----Messaggio originale----
Da: 'Ismael L. Donis Garcia' slibre@... [firebird-support] <firebird-support@yahoogroups.com>
Data: 26/04/2016 17.36
A: <firebird-support@yahoogroups.com>
Ogg: Re: [firebird-support] FB 3.0 and PHP connection

 



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 -----

From: 'palberto@...' palberto@... [firebird-support]

To: firebird-support@yahoogroups.com

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!

---

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++