[Multi-server system] Very strange problem

[Gimly]

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 (http://img188.imageshack.us/i/passgbd2.jpg/)

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

http://img142.imageshack.us/img142/416/gris.th.jpg (http://img142.imageshack.us/i/gris.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 (http://img339.imageshack.us/i/passgbd.jpg/)

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

http://img175.imageshack.us/img175/3687/configserveurs.th.jpg (http://img175.imageshack.us/i/configserveurs.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) :

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]

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]

When can I know if the problem is fix ?

[till]

As usual, look at the bugtracker.

[Gimly]

thanks till :)

[till]

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]

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]

Hi Till,

Thanks for your reply

1)
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)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]

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

[Gimly]

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

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

[Gimly]

Since your last fix on svn, new problem are come.

In limit client properties, the number off DNS, Mailbox, Database, Cron Jobs, etc ... not work for user (work for admin). For exemple :

User have 8 database and he don't use again DB. When he wants to create DB , he can see this error :

Error
The max. number database for your account is reached.

Can you look at this problem please ?

Thanks in advance :)

[till]

Tested it and it works for me. Make sure that you did not reached the reseller limits. Also no code in this reagion has changed from beta 2.

[Gimly]

User is attached to admin no to a reseller, so admin hasn't limit. So I don't understand why it doesn't work O_o.


PS : I updated my beta 2 version with svn trunk

[till]

Set the limit of the item e.g. databases to a higher value and try again.

[Gimly]

same problem

[till]

Is the problem just with this one client or with others too? I tested the current SVN version an everything works fine on my installation.

[Gimly]

I have the problem with all my users :( . Admin has no limits, right ?

[till]

The admin has no limit. And you are really sure that the users do not belong to a reseller?

[Gimly]

Yes because, I don't have any resellers created on my ispconfig system ;)

[till]

1) Cn you create items, when you are logged in as admin?
2) Can you create items when you are logged in as a client when you set a limit for a specific item.
3) Can you create items when you are logged in as a client when you set no limit for a specific item (-1).
4) Create a new client, can you craete items for him?

[Gimly]

1) Cn you create items, when you are logged in as admin?

Yes, I can in as admin

2) Can you create items when you are logged in as a client when you set a limit for a specific item.

No, user can't create item

3) Can you create items when you are logged in as a client when you set no limit for a specific item (-1).

No, I can't an I can see, if I use -1 or an other number the last option enter is not save

4) Create a new client, can you craete items for him?

Yes, it work fine, but not with existing users

[till]

Ok, then there msut be a permission problem with your old clients. I will try to make a update installation and see if I can reproduce it.

[Gimly]

Thanks Till for your quick reply :)

[till]

I installed a 3.0.1.2 version, created clients and resellers and then updated it to 3.0.1.3 added another client and then updated to svn. All limits are working fine on this system.

Please take a look at the database of your system, as new clients work but not old ones, please compare the record for a old and a new client in the client table, then compare the corresponding groups in the sys_group table and then the corresponding users in the sys_user table if you see any significant differences.

[Gimly]

I solved the problem, it's due to group, my old client uses an unexisting group. I move user on their own group and now it work.

Thanks Till for your very quick reply ^^