[Solved] Firebird installation problems on Ubuntu lazarus / 16-Databases ---------------------------------------------------------------------- Dibo · 2010-01-16 11:12 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 Regards ---------------------------------------------------------------------- clauslack · 2010-01-16 13:50 What version do you intall? First Check if Firebird is running... Code: [Select]xxx@xxxx:~$ ps aux|grep fbserver "show that ->" firebird 1488 13.2 1.9 113228 19660 ? Jan03 2392:33 /opt/fb21ss/bin/fbserver or the listen port 3050 Code: [Select]xxx@xxxx:~$ netstat -an | grep 3050 "show that ->" tcp  0  0   0.0.0.0:3050       0.0.0.0:*    LISTEN - check firebird.log Code: [Select]xxx@xxxx:~$ cat /opt/fb21ss/firebird.log 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 · 2010-01-16 18:07 QuoteWhat version do you intall?2.1.3 for 64bit Linux QuoteCheck if Firebird is running or the listen port 3050Netstat does not show nothing ont this port so I think that the Firebird server is not running. QuoteIf not running, try to run (maybe as root, for test) /opt/fb21ss/bin/fbserver or /etc/rc.d/rc.firebird startI don't have this files . In /opt/firebird/bin I have only: QuotechangeDBAPassword.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 When I try to connect to the database with Flamerobin, in the log appears lines: Quotexxx-xxxx-xxx (Client)   Sat Jan 16 18:19:00 2010    INET/inet_error: connect errno = 111 Maybe converted RPM file is badly installed? ---------------------------------------------------------------------- gandergz · 2010-01-16 18:58 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 · 2010-01-16 20:21 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. ---------------------------------------------------------------------- Dibo · 2010-01-16 20:55 Ehh ... I am not an advanced user of ubuntu. I ran the second computer on which I have ubuntu too. Firebird installed from the repository without any bugs, everything works beautifully. Something spoiled on the first computer and I do not know how to now clean up. It began when I saw that synaptic have old version of firebird. So, I downloaded the .tar from the firebird page, and I tried to install manually by running the attached script. I received some errors so I decided get back. Only after that I decided to install an older version from the repository but I have dependencies errors when installing packages. I do not know how to unscrew everything now. I cleared cache /apt-get and /tmp directory, but nothing helped. I try again with install.sh script EDIT: Eureka!! . The whole cause has been on the version of Linux. I have amd64bit. I tried again to install the version from Firebird page using install.sh. Carefully read error messages. I had an error "error while loading shared libraries: libstdc++.so.5: can not open shared object file: No such file or directory". In Synaptic I found only version libstdc++.so.6 (probably this is the reason of crashed installation from the repository with depending errors). In google I found another person that had the same error message and a 64-bit versions of ubuntu, but there was no information to solve the problem. I search for .DEB packages of libstdc++.so.5 version and installed it (http://packages.debian.org/lenny/amd64/libstdc++5/download). Now install.sh script installed and executed without any problems. Netstat found Firebird on port 3050, FlameRobin connects to the database. It is too beautiful . But it cost me a whole Saturday. Aaaa and curiosity. I had a base which I crated on windows. FlameRobin throwing permission error to access to the file. I had to assign the owner to Firebird user (thanks gandergz for information about Firebird user, I quickly connected this problem with your information). I hope that this issue be useful to other users 64-bit computers. Thanks to everyone for help and motivation to solve the problem and sorry for my English. Regards