Subject Re: Multiple classic servers on a single machine Linux
Author frank.kronbalt
Hey,

sounds reasonable, but I'm missing something somewhere. I show you exactly what I did.

root@ubuntu:/# export FIREBIRD=/opt/firebird2/
root@ubuntu:/# export LD_LIBRARY_PATH=/opt/firebird2/lib:LD_LIBRARY_PATH

root@ubuntu:/opt/firebird2/bin# ./gsec
GSEC> modify SYSDBA -pw masterkey
Warning - maximum 8 significant bytes of password used
GSEC> quit

root@ubuntu:/opt/firebird2/bin# ./isql -user SYSDBA -pass masterkey localhost:3060:database2
Statement failed, SQLCODE = -902
cannot attach to password database
Use CONNECT or CREATE DATABASE to specify a database
SQL> quit;



Thx for any help :)

--- In firebird-support@yahoogroups.com, "Carrell Alex" <Alex.Carrell@...> wrote:
>
>
> What was the environment setting when you ran gsec to set fb2?
>
> GSEC will use the FIREBIRD enviroment variable to work out what it is modifying I believe.
>
>
> When I edit multiple installs on fb (1.5x, 2.1x,2.5x) on linux(ubuntu and suse) I must set the FIREBIRD value and the LDLIBRARY path varible.
>
>
> Alex
>
>
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of frank.kronbalt
> Sent: 01 April 2010 15:06
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: Multiple classic servers on a single machine Linux
>
> Has someone any idea why I get this error? It still tells me that the password on my firebird-2 is wrong?
>
> Thx for any help
>
>
> --- In firebird-support@yahoogroups.com, "frank.kronbalt" <kronbalt@> wrote:
> >
> > Awesome,
> >
> > this is working...you just saved my day :)
> >
> > I just have one little problem left, it refuses me access via SYSDBA
> > with password masterkey, I've tried to change the password in the
> > /opt/firebird2/security2.fdb with gsec using the following command,
> >
> > /opt/firebird2/bin/gsec -database /opt/firebird2/security2.fdb -mo
> > SYSDBA -pw masterkey -user sysdba -pass masterkey
> >
> > Gsec tells me this
> > Warning - maximum 8 significant bytes of password used
> >
> >
> > And in the firebird.log I get this error when I try to log in onto
> > port 3060
> >
> > ubuntu Fri Mar 19 13:21:00 2010
> > operating system directive semctl failed
> >
> >
> > ubuntu Fri Mar 19 13:21:00 2010
> > Permission denied
> >
> >
> >
> > Thx ...
> >
> > --- In firebird-support@yahoogroups.com, "Carrell Alex" <Alex.Carrell@> wrote:
> > >
> > >
> > > Hi,
> > >
> > > picking up the right confile:
> > >
> > > your pretty close:
> > >
> > > Take this conf file:
> > > service gds_db2_1
> > > {
> > > socket_type = stream
> > > wait = no
> > > user = firebird
> > > server =/opt/firebird2_1/bin/fb_inet_server
> > > flags = REUSE
> > > instances =UNLIMITED
> > > env =FIREBIRD=/opt/firebird2_1_3
> > > env +=LD_LIBRARY_PATH=/opt/firebird2_1_3/usr/lib:LD_LIBRARY_PATH
> > > }
> > >
> > >
> > > -Your picking up the conf file found in the environment variable FIREBIRD in both cases as you have no overidden where Firebird will look.
> > > you override environment varaible by using the 'env' keyword in the
> > > xinetd for the shell that FB starts in. Note that I have also
> > > overriden the LD_LIBRARY_PATH, not something you ought to do, but I
> > > run multiple versions of Firebird that way. From what I understand
> > > FB2.5+ will have better built in ways of handling which libraries to
> > > use etc
> > >
> > > alex.
> > >
> > > -----Original Message-----
> > > From: firebird-support@yahoogroups.com
> > > [mailto:firebird-support@yahoogroups.com] On Behalf Of
> > > frank.kronbalt
> > > Sent: 22 March 2010 12:10
> > > To: firebird-support@yahoogroups.com
> > > Subject: [firebird-support] Re: Multiple classic servers on a single
> > > machine Linux
> > >
> > > Hi,
> > >
> > > that's exactly what I did, I have in my first firebird-1
> > > configuration RemoteServicePort = 3050 and on firebird-1 conf
> > > RemoteServicePort = 3060
> > >
> > > The connections are working now, but the firebird-2 loads the
> > > aliases.conf from firebird-1. HMMM frustrating
> > >
> > > My xinetd service configuration for firebird-2 looks like this now
> > >
> > > service firebird2
> > > {
> > > flags = REUSE
> > > socket_type = stream
> > > wait = no
> > > user = firebird
> > > server = /opt/firebird2/bin/fb_inet_server2
> > > #server_args = -d -e /opt/firebird2/
> > > port = 3060
> > > disable = no
> > > }
> > >
> > >
> > > Thx for any answers :)
> > >
> > > Does it have to do something with the lockmanager? If connect on it via 3060 port it launches the lock manager from firebird-1 directory.
> > >
> > >
> > >
> > >
> > >
> > > --- In firebird-support@yahoogroups.com, Milan Tomes - Position <tomes@> wrote:
> > > >
> > > > Hi,
> > > >
> > > > did you made necessary changes in firebird.conf file? You have to
> > > > change RemoteServicePort to appropriate port (3060 in your case
> > > > for
> > > > firebird-2 service).
> > > >
> > > > M. Tomes
> > > >
> > > > Dne 19.03.2010 15:49, frank.kronbalt napsal(a):
> > > > >
> > > > > Hi, I am trying to install multiple servers which listen to
> > > > > different ports on a single machine. Like so ....
> > > > >
> > > > > Install directories,
> > > > >
> > > > > /opt/firebird-1 with executable fb_inet_server-1
> > > > > /opt/firebird-2 with executable fb_inet_server-2 ....
> > > > >
> > > > > I am using xinetd to listen for incoming connection and I've
> > > > > added to /etc/services the following
> > > > >
> > > > > firebird-1 3050/tcp # Firebird 1
> > > > > firebird-1 3050/udp
> > > > > firebird-2 3060/tcp # Firebird 2
> > > > > firebird-2 3060/udp
> > > > >
> > > > > --> /etc/xinet.d/firebird-1
> > > > > service firebird-1
> > > > > {
> > > > > flags = REUSE
> > > > > socket_type = stream
> > > > > wait = no
> > > > > user = firebird
> > > > > server = /opt/firebird/bin/fb_inet_server-1
> > > > > disable = no
> > > > > }
> > > > >
> > > > > --> /etc/xinet.d/firebird-2
> > > > > service firebird-2
> > > > > {
> > > > > flags = REUSE
> > > > > socket_type = stream
> > > > > wait = no
> > > > > user = firebird
> > > > > server = /opt/firebird2/bin/fb_inet_server-2
> > > > > server_args = -d -e /opt/firebird2/ port = 3060 disable = no }
> > > > >
> > > > > When I am trying to connect via telnet to localhost 3050 all
> > > > > seems fine, but on 3060 I get the following error in
> > > > > firebird.log of
> > > > > firebird-2
> > > > >
> > > > > ubuntu Fri Mar 19 05:20:04 2010
> > > > > INET/inet_error: bind errno = 98
> > > > >
> > > > > Anybody got an idea how to solve this problem? and to get the
> > > > > setup working as I need it. Thx a lot :)
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > >
> > > Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links !
> > >
> > > Also search the knowledgebases at http://www.ibphoenix.com
> > >
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > > This message and any attachments (the message) are intended solely
> > > for the addressees and are confidential. If you receive this message
> > > in error, please delete it and immediately notify the sender. Any
> > > use not in accordance with its purpose, any dissemination, copying
> > > or disclosure, either whole or partial is prohibited without prior
> > > formal approval. The internet cannot guarantee the integrity of the message. The companies of Bobst Group do not accept any liability for data corruption, delay, interception or any modification in relation with this message.
> > >
> >
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
> This message and any attachments (the message) are intended solely for the addressees and are
> confidential. If you receive this message in error, please delete it and immediately notify
> the sender. Any use not in accordance with its purpose, any dissemination, copying or disclosure,
> either whole or partial is prohibited without prior formal approval. The internet cannot
> guarantee the integrity of the message. The companies of Bobst Group do not accept any liability
> for data corruption, delay, interception or any modification in relation with this message.
>