[freeside] installation problems

[Kristian Hoffmann]

Check the 1.4.1 release notes a couple of posts back.  You'll need mysql
4.1.0 if you want to use mysql with freeside 1.4.1.  Personally, I'd
switch to postgres, but that's your call.

Kristian Hoffmann
PC-InTOUCH/FireToWire System Administrator
khoff at pc-intouch.com
---

On Sat, 16 Aug 2003, rbragg at rickbragg.net wrote:

> 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.
> >
> >
>
>
>