Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 7th June 2009, 10:40
homo homo is offline
Junior Member
 
Join Date: Jul 2008
Location: Greece
Posts: 21
Thanks: 2
Thanked 0 Times in 0 Posts
Default Databases don't work

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 by homo; 7th June 2009 at 10:50.
Reply With Quote
Sponsored Links
  #2  
Old 7th June 2009, 14:16
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,011
Thanks: 826
Thanked 5,378 Times in 4,225 Posts
Default

Quote:
The databases that have been created manually are visible (i mean from phpmyadmin) and work.
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.

Quote:
Before the update the database function was just fine.
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?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 7th June 2009, 16:15
homo homo is offline
Junior Member
 
Join Date: Jul 2008
Location: Greece
Posts: 21
Thanks: 2
Thanked 0 Times in 0 Posts
Default

Quote:
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 for testing the db server

Quote:
Are you sure that you did not change the root password of your mysql database?
Yes, i checked also the configuration file, the db root password is the same.
Reply With Quote
  #4  
Old 7th June 2009, 16:36
homo homo is offline
Junior Member
 
Join Date: Jul 2008
Location: Greece
Posts: 21
Thanks: 2
Thanked 0 Times in 0 Posts
Default


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
Reply With Quote
  #5  
Old 7th June 2009, 18:42
Croydon Croydon is offline
ISPConfig Developer
 
Join Date: Jul 2007
Location: Koblenz, Germany
Posts: 927
Thanks: 16
Thanked 261 Times in 208 Posts
Default

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
Reply With Quote
The Following User Says Thank You to Croydon For This Useful Post:
homo (9th June 2009)
  #6  
Old 9th June 2009, 11:55
homo homo is offline
Junior Member
 
Join Date: Jul 2008
Location: Greece
Posts: 21
Thanks: 2
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by Croydon View Post
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
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?
Reply With Quote
Reply

Bookmarks

Tags
db ispconfig 3 database

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail server using Postfix, Dovecot, Mysql... Postfix virtual maps doesn't work?? tarasbuljba HOWTO-Related Questions 33 28th May 2010 14:33
Remoting frame work work with version 2.32 ??? afandino Developers' Forum 7 8th June 2009 16:23
install ispconfig2 ok site dos not work ferasfm Installation/Configuration 5 7th May 2009 20:16
Restore deleted databases sojic Installation/Configuration 6 18th November 2008 12:53
Recovering unlinked mysql databases and users... Dave Lane Installation/Configuration 2 10th May 2006 19:45


All times are GMT +2. The time now is 12:05.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.