[freeside-users] FS-4.0 CENTOS 6.7

[Madalitso Mzandu]

This is working without problems with pg so I guess I will just drop mysql
for now.

Thanks

On Fri, Apr 15, 2016 at 7:51 AM, Madalitso Mzandu <amzandu at gmail.com> wrote:

> 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/20160417/ecc8bfcd/attachment.html>