You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Jeff Peake <je...@megapathdsl.net> on 2003/03/22 08:14:06 UTC
Unable to get PSML database working
I am using JetSpeed 1.4b3, Tomcat 4.1.18, with SQL Server 2000 Developer.
I can get the User database working just fine.
I am trying to now get the PSML database working. I have set up the
Torque.properties file, and run "ant import". No problems there.
When I try to load up the site, I get the error:
Error retrieving Portal Page: Profile not found.
This is for the ANON user, when I login with any of my other users I get the
same error.
In the jetspeed.log, I see:
[22 Mar 2003 02:00:27 DEBUG] - Profiler: fallback called with:
BaseProfile[anon/en/US/html/default.psml]
[22 Mar 2003 02:00:27 INFO] - Start Initializing service (late):
PsmlManager
[22 Mar 2003 02:00:27 INFO] - Finish Initializing service (late):
PsmlManager
[22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService: Returning locator
string: User:anon$Page:default.psml$MediaType:html$Country:US$Language:en
[22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService: Returning locator
string: User:anon$Page:default.psml$MediaType:html$Country:US$Language:en
[22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService.refresh: no
document found: profile:
User:anon$Page:default.psml$MediaType:htmlCountry:USLanguage:en
[22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService: Returning locator
string: User:anon$Page:default.psml$MediaType:html$Language:en
[22 Mar 2003 02:00:27 ERROR] - PSMLManager: Could not unmarshal the
inputstream
org.xml.sax.SAXParseException: Content is not allowed in trailing section.
at
org.apache.xerces.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:118
9)
at
org.exolab.castor.xml.Unmarshaller.unmarshal(Unmarshaller.java:338)
at
org.exolab.castor.xml.Unmarshaller.unmarshal(Unmarshaller.java:270)
at
org.apache.jetspeed.services.psmlmanager.db.DBUtils.bytesToPortlets(DBUtils.
java:100)
at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.refre
sh(DatabasePsmlManagerService.java:983)
at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.getDo
cument(DatabasePsmlManagerService.java:589)
at
org.apache.jetspeed.services.PsmlManager.getDocument(PsmlManager.java:110)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallback(Jetsp
eedProfilerService.java:767)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackProfil
e(JetspeedProfilerService.java:550)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(Jet
speedProfilerService.java:293)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(Jet
speedProfilerService.java:585)
In my tomcat window I get several:
[Fatal Error] :2:2654: Content is not allowed in trailing section.
I am using the Microsoft JDBC driver, have also tried the jTDS driver with
the same results. Have also tried running a nightly release of
JetSpeed...still get the same error.
My Torque.prop file:
<...snip...>
torque.database.default.adapter=mssql
torque.dsfactory.default.pool.defaultMaxConnections=10
torque.dsfactory.default.pool.maxExpiryTime=3600
torque.dsfactory.default.pool.connectionWaitTimeout=10
torque.dsfactory.default.connection.driver =
com.microsoft.jdbc.sqlserver.SQLServerDriver
torque.dsfactory.default.connection.url =
jdbc:microsoft:sqlserver://MERCURY:1433
torque.dsfactory.default.connection.user = jetspeed
torque.dsfactory.default.connection.password = jetspeed <...snip...>
I have verified that there are entries in the "JETSPEED_USER_PROFILE" table.
Can anyone help???
Thanks
Jeff Peake
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
Re: Unable to get PSML database working
Posted by dulondel yann <du...@wanadoo.fr>.
It's doesn't work perhaps because you don't give to the system the
databasename
torque.dsfactory.default.connection.url =
jdbc:microsoft:sqlserver://MERCURY:1433;databasename=<Name of the database>
----- Original Message -----
From: "Jeff Peake" <je...@megapathdsl.net>
To: "'Jetspeed Users List'" <je...@jakarta.apache.org>
Sent: Sunday, March 23, 2003 2:33 AM
Subject: RE: Unable to get PSML database working
Just and FYI if anyone else has this problem.
I changed the "Profile" column from datatype "Binary", to "Text" in the
Jetspeed_xxx_Profile tables and all is working well.
Jeff Peake
-----Original Message-----
From: Jeff Peake [mailto:jeffpeake@megapathdsl.net]
Sent: Saturday, March 22, 2003 2:14 AM
To: jetspeed-user@jakarta.apache.org
Subject: Unable to get PSML database working
I am using JetSpeed 1.4b3, Tomcat 4.1.18, with SQL Server 2000 Developer.
I can get the User database working just fine.
I am trying to now get the PSML database working. I have set up the
Torque.properties file, and run "ant import". No problems there.
When I try to load up the site, I get the error:
Error retrieving Portal Page: Profile not found.
This is for the ANON user, when I login with any of my other users I get the
same error.
In the jetspeed.log, I see:
[22 Mar 2003 02:00:27 DEBUG] - Profiler: fallback called with:
BaseProfile[anon/en/US/html/default.psml]
[22 Mar 2003 02:00:27 INFO] - Start Initializing service (late):
PsmlManager
[22 Mar 2003 02:00:27 INFO] - Finish Initializing service (late):
PsmlManager
[22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService: Returning locator
string: User:anon$Page:default.psml$MediaType:html$Country:US$Language:en
[22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService: Returning locator
string: User:anon$Page:default.psml$MediaType:html$Country:US$Language:en
[22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService.refresh: no
document found: profile:
User:anon$Page:default.psml$MediaType:htmlCountry:USLanguage:en
[22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService: Returning locator
string: User:anon$Page:default.psml$MediaType:html$Language:en
[22 Mar 2003 02:00:27 ERROR] - PSMLManager: Could not unmarshal the
inputstream
org.xml.sax.SAXParseException: Content is not allowed in trailing section.
at
org.apache.xerces.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:118
9)
at
org.exolab.castor.xml.Unmarshaller.unmarshal(Unmarshaller.java:338)
at
org.exolab.castor.xml.Unmarshaller.unmarshal(Unmarshaller.java:270)
at
org.apache.jetspeed.services.psmlmanager.db.DBUtils.bytesToPortlets(DBUtils.
java:100)
at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.refre
sh(DatabasePsmlManagerService.java:983)
at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.getDo
cument(DatabasePsmlManagerService.java:589)
at
org.apache.jetspeed.services.PsmlManager.getDocument(PsmlManager.java:110)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallback(Jetsp
eedProfilerService.java:767)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackProfil
e(JetspeedProfilerService.java:550)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(Jet
speedProfilerService.java:293)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(Jet
speedProfilerService.java:585)
In my tomcat window I get several:
[Fatal Error] :2:2654: Content is not allowed in trailing section.
I am using the Microsoft JDBC driver, have also tried the jTDS driver with
the same results. Have also tried running a nightly release of
JetSpeed...still get the same error.
My Torque.prop file:
<...snip...>
torque.database.default.adapter=mssql
torque.dsfactory.default.pool.defaultMaxConnections=10
torque.dsfactory.default.pool.maxExpiryTime=3600
torque.dsfactory.default.pool.connectionWaitTimeout=10
torque.dsfactory.default.connection.driver =
com.microsoft.jdbc.sqlserver.SQLServerDriver
torque.dsfactory.default.connection.url =
jdbc:microsoft:sqlserver://MERCURY:1433
torque.dsfactory.default.connection.user = jetspeed
torque.dsfactory.default.connection.password = jetspeed <...snip...>
I have verified that there are entries in the "JETSPEED_USER_PROFILE" table.
Can anyone help???
Thanks
Jeff Peake
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
RE: Unable to get PSML database working
Posted by Jeff Peake <je...@megapathdsl.net>.
Just and FYI if anyone else has this problem.
I changed the "Profile" column from datatype "Binary", to "Text" in the
Jetspeed_xxx_Profile tables and all is working well.
Jeff Peake
-----Original Message-----
From: Jeff Peake [mailto:jeffpeake@megapathdsl.net]
Sent: Saturday, March 22, 2003 2:14 AM
To: jetspeed-user@jakarta.apache.org
Subject: Unable to get PSML database working
I am using JetSpeed 1.4b3, Tomcat 4.1.18, with SQL Server 2000 Developer.
I can get the User database working just fine.
I am trying to now get the PSML database working. I have set up the
Torque.properties file, and run "ant import". No problems there.
When I try to load up the site, I get the error:
Error retrieving Portal Page: Profile not found.
This is for the ANON user, when I login with any of my other users I get the
same error.
In the jetspeed.log, I see:
[22 Mar 2003 02:00:27 DEBUG] - Profiler: fallback called with:
BaseProfile[anon/en/US/html/default.psml]
[22 Mar 2003 02:00:27 INFO] - Start Initializing service (late):
PsmlManager
[22 Mar 2003 02:00:27 INFO] - Finish Initializing service (late):
PsmlManager
[22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService: Returning locator
string: User:anon$Page:default.psml$MediaType:html$Country:US$Language:en
[22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService: Returning locator
string: User:anon$Page:default.psml$MediaType:html$Country:US$Language:en
[22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService.refresh: no
document found: profile:
User:anon$Page:default.psml$MediaType:htmlCountry:USLanguage:en
[22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService: Returning locator
string: User:anon$Page:default.psml$MediaType:html$Language:en
[22 Mar 2003 02:00:27 ERROR] - PSMLManager: Could not unmarshal the
inputstream
org.xml.sax.SAXParseException: Content is not allowed in trailing section.
at
org.apache.xerces.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:118
9)
at
org.exolab.castor.xml.Unmarshaller.unmarshal(Unmarshaller.java:338)
at
org.exolab.castor.xml.Unmarshaller.unmarshal(Unmarshaller.java:270)
at
org.apache.jetspeed.services.psmlmanager.db.DBUtils.bytesToPortlets(DBUtils.
java:100)
at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.refre
sh(DatabasePsmlManagerService.java:983)
at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.getDo
cument(DatabasePsmlManagerService.java:589)
at
org.apache.jetspeed.services.PsmlManager.getDocument(PsmlManager.java:110)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallback(Jetsp
eedProfilerService.java:767)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackProfil
e(JetspeedProfilerService.java:550)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(Jet
speedProfilerService.java:293)
at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(Jet
speedProfilerService.java:585)
In my tomcat window I get several:
[Fatal Error] :2:2654: Content is not allowed in trailing section.
I am using the Microsoft JDBC driver, have also tried the jTDS driver with
the same results. Have also tried running a nightly release of
JetSpeed...still get the same error.
My Torque.prop file:
<...snip...>
torque.database.default.adapter=mssql
torque.dsfactory.default.pool.defaultMaxConnections=10
torque.dsfactory.default.pool.maxExpiryTime=3600
torque.dsfactory.default.pool.connectionWaitTimeout=10
torque.dsfactory.default.connection.driver =
com.microsoft.jdbc.sqlserver.SQLServerDriver
torque.dsfactory.default.connection.url =
jdbc:microsoft:sqlserver://MERCURY:1433
torque.dsfactory.default.connection.user = jetspeed
torque.dsfactory.default.connection.password = jetspeed <...snip...>
I have verified that there are entries in the "JETSPEED_USER_PROFILE" table.
Can anyone help???
Thanks
Jeff Peake
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org