Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /home/users/p/prom-auto/domains/prom-auto.ru/wiki/inc/parser/handler.php on line 1458

Warning: Declaration of syntax_plugin_tablecalc::handle($match, $state, $pos, &$handler) should be compatible with DokuWiki_Syntax_Plugin::handle($match, $state, $pos, Doku_Handler $handler) in /home/users/p/prom-auto/domains/prom-auto.ru/wiki/lib/plugins/tablecalc/syntax.php on line 41

Warning: Declaration of syntax_plugin_tablecalc::render($mode, &$renderer, $data) should be compatible with DokuWiki_Syntax_Plugin::render($format, Doku_Renderer $renderer, $data) in /home/users/p/prom-auto/domains/prom-auto.ru/wiki/lib/plugins/tablecalc/syntax.php on line 72

Warning: Declaration of syntax_plugin_offline::handle($match, $state, $pos, &$handler) should be compatible with DokuWiki_Syntax_Plugin::handle($match, $state, $pos, Doku_Handler $handler) in /home/users/p/prom-auto/domains/prom-auto.ru/wiki/lib/plugins/offline/syntax.php on line 60

Warning: Declaration of syntax_plugin_offline::render($format, &$renderer, $data) should be compatible with DokuWiki_Syntax_Plugin::render($format, Doku_Renderer $renderer, $data) in /home/users/p/prom-auto/domains/prom-auto.ru/wiki/lib/plugins/offline/syntax.php on line 67

Warning: preg_match(): Compilation failed: invalid range in character class at offset 3416 in /home/users/p/prom-auto/domains/prom-auto.ru/wiki/inc/parser/lexer.php on line 118

A PCRE internal error occured. This might be caused by a faulty plugin

====== Installing Firebird from archieve ====== See [[http://www.firebirdsql.org/file/documentation/release_notes/html/install210.html#install2-posx|Firebird 2 Migration & Installation]] for details. ===== Uninstall previos installation ===== If you you have any installed Firebird on your system, remove it before moving on. For instance: sudo apt-get remove firebird2.5-common sudo apt-get remove firebird2.5-common-doc sudo apt-get remove firebird2.5-dev sudo apt-get remove firebird2.5-examples sudo apt-get remove firebird2.5-server-common sudo apt-get remove firebird2.5-super ===== Download release archieve ===== http://www.firebirdsql.org/en/downloads/ \\ It'll look like somewhat below:\\ October 04, 2011 [[http://sourceforge.net/projects/firebird/files/firebird-linux-i386/2.5.1-Release/FirebirdSS-2.5.1.26351-0.i686.tar.gz/download|FirebirdSS-2.5.1.26351-0.i686.tar.gz]] 6 MB Superserver, compressed tarball ===== Start install script ===== **Next operations need root access!**\\ Unpack content of the archieve and start: install.sh Installation complete. ===== Getting rid of "insserv error" ===== If you come across with system output like follows: <code> insserv: warning: script 'K20acpi-support' missing LSB tags and overrides The script you are attempting to invoke has been converted to an Upstart job, but lsb-header is not supported for Upstart jobs. insserv: warning: script 'cryptdisks-udev' missing LSB tags and overrides The script you are attempting to invoke has been converted to an Upstart job, but lsb-header is not supported for Upstart jobs. insserv: warning: script 'bridge-network-interface' missing LSB tags and overrides The script you are attempting to invoke has been converted to an Upstart job, but lsb-header is not supported for Upstart jobs. ...and so on </code> than you need to patch "insserv bug": - get this file [[https://bugs.launchpad.net/ubuntu/+source/insserv/+bug/467000/+attachment/1911930/+files/upstart-job.patch|upstart-job.patch]]<code bash> *** upstart-job.orig 2011-03-16 08:06:15.275456408 -0400 --- upstart-job 2011-03-16 08:44:45.622968551 -0400 *************** *** 65,70 **** --- 65,82 ---- $ECHO "Upstart job, you may also use the $COMMAND(8) utility, e.g. $COMMAND $JOB" reload "$JOB" ;; + lsb-header) + $ECHO "### BEGIN INIT INFO" + $ECHO "# Provides: $JOB" + $ECHO "# Required-Start:" + $ECHO "# Required-Stop:" + $ECHO "# Should-Start:" + $ECHO "# Should-Stop:" + $ECHO "# Default-Start:" + $ECHO "# Default-Stop:" + $ECHO "# Short-Description: $JOB, converted to upstart." + $ECHO "### END INIT INFO" + ;; *) $ECHO $ECHO "The script you are attempting to invoke has been converted to an Upstart" 1>&2</code> - execute commands:<code> cd /lib/init patch < your_path/upstart-job.patch</code> - finish installation:<code> /sbin/insserv /etc/init.d/firebird</code> Finally you'll something similar to this: <code> insserv: warning: script 'K20acpi-support' missing LSB tags and overrides insserv: warning: current start runlevel(s) (0) of script `halt' overwrites defaults (empty). insserv: warning: current start runlevel(s) (0 6) of script `cryptdisks-early' overwrites defaults (empty). insserv: warning: script 'acpi-support' missing LSB tags and overrides insserv: warning: current start runlevel(s) (0 6) of script `umountnfs.sh' overwrites defaults (empty). insserv: warning: current start runlevel(s) (0 6) of script `networking' overwrites defaults (empty). ...and so on </code> ===== Checking your Firebird working ===== <code> $cd /opt/firebird/bin $./isql -user sysdba -password <password>1 SQL>connect localhost:employee.fdb /* this is an aliased path */ SQL>select * from sales; SQL>select rdb$relation_name from rdb$relations; SQL>help; SQL>quit; </code>