RE: [cobalt-developers] Interbase on the Raq 550 + PHP

["Studds McButt" <studds@xxxxxxxxxxxx>]

Thanks for your insights. 

The reson for using Interbase in the first place is that it runs out of
the box on the raq4 and it ran fine for the past few years. After
migrating to the raq 550, the same databases work OK with IBManager, so
from what you say this means that the raq550 includes the Super Server
version. There is no mention of this version issue in the Raq 550
manual. 

In any event, I can use IBManager to open the databases, view the data,
and manipulate the database. From the commend line, I change users and
passwords using GSEC. So I'm not having any problem with the database
itself, I just can't access it from PHP, because of the "cannot attach
to password database" issue. The password database, isc4.gdb, may be
located in a place where PHP is not looking for it, but I can't find any
explanation of this problem. 

Under the circumstances, the quickest solution might be to switch to
mySQL, since it seems to be much more thoroughly documented. I undersand
the advantages of Firebird in principle, but as I said, the only reason
for using Interbase in the first place was that it was simple. That was
then, this is now, and I think I'll move on. 

Thanks again

Ken 



-----Original Message-----
From: cobalt-developers-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-developers-admin@xxxxxxxxxxxxxxx] On Behalf Of William L.
Thomson Jr.
Sent: Tuesday, August 26, 2003 8:11 PM
To: Cobalt Developers Group
Subject: Re: [cobalt-developers] Interbase on the Raq 550 + PHP


Ok,
	Without getting to deep off hand there are two version of
InterBase/Firebird. Classic and Super Server.

Classic creates a new process each time a connection is made to the
database. It can be used in SMP systems. However you can't use any
graphical interface with it. Only the command line tools.

Super Server is a multi-threaded version which may have less threads
than connections or more. However it can not be used on SMP systems and
is best for single proc systems. Super Server does allow connections to
it via graphical interfaces. It has an API that the Classic Server
lacks.

So you have two choices. Develop the db on a machine with Super Server
if you want to use a GUI like IBConsole, IBManager, IBAccess, etc. Then
backup and restore the db on your Cobalt.

Otherwise look into upgrading or installing the Super Server edition.

Also FYI, if you are using Open Source InterBase, you should really
switch to Firebird for too many reasons for me to go into.

http://firebird.sourceforge.net/

If you have further questions or problems let me know. You can also
subscribe to the fb-support group on Yahoo.

-- 
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios, Inc.
http://www.obsidian-studios.com

_______________________________________________
cobalt-developers mailing list cobalt-developers@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-developers