Subject Re: [firebird-support] FB 3.0 and PHP connection
Author Ismael L. Donis Garcia
Post date 2016-04-26T15:36:51Z

which authentication method you are using on the server?
 
Test with:
Legacy Authentication
If you do not intend to use SRP encrypted log-ins right away and want to use the security database—security3.fdb— as you have done in previous Firebird versions, proceed as follows:
Using a text editor, open firebird.conf and find the entry for the parameter UserManager:
#UserManager = Srp
Delete the “#” symbol and change the value to:
UserManager = Legacy_UserManager
Find the entry for the WireCrypt parameter:
#WireCrypt = Enabled (for client) / Required (for server)
Delete the “#” symbol and change the value to:
WireCrypt = Disabled
Find the entry for the AuthServer parameter:
#AuthServer = Srp, WinSspi, Legacy_Auth
Delete the “#” symbol and change the order of the arguments:
AuthServer = Legacy_Auth, Srp, WinSspi
Find the entry for the AuthClient parameter:
#AuthClient = Srp, WinSspi, Legacy_Auth
Delete the “#” symbol and change the order of the arguments:
AuthClient = Legacy_Auth, Srp, WinSspi
Save the changes.
Stop and restart Firebird for the changes to take effect.
Legacy Passwords
The old masterke password is available for your first login as SYSDBA. It is known to the whole world and should be changed as soon as possible.
Reminder: Legacy authentication reads only the first 8 characters of any password.
 
Best Regards
========
| ISMAEL |
========
----- Original Message -----
Sent: Tuesday, April 26, 2016 9:47 AM
Subject: [firebird-support] FB 3.0 and PHP connection

 

Hi all,
 I'm working on the evaluation of Firebird SQL 3.0 and connection using PDO available in PHP.

The database works fine and I'm able to connect it using FlameRobin but when I try to establish a connection using PHP I get a NULL as result of the follow:

<?
$SERVER  = "firebird:dbname=localhost:C:\Database\UUP.GDB";
$USERID   = "SYSDBA";
$PASSWORD = "masterkey";

try {
$dbh = new PDO($SERVER, $USERID, $PASSWORD);
 
} catch (PDOException $e) {

   print "Error!: " . $e->getMessage() . "<br/>";
   
}
var_dump($dbh);
?>

PHP load fine the PDO and PDO_Firebird, does anyone knows if I have to move some DLL somewhere?

NOTE: Windows 2012 R2, PHP Version 5.2.12, Apache 2.2, Firebird 3.0

Thanks in advance.
Alberto


Posted by: "palberto@..." <palberto@...>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1)
 
Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++