[Solved] Firebird DB not working on linux, with Plastic5 (openSUSE, CentOS)

[Andy22]

Just tested PlasticSCM + firebird v2.5.2/v2.1.5 using CentOS x64 (6.5), openSUSE x32 (12.3).
 
 
with Firebird server 2.5.2/2.1.5:
 

<DbConfig>
  <ProviderName>firebird</ProviderName>
  <ConnectionString>ServerType=0;User=SYSDBA;Password=masterkey;Database={0};Pooling=true;Connection lifetime=15;Charset=UNICODE_FSS;</ConnectionString>
  <DatabasePath></DatabasePath>
</DbConfig>

 

(null) root at (null) ERROR Codice.CM.Server.RepositoryHandler - An invalid connection string argument has been supplied or a required connection string argument has not been supplied.   at FirebirdSql.Data.FirebirdClient.FbConnectionString.Validate () [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.FirebirdClient.FbConnection.set_ConnectionString (System.String value) [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.FirebirdClient.FbConnection..ctor (System.String connectionString) [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbConnection:.ctor (string)
  at tj.b (System.String A_0) [0x00000] in <filename unknown>:0
  at Codice.CM.Data.BaseDataManager.CreateRepositoriesData () [0x00000] in <filename unknown>:0
  at (wrapper synchronized) Codice.CM.Data.BaseDataManager:CreateRepositoriesData ()
  at Codice.CM.Server.RepositoryHandler.InitService () [0x00000] in <filename unknown>:0
5c2b4931-4bb4-49a8-9a31-2fb8a87f9df9 root at Server:freeNAS INFO  Transaction - Transaction timeout -> 120000ms
5c2b4931-4bb4-49a8-9a31-2fb8a87f9df9 root at Server:freeNAS ERROR Trigger - There was an error loading the triggers. Error: An invalid connection string argument has been supplied or a required connection string argument has not been supplied.
root at  INFO  Channel - 'sinklevel' compression mode set. all metadata will be serialized
root at  INFO  Channel - 'BufferPoolMax' is set to '10'. It sets the maximum number of available buffers for object data transfers
root at  INFO  Channel - 'SerializationObjectsAtSink' is set to 'True'. True means SerializationBase descendants are  directly written into the response buffer
 root at  INFO  Channel - Start listening

 
Same problem exists under freeBSD 9.2-p3.
 
 
Firebird Embedded version:

<DbConfig>
  <ProviderName>firebird</ProviderName>
  <ConnectionString>ServerType=1;User=SYSDBA;Password=masterkey;Database={0};Pooling=true;Connection lifetime=15;Charset=UNICODE_FSS;</ConnectionString>
  <DatabasePath></DatabasePath>
</DbConfig>

 

(null) root at (null) ERROR Codice.CM.Server.RepositoryHandler - fbembed   at (wrapper managed-to-native) FB_1061628003_Class:isc_attach_database (intptr[],int16,byte[],int&,int16,byte[])
  at FB_1061628003_Class.IFbClient.isc_attach_database (System.IntPtr[] statusVector, Int16 dbNameLength, System.Byte[] dbName, System.Int32& dbHandle, Int16 parmBufferLength, System.Byte[] parmBuffer) [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.Client.Native.FesDatabase.Attach (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb, System.String dataSource, Int32 port, System.String database) [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect () [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbConnectionInternal:Connect ()
  at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create () [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut () [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbConnectionPool:CheckOut ()
  at FirebirdSql.Data.FirebirdClient.FbConnection.Open () [0x00000] in <filename unknown>:0
7d281ea1-ec28-42dc-a638-9e4df33e71c3 root at Server:freeNAS INFO  Transaction - Transaction timeout -> 120000ms
7d281ea1-ec28-42dc-a638-9e4df33e71c3 root at Server:freeNAS ERROR DataConnection - There was a problem in OpenConnection. fbembed [/root/server/repositories.plastic.fdb]
7d281ea1-ec28-42dc-a638-9e4df33e71c3 root at Server:freeNAS ERROR Trigger - There was an error loading the triggers. Error: Plastic SCM server freeNAS:8087 wasn't able to open a connection to the database. Check the server log (plastic.server.log). Error: fbembed
root at  INFO  Channel - 'sinklevel' compression mode set. all metadata will be serialized
root at  INFO  Channel - 'BufferPoolMax' is set to '10'. It sets the maximum number of available buffers for object data transfers
root at  INFO  Channel - 'SerializationObjectsAtSink' is set to 'True'. True means SerializationBase descendants are  directly written into the response buffer
root at  INFO  Channel - Start listening

 
 
So can we get updated firebird files for linux/freeBSD?
 
 
Thx Andy

[calbzam]

Hi,

 

I will try to install Firebird as backend on a Linux machine. I guess the other backends worked fine, but you want to use Firebird, right?

 

Regards,

Carlos

[Andy22]

Hi,

 

I will try to install Firebird as backend on a Linux machine. I guess the other backends worked fine, but you want to use Firebird, right?

 

Regards,

Carlos

 

 

Yes if possible, i would like to test it against SQLite, MySQL on a freeNAS server.

[calbzam]

Hi,

 

Please, try using this db.conf configuration:

<DbConfig>
<ProviderName>firebird</ProviderName>
<DatabasePath>/path/to/myRepositoryStore</DatabasePath>
<ConnectionString>ServerType=0;Server=localhost;Port=3050;User=SYSDBA;Password=masterkey;Database={0};Pooling=true;Connection Timeout=120;Connection Lifetime=1200;</ConnectionString>
</DbConfig>

Make sure the server user is able to write on the path provided, the user/passwd is correct and the firebird port is fine. 

 

More info here: http://www.plasticscm.net/index.php?/topic/759-invalid-connection-string-after-upgrating-from-sqlite-to-firebird-on-ubuntu/

 

Regards,

Carlos

[Andy22]

Hi,

 

Please, try using this db.conf configuration:

<DbConfig>
<ProviderName>firebird</ProviderName>
<DatabasePath>/path/to/myRepositoryStore</DatabasePath>
<ConnectionString>ServerType=0;Server=localhost;Port=3050;User=SYSDBA;Password=masterkey;Database={0};Pooling=true;Connection Timeout=120;Connection Lifetime=1200;</ConnectionString>
</DbConfig>

Make sure the server user is able to write on the path provided, the user/passwd is correct and the firebird port is fine. 

 

More info here: http://www.plasticscm.net/index.php?/topic/759-invalid-connection-string-after-upgrating-from-sqlite-to-firebird-on-ubuntu/

 

Regards,

Carlos

 

This did fix it for openSUSE, but freeBSD using the same settings still brings the same error.

 

I will try to compile the exact same mono version under freeBSD u ship with the linux packages and see if this helps.

[Andy22]

I just tried ubuntuu 12.04 LTS with the server.zip and mono 2.1 from the ubuntuu reps, while just doing "mono plasticd.exe --console".

 

The server version works fine with the new connection string, but the embedded gives me this:

(null) root at (null) ERROR Codice.CM.Server.RepositoryHandler - fbembed   at (wrapper managed-to-native) FB_1061628003_Class:isc_attach_database (intptr[],int16,byte[],int&,int16,byte[])
  at FB_1061628003_Class.IFbClient.isc_attach_database (System.IntPtr[] statusVector, Int16 dbNameLength, System.Byte[] dbName, System.Int32& dbHandle, Int16 parmBufferLength, System.Byte[] parmBuffer) [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.Client.Native.FesDatabase.Attach (FirebirdSql.Data.Common.DatabaseParameterBuffer dpb, System.String dataSource, Int32 port, System.String database) [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect () [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbConnectionInternal:Connect ()
  at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create () [0x00000] in <filename unknown>:0
  at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut () [0x00000] in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbConnectionPool:CheckOut ()
  at FirebirdSql.Data.FirebirdClient.FbConnection.Open () [0x00000] in <filename unknown>:0
ac0032d3-6545-4603-b00b-dd6caf72e08e root at Server:ubuntu INFO  Transaction - Transaction timeout -> 120000ms
ac0032d3-6545-4603-b00b-dd6caf72e08e root at Server:ubuntu ERROR DataConnection - There was a problem in OpenConnection. fbembed [/db/repositories.plastic.fdb]
ac0032d3-6545-4603-b00b-dd6caf72e08e root at Server:ubuntu ERROR Trigger - There was an error loading the triggers. Error: Plastic SCM server ubuntu:8087 wasn't able to open a connection to the database. Check the server log (plastic.server.log). Error: fbembed
root at  INFO  Channel - 'sinklevel' compression mode set. all metadata will be serialized
root at  INFO  Channel - 'BufferPoolMax' is set to '10'. It sets the maximum number of available buffers for object data transfers
root at  INFO  Channel - 'SerializationObjectsAtSink' is set to 'True'. True means SerializationBase descendants are  directly written into the response buffer
root at  INFO  Channel - Start listening

 

 

I still did not find a way to get the FB server running under freeBSD, will try a Linux Jail configuration next.