Subject Re: [firebird-support] Firebird SQL Classic-Server 2.5.3 in OSX 10.10.2
Author René Colombe
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' pabeach@... [firebird-support] <firebird-support@yahoogroups.com>:

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
>
>
> <?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/Se
> rver.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>
>
>
> How can i configure the remote-service-port (standard is 3050) to another one?
>
>
> Thank You
> Regards
>
>
> René
>
>
> [colombe] computer und medien
>
>
> E-Mail: info@...
> Tel.: 030 868 70 48 89
> mobil: 0179 249 48 89
> www.colombe.biz
>
>
>
>
>
>
>
>
> ------------------------------------
> Posted by: =?windows-1252?Q?Ren=E9_Colombe?= <firebirdsql-list@...>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>