[freeside-users] FS-4.0 CENTOS 6.7

[Madalitso Mzandu]

I am still struggling with FS 4.0 on centos 6.7 with mysql and apache 2.2.
I have given up on new install and I am working with upgrade.

It appears my problems are revolving around CurrentUser.pm. All sessions
are returned bad and won't return usernum to AuthCookieHandler.

bad session c6BOYGIYbjRmpXri1TV6aIb3MS6qX2FNYkJPWrtx from 10.1.8.2
[Fri Apr 15 04:49:16 2016] [error] [client 10.1.8.2] Can't call method
"usernum" without a package or object reference at
/usr/local/share/perl5/FS/Record.pm line 2329.\n, referer:
http://10.1.10.11/freeside/

Regards,

On Wed, Apr 13, 2016 at 6:32 PM, Madalitso Mzandu <amzandu at gmail.com> wrote:

> Thanks for jumping in maybe I should try it with postgres. Will let you
> know.
>
> Regards,
>
> On Wed, Apr 13, 2016 at 5:40 PM, Obinna Chukwujekwu <
> ochukwujekwu at ipnxnigeria.net> wrote:
>
>> 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
>>>
>>>
>>
>> _______________________________________________
>> 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/20160415/45b266d9/attachment.html>