--- In firebird-php@yahoogroups.com, Milan Babuskov <albis@e...> wrote:

> vengfulsquirrel wrote:
> > The following commands work correctly:
> > /opt/firebird/bin/isql connect '/opt/firebird/examples/employee.fdb'
> > /opt/firebird/bin/isql connect
> > 'localhost:/opt/firebird/examples/employee.fdb'
> >
> > But
> > /opt/firebird/bin/isql connect
> > '192.168.2.4:/opt/firebird/examples/employee.fdb'
> > does not work and prints error: "connection rejected by remote
> > interface".
>
> Try with -user and -pass switches, something like this:
>
> isql -user sysdba -pass *******
> 192.168.2.4:/opt/firebird/examples/employee.fdb
>
>
> > The logfile has these 2 entries like 10 times.
> > /opt/firebird/firebird.log:
> > slinux2 Sat Nov 29 12:13:05 2003
> > SERVER/process_packet: connection rejected for root
> >
> > slinux2 Sat Nov 29 12:13:05 2003
> > SERVER/process_packet: connect reject, server exiting
>
> AFAIK, that's because when you enter 192.168.2.4 it isn't a "local"
> connection anymore, so you must supply username/password.
>
> > Will apache need to connect through 192.168.2.4 and not localhost?
>
> If apache (PHP) is on the same computer, than it doesn't matter. You

can

> connect with either of these.
>
> --
> Milan Babuskov
> http://fbexport.sourceforge.net

Okay it works now using -user and -pass
/opt/firebird/bin/isql connect -user sysdba -pass ******
'192.168.2.4:/opt/firebird/examples/employee.fdb'
/opt/firebird/bin/isql connect -user sysdba -pass ******
'192.168.2.4:/opt/firebird/anecesis.fdb

downloaded php-4.3.4.tar.gz
%tar -zxvf
In accordance to http://bugs.php.net/bug.php?id=23928
I edited ./ext/interbase/php_interbase.h
added #define ISC_FAR
Then
%export LIBS="-lstdc++ -lcrypt"

Here is what I configured php4 with:
./configure --prefix=/usr/share --datadir=/usr/share/php
--bindir=/usr/bin --libdir=/usr/share --includedir=/usr/include
--sysconfdir=/etc --with-_lib=lib --with-config-file-path=/etc
--with-exec-dir=/usr/lib/php/bin --disable-debug
--enable-inline-optimization --enable-magic-quotes --enable-safe-mode
--enable-track-vars --enable-versioning --with-ftp --with-iodbc
--with-jpeg-dir=/usr --with-mcrypt --with-mhash --with-png-dir=/usr
--with-xml --with-openssl --with-curl --with-imap-ssl
--with-apxs=/usr/sbin/apxs --with-interbase=shared,/opt/firebird
i586-suse-linux
Then: make, make install

if(!($dblink = ibase_connect("/opt/firebird/anecesis.fdb",
"SYSDBA","******"))){
print("Cannot Connect.");
exit();
}

If I install php with --with-interbase=shared,/opt/firebird
and restart apache I get this error. The php.ini file is not even in
/etc should it be?,php IS working but the modules obviuosly is not.

Fatal error: Call to undefined function: ibase_connect() in
zaddplant.php on line 47

If I install php with --with-interbase=/opt/firebird
and restart apache I get this error. The php.ini file is still not in
/etc.
Warning: ibase_connect(): operating system directive open failed
Permission denied in zaddplant.php on line 47
Cannot Connect

Now I tried copying the php.ini-dist file into /etc but none of the
settings I gave through configure are set. Does php automatically set
these or not? Because it is not setting them, ie safe-mode is not set
to on and neither are magic-quotes.

What is the advantage of compiling firebird as a module?

One more thing, should I just recompile apache from source too because
I am using the SUSE rpm, which has mod_python and mod_perl installed
already, I would have to install everything from source.

Note: I am trying to access the apache server from a browser on a
seperate machine if that makes any difference, but php/apache/firebird
are all on the same machine, ie 192.168.2.4.

Thanks for the help.

-Ian