problems creating a db in freeBSD

Dev Shed Forums Sponsor:

February 6th, 2004, 02:47 PM

zapa

Mentat of IX

Join Date: Mar 2003

Location: Bucuresti / Toronto

Posts: 112

Time spent in forums: 29 sec
Reputation Power: 6

problems creating a db in freeBSD

Hey ppl ,
So I have used FirebirdSQL with Windows XP and had no problems with it , however my platform of choice for such things is freeBSD therefore I am now trying to get it working in there .

Unfortunately , I can't seem to be able to create a database in freeBSD here are some messages :

Code:

SQL> create database 'f.gdb';
Statement failed, SQLCODE = -902

operating system directive semget failed
-No such file or directory
SQL> create database 'localhost:/usr/proj/test.gdb';
Statement failed, SQLCODE = -902

Unable to complete network request to host "localhost".
-Failed to establish a connection.
-Connection refused
SQL> create database '/usr/proj/test.fdb';
Statement failed, SQLCODE = -902

operating system directive semget failed
-No such file or directory

__________________
FreeBSD , dooing more with less since 10 years ago

February 8th, 2004, 03:33 PM

mariuz

Bug Hunter

Join Date: May 2003

Location: Transylvania (Romania)

Posts: 277

Time spent in forums: 20 h 48 m 14 sec
Reputation Power: 9

firebird server is runing ?

telnet localhost 3050
and take a look in the logs ...
any messages ?

February 8th, 2004, 03:41 PM

mariuz

Bug Hunter

Join Date: May 2003

Location: Transylvania (Romania)

Posts: 277

Time spent in forums: 20 h 48 m 14 sec
Reputation Power: 9

from Firebird 1.0 FreeBSD Release Notes

Quote:

Firebird is installed SUID with owner and group `firebird'.
This does affect where you can and cannot create databases when
connecting remotely, as well as which existing databases you can
access. If you want a database to be available remotely, be sure
it's readable and writeable to group firebird.

There may be times when you manage to get your system into a
state where using any of the Firebird utilites (isql, gbak, gsec,
etc.) gives you the message "semget failed". One surefire way to
do this is to build and install the port.

If this happens,
make sure that the lock manager is not running and its semaphores
have been removed. The former can be accomplished with 'ps ax
|grep gds' and 'kill'; the latter with 'ipcs -s' and 'ipcrm -s'.

For example, after building and installing the port, you will
probably go through something like this:

# isql /usr/interbase/isc4.gdb
Statement failed, SQLCODE = -902

operating system directive semget failed
-No such file or directory

# ipcs -s
Semaphores:
T ID KEY MODE OWNER GROUP
s 1310720 252034728 --rw-rw-rw- root wheel

# ipcrm -s 1310720

and you should be in business.

Once this is done, you should be able to connect normally to
databases. Your first connection will restart the lock manager.

There may be times, however, when you still get "semget failed"
even though the lock manager is not running and the semaphores have
been cleaned up. There seems to be a conflict with this release
and the PostgreSQL 7 release as installed from the ports collection.
If you're having trouble with Firebird and you're running PostgreSQL,
try stopping PostgreSQL:

/usr/local/etc/rc.d/pgsql.sh stop

and see if that helps.

Super Server support has recently been added. However, there is
anecdotal evidence that it is not as reliable nor as scalable as the
Classic Server version. For this reason, I have not included a
start up method for Super Server. For those that are interested,
traversing to /usr/interbase/misc will find the startup scripts for
the various flavours of Linux.

February 9th, 2004, 09:16 AM

zapa

Mentat of IX

Join Date: Mar 2003

Location: Bucuresti / Toronto

Posts: 112

Time spent in forums: 29 sec
Reputation Power: 6

ah thanx ...

i'm curently running postgreSQL and there is a good chance that's what the problem is , i'll look into it right away

Viewing: Dev Shed Forums > Databases > Firebird SQL Development > problems creating a db in freeBSD

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump

Free IT White Papers!

How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.

Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.

Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.

Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.

Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.

More Free IT White Papers!