Prev Previous Post   Next Post Next
  #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
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[ask] MYSQL and PhpMyAdmin Problem Login m4l41k4t General 1 11th October 2012 09:47
MySQL problem - Sometimes cann't connect to MySQL Ronniea Server Operation 2 16th July 2012 22:01
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 11:49
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 23:16
Problem Installing Apache 2.2.8, MySQL 5.0 Client and PHP 5.2.5 On Fedora 8 (64-Bit) asyadiqin Installation/Configuration 5 10th April 2008 19:40


All times are GMT +2. The time now is 08:11.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.