Topic: Firebird Data Base installation

[jibe]

Hi,

The upgrade to a later version of PHP is fairly painless (so long as you stay with PHP 4.???).

My problem is I cannot try for now (no possibility for me to have a server for tests. I should have one or two months later...) So, I don't know who is right : you saying that there is no problems, or those who got problems (some lost their server-manager) as they say in several posts (see links upper).

Could you please give the links to the topics and scripts you used to successfully upgrade your PHP ? Maybe those who experienced problems did not use the right ones ?

@Jader :
As you confirm that you installed version 1.0.3, I think that this version can work with older libraries and those installed on SME are good. So, you could have problems if you install 1.5 version. But let's see if TrevorB gives us a good solution to upgrade correctly the libraries !

[Jáder]

I´ll try to test Firebird 1.5 on 6.01 this weekend or monday (here in my town, monday will be holiday!).

I´ll let you know any news!

[jibe]

Hi,

Ok, jader ! Thanks and good luck !

[mdo]

Hi,

was there ever a result with that? Did someone get this going (Firebird 1.5 on SME 6.x)? We would need that for an installation and any help is appreciated.

Thanks,
Michael

[Jáder]

Hi

I was able to install FB1.5 on SME 6.01-01 but that server never got into production... so I´m not sure it works.
I have to install some packages by --force ... I do not remember which ones... but I can track them.
BTW I´m trying to put that server in production this week... but I´m out of luck because a "technician" mess with my installation (my client give the root password to a newbie who was learning linux!).
I´ll try to fix the installation (to avoid to have reinstall everything!)... or if impossible... try to duplicate that I did... and I´ll let you know.
I´ll work on this on weekend, so please if you don´t have any news from me till Monday, just write a note here again.

[eiceic]

I just saw this thread and thought I'd attach my notes for getting version FB 1.5 installed on SME 6.01

#1  Make an IBay called firebird and map it to your windows workstation
-- download the following files from the internet (let me know if you can't find) and drop them in that ibay (in the /files subdir)

libgcc_s-3.2-1.i386.rpm
ibstdc++-3.2-1.i386.rpm
FirebirdSS-1.5.0.4290-0.i686.tar.gz

#2  From the web browser/server-manager  -- go to the
security/remote access section and allow Secure Shell Access from local
networks  and Allow Command Line over secure shell

#3  Get a telnet program that can do SSH like
http://www.chiark.greenend.org.uk/~sgtatham/putty/ and then connect to
your linux box using the SSH protocol

#4  From the telnet login screen, login as "root" user with whatever
your admin password is.   You should now be at a root linux prompt.

#5  Follow these linux commands at the command prompt

cd /home/e-smith/files/ibays/firebird/files
rpm -ivh libgcc_s-3.2-1.i386.rpm
rpm -ivh libstdc++-3.2-1.i386.rpm
cp FirebirdSS-1.5.0.4290-0.i686.tar.gz /usr/local
cd/usr/local
tar -zxvf FirebirdSS-1.5.0.4290-0.i686.tar.gz
cd FirebirdSS-1.5.0.4290-0.i686
./install.sh
ln -s /etc/rc.d/init.d/firebird /etc/rc.d/rc7.d/S96firebird


***  Now you should have an operation firebird/linux server -- you can
test locally by doing the following

cd /opt/firebird/bin
./isql -user sysdba -password (whateveryoupicked)


Enjoy,

Chris Buechler

[jibe]

Hi Chris,

Thanks for your post !

I found an easier method to do that, but finally it's almost the  same. I wrote a script to do that. Those who want to install Firebird can download it.
Some more details on the SMERP forum.

[Jáder]

Finally I got my server on production.
I still need to put php-interbase rpm to work.
Last time I do a --nodeps to install.
Now I open a new thread to ask for a new package.

Thank you Jibe by your script. I think you should post it here on forum (maybe on this topic!) to avoid to loose it on a reformat/HDD problem!

[jibe]

Hello,

I think you should post it here on forum (maybe on this topic!) to avoid to loose it on a reformat/HDD problem!

Hey, I don't reformat my HDD everyday   And it's on m'y ISP server, there is few risks and anyway I have also one copy on my server and another on my development computer, plus the backups of each  

But you're right : I can publish it here.

Code: [Select]

wget http://www.haoli.org/rpm/redhat-7.x/RPMS/i386/libgcc_s-3.2-1.i386.rpm
wget http://www.haoli.org/rpm/redhat-7.x/RPMS/i386/libstdc++-3.2-1.i386.rpm
wget http://switch.dl.sourceforge.net/sourceforge/firebird/FirebirdSS-1.5.2.4731-0.i686.rpm
rpm -ivh libgcc_s-3.2-1.i386.rpm
rpm -ivh libstdc++-3.2-1.i386.rpm
rpm -ivh FirebirdSS-1.5.2.4731-0.i686.rpm
ln -s /etc/rc.d/init.d/firebird /etc/rc.d/rc7.d/S96firebird


Note that with these versions of libraries, I got no problems with PHP. But I do have if I install the last version (3.3 if I remember well).

But I don't use Firebird with PHP. I use it with C++ programs only. So, sorry, Jáder, I can't help you for using Firebird with PHP.

[Jáder]

Hi Jibe

I got Firebird support on PHP (a --nodeps again).
But Erginoz kindly released a new version of PHP RPMs wit Firebird support!

watch it here: http://forums.contribs.org/index.php?topic=28405.0

And I´m happy you don´t have to reformat your HDD very often. Good luck to you!

Bye

Jáder

[jibe]

Hi,

Thanks, jader !

I don't use Firebird with PHP, but your last post will surely be interesting for other people. Pls let them know if all works fine : ergozd asks for feed back...