Re: [firebird-support] change /tmp/firebird lock dir default value
> Hi, > > > I’am running multiples instances of Firebird CS 2.5 x64. But all instances > uses the same “lock dir”. How I can change the "lock dir” default value > "/tmp/firebird”? > I will appreciate any help. To my understanding, this can get dangerous when you start to separate shared resources (e.g. lock tables) into different directories per instance. Once you start to access a database from several SC/CS instances, you might ask for corruption. See also: http://tracker.firebirdsql.org/browse/CORE-3268 Destination for the the temporary data (sort files etc.) can be configured per instance though. Check out firebird.conf. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
[firebird-support] change /tmp/firebird lock dir default value
Hi, I’am running multiples instances of Firebird CS 2.5 x64. But all instances uses the same “lock dir”. How I can change the "lock dir” default value "/tmp/firebird”? I will appreciate any help. Best Regards Juan E. [Non-text portions of this message have been removed]
Re: [firebird-support] Missing something ...
Thursday, October 13, 2016, 8:38:32 AM, Lester Caine wrote: > OK I've put a new machine together using the latest builds via SUSE > which has given me Nginx, PHP7 and Firebird3. Firebird is working > locally and after a couple of problems Nginx and PHP7 are talking since > they package manager did not complete the configuration. > Now I need to configure FB3 so that it can be accessed from the other > machines on the network which are still running 2.1 and 2.5 and will be > for some time to come. I've done the 'Legacy Authentication' settings, > but I'm still not able to log in from FlameRobin on another machine. > It's a little confusing since SYSDBA existed and I've reset the password > to one of my normal ones (suse is using isql-fb to avoid clash with > mysql) but I'm getting to the point where I need something working and > the 'improvements' in FB3 seem to be fighting against that. :( I've gone > through the same setup on a machine which has a desktop, but flamerobin > dies on that machine so I'm no further forward ... What you might have missed: 1. Did you install the passwords (including SYSDBA) with the clause USING PLUGIN Legacy_UserManager ? If not, your CREATE | ALTER USER statements install them by default as SRP users and the legacy logins won't work. You can check by querying SEC$USERS. 2. Did you configure the UserManager parameter? By default it is Srp. If you want Legacy_Auth to be available, you need to configure it explicitly. 3. Did you modify the WireCrypt parameter from Required to Enabled (or Disabled)? You need to do that for legacy clients because only the Fb3 client knows about wire encryption. Remember that legacy passwords won't be checked beyond 8 characters. Helen -- Kind regards, Helen Borrie
Re: [firebird-support] Reviving an old firebird database (file conversion/programming hints)
> On Oct 13, 2016, at 4:37 AM, Urs Liska fireb...@openlilylib.org > [firebird-support]wrote: > >> Am 13.10.2016 um 10:18 schrieb Elmar Haneke el...@haneke.de >> [firebird-support]: >> >> > 1) >> > I assume on LInux (Debian based Mint version and an Ubuntu flavor) I >> > install a variant of the server (in the repository I find the 2.5 >> > variants, but I'd be also happy installing a downloaded 3.0 >> > instead). >> > Then I need a generic DB manager like e.g. Flamerobin to do general >> > operations and basic DB editing. Or is it equally possible to do that in >> > the terminal? >> > >> > Is that correct? >> >> That's mostly correct. 64Bit Firebird might be unable to open old >> database - I came to tha Problem with an FB 1.5 database moving to FB 2.5. >> >> In that case you have to install either 32Bit package or an old package. >> >> > 2) >> > How can I determine the version of my existing database file? And how >> > can I convert that to a current one in the expected case it isn't >> > compatible with my current installation? There is only the .fdb file and >> > no backup available. >> >> Once accessible FlameRobin can tell you the version of datafile. >> >> To convert to current database you have to create an backup and restore. >> >> Elmar > > So that boils down to having to try out different versions of Firebird until > I find one that can open the DB? > Try gstat -h. It should tell you the version of the database file even if the seever won't open it. Good luck, Ann > > Posted by: Urs Liska > > > ++ > > 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/ > > ++ > > > > VISIT YOUR GROUP New Members 3 > • Privacy • Unsubscribe • Terms of Use >
Re: [firebird-support] Reviving an old firebird database (file conversion/programming hints)
Hello Urs, > 1) > I assume on LInux (Debian based Mint version and an Ubuntu flavor) I > install a variant of the server (in the repository I find the 2.5 > variants, but I'd be also happy installing a downloaded 3.0 instead). > Then I need a generic DB manager like e.g. Flamerobin to do general > operations and basic DB editing. Or is it equally possible to do that in > the terminal? > Is that correct? > >That's mostly correct. 64Bit Firebird might be unable to open > old >database - I came to tha Problem with an FB 1.5 database > moving to FB 2.5. > >In that case you have to install either 32Bit package or an > old package. 64-bit or 32-bit - does not matter. You should be able to open that v.1.5 database with either Fb 1.5 or 2.0.6. You would probably get some errors trying to open it in Fb 2.1 or 2.5. That has nothing to do with 32-bit/64-bit but with changes in the on-disk structure. BTW, Flamerobin is a useful tool but all Firebird packages come with the isql utility, which runs in the command shell. You just have to make sure you run it from its own bin directory with ./ because there are other DBMS out there that have their own [incompatible] binaries with the same name. > > 2) > How can I determine the version of my existing database file? And how > can I convert that to a current one in the > expected case it isn't > compatible with my current installation? There is only the .fdb file and > no backup available. Start by downloading and installing the Fb 1.5.6 tar.gz kit from http://www.firebirdsql.org/en/firebird-1-5/#Linux_x86 ... Put the database file somewhere on the physical filesystem of the host machine. Use the gbak utility to take a backup which can be restored to a higher ODS. > >Once accessible FlameRobin can tell you the version of > datafile. You don't need Flamerobin for that. In the same directory, do ./gstat -h /path/to/database and look for the item "ODS version": 10.0 means it was created under Fb 1.0 10.1 """ Fb 1.5 11.0 """ Fb 2.0 11.1 """ Fb 2.1 11.2 """ Fb 2.5 After taking your gbak backup, decide which version you want to upgrade to. At both 2.0 and 2.1 there were changes that need repair when you restore the database, so read the release notes, especially the installation and migration document, which is common to both major versions. > So that boils down to having to try out different versions of > Firebird until I find one that can open the DB? Only if you want to! ;-) I would start with 1.5 so you have a good backup to work with. If you decide to go straight to 2.5, read the release notes thoroughly; but also get PDF release notes and installation docs for 2.0 and 2.1 from the Documentation zone. Particularly look at the gbak -c[reate] options for fixing data and metadata. because you will still need to do those fix options when you upgrade from the v.1.5 backup to Fb 2.5. I'd also recommend studying all the scripts that are in the tarball kit when you decompress it. When you get back "in the groove" you might consider doing the upgrade to Fb 3. -- Kind regards, Helen Borrie
Re: [firebird-support] Reviving an old firebird database (file conversion/programming hints)
13.10.2016 10:37, Urs Liska fireb...@openlilylib.org [firebird-support] wrote: > So that boils down to having to try out different versions of Firebird until > I find one > that can open the DB? No, you can use gstat from FB 2.5 to see ODS version in database header and derive right FB version from it. Or you can just use FB 2.5 for the file migration as it can read most of old databases. -- WBR, SD. ++ 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Missing something ...
OK I've put a new machine together using the latest builds via SUSE which has given me Nginx, PHP7 and Firebird3. Firebird is working locally and after a couple of problems Nginx and PHP7 are talking since they package manager did not complete the configuration. Now I need to configure FB3 so that it can be accessed from the other machines on the network which are still running 2.1 and 2.5 and will be for some time to come. I've done the 'Legacy Authentication' settings, but I'm still not able to log in from FlameRobin on another machine. It's a little confusing since SYSDBA existed and I've reset the password to one of my normal ones (suse is using isql-fb to avoid clash with mysql) but I'm getting to the point where I need something working and the 'improvements' in FB3 seem to be fighting against that. :( I've gone through the same setup on a machine which has a desktop, but flamerobin dies on that machine so I'm no further forward ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
Re: [firebird-support] Reviving an old firebird database (file conversion/programming hints)
> 1) > I assume on LInux (Debian based Mint version and an Ubuntu flavor) I > install a variant of the server (in the repository I find the 2.5 > variants, but I'd be also happy installing a downloaded 3.0 instead). > Then I need a generic DB manager like e.g. Flamerobin to do general > operations and basic DB editing. Or is it equally possible to do that in > the terminal? > > Is that correct? That's mostly correct. 64Bit Firebird might be unable to open old database - I came to tha Problem with an FB 1.5 database moving to FB 2.5. In that case you have to install either 32Bit package or an old package. > 2) > How can I determine the version of my existing database file? And how > can I convert that to a current one in the expected case it isn't > compatible with my current installation? There is only the .fdb file and > no backup available. Once accessible FlameRobin can tell you the version of datafile. To convert to current database you have to create an backup and restore. Elmar