[Multi-server system] Very strange problem

Discussion in 'Installation/Configuration' started by Gimly, Aug 26, 2009.

  1. Gimly

    Gimly Member

    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) :

    [​IMG]

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

    [​IMG]

    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) :

    [​IMG]

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

    [​IMG]

    I've the same problem with my mail server.

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

    and I don't use firewall on this servers.

    If you have an idea, please ?

    Thank you in advance
     
    Last edited: Aug 27, 2009
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  3. Gimly

    Gimly Member

    When can I know if the problem is fix ?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    As usual, look at the bugtracker.
     
  5. Gimly

    Gimly Member

    thanks till :)
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    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
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    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
     
  8. Gimly

    Gimly Member

    Hi Till,

    Thanks for your reply

    1)
    2) I'm logged in as user when the problem come, but when I'm in admin I d'ont have this problem

    3)
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

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

    Gimly Member

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

    --- edit : It work fine now, thank you very much Till :) ---
     
    Last edited: Aug 30, 2009
  11. Gimly

    Gimly Member

    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 :

    Can you look at this problem please ?

    Thanks in advance :)
     
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  13. Gimly

    Gimly Member

    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
     
  14. till

    till Super Moderator Staff Member ISPConfig Developer

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

    Gimly Member

    same problem
     
  16. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  17. Gimly

    Gimly Member

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

    till Super Moderator Staff Member ISPConfig Developer

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

    Gimly Member

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

    till Super Moderator Staff Member ISPConfig Developer

    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?
     

Share This Page