| Subject | Re: [firebird-support] Fbguard & fbserver |
|---|---|
| Author | Helen Borrie |
| Post date | 2006-01-15T23:33:30Z |
At 09:32 AM 16/01/2006 +1100, you wrote:
instead to connect to the database. (gstat reads the database file, but it
doesn't connect to a server as a client...)
server automatically. ps -aux |grep fb
should show that the fbserver process is running. However, no database
file will be open until a client actually connects.
Unlike gstat, isql (which must be fully path-qualified, or otherwise run
from the ../firebird/bin directory using the dot-slash convention) *is* a
client program.
However, I wonder whether you are trying to make a local connection to
fbserver. This isn't possible - you must use a network path.
If you want to connect locally, you'll need to make sure that the localhost
loopback server is properly configured in the hosts file; or,
alternatively, you can use the IP address 127.0.0.1.
permissions. In Fb 1.0, fbserver ran under root; in Fb 1.5, it runs as a
user named firebird. If you used the installer, it will have taken care of
the firebird user's permissions to the server files; however, for database
files, it's necessary to give rwx perms to the directory tree where the
database resides and rw perms to the actual database file.
The most elegant way to do this is to create a firebird group, make the
firebird user a member, and then assign the permissions to the group. That
way, if you have another user who needs privileges for the database files,
you can just add that user to the group.
Read the release notes, please!
./heLen
>I ran gstat on the database and it suggests that the db is not open orInstead of using gstat to determine whether "the server is running", try
>running although the fbguard service is running.
instead to connect to the database. (gstat reads the database file, but it
doesn't connect to a server as a client...)
>I killed anything relating to firebird in the process list and re-ranIt isn't necessary at all. As soon as fbguard starts up, it starts the
>fbguard& , then run gstat and the db then says open for business.
>I would prefer that after starting my fedora server that I didn't have to
>go through this startup routine.
server automatically. ps -aux |grep fb
should show that the fbserver process is running. However, no database
file will be open until a client actually connects.
Unlike gstat, isql (which must be fully path-qualified, or otherwise run
from the ../firebird/bin directory using the dot-slash convention) *is* a
client program.
However, I wonder whether you are trying to make a local connection to
fbserver. This isn't possible - you must use a network path.
If you want to connect locally, you'll need to make sure that the localhost
loopback server is properly configured in the hosts file; or,
alternatively, you can use the IP address 127.0.0.1.
>I have another fedora core 4 server running fb 1.02 which starts up on...as does Fb 1.5.x. But with 1.5 you *must* take care of filesystem
>reboot and opens the db automatically.
permissions. In Fb 1.0, fbserver ran under root; in Fb 1.5, it runs as a
user named firebird. If you used the installer, it will have taken care of
the firebird user's permissions to the server files; however, for database
files, it's necessary to give rwx perms to the directory tree where the
database resides and rw perms to the actual database file.
The most elegant way to do this is to create a firebird group, make the
firebird user a member, and then assign the permissions to the group. That
way, if you have another user who needs privileges for the database files,
you can just add that user to the group.
Read the release notes, please!
./heLen