client database not created

Discussion in 'Installation/Configuration' started by 5t3f4n, Nov 16, 2014.

  1. 5t3f4n

    5t3f4n New Member

    hello,

    running a multiserver set-up with dedicated IPs:

    web 192.168.0.1
    database 192.168.0.2
    mail 192.168.0.3

    Adding new database via ISPConfig 3 works, meaning the database and the database user are created and are showing also in dbispconfig - web_database and web_database_user.

    for some reason the system won't allow to access this added client database with the client database user via phpmyadmin, nor i can see the client database when logging in to phpmyadmin with root user.

    What can i check to debug/resolve this?

    all hints welcome.

    thx
     
  2. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    The databases are created on "database". To let the user sign-in with phpmyadmin, you must either install phpmyadmin on "database", too or run phpmyadmin on web / your master-server, configure phpmyadmin to connect to "database" (configure a 2nd server in the config) and allow remote-accces for db and the db-user.
     
  3. 5t3f4n

    5t3f4n New Member

    thanks,

    current set-up has phpmyadmin installed on web (master-server).

    phpmyadmin can access 'database' server, i.e.all tables in dbispconfig are displayed, roundcube db is there, etc.

    The database that was created in ISPConfig has remote access activated, and the remote access IP from the 'database' server (192.168.0.2) is also specified.

    Still this database created via ISPConfig is not accessible with its database user and is not shown in phpmyadmin when logging in with root.

    what am I missing? maybe it's the 'configure a 2nd server in the config'? not sure where exactly i need to to that? in the phpmyadmin config file (/etc/apache2/conf.d/phpmyadmin.conf)?
     
  4. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    Please see here. If you do not use the remote-db-server with phpmyadmin, there are of course no new created users, as they will be created on "databse" (as long as you donĀ“t have a replication between master and db).
     

Share This Page