[freeside-users] FS-4.0 CENTOS 6.7

[Madalitso Mzandu]

Thanks Obinna, I had already done these steps

1. make install-apache to replace the apache snippet with exactly like
attachement
2. deleted the .htaccess in the docs folder to make sure basic
authentication is not used
3. created a non-htpasswd admin with password

I still get bad cookie on upgraded install. And new install has empty
access tables with error:

DBD::mysql::st execute failed: Cannot add or update a child row: a foreign
key constraint fails (`freeside`.`access_usergroup`, CONSTRAINT
`access_usergroup_ibfk_2` FOREIGN KEY (`groupnum`) REFERENCES
`access_group` (`groupnum`)) [for Statement "INSERT INTO access_usergroup (
usernum, groupnum) VALUES ('6', '1')"] at
/usr/local/share/perl5/FS/Record.pm line 1375.
Cannot add or update a child row: a foreign key constraint fails
(`freeside`.`access_usergroup`, CONSTRAINT `access_usergroup_ibfk_2`
FOREIGN KEY (`groupnum`) REFERENCES `access_group` (`groupnum`)) at
/usr/local/bin/freeside-adduser line 39.

Regards,



On Wed, Apr 13, 2016 at 12:41 PM, Obinna Chukwujekwu <
ochukwujekwu at ipnxnigeria.net> wrote:

> For the upgrade from 3.9 try using the attached to replace your
> freeside-base2.conf under /etc/httpd/conf.d/
>
> For the new install, when adding your account run the command as: freeside-adduser
> -g 1 username password; to create the account in the access_user table
> instead of the htpasswd file.
>
> Freeside versions prior to 4.0 authenticate users via the htpasswd file
> under /usr/local/etc/freeside/ while 4.0 authenticates users via the
> access_user table in the freeside database.
>
> Let me know if this works for you.
>
>
>
>
> Kind Regards …
>
>
>
>  Obinna Chukwujekwu
>
>
>
> ------ Original Message ------
> From: "Madalitso Mzandu" <amzandu at gmail.com>
> To: freeside-users at freeside.biz
> Sent: 13-Apr-16 11:31:56
> Subject: [freeside-users] FS-4.0 CENTOS 6.7
>
>
> Testing 4.0 on CentOS 6.7. If anyone has managed to get it working please
> help.
>
> New Install has empty access_group,access_rights and access_usergroup.
> Upgrade from 3.9 gives "bad cookie" when I login with apache log:
>
>  bad session 3t16KCwxrnFkJPnLcSR2F19Ypp/0XhtqR4M4w5tY from 10.1.8.2
> [Wed Apr 13 07:12:45 2016] [error] [client 10.1.8.2] Can't call method
> "usernum" without a package or object reference at
> /usr/local/share/perl5/FS/access_user_log.pm line 81.\n, referer:
> http://10.1.10.11/login
>
> Regards,
>
>
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://freeside.biz/pipermail/freeside-users/attachments/20160413/94564720/attachment-0001.html>