View Single Post
  #8  
Old 28th June 2008, 10:10
blocker blocker is offline
Senior Member
 
Join Date: Mar 2008
Posts: 178
Thanks: 9
Thanked 4 Times in 4 Posts
Default

Quote:
Originally Posted by till View Post
Please run the following SQL statements in the ispconfig database:

update isp_isp_web set status = 'u' where status = '';
update isp_isp_user set status = 'u' where status = '';

Then change a setting in one of the sites in ispconfig and click on save.
Thanks Till!!!

Thats exactly what i was looking for!
But unfortunately it doesn't work for me. I have tried exactly your suggestion:

Code:
mysql -u root -p
use db_ispconfig;
update isp_isp_web set status = 'u' where status = '';
update isp_isp_user set status = 'u' where status = '';
quit
/root/ispconfig/php/bin/php /root/ispconfig/scripts/writeconf.php
the output is something like this:

Code:
start
UPDATE: 594
UPDATE: 595
UPDATE: 596
etc etc etc

UPDATE USER: 1
UPDATE USER: 2
UPDATE USER: 6
etc etc etc

ende
there were also a couple of warnings like this:

Code:
UPDATE USER: 746

Warning: symlink(): File exists in /root/ispconfig/scripts/lib/config.lib.php on line 933
UPDATE USER: 1494
after that:

Code:
cd /var/www
ls -la

drwxrwxrwx   8 admin_user                10590  4096 2008-06-28 08:50 web168
lrwxrwxrwx   1 www-data                   10590    15 2008-03-20 11:25 www.example.org -> /var/www/web168
(changed to 777, so the users at least can get the mails in their Maildirs...)

So i suppose the problem should be somewhere in the ispc database, in case the writeconf.php is started after a modification flag has been set to every user and site? This is really wired i am totally confused...
Reply With Quote