database created but no user

Discussion in 'General' started by maumar, Jul 8, 2012.

  1. maumar

    maumar New Member HowtoForge Supporter

    Hello
    this is a multiserver installation.
    my customer did a great damage, he tryied to create a database on a mysql server with root as dbuser.

    You cannot imagine what a nightmare ;)
    I have fixed all the issues. But still something des not work.
    I have disbled cron, enabled debug, created a database on panel and assigned it to mysql server with issues
    here is the debug:
    Code:
     /usr/local/ispconfig/server/server.sh
    08.07.2012-15:30 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    08.07.2012-15:30 - DEBUG - Found 1 changes, starting update process.
    /usr/bin/fail2ban-client
    /sbin/iptables
    /sbin/ip6tables
    08.07.2012-15:30 - DEBUG - Unable to register function 'soa_insert' from plugin 'bind_plugin' for event 'dns_soa_insert'
    08.07.2012-15:30 - DEBUG - Unable to register function 'soa_update' from plugin 'bind_plugin' for event 'dns_soa_update'
    08.07.2012-15:30 - DEBUG - Unable to register function 'soa_delete' from plugin 'bind_plugin' for event 'dns_soa_delete'
    08.07.2012-15:30 - DEBUG - Unable to register function 'slave_insert' from plugin 'bind_plugin' for event 'dns_slave_insert'
    08.07.2012-15:30 - DEBUG - Unable to register function 'slave_update' from plugin 'bind_plugin' for event 'dns_slave_update'
    08.07.2012-15:30 - DEBUG - Unable to register function 'slave_delete' from plugin 'bind_plugin' for event 'dns_slave_delete'
    08.07.2012-15:30 - DEBUG - Unable to register function 'rr_insert' from plugin 'bind_plugin' for event 'dns_rr_insert'
    08.07.2012-15:30 - DEBUG - Unable to register function 'rr_update' from plugin 'bind_plugin' for event 'dns_rr_update'
    08.07.2012-15:30 - DEBUG - Unable to register function 'rr_delete' from plugin 'bind_plugin' for event 'dns_rr_delete'
    08.07.2012-15:30 - DEBUG - Replicated from master: REPLACE INTO web_database (`database_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`type`,`database_name`,`database_user`,`database_password`,`database_charset`,`remote_access`,`remote_ips`,`active`) VALUES ('357','1','22','riud','ru','','22','mysql','pippoprova','pippoprova','*ED1A992BC805C84B24010899F62C0B341C37A884','utf8','y','83.170.92.57,178.79.130.202','y')
    08.07.2012-15:30 - DEBUG - Calling function 'db_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
    08.07.2012-15:30 - DEBUG - Created MySQL database: pippoprova
    08.07.2012-15:30 - DEBUG - Processed datalog_id 468781
    08.07.2012-15:30 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    finished.
    
    
    1. ok: the record into web_database is inserted
    2. ok: the database is created and i see it into /var/lib/mysql
    3. ko: i have no record into mysql database, neither into mysql.user, neither into mysql.db
    4. ok: /usr/local/ispconfig/server/lib/mysql_clientdb.conf is ok

    what can I investigate further?

    which php unit does insert into mysql? if i know which one, i could insert some debug into it

    many thnx
     
    Last edited: Jul 8, 2012
  2. maumar

    maumar New Member HowtoForge Supporter

    Solved!
    i have fixed [email protected] without giving it GRANT priv.
    Grant_priv was 'n', intead of 'y'

    I solved reading:
    Code:
    /usr/local/ispconfig/server/plugins-enabled/mysql_clientdb_plugin.inc.php
    
     

Share This Page