#1  
Old 27th April 2012, 14:33
diablo666 diablo666 is offline
Member
 
Join Date: Mar 2007
Posts: 95
Thanks: 15
Thanked 2 Times in 2 Posts
Default Problem after upgrade to 3.

Hi there, i've upgrade ispconfig from version 3.0.4.3 to 3.0.4.4

My configuration is based in on debian etch 6.0, and it's configured with two nodes in cluster. Before the upgrade all works fine, but now i can't login to panel.

In the syslog i saw the following error

mysqld: 120427 13:28:17 [Warning] Statement may not be safe to log in statement format. Statement: UPDATE `attempts_login` SET `times`=`times`+1, `login_time`=NOW() WHERE `login_time` >= '1335526097' LIMIT 1

Any idea?
Reply With Quote
Sponsored Links
  #2  
Old 27th April 2012, 15:13
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,791
Thanks: 840
Thanked 5,612 Times in 4,423 Posts
Default

I've no idea, the scripts involved in the login process have not been altered between these two versions.

Are you sure that you installed the 3.0.4.4 stable version and not e.g. ispconfig svn version? And are the mysql login details in the file /usr/local/ispconfig/interface/lib/config.inc.php correct?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 27th April 2012, 15:46
diablo666 diablo666 is offline
Member
 
Join Date: Mar 2007
Posts: 95
Thanks: 15
Thanked 2 Times in 2 Posts
Default

Yes, i've upgraded to stable version.

i'm now looking on confing backup files to control the parameter you suggested.
Reply With Quote
  #4  
Old 27th April 2012, 15:59
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,791
Thanks: 840
Thanked 5,612 Times in 4,423 Posts
Default

You can test the mysql login details with the mysql command. Example:

mysql -h localhost -u ispconfig -p dbispconfig

the command should ask for the password then which can be found in the config.inc.php file.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
diablo666 (27th April 2012)
  #5  
Old 27th April 2012, 16:01
diablo666 diablo666 is offline
Member
 
Join Date: Mar 2007
Posts: 95
Thanks: 15
Thanked 2 Times in 2 Posts
Default

Oh maybe i've found the mistake

Quote:
... and execute this command:

Code:
scp -p /usr/local/ispconfig/interface/lib/config.inc.php root@192.168.0.106:/usr/local/ispconfig/interface/lib/config.inc.php
This command has to be excuted after each ISPConfig update again after you updated ISPConfig on the master and on the slave with the normal ISPConfig update command (ispconfig_update.sh).
Reply With Quote
  #6  
Old 27th April 2012, 16:08
diablo666 diablo666 is offline
Member
 
Join Date: Mar 2007
Posts: 95
Thanks: 15
Thanked 2 Times in 2 Posts
Default

Quote:
Originally Posted by till View Post
You can test the mysql login details with the mysql command. Example:

mysql -h localhost -u ispconfig -p dbispconfig

the command should ask for the password then which can be found in the config.inc.php file.
Credentials are fine, they work perfectly.
Reply With Quote
  #7  
Old 27th April 2012, 16:15
diablo666 diablo666 is offline
Member
 
Join Date: Mar 2007
Posts: 95
Thanks: 15
Thanked 2 Times in 2 Posts
 
Default [Solved]

Ok solved.

The problema was as i said before that you got to copy config.inc.php from master to slave.

scp -p /usr/local/ispconfig/interface/lib/config.inc.php root@192.168.0.106:/usr/local/ispcon...config.inc.php

After that all worked fine.

Tnx Till for support!
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mail.err warnings and some mail unable to receive HellMind General 4 8th October 2010 20:57
sending e-mail using mail() function linuxuser1 HOWTO-Related Questions 38 21st April 2009 13:20
Virtual users... Ubuntu 8.04 spaceuser HOWTO-Related Questions 12 19th June 2008 09:04
problem after upgrade from 2.2.8 to 2.2.9 smartcall Installation/Configuration 15 23rd January 2007 10:48
Big unespected problem in upgrade!!! donaldblake Installation/Configuration 6 6th December 2005 23:31


All times are GMT +2. The time now is 10:50.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.