Subject Re: [firebird-php] It works!! PHP+Firebird (1.0) in Linux Fedora Core 2.
Author Helen Borrie
At 08:32 AM 23/05/2004 +0100, you wrote:
>Kamus wrote:
>
> > I have working Php and Firebird "1.0". With 1.5 it fails for me.
>
>OK That is a good starting point.
>
> > 10.- Start or Restart (if it running) Apache Server
> >
> > # service httpd start
>
>Usefull check at this point - phpinfo() - which engine does it show when
>switching to 1.5
>
> > 11.- Create the following script:
> >
> > <?
> > $cnx = ibase_connect("localhost:/opt/interbase/examples/employee.gdb",

localhost:/opt/firebird/examples/employee.fdb
Note, different location, different database file name.

> > "sysdba","masterkey"); //this in one line

Not masterkey. Look in the firebird root dir for a file named
SYSDBA.password. That contains the auto-generated password. You can
change it if you want, using the shell script (chgDBAPassword) or gsec.

> > $sql = "select * from customer";
> > $res = ibase_query($sql);
> > while ($fila = ibase_fetch_row($res)) {
> > echo $fila[0].' '.$fila[1].'<br />';
> > }
> > ?>

You may also need to do some stuff about permissions. The firebird user
(or firebird group) needs to have rwx permissions on the directories where
databases reside.

Also, with Fedora you will need to disable the NPTL thread
library. Directions for doing that are in the release notes, in the Linux
installation section. (A build with NPTL support will be available with
the 1.5.1 release).

Helen