I am not a postgres expert, but I think this is due to something like not defining a postgres user for the user you are running jboss as. I'd look at the postgres docs to see about defining users. As I (just barely) recall, I had this problem on only one of my two linux machines.
david jencks On 2002.08.10 23:39:26 -0400 G.L. Grobe wrote: > 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 > > ------------------------------------------------------- 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
