[질의]우분투8.04에서 firebird 설치하였습니다. 이제 어떻게 firebird를 실행 할 수 있나요?

우분투8.04에서 firebird 설치하였습니다.
시스템->관리->시냅틱 꾸러미 관리자에서 쉽게 설치는 했는데요…

  1. 이제 어떻게 firebird를 실행 할 수 있나요?
    linux에서는 load 라고 하던가요??
    마우스로 또는 터미널창에서 실행하는 방법 아시면 알켜주세요.

  2. 윈도우즈의 제어판->firebird관리자 같은게 linux용에도 있나요??

  3. 우분투에서 firebird로 data를 물려서 서버로 운용하고, 윈도우에서 사용하고 싶은데…
    윈도우에서 어떻게 연결 할 수 있나요???

고수님들의 조언 부탁 드립니다.
감사합니다.

[quote="kds4u":1t7bclu9]1. 이제 어떻게 firebird를 실행 할 수 있나요?
linux에서는 load 라고 하던가요??
마우스로 또는 터미널창에서 실행하는 방법 아시면 알켜주세요.[/quote:1t7bclu9]

우선 설치 후 비번 정하고 어쩌구 아래 링크에 작업들을 해주었는지요?
참고 : http://www.firebirdsql.org/manual/ubusetup.html

[quote="강분도":2v5rr1b9]우선 설치 후 비번 정하고 어쩌구 아래 링크에 작업들을 해주었는지요?
참고 : http://www.firebirdsql.org/manual/ubusetup.html[/quote:2v5rr1b9]
안녕하세요?
역시나 또 강분도님께서 답글을 주셧네요…감사드립니다.
설치만 했구요, 설치후 작업이 있는지 몰랐네요…
링크에 있는것 해 보구 결과 달아놓겠습니다.

아래의 글을 참고하여 터미널에서 열심히 따라해 보았으나…
그런 명령이 없다고만 나오고, 막막 하기만 합니다.ㅠㅠ
우분투 버젼이 다르거나, 파이어버드 파일명 또는 실행파일명이 다른것 같기도 하고…
첫 줄 부터 고난의 연속 입니다. ㅎㅎㅎ
누군가 고수분이 하시는거 한번만 봐도 알것 같은데,
텍스트로만 의사전달이 되니 참으로 이해하기 어렵네요…

[color=#0000FF:2v5rr1b9]Setting up Firebird on Ubuntu Linux

This article describes the process of installing and running Firebird on Ubuntu Linux. Like the Debian GNU/Linux distribution it is based on, installing software with Ubuntu (or Kubuntu) is very straightforward and Firebird is no exception. This guide is based on Ubuntu 6.10 “Edgy Eft”.

The version of Firebird packaged with Ubuntu “Edgy Eft” is 1.5.3.4870-10 but is labelled "firebirdsql2". Since its inception, Ubuntu has followed a strict six-month release cycle so this may change with the “Feisty Fawn” release in April 2007.

With administrator privileges on the target machine, issue the following command:

# apt-get install firebird2-super-server

Apt’s dependency tracking will automatically propose all the packages required for a complete installation with the following output:

The following extra packages will be installed:
firebird2-common firebird2-server-common libfbclient1
Recommended packages:
firebird2-server
The following NEW packages will be installed
firebird2-common firebird2-server-common firebird2-super-server
  libfbclient1
Need to get 2342kB of archives.
After unpacking 5976kB of additional disk space will be used.
Do you want to continue [Y/n]?

Ignore the “firebird2-server” virtual package which will just ask you to select either the “Classic” or “Super” server.

The packages will then download and install on the target machine, a new user “firebird” will be created to run the server, and the server will be started immediately:

Setting up firebird2-super-server (1.5.3.4870-10) ...
Created default security.fdb
Starting Firebird server: server has been successfully started

You will then be asked to enter a new password for the SYSDBA user, spelling mistake included:

Plase enter new password for SYSDBA user:

You will then be returned to a shell prompt with the following output, that’s it!

GSEC> GSEC>

If you’re a seasoned Unix person, but new to Ubuntu, you might be wondering where all the Firebird files are residing in the directory hierarchy. To see where all the files were installed by Apt, simply do:

# dpkg -L firebird2-super-server

/.
/usr
/usr/lib
/usr/lib/firebird2
/usr/lib/firebird2/bin
/usr/lib/firebird2/bin/fb_lock_print
/usr/lib/firebird2/bin/fbserver
/usr/lib/firebird2/bin/fbguard
/usr/lib/firebird2/bin/fbmgr.bin
/usr/lib/firebird2/UDF
/usr/lib/firebird2/UDF/fbudf.so
/usr/bin
/usr/bin/gsec
/usr/bin/fbmgr
/usr/share
/usr/share/lintian
/usr/share/lintian/overrides
/usr/share/lintian/overrides/firebird2-super-server
/usr/share/doc
/usr/share/doc/firebird2-super-server
/usr/share/doc/firebird2-super-server/README.Debian
/usr/share/doc/firebird2-super-server/TODO.Debian
/usr/share/doc/firebird2-super-server/copyright
/usr/share/doc/firebird2-super-server/NEWS.Debian.gz
/usr/share/doc/firebird2-super-server/changelog.gz
/usr/share/doc/firebird2-super-server/changelog.Debian.gz
/usr/share/man
/usr/share/man/man1
/usr/share/man/man1/fbmgr.1.gz
/usr/share/man/man1/gsec.1.gz
/etc
/etc/init.d
/etc/init.d/firebird2
/usr/lib/firebird2/bin/fbmgr
/usr/lib/firebird2/bin/gsec

As mentioned, a new user “firebird” is created on the target machine. With administrator access, set a password for this new user:

# passwd firebird
Enter new UNIX password:
Retype new UNIX password:

Now you can switch to the firebird user with the su command if required.

If you try to stop the server from running with the init.d command an error message will appear.

# /etc/init.d/firebird2 stop
/etc/init.d/firebird2: 28: source: not found
Stopping Firebird server: Your user name and password are not
defined. Ask your database administrator to set up a Firebird
login.
can not attach to server

The same will happen if you try and start the server. This needs further investigation and discussion with the Debian and Ubuntu Firebird packagers to iron out, but for now to stop the server:

# su -c "fbmgr -shut -password SYSDBApassword" firebird
Password:
server shutdown completed

Where SYSDBApassword is the password you entered immediately after installation and the second password is the firebird user password. To start the server again:

# su -c "fbmgr -start" firebird

With the installation complete, you can now begin using Firebird on Ubuntu Linux. The base package does not include any example databases, so if you like, install some with:

# apt-get install firebird2-examples

These will be installed in /usr/share/doc/firebird2-examples/. While you’re at it, install the utilities package:

# sudo apt-get install firebird2-utils-super

This will give you an interactive shell, and backup and reporting tools among others. Now you can test your Firebird installation by connecting to an example database. Decompress the example “employee.fdb” database:

# gunzip
# /usr/share/doc/firebird2-examples/examples/employee.fdb.gz

Fire up the interactive shell.

# isql-fb

At the SQL> prompt, connect to the database with:

SQL> connect "employee.fdb" user 'SYSDBA' password 'SYSDBApassword';

If you get an error message like “Statement failed, SQLCODE = -551 no permission for read-write access to database /usr/share/doc/firebird2-examples/examples/employee.fdb”, then the server process doesn’t have read or write access to the database file. Change the ownership of the database to the user firebird with:

# chown firebird:firebird employee.fdb

When you manage to successfully connect to the database you will see the message:

Database:  "employee.fdb", User: SYSDBA

Now, from the SQL> prompt, feel free to browse around the employee database:

SQL> show tables;
COUNTRY                    CUSTOMER
DEPARTMENT                 EMPLOYEE
EMPLOYEE_PROJECT           JOB
PHONE_LIST                 PROJECT
PROJ_DEPT_BUDGET           SALARY_HISTORY
SALES

If you’ve made it this far your Firebird installation on Ubuntu has been a success. Have a nice day! [/color:2v5rr1b9]

아쉽게도…
제 우분투 스킬이 미천한지라, 아직 firebird 가동을 못 시키고 있습니다.
열심히 이곳 저곳의 자료를 읽고 뒤적이며 따라 해 보고 있는데…
기본적인 먼가가 부족한듯 진전이 없습니다.
혹시, 우분투8.04에서 firebird 설치,가동 해 보신 분 계시면 한 수 만 지도 바랍니다.

아 전글을 고치셔서 잘안된다는 글을 못보았군요
이런경우엔 본 우분투포럼은 지금처럼 새로 댓글을 다시면 다시 글이 위로 올라 오는 구조이니
새로 댓글로 쓰시는 것이 좋습니다.

위 파란 글은 제가 가르쳐 드린 링크를 복사해온 것이군요 ^^

위 설명대로라면 sudo -i 하여 root 가 되신후 작업 하시는 것이 sudo 안치고 편합니다.
우선 버전은 상관 없습니다.

[code:6coj6egb] [color=#FF4040]apt-get install apt-get install firebird2.0-super firebird2.0-common[/color][/code:6coj6egb]
위 명령은 8.04에 맞는 최신 파이어버드를 설치 할 것 입니다.

설치를 하면서

[code:6coj6egb]Plase enter new password for SYSDBA user:[/code:6coj6egb]
SYSDBA 의 비번 정하게 됩니다.

[code:6coj6egb]dpkg -L firebird2-super-server[/code:6coj6egb]
위 명령어는 파이어버드 설치된 파일들을 보는 명령어일 뿐입니다.

[code:6coj6egb]

sudo passwd firebird

[/code:6coj6egb]
위 명령어는 firebird의 유저 비번을 만들어 주는 것 입니다.

[code:6coj6egb]# /etc/init.d/firebird2 stop[/code:6coj6egb]
파이어 버드를 정지시키는데 먼가 셋업어쩌구 비번 있고 나옵니다.
그래서

[code:6coj6egb]# su -c "fbmgr -shut -password SYSDBApassword" firebird[/code:6coj6egb]
패스워드 넣으면서 위와 같이 정지 시킵니다.

이제 새로 시작하려면 아까 적은 firebird 비번이 필요 합니다.

[code:6coj6egb]su -c "fbmgr -start" firebird[/code:6coj6egb]

[code:6coj6egb]#[color=#FF0040] apt-get install apt-get install firebird2.0-examples[/color][/code:6coj6egb]파이어버드예제 설치

[code:6coj6egb]# gzip -d /usr/share/doc/firebird2.0-examples/examples/employee.fdb.gz[/code:6coj6egb]압축풀기

[code:6coj6egb]# chown firebird:firebird employee.fdb[/code:6coj6egb]파일 권한을 firebird 에게 넘기기

[code:6coj6egb]# isql-fb[/code:6coj6egb]SQL 쉘로 들어가기

[code:6coj6egb]SQL> connect "employee.fdb" user ‘SYSDBA’ password ‘SYSDBApassword’;[/code:6coj6egb]employee.fdb 에 연결하기

[code:6coj6egb]SQL> show tables;[/code:6coj6egb]테이블 보기

[code:6coj6egb]SQL> exit[/code:6coj6egb] 나오기

설명자가 머가 안될것이다 그러니 이리 해라 하면서 순서가 좀 바꿔진게 있고

는 루트라는 표시 입니다. 일반 유저가 아닌 그러니 sudo -i 로 루트되어 작업 하시고

저도 저거 이용법은 모릅니다. Mysql 쓰고 있고 mysql 도 쪼금 압니더

과정 보면서 설명 해보았는데 어디서 머가 안되는 지요?

역시나 강분도님의 답글… 너무 감사드립니다.
일단 위의 내용데로 따라 해 보았습니다. 결과는…

[quote:1v2m1a1m]test@test-desktop:~$ [color=#8000FF:1v2m1a1m]sudo -i[/color:1v2m1a1m]
[sudo] password for test:
root@test-desktop:~# [color=#8000FF:1v2m1a1m]apt-get install firebird2-super-server[/color:1v2m1a1m]
[color=#0000FF:1v2m1a1m]Reading package lists… Done
Building dependency tree
Reading state information… Done
Package firebird2-super-server is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
firebird2.0-common
E: Package firebird2-super-server has no installation candidate[/color:1v2m1a1m]
root@test-desktop:~#
[/quote:1v2m1a1m]

[quote="kds4u":zqj7xtod]
root@test-desktop:~# [i:zqj7xtod]apt-get install firebird2-super-server[/i:zqj7xtod]
Reading package lists… Done
Building dependency tree
Reading state information… Done
Package firebird2-super-server is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
firebird2.0-common
E: Package firebird2-super-server has no installation candidate
root@test-desktop:~#
[/quote:zqj7xtod]
위에서 말하듯 firebird2.0-common 을 설치 하라는 군요 그냥 필요 패키지 같이 되게

[color=#FF4000:zqj7xtod][b:zqj7xtod]apt-get install firebird2.0-super firebird2.0-common firebird2.0-examples[/b:zqj7xtod][/color:zqj7xtod]

위 같이 해보소서 ;)

가르침데로 따라 해 보았나이다…ㅎㅎ (이거 전염되었나요??)
그랬더니, 머가 잘 되는가 싶더니…
However the following packages replace it:
firebird2.0-common 요렇게 나와서…
한번 배우면 10가지를 안다고…ㅋㅋ
apt-get install firebird2-super-server2.0-common 요렇게 또 명령을 내려 보았으나…
아래와 같이… 에러네요…

모든걸 다 지우고 새로 다시 해 보겠습니다.
그리고 결과 올릴께요.

[quote:2zp93s8c]root@test-desktop:~# [color=#8000FF:2zp93s8c]apt-get install firebird2.0-common firebird2.0-examples[/color:2zp93s8c]
[color=#0000FF:2zp93s8c]Reading package lists… Done
Building dependency tree
Reading state information… Done
firebird2.0-common is already the newest version.
firebird2.0-common set to manually installed.
The following packages were automatically installed and are no longer required:
x11proto-kb-dev mesa-common-dev libxdmcp-dev xtrans-dev x11proto-core-dev
libglu1-mesa-dev dkms openbsd-inetd x11proto-input-dev libpthread-stubs0-dev
libxau-dev libpthread-stubs0 libgl1-mesa-dev libx11-dev libxcb-xlib0-dev
libxcb1-dev
Use ‘apt-get autoremove’ to remove them.
Recommended packages:
firebird2.0-dev
The following NEW packages will be installed:
firebird2.0-examples
0 upgraded, 1 newly installed, 0 to remove and 1 not upgraded.
Need to get 536kB of archives.
After this operation, 807kB of additional disk space will be used.
Get:1 http://kr.archive.ubuntu.com hardy/universe firebird2.0-examples 2.0.3.12981.ds1-12 [536kB]
Fetched 536kB in 3s (163kB/s)
Selecting previously deselected package firebird2.0-examples.
(Reading database … 118583 files and directories currently installed.)
Unpacking firebird2.0-examples (from …/firebird2.0-examples_2.0.3.12981.ds1-12_all.deb) …
Setting up firebird2.0-examples (2.0.3.12981.ds1-12) …
root@test-desktop:~# apt-get install firebird2-super-server
Reading package lists… Done
Building dependency tree
Reading state information… Done
Package firebird2-super-server is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
However the following packages replace it:
firebird2.0-common
E: Package firebird2-super-server has no installation candidate[/color:2zp93s8c]
root@test-desktop:~# [color=#8000FF:2zp93s8c]apt-get install firebird2-super-server2.0-common[/color:2zp93s8c]
[color=#0000FF:2zp93s8c]Reading package lists… Done
Building dependency tree
Reading state information… Done
E: Couldn’t find package firebird2-super-server2.0-common[/color:2zp93s8c]
root@test-desktop:~#
[/quote:2zp93s8c]

[quote="강분도":1g6hyxyh]

[color=#FF4000:1g6hyxyh][b:1g6hyxyh]apt-get install firebird2.0-super firebird2.0-common firebird2.0-examples[/b:1g6hyxyh][/color:1g6hyxyh]

위 같이 해보소서 ;)[/quote:1g6hyxyh]

설치는 빨간색 한번이면 필요한 설치 다한겁니더(나중에꺼까지…)
끙 글자 스펠 뜨어쓰기 잘 보소서 ;)

[quote="kds4u":1g6hyxyh]
root@test-desktop:~# [color=#8000FF:1g6hyxyh]apt-get install firebird2.0-common firebird2.0-examples[/color:1g6hyxyh]
root@test-desktop:~#
[/quote:1g6hyxyh]

firebird2.0-common은 이미 설치 되있고 firebird2.0-example를 설치 한다고 나오고

[quote="kds4u":1g6hyxyh]
root@test-desktop:~# apt-get install firebird2-super-server
root@test-desktop:~#
[/quote:1g6hyxyh]
이런거 는 없다고 나옵니다. firebird2-super-server 아니고 firebird2.0-super 입니다 패키지네임이 6.06 때 쓰던 이름에서
변경되었음
제가 그냥 링크글 보고 해석을 달면서 써서 그런가 봅니다 망극 위 글도 고챠 봐야징

드디어 뭔가 된거 같습니다.
시냅틱꾸러미관리자에서 파이어버드 관련된거 모두 지우고 새로 하니
아래와 같이 잘 되었습니다.
특히 갈색줄에서 창이 하나 새로 뜨면서 패스워드를 묻더군요.
이제 몇번 더 해 보구 켜고,끄고 익혀야 겠습니다.
감사감사 드립니다.

[quote:1suuv7ya]root@test-desktop:~# [color=#BF00FF:1suuv7ya]apt-get install firebird2.0-super firebird2.0-common firebird2.0-examples[/color:1suuv7ya]
[color=#0000FF:1suuv7ya]Reading package lists… Done
Building dependency tree
Reading state information… Done
The following packages were automatically installed and are no longer required:
x11proto-kb-dev mesa-common-dev libxdmcp-dev xtrans-dev x11proto-core-dev
libglu1-mesa-dev dkms openbsd-inetd x11proto-input-dev libpthread-stubs0-dev
libxau-dev libpthread-stubs0 libgl1-mesa-dev libx11-dev libxcb-xlib0-dev
libxcb1-dev
Use ‘apt-get autoremove’ to remove them.
The following extra packages will be installed:
libfbclient2
Suggested packages:
firebird2.0-doc
Recommended packages:
firebird2.0-dev
The following NEW packages will be installed:
firebird2.0-common firebird2.0-examples firebird2.0-super libfbclient2
0 upgraded, 4 newly installed, 0 to remove and 1 not upgraded.
Need to get 0B/4910kB of archives.
After this operation, 11.4MB of additional disk space will be used.[/color:1suuv7ya]
Do you want to continue [Y/n]? [color=#BF00FF:1suuv7ya]y[/color:1suuv7ya]
[color=#0000FF:1suuv7ya]Preconfiguring packages …
Selecting previously deselected package firebird2.0-common.
(Reading database … 118493 files and directories currently installed.)
Unpacking firebird2.0-common (from …/firebird2.0-common_2.0.3.12981.ds1-12_i386.deb) …
Selecting previously deselected package firebird2.0-examples.
Unpacking firebird2.0-examples (from …/firebird2.0-examples_2.0.3.12981.ds1-12_all.deb) …
Selecting previously deselected package libfbclient2.
Unpacking libfbclient2 (from …/libfbclient2_2.0.3.12981.ds1-12_i386.deb) …
Selecting previously deselected package firebird2.0-super.
Unpacking firebird2.0-super (from …/firebird2.0-super_2.0.3.12981.ds1-12_i386.deb) …
Setting up firebird2.0-common (2.0.3.12981.ds1-12) …

Setting up firebird2.0-examples (2.0.3.12981.ds1-12) …
Setting up libfbclient2 (2.0.3.12981.ds1-12) …

Setting up firebird2.0-super (2.0.3.12981.ds1-12) …

  • Firebird 2.0 server manager not running.
  • Not starting Firebird 2.0 server manager
  • Use `dpkg-reconfigure firebird2.0-super’ to enable.

Processing triggers for libc6 …
ldconfig deferred processing now taking place[/color:1suuv7ya]
root@test-desktop:~#[color=#BF00FF:1suuv7ya] dpkg-reconfigure firebird2.0-super[/color:1suuv7ya]
[color=#0000FF:1suuv7ya] * Firebird 2.0 server manager not running.[/color:1suuv7ya]
[color=#800000:1suuv7ya] * Starting Firebird 2.0 server manager… [ OK ] [/color:1suuv7ya]
[color=#0000FF:1suuv7ya] * Firebird 2.0 server manager already running.[/color:1suuv7ya]
root@test-desktop:~#
[/quote:1suuv7ya]

이거 장황하게 글써 놓고 보니깐
유저 계정서 $ sudo apt-get install ??? 했으면 그냥 한글말로 나와서
다 넘가갈 문제 였군요 크 ~ 아니면 루트환경도 한글되게 하던가 했음 ^^

아니, 그렇게 좋은걸(한글) 왜 이제서야…ㅋㅋㅋ
다행히 잘 설치해서 켜고, 끄고, 익히는 중 입니다.
감사드려요~

흐 링크글이 예전 이라 [u:3unbr2ur]패키지 네임이 바꿔 진거하고 한글 환경에서의 설치 2가지[/u:3unbr2ur]군요
전 [color=#FF0040:3unbr2ur]firebird[/color:3unbr2ur] 써본 전이 없는데 DB 로 mysql 보다 어떤지요!
어 기왕이면 설치와 운영에 관해 [url=http://ubuntu.or.kr/viewforum.php?f=9:3unbr2ur][color=#4000FF:3unbr2ur]팁게시판[/color:3unbr2ur][/url:3unbr2ur]에 글부탁 드립니다. :(

저는 firefox 와 thunderbird 는 무지 쓰는 데 둘이 합치면 [color=#FF0040:3unbr2ur][b:3unbr2ur]firebird[/b:3unbr2ur][/color:3unbr2ur] :?:

[quote="강분도":1g0jvdoh]저는 firefox 와 thunderbird 는 무지 쓰는 데 둘이 합치면 [color=#FF0040:1g0jvdoh][b:1g0jvdoh]firebird[/b:1g0jvdoh][/color:1g0jvdoh] :?:[/quote:1g0jvdoh]

여담이 되겠습니다만… 파폭이 정말 이름떄문에 고생이 많았죠. ㅋㅋ

Firefox의 2번째 이름이 원래 Firebird였습니다 (처음엔 "다시 태어난다" 라는 의미를 부여해 불사조 Pheonix라는 이름이었죠). 그러다가 바로 이 Firebird때문에 Firefox로 이름을 바꾼거죠.

전 처음에 이 글타래 보고 대체 저 버전의 파폭을 어디서 구하셨나… 했었습니다. ㅋㅋ