Does ispCP support PHP 5.3.0

[ceco91]

I am setting up a new hosting server and expirienced big problems with php 5.3.0. I have compiled it myself.
I am using Ubuntu Server 8.04 (hardy).
PHP configuration:

Code:

'./configure' '--with-gd' '--enable-gd-native-ttf' '--enable-gd-jis-conv' '--with-mcrypt' '--with-mhash' '--with-mysql=/usr/local/mysql/' '--with-pear' '--with-mysql-sock=/var/run/mysqld/mysqld.sock' '--enable-sockets' '--enable-ftp' '--enable-mbstring'

[joximu]

Yes, principally it does - but we allready found at least one problem where the parameters of a function call were wrong (syntax) - that caused a problem - but only in 5.3 (maybe they changed the level of error???).

I'd say: enable php error logging and see wheres the problem - so we can fix this and are ready for the 5.3 when its in the common distri...

/J

[ceco91]

I've fix some bugs. There are plenty. I can give you a list of errors which I have found.

[joximu]

ok, maybe you can enter this list into a bugreport - otherwise post here...

Thanx

/J

[ceco91]

I have made some changes to sql_user_add.php and now ispCP adds a new SQL users but it gives me "Query was empty" (It gave the same error before the edit). Here is the part I've changed:

Code:

    $new_db_name = ereg_replace("_", "\\_", $db_name);
    $query = 'grant all on ' . quoteIdentifier($new_db_name) . '.* to ?@\'localhost\' identified by ?';
    $rs = exec_query($sql, $query, array($db_user, $user_pass));
    $query = 'grant all on ' . quoteIdentifier($new_db_name) . '.* to ?@\'%\' identified by ?';
    $rs = exec_query($sql, $query, array($db_user, $user_pass));

to

Code:

    $new_db_name = str_replace("_", "\\_", $db_name);
    $query = 'grant all privileges on ' . quoteIdentifier($new_db_name) . ".* to ".$db_user."@localhost identified by '".$user_pass."'";
    $rs = exec_query($sql, $query);
    $query = 'grant all privileges on ' . quoteIdentifier($new_db_name) . ".* to ".$db_user."@% identified by '".$user_pass."'";
    $rs = exec_query($sql, $query );

Apparenty, PDO class doesn't work fine .

[joximu]

"Query was empty" when login...
please check if you have the table subdomain_aliases in your db.

Code:

CREATE TABLE `subdomain_alias` (
  `subdomain_alias_id` int(10) unsigned NOT NULL auto_increment,
  `alias_id` int(10) unsigned default NULL,
  `subdomain_alias_name` varchar(200) collate utf8_unicode_ci default NULL,
  `subdomain_alias_mount` varchar(200) collate utf8_unicode_ci default NULL,
  `subdomain_alias_status` varchar(255) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`subdomain_alias_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[ceco91]

No such problem detected. I've received a mail fromr ispCP with critical error:

Code:

Hey There,

I'm the automatic email sent by on your www.hosting-zone.eu (95.87.7.77) server.

A critical error just was encountered while executing function mysqldb_quota_by_mysql_engine() in /var/www/ispcp/engine/quota/ispcp-dsk-quota

Error encountered was:

========================================================================
Database '2_test' exists only in table 'sql_database'!!!
========================================================================

[BeNe]

Looks like the Database '2_test' exists only in table 'sql_database' but not in the MySQL DB itself. Someone delete them via PHPMyadmin and not in ispCP.

Greez BeNe

[ceco91]

The `subdomain_alias`is fine. Other ideas.

[joximu]

Set PHP to log errors. Hopefully this brings more infos...

/J