Page Comparison

[00:34:34 EDT(-0400)] * lennard1 (n=sparhk@ip68-98-56-21.ph.ph.cox.net) has joined ##uportal
[08:45:03 EDT(-0400)] * michelled (n=michelle@CPE001310472ade-CM0011aefd3ca8.cpe.net.cable.rogers.com) has joined ##uportal
[09:54:28 EDT(-0400)] * EricDalquist (n=EricDalq@static-210-59.vpn.wisc.edu) has joined ##uportal
[10:12:55 EDT(-0400)] * jessm (n=Jess@c-71-232-1-65.hsd1.ma.comcast.net) has joined ##uportal
[10:15:26 EDT(-0400)] * athena (i=4824784e@gateway/web/freenode/x-xedtqwckbqzojznv) has joined ##uportal
[10:40:28 EDT(-0400)] * colinclark (n=colin@142.150.154.101) has joined ##uportal
[10:58:56 EDT(-0400)] * sanji (n=Sanji@luna.it.fit.edu) has joined ##uportal
[11:03:32 EDT(-0400)] <sanji> HI, i have a problem getting uportal to use an external database server
[11:03:48 EDT(-0400)] <sanji> i've changed the needed files to reference the new database
[11:04:06 EDT(-0400)] <sanji> and i get a successful build
[11:04:44 EDT(-0400)] <sanji> but when i navigate to the web page i just get a 404 error the description The requested resource () is not available.
[11:05:11 EDT(-0400)] <EricDalquist> Getting a 404 implies that uPortal is not correctly deployed to your servlet container
[11:09:27 EDT(-0400)] <sanji> is there anything with changing the database that could cause the problem?
[11:11:33 EDT(-0400)] * lennard1 (n=sparhk@wsip-72-215-204-133.ph.ph.cox.net) has joined ##uportal
[11:13:31 EDT(-0400)] <sanji> i do get this when i run dbtest INFO Join test failed: org.jasig.portal.rdbm.DatabaseMetaDataImpl$OracleDb on statement: 'SELECT COUNT(UP_USER.USER_ID) FROM UP_USER, UP_USER_LAYOUT WHERE UP_USER.USER_ID = UP_USER_LAYOUT.USER_ID AND UP_USER.USER_ID=0':
[11:13:42 EDT(-0400)] <EricDalquist> no
[11:13:45 EDT(-0400)] <EricDalquist> not a 404
[11:13:49 EDT(-0400)] <EricDalquist> uPortal doesn
[11:13:53 EDT(-0400)] <EricDalquist> 't ever return 404s
[11:14:00 EDT(-0400)] <EricDalquist> that would be your servlet container
[11:14:11 EDT(-0400)] <EricDalquist> did the same URL work before you changed the DB info?
[11:14:22 EDT(-0400)] <sanji> yeah
[11:14:57 EDT(-0400)] <EricDalquist> are there any Exceptions in your portal.log file?
[11:16:18 EDT(-0400)] <sanji> yeah there is one right after the line i just printed
[11:16:19 EDT(-0400)] <sanji> [java] StatementCallback; bad SQL grammar [SELECT COUNT(UP_USER.USER_ID) FROM UP_USER, UP_USER_LAYOUT WHERE UP_USER.USER_ID = UP_USER_LAYOUT.USER_ID AND UP_USER.USER_ID=0]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND UP_USER.USER_ID=0' at line 1
[11:16:36 EDT(-0400)] <EricDalquist> any others?
[11:16:40 EDT(-0400)] <sanji> no
[11:17:03 EDT(-0400)] <EricDalquist> what version of uPortal are you using?
[11:17:08 EDT(-0400)] <sanji> 3.1.1
[11:18:53 EDT(-0400)] <EricDalquist> after you start tomcat, does your portal.log file end with something like:
[11:18:54 EDT(-0400)] <EricDalquist> INFO [Quartz Scheduler [uPortalTaskScheduler]] quartz.SchedulerFactoryBean.[] Oct/01 10:18:06 - Starting Quartz Scheduler now, after delay of 30 seconds
[11:18:54 EDT(-0400)] <EricDalquist> INFO [Quartz Scheduler [uPortalTaskScheduler]] core.QuartzScheduler.[] Oct/01 10:18:06 - Scheduler uPortalTaskScheduler_$_NON_CLUSTERED started.
[11:21:50 EDT(-0400)] <sanji> no, it ends with some lines that talk about shutting down
[11:22:01 EDT(-0400)] <EricDalquist> ok, so something is failing during startup
[11:22:09 EDT(-0400)] <EricDalquist> take a look in tomcat's catalina.out
[11:24:14 EDT(-0400)] <sanji> is there any specific string of words i'm looking for?
[11:24:31 EDT(-0400)] <sanji> perhaps
[11:24:31 EDT(-0400)] <sanji> SEVERE: Coyote connector has not been started
[11:25:00 EDT(-0400)] <EricDalquist> you can search for /uPortal
[11:27:09 EDT(-0400)] <sanji> SEVERE: Context [/uPortal] startup failed due to previous errors
[11:27:31 EDT(-0400)] <EricDalquist> are there any error messages before that line?
[11:28:03 EDT(-0400)] <sanji> SEVERE: Error filterStart
[11:28:26 EDT(-0400)] <EricDalquist> any stack traces or more detail?
[11:31:20 EDT(-0400)] * michelled (n=michelle@CPE001310472ade-CM0011aefd3ca8.cpe.net.cable.rogers.com) has joined ##uportal