Subject Re: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2
Author René Colombe
Post date 2015-03-04T08:38:22Z
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:
-------
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>Disabled</key>
<false/>
<key>EnvironmentVariables</key>
<dict>
<key>PATH</key>
<string>/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</string>
</dict>
<key>InetdCompatibility</key>
<dict>
<key>Wait</key>
<false/>
</dict>
<key>InitGroups</key>
<true/>
<key>Label</key>
<string>org.firebird.gds</string>
<key>OnDemand</key>
<true/>
<key>ProgramArguments</key>
<array>
<string>/Library/Frameworks/Firebird.framework/Resources/bin/fb_inet_server</string>
</array>
<key>Sockets</key>
<dict>
<key>Listeners</key>
<dict>
<key>SockFamily</key>
<string>IPv4</string>
<key>SockServiceName</key>
<string>gds_db</string>
<key>SockType</key>
<string>stream</string>
</dict>
</dict>
<key>UserName</key>
<string>firebird</string>
</dict>
</plist>
———

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 helebor@... [firebird-support] <firebird-support@yahoogroups.com>:

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
__________________________________________________________