Subject | Re: [firebird-support] Multiple instances of firebird not working |
---|---|
Author | cha thu |
Post date | 2015-07-31T04:07:50Z |
Thanks Helen for the response.
I made sure
1. Registry does not have any firebird related keys that are pointing to firebird 1.5 or anything else.
2. echo %FIREBIRD% does not print a value
3. firebird.conf has below two lines. Only line changed was the port from 3050 to 3070
#RemoteServiceName = gds_db
RemoteServicePort = 3070
Ran
instsvc stop -name secondservice
instsvc stop -name DefaultInstance
instsvc r -n secondservice
instsvc install -auto -superserver -guardian -name secondservice
instsvc start -name secondservice
Services are up and running
telnet -a confirms service is listening on 3070 port.
isql localhost/3070:C:\test.fdb -user SYSDBA -pass masterkey
worked for me yay!!
Thank you for pointing out the difference between service name/instance name
On Friday, 31 July 2015, 12:42, "Helen Borrie helebor@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:
At 12:45 p.m. 31/07/2015, preschathu@... [firebird-support] wrote:
Did you open that port in the firewall?
Port 3060 is likely to be a bad choice (a) because it could be in use by another application, or even by Fb 1.5 as its RemoteAuxPort (for events) and (b) it's never a good idea to use a low port number because the high risk of conflicting. A better choice is to use a number in the 10000 - 49000 range, e.g., 13050 or 30500.
The protocol is
localhost\3060:employee
The name that you devised for the second server instance is *not* the same as the symbol represented by RemoteServiceName. They are two totally different things. If you had assigned a different RemoteServiceName (such as e.g., fb_db instead of gds_db, the symbol for port 3050) then you could use that symbol in lieu of the port number. The port number is the right one to use in your case, as it will override any service port name symbol.
Check the firewall and open the port if necessary. Test whether you connect using the correct protocol. If not, then redo your RemoteServicePort assignment using a higher port number. (You could also look in firebird.conf in the Fb 1.5 server installation to see whether it has earmarked port 3060.)
Helen
>I have an 3rd party application running firebird 1.5.
>
>
>I want to install firebird 2.5 instance, with my application, without affecting the other app.
>
>instsvc install -auto -superserver -guardian -name secondservice
>instsvc start -name secondservice
>I also edited the firebird.conf RemoteServicePort parameter to be 3060 before starting the service
>
>
>Service is up and running. Running netstat on command line did not show any services listening on port 3060 though.
Did you open that port in the firewall?
Port 3060 is likely to be a bad choice (a) because it could be in use by another application, or even by Fb 1.5 as its RemoteAuxPort (for events) and (b) it's never a good idea to use a low port number because the high risk of conflicting. A better choice is to use a number in the 10000 - 49000 range, e.g., 13050 or 30500.
>I was unable to connect to the second instance using
>
>isql localhost\secondservice:employee
The protocol is
localhost\3060:employee
The name that you devised for the second server instance is *not* the same as the symbol represented by RemoteServiceName. They are two totally different things. If you had assigned a different RemoteServiceName (such as e.g., fb_db instead of gds_db, the symbol for port 3050) then you could use that symbol in lieu of the port number. The port number is the right one to use in your case, as it will override any service port name symbol.
Check the firewall and open the port if necessary. Test whether you connect using the correct protocol. If not, then redo your RemoteServicePort assignment using a higher port number. (You could also look in firebird.conf in the Fb 1.5 server installation to see whether it has earmarked port 3060.)
Helen