Hi,

my name is mikael, i'm from france and i'm looking for some help :)

i want to use firebird superserver on linux (suse 8.2 pro) with
ibWebAdmin
for the database and apache + php for the user-side.
There is what i've done :

in /usr/local/

# tar -xvf FirebirdSS-1.5.0.3737-0.RC4.i686.tar

then, i've made some changes in /usr/local/firebird/miniInstall.sh :
replacement in all lines of /etc/rc.d/init.d/ by /etc/init.d

in the original macro miniInstall.sh, there were the lines :

LinkLib /usr/local/firebird/lib/libfbclient.so.1.0.0 /usr/lib/libfbcl
ient.so.1.0.0
LinkLib /usr/lib/libfbclient.so.1.0.0 /usr/lib/libfbclient.so.1
LinkLib /usr/lib/libfbclient.so.1 /usr/lib/libfbclient.so
LinkLib /usr/local/firebird/lib/libib_util.so /usr/lib/libib_util.so

so i've changed the second and the third to :

LinkLib /usr/lib/libfbclient.so.1 /usr/lib/libfbclient.so.1
LinkLib /usr/lib/libfbclient.so /usr/lib/libfbclient.so

i also decided to desactivate (for the moment) the end line

/etc/init.d/firebird start

because i don't want to use the auto load of firebird yet and i got
some problems
with the firebird macro due to particular redhat/mandrake functions.
i'll come back
on it when the other troubles will be solved ;)

then, to start firebird :
in /usr/local/firebird/bin

# ./fbmgr.bin

IBMGR> // i got the prompt, all right

IBMGR> show

Host : localhost
User : SYSBDA

IBMGR>quit

# ./fbmgr.bin -start -forever // as written in firebird.initd

check $FIREBIRD/firebird.log file for errors
can not start server

so, in firebird.log :
ros093st389095 (Server) Fri Jul 25 10:29:18 2003
SERVER/process_packet: connection rejected for root

no surprise, because 'root' isn't a user defined fo firebird...

then :

# ./fbmgr.bin -start -forever -user SYSBDA -password masterkey

no permissions to perform operation

i've tried several other command, with fbserver and fbguard too, but
i'm still to
the same point, i just can't run the server. and, logically, gsec
and isql don't work :

Unable to complete network request to host "localhost".
Failed to establish a connection.
Connection refused
unable to open database

i've installed apache (httpd-2.0.47.tar) and php (php-4.3.2.tar)
too, and followed the
instructions found on both web sites. i make the administration
through Webmin 1.100,
everything runs quite well, even my test 'hello world !' ... great,
hu hu hu, i've done
something not totally wrong today :)

i've installed too ibWebAdmin [0.91], renamed index.html to
ibwa.html and copy all the
files and directories found in ibWebAdmin_0.91/
to /usr/local/apache2/htdocs/ since i
began i merely don't know how to make the link between ibwa.html in
htdocs/ to
database.php in /usr/local/ibWebAdmin_0.91/ through localhost...

then, in konqueror web browser :

http://localhost/ibwa.html

processed to :

http://localhost/database.php

and i got this error message [*]:

Your php installation misses the interbase support!
Recompile php and configure --with-interbase[=DIR]
or edit your php.ini to load interbase.so respectively interbase.dll.

i've edited /usr/local/lib/php.ini and added these lines :

extension_dir = "../firebird/lib"
extension_dir = "../firebird/UDF"

extension=fb_udf.so
extension=ib_udf.so
extension=libib_util.so
extension=libfbclient.so
extension=libfbclient.so.1
extension=libfbclient.so.1.0.0

since database.php require inc/script_start.inc.php and, in this
last files, i've
changed the lines

if (!in_array('interbase', get_loaded_extensions())) {
@dl('interbase.so') || @dl('interbase.dll');
}

to

if (!in_array('interbase', get_loaded_extensions())) {
@dl('libfbclient.so') && @dl('libfbclient.so.1') &&
@dl('libfbclient.so.1.0.0') && @dl('libib_util.so') || @dl
('interbase.dll');
}

i still got the error message [*] when loading database.php ...

by the way, i've also made the right changes in
inc/configuration.inc.php in order to
defines the paths where firebird superserver is installed.

So, this is a S.O.S. !
Can anyone give me some hints and helps me with these issues ?

when i used firebird on 2000, i had no such big problems and when i
used the file
firebird.super.1.5.rc3.tar i got some trouble with the libs, now
fixed in the new
version of firebirdSS for linux in miniInstall.sh by the LinkLib
function.

thanks for reading this text, i hope i'll receive a lot of
messages ;)

M.