Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 10th December 2010, 07:53
faster faster is offline
Junior Member
 
Join Date: Dec 2010
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Cannot Create New MySQL Databases

I have ISPConfig3 setup on an Ubuntu server and followed the excellent guide here. After initially setting up the server I was able to create some MySQL databases through ISPConfig. I could log into those MySQL databases through PHPMyAdmin. Now I cannot.

I create the database, user, and select the site through ISPConfig. No errors or anything. When I attempt to log into MySQL it basically gives me a error: #1045 Cannot log in to the MySQL server. I also cannot log into the database with the newly created MySQL username / password through at the terminal. mysql -u user -pPassword

I need to create some new databases for new sites. Any help or suggestions would be awesome. I've checked the logs and have not see anything.
Reply With Quote
Sponsored Links
  #2  
Old 10th December 2010, 09:21
faster faster is offline
Junior Member
 
Join Date: Dec 2010
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

When I log into the database as root through the termainl, then run select host, user, password from mysql.user; it does not show any of the users I've created.

What would prevent ISPConfig from creating users or databases?

Thanks
Reply With Quote
  #3  
Old 11th December 2010, 14:56
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

Make sure that your database details in /usr/local/ispconfig/interface/lib/config.inc.php are correct.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #4  
Old 11th January 2011, 09:48
faster faster is offline
Junior Member
 
Join Date: Dec 2010
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I just checked that and mysql_clientdb.conf and everything looks correct. Is there anything that should stand out in the conf files?

I was able to mysql -u root -pPassword based on the info in mysql_clientdb.conf.

Any other suggestions? Thanks
Reply With Quote
  #5  
Old 11th January 2011, 12:52
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,001
Thanks: 840
Thanked 5,650 Times in 4,460 Posts
Default

Quote:
I was able to mysql -u root -pPassword based on the info in mysql_clientdb.conf.
Thats good, the credentials in that file are used to create the databases. Please try also to use the hostname as it might be related to the hostname when the login fails.

mysql -h localhost -u root -pPassword

Are there any non processed changes listed in the ispconfig monitor in the jobqueue?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 11th January 2011, 17:35
faster faster is offline
Junior Member
 
Join Date: Dec 2010
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Tried: mysql -h localhost -u root -pPassword and it worked correctly.

In my Jobqueue i have a lot of insert / delete / update to web_database table. It seems these are all the database creations I have been trying to do but yet not going through.
Reply With Quote
  #7  
Old 11th January 2011, 17:47
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,001
Thanks: 840
Thanked 5,650 Times in 4,460 Posts
Default

Ok, so there is a problem that has stopped the job processing. Please check in ispconfig under monitor > system log if there are any errors listed there.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #8  
Old 11th January 2011, 17:52
faster faster is offline
Junior Member
 
Join Date: Dec 2010
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

ISPConfig System-Log does not show any issues.

I followed this thread: http://www.howtoforge.com/forums/showthread.php?t=45407 and it seems to be the same thing but I am not sure how to fix it.


select datalog_id from sys_datalog; returns 138 as the last result but

mysql> select updated from server; returns 137.

Not sure how to make it sync so I can create databases.

Thanks
Reply With Quote
  #9  
Old 11th January 2011, 18:06
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,001
Thanks: 840
Thanked 5,650 Times in 4,460 Posts
Default

This is a quite old bug, so you should update your server to a current ispconfig release.

Then change the number in the updated field in the server table to the number of the first unprocessed record from sys_datalog. You can find that record e.g. by counting the number of records that show up in the jobqueue in the monitor.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #10  
Old 12th January 2011, 09:05
faster faster is offline
Junior Member
 
Join Date: Dec 2010
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Ran sudo apt-get upgrade
Downloaded and updated ISPConfig to 3.0.3.2

Currently in my JobQueue I have one thing pending.


select datalog_id, status from sys_datalog order by datalog_id;

Shows 138 items pending. Does it matter there are that many pending in there but only one item showing up in JobQueue?

select updated from server; returns 137.

I set the updated column to 138 and rebooted the server.

After reboot I tried to make a database but it failed.

Same issue. sys_datalog shows 139 items but updated column only shows 138.

Any suggestions?

Also the database I create show sup in web_database but nothing when listing actual databases in mysql nothing shows up.

Thanks

Last edited by faster; 12th January 2011 at 09:09.
Reply With Quote
Reply

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
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 18:03
cannot assign MySQL databases tom Installation/Configuration 2 29th March 2007 13:46
Chroot SSH + ISPConfig Norman Installation/Configuration 27 26th March 2007 04:40
You cannot assign MySQL databases to this website hans2512 Installation/Configuration 4 25th February 2007 16:23


All times are GMT +2. The time now is 03:46.


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