Hello,
Debian7, Ispconfig 3.0.4.6, Physical server at OVH.
mysql-server: Installed: 5.5.24+dfsg-4
I have discoverd an issue in my ispconfig3: "add new database" doesn't insert database & users in Mysql:
Here the logs from mysql after create a database:
Code:
121218 13:02:30 30755 Connect ispconfig@localhost on
30755 Query SET NAMES utf8
30755 Query SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'
30755 Init DB dbispconfig
30755 Query SELECT * FROM sys_session WHERE session_id = 'rlvdl22gk2qrp5toqevrtner22'
30755 Query SET NAMES utf8
30755 Query SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'
30755 Init DB dbispconfig
30755 Query SELECT config FROM sys_ini WHERE sysini_id = 1
30755 Init DB dbispconfig
30755 Query SELECT client_id FROM sys_group WHERE groupid = 0
30755 Init DB dbispconfig
30755 Query SELECT client_id FROM sys_group WHERE groupid = 0
30755 Init DB dbispconfig
30755 Query SELECT count(database_id) as dbnum FROM web_database WHERE database_name = 'c0test' AND server_id = '1'
30755 Init DB dbispconfig
30755 Query SELECT count(*) as number FROM `web_database` WHERE database_user = 'c0test' AND database_id != 0
30755 Init DB dbispconfig
30755 Query INSERT INTO `web_database` (`server_id`, `type`, `database_name`, `database_user`, `database_password`, `database_charset`, `remote_access`, `active`, `remote_ips`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`) VALUES ('1', 'mysql', 'c0test', 'c0test', PASSWORD('testtesttest'), '', 'n', 'y', '', '1', '1', 'riud', 'riud', '')
30755 Init DB dbispconfig
30755 Query UPDATE web_database SET sys_groupid = 0, sys_perm_group = 'ru' WHERE database_id = 15
30755 Init DB dbispconfig
30755 Query SELECT client.limit_client FROM sys_user, client WHERE sys_user.userid = 1 AND sys_user.client_id = client.client_id
30755 Init DB dbispconfig
30755 Query SELECT * FROM `web_database` WHERE database_id = 15
30755 Init DB dbispconfig
30755 Query INSERT INTO sys_datalog (dbtable,dbidx,server_id,action,tstamp,user,data) VALUES ('web_database','database_id:15','1','i','1355832150','admin','a:2:{s:3:\"new\";a:15:{s:11:\"database_id\";s:2:\"15\";s:10:\"sys_userid\";s:1:\"1\";s:11:\"sys_groupid\";s:1:\"0\";s:13:\"sys_perm_user\";s:4:\"riud\";s:14:\"sys_perm_group\";s:2:\"ru\";s:14:\"sys_perm_other\";s:0:\"\";s:9:\"server_id\";s:1:\"1\";s:4:\"type\";s:5:\"mysql\";s:13:\"database_name\";s:6:\"c0test\";s:13:\"database_user\";s:6:\"c0test\";s:17:\"database_password\";s:41:\"*7032DC61FAF4DEC266EBA762C328FF49AB0EB7E7\";s:16:\"database_charset\";s:0:\"\";s:13:\"remote_access\";s:1:\"n\";s:10:\"remote_ips\";s:0:\"\";s:6:\"active\";s:1:\"y\";}s:3:\"old\";a:15:{s:11:\"database_id\";N;s:10:\"sys_userid\";N;s:11:\"sys_groupid\";N;s:13:\"sys_perm_user\";N;s:14:\"sys_perm_group\";N;s:14:\"sys_perm_other\";s:0:\"\";s:9:\"server_id\";N;s:4:\"type\";N;s:13:\"database_name\";N;s:13:\"database_user\";N;s:17:\"database_password\";N;s:16:\"database_charset\";s:0:\"\";s:13:\"remote_access\";N;s:10:\"remote_ips\";s:0:\"\";s:6:\"active\";N;}}')
30755 Init DB dbispconfig
30755 Query UPDATE sys_session SET last_updated = '2012-12-18 12:02:30' WHERE session_id = 'rlvdl22gk2qrp5toqevrtner22'
30755 Init DB dbispconfig
30755 Query DELETE FROM sys_session WHERE last_updated < '2012-12-18 11:38:30'
30755 Quit
121218 13:02:31 30756 Connect ispconfig@localhost on
30756 Query SET NAMES utf8
30756 Query SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'
30756 Init DB dbispconfig
30756 Query SELECT * FROM sys_session WHERE session_id = 'rlvdl22gk2qrp5toqevrtner22'
30756 Query SET NAMES utf8
30756 Query SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'
30756 Init DB dbispconfig
30756 Query SELECT groupid, name FROM sys_group WHERE groupid != 1 ORDER BY name
30756 Init DB dbispconfig
30756 Query SELECT server_id,server_name FROM server WHERE 1 AND db_server = 1 ORDER BY server_name
30756 Init DB dbispconfig
30756 Query SELECT count(*) AS anzahl FROM web_database WHERE 1
30756 Init DB dbispconfig
30756 Query SELECT * FROM web_database WHERE 1 LIMIT 0, 15
30756 Init DB dbispconfig
30756 Query SELECT config FROM sys_ini WHERE sysini_id = 1
30756 Init DB dbispconfig
30756 Query SELECT client.limit_client FROM sys_user, client WHERE sys_user.userid = 1 AND sys_user.client_id = client.client_id
30756 Init DB dbispconfig
30756 Query UPDATE sys_session SET last_updated = '2012-12-18 12:02:31' WHERE session_id = 'rlvdl22gk2qrp5toqevrtner22'
30756 Init DB dbispconfig
30756 Query DELETE FROM sys_session WHERE last_updated < '2012-12-18 11:38:31'
30756 Quit
But I can't connect in mysql with this new database:
Code:
# mysql -u c0test -p
Enter password:
ERROR 1045 (28000): Access denied for user 'c0test'@'localhost' (using password: YES)
And it's normal...
Code:
mysql> select host, user from mysql.user;
+-------------------+------------------+
| host | user |
+-------------------+------------------+
| 127.0.0.1 | root |
| ::1 | root |
| localhost | |
| localhost | c0base1 |
etc...
| localhost | c1base9 |
| localhost | debian-sys-maint |
| localhost | ispconfig |
| localhost | root |
| mail.karmaweb.biz | |
| mail.karmaweb.biz | root |
+-------------------+------------------+
19 rows in set (0.00 sec)
No database inserted, no user inserted.
If you have an idea what might be going on, you're welcome, I do not understand ...
Recent comments
22 hours 2 min ago
1 day 57 min ago
1 day 2 hours ago
1 day 3 hours ago
1 day 5 hours ago
1 day 6 hours ago
1 day 7 hours ago
1 day 23 hours ago
2 days 42 min ago
2 days 4 hours ago