Postgres in 2.1 version

[mbrada]

Hello:

I have a production copy of phpSch... 1.2. It is working fine on postgres 8.4.

Now I am installing version 2.1 with the purpose of upgrade it. I saw the login form and get this error message when submit.

Fatal error: Call to undefined function mysql_connect() in /home/aulas/desa/lib/Database/MySQL/MySqlConnection.php on line 53

... even though, my configuration is:

$conf['settings']['database']['type'] = 'pgsql';
$conf['settings']['database']['user'] = 'myuser';        // database user with permission to the phpScheduleIt database
$conf['settings']['database']['password'] = 'XXX';
$conf['settings']['database']['hostspec'] = 'mypostgresserver';        // ip, dns or named pipe
$conf['settings']['database']['name'] = 'mydatabase';

The test version is in the same server as production version, so the questions are:

Works 2.1 with postgresql ?
Do I need to install something more ?

Thanx in advance !

Martin

[Nick]

At the moment phpScheduleIt is only configured to use MySQL. You can try this code to enable any MDB2 database. Change the GetDatabase() function on line 28 of /lib/Database/DatabaseFactory.php to:

Code:

public static function GetDatabase()
{
if (is_null(self::$_instance))
{
$databaseType = Configuration::Instance()->GetSectionKey(ConfigSection::DATABASE, ConfigKeys::DATABASE_TYPE);
$dbUser = Configuration::Instance()->GetSectionKey(ConfigSection::DATABASE, ConfigKeys::DATABASE_USER);
$dbPassword = Configuration::Instance()->GetSectionKey(ConfigSection::DATABASE, ConfigKeys::DATABASE_PASSWORD);
$hostSpec = Configuration::Instance()->GetSectionKey(ConfigSection::DATABASE, ConfigKeys::DATABASE_HOSTSPEC);
$dbName = Configuration::Instance()->GetSectionKey(ConfigSection::DATABASE, ConfigKeys::DATABASE_NAME);

if (strtolower($databaseType) == 'mysql')
{
self::$_instance = new Database(new MySqlConnection($dbUser, $dbPassword, $hostSpec,$dbName));
}
else
{
self::$_instance = new Database(new Mdb2Connection($databaseType,$dbUser, $dbPassword, $hostSpec,$dbName));
}

}

return self::$_instance;
}