#1  
Old 16th May 2006, 18:16
trueshanti trueshanti is offline
Member
 
Join Date: May 2006
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default site - databases

Hi

i found out today that ISPConfig doesnt create databases anymore that are created from web-site-administration .. inside ISPConfig it looks ok .. but no databases are created .. deleting existing ones works .. but not for new ones ( no limits ) - i am still able to create via phpmyadmin aso.

ispconfig.log doesnt show me useful debug on this .. the only MYSQL-related lines that occour read:

16.05.2006 - 18:05:09 => INFO - /root/ispconfig/scripts/lib/config.lib.php, Line 427: MySQL FLUSH PRIVILEGES

thats it :-/

are databases created on schedule or instantly ? .. maybe i missed something ?

please comment !

tnx4reply

-c-
Reply With Quote
Sponsored Links
  #2  
Old 16th May 2006, 19:09
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,034
Thanks: 826
Thanked 5,382 Times in 4,229 Posts
Default

I guess your mysql user that you specified during ISPConfig setup has not the permission to create databases.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 16th May 2006, 22:16
trueshanti trueshanti is offline
Member
 
Join Date: May 2006
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till
I guess your mysql user that you specified during ISPConfig setup has not the permission to create databases.
well .. that is root .. and i can delete already created ones out of ISPC but not create any anymore..

via phpmyadm (root as well ) it is possible to create them ..

so its not the mysqld-part ..

there should also be an error in the ispconfig.log - but there isnt :-(

update:

i delete the DBs "web11_db1 web11_db2" and created "web13_db1 web14_db1 and web15_db1" .. after a few hours ( not after 5 mins or so) i could see "some" of the new databases in the Filesystem and on phpmyadmin, but not all .. :-/ ,while in IDPConfig they all show up :-)

.. and one of those databases even shows up as web14?db1 (on fs and phpmyadmin ) -> "?" instead of "_" in ispconfig its name ist ok (with "_" )

but even after removing this badnamed db , creating dbs out of ispconfig is still not possible

thats wagg :-)

-c-

Last edited by trueshanti; 16th May 2006 at 22:19.
Reply With Quote
  #4  
Old 17th May 2006, 15:39
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Which ISPConfig version do you use?
__________________
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
  #5  
Old 17th May 2006, 21:30
trueshanti trueshanti is offline
Member
 
Join Date: May 2006
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default

2.2.2

tnx

-c-
Reply With Quote
  #6  
Old 18th May 2006, 20:49
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

What's the output of
Code:
strace /root/ispconfig/php/php - /root/ispconfig/scripts/writeconf.php
?
__________________
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
  #7  
Old 18th May 2006, 22:43
trueshanti trueshanti is offline
Member
 
Join Date: May 2006
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i would like to get some debug information on this .. but dont know how to set it up so ispconfig would show up the errors for "NOT" creating the dbs .. how can i debug this

tnx4reply
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
Site Skeletons rbartz Feature Requests 11 29th November 2008 16:07
Shared IP error when adding new site amoswright Installation/Configuration 15 15th June 2006 15:04
Recovering unlinked mysql databases and users... Dave Lane Installation/Configuration 2 10th May 2006 19:45
Removed site, but it is still there mromer General 2 21st December 2005 17:46
can't delete a site KenMcGinnis Installation/Configuration 2 14th August 2005 15:02


All times are GMT +2. The time now is 00:40.


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