[freeside-users] FS-4.0 CENTOS 6.7

[Madalitso Mzandu]

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/20160413/32c32220/attachment.html>