HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   [Multi-server system] Very strange problem (http://www.howtoforge.com/forums/showthread.php?t=38535)

Gimly 26th August 2009 22:25

[Multi-server system] Very strange problem
 
Hi all,

Actually, I meet a very strange problem, my ispconfig doesn't create mail and database. I've multiserver system, which worked fine but since 1 week, the system doesn't work.

When I'm going to look my database, I've look this problem (first picture) :

http://img188.imageshack.us/img188/8964/passgbd2.th.jpg

When I click on database properties, the server list are in grey :

http://img142.imageshack.us/img142/416/gris.th.jpg

I've look at client limits properties and when I want to select database server, I just have my master server and not my sql server (sql.espace4you.org) :

http://img339.imageshack.us/img339/7844/passgbd.th.jpg

and when I look at my servers config, it's ok :

http://img175.imageshack.us/img175/3...erveurs.th.jpg

I've the same problem with my mail server.

I launch the server.sh and this is the return (same result for mail server) :

Quote:

sql:/home/e4yromain# /usr/local/ispconfig/server/server.sh
finished.
sql:/home/e4yromain#
and I don't use firewall on this servers.

If you have an idea, please ?

Thank you in advance

till 27th August 2009 13:17

I guess that a problem with the current beta. I noticed this today during testing. It affects only new records that were created by clients and not admins. The server_id is missing in these records. Will have to take a look at the code what has caused this.

Gimly 28th August 2009 10:58

When can I know if the problem is fix ?

till 28th August 2009 11:03

As usual, look at the bugtracker.

Gimly 28th August 2009 11:45

thanks till :)

till 28th August 2009 13:46

The problem now is that I'am not able to reproduce it anymore on my systems. May you please execute this sql query in the ispconfig database e.g. with phpmyadmin and post the output:

SELECT server_id,server_name FROM server WHERE db_server = 1 ORDER BY server_name

till 28th August 2009 13:59

Additional questions:

1) are you logged in as admin, normal user or reseller user when this happens?
2) Post also the output of this mysql query:

SELECT sys_perm_user,sys_perm_group,sys_perm_other FROM server WHERE db_server = 1

Gimly 28th August 2009 18:57

Hi Till,

Thanks for your reply

1)
Quote:

mysql> SELECT server_id,server_name FROM server WHERE db_server = 1 ORDER BY server_name ;
+-----------+--------------------+
| server_id | server_name |
+-----------+--------------------+
| 9 | sql.espace4you.org |
+-----------+--------------------+
2) I'm logged in as user when the problem come, but when I'm in admin I d'ont have this problem

3)
Quote:

mysql> SELECT sys_perm_user,sys_perm_group,sys_perm_other FROM server WHERE db_server = 1 ;
+---------------+----------------+----------------+
| sys_perm_user | sys_perm_group | sys_perm_other |
+---------------+----------------+----------------+
| riud | riud | r |
+---------------+----------------+----------------+
1 row in set (0.00 sec)

mysql>

till 30th August 2009 11:10

Thanks. I think I found the problem and fixed it in SVN.

Gimly 30th August 2009 12:40

Thanks Till, I upgrade from last svn version to test it :)

--- edit : It work fine now, thank you very much Till :) ---


All times are GMT +2. The time now is 17:20.

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