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! ++ -->
R: [firebird-support] Re: FB 3.0 and PHP connection
Hi, also with this format I've got the same result (=NULL) :-( Best Regards Messaggio originale Da: r...@graficalc.nl [firebird-support] Data: 26/04/2016 17.03 A: Ogg: [firebird-support] Re: FB 3.0 and PHP connection You could try separating the hostname from the database location (passing the hostname with host=). I have this:$conn = new PDO("firebird:host=$databasehost;dbname=$databasename;charset=utf8", $databaseuser, $databasepass); -->
[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
R: [firebird-support] CAST CHAR to INTEGER
I'm sorry, I understood... it work! Messaggio originale Da: firebird-support@yahoogroups.com Data: 29/07/2015 11.20 A: Ogg: [firebird-support] CAST CHAR to INTEGER Hi all, how can I make this cast in Firebrid 2.5.4 (if is it possible?) DECLARE VARIABLE QTA CHAR (5);DECLARE VARIABLE XYZ INTEGER; XYZ = cast(rtrim(ltrim(QTA))) as integer; Let me know, best regardsAlpe -->
[firebird-support] CAST CHAR to INTEGER
Hi all, how can I make this cast in Firebrid 2.5.4 (if is it possible?) DECLARE VARIABLE QTA CHAR (5);DECLARE VARIABLE XYZ INTEGER; XYZ = cast(rtrim(ltrim(QTA))) as integer; Let me know, best regardsAlpe
R: Odp: [firebird-support] Firebird 1.5.3 on Windows 2012 R2 Server
Hi, I developed a web application based on Interbase, Win98, PHP, Apache. During those yeas has been lightly updated with lase release of software, now the we application (10 users) use the follow: Microsoft Server 2012 (64bit)Apache 2.0PHP 5.4Firebird SQL 1.5 (3 databases, 250 Mbyte the bigger one) So Firebird SQL 1.5 and Microsoft Server 2012 (64bit), works very well !!! Regards Messaggio originale Da: firebird-support@yahoogroups.com Data: 30/06/2015 18.12 A: Ogg: Odp: [firebird-support] Firebird 1.5.3 on Windows 2012 R2 Server Hi, I know only one - cache problem Windows can eat too many RAM. Fixed in FB2.5 serie. Migration to 2.5 does not require 2.1 between. Buf you can get migration errors like ambigous field names and other Regards, Karol Bieniaszewski - Reply message - Od: "'Softtech Support' stwiz...@att.net [firebird-support]" Do: Temat: [firebird-support] Firebird 1.5.3 on Windows 2012 R2 Server Data: wt., cze 30, 2015 16:12 Greetings All, Can anyone tell me if Firebird 1.5.3 will run on Windows 2012 R2 Server? Our Delphi application has run since 1997 on one version or another of windows server. It is currently on Windows 2003 Server and we have had no issues at all. Our office is wanting to install a new server with Windows 2012 R2 and I need to know if there are any issues I should be aware of or if Firebird will install and run without any issues. Is there a place to go on the web that discusses this in depth (If necessary)? Thanks for anyone that takes there time to answer. If I'm ever given any breathing room, I would eventually like to move to Firebird 2.5.4 and would also like to know if I should move in stages like to 2.1 then to 2.5, etc. Any documentaion on that would be helpful as well. Thanks all, Mike This email has been checked for viruses by Avast antivirus software. www.avast.com -->
R: [firebird-support] Re: Firebird migration to increase perfomances
Hi, the release 2.5.4 have some performance upgrade vs the 1.5 release. Best Regards Messaggio originale Da: firebird-support@yahoogroups.com Data: 21/06/2015 14.05 A: Ogg: [firebird-support] Re: Firebird migration to increase perfomances If application works very well then don't fix it if it ain't broken ;-) If you really want to then upgrade to 2.5.4 and make the test by yourself by executing most time consuming queries. -->
[firebird-support] Firebird migration to increase perfomances
Hi all, some years ago I developed a web application based on Interbase, Win98, PHP, Apache. During those yeas has been lightly updated with lase release of software, now the we application (10 users) use the follow: Microsoft Server 2012 (64bit)Apache 2.0PHP 5.4Firebird SQL 1.5 (3 databases, 250 Mbyte the bigger one) The application works very well, but I'm asking to the mailing list if it possible to have more performance considering the database side without make a big software refactoring.Which release do you suggest? What will be the percentage of performances get? Thank's very much.AlPe