Jump to content
oceanfront

Firebird under Linux

Recommended Posts

I struggled a bit with getting plastic working with Firebird under Linux, so I thought I'd post the Caramilk secret in hopes it might save someone else some time.

First off, it is unclear whether the embedded db is included (it is not, Plastic uses SQLLite now).

So, the first step is to install Firebird.

The Plastic administrator's guide says:

To use Firebird, create a file called db.conf, with this content:

<DbConfig>

<ProviderName>firebird</ProviderName>

<DatabasePath>c:\myRepositoryStore</DatabasePath>

</DbConfig>

which, of course, does not work.

The correct config is:

<DbConfig>

<ProviderName>firebird</ProviderName>

<DatabasePath>/path/to/myRepositoryStore</DatabasePath>

<ConnectionString>

ServerType=0;Server=localhost;Port=3050;User=ozzy;Password=harriet;Database={0};Pooling=true;Connection Timeout=120;Connection Lifetime=1200;

</ConnectionString>

</DbConfig>

Also, the directory /path/to/myRepositoryStore must be writable by the firebird user, so:

chown firebird.firebird /path/to/myRepositoryStore

Once you have made these changes, restart Plastic, and you should see a firebird database (fdb file) appear in /path/to/myRepositoryStore

I hope this is helpful.

Share this post


Link to post
Share on other sites

Very useful!

I'm afraid the doc you found works for Windows only.

The "embedded" on Linux is not a good option (it doesn't work, ok, it does but Firebird crashes with more than one thread). That's why we used to package a Firebird build, but we switched to SQLite a few months ago.

Question: don't we say SQLite is the default and only used for eval purposes during the install? Maybe we only say it if you run the installer in GUI mode.

Check this: http://www.plasticscm.com/infocenter/technical-articles/kb-plastic-scm-database-backend-migrating-sqlite-to-mysql.aspx, what we're missing is something similar but for SQLite to Firebird :)

Thanks.

Share this post


Link to post
Share on other sites

You did say sqlite is embedded for evaluation.

When I am evaluating a tool, I like to get as close to a production environment as possible, so the behavior doesn't change when we "go live".

And yes, an sqlite to firebird doc would be helpful.

PS The sqlite to mysql link you posted returns 404.

Share this post


Link to post
Share on other sites

You shouldn't be using Firebird for your databases in Linux server in 2021. The default and recommended databases backend is the detault one: Jet.

Regards,

Carlos.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...