Jump to content

chanders

Members
 View Profile  See their activity

  • Posts

    67

  • Joined

  • Last visited

 Content Type 

Everything posted by chanders

  1. chanders
    Greetings, It seems that Tomcat on tommy is down. Accessing servlet/site says: 503. Service Unavailable. Also, the servlet deployment is not working as well. It seem it has been stuck at this situation for more that 8 hours. Appreciate if you would please fix it, and provide some insight into the reasons for such as long outage. Thanks and regards.
  2. chanders
    Greetings. I requested the redeployment of cbook early yesterday -- it is however still not processed. Wondering if the deployment process is not working? please make sure that I do continue to to have the https access. thanks
  3. chanders
    Yes. and thank you.
  4. chanders
    It seems that while the front-page (i.e., index.html) is reachable as https, the servlet is not reachable as https. It there any way to deploy or access servlet as: https://user.heliohost.org/deploy_name/servlet_class? Accessing the servlet via https://.. gives 404. Since the origin and the servlet access must both match -- the site become inaccessible. For secure access https:// is preferable for both. Thanks your help.
  5. chanders
    Greetings, my ip has been disabled due to sftp testing. Please enable my ip. user: citisnet on tommy thanks
  6. chanders
    Thank you -- it's work now!
  7. chanders
    clicking from cpanel to phpMyAdmin give error 401. Database structure / scheme remains inaccessible -- error 401. And then the login in panel reappears. Appreciate if you would please look into it. regards, user: citisnet
  8. chanders
    Please unblock my ip -- it occurred while testing sftp! user: citisnet
  9. chanders
    Thanks Krydos, I was wondering if it a bug -- and should it not be fixed by specifying this in the server.xml???
  10. chanders
    http://citisnet.heliohost.org/citisnetsql3/ click 'Sign In' and enter arbitrary userid/password to login.
  11. chanders
    Krydos, Thanks for trying -- Unfortunately my servlet 'citisnetsql3' works find locally, but I run on tommy (and has worked ok before though) gives null pointer exception -- please check my 'server log' to see if it provides any additional info.... Here is what I get in my console view.. <!doctype html><html lang="en"><head><title>HTTP Status 500 – Internal Server Error</title><style type="text/css">h1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} h2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} h3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} body {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} b {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} p {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;} a {color:black;} a.name {color:black;} .line {height:1px;background-color:#525D76;border:none;}</style></head><body><h1>HTTP Status 500 – Internal Server Error</h1><hr class="line" /><p><b>Type</b> Exception Report</p><p><b>Description</b> The server encountered an unexpected condition that prevented it from fulfilling the request.</p><p><b>Exception</b></p><pre>java.lang.NullPointerExceptioncom.citisnet.buildapp.processRecord.runSqlCommand(processRecord.java:1572)com.citisnet.buildapp.processRecord.runSqlCommandOn(processRecord.java:923)com.citisnet.buildapp.processRecord.processSql(processRecord.java:913)com.citisnet.buildapp.processRecord.processSqls(processRecord.java:637)com.citisnet.buildapp.processRecord.processRec(processRecord.java:2778)com.citisnet.buildapp.processInput.process_action(processInput.java:201)com.citisnet.buildapp.processInput.processCmd(processInput.java:146)com.citisnet.buildapp.processInput.readParam3(processInput.java:126)com.citisnet.buildapp.MeBook.doPost(MeBook.java:95)javax.servlet.http.HttpServlet.service(HttpServlet.java:661)javax.servlet.http.HttpServlet.service(HttpServlet.java:742)org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</pre><p><b>Note</b> The full stack trace of the root cause is available in the server logs.</p><hr class="line" /><h3>Apache Tomcat/8.5.24</h3></body></html> thanks.
  12. chanders
    Dear Krydos, While this file may not be corrupted, it is highly likely that some of jdbc calls might be getting overloaded (overridden) by non-functioning or corrupted jdbc calls (from a different jar file). Appreciate if you would please test and confirm by making calls to "Datasource" and "setPoolProperties" and then create a Connection using "getConnection()" -- then create a sql "Statement" and "execQuery" -- resultSet.next() will present java.lang.NullPointerException!
  13. chanders
    additional info -- I think one these jar file that may be corrupted is: tomcat-jdbc.jar
  14. chanders
    Greetings, I had been getting null pointer exception on jdbc connection creation (ever since tommy crash) -- the root cause of this is the missing jdbc connection pooling jar files in the tomcat library. Either these libraries were not loaded after the 'tommy' crash or are corrupted. Please restore these missing jar files in Tomcat library or do a fresh install of the tomcat server. This should fix the null pointer issues for all those who are using the connection pooling in jdbc. Unfortunately this issue has remained undiscovered for quite sometime -- appreciate if you would please fix it as soon as possible. Thanks you.
  15. chanders
    Greetings, After some analysis, I have confirmed that the reason for null pointer occurs because the jdbc connection pooling libraries are missing (or not loaded) in tomcat. This probably occurred after the crash and restore of tommy. Please check tomcat library directory for the missing connection pooling libraries and restore them. This should fix the null pointer issues for those who are using connection pooling in jdbc. please confirm this finding and restore the connection pooling library in tomcat. warm regards.
  16. chanders
    let's try redeploying servlet: cbook.war username: citisnet
  17. chanders
    yes!
  18. chanders
    Greeting, When I execute sql query in a java servlet on Tomcat -- it returns a null pointer (code 500). It seem that this malfunction may be related to the recent servlet/tomcat configuration mishap that occurred on tommy. However, when this servlet is run locally (via my localhost) it works fine and successfully fetches table rows from mysql at tommy. Appreciate if you would please investigate whether any java/Jdbc connector libraries are missing, and/or suggest any workarounds to adjust to changes in configuration that I should explore. I suggest that viewing the servlet log might provide additional information -- my user account is: citisnet warm regards.
  19. chanders
    Hello Support, I can not seem to be able to get to my home page at: https://citisnet.heliohost.org/ any more! Is the system not serving webpages ? .. please restart server. warm regards, /home/citisnet
  20. chanders
    Dear Support, I have thoroughly checked my logic -- and determined that all threads are closed. ProcessList shows nothing active or suspended. I believe the system delaying in actually releasing a pooled connection. Since the maximum user connections allowed is 4 -- it is easy to exceed this limit, sometimes (especially when the system is slow to process clear requests). Appreciate if you can please check this or may be temporarily increase connections allowed. I donot believe there is no danger of run away connections, as the system limits them to 75. Thanks and warm regards at: /home/citisnet
  21. chanders
    Dear Support, I am re-experiencing "already has more than 'max_user_connections' active connections" when I attempt to connect to mySql. When it occurred before, the root cause seemed to point to the fact that the system was not immediately closing the connection when requested by the servlet, and therefore was exceeding max connections (which are currently set to 4) -- I believe increasing it to ~40 fixed the issue! The code still opens a connection, processes an sql and closes right after (as before). It does seem to work most of the time, but annoying stops or slows down causing data access errors. Just an observation: ever since the last solution (back in June, I think) I did not experience this error! Thanks and appreciate for help. at: /home/citisnet warm regards.
  22. chanders
    Friends -- I am getting 503 (service unavailable!) when accessing servlet at: http://citisnet.heliohost.org/citisnetsql3/#/ appreciate your attention. ... regards.
  23. chanders
    please re-deploy user: citisnet file: citisnetsql3.war
  24. chanders
    Krydos, Thanks for work on it -- But now I get HTTP Status 404 - /citisnet_citisnetsql3/could you please redeploy. warm regards.
  25. chanders
    Hello Krydos -- the server seems to be still holding on to the previous servlet -- please clear the cache of older servlet from the server. regards.
×
×
  • Create New...