[freeside] installation problems

[rbragg at rickbragg.net]

Thanks, the permissions were it.

I am using the following software:

Freeside version: 1.4.1
Apache-ASP-2.53
Perl 5.6.1 (no threads)
OS Redhat 7.3
mysql-3.2.3
DBD-mysql-2.9002
Apache-DBI-0.91

All the modules seem to be working correctly and as expected.

For some reason that I can't see, I am having issues connecting to the 
database only when adding a new user.  I was able to add services, 
packages, etc... Here is what I got in my error log when I tried to add 
a user.  I don't think that I should need to edit any of the cgi files 
for this.  Any suggestions?

error log:
-----
[Sat Aug 16 01:51:18 2003] null: DBD::mysql::st execute failed: You have 
an error in your SQL syntax near 'SELECT COUNT(*) FROM type_pkgs 
       WHERE typenum = 1             AND ty' at line 1 at 
/usr/lib/perl5/site_perl/5.6.1//FS/Record.pm line 282.
[Sat Aug 16 01:51:18 2003] [error] [asp] [8490] [error] Error executing 
"SELECT * FROM part_pkg WHERE ( disabled IS NULL OR disabled = "" )  AND 
0 < ( SELECT COUNT(*) FROM type_pkgs              WHERE typenum = 1 
         AND type_pkgs.pkgpart = part_pkg.pkgpart )": You have an error 
in your SQL syntax near 'SELECT COUNT(*) FROM type_pkgs 
WHERE typenum = 1             AND ty' at line 1 at 
/var/www/freeside.gmnet.net/htdocs/freeside-asp/view/cust_main.cgi line 
296 <--> , /usr/lib/perl5/site_perl/5.6.1/Apache/ASP.pm line 1488

---

Thanks again
Rick




fox at vader.aacc.edu wrote:
> On Fri, 15 Aug 2003, rbragg at rickbragg.net wrote:
> 
> 
>>any suggestions?
> 
> 
> Yes, 3.
> 
> 1- Check file and directory permissions, quota (if active), etc: chance is
> the user your httpd is running as can't create files in directory
> /usr/local/etc/freeside/asp-global//.state.
> 
> 2- If trying 1 fixed the problem, you may optionally come back and explain 
> sheepishly why you didn't check that before posting. :-)
> 
> 3- I'll let Ivan handle that one, I think he secretly enjoys reminding 
> posters about the problem reporting guidelines. :-)
> 
> 
>>[Fri Aug 15 18:21:15 2003] [error] [asp] [6489] [error] can't create 
>>group dir /usr/local/etc/freeside/asp-global//.state/server: Permission 
>>denied, /usr/lib/
>>perl5/site_perl/5.6.1/Apache/ASP/State.pm line 160
>>[Fri Aug 15 18:21:15 2003] [error] can't open file 
>>/usr/local/etc/freeside/asp-global//.state/server/internal.lock: 
>>Permission denied at /usr/lib/perl5/site_p
>>erl/5.6.1/MLDBM/Sync.pm line 239.
> 
>