From owner-freebsd-database@FreeBSD.ORG Fri Jun 30 12:49:19 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7665416A415 for ; Fri, 30 Jun 2006 12:49:19 +0000 (UTC) (envelope-from i.am.aleks@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.185]) by mx1.FreeBSD.org (Postfix) with ESMTP id CB00B43D48 for ; Fri, 30 Jun 2006 12:49:18 +0000 (GMT) (envelope-from i.am.aleks@gmail.com) Received: by nf-out-0910.google.com with SMTP id c29so277526nfb for ; Fri, 30 Jun 2006 05:49:17 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=Wti2CvkfB3AUUTl8uco7klHUsmaoqOAkDckTjlgdLjr+MptcsBrf35MlkSuVXQN9yR/8WcQDjBkOtpTKqgb92/fioVpy6Fepbxc5QhGOD+5v+iqQHTvWn/oZNEHs0pBcr3JHcKh3th9In3fk2U2HGkogBA+Y+CLahANkJ5jWoVY= Received: by 10.49.72.6 with SMTP id z6mr263661nfk; Fri, 30 Jun 2006 05:49:16 -0700 (PDT) Received: by 10.48.223.10 with HTTP; Fri, 30 Jun 2006 05:49:16 -0700 (PDT) Message-ID: <94678bd60606300549m25b560e9t48d9775a21135647@mail.gmail.com> Date: Fri, 30 Jun 2006 15:49:16 +0300 From: Aleks To: freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Subject: FreeBSD 6.1 & Firebird X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 30 Jun 2006 12:49:19 -0000 Hello! Yesterday I tried several times to setup a Firebird Server on a freshly installed FreeBSD 6.1 and connect to the example fdb via network, but with no success. Here is a transcript of what I do: Standard installation. Fdisk: Using entire disk (A option). Set bootable (S) the freebsd partition. Finish (Q). Install a standard MBR (no boot manager). Disklabel Editor: Auto defaults (A) used in Disklabel Editor. Finish (Q). Choose Minimal distribution set. Install from FreeBSD 6.1 CD disk1. Congratulations! ... Choose to configure Ethernet fxp0 (Intel EtherExpress Pro/100B). No IPv6. No DHCP. Host: firebird1 Domain: iktiv.com IPv4 Gateway: 172.16.0.254 Name server: 172.16.0.254 IPv4 Address: 172.16.0.250 Netmask: 255.255.255.0 OK. Bring up the fxp0 now. Choose not to function as a gateway. Choose to configure inetd. Choose to enable inetd. Choose not to invoke an editor on /etc/inetd.conf. Choose not to enable SSH login. Choose not to have anonymous FTP access. Choose not to configure as an NFS server. Choose not to configure as an NFS client. Choose not to customize system console settings. CMOS clock is set to UTC. Set time zone to EEST. Choose to exit the install. (Remove CD.) (System boots up and I login as root.) # pkg_add -r firebird-server (Fetches firebird-server and firebird-client.) (No errors.) # echo "gds_db 3050/tcp # InterBase Database Remote Protocol" >> /etc/services # echo "gds_db stream tcp nowait firebird /usr/local/sbin/fb_inet_server /usr/local/sbin/fb_inet_server" >> /etc/inetd.conf # /etc/rc.d/inetd restart Stopping inetd. Starting inetd. # gsec GSEC> display (Shows only SYSDBA, uid=0, gid=0.) GSEC> quit # isql Use CONNECT or CREATE DATABASE to specify database SQL> connect '/usr/local/share/examples/firebird/employee.fdb' user 'SYSDBA' password 'masterkey'; Database: '/usr/local/share/examples/firebird/employee.fdb', User: SYSDBA SQL> quit; # ping localhost (Successful.) # sockstat | grep inetd root inetd 603 5 tcp4 *:3050 *:* # telnet localhost gds_db Trying ::1... telnt: connect to address ::1: Connecion refused Trying 127.0.0.1... Connected to localhost.iktiv.com. Escape charactes is '^]'. ^] telnet> quit Connection closed. # isql Use CONNECT or CREATE DATABASE to specify database SQL> connect 'localhost:/usr/local/share/examples/firebird/employee.fdb' user 'SYSDBA' password 'masterkey'; Statement failed, SQLCODE =-902 I/O error for file "/usr/local/share/examples/employee.fdb" -Error while trying to open file -No such file or directory SQL> quit; So that's it. I can't find any useful documentation about how to setup Firebird on FreeBSD 6.1. Can anyone, please, suggest what might be the problem or to show a working setup of FreeBSD 6.1 & Firebird so I could use it via the network? Thank you! Aleks