Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 26th September 2007, 17:20
erebus erebus is offline
Member
 
Join Date: Sep 2007
Posts: 63
Thanks: 10
Thanked 9 Times in 9 Posts
Exclamation SERIOUS ISPConfig + MySQL bug?

Hello all,

I was playing around today created demo resellers and users to see how ISPConfig behaves. Here is the scenario:

1) As admin I have created a demo reseller with (among other) a privilege to create 10 MySQL DBs.

2) I login as this demo reseller and created a demo website with a limit of 1 MySQL DB. For this website, I create a MySQL DB and a MySQL user. When I tried to create more DBs, ISPConfig says that I have reached the limit (which is normal).

3) I then login with this MySQL user credentials in phpmyadmin. The username is web11_u1 and the database is web11_db1 (which is normal).

Now comes the problem.

When I logged in for the first time in phpmyadmin, I saw the created database 'web11_db1' and phpmyadmin proposed me to create if I want another db with the auto provided name 'web11?db1' (don't know why). So I tried and guess what happened. I was able to create it!

So I tried to create more databases (always having logged in as web11_u1) and I reached to the following conclusion: I cannot create databases with any name I want (i.e. abcdef is not accepted) HOWEVER I CAN CREATE DBs with names similar to my originally created database name. So far I have already created these dbs:

web11*u1
web11&u1
web11-u1
web11?u1

...which I suppose is a serious issue.

So please, have a look at it and give us a quick workaround.

Thank you,

P.S. I have thought to disable the database creation from phpmyadmin's config, however I don't think that this would solve the problem as it seems there is a problem with the credentials and not with the frontend itself.
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
Update MySQL In debian with ISPCONFIG kaneda Tips/Tricks/Mods 5 25th January 2007 18:38
ISPConfig server also a MySQL replication slave jamesh Installation/Configuration 1 2nd August 2006 09:59
ISPConfig: Install: mysql: unknown variable 'db-name=default' dreger Installation/Configuration 3 30th July 2006 22:23
A 'group' / 'name' bug? ISPconfig 2.2.0 edge General 3 9th April 2006 12:34
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 13:58.


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