Forum > Databases
[Solved] Firebird installation problems on Ubuntu
Dibo:
Hi,
My favorite database on Windows was the Firebird. Simple to install, no configuration. But installation Firebird on Ubuntu is a nightmare. When I try to install version 2.0 or 2.1 with Synaptic, I have dependency errors at the end of the installation packages. So I decided to install version directly from the FireBird page. I downloaded RPM version and converted to DEB using the ALIEN. The installation went without problems. I see the installed package in Synaptic but I'm not entirely convinced that Firebird running. I installed FlameRobin (the SQL manager for FireBird). When I try to connect to the database I have this error:
--- Quote ---*** IBPP::SQLException ***
Context: Database::Connect
Message: isc_attach_database failed
SQL Message : -902
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements
Engine Code : 335544721
Engine Message :
Unable to complete network request to host "localhost".
Failed to establish a connection.
Connection refused
--- End quote ---
Regards
clauslack:
What version do you intall?
First
Check if Firebird is running...
--- Code: ---xxx@xxxx:~$ ps aux|grep fbserver
"show that ->"
firebird 1488 13.2 1.9 113228 19660 ? Jan03 2392:33 /opt/fb21ss/bin/fbserver
--- End code ---
or
the listen port 3050
--- Code: ---xxx@xxxx:~$ netstat -an | grep 3050
"show that ->"
tcp 0 0 0.0.0.0:3050 0.0.0.0:* LISTEN
--- End code ---
- check firebird.log
--- Code: ---xxx@xxxx:~$ cat /opt/fb21ss/firebird.log
--- End code ---
If not running, try to run (maybe as root, for test)
/opt/fb21ss/bin/fbserver
or
/etc/rc.d/rc.firebird start
and look the errors.
Maybe you have diferents paths(/opt/firebird)
Regards
Dibo:
--- Quote ---What version do you intall?
--- End quote ---
2.1.3 for 64bit Linux
--- Quote ---Check if Firebird is running or the listen port 3050
--- End quote ---
Netstat does not show nothing ont this port so I think that the Firebird server is not running.
--- Quote ---If not running, try to run (maybe as root, for test)
/opt/fb21ss/bin/fbserver
or
/etc/rc.d/rc.firebird start
--- End quote ---
I don't have this files :( . In /opt/firebird/bin I have only:
--- Quote ---changeDBAPassword.sh
changeGdsLibraryCompatibleLink.sh
changeRunUser.sh
createAliasDB.sh
fb_config
fb_inet_server
fb_lock_mgr
fb_lock_print
fbsvcmgr
gbak
gdef
gds_drop
gfix
gpre
gsec
gsplit
gstat
isql
nbackup
qli
restoreRootRunUser.sh
--- End quote ---
When I try to connect to the database with Flamerobin, in the log appears lines:
--- Quote ---xxx-xxxx-xxx (Client) Sat Jan 16 18:19:00 2010
INET/inet_error: connect errno = 111
--- End quote ---
Maybe converted RPM file is badly installed?
gandergz:
1 - During installation, a new user called firebird is created.
2 - All action FB do is performed by that user
3 - You must (as root) give read/write rights for that user in some directory (the recomended is /var/firebird)
4 - From now, you can use Flamerobin in order to create databeses etc.
5 - Optionally (but strongly recommended) edit aliases.conf in the /opt/firebird directory and create some new alias
6 - Read the release notes.
clauslack:
You install the Firebird Classic Server.
Look at
http://www.firebirdsql.org/manual/qsg2-classic-or-super.html
This use inetd or xinetd for run.
If you choose classic, try to install
FirebirdCS-2.1.3.XXXX.i686.tar.gz, this come with an install.sh script.
Maybe the RPM not installed fine.
Or SuperServer Version, this run standalone, tar.gz come with install.sh script too.
Regards.
Navigation
[0] Message Index
[#] Next page