Setting the user/password for interbase

[bambaloo]

I have tried every combination to try and get the user
and password recognised when using Interbase.
Here is my 'interbase-service.xml' with one attempt of
setting the user and password. i am using interserver 2.00 with the latest interclient drivers compiled to 1.3).

I am runnning the alpha 3.0 binary version. Has anyone got a running version of interbase, can i see the xml file PLEASE!!!







<!-- ==================================================================== -->
<!-- JDBC - Initialize the databases -->
<!-- to ConnectionFactoryLoader -->
<!-- ==================================================================== -->


ConnectionURL=jdbc:interbase://bambaloo/c:/temp/test.db
DriverClass=interbase.interclient.Driver UserName=sysdba UserPassword=masterkey

DefaultDS
java:/TransactionManager


<mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter</mbean-ref>
<mbean-ref name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</mbean-ref>
#
#Wed Aug 15 16:17:29 EDT 2001
MinSize=0
MaxSize=10
BlockingTimeoutMillis=5000
IdleTimeoutMinutes=30
CleanupIntervalMinutes=10
MaxIdleTimeoutPercent=1.0


org.jboss.resource.security.ManyToOnePrincipalMapping

user=sysdba password=masterkey

[bambaloo]

This works.. but now having issues with interserver and interclient compatiblities. Bad protocol errors.

<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->

<!-- $Id: interbase-service.xml,v 1.5 2001/11/20 22:15:23 d_jencks Exp $ -->







<!-- ==================================================================== -->
<!-- JDBC - Initialize the databases -->
<!-- to ConnectionFactoryLoader -->
<!-- ==================================================================== -->


ConnectionURL=jdbc:interbase://bambaloo/c:/temp/test.db
DriverClass=interbase.interclient.Driver UserName=sysdba Password=masterkey

TestDS
java:/TransactionManager


<mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter</mbean-ref>
<mbean-ref name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</mbean-ref>
#
#Wed Aug 15 16:17:29 EDT 2001
MinSize=0
MaxSize=10
BlockingTimeoutMillis=5000
IdleTimeoutMinutes=30
CleanupIntervalMinutes=10
MaxIdleTimeoutPercent=1.0


org.jboss.resource.security.ManyToOnePrincipalMapping

user=sysdba password=masterkey

[davidjencks]

I had some problems like this the last time I tried to set this up. Which interbase/firebird/interserver/interclient are you using and where did you get them? You might try firebird + interclient from the firebird site, there are binary interclient packages for windows and rh linux 7.1 (compiling interserver is the hard part).

[bambaloo]

Thanks for the reply.

I am using the interserver/interclient from the Borland site.

http://www.borland.com/devsupport/interbase/interclient/patch202.html

I am using interserver 2.01 and the latest interclient compiled to jdk1.3.


i will try the firebird stuff as you mentioned and let you know how i get on.