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
[11:31:52 EDT(-0400)] <sanji> - <Finished cleaning of expired tickets from ticket registry at [Thu Oct 01 11:22:00 EDT 2009]>
[11:31:52 EDT(-0400)] <sanji> Oct 1, 2009 11:22:01 AM org.apache.catalina.core.StandardContext start
[11:31:52 EDT(-0400)] <sanji> SEVERE: Error filterStart
[11:31:52 EDT(-0400)] <sanji> Oct 1, 2009 11:22:01 AM org.apache.catalina.core.StandardContext start
[11:31:52 EDT(-0400)] <sanji> SEVERE: Context [/uPortal] startup failed due to previous errors
[11:31:53 EDT(-0400)] <sanji> Oct 1, 2009 11:22:01 AM org.apache.pluto.core.PortletContainerImpl infoWithName
[11:31:55 EDT(-0400)] <sanji> INFO: Portlet Container [/uPortal-PlutoPortletContainer]: Container destroyed.
[11:31:57 EDT(-0400)] <sanji> log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
[11:32:09 EDT(-0400)] * EricDalquist1 (n=EricDalq@static-210-59.vpn.wisc.edu) has joined ##uportal
[11:32:19 EDT(-0400)] <sanji> and there are some java.net excptions a few lines down when coyote tries to start
[11:32:53 EDT(-0400)] <sanji> BindException: Address already in use<null>:8080
[11:32:54 EDT(-0400)] <EricDalquist1> would you be able to paste the full catalina.out to http://uportal.pastebin.com/
[11:33:01 EDT(-0400)] <EricDalquist1> oh
[11:33:16 EDT(-0400)] <EricDalquist1> well that means something is already running on port 8080
[11:39:07 EDT(-0400)] <sanji> i checked and firefox is the only one that is using 8080
[11:39:18 EDT(-0400)] <EricDalquist> firefox isn't a server
[11:39:22 EDT(-0400)] <EricDalquist> so it wouldn't be using 8080
[11:39:33 EDT(-0400)] <EricDalquist> do you have another tomcat instance running somwhere?
[11:41:27 EDT(-0400)] <sanji> lsof | grep 8080
[11:41:27 EDT(-0400)] <sanji> pcscd 2450 root 4u unix 0xf7b28080 6372 socket
[11:41:27 EDT(-0400)] <sanji> firefox 3213 root mem REG 253,0 58080 14490310 /usr/lib/xulrunner-1.9/components/libimgicon.so
[11:41:27 EDT(-0400)] <sanji> firefox 3213 root 26u unix 0xf76d8080 42698 socket
[11:41:53 EDT(-0400)] <EricDalquist> are you on linux or unix?
[11:41:59 EDT(-0400)] <sanji> linux
[11:42:20 EDT(-0400)] <EricDalquist> try a 'sudo netstat -natp'
[11:43:09 EDT(-0400)] <sanji> no local address is using 8080
[11:43:54 EDT(-0400)] <EricDalquist> huh, I wonder if you had another tomcat instance that got shutdown or something
[11:44:00 EDT(-0400)] <EricDalquist> can you delete your catalina.out
[11:44:03 EDT(-0400)] <EricDalquist> then do a startup
[11:44:05 EDT(-0400)] <sanji> and when i start tomcat it's being used by java
[11:44:12 EDT(-0400)] <EricDalquist> and then paste it to pastebin
[11:44:32 EDT(-0400)] <sanji> alright, hold on
[11:46:59 EDT(-0400)] <sanji> http://uportal.pastebin.com/m360e3e0b
[11:49:45 EDT(-0400)] <sanji> i modified it with what is happening after i try to access the uportal page
[11:49:46 EDT(-0400)] <sanji> http://uportal.pastebin.com/m48739b29
[11:50:49 EDT(-0400)] * lennard1 (n=sparhk@wsip-72-215-204-133.ph.ph.cox.net) has joined ##uportal
[12:08:38 EDT(-0400)] <sanji> Eric: i need to head out and fix some troublesome projectors, if you happen to find something that can help email me at sbrabant(at)fit.edu