Strange message at login to the management console

Discussion in 'General' started by galius, Oct 29, 2013.

  1. galius

    galius New Member

    This morning when I went to log in as administrator, here is what I saw at the top of the login window:

    Code:
    #0 db->query(SELECT config FROM sys_ini WHERE sysini_id = 1) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:172] #1 db->queryOneRecord(SELECT config FROM sys_ini WHERE sysini_id = 1) called at [/usr/local/ispconfig/interface/lib/classes/getconf.inc.php:52] #2 getconf->get_global_config(misc) called at [/usr/local/ispconfig/interface/web/index.php:42] 
    I get connected without problem. But the server is very slow.

    Any idea?

    Thank you
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    It might be that the mysql database is damaged. Please check and repair the dbispconfig mysql database with phpmyadmin or the mysql console.
     
  3. galius

    galius New Member

    Thank you Till,

    Check dbispconfig database by phpmyadmin: ok, no problem whit database

    Now, in my : https://myispconfighere:8080/ I see only the login.

    When I put the login and password also, he says there is nothing.

    Code:
    ERROR
     Error 
    Username or Password empty.

    PS:

    I just see that "check", "repair" and "optimize" the tables fixed the problem. My connection problem came from a "time out" too much of a high system load (I do not know where it comes from now)

    Thank you
    :confused:
     
    Last edited: Oct 29, 2013
  4. stef157

    stef157 Member

    Do you have upgrade php with php5 ?
    Cause that cause the same issue for me…

    The problem is that in CLI, you have php and php5 but php5 should be the default one… so all the module for php are moved…
    And php5 will work but all the script use php and not php5…
     
  5. galius

    galius New Member

    Hello,

    I just did a normal update of my debian 7 ... and all available updates ...

    And after I update too my ISPConfig3 (download the latest version) and php update.php in my ispconfiginstall...

    updating is not accomplished because Ispconfig3 does not recognize the version of my system ...

    I search for solutions ...
     
  6. stef157

    stef157 Member

    have you tried php5 -q update.php ?

    If it's working… then it's because you have php5 and / or php…

    So, you've to delete php5 and install php
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    Please post the exact error message that you got from ispconfig update script.
     
  8. galius

    galius New Member

    My Debian:

    Code:
    Linux neo.alosys.fr 3.2.0-4-amd64 #1 SMP Debian 3.2.51-1 x86_64
    Debian GNU/Linux 7 \n \l

    I go to:

    Code:
    ~/ispconfig3_install/install 
    and:

    Code:
    php update.php 
    I see this:

    Code:
    >> Update  
    
    Operating System: Debian or compatible, unknown version.
    
    This application will update ISPConfig 3 on your server.
    
    Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]:
    I reply "yes"

    I see:
    Code:
    Creating backup of "/usr/local/ispconfig" directory...
    I reply yesCreating backup of "/etc" directory...
    Checking ISPConfig database .. OK
    Starting incremental database update.
    Reconfigure Permissions in master database? (yes,no) [no]: no
    Reconfigure Permissions in master database? (yes,no) [no]: no
    
    Reconfigure Services? (yes,no) [yes]: yes
    
    Configuring Postfix
    Configuring Mailman
    Configuring Jailkit
    Configuring Dovecot
    Configuring Spamassassin
    Configuring Amavisd
    Configuring Getmail
    Configuring Pureftpd
    Configuring BIND
    Configuring Apache
    Configuring vlogger
    Configuring Apps vhost
    Configuring Database
    Configuring Bastille Firewall
    Updating ISPConfig
    ISPConfig Port [8080]: 8080
    
    Create new ISPConfig SSL certificate (yes,no) [no]: no
    
     
    Reconfigure Crontab? (yes,no) [yes]: 
    Updating Crontab
    
    Restarting services ...
    Stopping MySQL database server: mysqld.
    Starting MySQL database server: mysqld . . . . . . ..
    Checking for tables which need an upgrade, are corrupt or were 
    not closed cleanly..
    Stopping Postfix Mail Transport Agent: postfix.
    Starting Postfix Mail Transport Agent: postfix.
    Stopping amavisd: amavisd-new.
    Starting amavisd: amavisd-new.
    Stopping ClamAV daemon: clamd Waiting .  . .
     Starting ClamAV daemon: clamd .
    Restarting IMAP/POP3 mail server: dovecot.
    [Wed Oct 30 17:17:07 2013] [warn] NameVirtualHost *:443 has no VirtualHosts
    [Wed Oct 30 17:17:07 2013] [warn] NameVirtualHost *:80 has no VirtualHosts
    [Wed Oct 30 17:17:18 2013] [warn] NameVirtualHost *:443 has no VirtualHosts
    [Wed Oct 30 17:17:18 2013] [warn] NameVirtualHost *:80 has no VirtualHosts
    Restarting web server: apache2 ... waiting .........
    Restarting ftp server: Running: /usr/sbin/pure-ftpd-mysql-virtualchroot -l mysql:/etc/pure-ftpd/db/mysql.conf -l pam -O clf:/var/log/pure-ftpd/transfer.log -b -E -8 UTF-8 -H -Y 1 -A -u 1000 -D -B
    Update finished.
    
    In my panel (Monitor), I see this:
    Code:
    info:
    Your Server in under heavy load [More...]
    and in Server Load:

    Code:
    Data from: 2013-10-30 17:10
    Server online since: 	0 days, 4:22 hours
    Users Online: 	0
    System load 1 minute: 	20.21
    System load 5 minutes: 	23.61
    System load 15 minutes: 	31.42
    Any idea?
     

Share This Page