Vhosts_ispconfig.conf no update

[zdenbe]

Hello,
can you help me with my problem? everything probably okay since update from ispconfig version 2.2.23 to 2.2.32.

no changes in/with Vhosts_ispconfig.conf (except access time)
no new files like Vhosts_ispconfig_date
no errors in logs (what i can see)

i changed permissions, synced Vhosts_ispconfig.conf and Vhosts_ispconfig.conf~ (same creation time), changed httpd control option in config file and try other tips from forums...

additional informations:
update wasn't update but new installation
some db from mysql are lost (no info about db in ispconfig admin, but i have it in my sql server dump...)

Can you give me some tip what to do?
Thanks in advance for your comments and sorry for my english :)

[falko]

What are the outputs of
ps aux | grep wconf
ls -la /root/ispconfig/
ls -la /home/admispconfig/ispconfig/?

[zdenbe]

ps aux | grep wconf
root 6639 0.0 0.0 4360 1692 ? S Aug04 1:34 /bin/bash /root/ispconfig/sv/ispconfig_wconf
root 7822 0.0 0.0 3120 744 pts/0 S+ 21:05 0:00 grep wconf

ls -la /root/ispconfig/
total 112
drwxr-xr-x 10 root root 4096 2009-08-03 22:25 .
drwxr-xr-x 12 root root 4096 2009-08-06 15:17 ..
-rwxr-xr-x 1 root root 34530 2009-08-01 19:36 cronolog
-rwxr-xr-x 1 root root 9673 2009-08-01 19:36 cronosplit
drwxr-xr-x 12 root root 4096 2009-08-01 18:56 httpd
drwxr-xr-x 16 root root 4096 2009-08-01 19:36 isp
-rw-r--r-- 1 root root 0 2009-08-05 09:20 .ispconfig_lock
drwxr-xr-x 7 root root 4096 2009-08-01 19:00 libmcrypt
-rw-r--r-- 1 root root 13 2009-08-03 19:05 .old_path_httpd_root
-rw-r--r-- 1 root root 7384 2009-08-02 16:31 omega.cfg
drwxr-xr-x 6 root root 4096 2009-08-01 18:47 openssl
drwxr-xr-x 6 root root 4096 2009-08-03 12:15 php
drwxr-xr-x 4 root root 4096 2009-08-01 19:36 scripts
drwxr-xr-x 4 root root 4096 2009-08-01 19:36 standard_cgis
drwxr-xr-x 2 root root 4096 2009-08-01 19:36 sv
-rwx------ 1 root root 9389 2009-08-01 19:36 uninstall

ls -la /home/admispconfig/ispconfig/
total 4012
drwxr-xr-x 8 admispconfig admispconfig 4096 2009-08-05 09:20 .
drwxr-xr-x 5 admispconfig admispconfig 4096 2009-08-03 18:27 ..
-rw-r--r-- 1 admispconfig admispconfig 22 2009-08-02 18:46 adminmail.txt
drwxrwx--- 2 admispconfig mysql 4096 2007-07-24 01:20 backup
drwxr-xr-x 4 admispconfig admispconfig 4096 2007-07-24 01:20 files
-rw-r--r-- 1 admispconfig admispconfig 3048903 2009-08-05 23:59 ispconfig.log
-rwxr-xr-x 1 admispconfig admispconfig 253090 2009-02-02 09:47 ispconfig.log.02-02-09_09-47-49.tar.gz
-rwxr-xr-x 1 admispconfig admispconfig 226427 2008-04-14 22:16 ispconfig.log.14-04-08_22-16-43.tar.gz
-rwxr-xr-x 1 admispconfig admispconfig 239590 2008-09-20 18:12 ispconfig.log.20-09-08_18-12-11.tar.gz
-rwxr-xr-x 1 admispconfig admispconfig 264653 2009-05-27 11:51 ispconfig.log.27-05-09_11-51-26.tar.gz
drwxr-xr-x 6 admispconfig admispconfig 4096 2009-08-01 20:27 lib
-rwxr-xr-x 1 admispconfig admispconfig 1085 2009-08-01 19:36 sysconf.txt
drwxr-xr-x 10 admispconfig admispconfig 4096 2009-07-27 12:41 temp
drwxr-xr-x 10 admispconfig admispconfig 4096 2008-02-12 15:50 tools
-rwxr-xr-x 1 admispconfig admispconfig 3472 2009-08-01 19:36 users
drwxr-xr-x 20 admispconfig admispconfig 4096 2008-05-27 04:34 web

[falko]

Run
rm -f /root/ispconfig/.ispconfig_lock
/root/ispconfig/php/php /root/ispconfig/scripts/writeconf.php
Does the last command show any errors?

[zdenbe]

Yes.

/root/ispconfig/php/php /root/ispconfig/scripts/writeconf.php
export APACHE_RUN_USER=www-data
start
Could not select database

[falko]

Please check if the ISPConfig database exists.

[zdenbe]

Yes, db for ispconfig exist, values in config.inc.php tested via phpmyadmin (login successfull)

edit: :rolleyes: insufficient rights of mysql ispconfig user...
Thanks for help!

[till]

The ispconfig mysql user must be root or must have the same permissions at it is used to administer the mysql database and to craete new mysql users and databases.