application vault & mysql_connect

[teckna]

We have plek 8.01 server and have just installed Plesk 8.6 on a new server.

Everything seems to be ok exept if you try and install something from the application vault that uses mysql.

Here is the Oscommerce error,
"Warning: Site application installation failed:
Fatal error: Call to undefined function: mysql_connect() in /var/www/vhosts/andycaisey.co.uk/vault_scripts/oscommerce/scripts/db-util.php on line 66"

others are all "line 66" whcih is:

function mysql_db_connect($dbaddress, $dblogin, $dbpassword, $dbname)
{
if(!mysql_connect($dbaddress, $dblogin, $dbpassword)) <---------------LINE66
{
print "Unable to connect to DB: " . mysql_error() . "\n";
exit(1);
}

if(!mysql_select_db($dbname))
{
print "Unable to select $dbname database: " . mysql_error() . "\n";
exit(1);
}
}

I need to buy new licences next week but cant if this fails for mysql application vaults.

Ubunt 6.06
php -v
PHP 5.1.2 (cli) (built: Jul 23 2008 17:01:53)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies

php4 -v
PHP 4.4.2-1build1 (cli) (built: Apr 6 2006 09:44:32)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies

php5 -v
PHP 5.1.2 (cli) (built: Jul 23 2008 17:01:53)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies

any other info required?

thanks

Andy @ Teckna

 

[teckna]

ps. i can manually create a mysql database and connect to it externally.

 

[Amin Taheri]

Is this site running in php4 or php5? how is it running (apache module, fcgi, etc). What version of mysql do you use? have you tried using mysqli php extension instead of mysql?

 

[teckna]

hi .. strange how life hits you !! I had to rebuild the server due to another problem, 2nd time around this problem did not occur.

so, mrk it down to USER error !

thanks for asking

ANdy