#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
  #2  
Old 26th September 2007, 18:13
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,505
Thanks: 813
Thanked 5,266 Times in 4,129 Posts
Default

This is a known bug in mysql, but mysql refuses to fix this in the older versions. The recommended fix from mysql is to update your mysql installation to mysql 5.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 26th September 2007, 23:38
erebus erebus is offline
Member
 
Join Date: Sep 2007
Posts: 63
Thanks: 10
Thanked 9 Times in 9 Posts
Default

Thank you till for the quick response.

I didn't know it was a known issue. I'm sorry for that.

I run a "perfect" Centos 4.5 server. How easy would be to upgrade to MySQL 5? Is ISPConfig ok with this? Does it run smoothly?

Thank you again,
Reply With Quote
  #4  
Old 27th September 2007, 08:13
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,505
Thanks: 813
Thanked 5,266 Times in 4,129 Posts
Default

ISPConfig supports all mysql versions > 3. Which mysql version are you using right now?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
erebus (29th September 2007)
  #5  
Old 29th September 2007, 01:34
erebus erebus is offline
Member
 
Join Date: Sep 2007
Posts: 63
Thanks: 10
Thanked 9 Times in 9 Posts
Default

The latest stable that Centos 4.5 uses...

MySQL 4.1.2

Any upgrade procedure available to go to 5.x ?

Thank you

Edit:

In the meantime, I have found a quick-n-dirty way to solve this. phpmyadmins proposes by default to the user logged in, to create a new db with a similar db name to the one already created (and this is how I've discovered this mysql bug). I.e. if the db is blah_blah, it proposes to the users to create blah?blah. So you have two choices: Either to disable new db creation from phpmyadmin, or to disable db name suggestions for the new dbs. Personally I prefer the later, as I found the new db creation useful -- especially for the root user. So, change the following two options accordingly in /home/admispconfig/ispconfig/web/phpmyadmin/config.inc.php:

Code:
$cfg['ShowCreateDb']          = TRUE;   // show create database form
$cfg['SuggestDBName']         = FALSE;   // suggest a new DB name if possible (false = keep empty)
Also if Hans find this tweak useful, he may set these values in his phpmyadmin package, so as not to change them each time for the every new upgrade.

Thank you all,

Last edited by erebus; 29th September 2007 at 01:46.
Reply With Quote
The Following User Says Thank You to erebus For This Useful Post:
Hans (29th September 2007)
  #6  
Old 29th September 2007, 02:07
mlz mlz is offline
Senior Member
 
Join Date: Dec 2006
Posts: 189
Thanks: 16
Thanked 9 Times in 9 Posts
Default

Check the CentOS Plus repository, you can get 5 from there.
Reply With Quote
The Following User Says Thank You to mlz For This Useful Post:
erebus (29th September 2007)
  #7  
Old 29th September 2007, 13:10
erebus erebus is offline
Member
 
Join Date: Sep 2007
Posts: 63
Thanks: 10
Thanked 9 Times in 9 Posts
Default

Should I expect that by just running a

Code:
yum --enablerepo=centosplus update
...everything will update just fine without breaking my setup/configuration?

Code:
--> Running transaction check

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
 httpd                   i386       2.0.59-1.el4s1.7.el4.centos  centosplus                                                                                     928 k
     replacing  httpd-suexec.i386 2.0.52-32.3.ent.centos4

 kernel                  i686       2.6.9-55.0.9.EL  update             11 M
 perl                    i386       4:5.8.8-4.el4s1  centosplus         11 M
     replacing  perl-Filter.i386 1.30-6

Updating:
 mysql                   i386       5.0.48-1.el4.centos  centosplus        2.7 M
 mysql-devel             i386       5.0.48-1.el4.centos  centosplus        2.8 M
 mysql-server            i386       5.0.48-1.el4.centos  centosplus        9.7 M
 perl-DBD-MySQL          i386       3.0008-1.el4.centos  centosplus        145 k
 perl-DBI                i386       1.53-2.el4s1     centosplus        602 k
 perl-libwww-perl        noarch     5.805-1.1.1      centosplus        371 k
 php                     i386       5.1.6-3.el4s1.7  centosplus        1.1 M
 php-devel               i386       5.1.6-3.el4s1.7  centosplus        490 k
 php-gd                  i386       5.1.6-3.el4s1.7  centosplus        102 k
 php-imap                i386       5.1.6-3.el4s1.7  centosplus         48 k
 php-ldap                i386       5.1.6-3.el4s1.7  centosplus         31 k
 php-mysql               i386       5.1.6-3.el4s1.7  centosplus         77 k
 php-odbc                i386       5.1.6-3.el4s1.7  centosplus         47 k
 php-pear                noarch     1:1.4.11-1.el4s1.1  centosplus        345 k
 php-xmlrpc              i386       5.1.6-3.el4s1.7  centosplus         49 k
 postfix                 i386       2:2.2.10-1.1.el4.centos.mysql_pgsql.plus  ce                                                                             ntosplus        3.1 M
 postgresql-libs         i386       8.1.9-1.el4s1.1  centosplus        183 k
 unixODBC                i386       2.2.12-1.el4s1.1  centosplus        869 k
Installing for dependencies:
 autoconf                noarch     2.59-5           base              628 k
 automake                noarch     1.9.2-3          base              442 k
 mysql-libs              i386       5.0.48-1.el4.centos  centosplus        1.8 M
 mysqlclient14           i386       4.1.22-1.el4s1.1  centosplus        1.2 M
 perl-Compress-Zlib      i386       1.42-1.el4       centosplus         54 k
 php-cli                 i386       5.1.6-3.el4s1.7  centosplus        2.0 M
 php-common              i386       5.1.6-3.el4s1.7  centosplus        135 k
 php-pdo                 i386       5.1.6-3.el4s1.7  centosplus        219 k
 postgresql              i386       8.1.9-1.el4s1.1  centosplus        2.7 M
 postgresqlclient7       i386       7.4.14-1.el4s1.1.el4.centos  centosplus                                                                                     232 k

Transaction Summary
=============================================================================
Install     13 Package(s)
Update      18 Package(s)
Remove       0 Package(s)
Total download size: 55 M
Is this ok [y/N]:
Thank you.
Reply With Quote
  #8  
Old 29th September 2007, 13:30
Hans Hans is offline
Moderator
 
Join Date: Dec 2005
Location: Montfoort, The Netherlands
Posts: 2,256
Thanks: 212
Thanked 648 Times in 294 Posts
Send a message via Skype™ to Hans
 
Thumbs up

Quote:
Originally Posted by erebus
Code:
$cfg['ShowCreateDb']          = TRUE;   // show create database form
$cfg['SuggestDBName']         = FALSE;   // suggest a new DB name if possible (false = keep empty)
Also if Hans find this tweak useful, he may set these values in his phpmyadmin package, so as not to change them each time for the every new upgrade.
I will consider to to so.
Thank you for this usefull information anyway.
__________________
Hans

BB-Hosting | Quality Web Hosting since 2005
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
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 16:50.


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