Dash in DB name causes plesk exception when viewing full resource statistics

[Mshaker]

OS: centos 5 x64
Plesk version: 9.5.2 CentOS 5 95100504.10

When you create a database containing the '-' character it creates the database as expected however on disk the database directory path '-' gets created as '@002d'.

Eg. create database name called example-database
Database name: example-database
On disk: /var/lib/mysql/example@002ddatabase/

After the database is created you can no longer view the domains "Full Summary" report as it now throws a "PleskUtilException"

get_dir_size: Error: unable to get dir size for /var/lib/mysql/example-database

System error 2: No such file or directory

0: DatabaseManagerMySQL.php:284
DatabaseManagerMySQL->getDatabaseSizeImpl(string 'example-database', resource)
1: DatabaseManager.php:323
DatabaseManager->getDatabaseSize(object of type Database)
2: class.DomainReport.php:673
DomainReport->make_report_full_databases_()
3: class.Report.php:277
Report->make_report(integer '61')
4: ReportUIPointer.php:40
ReportUIPointer->accessItem(string 'POST', NULL null)
5: UIPointer.php:596
UIPointer->access(string 'POST')
6: plesk.php:38

Just a note that dumping the database and recreating it without the '-' will fix the exception.

 

[IgorG]

Right, it is known issue. I hope it will be fixed soon. Now we can recommend you do not use any special symbols for database names.

 

[patricrt]

Hi,

We have experienced this problem in version 9.5.3 CentOS 5 95101022.06 - do you know when this will finally be resolved?

Thanks

 

[Mickael Salfati]

Right, it is known issue. I hope it will be fixed soon. Now we can recommend you do not use any special symbols for database names.

IgorG, No fix 2 months after ? I think that it's really an urgent issue because disk space took by customers isn't correctly calculated ! Other topic refering this issue without response about plesk 10.2: http://forum.parallels.com/showthread.php?t=110046

 

[IgorG]

Please check this link:

http://download1.parallels.com/Ples...uide/plesk-control-panel-user-guide/65157.htm

This document says "We recommend that you choose a name that starts with a Latin alphabet symbol and comprises only alphanumeric and underscore symbols (up to 64 symbols)".

Please follow these documented recommendations.