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.
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.
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,
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,
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.
