Topic: installing firebird 1.5.3 on sme

[audie]

I am new to this linux thing and am realy impressed with sme
tried to install firebird 1.5 on the sme server no for two days and have decided I need help.

I get the firebird installed after installing dependencies.

But i don't seem to get it running
the problem is as follows
the firebird rpm installs it to /opt/firebird with user rights for firebird user
then it installs a script to start it in /etc/xinetd.d called firebird
Now if i undersatand it correctly this means than the moment someone tries to connect it will make sure that the service is running

so I tried    ./etc/xinetd.d/firebird start - and got permision denied
I added a user firebird and got the same result

Then i opened the script and changed user = firebird to user=root
and no success
desperate now
Then i did  chmod -R 7777 on the firebird directory in /opt
 
this trial and error has me
I NEED help -a step by step ?

[Jáder]

Hi

I have done FB 1.5 work on a SME6 some time ago. I think was FB SS
I´d like to know what package of FB do you try to install?
What version and from where do you download it?
What dependencies do you installed?

I suggest you to remove FB rpm and install it again.
Then please post exact error messages... but do not try "fix" anything else by running chown/chmod command.

Very often a permission denied is just that: a wrong user or a missing eXecute permission

Jáder

I am new to this linux thing and am realy impressed with sme
tried to install firebird 1.5 on the sme server no for two days and have decided I need help.

I get the firebird installed after installing dependencies.

But i don't seem to get it running
the problem is as follows
the firebird rpm installs it to /opt/firebird with user rights for firebird user
then it installs a script to start it in /etc/xinetd.d called firebird
Now if i undersatand it correctly this means than the moment someone tries to connect it will make sure that the service is running

so I tried    ./etc/xinetd.d/firebird start - and got permision denied
I added a user firebird and got the same result

Then i opened the script and changed user = firebird to user=root
and no success
desperate now
Then i did  chmod -R 7777 on the firebird directory in /opt
 
this trial and error has me
I NEED help -a step by step ?

[CharlieBrady]

I am new to this linux thing and am realy impressed with sme
tried to install firebird 1.5 on the sme server no for two days and have decided I need help.

You are more likely to receive help if you ask your question in the correct forum.

[byte]

Moving this topic to the SME 7.x contribs forum, it is more appropriate there. Thanks!

[mdo]

Audie,

here are some notes that I took when installing firebird (version 1.5) on SME7.0:

(additional rpm required first):

yum install compat-libstdc++-33 --enablerepo=base

(Sorry, cannot remember where I downloaded the rpm from).

rpm -ivh /xx-path-to-rpm-xx/FirebirdSS-1.5.2.4731-0.i686.rpm

After that install, the firebird server should already be running (started).
To stop you can do:

/etc/init.d/firebird stop

or to start:

/etc/init.d/firebird start

To have the service started every time automatically at server start:

ln -s /etc/rc.d/init.d/firebird /etc/rc7.d/S96firebird

-------------------------------------
Hope this will help,
Michael

[audie]

The interesting thing is that when i did an rpm -ivh FirebirdSSnnn.rpm install
i could'nt uninstall there
<it doesnt run all the setup scripts>

After installing libstdc++.so.5  all the scripts worked and now my install works

this is how

So to install firebird 1.5 Super Server on a fresh SME 7.1 u need to install only
rpm -ivh  libstdc++.so.5
then
 add a group firebird
add  a user lnked to user
 then
 rpm -ivh firebirdrpm
then

create auto start
cd /etc/rc7.d/
ln -s  /etc/rc.d/initd.d/firebird S99firebird

Restart

netstat -l >see if it is listening on port 3050

cd /opt/firebird/bin

run script
./isql -user sysdba -password <password from /opt/firebird/SYSDBA.password>

connect localhost:employee.fdb ;

select * from sales; <remember the ';'
if it connects You are there

Thanx

for the help
Hope this will save someone two days

[SchulzStefan]

@audie

I want to migrate a firebird database from win to linux. Do you have any expierience? Is it possible to copy the database from the windows-server to the linux- (sme) server without running in trouble?

Thx for any reply

stefan

[mdo]

@audie

I want to migrate a firebird database from win to linux. Do you have any expierience? Is it possible to copy the database from the windows-server to the linux- (sme) server without running in trouble?

stefan

Yes it should work. We have done this a long time ago and the local (sales) people for that application were all scared (feeling more comfortable with Windows because "we know how this works" ...) but fortunately the product's core support people in AU were positive about it (which is/was very rare to get a positive answer when you inquire about something like this here "down under")

If you have the firebird server already installed and running, stop the service, then copy the database over from  Windows (a .gdb file?).
Then you need to set ownership ("firebird" probably) & group accordingly. Here it looked like this:

-rwxrw----    1 firebird firebird 69070848 Jan 18 07:49 XXXXXXX.GDB

Note: We kept the filename in capitals because this application somehow expected it that way.

At the end, (re)start the firebird service. This all worked very well here at that time, using this rpm: FirebirdSS-1.5.2.4731-0.i686.rpm

Hope that helps,
Michael