Cluster Email Client Problem Updating from Master

Discussion in 'Installation/Configuration' started by Maile Halatuituia, Mar 8, 2019.

  1. I have this error

    PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196
    PHP Warning: mysqli_real_connect(): (HY000/1044): Access denied for user 'ispcsrv54'@'pop.kalianet.to' to database 'dbispconfig' in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198

    i have check everything but it seems i am lost at this moment.

    This was a working setup but i have issues after i changed ip address. After restore to the original i still have the issue.
    I have check /usr/local/ispconfig/server/lib/config.inc.php and it look ok. also the /usr/local/ispconfig/interface/lib/config.inc.php
    please advice
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    You do not say what this everything is. Maybe you missed some spot where IP-address is configured?
    In addition to ISPConfig server config, it is at least in
    • File /etc/hosts
    • some other files in /etc, use
      Code:
      grep -R 11.22.33.44 /etc
      to find them all
    • name service, and wait 4 to 48 hours to be sure the change has propagated everywhere
    • the user for host in database
     
  3. Hi Taleman
    Please note everything i mean including the both hosts /etc/hosts file.
    I am not sure but i think some files apart from those i mention above i need to adjust but i don't know
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    When you change the IP address of a node, then you'll have to change the ip address of the mysql user in the master mysql database too, use the user editor from mysql for that as the user permissions are split on several tables. And change the hosts file on all servers incl. the master a @Taleman suggested.
     
  5. Hi Till
    This has been fixed by running ispconfig update.

    I have further issue. Now i dont see any error but after i upgrade to the latest ispconifg, when i make change n my master i see now changes happen to my clients. even the event current number is not changed. Seems the Panel scirpt doesnot aware of the change i make to sync to the clients.
    I have email server clients but both of them does not seem to recognize a change was made on the master server
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

  7. Hi Till
    I have done this and here is what i find.
    If i do a change to on the Server Config to my client email server it is work as expected and changes is erplicate nromally from my Master to the Client Email Server. However if i make any change to the Emailbox like changing password or adding new accounts, it is only exist on the master server but not automatically replicate to the Email Client server as it should be
    Attached is my client email server Server Services on the Master Server GUI.. email.png
     

Share This Page