Login on ISPConfig3 problem

[Kyeto]

Hello,

I'm using ISPConfig 3 since 2010 on Lenny.
I have no problem with it.

But yesterday, i have a problem to log me with admin account or reseller account.
I come back to the login page without error.

If i try to log me with a false account, i have an error :
Username or Password wrong

I have try to reset the admin password but it's the same problem.

A reboot doesn't work ... An update of ISPConfig3 doesn't work.

I really don't know what can i do.

Thanks for your help

[till]

Please check that the harddisk is not full with:

df -h

Have you changed anything in the server configuration before the problem started?

[Kyeto]

Hi,

Thanks for your reply.

My harddisk is not full :
Sys. de fich. Tail. Occ. Disp. %Occ. Monté sur
/dev/sda1 96G 9,1G 82G 11% /
tmpfs 503M 0 503M 0% /lib/init/rw
udev 10M 592K 9,5M 6% /dev
tmpfs 503M 0 503M 0% /dev/shm

Nothing was changed on the server ... i don't understand what is happen !

[falko]

Please check if MySQL is running:

netstat -tap

[Kyeto]

tcp        0      0 localhost:10024         *:*                     LISTEN      8334/amavisd (maste
tcp        0      0 localhost:680           *:*                     LISTEN      3896/famd       
tcp        0      0 localhost:10025         *:*                     LISTEN      8281/master     
tcp        0      0 localhost:mysql         *:*                     LISTEN      18676/mysqld    
tcp        0      0 localhost:spamd         *:*                     LISTEN      3040/spamd.pid  
tcp        0      0 *:sunrpc                *:*                     LISTEN      2713/portmap    
tcp        0      0 myvm:domain *:*                     LISTEN      9108/mydns      
tcp        0      0 localhost:domain        *:*                     LISTEN      9108/mydns      
tcp        0      0 *:ftp                   *:*                     LISTEN      9102/pure-ftpd (SER
tcp        0      0 *:ssh                   *:*                     LISTEN      2873/sshd       
tcp        0      0 myvm:8025 *:*                     LISTEN      8281/master     
tcp        0      0 *:smtp                  *:*                     LISTEN      8281/master     
tcp        0      0 *:34588                 *:*                     LISTEN      2724/rpc.statd  
tcp        0      0 localhost:50164         localhost:mysql         TIME_WAIT   -               
tcp        0      0 localhost:50165         localhost:mysql         TIME_WAIT   -               
tcp        0      0 localhost:50166         localhost:mysql         TIME_WAIT   -               
tcp        0      0 localhost:50162         localhost:mysql         TIME_WAIT   -               
tcp        0      0 localhost:50161         localhost:mysql         TIME_WAIT   -               
tcp        0      0 localhost:mysql         localhost:39373         ESTABLISHED 18676/mysqld    
tcp        0      0 localhost:39373         localhost:mysql         ESTABLISHED 29868/amavisd (ch11
tcp        0      0 localhost:50172         localhost:mysql         TIME_WAIT   -               
tcp        0      0 localhost:50174         localhost:mysql         TIME_WAIT   -               
tcp        0      0 localhost:57532         localhost:mysql         ESTABLISHED 11549/amavisd (ch11
tcp        0      0 localhost:mysql         localhost:50170         TIME_WAIT   -               
tcp        0      0 localhost:50176         localhost:mysql         TIME_WAIT   -               
tcp        0      0 localhost:50171         localhost:mysql         TIME_WAIT   -               
tcp        0      0 myvm:smtp adsl-99-159-236-1:62638 ESTABLISHED 14155/smtpd     
tcp        0      0 localhost:50168         localhost:mysql         TIME_WAIT   -               
tcp        0      0 localhost:50163         localhost:mysql         TIME_WAIT   -               
tcp        0      0 localhost:50167         localhost:mysql         TIME_WAIT   -               
tcp        0      0 localhost:50169         localhost:mysql         TIME_WAIT   -               
tcp        0      0 localhost:50159         localhost:mysql         TIME_WAIT   -               
tcp        0      0 localhost:50160         localhost:mysql         TIME_WAIT   -               
tcp        0   3408 myvm:ssh 11-188-33-178.dsl:53453 ESTABLISHED 15336/0         
tcp        0      0 localhost:50175         localhost:mysql         TIME_WAIT   -               
tcp        0      0 localhost:50173         localhost:mysql         TIME_WAIT   -               
tcp        0      0 localhost:mysql         localhost:57532         ESTABLISHED 18676/mysqld    
tcp6       0      0 [::]:imaps              [::]:*                  LISTEN      9018/couriertcpd
tcp6       0      0 [::]:pop3s              [::]:*                  LISTEN      9047/couriertcpd
tcp6       0      0 [::]:pop3               [::]:*                  LISTEN      9029/couriertcpd
tcp6       0      0 [::]:imap2              [::]:*                  LISTEN      9001/couriertcpd
tcp6       0      0 [::]:http-alt           [::]:*                  LISTEN      9084/apache2    
tcp6       0      0 [::]:www                [::]:*                  LISTEN      9084/apache2    
tcp6       0      0 [::]:tproxy             [::]:*                  LISTEN      9084/apache2    
tcp6       0      0 localhost:domain        [::]:*                  LISTEN      9108/mydns      
tcp6       0      0 [::]:ftp                [::]:*                  LISTEN      9102/pure-ftpd (SER
tcp6       0      0 [::]:ssh                [::]:*                  LISTEN      2873/sshd       
tcp6       0      0 [::]:https              [::]:*                  LISTEN      9084/apache2

Mysql run and i can log with root password of mysql without problem

[falko]

Can you make MySQL listen on all interfaces for testing purposes? You must comment out the bind line in /etc/mysql/my.cnf and restart MySQL.

[Kyeto]

I have try it, but it's the same problem

[falko]

Does the ISPConfig database exist?

Did you change the MySQL root password?

[Kyeto]

I haven't change the root mysql password.

~# mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4571
Server version: 5.0.51a-24+lenny3 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use dbispconfig;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-----------------------+
| Tables_in_dbispconfig |
+-----------------------+
| attempts_login        | 
| client                | 
| client_template       | 
| country               | 
| cron                  | 
| dns_rr                | 
| dns_slave             | 
| dns_soa               | 
| dns_template          | 
| domain                | 
| firewall              | 
| ftp_user              | 
| mail_access           | 
| mail_content_filter   | 
| mail_domain           | 
| mail_forwarding       | 
| mail_get              | 
| mail_greylist         | 
| mail_mailman_domain   | 
| mail_relay_recipient  | 
| mail_traffic          | 
| mail_transport        | 
| mail_user             | 
| mail_user_filter      | 
| monitor_data          | 
| remote_session        | 
| remote_user           | 
| server                | 
| server_ip             | 
| shell_user            | 
| software_package      | 
| software_repo         | 
| software_update       | 
| software_update_inst  | 
| spamfilter_policy     | 
| spamfilter_users      | 
| spamfilter_wblist     | 
| support_message       | 
| sys_config            | 
| sys_datalog           | 
| sys_dbsync            | 
| sys_filesync          | 
| sys_group             | 
| sys_ini               | 
| sys_log               | 
| sys_remoteaction      | 
| sys_session           | 
| sys_user              | 
| web_database          | 
| web_domain            | 
| web_traffic           | 
| webdav_user           | 
+-----------------------+
52 rows in set (0.00 sec)

[Kyeto]

No idea ?

If i remove ispconfig and i setup again ispconfig, it could work ?