HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   SERIOUS ISPConfig + MySQL bug? (http://www.howtoforge.com/forums/showthread.php?t=15806)

erebus 26th September 2007 18:20

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.

till 26th September 2007 19:13

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.

erebus 27th September 2007 00:38

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,

till 27th September 2007 09:13

ISPConfig supports all mysql versions > 3. Which mysql version are you using right now?

erebus 29th September 2007 02:34

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,

mlz 29th September 2007 03:07

Check the CentOS Plus repository, you can get 5 from there.

erebus 29th September 2007 14:10

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.

Hans 29th September 2007 14:30

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.


All times are GMT +2. The time now is 05:14.

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