- start isql SQL> create database "[servidor]:/[archivo]/[base de datos].gdb"
USER "sysdba" PASSWORD "masterkey" DEFAULT CHARACTER SET ISO8859_1; SQL> create table .... . . . SQL> quit; Mejor: hechar un usario separado con "gsec" porque "sysdba" tiene todo permiso en la base de datos - como "root" en UNIX...
Mas informaciones: Download and install the InterBase rpm * download InterBaseSS_LI-V6.0-1.i386.rpm * # rpm -i InterBaseSS_LI-V6.0-1.i386.rpm Set correct permissions The InterBase server daemon allows run as root or run as a Linux user named interbas but you should not run the InterBase server daemon as root. To run the InterBase server daemon as interbas you have to do: * create a Linux user named interbas * # chown -R interbas /opt/interbase * # chown -R interbas [database file directory] * include /opt/interbase/bin/ into the $PATH or create symbolic links from /opt/interbase/bin/* to e.g. /usr/local/bin/ * # ln -s /usr/lib/libgds.so /opt/interbase/lib/libgds.so * start the InterBase server daemon as interbas e.g by the following script The Linux user named interbas doesn't need any other write permissions. You don't have to allow any login for interbas. Create a start script to start the interbase server daemon in runlevel 3 and 5 like this #! /bin/sh # /etc/init.d/interbase # to start ibserver in runlevel 3 and 5 . /etc/rc.config # Determine the base and follow a runlevel link name. base=${0##*/} link=${base#*[SK][0-9][0-9]} # Force execution if not called by a runlevel directory. test $link = $base && START_INTERBASE=yes test "$START_INTERBASE" = "yes" || exit 0 # The echo return value for success (defined in /etc/rc.config). return=$rc_done case "$1" in start) echo -n "Starting INTERBASE services:" startproc -u interbas /opt/interbase/bin/ibserver || return=$rc_failed echo -e "$return" ;; stop) echo -n "Shutting down INTERBASE services:" killproc -TERM /opt/interbase/bin/ibserver || return=$rc_failed echo -e "$return" ;; restart|reload) $0 stop && $0 start || return=$rc_failed ;; status) echo -n "Checking for service INTERBASE: " checkproc /opt/interbase/bin/ibserver && echo "OK " || echo "No process " ;; *) echo "Usage: $0 {start|stop|restart|reload|status}" exit 1 esac # Inform the caller not only verbosely and set an exit status. test "$return" = "$rc_done" || exit 1 exit 0 Prepare PHP PHP4 has native support for a lot of database systems, of course InterBase support is included too. For using PHP with additional database systems than MySQL you must compile and install PHP with support for your relevant database system like $ ./configure --with-apxs --with-interbase=/opt/interbase --with-config-file-path=/etc $ make # make install For the default MySQL support you don't need --with-mysql, PHP will work with both database systems. To keep your PHP code useable for different database systems you should wrap the database access in a separate PHP file like this: <? // dbaccess.php to wrap database access for different database systems $charset="ISO8859_1"; $dbuser="xxxx"; $dbpassword="yyyy"; $host="yenidze"; $rdbms="interbase"; $database="/gdb60/pcb.gdb"; //$rdbms="mysql"; //$database="pcb"; function dbaccess_connect(){ global $charset; global $dbuser; global $dbpassword; global $database; global $rdbms; if ($rdbms == "interbase"){ $dbh = ibase_connect("$host:/$database", $dbuser, $dbpassword, $charset); } if ($rdbms == "mysql"){ $dbh = mysql_connect($host, $dbuser, $dbpassword); } return $dbh; } function dbaccess_query($dbh, $sql){ global $rdbms; global $database; if ($rdbms == "interbase"){ $sth = ibase_query ($dbh, $sql); } if ($rdbms == "mysql"){ $sth = mysql_db_query ($database, $sql, $dbh); } return $sth; } function dbaccess_fetch_object($sth){ global $rdbms; if ($rdbms == "interbase"){ $row = ibase_fetch_object($sth); } if ($rdbms == "mysql"){ $row = mysql_fetch_object($sth, MYSQL_ASSOC); } return $row; } function dbaccess_close($dbh){ global $rdbms; if ($rdbms == "interbase"){ $i = ibase_close ($dbh); } if ($rdbms == "mysql"){ $i = mysql_close ($dbh); } return $i; } ?> On Sunday 02 June 2002 23:48, Nelson Acero Fino wrote:
Saludos lista,
He instalado correctamente Interbase 6.0 en SuSE 8.0 profesional. Como hago para arrancar la base de datos.
Ayuda, gracias!.
Nelson Acero Fino
-- AMD Saxony Manufacturing GmbH Dresden Design Center Dipl.-Ing. William Epler Wilschdorfer Landstr. 101 D-01109 Dresden Tel. +49 351 277 6883 william.epler@amd.com http://www.amd.com