Subject | Re: [firebird-php] It works!! PHP+Firebird (1.0) in Linux Fedora Core 2. |
---|---|
Author | Helen Borrie |
Post date | 2004-05-23T09:05:32Z |
At 08:32 AM 23/05/2004 +0100, you wrote:
Note, different location, different database file name.
SYSDBA.password. That contains the auto-generated password. You can
change it if you want, using the shell script (chgDBAPassword) or gsec.
(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
>Kamus wrote:localhost:/opt/firebird/examples/employee.fdb
>
> > 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",
Note, different location, different database file name.
> > "sysdba","masterkey"); //this in one lineNot 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";You may also need to do some stuff about permissions. The firebird user
> > $res = ibase_query($sql);
> > while ($fila = ibase_fetch_row($res)) {
> > echo $fila[0].' '.$fila[1].'<br />';
> > }
> > ?>
(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