[freeside-users] FS-4.0 CENTOS 6.7

[Obinna Chukwujekwu]

Sorry I have not done the install using mysql as a database before

Kind Regards …

  Obinna Chukwujekwu
Head, IT Services Delivery
+234 16280050






------ Original Message ------
From: "Madalitso Mzandu" <amzandu at gmail.com>
To: "Freeside users mailing list" <freeside-users at freeside.biz>
Sent: 13-Apr-16 15:56:57
Subject: Re: [freeside-users] FS-4.0 CENTOS 6.7

>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/90dccc54/attachment.html>