1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

application vault & mysql_connect

Discussion in 'Plesk for Linux - 8.x and Older' started by teckna, Nov 14, 2008.

  1. teckna

    teckna Basic Pleskian

    25
    73%
    Joined:
    Nov 17, 2006
    Messages:
    53
    Likes Received:
    0
    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
     
  2. teckna

    teckna Basic Pleskian

    25
    73%
    Joined:
    Nov 17, 2006
    Messages:
    53
    Likes Received:
    0
    ps. i can manually create a mysql database and connect to it externally.
     
  3. Amin Taheri

    Amin Taheri Golden Pleskian Plesk Certified Professional

    33
     
    Joined:
    Jul 5, 2007
    Messages:
    1,398
    Likes Received:
    1
    Location:
    Seattle Area
    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?
     
  4. teckna

    teckna Basic Pleskian

    25
    73%
    Joined:
    Nov 17, 2006
    Messages:
    53
    Likes Received:
    0
    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
     
Loading...