Login on ISPConfig3 problem

Discussion in 'Installation/Configuration' started by Kyeto, May 16, 2011.

  1. Kyeto

    Kyeto New Member

    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
     
  2. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    Please check that the harddisk is not full with:

    df -h

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

    Kyeto New Member

    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 !
     
  4. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Please check if MySQL is running:
    Code:
    netstat -tap
     
  5. Kyeto

    Kyeto New Member

    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
     
  6. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    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.
     
  7. Kyeto

    Kyeto New Member

    I have try it, but it's the same problem :(
     
  8. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Does the ISPConfig database exist?

    Did you change the MySQL root password?
     
  9. Kyeto

    Kyeto New Member

    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)
    
    
     
  10. Kyeto

    Kyeto New Member

    No idea ?

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

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    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.
     
  12. Kyeto

    Kyeto New Member

    I have just do it but no success.

    Where is the log of ispconfig system ?
     
  13. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    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?
     
    Last edited: May 24, 2011
  14. Kyeto

    Kyeto New Member

    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.
     

Share This Page