Hi guys, I'm having trouble while managing databases. When selecting a database in the panel, there are no information coming in the fields. It is an apache ISPConfig, serveur is running fine, i just can't modify databases. Datas in dbispconfig looks like correct compared to another ispconfig select * from web_database where database_id = 14; +-------------+------------+-------------+---------------+----------------+----------------+-----------+------------------+-------+---------------+----------------------+----------------+----------------+-------------------------+------ ------------+---------------------+------------------+---------------+------------+-----------------+---------------+--------+ | database_id | sys_userid | sys_groupid | sys_perm_user | sys_perm_group | sys_perm_other | server_id | parent_domain_id | type | database_name | database_name_prefix | database_quota | quota_exceeded | last_quota_notification | datab ase_user_id | database_ro_user_id | database_charset | remote_access | remote_ips | backup_interval | backup_copies | active | +-------------+------------+-------------+---------------+----------------+----------------+-----------+------------------+-------+---------------+----------------------+----------------+----------------+-------------------------+------ ------------+---------------------+------------------+---------------+------------+-----------------+---------------+--------+ | 14 | 14 | 14 | riud | riud | | 1 | 0 | mysql | XXXXXX | | 0 | n | NULL | 14 | 0 | UTF8 | n | | none | 1 | y | +-------------+------------+-------------+---------------+----------------+----------------+-----------+------------------+-------+---------------+----------------------+----------------+----------------+-------------------------+------ ------------+---------------------+------------------+---------------+------------+-----------------+---------------+--------+ I just updated ispconfig, but i can't tell if it is related, this server was configuered a while ago and no changed where made but upgrading ispconfig and security upgrade so i don't know when it broke. Edit => not related, yesterday backup have the same problem The test script does not seem to find problems, i just have IP-address (as per hostname): ***.***.***.*** [WARN] could not determine server's ip address by ifconfig Thanks in advance for your help Best Regards
these databases where created via API, and parent_domain was probably set to 0. Setting parent_domain to correct value added stuff. But when I want to add a readonly user to the DB, i have the message The database charset can not be changed the charset for my DB is +------------------------+---------+ | Variable_name | Value | +------------------------+---------+ | character_set_database | utf8mb3 | +------------------------+---------+ I tried all the charset, added the value to the tform 'value' => array('' => 'DB-Default', 'latin1' => 'Latin 1', 'utf8' => 'UTF-8', 'utf8mb4' => 'UTF8MB4', 'utf8mb3' => 'UTF8MB3') but even with the correct value, I can't save my DB information any idea ? thanks in advance
