Category: Technical Articles

[See remaining text…] 

Download a compressed snapshot of the Ports Collection into /var/db/portsnap.

# portsnap fetch

or update it
If you are running Portsnap for the first time, extract the snapshot into /usr/ports:

# portsnap extract

If you already have a populated /usr/ports and you are just updating, run the following command instead:

# portsnap update

enter firebird server ports directory

# cd /usr/ports/firebird25-server

compile and install firebird server

# make -DPACKAGE_BUILDING

# make install

enable it by adding

firebird_enable="YES"

we modify in

/etc/rc.conf

and start it with

#/usr/local/etc/rc.d/firebird start

logs and security2.fdb seems to be in /var/db/firebird

#/usr/local/bin/isql-fb

To create a new database

SQL> create database “tmp/first_database.fdb;

SQL> connect “/tmp/first_database.fdb” ;

Commit current transaction (y/n)?y

Committing.

Database: “/tmp/first_database.fdb”

SQL>

if you want to create a simple table then insert 1-2 rows and select from it here is one example

SQL> CREATE TABLE TEST (ID INT NOT NULL PRIMARY KEY, NAME VARCHAR(20));

SQL> show tables;

TEST

SQL> INSERT INTO TEST VALUES (1, ‘John’);

SQL> INSERT INTO TEST VALUES (2, ‘Joe’);

SQL> select * from test;

ID NAME

============ ====================

1 John

2 Joe

To quit the isql-fb console type quit

SQL> quit

CON>;

For a good open source GUI admin tool you might check the flamerobin administration tool included in ports repository can be installed by an simple

cd /usr/ports/databases/flamerobin/ && make install clean

To use firebird with php , you will need the php5 driver

#cd /usr/ports/databases/php5-interbase/ && make install clean

You can choose to compile php with apache support (I have choosen cli, cgi , and apache support)

check it if is enabled with

#/usr/local/bin/php -m

« Hide it