Различия
Здесь показаны различия между двумя версиями данной страницы.
| Предыдущая версия справа и слева Предыдущая версия Следующая версия | Предыдущая версия | ||
|
dev:ubuntu:firebird25 [2012/08/08 11:54] jamis7005 Enter your zip code here |
dev:ubuntu:firebird25 [2012/08/08 21:43] (текущий) jamis7005 |
||
|---|---|---|---|
| Строка 1: | Строка 1: | ||
| - | ====== How to install Firebird 2.5 on Ubuntu ====== | + | ====== Firebird installation on Ubuntu ====== |
| - | [[dev:ubuntu:firebird25_deb]] | + | [[dev:ubuntu:firebird25_deb]]\\ |
| - | [[dev:ubuntu:firebird25_tar]] | + | |
| - | [[dev:ubuntu:firebird25_src]] | + | |
| - | Source https://help.ubuntu.com/community/Firebird2.5 | + | [[dev:ubuntu:firebird25_tar]]\\ |
| - | ---- | + | |
| - | \\ | + | |
| - | In Ubuntu 10.10 Maverick Firebird 2.5.0 is included by default but is not the final release (just the Release Canditate imported from Debian at that time) | + | [[dev:ubuntu:firebird25_src]]\\ |
| - | The Firebird2.5 Final package (version 2.5.0) for Ubuntu 10.10 Maverick and 10.04 Lucid is located into this repository (ppa) | ||
| - | The repository must be added into sources.list , Here is the example for Maverick | + | http://www.firebirdsql.org/manual/ |
| - | + | ||
| - | sudo pico /etc/apt/sources.list.d/firebird.list | + | |
| - | + | ||
| - | and you should add these lines | + | |
| - | <file> | + | |
| - | deb http://ppa.launchpad.net/mapopa/ppa/ubuntu maverick main | + | |
| - | deb-src http://ppa.launchpad.net/mapopa/ppa/ubuntu maverick main | + | |
| - | </file> | + | |
| - | You need to import my gpg key | + | |
| - | + | ||
| - | sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com ea316a2f8d6bd55554c23f680be6d09eef648708 | + | |
| - | + | ||
| - | Then you need to update the cache repository | + | |
| - | + | ||
| - | sudo apt-get update | + | |
| - | + | ||
| - | Here is how you can inspect the firebird2.5 related packages | + | |
| - | + | ||
| - | apt-cache search firebird2.5-* | + | |
| - | + | ||
| - | Install the super server package (you will be asked about the SYSDBA password and what service to enable :Super Server , Classic or new SuperClassic ) | + | |
| - | <code> | + | |
| - | sudo apt-get install firebird2.5-super | + | |
| - | + | ||
| - | The following extra packages will be installed: | + | |
| - | firebird2.5-common firebird2.5-common-doc firebird2.5-dev firebird2.5-server-common libfbclient2 libib-util | + | |
| - | Suggested packages: | + | |
| - | libfbembed2.5 firebird2.5-examples firebird2.5-doc | + | |
| - | The following NEW packages will be installed: | + | |
| - | firebird2.5-server-common firebird2.5-super | + | |
| - | The following packages will be upgraded: | + | |
| - | firebird2.5-common firebird2.5-common-doc firebird2.5-dev libfbclient2 libib-util | + | |
| - | 5 upgraded, 2 newly installed, 0 to remove and 21 not upgraded. | + | |
| - | Need to get 5,442kB of archives. | + | |
| - | After this operation, 11.3MB of additional disk space will be used. | + | |
| - | Do you want to continue [Y/n]? y | + | |
| - | </code> | + | |
| - | + | ||
| - | Or install Classic or SuperClassic if you have more than one cpu (dual core or SMP machine) and want SMP support | + | |
| - | + | ||
| - | + | ||
| - | sudo apt-get install firebird2.5-classic | + | |
| - | or | + | |
| - | sudo apt-get install firebird2.5-superclassic | + | |
| - | + | ||
| - | You need to configure the package after is installed. **Do it by all means, or your server won't start automatically**: | + | |
| - | + | ||
| - | sudo dpkg-reconfigure firebird2.5-super | + | |
| - | + | ||
| - | <note> | + | |
| - | You can control your server by following commands:\\ | + | |
| - | sudo /etc/init.d/firebird2.5-super start | + | |
| - | sudo /etc/init.d/firebird2.5-super stop | + | |
| - | </note> | + | |
| - | + | ||
| - | Install the examples and dev files | + | |
| - | + | ||
| - | sudo apt-get install firebird2.5-examples firebird2.5-dev | + | |
| - | + | ||
| - | The employee.fdb archive will be under this dir /usr/share/doc/firebird2.1-examples/examples/empbuild/ | + | |
| - | + | ||
| - | <code> | + | |
| - | cd /usr/share/doc/firebird2.5-examples/examples/empbuild/ | + | |
| - | sudo gunzip employee.fdb.gz | + | |
| - | sudo chown firebird.firebird employee.fdb | + | |
| - | sudo mv employee.fdb /var/lib/firebird/2.5/data/ | + | |
| - | </code> | + | |
| - | + | ||
| - | Connect to database using the isql-fb console | + | |
| - | + | ||
| - | <code> | + | |
| - | $ isql-fb | + | |
| - | SQL> connect "/var/lib/firebird/2.5/data/employee.fdb " user 'SYSDBA' password 'SYSDBApassword'; | + | |
| - | </code> | + | |
| - | always use localhost: in front in front of db path when using classic or superclassic in 2.5 this way the lock files and the shared memory segment will be owned by the 'firebird' user. Another alternative is to add yourself to firebird group | + | |
| - | + | ||
| - | + | ||
| - | $ sudo adduser `id -un` firebird | + | |
| - | + | ||
| - | Then connect to the db in superclassic or classic | + | |
| - | + | ||
| - | $ isql-fb | + | |
| - | SQL> connect "localhost:/var/lib/firebird/2.5/data/employee.fdb " user 'SYSDBA' password 'SYSDBApassword'; | + | |
| - | + | ||
| - | If all is ok then you will have the message with what database connected and what user and ready to use sql prompt | + | |
| - | + | ||
| - | Database: "/var/lib/firebird/2.5/data/employee.fdb ", User: SYSDBA | + | |
| - | SQL> | + | |
| - | + | ||
| - | Now you can check the server version and the tables | + | |
| - | + | ||
| - | <code> | + | |
| - | SQL> show tables; | + | |
| - | COUNTRY CUSTOMER | + | |
| - | DEPARTMENT EMPLOYEE | + | |
| - | EMPLOYEE_PROJECT JOB | + | |
| - | PROJECT PROJ_DEPT_BUDGET | + | |
| - | SALARY_HISTORY SALES | + | |
| - | + | ||
| - | SQL> show version; | + | |
| - | ISQL Version: LI-V2.5.0.* Firebird 2.5 | + | |
| - | Server version: | + | |
| - | Firebird/linux Intel (access method), version "LI-V2.5.0.* Firebird 2.5" | + | |
| - | Firebird/linux Intel (remote server), version "LI-V2.5.0.* Firebird 2.5/tcp (eeepc)/P11" | + | |
| - | Firebird/linux Intel (remote interface), version "LI-V2.5.0.* Firebird 2.5 Release Candidate 2/tcp (eeepc)/P11" | + | |
| - | on disk structure version 11.1 | + | |
| - | </code> | + | |
| - | + | ||
| - | To create a new database | + | |
| - | <code> | + | |
| - | SQL> create database "/var/lib/firebird/2.5/data/first_database.fdb" user 'SYSDBA' password 'SYSDBAPASSWORD'; | + | |
| - | SQL> connect "/var/lib/firebird/2.5/data/first_database.fdb" user 'SYSDBA' password 'masterkey'; | + | |
| - | Commit current transaction (y/n)?y | + | |
| - | Committing. | + | |
| - | Database: "/var/lib/firebird/2.5/data/first_database.fdb", User: SYSDBA | + | |
| - | SQL> | + | |
| - | </code> | + | |
| - | + | ||
| - | If you want to create a simple table then insert 1-2 rows and select from it here is one example | + | |
| - | + | ||
| - | <code> | + | |
| - | 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 | + | |
| - | </code> | + | |
| - | 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 ubuntu repository can be installed by an simple | + | |
| - | + | ||
| - | sudo apt-get install flamerobin | + | |
| - | + | ||
| - | Then use it from the menu Applications->Programming->FlameRobin | + | |
| - | + | ||
| - | To use firebird with php , you will need the php5 driver | + | |
| - | + | ||
| - | sudo apt-get install php5-interbase | + | |
| - | sudo /etc/init.d/apache2 restart | + | |
| - | + | ||
| - | Next if you need to install an php administration tool like Firebird Web Admin | + | |
| - | + | ||
| - | sudo apt-get install git-core | + | |
| - | git clone git://github.com/mariuz/FirebirdWebAdmin.git | + | |
| - | mv FirebirdWebAdmin/firebirdwebadmin /var/www/firebirdwebadmin | + | |
| - | + | ||
| - | and load it in the browser http://localhost/firebirdwebadmin | + | |
| - | + | ||
| - | It should look like this screen shot | + | |
| - | + | ||
| - | + | ||
| - | ---- | + | |
| - | **Other Firebird Related Guides** | + | |
| - | + | ||
| - | You can start with the main Firebird documentation. | + | |
| - | + | ||
| - | To use Ruby language with firebird I wrote a tutorial on howto install the stable driver. | + | |
| - | + | ||
| - | For Ruby on Rails i wrote howto install the Firebird Active Record Adapter and start an application. | + | |
| - | + | ||
| - | To use python you must use the official firebird python driver and here is howto install and test it if it works. | + | |
| - | + | ||
| - | For Lazarus IDE i wrote an visual guide on howto use the database aware components in a simple application that uses Firebird. | + | |
| - | + | ||
| - | Lua Language does have a good driver and there is a Getting started guide with firebird on ubuntu | + | |
| - | + | ||
| - | Firebird2.5 (последним исправлял(а) Mariuz 2010-11-24 12:36:41) | + | |
| - | + | ||
| - | ====== Installation files list ====== | + | |
| - | <code> | + | |
| - | denis@denis-office-ub:~$ dpkg-query -l firebird* | grep "ii" | + | |
| - | ii firebird2.5-common 2.5.0.26074-0.ds4-2ubuntu4 common files for firebird 2.5 servers and cl | + | |
| - | ii firebird2.5-common-doc 2.5.0.26074-0.ds4-2ubuntu4 copyright, licnesing and changelogs of fireb | + | |
| - | ii firebird2.5-dev 2.5.0.26074-0.ds4-2ubuntu4 Development files for Firebird - an RDBMS ba | + | |
| - | ii firebird2.5-examples 2.5.0.26074-0.ds4-2ubuntu4 Examples for Firebird - an RDBMS based on In | + | |
| - | ii firebird2.5-server-common 2.5.0.26074-0.ds4-2ubuntu4 common files for firebird 2.5 servers | + | |
| - | ii firebird2.5-super 2.5.0.26074-0.ds4-2ubuntu4 Firebird Super Server - an RDBMS based on In | + | |
| - | + | ||
| - | denis@denis-office-ub:~$ dpkg -L firebird2.5-common | + | |
| - | /. | + | |
| - | /usr | + | |
| - | /usr/lib | + | |
| - | /usr/lib/firebird | + | |
| - | /usr/lib/firebird/2.5 | + | |
| - | /usr/lib/firebird/2.5/intl | + | |
| - | /usr/lib/firebird/2.5/intl/fbintl | + | |
| - | /usr/share | + | |
| - | /usr/share/doc | + | |
| - | /usr/share/firebird2.5-common | + | |
| - | /usr/share/firebird2.5-common/functions.sh | + | |
| - | /usr/share/lintian | + | |
| - | /usr/share/lintian/overrides | + | |
| - | /usr/share/lintian/overrides/firebird2.5-common | + | |
| - | /usr/share/firebird | + | |
| - | /usr/share/firebird/2.5 | + | |
| - | /usr/share/firebird/2.5/fr_FR.msg | + | |
| - | /usr/share/firebird/2.5/firebird.msg | + | |
| - | /usr/share/firebird/2.5/de_DE.msg | + | |
| - | /etc | + | |
| - | /etc/firebird | + | |
| - | /etc/firebird/2.5 | + | |
| - | /etc/firebird/2.5/firebird.conf | + | |
| - | /etc/firebird/2.5/fbintl.conf | + | |
| - | /usr/lib/firebird/2.5/firebird.conf | + | |
| - | /usr/lib/firebird/2.5/firebird.msg | + | |
| - | /usr/lib/firebird/2.5/intl/fbintl.conf | + | |
| - | /usr/share/doc/firebird2.5-common | + | |
| - | + | ||
| - | denis@denis-office-ub:~$ dpkg -L firebird2.5-server-common | + | |
| - | /. | + | |
| - | /var | + | |
| - | /var/lib | + | |
| - | /var/lib/firebird | + | |
| - | /var/lib/firebird/2.5 | + | |
| - | /var/lib/firebird/2.5/system | + | |
| - | /var/lib/firebird/2.5/system/help.fdb | + | |
| - | /var/lib/firebird/2.5/system/default-security2.fdb | + | |
| - | /var/lib/firebird/2.5/data | + | |
| - | /var/lib/firebird/2.5/data/no_empty | + | |
| - | /var/lib/firebird/2.5/backup | + | |
| - | /var/lib/firebird/2.5/backup/no_empty | + | |
| - | /var/lib/firebird/2.5/tmp | + | |
| - | /usr | + | |
| - | /usr/sbin | + | |
| - | /usr/sbin/fbguard | + | |
| - | /usr/lib | + | |
| - | /usr/lib/firebird | + | |
| - | /usr/lib/firebird/2.5 | + | |
| - | /usr/lib/firebird/2.5/plugins | + | |
| - | /usr/lib/firebird/2.5/plugins/libfbtrace.so | + | |
| - | /usr/lib/firebird/2.5/UDF | + | |
| - | /usr/lib/firebird/2.5/UDF/fbudf.sql | + | |
| - | /usr/lib/firebird/2.5/UDF/ib_udf.sql | + | |
| - | /usr/lib/firebird/2.5/UDF/ib_udf2.sql | + | |
| - | /usr/share | + | |
| - | /usr/share/doc | + | |
| - | /usr/share/doc/firebird2.5-common-doc | + | |
| - | /usr/share/doc/firebird2.5-common-doc/examples | + | |
| - | /usr/share/doc/firebird2.5-common-doc/examples/reindex-db | + | |
| - | /usr/share/man | + | |
| - | /usr/share/man/man1 | + | |
| - | /usr/share/man/man1/fbsvcmgr.1.gz | + | |
| - | /usr/share/man/man1/gdef.1.gz | + | |
| - | /usr/share/man/man1/nbackup.1.gz | + | |
| - | /usr/share/man/man1/fbtracemgr.1.gz | + | |
| - | /usr/share/man/man1/gbak.1.gz | + | |
| - | /usr/share/man/man1/qli.1.gz | + | |
| - | /usr/share/man/man1/fbstat.1.gz | + | |
| - | /usr/share/man/man1/gfix.1.gz | + | |
| - | /usr/share/man/man1/gpre.1.gz | + | |
| - | /usr/share/man/man1/fb_lock_print.1.gz | + | |
| - | /usr/share/man/man1/fbguard.1.gz | + | |
| - | /usr/share/man/man1/isql-fb.1.gz | + | |
| - | /usr/share/man/man1/gsec.1.gz | + | |
| - | /etc | + | |
| - | /etc/default | + | |
| - | /etc/default/firebird2.5 | + | |
| - | /etc/logrotate.d | + | |
| - | /etc/logrotate.d/firebird2.5 | + | |
| - | /etc/firebird | + | |
| - | /etc/firebird/2.5 | + | |
| - | /etc/firebird/2.5/aliases.conf | + | |
| - | /etc/firebird/2.5/fbtrace.conf | + | |
| - | /usr/share/doc/firebird2.5-server-common | + | |
| - | + | ||
| - | denis@denis-office-ub:~$ dpkg -L firebird2.5-super | + | |
| - | /. | + | |
| - | /usr | + | |
| - | /usr/bin | + | |
| - | /usr/bin/isql-fb | + | |
| - | /usr/bin/fbsvcmgr | + | |
| - | /usr/bin/fbtracemgr | + | |
| - | /usr/bin/gdef | + | |
| - | /usr/bin/gsec | + | |
| - | /usr/bin/fbstat | + | |
| - | /usr/bin/gfix | + | |
| - | /usr/bin/gpre | + | |
| - | /usr/bin/qli | + | |
| - | /usr/bin/nbackup | + | |
| - | /usr/bin/gbak | + | |
| - | /usr/sbin | + | |
| - | /usr/sbin/fb_lock_print | + | |
| - | /usr/sbin/fbserver | + | |
| - | /usr/lib | + | |
| - | /usr/lib/firebird | + | |
| - | /usr/lib/firebird/2.5 | + | |
| - | /usr/lib/firebird/2.5/UDF | + | |
| - | /usr/lib/firebird/2.5/UDF/ib_udf.so | + | |
| - | /usr/lib/firebird/2.5/UDF/fbudf.so | + | |
| - | /usr/share | + | |
| - | /usr/share/doc | + | |
| - | /usr/share/lintian | + | |
| - | /usr/share/lintian/overrides | + | |
| - | /usr/share/lintian/overrides/firebird2.5-super | + | |
| - | /usr/share/man | + | |
| - | /usr/share/man/man1 | + | |
| - | /usr/share/man/man1/fbserver.1.gz | + | |
| - | /etc | + | |
| - | /etc/init.d | + | |
| - | /etc/init.d/firebird2.5-super | + | |
| - | /usr/share/doc/firebird2.5-super | + | |
| - | + | ||
| - | </code> | + | |
