<HTML><HEAD>
<STYLE id=eMClientCss>blockquote.cite { margin-left: 5px; margin-right: 0px; padding-left: 10px; padding-right:0px; border-left: 1px solid #cccccc }
blockquote.cite2 {margin-left: 5px; margin-right: 0px; padding-left: 10px; padding-right:0px; border-left: 1px solid #cccccc; margin-top: 3px; padding-top: 0px; }
.plain pre, .plain tt { font-family: monospace; font-size: 100%; font-weight: normal; font-style: normal;}
a img { border: 0px; }body {font-family: Verdana;font-size: 10pt;}
.plain pre, .plain tt {font-family: Verdana;font-size: 10pt;}
</STYLE>
<STYLE></STYLE>
</HEAD>
<BODY scroll=auto class>
<DIV>Sorry I have not done the install using mysql as a database before</DIV>
<DIV> </DIV>
<DIV id=signature_old>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN style='mso-fareast-font-family: "Times New Roman"'>Kind Regards …<?xml:namespace prefix = "o" /><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style='mso-fareast-font-family: "Times New Roman"'><o:p> </o:p></SPAN><SPAN style='mso-fareast-font-family: "Times New Roman"'>Obinna Chukwujekwu<BR>Head, IT Services Delivery <BR><?xml:namespace prefix = "u1" /><u1:p></u1:p>+234 16280050<B><SPAN style="COLOR: #330033"><o:p></o:p></SPAN></B></SPAN></P>
<P class=MsoNormal><o:p> </o:p></P></DIV></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>------ Original Message ------</DIV>
<DIV>From: "Madalitso Mzandu" <<A href="mailto:amzandu@gmail.com">amzandu@gmail.com</A>></DIV>
<DIV>To: "Freeside users mailing list" <<A href="mailto:freeside-users@freeside.biz">freeside-users@freeside.biz</A>></DIV>
<DIV>Sent: 13-Apr-16 15:56:57</DIV>
<DIV>Subject: Re: [freeside-users] FS-4.0 CENTOS 6.7</DIV>
<DIV> </DIV>
<DIV id=x01606fbc91094f3c9e983b32ec728c56>
<BLOCKQUOTE class=cite2 cite=CAEaYdoMSvs2k+3Vs=6-MWvBSX7pupurbv7VMhsg+-Z2-721abw@mail.gmail.com type="cite">
<DIV dir=ltr>
<DIV>
<DIV>
<DIV>
<DIV>Thanks Obinna, I had already done these steps<BR><BR></DIV>1. make install-apache to replace the apache snippet with exactly like attachement<BR></DIV>2. deleted the .htaccess in the docs folder to make sure basic authentication is not used<BR></DIV>3. created a non-htpasswd admin with password<BR><BR></DIV>
<DIV>I still get bad cookie on upgraded install. And new install has empty access tables with error:<BR><BR>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.<BR>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.<BR><BR></DIV>
<DIV>Regards,<BR></DIV><BR><BR></DIV>
<DIV class=gmail_extra><BR>
<DIV class=gmail_quote>On Wed, Apr 13, 2016 at 12:41 PM, Obinna Chukwujekwu <SPAN dir=ltr><<A href="mailto:ochukwujekwu@ipnxnigeria.net">ochukwujekwu@ipnxnigeria.net</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex">
<DIV>
<DIV>For the upgrade from 3.9 try using the attached to replace your freeside-base2.conf under /etc/httpd/conf.d/</DIV>
<DIV> </DIV>
<DIV>For the new install, when adding your account run the command as: <SPAN>freeside-adduser -g 1 username password; to create the account in the access_user table instead of the htpasswd file.</SPAN></DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Let me know if this works for you.</DIV>
<DIV> </DIV>
<DIV>
<DIV>
<P class=MsoNormal><SPAN></SPAN> </P>
<P class=MsoNormal><SPAN>Kind Regards …</SPAN></P><SPAN class=HOEnZb><FONT color=#888888>
<P class=MsoNormal><SPAN><U></U><U></U><U></U></SPAN> </P>
<P class=MsoNormal><SPAN><U></U> <U></U></SPAN><SPAN>Obinna Chukwujekwu<BR></SPAN></P></FONT></SPAN></DIV></DIV>
<DIV>
<DIV class=h5>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>------ Original Message ------</DIV>
<DIV>From: "Madalitso Mzandu" <<A href="mailto:amzandu@gmail.com">amzandu@gmail.com</A>></DIV>
<DIV>To: <A href="mailto:freeside-users@freeside.biz">freeside-users@freeside.biz</A></DIV>
<DIV>Sent: 13-Apr-16 11:31:56</DIV>
<DIV>Subject: [freeside-users] FS-4.0 CENTOS 6.7</DIV>
<DIV> </DIV>
<DIV>
<BLOCKQUOTE class=cite cite=http://CAEaYdoO1WdMw=O7wEmw9NzKsVSwmhx1FE2b8jnXYNmKQws6n+w@mail.gmail.com type="cite">
<DIV dir=ltr>
<DIV>Testing 4.0 on CentOS 6.7. If anyone has managed to get it working please help.<BR><BR>New Install has empty access_group,access_rights and access_usergroup. Upgrade from 3.9 gives "bad cookie" when I login with apache log:</DIV><BR>
<DIV> bad session 3t16KCwxrnFkJPnLcSR2F19Ypp/0XhtqR4M4w5tY from 10.1.8.2<BR>[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/<A href="http://access_user_log.pm/">access_user_log.pm</A> line 81.\n, referer: <A href="http://10.1.10.11/login">http://10.1.10.11/login</A><BR><BR></DIV>
<DIV>Regards,<BR></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV></DIV></BLOCKQUOTE></DIV></DIV></DIV></DIV><BR>_______________________________________________<BR>freeside-users mailing list<BR><A href="mailto:freeside-users@freeside.biz">freeside-users@freeside.biz</A><BR><A href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users" rel=noreferrer>http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV></BLOCKQUOTE></DIV></BODY></HTML>