Re: [firebird-support] Firebird on mac
2015-03-24
Thread
Schwarze Consulting - Michael Schwarze michael.schwa...@schwarze-consulting.de [firebird-support]
Hm...it's probably not a good idea to put your database into the "system" folder (/Library/...) Have you tried working in your own user directory ~? > Am 24.03.2015 um 21:51 schrieb Felipe Mathais : > > WW. OH MY GODNESS!!! > > GSEC is run now! > But, I creates a diretory “dados” using sudo mkdir in > /Library/Frameworks/Firebird.framework/Resourses/dados and I copied my > database “freedom_homologacao.fbk” on there. When I use gbak to back my > database .fdb I get this error: > > ⌊➝ gbak -c freedom_homologacao.fbk freedom_homologacao.fdb -user sysdba > -pass masterkey > gbak: ERROR:I/O error during "open O_CREAT" operation for file > "/Library/Frameworks/firebird.framework/Versions/A/Resources/dados/freedom_homologacao.fdb" > gbak: ERROR:Error while trying to create file > gbak: ERROR:Permission denied > gbak: ERROR:failed to create database freedom_homologacao.fdb > gbak:Exiting before completion due to errors > > What I do? Please I'm really needing for help. > > Thank you. > Ass: Felipe Mathais > >
Re: [firebird-support] Firebird on mac
2015-03-24
Thread
Schwarze Consulting - Michael Schwarze michael.schwa...@schwarze-consulting.de [firebird-support]
Hi Felipe, I had the same issue with my first installation of firebird on Mac. Looks to me that you haven't added your user to the firebird user group; firebird seems to be quite strict in terms of security / access rights for its respective files. How to add your user depends on your OS X version but you will find plenty of stuff out there...the following worked for me (Yosemite): dseditgroup -o edit -u XXX -p -a YYY -t user firebird Whereby XXX is your computer's administrator and YYY is your user. In general re. installations, etc. for firebird I would recommend the official documentation "Firebird Database Server on Mac OSX" [1]. It's pretty comprehensive, but I have to admit the figuring out the above mentioned user-related issue took me some while, too. Cheers, Michael --- [1] http://www.firebirdsql.org/file/documentation/papers_presentations/html/paper-fb-macosx.html > Am 24.03.2015 um 17:13 schrieb Felipe Mathais fmath...@gmail.com > [firebird-support] : > > I installed firebird 2.5 on mac, and I can’t use commands gbak, gsec, or > connect using isql. > I have exported variable PATH. > But to use gsec -user sysdba -password masterkey for exemple, I get this > message: > “cannot attach to password database > unable to open database” > > What should I do? > > I don’t understand your directory structure too. On Linux, when I install > Firebird, it creates a directory in /opt/firebird, and here > /Library/Frameworks/Firebird.frameworks/, but have several directories with > severals symbolics links. Can someone explain me? > > Thank you. > Ass. Felipe Mathais > >
[firebird-support] Firebird on mac
I installed firebird 2.5 on mac, and I can’t use commands gbak, gsec, or connect using isql. I have exported variable PATH. But to use gsec -user sysdba -password masterkey for exemple, I get this message: “cannot attach to password database unable to open database” What should I do? I don’t understand your directory structure too. On Linux, when I install Firebird, it creates a directory in /opt/firebird, and here /Library/Frameworks/Firebird.frameworks/, but have several directories with severals symbolics links. Can someone explain me? Thank you. Ass. Felipe Mathais
Re: [firebird-support] Firebird on Mac
On 14.11.2014 21:04, 'William, David' david.will...@espn.com [firebird-support] wrote: > > > Hi, > > I am trying to run Firebird on mac (our standard development platform). > I have tried all server packages available on Firebirdsql.org . > > The installation process runs ok. > But whenever I try to start the server, I get this: > > $ fbguard > fbguard: Invalid user (must be firebird, interbase, interbas or root). > > If I try to start the server with the root password, nothing happens. No > output at all and no server running. > > A little bit about my scenario: > > We have some desktop apps running on Windows and we would like to > translate it to web app, keeping the same Firebird databases. We will > use Ruby on Rails. > > We use Macs and we need to setup a local Firebird machine. > > My current Firebird installation have the following binaries: > > 16 -rwxr-xr-x 1 firebird firebird5259 Jul 9 09:26 > changeMultiConnectMode.sh > 24 -rwsr-sr-x 1 firebird firebird8576 Jul 9 09:26 fb_inet_server > 1264 -rwxr-xr-x 1 firebird firebird 643936 Jul 9 09:26 fb_lock_print > 1624 -rwxr-xr-x 1 firebird firebird 830060 Jul 9 09:26 fb_smp_server > 496 -rwxr-xr-x 1 firebird firebird 253648 Jul 9 09:26 fbguard > 504 -rwxr-xr-x 1 firebird firebird 254928 Jul 9 09:26 fbsvcmgr > 520 -rwxr-xr-x 1 firebird firebird 264792 Jul 9 09:26 fbtracemgr > 1080 -rwxr-xr-x 1 firebird firebird 552144 Jul 9 09:26 gbak > 1224 -rwxr-xr-x 1 firebird firebird 623808 Jul 9 09:26 gdef > 656 -rwxr-xr-x 1 firebird firebird 335844 Jul 9 09:26 gfix > 1296 -rwxr-xr-x 1 firebird firebird 663112 Jul 9 09:26 gpre > 1192 -rwxr-xr-x 1 firebird firebird 610228 Jul 9 09:26 gsec > 1144 -rwxr-xr-x 1 firebird firebird 581820 Jul 9 09:26 gstat > 1488 -rwxr-xr-x 1 firebird firebird 759696 Jul 9 09:26 isql > 1152 -rwxr-xr-x 1 firebird firebird 586068 Jul 9 09:26 nbackup > 1152 -rwxr-xr-x 1 firebird firebird 588604 Jul 9 09:26 qli > > Thanks. > David William IIRC on Mac firebird installs in classic mode, so connections are dealt by forked server instances - that is in case of classic fb_inet_server You may try from the terminal: /path/to/isql -user SYSDBA -password whateveritis 127.0.0.1:/path/to/database for further informations: http://www.firebirdsql.org/file/documentation/papers_presentations/html/paper-fb-macosx.html hth, marcus > > [Non-text portions of this message have been removed]
[firebird-support] Firebird on Mac
Hi, I am trying to run Firebird on mac (our standard development platform). I have tried all server packages available on Firebirdsql.org . The installation process runs ok. But whenever I try to start the server, I get this: $ fbguard fbguard: Invalid user (must be firebird, interbase, interbas or root). If I try to start the server with the root password, nothing happens. No output at all and no server running. A little bit about my scenario: We have some desktop apps running on Windows and we would like to translate it to web app, keeping the same Firebird databases. We will use Ruby on Rails. We use Macs and we need to setup a local Firebird machine. My current Firebird installation have the following binaries: 16 -rwxr-xr-x 1 firebird firebird5259 Jul 9 09:26 changeMultiConnectMode.sh 24 -rwsr-sr-x 1 firebird firebird8576 Jul 9 09:26 fb_inet_server 1264 -rwxr-xr-x 1 firebird firebird 643936 Jul 9 09:26 fb_lock_print 1624 -rwxr-xr-x 1 firebird firebird 830060 Jul 9 09:26 fb_smp_server 496 -rwxr-xr-x 1 firebird firebird 253648 Jul 9 09:26 fbguard 504 -rwxr-xr-x 1 firebird firebird 254928 Jul 9 09:26 fbsvcmgr 520 -rwxr-xr-x 1 firebird firebird 264792 Jul 9 09:26 fbtracemgr 1080 -rwxr-xr-x 1 firebird firebird 552144 Jul 9 09:26 gbak 1224 -rwxr-xr-x 1 firebird firebird 623808 Jul 9 09:26 gdef 656 -rwxr-xr-x 1 firebird firebird 335844 Jul 9 09:26 gfix 1296 -rwxr-xr-x 1 firebird firebird 663112 Jul 9 09:26 gpre 1192 -rwxr-xr-x 1 firebird firebird 610228 Jul 9 09:26 gsec 1144 -rwxr-xr-x 1 firebird firebird 581820 Jul 9 09:26 gstat 1488 -rwxr-xr-x 1 firebird firebird 759696 Jul 9 09:26 isql 1152 -rwxr-xr-x 1 firebird firebird 586068 Jul 9 09:26 nbackup 1152 -rwxr-xr-x 1 firebird firebird 588604 Jul 9 09:26 qli Thanks. David William
[firebird-support] FireBird On Mac
Hi, Sorry to bother you. I have an issue about reading and updating data with FireBird database on Mac. We've wrote a program to get data from FireBird database on Mac, but got the error like that: Unhandled Exception: System.DllNotFoundException: fbembed at (wrapper managed-to-native) FirebirdSql.Data.Client.Embedded.FbClient:isc_attach_database (int[],int16,byte[],int&,int16,byte[]) at FirebirdSql.Data.Client.Embedded.FesDatabase.Attach (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb, System.String dataSource, Int32 port, System.String database) [0x0] in :0 at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect () [0x0] in :0 at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbConnectionInternal:Connect () at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create () [0x0] in :0 at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut () [0x0] in :0 at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbConnectionPool:CheckOut () at FirebirdSql.Data.FirebirdClient.FbPoolManager.GetConnection (System.String connectionString) [0x0] in :0 at FirebirdSql.Data.FirebirdClient.FbConnection.Open () [0x0] in :0 [ERROR] FATAL UNHANDLED EXCEPTION: System.DllNotFoundException: fbembed at (wrapper managed-to-native) FirebirdSql.Data.Client.Embedded.FbClient:isc_attach_database (int[],int16,byte[],int&,int16,byte[]) at FirebirdSql.Data.Client.Embedded.FesDatabase.Attach (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb, System.String dataSource, Int32 port, System.String database) [0x0] in :0 at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect () [0x0] in :0 at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbConnectionInternal:Connect () at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create () [0x0] in :0 at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut () [0x0] in :0 at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbConnectionPool:CheckOut () at FirebirdSql.Data.FirebirdClient.FbPoolManager.GetConnection (System.String connectionString) [0x0] in :0 at FirebirdSql.Data.FirebirdClient.FbConnection.Open () [0x0] in :0 It happened when executing this code: FbConnection connection = new FbConnection(connectionString) After I copied fbembed.dll to the same folder with the program's. It still doesn't work. Could we get data from it on Mac? If it can, can you give me some guides or demo projects on Mac? The information related to Mac is really lack. Your help is really appreciated. Thanks. [Non-text portions of this message have been removed]
[firebird-support] firebird on mac - appstore
Hello... the 'Firebird 2.1 on OSX Lion' thread raised a few questions regarding the use of Firebird with applications deployed via the AppStore. The rules regarding file locations and elevated privileges are rather strict, you can basically write to these locations; * |~/Library/Application Support/| * |~/Library/| * |~/Library/Caches/| Has anybody had any success getting anything Firebird database opening in ~/Library without modifying permissions, ACLs, ownership etc? I've got something working in ~/Public/ but you're not allowed to write there... We are currently using Firebird 2.1.3 Classic as embedded, and deploying within the application bundle. Apple aren't likely to be happy about any writing into the bundle, which we don't do - but, the security database lives in there as well and is opened for read / write. Is it possible to locate this somewhere else? We also get lock files created within the bundles. Can the location of those be controlled via the firebird.conf file or FIREBIRD_TMP environment variable? Regards, Peter Lee [Non-text portions of this message have been removed]