ispconfig 3.2.2 does not create database

Discussion in 'General' started by buhler, Jan 5, 2021.

  1. buhler

    buhler Member

    I updated today to ispconfig 3.2.2.
    When a user tries to create a database, it appears as created in the panel. But in practice it is not created in Mariadb.
    In version 3.2.1 it was working normal. Debian environment 10 and 9. Ispconfig 3.2.2.
    There is no error in the cron.log in the debug.
    And we noticed that the task of creating the bank in the red ball does not appear next to the research field.
    But the task is recorded in the sys_datalog logs.
    I upgraded to 3.2.2 and now I'm starting to regret it.
    https://git.ispconfig.org/ispconfig/ispconfig3/-/issues/5998
     
    Last edited: Jan 5, 2021
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

  3. buhler

    buhler Member

    I already did the procedure and it doesn't show an error.
     
  4. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Did you reconfigure database permissions on your master server? Are all servers at 3.2.2? Did you do the debug steps on the correct server?
     
    Last edited: Jan 5, 2021
  5. buhler

    buhler Member

    [email protected]:/var/log/ispconfig# /usr/local/ispconfig/server/server.sh
    05.01.2021-11:35 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
    05.01.2021-11:35 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    finished server.php.

    Did you configure database permissions on your master servers?
    Reconfigure Permissions in master database? (yes,no) [no] ->
    I always left no.

    Everything was working in 3.2.1. Now in 3.2.2 this situation has appeared. And I've been updating since 3.1


    Are all servers at 3.2.2? yes

    Did you do the debug steps on the correct server?
    yes
     
  6. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Alright, on the master server, it is better to do so, but it shouldn't break your install. Can you try running the whole upgrade again?

    What is in the updated column of the server table for the server that has issue? En what is the latest datalog ID? (sys_datalog table)
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    And are you sure that you added a database too and not just a MySQL user? The MySQL user gets added when you add a database that requires that user and not when you add the user.
     
    Th0m likes this.
  8. buhler

    buhler Member

    The user was created first and then the database
     
  9. buhler

    buhler Member

    How I have been updating my ispconfig since version 3.0. The sys_datalog was large. So I did a truncate.
    It is currently on datalog_id 48.
    I made an attempt to create the database and went to datalog_id 49

    I've been upgrading from 3.0 to 3.1 and now 3.2

    For testing I tried to create an email and it worked normal.
    Only creating database does not work
     
  10. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Well, there you go. In the server table it is saved which datalog_id was processed last, and that will be a much higher ID. Lower that so it runs all missed actions (for every server).

    No problem with 3.2.2 :)
     
  11. buhler

    buhler Member

    In which field of the server table should I make the adjustment? in the update field?
     
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    Your system must fail after that action. As @Th0m mentioned, no problem with ISPConfig 3.2.2 here.
     
  13. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Yes, the updated column.
     
  14. buhler

    buhler Member

    It worked. Thanks
     

Share This Page