Subject Re: [firebird-php] It works!! PHP+Firebird (1.0) in Linux Fedora Core 2.
Author Dariusz Zelichowski
Finally I found time to experiment and, just like Helen
wrote, the SYSDBA.password file needs to be
changed/examined before a connection is attempted. That's
all. I didn't have to change any pesmissons or to disable
the NPTL thread.

In other words, the original instructions Julio posted work
OK. Tested under Mandrake 10 Official and I love the
aliasing.


--- Helen Borrie <helebor@...> wrote:
> 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
>
>





__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/