R: Re: [firebird-support] FB 3.0 and PHP connection
Hi, I made a fresh installation about Firebird, with flag on gnerate gds32.dll library, and everythings works fine! Thanks for support.Best Regards Messaggio originale Da: 'Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support] Data: 26/04/2016 17.36 A: 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: 'palbe...@libero.it' palbe...@libero.it [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: getMessage() . ""; } 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: "palbe...@libero.it" 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! ++ -->
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: 'palbe...@libero.it' palbe...@libero.it [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: getMessage() . ""; } 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: "palbe...@libero.it" -- 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! -- ++
Re: [firebird-support] FB 3.0 and PHP connection
I had to copy the FBCLIENT.DLL from the Firebird installation directory to the Apache/bin directory for the PDO stuff to work. This however is dependent on your setup. Also remember to use correct 32bit or 64bit version of the DLL, depending on your Apache. Regards, Kim From: "'palbe...@libero.it' palbe...@libero.it [firebird-support]" To: Sent: 4/26/2016 4:47 PM 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: getMessage() . ""; } 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
[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: getMessage() . ""; }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