Invalid connection string after upgrating from sqlite to firebird on ubuntu

rraf · January 24, 2012

Hi.

I installed plasticSCM 3.0.187.30 inside a Ubutni 10.04 Virtual Machine.

Configure the server, by default it was using sqlite.

I created several test repositories and checked in some files to test it.

Verified that I could access it inside Ubuntu and from external windows machines.

All is well in the world.

It auomatically created a db.conf file for sqlite on install

<ProviderName>sqlite</ProviderName>

<ConnectionString>Data Source={0};Synchronous=OFF;Journal Mode=Delete;Pooling=true</ConnectionString>

<DatabasePath</DatabasePath>

</DBConfig>

I installed firebird using

# sudo su

# apt-get install firebird2.1-super

Configured to automatically start.

# dpkg-reconfigure firebird2.1-super

Set the new firebird user passwd to masterkey

Installed and tested the firebird dev databse. Logged into it and tested no problem.

Stopped the plastic server.

#./plasticsd stop

renamed the current db.conf file to db.conf.sqlite

created a new db.conf file for the firebird install.

(I made sure that the connection string was a single line.)

<ProviderName>firebird</ProviderName>

<ConnectionString>ServerType=0;User=SYSDBA;

Password=masterkey;Database={0};Pooling=true;

connection lifetime=60;Charset=UNICODE_FSS;

</ConnectionString>

</DbConfig>

restarted plastic server and

# ./plasticsd start

And when I try to create a repository I get the following message.

# cm mkrep cwsi-srv-plastic:8084 rraf_test

Error: An Invalid connection string argument has been supplied or a required connection string argument has not bee supplied.

When I change the server type to 1 and run cm mkrep I get this error message instead.

Server cwsi-srv-plastic:8084 wasn't able to open a connection to the database. Check the server's log.

There are no new entries in firebird.log inthe plasticscm/server directory and no other lg files.

Please help. Is there some other config I need to do?

Thanks Rob

manu · January 24, 2012

Hi Rob,

please try using this db.conf configuration:

<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.

rraf · January 24, 2012

thanks. I will try that and get back to you with the results.

Rob

rraf · January 24, 2012

Hi.

I tired it and I got

Error: Connection refused: cwsi-srv-plastic:8084 ---> System.Runtime.RemotingException: Connection Refused.

manu · January 24, 2012

This error is shown when the client is not able to contact with the server.

Is the server up? Are the databases created?Can you send to us the server log? You will find it on the PlasticSCM installation directory, it's called loader.log.txt/plastic.server.log.

rraf · January 24, 2012

Hi.

A few mintues later this showed up in my root console.

Unhandled Exception: System.InvalidOperationException: List has changed.

at System.Collections.ArrayList+SimpleEnumerator.MoveNext () [0x00000] in <filename unknown>:0

at Codice.CM.Server.ActivityScheduler.b () [0x00000] in <filename unknown>:0

at Codice.CM.Server.ActivityScheduler.c () [0x00000] in <filename unknown>:0

rraf · January 24, 2012

I'm having trouble uploading it as it is too big.

I can email itm but here is the latest info.

2012-01-24 11:58:17,726 ActivitySchedulerThread ERROR Security - Starting server without inactive users info

2012-01-24 11:58:17,891 ActivitySchedulerThread EVERY_USER_OR_GROUP 34e8ed6f-966c-4f22-ac3f-f4bb16f99118 Server:cwsi-srv-plastic INFO Transaction - RollbackArea -- Transaction removed 34e8ed6f-966c-4f22-ac3f-f4bb16f99118

2012-01-24 11:58:17,892 ActivitySchedulerThread ERROR Transaction - 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

2012-01-24 11:58:17,892 ActivitySchedulerThread ERROR Security - An exception was thrown loading known seid info:

System.DllNotFoundException: fbembed

at (wrapper managed-to-native) FB_1061628003_Class:isc_attach_database (intptr[],int16,byte[],int&,int16,byte[])