Ok, ... seems I don't need the login-config.xml. That puts me back at the beginning ... so, any idea what I do need to make these errors go away?
18:54:13,716 ERROR [DBaseFetchBean] getTasks: Could not create connection; - nested throwable: (Something unusual has occured to cause the driver to fail. Please report this exception: java.sql.SQLException: No Postgres username specified in startup packet.); - nested throwable: (org.jboss.resource.ResourceException: Could not create connection; - nested throwable: (Something unusual has occured to cause the driver to fail. Please report this exception: java.sql.SQLException: No Postgres username specified in startup packet.)) ----- Original Message ----- From: "David Jencks" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 10, 2002 10:24 PM Subject: Re: [JBoss-user] postgres driver failure ... could not create connection > The simple config (which I should have made the default) is to put the user > and pw in the config-properties in this file. You only need to use a login > module if you don't want cleartext passwords in your config file or need to > have the db user identity depend on the app user identity in some way (in > which case you need a more complicated login module) > > david jencks > > On 2002.08.10 18:35:22 -0400 G.L. Grobe wrote: > > 18:54:13,716 ERROR [DBaseFetchBean] getTasks: Could not create > > connection; - nested throwable: (Something unusual has occured to cause > > the driver to fail. Please report this exception: java.sql.SQLException: > > No Postgres username specified in startup packet.); - nested throwable: > > (org.jboss.resource.ResourceException: Could not create connection; - > > nested throwable: (Something unusual has occured to cause the driver to > > fail. Please report this exception: java.sql.SQLException: No Postgres > > username specified in startup packet.)) > > > > I'm moving my app from 2.4 into 3.0.1 and I see that the default > > postgres-service.xml file (below) has username and password commented out > > and says I must include a login module named PostgresDbRealm ... and from > > the errors above ... am I following that right? Anyone done this or know > > how this is supposed to go? btw - I did comment the application-policy > > section out, but same results. > > > > --- postgres-service.xml --- > > > > <?xml version="1.0" encoding="UTF-8"?> > > > > <!-- ============================================================================ ============ > > --> > > <!-- New ConnectionManager setup for default PostgreSQL dbs > > --> > > <!-- Build jmx-api (build/build.sh all) and view for config > > documentation --> > > <!-- To avoid class not found headaches, copy your postgres driver to > > the jboss lib directory --> > > <!-- ============================================================================ ============ > > --> > > > > <server> > > > > <mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager" > > name="jboss.jca:service=LocalTxCM,name=PostgresDS"> > > <!-- ======================================================= --> > > <!-- You must include a login module configuration named > > PostgresDbRealm > > in your login-conf.xml, here is an example for a > > ConfiguredIdentityLoginModule: > > > > <application-policy name = "PostgresDbRealm"> > > <authentication> > > <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" > > flag = "required"> > > <module-option name = "principal">myuser</module-option> > > <module-option name = "userName">myuser</module-option> > > <module-option name = "password">mypass</module-option> > > <module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=PostgresDS</ module-option> > > </login-module> > > </authentication> > > </application-policy> > > > > NOTE: the application-policy name attribute must match > > SecurityDomainJndiName, and the > > module-option name = "managedConnectionFactoryName" > > must match the object name of the ConnectionManager you are > > configuring here. > > --> > > <!-- ===================================================================== > > --> > > <!--uncomment out this line if you are using the PostgresDbRealm > > above > > <attribute name="SecurityDomainJndiName">PostgresDbRealm</attribute> > > --> > > > > <depends optional-attribute-name="ManagedConnectionFactoryName"> > > <!--embedded mbean--> > > <mbean code="org.jboss.resource.connectionmanager.RARDeployment" > > name="jboss.jca:service=LocalTxDS,name=PostgresDS"> > > <!-- ========== Set the JndiName ======================= --> > > <attribute name="JndiName">PostgresDS</attribute> > > <attribute name="ManagedConnectionFactoryProperties"> > > <properties> > > <config-property name="ConnectionURL" > > type="java.lang.String">jdbc:postgresql://localhost:5432/acais</config-prope rty> > > <config-property name="DriverClass" > > type="java.lang.String">org.postgresql.Driver</config-property> > > <!--set these only if you want only default logins, not > > through JAAS --> > > <config-property name="UserName" > > type="java.lang.String"></config-property> > > <config-property name="Password" > > type="java.lang.String"></config-property> > > </properties> > > > > </attribute> > > > > <!--Below here are advanced properties --> > > <!--hack--> > > <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,n ame=JBoss > > LocalTransaction JDBC Wrapper</depends> > > > > <!--real attributes--> > > </mbean> > > </depends> > > > > <depends optional-attribute-name="ManagedConnectionPool"> > > <!--embedded mbean--> > > <mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" > > name="jboss.jca:service=LocalTxPool,name=PostgresDS"> > > > > <attribute name="MinSize">0</attribute> > > <attribute name="MaxSize">50</attribute> > > <attribute name="BlockingTimeoutMillis">5000</attribute> > > <attribute name="IdleTimeoutMinutes">15</attribute> > > <!--criteria indicates if Subject (from security domain) or app > > supplied > > parameters (such as from getConnection(user, pw)) are used to > > distinguish > > connections in the pool. Choices are > > ByContainerAndApplication (use both), > > ByContainer (use Subject), > > ByApplication (use app supplied params only), > > ByNothing (all connections are equivalent, usually if adapter > > supports > > reauthentication)--> > > <attribute name="Criteria">ByContainer</attribute> > > </mbean> > > > > </depends> > > <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedCo nnectionManager</depends> > > > > <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service= JaasSecurityManager</depends> > > > > <attribute name="TransactionManager">java:/TransactionManager</attribute> > > <!--make the rar deploy! hack till better deployment--> > > <depends>jboss.jca:service=RARDeployer</depends> > > > > > > </mbean> > > > > > > </server> > > > > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > > <HTML><HEAD> > > <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> > > <META content="MSHTML 6.00.2716.2200" name=GENERATOR> > > <STYLE></STYLE> > > </HEAD> > > <BODY bgColor=#ffffff> > > <DIV><FONT face=Arial size=2>18:54:13,716 ERROR [DBaseFetchBean] > > getTasks: Could > > not create connection; - nested throwable: (Something unusual has occured > > to > > cause the driver to fail. Please report this exception: > > java.sql.SQLException: > > No Postgres username specified in startup packet.); - nested throwable: > > (org.jboss.resource.ResourceException: Could not create connection; - > > nested > > throwable: (Something unusual has occured to cause the driver to fail. > > Please > > report this exception: java.sql.SQLException: No Postgres username > > specified in > > startup packet.))<BR></FONT></DIV> > > <DIV><FONT face=Arial size=2>I'm moving my app from 2.4 into 3.0.1 and I > > see > > that the default postgres-service.xml file (below) has username and > > password commented out and says I must include a login module named > > PostgresDbRealm ... and from the errors above ... am I following > > that > > right? Anyone done this or know how this is supposed to go? btw - I did > > comment > > the application-policy section out, but same results.</DIV></FONT> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2>--- postgres-service.xml ---</DIV></FONT> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2><?xml version="1.0" > > encoding="UTF-8"?></FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2> <!-- > > ============================================================================ ============ > > > > --><BR> <!-- New ConnectionManager setup for default > > PostgreSQL > > dbs & nbsp;   ; > > > > --><BR> <!-- Build jmx-api (build/build.sh all) and view for > > config > > documentation &nb sp; > > > > --><BR> <!-- To avoid class not found headaches, copy your > > postgres > > driver to the jboss lib directory --><BR> <!-- > > ============================================================================ ============ > > > > --></FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2><server></FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2> <mbean > > code="org.jboss.resource.connectionmanager.LocalTxConnectionManager" > > name="jboss.jca:service=LocalTxCM,name=PostgresDS"><BR> > > > > <!-- ======================================================= > > --><BR> <!-- You must include a login module > > configuration named > > PostgresDbRealm<BR> in > > your > > login-conf.xml, here is an example for > > a<BR> > > ConfiguredIdentityLoginModule:</FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2> <application-policy > > name = > > "PostgresDbRealm"><BR> > > <authentication><BR> &n bsp; > > > > <login-module code = > > "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = > > "required"><BR> &nbs p; > > > > <module-option name = > > "principal">myuser</module-option><BR>   ; > > > > <module-option name = > > "userName">myuser</module-option><BR> > > > > <module-option name = > > "password">mypass</module-option><BR> > > > > <module-option name = > > "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=PostgresD S</module-option><BR> & nbsp; > > > > </login-module><BR> > > </authentication><BR> > > </application-policy></FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2> NOTE: the > > application-policy > > name attribute must match SecurityDomainJndiName, and > > the<BR> module-option name = > > "managedConnectionFactoryName"<BR> must match the > > object name > > of the ConnectionManager you are configuring here.<BR> > > --><BR> <!-- > > ===================================================================== > > --><BR> <!--uncomment out this line if you are > > using the > > PostgresDbRealm above<BR> <attribute > > name="SecurityDomainJndiName">PostgresDbRealm</attribute><BR> > > > > --></FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2> <depends > > optional-attribute-name="ManagedConnectionFactoryName"><BR> &n bsp; > > > > <!--embedded mbean--><BR> <mbean > > code="org.jboss.resource.connectionmanager.RARDeployment" > > name="jboss.jca:service=LocalTxDS,name=PostgresDS"><BR><!-- > > ========== Set > > the JndiName ======================= > > --><BR> <attribute > > name="JndiName">PostgresDS</attribute><BR> & nbsp; > > > > <attribute > > name="ManagedConnectionFactoryProperties"><BR> &nb sp; > > > > <properties><BR> > > > > <config-property name="ConnectionURL" > > type="java.lang.String">jdbc:postgresql://localhost:5432/acais</config -property><BR>   ; > > > > <config-property name="DriverClass" > > type="java.lang.String">org.postgresql.Driver</config-property><BR> > > > > <!--set these only if you want only default logins, not through JAAS > > --><BR> &nbs p; > > > > <config-property name="UserName" > > type="java.lang.String"></config-property><BR> &nb sp; > > > > <config-property name="Password" > > type="java.lang.String"></config-property><BR> &nb sp; > > > > </properties></FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2> > > </attribute></FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2><!--Below here are advanced properties > > --><BR> > > <!--hack--><BR> > > <depends > > optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeploymen t,name=JBoss > > > > LocalTransaction JDBC Wrapper</depends></FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2> > > <!--real attributes--><BR> > > </mbean><BR> </depends></FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2> <depends > > optional-attribute-name="ManagedConnectionPool"><BR> &nb sp; > > > > <!--embedded mbean--><BR> <mbean > > code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" > > name="jboss.jca:service=LocalTxPool,name=PostgresDS"></FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2> > > <attribute > > name="MinSize">0</attribute><BR>   ; > > > > <attribute > > name="MaxSize">50</attribute><BR> &nbs p; > > > > <attribute > > name="BlockingTimeoutMillis">5000</attribute><BR> > > > > <attribute > > name="IdleTimeoutMinutes">15</attribute><BR>   ; > > > > <!--criteria indicates if Subject (from security domain) or app > > supplied<BR> &nbs p; > > > > parameters (such as from getConnection(user, pw)) are used to > > distinguish<BR> & nbsp; > > > > connections in the pool. Choices > > are<BR> > > > > ByContainerAndApplication (use > > both),<BR> > > > > ByContainer (use > > Subject),<BR> &nb sp; > > > > ByApplication (use app supplied params > > only),<BR> > > > > ByNothing (all connections are equivalent, usually if adapter > > supports<BR> &nbs p; > > > > reauthentication)--><BR> > > <attribute > > name="Criteria">ByContainer</attribute><BR> > > > > </mbean></FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2> > > </depends><BR> <depends > > optional-attribute-name="CachedConnectionManager">jboss.jca:service=Cache dConnectionManager</depends></FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2> <depends > > optional-attribute-name="JaasSecurityManagerService">jboss.security:servi ce=JaasSecurityManager</depends></FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV> > > <DIV><FONT face=Arial size=2> <attribute > > name="TransactionManager">java:/TransactionManager</attribute><BR>& nbsp; > > > > <!--make the rar deploy! hack till better > > deployment--><BR> > > <depends>jboss.jca:service=RARDeployer</depends></FONT></DIV> > > <DIV><FONT face=Arial size=2></FONT> </DIV><FONT face=Arial size=2> > > <DIV><BR> </mbean></DIV> > > <DIV> </DIV> > > <DIV><BR></server><BR></FONT></DIV></BODY></HTML> > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
