RE: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2
<> Err yes. Just a bit. <> As it does for me. <> Nope. gds_db = interbase/firebird = 3050 as per IANA http://linux.about.com/library/cmd/blcmdl5_services.htm Regards Paul
Re: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2
hi paul,
thank you for help.
i have did:
> launchctl unload org.firebird.gds.plist
> launchctl load org.firebird.gds.plist
>
bevor your mail and again after your mail.
but this cant fix the problem then my failure was based on a mistake of the
real function of the /etc/services file.
the original line in /etc/services looks like :
gds_db 3050/udp# gds_db
gds_db 3050/tcp# gds_db
and many lines lower i have set my own entries:
gds_db 5143/udp# gds_db (buhl)
gds_db 5143/tcp# gds_db (buhl)
but without disabling (comment) the upper entries.
so in my /etc/services was the gds_db enries „doubled“ set.
wow, this was the failure!
no it works as expected.
i have meant bevore, all entries in this file can simple set or changed as
needed.
but because the upper entries was processed earlier,
(maybe) the lower entries was ignored then.
is this a special design from firebird?
regards
rené
Am 04.03.2015 um 13:58 schrieb 'Paul Beach' pabe...@waitrose.com
[firebird-support] :
> I am on 10.10.2 and the instructions below worked for me without a problem...
> I saw the port number switching from 3050 -> 3051
>
> But you must:
> launchctl unload org.firebird.gds.plist
> launchctl load org.firebird.gds.plist
> after changing the port no.
>
> Paul
>
> -Original Message-
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Sent: 04 March 2015 01:39
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX
> 10.10.2
>
> hi paul,
>
> thank your for help.
>
> bevore my question i have changed the /etc/service file to this:
>
> gds_db 5143/udp # gds_db (buhl)
> gds_db 5143/tcp # gds_db (buhl)
>
> (without „/„ like the other entrys in this file)
>
> since this, firebird has stpped/started many times (reloading,reboot)
> but firebird seems to ignore the etc/service file on my system. (?)
>
> any other suggestions for osx 10.10. ?
>
> regards
> rené
>
> Am 03.03.2015 um 11:47 schrieb 'Paul Beach' pabe...@waitrose.com
> [firebird-support] :
>
> The following will work.
>
> cd /etc
>
> vi services
> change
>
> gds_db 3051/udp
> gds_db 3051/tcp
>
> for example.
>
> cd /Library/LaunchDaemons
>
> launchctl unload org.firebird.gds.plist
> launchctl load org.firebird.gds.plist
>
> isql>connect 'localhost:/Users/whome/databases/test.fdb' user 'whoever'
> password 'whatever';
>
> in another terminal window:
>
> lsof -i:3051
>
> Regards
> Paul
>
> > I am using firebird sql classic-server 2.5.3 under mac osx 10.10.2
> > How can i change the remote-service-port (standard is 3050) to another one?
> >
> >
> > i know, in windows and linux this setting is managed by an entry in
> > „firebird.conf"
> >
> >
> > in osx there is also a „firebird.conf" in
> > /Library/Frameworks/Firebird.framework/A/Resources/English-lproj/var/
> > but changes in this file:
> > RemoteServiceName = gds_db
> > RemoteServicePort = 5143
> > have no result in firebird. the port is the same as before (3050)
> >
> >
> > i have read the readme-file (firebird.conf.txt) in
> > /Library/Frameworks/Firebird.framework/A/Resources/doc
> > But i only found this in „Darwin“ section:
> >
> >
> > "Darwin on the other hand first checks the environment variable FIREBIRD.
> > If not found, it [... John, please describe the „bundle" stuff here].
> > As a last resort it too falls back to "/usr/local/firebird“.“
> >
> >
> > It seems that this section is not complete written by the author.
> > I have searched in internet many times for help but i have not found a
> > answer for this „problem“.
> > (with the right knowledege not really a problem)
> >
> >
> > in osx i have found two other files they are maybe used for configuring
> > firebird.
> > „org.firebird.gdl.plist" and "StartupParameters.plist"
> > but both file has other syntax so i cant adopt the settigs from
> > firebird.conf to this files.
> >
> >
> > these files are:
> > /Library/Frameworks/Firebird.framework/A/Resources/FirebirdSS/StartupParameters.plist
> >
> >
> > {
> > Description = "Firebird SQL Database server";
> > Provides = ("Firebird Server");
> > Requires = ("DirectoryServices");
> > Uses = ("Disks", "NFS");
> > OrderPreference = "None";
> > }
> >
> >
> > and:
RE: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2
I am on 10.10.2 and the instructions below worked for me without a problem...
I saw the port number switching from 3050 -> 3051
But you must:
launchctl unload org.firebird.gds.plist
launchctl load org.firebird.gds.plist
after changing the port no.
Paul
-Original Message-
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 04 March 2015 01:39
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2
hi paul,
thank your for help.
bevore my question i have changed the /etc/service file to this:
gds_db 5143/udp# gds_db (buhl)
gds_db 5143/tcp# gds_db (buhl)
(without / like the other entrys in this file)
since this, firebird has stpped/started many times (reloading,reboot)
but firebird seems to ignore the etc/service file on my system. (?)
any other suggestions for osx 10.10. ?
regards
rené
Am 03.03.2015 um 11:47 schrieb 'Paul Beach' pabe...@waitrose.com
[firebird-support] :
The following will work.
cd /etc
vi services
change
gds_db 3051/udp
gds_db 3051/tcp
for example.
cd /Library/LaunchDaemons
launchctl unload org.firebird.gds.plist
launchctl load org.firebird.gds.plist
isql>connect 'localhost:/Users/whome/databases/test.fdb' user 'whoever'
password 'whatever';
in another terminal window:
lsof -i:3051
Regards
Paul
> I am using firebird sql classic-server 2.5.3 under mac osx 10.10.2
> How can i change the remote-service-port (standard is 3050) to another one?
>
>
> i know, in windows and linux this setting is managed by an entry in
> firebird.conf"
>
>
> in osx there is also a firebird.conf" in
> /Library/Frameworks/Firebird.framework/A/Resources/English-lproj/var/
> but changes in this file:
> RemoteServiceName = gds_db
> RemoteServicePort = 5143
> have no result in firebird. the port is the same as before (3050)
>
>
> i have read the readme-file (firebird.conf.txt) in
> /Library/Frameworks/Firebird.framework/A/Resources/doc
> But i only found this in Darwin section:
>
>
> "Darwin on the other hand first checks the environment variable FIREBIRD.
> If not found, it [... John, please describe the bundle" stuff here].
> As a last resort it too falls back to "/usr/local/firebird.
>
>
> It seems that this section is not complete written by the author.
> I have searched in internet many times for help but i have not found a answer
> for this problem.
> (with the right knowledege not really a problem)
>
>
> in osx i have found two other files they are maybe used for configuring
> firebird.
> org.firebird.gdl.plist" and "StartupParameters.plist"
> but both file has other syntax so i cant adopt the settigs from firebird.conf
> to this files.
>
>
> these files are:
> /Library/Frameworks/Firebird.framework/A/Resources/FirebirdSS/StartupParameters.plist
>
>
> {
> Description = "Firebird SQL Database server";
> Provides = ("Firebird Server");
> Requires = ("DirectoryServices");
> Uses = ("Disks", "NFS");
> OrderPreference = "None";
> }
>
>
> and:
> /Library/LaunchDeamons/org.firebird.gdl.plist
>
>
>
> "http://www.apple.com/DTDs/PropertyList-1.0.dtd";>
>
>
> Disabled
>
> EnvironmentVariables
>
> PATH
>
> /usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Applications/Server.app/Contents/ServerRoot/usr/bin:/Applications/Se
> rver.app/Contents/ServerRoot/usr/sbin:/usr/local/sbin
>
> InetdCompatibility
>
> Wait
>
>
> InitGroups
>
> Label
> org.firebird.gds
> OnDemand
>
> ProgramArguments
>
> /Library/Frameworks/Firebird.framework/Resources/bin/fb_inet_server
>
> Sockets
>
> Listeners
>
> SockFamily
> IPv4
> SockServiceName
> gds_db
> SockType
> stream
>
>
> UserName
> firebird
>
>
>
>
> How can i configure the remote-service-port (standard is 3050) to another one?
>
>
> Thank You
> Regards
>
>
> René
>
>
> [colombe] computer und medien
Re: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2
hi helen,
thank your for help.
my settings was already:
> RemoteServiceName = gds_db
> RemoteServicePort = 5143
>
and i have tested no with:
> # RemoteServiceName = gds_db
> RemoteServicePort = 5143
>
after restart the service (and the hwole maschine),
firebird is watching again on port 3050 :-(
if i scan the for open ports locally, i have a response from firebird gds on
port 3050
both „known“ settings in /etc/service and firebird.conf are ignored from
firebird in osx.
i think there must be other settings in other files.
there are two other "more osx like“ setting files in firebird:
1.
/Library/Frameworks/Firebird.framework/A/Resources/FirebirdSS/StartupParameters.plist
content of StartupParameters.plist
-
{
Description = "Firebird SQL Database server";
Provides= ("Firebird Server");
Requires= ("DirectoryServices");
Uses= ("Disks", "NFS");
OrderPreference = "None";
}
2.
/Library/LaunchDeamons/org.firebird.gdl.plist
content of org.firebird.gdl.plist:
---
http://www.apple.com/DTDs/PropertyList-1.0.dtd";>
Disabled
EnvironmentVariables
PATH
/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Applications/Server.app/Contents/ServerRoot/usr/bin:/Applications/Server.app/Contents/ServerRoot/usr/sbin:/usr/local/sbin
InetdCompatibility
Wait
InitGroups
Label
org.firebird.gds
OnDemand
ProgramArguments
/Library/Frameworks/Firebird.framework/Resources/bin/fb_inet_server
Sockets
Listeners
SockFamily
IPv4
SockServiceName
gds_db
SockType
stream
UserName
firebird
———
maybe there are optional settings in the „Listeners“ part from
org.firebird.gdl.plist
but i dont know which exactly.
regards
rené
Am 04.03.2015 um 02:23 schrieb Helen Borrie hele...@iinet.net.au
[firebird-support] :
> At 01:38 p.m. 4/03/2015, you wrote:
> >bevore my question i have changed the /etc/service file to this:
> >
> >gds_db 5143/udp # gds_db (buhl)
> >gds_db 5143/tcp # gds_db (buhl)
> >
> >(without „/„ like the other entrys in this file)
> >
> >since this, firebird has stpped/started many times (reloading,reboot)
> >but firebird seems to ignore the etc/service file on my system. (?)
> >
> >any other suggestions for osx 10.10. ?
>
> Editing the services file does not open ports in the firewall. Have you
> checked whether port 5143 is open in the firewall?
>
> Next, have you tried setting the port in firebird.conf:
>
> # TCP Protocol Settings
> #
> # The TCP Service name/Port number to be used for client database
> # connections.
> #
> # It is only necessary to change one of the entries, not both. The
> # order of precedence is the 'RemoteServiceName' (if an entry is
> # found in the 'services.' file) then the 'RemoteServicePort'.
> #
> # Type: string, integer
> #
> #RemoteServiceName = gds_db
> #RemoteServicePort = 3050
>
> The commented settings are the Firebird defaults. You can try to override
> them by deleting the comment marker # on RemoteServicePort and setting the
> new port:
>
> #RemoteServiceName = gds_db
> RemoteServicePort = 5143
>
> After saving the changes in firebird.conf, don't forget to
> 1) open the new port in the firewall and
> 2) shut down and restart any fb-inet_server processes.
>
> I'm not sure, but you might have to restart xinetd before step 2), as well. I
> don't have access to an OSX box to test that.
>
> Helen Borrie, Support Consultant, IBPhoenix (Pacific)
> Author of "The Firebird Book" and "The Firebird Book Second Edition"
> http://www.firebird-books.net
> __
>
>
>
Re: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2
At 01:38 p.m. 4/03/2015, you wrote: >bevore my question i have changed the /etc/service file to this: > >gds_db 5143/udp# gds_db (buhl) >gds_db 5143/tcp# gds_db (buhl) > >(without / like the other entrys in this file) > >since this, firebird has stpped/started many times (reloading,reboot) >but firebird seems to ignore the etc/service file on my system. (?) > >any other suggestions for osx 10.10. ? Editing the services file does not open ports in the firewall. Have you checked whether port 5143 is open in the firewall? Next, have you tried setting the port in firebird.conf: # TCP Protocol Settings # # The TCP Service name/Port number to be used for client database # connections. # # It is only necessary to change one of the entries, not both. The # order of precedence is the 'RemoteServiceName' (if an entry is # found in the 'services.' file) then the 'RemoteServicePort'. # # Type: string, integer # #RemoteServiceName = gds_db #RemoteServicePort = 3050 The commented settings are the Firebird defaults. You can try to override them by deleting the comment marker # on RemoteServicePort and setting the new port: #RemoteServiceName = gds_db RemoteServicePort = 5143 After saving the changes in firebird.conf, don't forget to 1) open the new port in the firewall and 2) shut down and restart any fb-inet_server processes. I'm not sure, but you might have to restart xinetd before step 2), as well. I don't have access to an OSX box to test that. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of "The Firebird Book" and "The Firebird Book Second Edition" http://www.firebird-books.net __
Re: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2
hi paul,
thank your for help.
bevore my question i have changed the /etc/service file to this:
gds_db 5143/udp# gds_db (buhl)
gds_db 5143/tcp# gds_db (buhl)
(without „/„ like the other entrys in this file)
since this, firebird has stpped/started many times (reloading,reboot)
but firebird seems to ignore the etc/service file on my system. (?)
any other suggestions for osx 10.10. ?
regards
rené
Am 03.03.2015 um 11:47 schrieb 'Paul Beach' pabe...@waitrose.com
[firebird-support] :
> The following will work.
>
> cd /etc
>
> vi services
> change
>
> gds_db 3051/udp
> gds_db 3051/tcp
>
> for example.
>
> cd /Library/LaunchDaemons
>
> launchctl unload org.firebird.gds.plist
> launchctl load org.firebird.gds.plist
>
> isql>connect 'localhost:/Users/whome/databases/test.fdb' user 'whoever'
> password 'whatever';
>
> in another terminal window:
>
> lsof -i:3051
>
> Regards
> Paul
>
> > I am using firebird sql classic-server 2.5.3 under mac osx 10.10.2
> > How can i change the remote-service-port (standard is 3050) to another one?
> >
> >
> > i know, in windows and linux this setting is managed by an entry in
> > „firebird.conf"
> >
> >
> > in osx there is also a „firebird.conf" in
> > /Library/Frameworks/Firebird.framework/A/Resources/English-lproj/var/
> > but changes in this file:
> > RemoteServiceName = gds_db
> > RemoteServicePort = 5143
> > have no result in firebird. the port is the same as before (3050)
> >
> >
> > i have read the readme-file (firebird.conf.txt) in
> > /Library/Frameworks/Firebird.framework/A/Resources/doc
> > But i only found this in „Darwin“ section:
> >
> >
> > "Darwin on the other hand first checks the environment variable FIREBIRD.
> > If not found, it [... John, please describe the „bundle" stuff here].
> > As a last resort it too falls back to "/usr/local/firebird“.“
> >
> >
> > It seems that this section is not complete written by the author.
> > I have searched in internet many times for help but i have not found a
> > answer for this „problem“.
> > (with the right knowledege not really a problem)
> >
> >
> > in osx i have found two other files they are maybe used for configuring
> > firebird.
> > „org.firebird.gdl.plist" and "StartupParameters.plist"
> > but both file has other syntax so i cant adopt the settigs from
> > firebird.conf to this files.
> >
> >
> > these files are:
> > /Library/Frameworks/Firebird.framework/A/Resources/FirebirdSS/StartupParameters.plist
> >
> >
> > {
> > Description = "Firebird SQL Database server";
> > Provides = ("Firebird Server");
> > Requires = ("DirectoryServices");
> > Uses = ("Disks", "NFS");
> > OrderPreference = "None";
> > }
> >
> >
> > and:
> > /Library/LaunchDeamons/org.firebird.gdl.plist
> >
> >
> >
> > > "http://www.apple.com/DTDs/PropertyList-1.0.dtd";>
> >
> >
> > Disabled
> >
> > EnvironmentVariables
> >
> > PATH
> >
> > /usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Applications/Server.app/Contents/ServerRoot/usr/bin:/Applications/Se
> > rver.app/Contents/ServerRoot/usr/sbin:/usr/local/sbin
> >
> > InetdCompatibility
> >
> > Wait
> >
> >
> > InitGroups
> >
> > Label
> > org.firebird.gds
> > OnDemand
> >
> > ProgramArguments
> >
> > /Library/Frameworks/Firebird.framework/Resources/bin/fb_inet_server
> >
> > Sockets
> >
> > Listeners
> >
> > SockFamily
> > IPv4
> > SockServiceName
> > gds_db
> > SockType
> > stream
> >
> >
> > UserName
> > firebird
> >
> >
> >
> >
> > How can i configure the remote-service-port (standard is 3050) to another
> > one?
> >
> >
> > Thank You
> > Regards
> >
> >
> > René
> >
> >
> > [colombe] computer und medien
> >
> >
> > E-Mail: i...@colombe.biz
> > Tel.: 030 868 70 48 89
> > mobil: 0179 249 48 89
> > www.colombe.biz
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Posted by: =?windows-1252?Q?Ren=E9_Colombe?=
> >
> >
> > ++
> >
> > Visit http://www.firebirdsql.org and click the Documentation item
> > on the main (top) menu. Try FAQ and other links from the left-side menu
> > there.
> >
> > Also search the knowledgebases at
> > http://www.ibphoenix.com/resources/documents/
> >
> > ++
> >
> >
> > Yahoo Groups Links
> >
> >
> >
>
>
>
RE: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2
The following will work.
cd /etc
vi services
change
gds_db 3051/udp
gds_db 3051/tcp
for example.
cd /Library/LaunchDaemons
launchctl unload org.firebird.gds.plist
launchctl load org.firebird.gds.plist
isql>connect 'localhost:/Users/whome/databases/test.fdb' user 'whoever'
password 'whatever';
in another terminal window:
lsof -i:3051
Regards
Paul
> I am using firebird sql classic-server 2.5.3 under mac osx 10.10.2
> How can i change the remote-service-port (standard is 3050) to another one?
>
>
> i know, in windows and linux this setting is managed by an entry in
> firebird.conf"
>
>
> in osx there is also a firebird.conf" in
> /Library/Frameworks/Firebird.framework/A/Resources/English-lproj/var/
> but changes in this file:
> RemoteServiceName = gds_db
> RemoteServicePort = 5143
> have no result in firebird. the port is the same as before (3050)
>
>
> i have read the readme-file (firebird.conf.txt) in
> /Library/Frameworks/Firebird.framework/A/Resources/doc
> But i only found this in Darwin section:
>
>
> "Darwin on the other hand first checks the environment variable FIREBIRD.
> If not found, it [... John, please describe the bundle" stuff here].
> As a last resort it too falls back to "/usr/local/firebird.
>
>
> It seems that this section is not complete written by the author.
> I have searched in internet many times for help but i have not found a answer
> for this problem.
> (with the right knowledege not really a problem)
>
>
> in osx i have found two other files they are maybe used for configuring
> firebird.
> org.firebird.gdl.plist" and "StartupParameters.plist"
> but both file has other syntax so i cant adopt the settigs from firebird.conf
> to this files.
>
>
> these files are:
> /Library/Frameworks/Firebird.framework/A/Resources/FirebirdSS/StartupParameters.plist
>
>
> {
> Description = "Firebird SQL Database server";
> Provides= ("Firebird Server");
> Requires= ("DirectoryServices");
> Uses= ("Disks", "NFS");
> OrderPreference = "None";
> }
>
>
> and:
> /Library/LaunchDeamons/org.firebird.gdl.plist
>
>
>
> "http://www.apple.com/DTDs/PropertyList-1.0.dtd";>
>
>
> Disabled
>
> EnvironmentVariables
>
> PATH
>
> /usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Applications/Server.app/Contents/ServerRoot/usr/bin:/Applications/Se
> rver.app/Contents/ServerRoot/usr/sbin:/usr/local/sbin
>
> InetdCompatibility
>
> Wait
>
>
> InitGroups
>
> Label
> org.firebird.gds
> OnDemand
>
> ProgramArguments
>
>
> /Library/Frameworks/Firebird.framework/Resources/bin/fb_inet_server
>
> Sockets
>
> Listeners
>
> SockFamily
> IPv4
> SockServiceName
> gds_db
> SockType
> stream
>
>
> UserName
> firebird
>
>
>
>
> How can i configure the remote-service-port (standard is 3050) to another one?
>
>
> Thank You
> Regards
>
>
> René
>
>
> [colombe] computer und medien
>
>
> E-Mail: i...@colombe.biz
> Tel.:030 868 70 48 89
> mobil: 0179 249 48 89
> www.colombe.biz
>
>
>
>
>
>
>
>
>
> Posted by: =?windows-1252?Q?Ren=E9_Colombe?=
>
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu. Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
>
>
> Yahoo Groups Links
>
>
>
