From: Peter M. <pe...@ma...> - 2007-12-17 10:22:38
|
I'm moving my TikiWiki v1.9.8.2 from one server to another. Software wise, the servers are almost identical, both running Apache2, MySQL5 and PHP5. I have an issue with moving the database. Server A is working correctly. To move the site, I tar it up and copy it. I then copy the database. I've tried mysqldump, mysqlhotcopy, and manually stopping the database and copying the files. After restoring, Server B appears to work correctly, but will not allow users to login. It recognises a bad password but not a good one - when you enter good credentials the screen refreshes but you are still not logged in. My php.ini memory_limit is set at 32MB. Both servers are OpenVZ but I'm not hitting any limits on the virtual machine. My users_users table is identical in both databases. A diff of two dumps shows many differences, most of it binary. I've removed as much binary as I can from the database but it's still 140MB or so. I have MySQL and PHP logging on, but can find nothing to do with authentication in these logs. I'd appreciate any ideas on how to troubleshoot this. regards, Peter. |
From: Marc L. <mar...@gm...> - 2007-12-17 10:28:44
|
How about trying a clean install of Tiki on server B to see if the logins are OK? M ;-) Peter Machell wrote: > I'm moving my TikiWiki v1.9.8.2 from one server to another. > > Software wise, the servers are almost identical, both running Apache2, > MySQL5 and PHP5. > > I have an issue with moving the database. Server A is working > correctly. To move the site, I tar it up and copy it. I then copy the > database. I've tried mysqldump, mysqlhotcopy, and manually stopping > the database and copying the files. > > After restoring, Server B appears to work correctly, but will not > allow users to login. It recognises a bad password but not a good one > - when you enter good credentials the screen refreshes but you are > still not logged in. > > My php.ini memory_limit is set at 32MB. Both servers are OpenVZ but > I'm not hitting any limits on the virtual machine. > > My users_users table is identical in both databases. > > A diff of two dumps shows many differences, most of it binary. I've > removed as much binary as I can from the database but it's still 140MB > or so. > > I have MySQL and PHP logging on, but can find nothing to do with > authentication in these logs. > > I'd appreciate any ideas on how to troubleshoot this. > > regards, > Peter. > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services > for just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > _______________________________________________ > Tikiwiki-users mailing list > Tik...@li... > https://lists.sourceforge.net/lists/listinfo/tikiwiki-users > |
From: Peter M. <pe...@ma...> - 2007-12-17 10:41:11
|
On 17/12/2007, at 8:24 PM, Marc Laporte wrote: > How about trying a clean install of Tiki on server B to see if the > logins are OK? Thanks for that Marc, but the clean install works as expected. Peter. |
From: Sylvie G. <sgr...@gm...> - 2007-12-17 11:00:39
|
And if you load your database in this clean install? )perhaps you will have a run the upgrade script 1.8 to 1.19) On Mon, 2007-12-17 at 20:40 +1000, Peter Machell wrote: > On 17/12/2007, at 8:24 PM, Marc Laporte wrote: > > > How about trying a clean install of Tiki on server B to see if the > > logins are OK? > > Thanks for that Marc, but the clean install works as expected. > > Peter. > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services > for just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > _______________________________________________ > Tikiwiki-users mailing list > Tik...@li... > https://lists.sourceforge.net/lists/listinfo/tikiwiki-users |
From: Nicola M. <nic...@po...> - 2007-12-17 11:20:25
|
Peter Machell ha scritto: > On 17/12/2007, at 9:00 PM, Sylvie Greverend wrote: > >> And if you load your database in this clean install? >> )perhaps you will have a run the upgrade script 1.8 to 1.19) > > It fails in the same manner. > > Interestingly, I was able to login to the install script with the > admin password, but the upgrade failed (already upgraded). > > thanks, > Peter. this is EXACTLY the same problem i have! i'm not the only one, so.... Nicola |
From: Peter M. <pe...@ma...> - 2007-12-17 11:26:31
|
On 17/12/2007, at 9:20 PM, Nicola Mondinelli wrote: > this is EXACTLY the same problem i have! > i'm not the only one, so.... Interesting. Could it be that we are missing a dependancy? In my case, I'm trying to get all servers separated into different VMs, so this new server has only the basics, but includes a working Apache2, PHP5 and MySQL5. It didn't even have mail but I have now added Postfix. The installation documentation doesn't mention any other dependancies, but perhaps something is missing? Peter. |
From: Marc L. <mar...@gm...> - 2007-12-17 11:55:20
|
Hi! Sorry you are having issues. Please try emptying the database table: "tiki_sessions" (not deleting, just emptying) Also, delete all *.tpl.php in templates_c directory. Best regards, M ;-) Peter Machell wrote: > On 17/12/2007, at 8:24 PM, Marc Laporte wrote: > > >> How about trying a clean install of Tiki on server B to see if the >> logins are OK? >> > > Thanks for that Marc, but the clean install works as expected. > > Peter. > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services > for just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > _______________________________________________ > Tikiwiki-users mailing list > Tik...@li... > https://lists.sourceforge.net/lists/listinfo/tikiwiki-users > |
From: Peter M. <pe...@ma...> - 2007-12-17 11:09:06
|
On 17/12/2007, at 9:00 PM, Sylvie Greverend wrote: > And if you load your database in this clean install? > )perhaps you will have a run the upgrade script 1.8 to 1.19) It fails in the same manner. Interestingly, I was able to login to the install script with the admin password, but the upgrade failed (already upgraded). thanks, Peter. |
From: Sylvie G. <sgr...@gm...> - 2007-12-17 11:23:06
|
It is normal that the upgrade create error messages So the admin user is able to log-in tiki-install.php but not in tiki? the only reason I see is a strange value in feature_crypt_passwords in the tiki_preferences table. What do you have crypt-md5, crypt-des, tikihash? But as it tries each crypt method - I have some doubt. Did you try to change the admin password - there is a script there change_password.php http://tikiwiki.org/userpagesylvie#attachments that allorws to change password while respecting the crypt method strange... On Mon, 2007-12-17 at 21:08 +1000, Peter Machell wrote: > On 17/12/2007, at 9:00 PM, Sylvie Greverend wrote: > > > And if you load your database in this clean install? > > )perhaps you will have a run the upgrade script 1.8 to 1.19) > > It fails in the same manner. > > Interestingly, I was able to login to the install script with the > admin password, but the upgrade failed (already upgraded). > > thanks, > Peter. |
From: Peter M. <pe...@ma...> - 2007-12-17 12:33:59
|
On 17/12/2007, at 8:22 PM, Peter Machell wrote: > I'm moving my TikiWiki v1.9.8.2 from one server to another. > > Software wise, the servers are almost identical, both running Apache2, > MySQL5 and PHP5. Correction. ServerA was running PHP4 - no problem. ServerB was running PHP5 = login problems. I've cloned ServerA and have the new one running. Is there any changes to be made to allow TikiWiki to run properly on PHP5? regards, Peter. |
From: Mike K. \(kerrnel22\) <tik...@ke...> - 2007-12-17 13:40:49
|
Yes, I believe PHP5 requires you use mysqli instead of mysql. I remember reading something about that somewhere and I'm not sure if it related to anything to do with Tiki or if it was something you had to compile differently with PHP5. Trying not to confuse things, but I do know there is a difference between php4 and php5 in the way you access mysql. I've only ever used mysql4 so never come across this issue. Mike. -----Original Message----- From: tik...@li... [mailto:tik...@li...] On Behalf Of Peter Machell Sent: Monday, December 17, 2007 7:34 AM To: Tiki users mailing list Subject: Re: [Tikiwiki-users] Migration Blues On 17/12/2007, at 8:22 PM, Peter Machell wrote: > I'm moving my TikiWiki v1.9.8.2 from one server to another. > > Software wise, the servers are almost identical, both running Apache2, > MySQL5 and PHP5. Correction. ServerA was running PHP4 - no problem. ServerB was running PHP5 = login problems. I've cloned ServerA and have the new one running. Is there any changes to be made to allow TikiWiki to run properly on PHP5? regards, Peter. ------------------------------------------------------------------------ - SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketp lace _______________________________________________ Tikiwiki-users mailing list Tik...@li... https://lists.sourceforge.net/lists/listinfo/tikiwiki-users |
From: Sylvie G. <sgr...@gm...> - 2007-12-17 13:55:50
|
FYI I am using php5 and mysql with no problem On Mon, 2007-12-17 at 08:40 -0500, Mike Kerr (kerrnel22) wrote: > Yes, I believe PHP5 requires you use mysqli instead of mysql. I > remember reading something about that somewhere and I'm not sure if it > related to anything to do with Tiki or if it was something you had to > compile differently with PHP5. > > Trying not to confuse things, but I do know there is a difference > between php4 and php5 in the way you access mysql. I've only ever used > mysql4 so never come across this issue. > > Mike. > > -----Original Message----- > From: tik...@li... > [mailto:tik...@li...] On Behalf Of Peter > Machell > Sent: Monday, December 17, 2007 7:34 AM > To: Tiki users mailing list > Subject: Re: [Tikiwiki-users] Migration Blues > > On 17/12/2007, at 8:22 PM, Peter Machell wrote: > > > I'm moving my TikiWiki v1.9.8.2 from one server to another. > > > > Software wise, the servers are almost identical, both running Apache2, > > MySQL5 and PHP5. > > Correction. ServerA was running PHP4 - no problem. ServerB was running > PHP5 = login problems. > > I've cloned ServerA and have the new one running. Is there any changes > to be made to allow TikiWiki to run properly on PHP5? > > regards, > Peter. > > ------------------------------------------------------------------------ > - > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services > for just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketp > lace > _______________________________________________ > Tikiwiki-users mailing list > Tik...@li... > https://lists.sourceforge.net/lists/listinfo/tikiwiki-users > > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services > for just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > _______________________________________________ > Tikiwiki-users mailing list > Tik...@li... > https://lists.sourceforge.net/lists/listinfo/tikiwiki-users |
From: Mike K. <tik...@ke...> - 2007-12-17 16:03:57
|
When I say mysql vs. mysqli I think that's something specific to the =20 way PHP5 works with MySQL. Different library set or something. =20 Anyway, worth reading up on if you're Pete. Mike. Quoting Sylvie Greverend <sgr...@gm...>: > FYI I am using php5 and mysql with no problem > > On Mon, 2007-12-17 at 08:40 -0500, Mike Kerr (kerrnel22) wrote: >> Yes, I believe PHP5 requires you use mysqli instead of mysql. I >> remember reading something about that somewhere and I'm not sure if it >> related to anything to do with Tiki or if it was something you had to >> compile differently with PHP5. >> >> Trying not to confuse things, but I do know there is a difference >> between php4 and php5 in the way you access mysql. I've only ever used >> mysql4 so never come across this issue. >> >> Mike. >> >> -----Original Message----- >> From: tik...@li... >> [mailto:tik...@li...] On Behalf Of Peter >> Machell >> Sent: Monday, December 17, 2007 7:34 AM >> To: Tiki users mailing list >> Subject: Re: [Tikiwiki-users] Migration Blues >> >> On 17/12/2007, at 8:22 PM, Peter Machell wrote: >> >> > I'm moving my TikiWiki v1.9.8.2 from one server to another. >> > >> > Software wise, the servers are almost identical, both running Apache2, >> > MySQL5 and PHP5. >> >> Correction. ServerA was running PHP4 - no problem. ServerB was running >> PHP5 =3D login problems. >> >> I've cloned ServerA and have the new one running. Is there any changes >> to be made to allow TikiWiki to run properly on PHP5? >> >> regards, >> Peter. >> >> ------------------------------------------------------------------------ >> - >> SF.Net email is sponsored by: >> Check out the new SourceForge.net Marketplace. >> It's the best place to buy or sell services >> for just about anything Open Source. >> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketp >> lace >> _______________________________________________ >> Tikiwiki-users mailing list >> Tik...@li... >> https://lists.sourceforge.net/lists/listinfo/tikiwiki-users >> >> >> ------------------------------------------------------------------------- >> SF.Net email is sponsored by: >> Check out the new SourceForge.net Marketplace. >> It's the best place to buy or sell services >> for just about anything Open Source. >> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketpl= ace >> _______________________________________________ >> Tikiwiki-users mailing list >> Tik...@li... >> https://lists.sourceforge.net/lists/listinfo/tikiwiki-users > > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services > for just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketpla= ce > _______________________________________________ > Tikiwiki-users mailing list > Tik...@li... > https://lists.sourceforge.net/lists/listinfo/tikiwiki-users > |