Thread: [Coursework-help] Re: Two problems with our 2.5 installation
Brought to you by:
ianeboston,
john765367
Menu
▾
▴
coursework-help
|
From: Ian B. <ie...@tf...> - 2003-10-20 20:10:46
|
Ray, This could be a complete red herring. But when we first used the 2.5 system it had the capability to manage fail over on the Oracle connections. ie 2 backends. When the first connection fails it switches to the backup. Once or twice our developers left the connections in oracle.properties to the Stanford Oracle server. The result was that all of a sudden we would loose all sessions, and the course content and logins would change as if by magic. It even appeared to switch JDBC drivers mid flow. We changed passwords and urls on the connections in the Postgres version to ensure that it didn't happen. However, I dont know quite what would happen, if a connection was switched to failover and the failover connection failed. It could account for the behaviour you are seeing. ( The "unable to relogin until server is restarted" looks like a symptom of this. ) Have a look in oracle.properties and if there are any references to other servers. Its probably also worth removing any references to Stanford servers in the other config files. We will check the code in CVS to fix this. HTH Ian BTW, I've cc'd in the help list for the Postgres version. Daisy, sorry, this problem may have been caused by the port. Ray Davis wrote: > We've installed the 2.5 / PostgreSQL kit from Sourceforge for > evaluation. I'm stymied by two big problems: > > 1) As an administrator, I can create assignments and they preview > correctly. When I switch to the student view, or when I log in as a > student, and click on the assignment link, e.g.: > > > /coursework/servlet/Assignments?action=assignment&course=5360&assignment=5001&key=1838421524 > > > I get a popup window warning me about the 60 minute time limit, but the > main browser window is blank. A "View Source" shows only an empty HTML > document. I don't find any error messages in the log files. I've put > some more debug-level logging into > "coursework_postgres/src/Announcements.java" myself, but so far nothing > odd seems to be happening. > > 2) When the software tries to connect to an unavailable service, all > users lose their sessions and are unable to log in again until the > servers are restarted. (This is my tentative understanding of what's > happening, anyway.) > > We were first able to reproduce this by selecting the "Admin Print > Reserve" link: > > /coursework/servlet/AdminPrintReserve?action=process > > Not surprisingly, since it still pointed to Stanford's system, this > returned a 500 error, and the following message was in the error log: > > DEBUG [Thread-20] (AdminPrintReserve.java) - problem process Library > ReserveConnection refused. Check that the hostname and port are correct > and that the postmaster is accepting TCP/IP connections. > > The surprising part was that authentication stopped working. And, as > with the first problem, no relevant errors or warnings were being logged. > > Given the inconvenience, I commented out that line in > "dtl/admin/nexus/adminsite.dtl". However, we're still occasionally > bumping into the same symptoms, although I haven't been able to track > down the new trigger. > > Has anyone else had similar issues and solved them? > > Thanks, > Ray > ======================== > Ray Davis, Web Services > Educational Technology Services > University of California, Berkeley > > Phone: 510-642-8581 > > -++**==--++**==--++**==--++**==--++**==--++**==--++**==--++**== > This message was posted through the Stanford campus mailing list > server. If you wish to unsubscribe from this mailing list, send the > message body of "unsubscribe coursework_eval_tech" to > maj...@li... > |
|
From: Leonardo H. <her...@or...> - 2003-10-21 15:34:04
|
Hello, I'm getting an error when trying to connect to database. For example, when I try to access "User Registration" or "User Login" I get this error: -- WARN [Thread 9] (UserRegistration.java) - DB Error: connection was null I can't find any other log to help me solve this problem. Any ideas? Here is my oracle.properties: --------------------------------- dbDriver=org.postgresql.Driver minConns=5 maxConns=25 maxConnTime=1.0 # mode can be FAILOVER or ORACLE_CONNECTION_POOL(default) #mode=FAILOVER dbDriver=org.postgresql.Driver dbServer=jdbc\:postgresql\://archie/cw dbLogin=hernandez dbPassword= # add the following properties for DUAL (FAILOVER) mode dbServer_failover=jdbc\:postgresql\://archie/cw dbLogin_failover=hernandez dbPassword_failover= ---------------------------------- I access a remote database without password, maybe this is the problem. Any Ideas? -Leonardo |
|
From: Sam O. <sa...@lo...> - 2003-10-21 16:44:28
|
Are you able to access the remote database through psql? I turned full logging on in Postgres to better debug Coursework. This shows me all queries, query errors, etc. I uncommented these 3 lines in Postgres: ------------------------ log_statement = true log_duration = true log_timestamp = true ------------------------ The only other line I uncommented in postgresql.conf was: tcpip_socket = true Sam Leonardo Hernandez wrote: > Hello, > > I'm getting an error when trying to connect to database. For example, > when I try to access "User Registration" or "User Login" I get this > error: > > -- WARN [Thread 9] (UserRegistration.java) - DB Error: connection was > null > > I can't find any other log to help me solve this problem. Any ideas? > Here is my oracle.properties: > > --------------------------------- > dbDriver=org.postgresql.Driver > minConns=5 > maxConns=25 > maxConnTime=1.0 > > > # mode can be FAILOVER or ORACLE_CONNECTION_POOL(default) > #mode=FAILOVER > dbDriver=org.postgresql.Driver > dbServer=jdbc\:postgresql\://archie/cw > dbLogin=hernandez > dbPassword= > > > # add the following properties for DUAL (FAILOVER) mode > dbServer_failover=jdbc\:postgresql\://archie/cw > dbLogin_failover=hernandez > dbPassword_failover= > ---------------------------------- > > I access a remote database without password, maybe this is the problem. > > Any Ideas? > > -Leonardo > |
|
From: Ian B. <ie...@tf...> - 2003-10-21 23:07:39
|
connection was null is definitely caused by the connection being unable to open. Usually cause by one of 2 things. 1. It couldn't find the JDBC driver, you should get a full trace back with a ClassNotFound Exception in catalina.out if this is the case. Normally fixed by putting the PostgresQL driver jar in $tomcat_home/common/lib and restarting the coursework webapp. 2. Postgres JDBC considers a login that does not require a password to be different from one that requires a password but where the password is blank. The oracle.properties file, below, specifies a required, blank password. Try a real password. If either of these work, could you confirm which to the list for future users. Thanks (and thanks for trying Coursework) Ian Leonardo Hernandez wrote: > Hello, > > I'm getting an error when trying to connect to database. For example, > when I try to access "User Registration" or "User Login" I get this error: > > -- WARN [Thread 9] (UserRegistration.java) - DB Error: connection was null > > I can't find any other log to help me solve this problem. Any ideas? > Here is my oracle.properties: > > --------------------------------- > dbDriver=org.postgresql.Driver > minConns=5 > maxConns=25 > maxConnTime=1.0 > > > # mode can be FAILOVER or ORACLE_CONNECTION_POOL(default) > #mode=FAILOVER > dbDriver=org.postgresql.Driver > dbServer=jdbc\:postgresql\://archie/cw > dbLogin=hernandez > dbPassword= > > > # add the following properties for DUAL (FAILOVER) mode > dbServer_failover=jdbc\:postgresql\://archie/cw > dbLogin_failover=hernandez > dbPassword_failover= > ---------------------------------- > > I access a remote database without password, maybe this is the problem. > > Any Ideas? > > -Leonardo > > > > ------------------------------------------------------- > This SF.net email is sponsored by OSDN developer relations > Here's your chance to show off your extensive product knowledge > We want to know what you know. Tell us and you have a chance to win $100 > http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54 > _______________________________________________ > Coursework-help mailing list > Cou...@li... > https://lists.sourceforge.net/lists/listinfo/coursework-help > |
|
From: Leonardo H. <her...@or...> - 2003-10-22 17:43:29
|
Good... here's the solution I found: 1) I copy postgresql driver to $tomcat_home/common/lib and restarted coursework webapp, but, in my case, driver was in a file named pgsql73.jar, I renamed it to postgresql.jar and then restarted webapp. Some notes: In my case, I don't require a password to access the remote database. Even though, I try setting a password in oracle.properties, any password. Coursework Run. Then I erased password and Coursework still run. So, in conclusion, I think the problem was the driver, not only the driver but also the name of .jar file. Thanks a lot, I'm evaluating coursework from this moment on, and maybe we will be using it at my university. -Leonardo Ian Boston wrote: > connection was null is definitely caused by the connection being unable > to open. Usually cause by one of 2 things. > > 1. It couldn't find the JDBC driver, you should get a full trace back > with a ClassNotFound Exception in catalina.out if this is the case. > Normally fixed by putting the PostgresQL driver jar in > $tomcat_home/common/lib and restarting the coursework webapp. > > 2. Postgres JDBC considers a login that does not require a password to > be different from one that requires a password but where the password is > blank. The oracle.properties file, below, specifies a required, blank > password. Try a real password. > > If either of these work, could you confirm which to the list for future > users. > > Thanks (and thanks for trying Coursework) > Ian > > Leonardo Hernandez wrote: > >> Hello, >> >> I'm getting an error when trying to connect to database. For example, >> when I try to access "User Registration" or "User Login" I get this >> error: >> >> -- WARN [Thread 9] (UserRegistration.java) - DB Error: connection was >> null >> >> I can't find any other log to help me solve this problem. Any ideas? >> Here is my oracle.properties: >> >> --------------------------------- >> dbDriver=org.postgresql.Driver >> minConns=5 >> maxConns=25 >> maxConnTime=1.0 >> >> >> # mode can be FAILOVER or ORACLE_CONNECTION_POOL(default) >> #mode=FAILOVER >> dbDriver=org.postgresql.Driver >> dbServer=jdbc\:postgresql\://archie/cw >> dbLogin=hernandez >> dbPassword= >> >> >> # add the following properties for DUAL (FAILOVER) mode >> dbServer_failover=jdbc\:postgresql\://archie/cw >> dbLogin_failover=hernandez >> dbPassword_failover= >> ---------------------------------- >> >> I access a remote database without password, maybe this is the problem. >> >> Any Ideas? >> >> -Leonardo >> >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by OSDN developer relations >> Here's your chance to show off your extensive product knowledge >> We want to know what you know. Tell us and you have a chance to win $100 >> http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54 >> _______________________________________________ >> Coursework-help mailing list >> Cou...@li... >> https://lists.sourceforge.net/lists/listinfo/coursework-help >> > > |
|
From: Ian B. <ie...@tf...> - 2003-10-22 20:42:49
|
The only reason I can think of why a name change should make any
difference in the common/lib directory is the load order. The fact that
it worked before you copied the jar into common/lib implies that there
might be a jar in comon/lib already containing the driver class, it
might be worth a check to see if there are any other jars containing the
postgres driver in the common/lib or other directories.
find . -name '*.jar' -exec jar tvf {} \; | grep "org.postgresql.Driver"
might find it on a unix box.
Ian
Leonardo Hernandez wrote:
> Good... here's the solution I found:
>
> 1) I copy postgresql driver to $tomcat_home/common/lib and restarted
> coursework webapp, but, in my case, driver was in a file named
> pgsql73.jar, I renamed it to postgresql.jar and then restarted webapp.
>
> Some notes:
> In my case, I don't require a password to access the remote database.
> Even though, I try setting a password in oracle.properties, any
> password. Coursework Run.
> Then I erased password and Coursework still run.
>
> So, in conclusion, I think the problem was the driver, not only the
> driver but also the name of .jar file.
>
> Thanks a lot, I'm evaluating coursework from this moment on, and maybe
> we will be using it at my university.
>
> -Leonardo
>
>
>
>
>
>
>
> Ian Boston wrote:
>
>> connection was null is definitely caused by the connection being
>> unable to open. Usually cause by one of 2 things.
>>
>> 1. It couldn't find the JDBC driver, you should get a full trace back
>> with a ClassNotFound Exception in catalina.out if this is the case.
>> Normally fixed by putting the PostgresQL driver jar in
>> $tomcat_home/common/lib and restarting the coursework webapp.
>>
>> 2. Postgres JDBC considers a login that does not require a password to
>> be different from one that requires a password but where the password
>> is blank. The oracle.properties file, below, specifies a required,
>> blank password. Try a real password.
>>
>> If either of these work, could you confirm which to the list for
>> future users.
>>
>> Thanks (and thanks for trying Coursework)
>> Ian
>>
>> Leonardo Hernandez wrote:
>>
>>> Hello,
>>>
>>> I'm getting an error when trying to connect to database. For example,
>>> when I try to access "User Registration" or "User Login" I get this
>>> error:
>>>
>>> -- WARN [Thread 9] (UserRegistration.java) - DB Error: connection was
>>> null
>>>
>>> I can't find any other log to help me solve this problem. Any ideas?
>>> Here is my oracle.properties:
>>>
>>> ---------------------------------
>>> dbDriver=org.postgresql.Driver
>>> minConns=5
>>> maxConns=25
>>> maxConnTime=1.0
>>>
>>>
>>> # mode can be FAILOVER or ORACLE_CONNECTION_POOL(default)
>>> #mode=FAILOVER
>>> dbDriver=org.postgresql.Driver
>>> dbServer=jdbc\:postgresql\://archie/cw
>>> dbLogin=hernandez
>>> dbPassword=
>>>
>>>
>>> # add the following properties for DUAL (FAILOVER) mode
>>> dbServer_failover=jdbc\:postgresql\://archie/cw
>>> dbLogin_failover=hernandez
>>> dbPassword_failover=
>>> ----------------------------------
>>>
>>> I access a remote database without password, maybe this is the problem.
>>>
>>> Any Ideas?
>>>
>>> -Leonardo
>>>
>>>
>>>
>>> -------------------------------------------------------
>>> This SF.net email is sponsored by OSDN developer relations
>>> Here's your chance to show off your extensive product knowledge
>>> We want to know what you know. Tell us and you have a chance to win $100
>>> http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54
>>> _______________________________________________
>>> Coursework-help mailing list
>>> Cou...@li...
>>> https://lists.sourceforge.net/lists/listinfo/coursework-help
>>>
>>
>>
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by OSDN developer relations
> Here's your chance to show off your extensive product knowledge
> We want to know what you know. Tell us and you have a chance to win $100
> http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54
> _______________________________________________
> Coursework-help mailing list
> Cou...@li...
> https://lists.sourceforge.net/lists/listinfo/coursework-help
>
|
|
From: Leonardo H. <her...@or...> - 2003-10-23 16:48:03
|
Hi, Something's happening when trying to register a new user. I access /servlet/UserRegistration but I don't see the 'password' field in the page. Password is a required field, so, I cannot register new users. I'm looking at the source to understand how this work, but haven't found any tips yet. - Leonardo |
|
From: Ian B. <ie...@tf...> - 2003-10-23 14:13:27
|
If you are self registering , ( and not currently logged in as another user ) you should get the password field. But if you are adding a new users to a course, then the password will be generated and emailed to the user. At which point the user confirms their registration and (hopefully) changes their password. Does that make sense. If you are not logged in and still not seeing the password field there is a problem with the UserRegistration dtl. (I guess) I just checked a couple of our 2.1 systems and they appear to behave as above. Ian Leonardo Hernandez wrote: > Hi, > > Something's happening when trying to register a new user. I access > /servlet/UserRegistration but I don't see the 'password' field in the > page. Password is a required field, so, I cannot register new users. > > I'm looking at the source to understand how this work, but haven't found > any tips yet. > > - Leonardo > > > > |
|
From: Leonardo H. <her...@or...> - 2003-10-23 16:56:32
|
I'm running v2.5; I'm self registering and not logged in as any other user (I even restarted tomcat to ensure this) and still don't get the password field. Having a look at UserRegistration.dtl... [[IF EQUAL $ACTION "changeprofile"]] <TR><TD BGCOLOR="[[$BGLIGHT]]" VALIGN="TOP"><FONT FACE="arial,helvetica" SIZE=-1 COLOR="[[$TEXTDARK]]"><B>Contrasena</B></FONT></TD> <TD><INPUT TYPE=PASSWORD NAME=password VALUE="[[$PERSON.FIRSTNAME FORMSAFE]]" SIZE=50></FONT></TD></TR> <TR><TD BGCOLOR="[[$BGLIGHT]]" VALIGN="TOP"><FONT FACE="arial,helvetica" SIZE=-1 COLOR="[[$TEXTDARK]]"><B>Confirmar Contrasena</B></FONT></TD> <TD><INPUT TYPE=PASSWORD NAME=confirmpassword VALUE="[[$PERSON.FIRSTNAME FORMSAFE]]" SIZE=50></FONT></TD></TR> [[/IF]] If I comment the first and the last lines above, then I see the password field in the user registration form, but I'm not sure about what functionality could be affected by this change. - Leonardo Ian Boston wrote: > If you are self registering , ( and not currently logged in as another > user ) you should get the password field. But if you are adding a new > users to a course, then the password will be generated and emailed to > the user. At which point the user confirms their registration and > (hopefully) changes their password. > > Does that make sense. If you are not logged in and still not seeing the > password field there is a problem with the UserRegistration dtl. (I guess) > > I just checked a couple of our 2.1 systems and they appear to behave as > above. > > Ian > > Leonardo Hernandez wrote: > >> Hi, >> >> Something's happening when trying to register a new user. I access >> /servlet/UserRegistration but I don't see the 'password' field in the >> page. Password is a required field, so, I cannot register new users. >> >> I'm looking at the source to understand how this work, but haven't >> found any tips yet. >> >> - Leonardo >> >> >> >> > > |
|
From: Ian B. <ie...@tf...> - 2003-10-24 06:58:04
|
Its quite possible that this is the right thing to do, since the orriginal 2.5 code from stanford would have integrated to their SUID system and not the password mechanism in the Postgres version. I'll get one of the developers to check the imact of this and get it into the CVS version. Ian Leonardo Hernandez wrote: > I'm running v2.5; I'm self registering and not logged in as any other > user (I even restarted tomcat to ensure this) and still don't get the > password field. > > Having a look at UserRegistration.dtl... > [[IF EQUAL $ACTION "changeprofile"]] > <TR><TD BGCOLOR="[[$BGLIGHT]]" VALIGN="TOP"><FONT FACE="arial,helvetica" > SIZE=-1 COLOR="[[$TEXTDARK]]"><B>Contrasena</B></FONT></TD> > <TD><INPUT TYPE=PASSWORD NAME=password VALUE="[[$PERSON.FIRSTNAME > FORMSAFE]]" SIZE=50></FONT></TD></TR> > <TR><TD BGCOLOR="[[$BGLIGHT]]" VALIGN="TOP"><FONT FACE="arial,helvetica" > SIZE=-1 COLOR="[[$TEXTDARK]]"><B>Confirmar Contrasena</B></FONT></TD> > <TD><INPUT TYPE=PASSWORD NAME=confirmpassword VALUE="[[$PERSON.FIRSTNAME > FORMSAFE]]" SIZE=50></FONT></TD></TR> > [[/IF]] > > If I comment the first and the last lines above, then I see the password > field in the user registration form, but I'm not sure about what > functionality could be affected by this change. > > > - Leonardo > > > Ian Boston wrote: > >> If you are self registering , ( and not currently logged in as another >> user ) you should get the password field. But if you are adding a new >> users to a course, then the password will be generated and emailed to >> the user. At which point the user confirms their registration and >> (hopefully) changes their password. >> >> Does that make sense. If you are not logged in and still not seeing >> the password field there is a problem with the UserRegistration dtl. >> (I guess) >> >> I just checked a couple of our 2.1 systems and they appear to behave >> as above. >> >> Ian >> >> Leonardo Hernandez wrote: >> >>> Hi, >>> >>> Something's happening when trying to register a new user. I access >>> /servlet/UserRegistration but I don't see the 'password' field in the >>> page. Password is a required field, so, I cannot register new users. >>> >>> I'm looking at the source to understand how this work, but haven't >>> found any tips yet. >>> >>> - Leonardo >>> >>> >>> >>> >> >> > > > |
|
From: Leonardo H. <her...@or...> - 2003-10-27 16:42:13
|
Hi, I've added some material to a course and created a folder, and when I try to move one material to that folder, I'm prompted to select what folder I want the material to be moved and then I get an "Error 500" from tomcat server. Anyway, material es moved to the folder I select, but I can't make this error dissappear. It seems that for some reasons, the database connection resets. Do you have any idea what can be causing this? I copy some log at the end of this message. - Leonardo ----------------------------------------------- TOMCAT ERROR 500 LOG: ----------------------------------------------- java.lang.NullPointerException at AdminCourseMaterials.doPost(AdminCourseMaterials.java:415) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:261) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:604) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:562) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:679) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:534) ----------------------------------------------- ----------------------------------------------- CATALINA.OUT: ----------------------------------------------- 27 Oct 2003 12:42:58,111 -- DEBUG [Thread-21] (AdminCourseMaterials.java:153) - agree = yes 27 Oct 2003 12:42:58,114 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - ***** admin_coursematerials_move = /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/move.dtl 27 Oct 2003 12:42:58,155 -- DEBUG [Thread-21] (CourseMaterialController.java:176) - setting sort to 9 27 Oct 2003 12:43:02,043 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - ***** admin_coursematerials_byfolder = /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/byfolder.dtl 27 Oct 2003 12:43:02,087 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - ***** admin_coursematerials_bydate = /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/bydate.dtl 27 Oct 2003 12:43:02,306 -- DEBUG [Thread-21] (CourseMaterialController.java:745) - -- by date: adding 15060 to date folder 27 Oct 2003 12:43:02,475 -- DEBUG [Thread-21] (CourseMaterialController.java:745) - -- by date: adding 15080 to date folder 27 Oct 2003 12:43:02,674 -- DEBUG [Thread-21] (CourseMaterialController.java:745) - -- by date: adding 15081 to date folder 27 Oct 2003 12:43:02,821 -- DEBUG [Thread-21] (CourseMaterialController.java:745) - -- by date: adding 15100 to date folder 27 Oct 2003 12:43:02,990 -- DEBUG [Thread-21] (CourseMaterialController.java:745) - -- by date: adding 15101 to date folder 27 Oct 2003 12:43:03,159 -- DEBUG [Thread-21] (CourseMaterialController.java:745) - -- by date: adding 15102 to date folder 27 Oct 2003 12:43:03,346 -- DEBUG [Thread-21] (CourseMaterialController.java:745) - -- by date: adding 15120 to date folder 27 Oct 2003 12:43:03,514 -- DEBUG [Thread-21] (CourseMaterialController.java:745) - -- by date: adding 15121 to date folder 27 Oct 2003 12:43:03,723 -- DEBUG [Thread-21] (CourseMaterialController.java:745) - -- by date: adding 15122 to date folder 27 Oct 2003 12:43:03,861 -- DEBUG [Thread-21] (CourseMaterialController.java:745) - -- by date: adding 15123 to date folder 27 Oct 2003 12:43:04,030 -- DEBUG [Thread-21] (CourseMaterialController.java:745) - -- by date: adding 15124 to date folder 27 Oct 2003 12:43:04,034 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - ***** admin_coursematerials_bytitle = /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/bytitle.dtl 27 Oct 2003 12:43:04,284 -- DEBUG [Thread-21] (CourseMaterialController.java:621) - -- by title: adding 15080 to folder A 27 Oct 2003 12:43:04,461 -- DEBUG [Thread-21] (CourseMaterialController.java:621) - -- by title: adding 15081 to folder B 27 Oct 2003 12:43:04,690 -- DEBUG [Thread-21] (CourseMaterialController.java:621) - -- by title: adding 15101 to folder C 27 Oct 2003 12:43:04,798 -- DEBUG [Thread-21] (CourseMaterialController.java:621) - -- by title: adding 15100 to folder J 27 Oct 2003 12:43:04,977 -- DEBUG [Thread-21] (CourseMaterialController.java:621) - -- by title: adding 15122 to folder P 27 Oct 2003 12:43:05,155 -- DEBUG [Thread-21] (CourseMaterialController.java:621) - -- by title: adding 15123 to folder P 27 Oct 2003 12:43:05,322 -- DEBUG [Thread-21] (CourseMaterialController.java:621) - -- by title: adding 15124 to folder P 27 Oct 2003 12:43:05,502 -- DEBUG [Thread-21] (CourseMaterialController.java:621) - -- by title: adding 15060 to folder S 27 Oct 2003 12:43:05,684 -- DEBUG [Thread-21] (CourseMaterialController.java:621) - -- by title: adding 15120 to folder T 27 Oct 2003 12:43:05,839 -- DEBUG [Thread-21] (CourseMaterialController.java:621) - -- by title: adding 15121 to folder T 27 Oct 2003 12:43:06,008 -- DEBUG [Thread-21] (CourseMaterialController.java:621) - -- by title: adding 15102 to folder V 27 Oct 2003 12:43:06,011 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - ***** admin_coursematerials_bytype = /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/bytype.dtl 27 Oct 2003 12:43:06,228 -- DEBUG [Thread-21] (CourseMaterialController.java:691) - -- by resourcetype: adding 15100 to folder Reference 27 Oct 2003 12:43:06,396 -- DEBUG [Thread-21] (CourseMaterialController.java:691) - -- by resourcetype: adding 15101 to folder Web Resource 27 Oct 2003 12:43:06,565 -- DEBUG [Thread-21] (CourseMaterialController.java:691) - -- by resourcetype: adding 15124 to folder Other 27 Oct 2003 12:43:06,752 -- DEBUG [Thread-21] (CourseMaterialController.java:679) - -- by resourcetype: adding 15123 to folder Other 27 Oct 2003 12:43:06,920 -- DEBUG [Thread-21] (CourseMaterialController.java:679) - -- by resourcetype: adding 15122 to folder Other 27 Oct 2003 12:43:07,090 -- DEBUG [Thread-21] (CourseMaterialController.java:679) - -- by resourcetype: adding 15120 to folder Other 27 Oct 2003 12:43:07,284 -- DEBUG [Thread-21] (CourseMaterialController.java:679) - -- by resourcetype: adding 15102 to folder Other 27 Oct 2003 12:43:07,454 -- DEBUG [Thread-21] (CourseMaterialController.java:679) - -- by resourcetype: adding 15081 to folder Other 27 Oct 2003 12:43:07,622 -- DEBUG [Thread-21] (CourseMaterialController.java:679) - -- by resourcetype: adding 15080 to folder Other 27 Oct 2003 12:43:07,800 -- DEBUG [Thread-21] (CourseMaterialController.java:679) - -- by resourcetype: adding 15060 to folder Other 27 Oct 2003 12:43:07,978 -- DEBUG [Thread-21] (CourseMaterialController.java:679) - -- by resourcetype: adding 15121 to folder Other 27 Oct 2003 12:43:07,981 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - ***** admin_coursematerials_bymimetype = /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/bymimetype.dtl 27 Oct 2003 12:43:08,231 -- DEBUG [Thread-21] (CourseMaterialController.java:794) - mimetype is application/msword 27 Oct 2003 12:43:08,272 -- DEBUG [Thread-21] (CourseMaterialController.java:810) - -- by mimetype: adding 15102to folder Microsoft Word 27 Oct 2003 12:43:08,450 -- DEBUG [Thread-21] (CourseMaterialController.java:794) - mimetype is audio/x-pn-realaudio-plugin 27 Oct 2003 12:43:08,492 -- DEBUG [Thread-21] (CourseMaterialController.java:810) - -- by mimetype: adding 15124to folder Real Player 27 Oct 2003 12:43:08,732 -- DEBUG [Thread-21] (CourseMaterialController.java:794) - mimetype is audio/x-pn-realaudio-plugin 27 Oct 2003 12:43:08,736 -- DEBUG [Thread-21] (CourseMaterialController.java:796) - -- by mimetype: adding 15123to folder Real Player 27 Oct 2003 12:43:08,831 -- DEBUG [Thread-21] (CourseMaterialController.java:794) - mimetype is audio/x-pn-realaudio-plugin 27 Oct 2003 12:43:08,835 -- DEBUG [Thread-21] (CourseMaterialController.java:796) - -- by mimetype: adding 15122to folder Real Player 27 Oct 2003 12:43:09,017 -- DEBUG [Thread-21] (CourseMaterialController.java:794) - mimetype is image/gif 27 Oct 2003 12:43:09,059 -- DEBUG [Thread-21] (CourseMaterialController.java:810) - -- by mimetype: adding 15081to folder GIF Image 27 Oct 2003 12:43:09,220 -- DEBUG [Thread-21] (CourseMaterialController.java:794) - mimetype is image/gif 27 Oct 2003 12:43:09,224 -- DEBUG [Thread-21] (CourseMaterialController.java:796) - -- by mimetype: adding 15080to folder GIF Image 27 Oct 2003 12:43:09,389 -- DEBUG [Thread-21] (CourseMaterialController.java:794) - mimetype is text/html 27 Oct 2003 12:43:09,432 -- DEBUG [Thread-21] (CourseMaterialController.java:810) - -- by mimetype: adding 15101to folder HTML Document 27 Oct 2003 12:43:09,617 -- DEBUG [Thread-21] (CourseMaterialController.java:794) - mimetype is text/html 27 Oct 2003 12:43:09,621 -- DEBUG [Thread-21] (CourseMaterialController.java:796) - -- by mimetype: adding 15060to folder HTML Document 27 Oct 2003 12:43:09,786 -- DEBUG [Thread-21] (CourseMaterialController.java:794) - mimetype is text/plain 27 Oct 2003 12:43:09,827 -- DEBUG [Thread-21] (CourseMaterialController.java:810) - -- by mimetype: adding 15120to folder Text Document 27 Oct 2003 12:43:09,998 -- DEBUG [Thread-21] (CourseMaterialController.java:794) - mimetype is text/plain 27 Oct 2003 12:43:10,001 -- DEBUG [Thread-21] (CourseMaterialController.java:796) - -- by mimetype: adding 15100to folder Text Document 27 Oct 2003 12:43:10,183 -- DEBUG [Thread-21] (CourseMaterialController.java:794) - mimetype is text/plain 27 Oct 2003 12:43:10,186 -- DEBUG [Thread-21] (CourseMaterialController.java:796) - -- by mimetype: adding 15121to folder Text Document 27 Oct 2003 12:43:10,190 -- DEBUG [Thread-21] (CourseMaterialController.java:921) - adding folder for byfolder to DTL 27 Oct 2003 12:43:10,193 -- DEBUG [Thread-21] (Folder.java:386) - getting subfolders for 5040 27 Oct 2003 12:43:10,354 -- DEBUG [Thread-21] (Folder.java:367) - getting coursematerials for 5040 27 Oct 2003 12:43:11,992 -- DEBUG [Thread-21] (Folder.java:386) - getting subfolders for 5061 27 Oct 2003 12:43:12,069 -- DEBUG [Thread-21] (Folder.java:367) - getting coursematerials for 5061 27 Oct 2003 12:43:12,323 -- DEBUG [Thread-21] (Folder.java:386) - getting subfolders for 5061 27 Oct 2003 12:43:12,416 -- DEBUG [Thread-21] (Folder.java:386) - getting subfolders for 5062 27 Oct 2003 12:43:12,500 -- DEBUG [Thread-21] (Folder.java:367) - getting coursematerials for 5062 27 Oct 2003 12:43:12,755 -- DEBUG [Thread-21] (Folder.java:386) - getting subfolders for 5062 27 Oct 2003 12:43:12,912 -- DEBUG [Thread-21] (CourseMaterialController.java:921) - adding folder for bydate to DTL 27 Oct 2003 12:43:12,941 -- DEBUG [Thread-21] (CourseMaterialController.java:921) - adding folder for bytitle to DTL 27 Oct 2003 12:43:12,976 -- DEBUG [Thread-21] (CourseMaterialController.java:921) - adding folder for bytype to DTL 27 Oct 2003 12:43:13,031 -- DEBUG [Thread-21] (CourseMaterialController.java:921) - adding folder for bymimetype to DTL 27 Oct 2003 12:43:13,062 -- DEBUG [Thread-21] (AdminCourseMaterials.java:413) - saving material 15101 into folder 5040 27 Oct 2003 12:43:13,065 -- WARN [Thread-21] (FolderController.java:614) - SQLException:Connection is closed. Oct 27, 2003 12:43:13 PM org.apache.jk.server.JkCoyoteHandler action INFO: RESET ----------------------------------------------- |
|
From: Ian B. <ie...@tf...> - 2003-10-27 17:57:53
|
Looks like we have an error in the SQL statement for moving a folder. I'll get someone to have a look at it here and see if we can reproduce the behaviour. Ian Leonardo Hernandez wrote: > > Hi, > > I've added some material to a course and created a folder, and when I > try to move one material to that folder, I'm prompted to select what > folder I want the material to be moved and then I get an "Error 500" > from tomcat server. Anyway, material es moved to the folder I select, > but I can't make this error dissappear. > It seems that for some reasons, the database connection resets. > Do you have any idea what can be causing this? > I copy some log at the end of this message. > > - Leonardo > > > ----------------------------------------------- > TOMCAT ERROR 500 LOG: > ----------------------------------------------- > java.lang.NullPointerException > at AdminCourseMaterials.doPost(AdminCourseMaterials.java:415) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) > > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) > > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) > > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) > > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) > > at > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) > > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) > > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) > > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) > > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) > > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) > > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) > at > org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:261) > at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:360) > at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:604) > at > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:562) > > at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:679) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) > > at java.lang.Thread.run(Thread.java:534) > ----------------------------------------------- > > > > > > > > ----------------------------------------------- > CATALINA.OUT: > ----------------------------------------------- > 27 Oct 2003 12:42:58,111 -- DEBUG [Thread-21] > (AdminCourseMaterials.java:153) - agree = yes > 27 Oct 2003 12:42:58,114 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - > ***** admin_coursematerials_move = > /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/move.dtl > > 27 Oct 2003 12:42:58,155 -- DEBUG [Thread-21] > (CourseMaterialController.java:176) - setting sort to 9 > 27 Oct 2003 12:43:02,043 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - > ***** admin_coursematerials_byfolder = > /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/byfolder.dtl > > 27 Oct 2003 12:43:02,087 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - > ***** admin_coursematerials_bydate = > /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/bydate.dtl > > 27 Oct 2003 12:43:02,306 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15060 to date > folder > 27 Oct 2003 12:43:02,475 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15080 to date > folder > 27 Oct 2003 12:43:02,674 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15081 to date > folder > 27 Oct 2003 12:43:02,821 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15100 to date > folder > 27 Oct 2003 12:43:02,990 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15101 to date > folder > 27 Oct 2003 12:43:03,159 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15102 to date > folder > 27 Oct 2003 12:43:03,346 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15120 to date > folder > 27 Oct 2003 12:43:03,514 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15121 to date > folder > 27 Oct 2003 12:43:03,723 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15122 to date > folder > 27 Oct 2003 12:43:03,861 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15123 to date > folder > 27 Oct 2003 12:43:04,030 -- DEBUG [Thread-21] > (CourseMaterialController.java:745) - -- by date: adding 15124 to date > folder > 27 Oct 2003 12:43:04,034 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - > ***** admin_coursematerials_bytitle = > /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/bytitle.dtl > > 27 Oct 2003 12:43:04,284 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15080 to folder A > 27 Oct 2003 12:43:04,461 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15081 to folder B > 27 Oct 2003 12:43:04,690 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15101 to folder C > 27 Oct 2003 12:43:04,798 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15100 to folder J > 27 Oct 2003 12:43:04,977 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15122 to folder P > 27 Oct 2003 12:43:05,155 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15123 to folder P > 27 Oct 2003 12:43:05,322 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15124 to folder P > 27 Oct 2003 12:43:05,502 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15060 to folder S > 27 Oct 2003 12:43:05,684 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15120 to folder T > 27 Oct 2003 12:43:05,839 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15121 to folder T > 27 Oct 2003 12:43:06,008 -- DEBUG [Thread-21] > (CourseMaterialController.java:621) - -- by title: adding 15102 to folder V > 27 Oct 2003 12:43:06,011 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - > ***** admin_coursematerials_bytype = > /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/bytype.dtl > > 27 Oct 2003 12:43:06,228 -- DEBUG [Thread-21] > (CourseMaterialController.java:691) - -- by resourcetype: adding 15100 > to folder Reference > 27 Oct 2003 12:43:06,396 -- DEBUG [Thread-21] > (CourseMaterialController.java:691) - -- by resourcetype: adding 15101 > to folder Web Resource > 27 Oct 2003 12:43:06,565 -- DEBUG [Thread-21] > (CourseMaterialController.java:691) - -- by resourcetype: adding 15124 > to folder Other > 27 Oct 2003 12:43:06,752 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15123 > to folder Other > 27 Oct 2003 12:43:06,920 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15122 > to folder Other > 27 Oct 2003 12:43:07,090 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15120 > to folder Other > 27 Oct 2003 12:43:07,284 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15102 > to folder Other > 27 Oct 2003 12:43:07,454 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15081 > to folder Other > 27 Oct 2003 12:43:07,622 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15080 > to folder Other > 27 Oct 2003 12:43:07,800 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15060 > to folder Other > 27 Oct 2003 12:43:07,978 -- DEBUG [Thread-21] > (CourseMaterialController.java:679) - -- by resourcetype: adding 15121 > to folder Other > 27 Oct 2003 12:43:07,981 -- DEBUG [Thread-21] (CoreDTLObject.java:236) - > ***** admin_coursematerials_bymimetype = > /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/coursematerials/admin/bymimetype.dtl > > 27 Oct 2003 12:43:08,231 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is application/msword > 27 Oct 2003 12:43:08,272 -- DEBUG [Thread-21] > (CourseMaterialController.java:810) - -- by mimetype: adding 15102to > folder Microsoft Word > 27 Oct 2003 12:43:08,450 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is > audio/x-pn-realaudio-plugin > 27 Oct 2003 12:43:08,492 -- DEBUG [Thread-21] > (CourseMaterialController.java:810) - -- by mimetype: adding 15124to > folder Real Player > 27 Oct 2003 12:43:08,732 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is > audio/x-pn-realaudio-plugin > 27 Oct 2003 12:43:08,736 -- DEBUG [Thread-21] > (CourseMaterialController.java:796) - -- by mimetype: adding 15123to > folder Real Player > 27 Oct 2003 12:43:08,831 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is > audio/x-pn-realaudio-plugin > 27 Oct 2003 12:43:08,835 -- DEBUG [Thread-21] > (CourseMaterialController.java:796) - -- by mimetype: adding 15122to > folder Real Player > 27 Oct 2003 12:43:09,017 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is image/gif > 27 Oct 2003 12:43:09,059 -- DEBUG [Thread-21] > (CourseMaterialController.java:810) - -- by mimetype: adding 15081to > folder GIF Image > 27 Oct 2003 12:43:09,220 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is image/gif > 27 Oct 2003 12:43:09,224 -- DEBUG [Thread-21] > (CourseMaterialController.java:796) - -- by mimetype: adding 15080to > folder GIF Image > 27 Oct 2003 12:43:09,389 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is text/html > 27 Oct 2003 12:43:09,432 -- DEBUG [Thread-21] > (CourseMaterialController.java:810) - -- by mimetype: adding 15101to > folder HTML Document > 27 Oct 2003 12:43:09,617 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is text/html > 27 Oct 2003 12:43:09,621 -- DEBUG [Thread-21] > (CourseMaterialController.java:796) - -- by mimetype: adding 15060to > folder HTML Document > 27 Oct 2003 12:43:09,786 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is text/plain > 27 Oct 2003 12:43:09,827 -- DEBUG [Thread-21] > (CourseMaterialController.java:810) - -- by mimetype: adding 15120to > folder Text Document > 27 Oct 2003 12:43:09,998 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is text/plain > 27 Oct 2003 12:43:10,001 -- DEBUG [Thread-21] > (CourseMaterialController.java:796) - -- by mimetype: adding 15100to > folder Text Document > 27 Oct 2003 12:43:10,183 -- DEBUG [Thread-21] > (CourseMaterialController.java:794) - mimetype is text/plain > 27 Oct 2003 12:43:10,186 -- DEBUG [Thread-21] > (CourseMaterialController.java:796) - -- by mimetype: adding 15121to > folder Text Document > 27 Oct 2003 12:43:10,190 -- DEBUG [Thread-21] > (CourseMaterialController.java:921) - adding folder for byfolder to DTL > 27 Oct 2003 12:43:10,193 -- DEBUG [Thread-21] (Folder.java:386) - > getting subfolders for 5040 > 27 Oct 2003 12:43:10,354 -- DEBUG [Thread-21] (Folder.java:367) - > getting coursematerials for 5040 > 27 Oct 2003 12:43:11,992 -- DEBUG [Thread-21] (Folder.java:386) - > getting subfolders for 5061 > 27 Oct 2003 12:43:12,069 -- DEBUG [Thread-21] (Folder.java:367) - > getting coursematerials for 5061 > 27 Oct 2003 12:43:12,323 -- DEBUG [Thread-21] (Folder.java:386) - > getting subfolders for 5061 > 27 Oct 2003 12:43:12,416 -- DEBUG [Thread-21] (Folder.java:386) - > getting subfolders for 5062 > 27 Oct 2003 12:43:12,500 -- DEBUG [Thread-21] (Folder.java:367) - > getting coursematerials for 5062 > 27 Oct 2003 12:43:12,755 -- DEBUG [Thread-21] (Folder.java:386) - > getting subfolders for 5062 > 27 Oct 2003 12:43:12,912 -- DEBUG [Thread-21] > (CourseMaterialController.java:921) - adding folder for bydate to DTL > 27 Oct 2003 12:43:12,941 -- DEBUG [Thread-21] > (CourseMaterialController.java:921) - adding folder for bytitle to DTL > 27 Oct 2003 12:43:12,976 -- DEBUG [Thread-21] > (CourseMaterialController.java:921) - adding folder for bytype to DTL > 27 Oct 2003 12:43:13,031 -- DEBUG [Thread-21] > (CourseMaterialController.java:921) - adding folder for bymimetype to DTL > 27 Oct 2003 12:43:13,062 -- DEBUG [Thread-21] > (AdminCourseMaterials.java:413) - saving material 15101 into folder 5040 > 27 Oct 2003 12:43:13,065 -- WARN [Thread-21] > (FolderController.java:614) - SQLException:Connection is closed. > Oct 27, 2003 12:43:13 PM org.apache.jk.server.JkCoyoteHandler action > INFO: RESET > ----------------------------------------------- > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: The SF.net Donation Program. > Do you like what SourceForge.net is doing for the Open > Source Community? Make a contribution, and help us add new > features and functionality. Click here: http://sourceforge.net/donate/ > _______________________________________________ > Coursework-help mailing list > Cou...@li... > https://lists.sourceforge.net/lists/listinfo/coursework-help > |
|
From: Leonardo H. <her...@or...> - 2003-10-23 08:58:48
|
Hi, I've tryed both suggestions but I'm stil getting "connection was null" error... Here's part of my log... 22 Oct 2003 10:29:23,992 -- DEBUG [main] (CoreDTLObject.java) - DTLPATH: /usr/local/tomcat/webapps/coursework/WEB-INF/dtl 22 Oct 2003 10:29:24,017 -- DEBUG [main] (CoreDTLObject.java) - SITEPATH: /home/opensource/data/coursework-v2.5/site 22 Oct 2003 10:29:24,130 -- DEBUG [main] (CoreDTLObject.java) - COURSESPATH: /home/opensource/data/coursework-v2.5/courses 22 Oct 2003 10:29:24,321 -- DEBUG [main] (CoreDTLObject.java) - GLOBALINCLUDE: /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/globalinclude.dtl 22 Oct 2003 10:29:24,569 -- DEBUG [main] (DbConnectionManager.java) - Registering JDBC Driver org.postgresql.Driver 22 Oct 2003 10:29:24,776 -- DEBUG [main] (DbConnectionManager.java) - Creating connectionPool 22 Oct 2003 10:29:24,788 -- DEBUG [main] (DbConnectionManager.java) - done..... more to come 22 Oct 2003 10:29:24,984 -- DEBUG [main] (DbConnectionManager.java) - Creating connectionFactory 22 Oct 2003 10:29:24,990 -- DEBUG [main] (DbConnectionManager.java) - Creating PoolableConnectionFactory 22 Oct 2003 10:29:25,190 -- DEBUG [main] (DbConnectionManager.java) - Creating PoolingDataSource 22 Oct 2003 10:29:25,195 -- DEBUG [main] (DbConnectionManager.java) - All Done 22 Oct 2003 10:29:25,405 -- DEBUG [main] (DbConnectionManager.java) - Pool finished Creation 22 Oct 2003 10:29:49,350 -- DEBUG [Thread-9] (CoreDTLObject.java) - ***** student_error = /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/error.dtl 22 Oct 2003 10:29:49,356 -- DEBUG [Thread-9] (CoreDTLObject.java) - ***** dtl_userlogin = /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/userlogin.dtl 22 Oct 2003 10:29:49,948 -- DEBUG [Thread-9] (AuthFactory.java) - AUTHCLASSNAME=edu.stanford.coursework.passwordauth.PasswordAuthImpl 22 Oct 2003 10:29:49,968 -- DEBUG [Thread-9] (AuthFactory.java) - AUTHCLASS=class edu.stanford.coursework.passwordauth.PasswordAuthImpl 22 Oct 2003 10:29:55,442 -- DEBUG [Thread-8] (CoreDTLObject.java) - ***** student_error = /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/error.dtl 22 Oct 2003 10:29:55,450 -- DEBUG [Thread-8] (CoreDTLObject.java) - ***** dtl_userreg = /usr/local/tomcat/webapps/coursework/WEB-INF/dtl/userreg.dtl 22 Oct 2003 10:29:55,527 -- WARN [Thread-8] (UserRegistration.java) - DB Error: connection was null Thanks for the help... -Leonardo Ian Boston wrote: > connection was null is definitely caused by the connection being unable > to open. Usually cause by one of 2 things. > > 1. It couldn't find the JDBC driver, you should get a full trace back > with a ClassNotFound Exception in catalina.out if this is the case. > Normally fixed by putting the PostgresQL driver jar in > $tomcat_home/common/lib and restarting the coursework webapp. > > 2. Postgres JDBC considers a login that does not require a password to > be different from one that requires a password but where the password is > blank. The oracle.properties file, below, specifies a required, blank > password. Try a real password. > > If either of these work, could you confirm which to the list for future > users. > > Thanks (and thanks for trying Coursework) > Ian > > Leonardo Hernandez wrote: > >> Hello, >> >> I'm getting an error when trying to connect to database. For example, >> when I try to access "User Registration" or "User Login" I get this >> error: >> >> -- WARN [Thread 9] (UserRegistration.java) - DB Error: connection was >> null >> >> I can't find any other log to help me solve this problem. Any ideas? >> Here is my oracle.properties: >> >> --------------------------------- >> dbDriver=org.postgresql.Driver >> minConns=5 >> maxConns=25 >> maxConnTime=1.0 >> >> >> # mode can be FAILOVER or ORACLE_CONNECTION_POOL(default) >> #mode=FAILOVER >> dbDriver=org.postgresql.Driver >> dbServer=jdbc\:postgresql\://archie/cw >> dbLogin=hernandez >> dbPassword= >> >> >> # add the following properties for DUAL (FAILOVER) mode >> dbServer_failover=jdbc\:postgresql\://archie/cw >> dbLogin_failover=hernandez >> dbPassword_failover= >> ---------------------------------- >> >> I access a remote database without password, maybe this is the problem. >> >> Any Ideas? >> >> -Leonardo >> >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by OSDN developer relations >> Here's your chance to show off your extensive product knowledge >> We want to know what you know. Tell us and you have a chance to win $100 >> http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54 >> _______________________________________________ >> Coursework-help mailing list >> Cou...@li... >> https://lists.sourceforge.net/lists/listinfo/coursework-help >> > > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X