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
Please check that the harddisk is not full with: df -h Have you changed anything in the server configuration before the problem started?
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 !
Code: 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
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.
I haven't change the root mysql password. Code: ~# 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)
Thats not a good idea as it would remove all config data and cler your system. Please use the mysql repair and check functions for database tables (e.g. with phpmyadmin) to check the ispconfig mysql database if a table is corrupted.
The log is /var/log/ispconfig/. But thats a sytem log, login problems are not logged there. Login errors are printed on the screen if any errors occurred. So you will not find any info about your problem there. Your problem is most likely related to issues with php sessions. Have you installed nay session, cookie or ad blockers in your browser?
I have just activate debug mode and in the /var/log/ispconfig/ispconfig.log : Code: 24.05.2011-14:48 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock 24.05.2011-14:48 - WARNING - Unable to connect to local server. 24.05.2011-14:48 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock It could be the problem but i don't understand very well this error.
