Databases don't work

Discussion in 'General' started by homo, Jun 7, 2009.

  1. homo

    homo New Member

    I have update my system from ispconfig 3.0.1.1 to 3.0.1.3 and i have noticed that i can't create or delete databases.
    I can create the database/user throw the web interface, the database is visible by the ispconfig 3 interface but the phpmyadmin can't see them because they don't exist! The databases that have been created manually are visible (i mean from phpmyadmin) and work.
    Before the update the database function was just fine.

    edit: system log seams ok

    Thx 4 your time
     
    Last edited: Jun 7, 2009
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Do not create databases manually, ispconfig is not able to intgrate them and if you try to create such a database again in ispconfig the system will stop with an error until you deleted the database.

    Just testde this and it works fine for me in ispconfig 3.0.1.3.

    Are you sure that you did not change the root password of your mysql database?
     
  3. homo

    homo New Member

    just for testing the db server

    Yes, i checked also the configuration file, the db root password is the same.
     
  4. homo

    homo New Member

    [​IMG]
    Now there are many processes
    and more of them are from ispconfig:

    ID Owner Started Command
    1 root 16:57 init [3]
    2 root 16:57 [migration/0]
    3 root 16:57 [ksoftirqd/0]
    4 root 16:57 [watchdog/0]
    5 root 16:57 [events/0]
    6 root 16:57 [khelper]
    7 root 16:57 [kthread]
    10 root 16:57 [kblockd/0]
    11 root 16:57 [kacpid]
    101 root 16:57 [cqueue/0]
    104 root 16:57 [khubd]
    106 root 16:57 [kseriod]
    164 root 16:57 [pdflush]
    165 root 16:57 [pdflush]
    166 root 16:57 [kswapd0]
    167 root 16:57 [aio/0]
    323 root 16:57 [kpsmoused]
    345 root 16:57 [ata/0]
    346 root 16:57 [ata_aux]
    349 root 16:57 [scsi_eh_0]
    350 root 16:57 [scsi_eh_1]
    353 root 16:57 [kstriped]
    362 root 16:57 [ksnapd]
    373 root 16:57 [kjournald]
    400 root 16:57 [kauditd]
    654 root 16:57 [kgameportd]
    1449 root 16:57 [kmpathd/0]
    1450 root 16:57 [kmpath_handlerd]
    1472 root 16:57 [kjournald]
    2256 root 16:57 [rpciod/0]
    434 root 16:57 /sbin/udevd -d
    2080 root 16:57 auditd
    2082 root 16:57 /sbin/audispd
    2115 root 16:57 syslogd -m 0
    2118 root 16:57 klogd -x
    2167 rpc 16:57 portmap
    2208 rpcuser 16:57 rpc.statd
    2215 root 16:57 /usr/sbin/courierlogger -pid=/var/spool/authdaemon/pid -start /usr/libexec/couri ...
    2216 root 16:57 /usr/libexec/courier-authlib/authdaemond
    2274 root 16:57 /usr/libexec/courier-authlib/authdaemond
    2275 root 16:57 /usr/libexec/courier-authlib/authdaemond
    2276 root 16:57 /usr/libexec/courier-authlib/authdaemond
    2277 root 16:57 /usr/libexec/courier-authlib/authdaemond
    2278 root 16:57 /usr/libexec/courier-authlib/authdaemond
    2264 root 16:57 rpc.idmapd
    2296 dbus 16:57 dbus-daemon --system
    2311 root 16:57 /usr/sbin/hcid
    2317 root 16:57 /usr/sbin/sdpd
    2337 root 16:57 [krfcommd]
    2385 root 16:57 pcscd
    2408 root 16:57 /usr/bin/hidd --server
    2430 root 16:57 automount
    2454 root 16:57 /usr/sbin/acpid
    2472 root 16:57 /usr/sbin/sshd
    2672 root 16:58 sshd: root@pts/0
    2719 root 16:58 -bash
    2487 root 16:57 cupsd
    2502 clamav 16:58 clamd
    2538 root 16:58 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/my ...
    2598 mysql 16:58 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-f ...
    2628 nobody 16:58 mydns -b
    2674 amavis 16:58 amavisd (master)
    2877 amavis 16:58 amavisd (ch3-avail)
    2878 amavis 16:58 amavisd (ch3-avail)
    2684 root 16:58 /usr/sbin/courierlogger -pid=/var/run/imapd.pid -start -name=imapd /usr/lib/cour ...
    2685 root 16:58 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=4 -n ...
    2691 root 16:58 /usr/sbin/courierlogger -pid=/var/run/imapd-ssl.pid -start -name=imapd-ssl /usr/ ...
    2692 root 16:58 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=4 -n ...
    2697 root 16:58 /usr/sbin/courierlogger -pid=/var/run/pop3d.pid -start -name=pop3d /usr/lib/cour ...
    2698 root 16:58 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=4 -n ...
    2703 root 16:58 /usr/sbin/courierlogger -pid=/var/run/pop3d-ssl.pid -start -name=pop3d-ssl /usr/ ...
    2704 root 16:58 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40 -maxperip=4 -n ...
    2793 root 16:58 /usr/libexec/postfix/master
    2804 postfix 16:58 pickup -l -t fifo -u
    2805 postfix 16:58 qmgr -l -t fifo -u
    3602 postfix 17:00 tlsmgr -l -t unix -u
    2810 root 16:58 gpm -m /dev/input/mice -t exps2
    2827 root 16:58 /usr/sbin/httpd
    2840 root 16:58 vlogger (access log)
    2841 apache 16:58 /usr/sbin/httpd
    2902 apache 16:58 /usr/sbin/httpd
    2903 apache 16:58 /usr/sbin/httpd
    2904 apache 16:58 /usr/sbin/httpd
    2905 apache 16:58 /usr/sbin/httpd
    2906 apache 16:58 /usr/sbin/httpd
    2910 apache 16:58 /usr/sbin/httpd
    2911 apache 16:58 /usr/sbin/httpd
    2912 apache 16:58 /usr/sbin/httpd
    3712 apache 17:02 /usr/sbin/httpd
    2844 root 16:58 pure-ftpd (SERVER)
    2859 root 16:58 crond
    3244 root 16:59 crond
    3245 root 16:59 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    3246 root 16:59 /bin/bash /usr/local/ispconfig/server/server.sh
    3276 root 16:59 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    3285 root 17:00 crond
    3289 root 17:00 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    3290 root 17:00 /bin/bash /usr/local/ispconfig/server/server.sh
    3324 root 17:00 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    3621 root 17:01 crond
    3623 root 17:01 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    3624 root 17:01 /bin/bash /usr/local/ispconfig/server/server.sh
    3654 root 17:01 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    3661 root 17:02 crond
    3662 root 17:02 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    3663 root 17:02 /bin/bash /usr/local/ispconfig/server/server.sh
    3693 root 17:02 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    3717 root 17:03 crond
    3718 root 17:03 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    3719 root 17:03 /bin/bash /usr/local/ispconfig/server/server.sh
    3749 root 17:03 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    3752 root 17:04 crond
    3753 root 17:04 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    3754 root 17:04 /bin/bash /usr/local/ispconfig/server/server.sh
    3784 root 17:04 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    3791 root 17:05 crond
    3795 root 17:05 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    3799 root 17:05 /bin/bash /usr/local/ispconfig/server/server.sh
    3829 root 17:05 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    4124 root 17:06 crond
    4125 root 17:06 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    4126 root 17:06 /bin/bash /usr/local/ispconfig/server/server.sh
    4156 root 17:06 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    4187 root 17:07 crond
    4188 root 17:07 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    4189 root 17:07 /bin/bash /usr/local/ispconfig/server/server.sh
    4219 root 17:07 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    4281 root 17:08 crond
    4282 root 17:08 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    4283 root 17:08 /bin/bash /usr/local/ispconfig/server/server.sh
    4313 root 17:08 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    4339 root 17:09 crond
    4340 root 17:09 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    4341 root 17:09 /bin/bash /usr/local/ispconfig/server/server.sh
    4371 root 17:09 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    4390 root 17:10 crond
    4394 root 17:10 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    4395 root 17:10 /bin/bash /usr/local/ispconfig/server/server.sh
    4429 root 17:10 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    4722 root 17:11 crond
    4723 root 17:11 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    4724 root 17:11 /bin/bash /usr/local/ispconfig/server/server.sh
    4754 root 17:11 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    4757 root 17:12 crond
    4758 root 17:12 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    4759 root 17:12 /bin/bash /usr/local/ispconfig/server/server.sh
    4789 root 17:12 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    4791 root 17:13 crond
    4792 root 17:13 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    4793 root 17:13 /bin/bash /usr/local/ispconfig/server/server.sh
    4823 root 17:13 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    4826 root 17:14 crond
    4827 root 17:14 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    4828 root 17:14 /bin/bash /usr/local/ispconfig/server/server.sh
    4858 root 17:14 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    4862 root 17:15 crond
    4865 root 17:15 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    4869 root 17:15 /bin/bash /usr/local/ispconfig/server/server.sh
    4899 root 17:15 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    5222 root 17:16 crond
    5223 root 17:16 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    5224 root 17:16 /bin/bash /usr/local/ispconfig/server/server.sh
    5254 root 17:16 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    5257 root 17:17 crond
    5258 root 17:17 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    5259 root 17:17 /bin/bash /usr/local/ispconfig/server/server.sh
    5289 root 17:17 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    5291 root 17:18 crond
    5292 root 17:18 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    5293 root 17:18 /bin/bash /usr/local/ispconfig/server/server.sh
    5323 root 17:18 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    5326 root 17:19 crond
    5327 root 17:19 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    5328 root 17:19 /bin/bash /usr/local/ispconfig/server/server.sh
    5358 root 17:19 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    5363 root 17:20 crond
    5366 root 17:20 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    5370 root 17:20 /bin/bash /usr/local/ispconfig/server/server.sh
    5402 root 17:20 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    5697 root 17:21 crond
    5698 root 17:21 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    5699 root 17:21 /bin/bash /usr/local/ispconfig/server/server.sh
    5729 root 17:21 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    5768 root 17:22 crond
    5769 root 17:22 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    5770 root 17:22 /bin/bash /usr/local/ispconfig/server/server.sh
    5800 root 17:22 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    5802 root 17:23 crond
    5803 root 17:23 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    5804 root 17:23 /bin/bash /usr/local/ispconfig/server/server.sh
    5834 root 17:23 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    5837 root 17:24 crond
    5838 root 17:24 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    5839 root 17:24 /bin/bash /usr/local/ispconfig/server/server.sh
    5869 root 17:24 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    5873 root 17:25 crond
    5875 root 17:25 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    5877 root 17:25 /bin/bash /usr/local/ispconfig/server/server.sh
    5911 root 17:25 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    6204 root 17:26 crond
    6205 root 17:26 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    6206 root 17:26 /bin/bash /usr/local/ispconfig/server/server.sh
    6236 root 17:26 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    6254 root 17:27 crond
    6255 root 17:27 /bin/sh -c /usr/local/ispconfig/server/server.sh &> /dev/null
    6256 root 17:27 /bin/bash /usr/local/ispconfig/server/server.sh
    6286 root 17:27 /usr/bin/php -q /usr/local/ispconfig/server/server.php
    2915 root 16:58 /usr/sbin/munin-node
    2916 xfs 16:58 xfs -droppriv -daemon
    2974 root 16:58 /usr/bin/python /usr/bin/fail2ban-server -b -s /var/run/fail2ban/fail2ban.sock
    3019 root 16:58 anacron -s
    3037 root 16:58 /usr/sbin/atd
    3060 root 16:58 /usr/sbin/saslauthd -m /var/run/saslauthd -a pam
    3068 root 16:58 /usr/sbin/saslauthd -m /var/run/saslauthd -a pam
    3069 root 16:58 /usr/sbin/saslauthd -m /var/run/saslauthd -a pam
    3070 root 16:58 /usr/sbin/saslauthd -m /var/run/saslauthd -a pam
    3071 root 16:58 /usr/sbin/saslauthd -m /var/run/saslauthd -a pam
    3105 avahi 16:58 avahi-daemon: running [Evariste-Galois.local]
    3106 avahi 16:58 avahi-daemon: chroot helper
    3121 haldaemon 16:58 hald
    3122 root 16:58 hald-runner
    3129 haldaemon 16:58 hald-addon-acpi: listening on acpid socket /var/run/acpid.socket
    3138 root 16:58 hald-addon-storage: polling /dev/hdb
    3140 root 16:58 hald-addon-storage: polling /dev/hda
    3144 root 16:58 /usr/bin/python -tt /usr/sbin/yum-updatesd
    3146 root 16:58 /usr/libexec/gam_server
    3178 root 16:58 /usr/sbin/smartd -q never
    3183 root 16:58 /usr/bin/perl /usr/libexec/webmin/miniserv.pl /etc/webmin/miniserv.conf
    6243 root 17:26 /usr/bin/perl /usr/libexec/webmin/miniserv.pl /etc/webmin/miniserv.conf
    6252 root 17:26 /usr/libexec/webmin/proc/index_tree.cgi
    3186 root 16:58 /sbin/mingetty tty1
    3187 root 16:58 /sbin/mingetty tty2
    3191 root 16:58 /sbin/mingetty tty3
    3192 root 16:58 /sbin/mingetty tty4
    3202 root 16:58 /sbin/mingetty tty5
    3205 root 16:58 /sbin/mingetty tty6
     
  5. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Having multiple server.php instances running normally means there was an error. Check the system log of ispc for errors.
    Try to delete the /usr/local/ispconfig/server/temp/.ispconfig.lock file manually
     
  6. homo

    homo New Member

    That was very helpful for me!
    Thanks!

    By the way ispconfig log was clear, no errors, no warnings. Any ideas about what caused so many increasing processes?
     

Share This Page