Thread: Mysql problem
View Single Post
  #1  
Old 18th December 2012, 14:19
lollollollol lollollollol is offline
Member
 
Join Date: Nov 2011
Location: Madagascar
Posts: 44
Thanks: 7
Thanked 6 Times in 5 Posts
Default Mysql problem

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 ...
Reply With Quote
Sponsored Links