[Deploying Sakai] (no subject)

Steve Swinsburg steve.swinsburg at gmail.com
Mon Jan 18 02:26:56 PST 2010


Hi Satish,

It's still looking like a database error. 

2010-01-18 14:55:05,991  INFO main org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean - Building new Hibernate SessionFactory
2010-01-18 14:55:06,259  WARN main org.hibernate.cfg.SettingsFactory - Could not obtain connection metadata
java.sql.SQLException: Access denied for user 'sakaiuser'@'localhost' (using password: YES)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)

To get to the bottom of this, can you comment out the MySQL block and username/password in sakai.properties and restore the HSQL ones, and startup that way? The username for HSQL is 'sa', no password.

Also, does your MySQL user have full privileges on this database. (grant all on dbname.* to sakaiuser@'localhost' identified by 'password';)

cheers,
Steve


On 18/01/2010, at 8:43 PM, Satish Agrawal wrote:

> 
> Hi Steve, 
> 
>         Got install the 'sakai' database freshly again, but still getting the same error in login as 'admin'. 
>         
>         Please find the latest catalina.out file. 
> 
>         
> 
> Regards,
> Satish Kumar Agrawal
> Tata Consultancy Services
> Plot No 1, Survey No. 64/2, Software Units Layout
> Serilingampally Mandal, Madhapur
> Hyderabad - 500034,Andhra Pradesh
> India
> Buzz:- 040 6667 3318
> Mailto: satish.agrawal at tcs.com
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty.        IT Services
>                        Business Solutions
>                        Outsourcing
> ____________________________________________ 
> 
> 
>  	
> Re: [Deploying Sakai] (no subject)
> 
> Steve Swinsburg	to:	Satish Agrawal	
> 01/18/2010 02:36 PM
> 
> 
> 
> 
> 
> 
> Yes try that and see how you go. Is auto.ddl=true in sakai.properties? 
> 
> cheers, 
> Steve 
> 
> On 18/01/2010, at 5:31 PM, Satish Agrawal wrote: 
> 
> 
> Hi Steve, 
> 
>        Yes, the database was created as UTF8 only....we can drop the database and create it once again. 
> 
>        Shall i give that a try?? 
> 
> Regards,
> Satish Kumar Agrawal
> Tata Consultancy Services
> Plot No 1, Survey No. 64/2, Software Units Layout
> Serilingampally Mandal, Madhapur
> Hyderabad - 500034,Andhra Pradesh
> India
> Buzz:- 040 6667 3318
> Mailto: satish.agrawal at tcs.com
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty.        IT Services
>                       Business Solutions
>                       Outsourcing
> ____________________________________________ 
> 
> Re: [Deploying Sakai] (no subject)
> 
> 
> Steve Swinsburg	to:	Satish Agrawal	
> 01/18/2010 11:58 AM
> 
> 
> 
> 
> 
> 
> 
> Hi Satish, 
> 
> Upper and lower case shouldn't matter. Was your database created as utf8? It might be an issue with the password perhaps. 
> 
> Is it an option to drop and recreate the database? 
> 
> cheers, 
> Steve 
> 
> On 18/01/2010, at 5:22 PM, Satish Agrawal wrote: 
> 
> 
> Hi Steve, 
> 
>       Its a fresh installation of everything, we have installed sakai freshly on a fresh tomcat, mysql and other applications....We are having problem when we are trying to login using the admin account only, and a new account creation is easily done. 
> 
>       I am able to connect to the database using the user details mentioned in my sakai.properties file and also the database shows 291 tables present in the sakai db(some tables are in uppercase and some in lowercase, could that be a problem??). 
> 
> Regards, 
> Satish Kumar Agrawal
> Tata Consultancy Services
> Plot No 1, Survey No. 64/2, Software Units Layout
> Serilingampally Mandal, Madhapur
> Hyderabad - 500034,Andhra Pradesh
> India
> Buzz:- 040 6667 3318
> Mailto: satish.agrawal at tcs.com
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty.        IT Services
>                      Business Solutions
>                      Outsourcing
> ____________________________________________ 
> Re: [Deploying Sakai] (no subject)
> 
> 
> 
> Steve Swinsburg	to:	Satish Agrawal	
> 01/18/2010 11:38 AM
> 
> 
> 
> 
> 
> 
> 
> 
> Hi Satish, 
> 
> Check your database connection details, there are a number of db related errors from previous start ups. 
> 
> Did you upgrade or is this a fresh install. And is it a fresh tomcat or did it have an older version of Sakai deployed to it before? 
> 
> cheers, 
> Steve 
> 
> 
> On 18/01/2010, at 4:55 PM, Satish Agrawal wrote: 
> 
> 
> Hi Steve, 
> 
>      Please find the entire catalina.out file attached below 
> 
>      
> 
> Warm Regards,
> Satish Kumar Agrawal
> Tata Consultancy Services
> Plot No 1, Survey No. 64/2, Software Units Layout
> Serilingampally Mandal, Madhapur
> Hyderabad - 500034,Andhra Pradesh
> India
> Buzz:- 040 6667 3318
> Mailto: satish.agrawal at tcs.com
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty.        IT Services
>                     Business Solutions
>                     Outsourcing
> ____________________________________________
> Re: [Deploying Sakai] (no subject)
> 
> 
> 
> 
> Steve Swinsburg	to:	Satish Agrawal	
> 01/18/2010 11:23 AM
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Hi Satich, 
> 
> I need the entire catalina.out from Tomcat, as that is just the most recent error but there will no doubt be more before it. 
> 
> cheers, 
> Steve 
> 
> 
> 
> On 18/01/2010, at 4:46 PM, Satish Agrawal wrote: 
> 
> 
> Hi Steve, 
> 
>     Sorry for not mentioning that, we have installed sakai 2.6.1 on a fedora machine and are using JDK 1.5.0_21, MySQL 5.0.89, Tomcat 5.5.28 and apache-maven 2.2.1. 
> 
>     Please find attached below the catalina.out file with the specific error message. 
> 
>     
> 
> Regards,
> Satish Kumar Agrawal
> Tata Consultancy Services
> Plot No 1, Survey No. 64/2, Software Units Layout
> Serilingampally Mandal, Madhapur
> Hyderabad - 500034,Andhra Pradesh
> India
> Buzz:- 040 6667 3318
> Mailto: satish.agrawal at tcs.com
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty.        IT Services
>                    Business Solutions
>                    Outsourcing
> ____________________________________________
> Re: [Deploying Sakai] (no subject)
> 
> 
> 
> 
> 
> Steve Swinsburg	to:	Satish Agrawal	
> 01/18/2010 11:09 AM
> 
> 
> 
> 
> 
> Cc:	production
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Hi Satish, 
> 
> Which version Sakai have you installed? Can you attach the catalina.out from Tomcat/logs/ and we can take a look at possible issues. 
> 
> cheers, 
> Steve 
> 
> 
> 
> 
> 
> On 18/01/2010, at 4:29 PM, Satish Agrawal wrote: 
> 
> 
> Hi, 
> 
>    I have installed 'Sakai', but not able to login using the admin account and getting the below error on login: 
> 
> 
> 2010-01-18 10:56:03,830  WARN http-8080-Processor23 org.sakaiproject.portal.util.ErrorReporter - Bug Report bug-id: b3f2fd6b-c06a-4b67-857f-3583be70bb13 user: null usage-session: null time: Jan 18, 2010 10:55:40 user comment: null stack trace 
> org.sakaiproject.portal.api.PortalHandlerException: java.lang.NullPointerException 
> at org.sakaiproject.portal.charon.handlers.XLoginHandler.doPost(XLoginHandler.java:50) 
> caused by: java.lang.NullPointerException 
> at org.sakaiproject.portal.charon.SkinnableCharonPortal.doLogin(SkinnableCharonPortal.java:861) 
> at org.sakaiproject.portal.charon.handlers.XLoginHandler.doGet(XLoginHandler.java:61) 
> at org.sakaiproject.portal.charon.handlers.XLoginHandler.doPost(XLoginHandler.java:50) 
> at org.sakaiproject.portal.charon.SkinnableCharonPortal.doPost(SkinnableCharonPortal.java:1059) 
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) 
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) 
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) 
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) 
> at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:616) 
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) 
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) 
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) 
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) 
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) 
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) 
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) 
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873) 
> at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) 
> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) 
> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) 
> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) 
> at java.lang.Thread.run(Thread.java:595) 
> 
> Tool Placement: 
> No Placement 
> 
> Request: 
> :    AuthType:null 
> :    CharEncoding:UTF-8 
> :    ContentLength:31 
> :    ContentType:application/x-www-form-urlencoded 
> :    ContextPath:/portal 
> :    LocalAddress:172.25.140.147 
> :    LocalName:172.25.140.147 
> :    LocalPort:8080 
> :    Method:POST 
> :    PathInfo:/xlogin 
> :    Protocol:HTTP/1.1 
> :    QueryString:null 
> :    RemoteAddress:172.25.140.137 
> :    RemoteHost:172.25.140.137 
> :    RemotePort:1372 
> :    Requested URL:http://172.25.140.147:8080/portal/xlogin 
> :    Scheme:http 
> :    ServerName:172.25.140.147 
> :    Headers: 
> :        Header:accept:*/* 
> :        Header:referer:http://172.25.140.147:8080/portal 
> :        Header:accept-language:en-us 
> :        Header:content-type:application/x-www-form-urlencoded 
> :        Header:ua-cpu:x86 
> :        Header:accept-encoding:gzip, deflate 
> :        Header:user-agent:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729) 
> :        Header:host:172.25.140.147:8080 
> :        Header:content-length:31 
> :        Header:connection:Keep-Alive 
> :        Header:cache-control:no-cache 
> :        Header:cookie:---censored--- 
> :    Parameters: 
> :        Parameter:eid:0:----censored---- 
> :        Parameter:pw:0:----censored---- 
> :        Parameter:submit:0:Login 
> :    Attributes: 
> :        Attribute:sakai.session:org.sakaiproject.tool.impl.SessionComponent$MySession at 36799353 
> :        Attribute:sakai.character.encoding.done:sakai.character.encoding.done 
> :        Attribute:sakai.filtered:sakai.filtered 
> Session: 
> :    Created:1263792333497 
> :    LastAccess:1263792363745 
> :    MaxInactive:3600 
> :    Attributes: 
> :        Attribute:portalskin:defaultskin 
> 
> 2010-01-18 10:56:03,946  WARN http-8080-Processor23 org.sakaiproject.email.impl.BasicEmailService - send: javax.mail.internet.AddressException: Illegal address in string ``'' 
> 
> 
>    Please help me out of this. 
> 
> Warm Regards,
> Satish Kumar Agrawal
> Tata Consultancy Services
> Plot No 1, Survey No. 64/2, Software Units Layout
> Serilingampally Mandal, Madhapur
> Hyderabad - 500034,Andhra Pradesh
> India
> Buzz:- 040 6667 3318
> Mailto: satish.agrawal at tcs.com
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty.        IT Services
>                   Business Solutions
>                   Outsourcing
> ____________________________________________ 
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain 
> confidential or privileged information. If you are 
> not the intended recipient, any dissemination, use, 
> review, distribution, printing or copying of the 
> information contained in this e-mail message 
> and/or attachments to it are strictly prohibited. If 
> you have received this communication in error, 
> please notify us by reply e-mail or telephone and 
> immediately and permanently delete the message 
> and any attachments. Thank you
> 
> 
> 
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
> 
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe" 
> 
> <catalina.out>=====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain 
> confidential or privileged information. If you are 
> not the intended recipient, any dissemination, use, 
> review, distribution, printing or copying of the 
> information contained in this e-mail message 
> and/or attachments to it are strictly prohibited. If 
> you have received this communication in error, 
> please notify us by reply e-mail or telephone and 
> immediately and permanently delete the message 
> and any attachments. Thank you
> 
> 
> 
> <catalinabig.out>=====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain 
> confidential or privileged information. If you are 
> not the intended recipient, any dissemination, use, 
> review, distribution, printing or copying of the 
> information contained in this e-mail message 
> and/or attachments to it are strictly prohibited. If 
> you have received this communication in error, 
> please notify us by reply e-mail or telephone and 
> immediately and permanently delete the message 
> and any attachments. Thank you
> 
> 
> 
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain 
> confidential or privileged information. If you are 
> not the intended recipient, any dissemination, use, 
> review, distribution, printing or copying of the 
> information contained in this e-mail message 
> and/or attachments to it are strictly prohibited. If 
> you have received this communication in error, 
> please notify us by reply e-mail or telephone and 
> immediately and permanently delete the message 
> and any attachments. Thank you
> 
> 
> 
> 
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain 
> confidential or privileged information. If you are 
> not the intended recipient, any dissemination, use, 
> review, distribution, printing or copying of the 
> information contained in this e-mail message 
> and/or attachments to it are strictly prohibited. If 
> you have received this communication in error, 
> please notify us by reply e-mail or telephone and 
> immediately and permanently delete the message 
> and any attachments. Thank you
> 
> 
> 
> 
> <catalina.out>=====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain 
> confidential or privileged information. If you are 
> not the intended recipient, any dissemination, use, 
> review, distribution, printing or copying of the 
> information contained in this e-mail message 
> and/or attachments to it are strictly prohibited. If 
> you have received this communication in error, 
> please notify us by reply e-mail or telephone and 
> immediately and permanently delete the message 
> and any attachments. Thank you
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20100118/103abc82/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3823 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/production/attachments/20100118/103abc82/attachment-0001.bin 


More information about the production mailing list