It's like installation.type=auto database.configurationType=jndi database.jndi.name=jdbc/rollerdb mail.configurationType=jndi mail.jndi.name=mail/Session
-----Original Message----- From: Alfonso Romero [mailto:[email protected]] Sent: Wednesday, August 26, 2009 6:42 PM To: [email protected] Subject: Re: Mails are not going to user in roller. And what does your roller-custom.properties file look like? ----- Original Message ----- From: "Vikas Dahiya" <[email protected]> To: <[email protected]> Sent: Wednesday, August 26, 2009 6:40 AM Subject: RE: Mails are not going to user in roller. Hi Alfonso, Thanks for the help! I am using mySql database. And my context file entries for DB are as given below <Context path="/roller" docBase="G:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/roller" debug="0"> <Resource name="jdbc/rollerdb" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/rollerdb?autoReconnect=true&useUnic ode=true&characterEncoding=utf-8&mysqlEncoding=utf8" username="myuser" password="mypass" maxActive="20" maxIdle="3" removeAbandoned="true" maxWait="3000" /> But now I am getting this exception [org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSo urce.java:1150) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSourc e.java:880) at org.apache.roller.weblogger.business.DatabaseProvider.getConnection(Data baseProvider.java:179) at org.apache.roller.weblogger.business.DatabaseProvider.<init>(DatabasePro vider.java:141) at org.apache.roller.weblogger.business.startup.WebloggerStartup.prepare(We bloggerStartup.java:171) at org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(Rol lerContext.java:138) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.j ava:3843) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342 ) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.ja va:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:9 26) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java :889) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:31 1) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu pport.java:117) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:578) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: java.lang.NullPointerException at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(Unknown Source) at java.sql.DriverManager.getDriver(Unknown Source) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSo urce.java:1143) Port 25 of my mail server enabled. I have talked with my IT department folks and everything is ok at their end. Is there any way to send the mail not by using jndi type of connection. Thanks, --Vikas -----Original Message----- From: Alfonso Romero [mailto:[email protected]] Sent: Wednesday, August 26, 2009 2:35 PM To: [email protected] Subject: Re: Mails are not going to user in roller. Try using a google account, and the following files: roller-custom.properties installation.type=auto database.configurationType=jndi database.jndi.name=jdbc/rollerdb mail.configurationType=jndi mail.jndi.name=mail/Session Context.xml: <Context path="/roller" docBase="/usr/local/tomcat/webapps/roller" debug="0"> <Resource name="jdbc/rollerdb" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/rollerdb autoReconnect=true&useUnicode=true&characterEncoding=utf-8&m ysqlEncoding=utf8" username="roller_user" password="password" maxActive="20" maxIdle="3" removeAbandoned="true" maxWait="3000" /> <Resource name="mail/Session" auth="Container" type="javax.mail.Session" username="[email protected]" password="password" mail.debug="false" mail.user="[email protected]" mail.password="password" mail.smtp.from="[email protected]" mail.transport.protocol="smtp" mail.smtp.port="465" mail.smtp.host="smtp.gmail.com" mail.smtp.auth="true" mail.smtp.starttls.enable="true" mail.smtp.socketFactory.port="465" mail.smtp.socketFactory.class="javax.net.ssl.SSLSocketFactory" mail.smtp.socketFactory.fallback="false" /> </Context> Just change the values in bold.Maybe your server has port 25 blocked or something like that. Regards, Alfonso ----- Original Message ----- From: "Vikas Dahiya" <[email protected]> To: <[email protected]> Sent: Wednesday, August 26, 2009 3:00 AM Subject: Mails are not going to user in roller. Hi, I Have made configuration for mail setup as per installation document. I have setup mail host. When mail host was not set up, I was getting exception. But now I am not getting any exception in log file. But the problem is that mails are not going to the users when I am registering them. Log entries When Mail server username/password are incorrect INFO 2009-08-26 11:49:15,376 DatabaseProvider:successMessage - SUCCESS: Got parameters. Using configuration type JDBC_PROPERTIES INFO 2009-08-26 11:49:15,376 DatabaseProvider:successMessage - -- Using JDBC driver class: com.mysql.jdbc.Driver INFO 2009-08-26 11:49:15,392 DatabaseProvider:successMessage - -- Using JDBC connection URL: jdbc:mysql://localhost:3306/rollerdb INFO 2009-08-26 11:49:15,392 DatabaseProvider:successMessage - -- Using JDBC username: root INFO 2009-08-26 11:49:15,392 DatabaseProvider:successMessage - -- Using JDBC password: [hidden] INFO 2009-08-26 11:49:15,407 DatabaseProvider:successMessage - SUCCESS: loaded JDBC driver class [com.mysql.jdbc.Driver] WARN 2009-08-26 11:49:16,251 WebloggerStartup:prepare - Failed to setup mail provider, continuing anways. Reason: ERROR connecting to mail server org.apache.roller.weblogger.business.startup.StartupException: ERROR connecting to mail server at org.apache.roller.weblogger.business.MailProvider.<init>(MailProvider.ja va:99) at org.apache.roller.weblogger.business.startup.WebloggerStartup.prepare(We bloggerStartup.java:179) at org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(Rol lerContext.java:138) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.j ava:3843) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342 ) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.ja va:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:9 26) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java :889) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:31 1) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu pport.java:117) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:578) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) --- ROOT CAUSE --- javax.mail.AuthenticationFailedException at javax.mail.Service.connect(Service.java:306) at javax.mail.Service.connect(Service.java:156) at org.apache.roller.weblogger.business.MailProvider.getTransport(MailProvi der.java:126) at org.apache.roller.weblogger.business.MailProvider.<init>(MailProvider.ja va:96) at org.apache.roller.weblogger.business.startup.WebloggerStartup.prepare(We bloggerStartup.java:179) at org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(Rol lerContext.java:138) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.j ava:3843) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342 ) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.ja va:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:9 26) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java :889) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:31 1) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu pport.java:117) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:578) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) INFO 2009-08-26 11:49:17,344 WebloggerFactory:bootstrap - Bootstrapping Roller Weblogger business tier INFO 2009-08-26 11:49:17,344 WebloggerFactory:bootstrap - Weblogger Provider = org.apache.roller.weblogger.business.GuiceWebloggerProvider INFO 2009-08-26 11:49:17,344 DatabaseProvider:successMessage - SUCCESS: Got parameters. Using configuration type JDBC_PROPERTIES INFO 2009-08-26 11:49:17,360 DatabaseProvider:successMessage - -- Using JDBC driver class: com.mysql.jdbc.Driver INFO 2009-08-26 11:49:17,360 DatabaseProvider:successMessage - -- Using JDBC connection URL: jdbc:mysql://localhost:3306/rollerdb INFO 2009-08-26 11:49:17,360 DatabaseProvider:successMessage - -- Using JDBC username: root INFO 2009-08-26 11:49:17,360 DatabaseProvider:successMessage - -- Using JDBC password: [hidden] INFO 2009-08-26 11:49:17,360 DatabaseProvider:successMessage - SUCCESS: loaded JDBC driver class [com.mysql.jdbc.Driver] INFO 2009-08-26 11:49:17,391 JPAPersistenceStrategy:<init> - openjpa.Log: commons INFO 2009-08-26 11:49:18,266 IndexManagerImpl:<init> - search enabled: true Log Entries when Mail server username/password are correct. INFO 2009-08-26 13:15:02,204 DatabaseProvider:successMessage - SUCCESS: Got parameters. Using configuration type JDBC_PROPERTIES INFO 2009-08-26 13:15:02,204 DatabaseProvider:successMessage - -- Using JDBC driver class: com.mysql.jdbc.Driver INFO 2009-08-26 13:15:02,204 DatabaseProvider:successMessage - -- Using JDBC connection URL: jdbc:mysql://localhost:3306/rollerdb INFO 2009-08-26 13:15:02,204 DatabaseProvider:successMessage - -- Using JDBC username: root INFO 2009-08-26 13:15:02,204 DatabaseProvider:successMessage - -- Using JDBC password: [hidden] INFO 2009-08-26 13:15:02,235 DatabaseProvider:successMessage - SUCCESS: loaded JDBC driver class [com.mysql.jdbc.Driver] INFO 2009-08-26 13:15:03,813 WebloggerFactory:bootstrap - Bootstrapping Roller Weblogger business tier INFO 2009-08-26 13:15:03,813 WebloggerFactory:bootstrap - Weblogger Provider = org.apache.roller.weblogger.business.GuiceWebloggerProvider INFO 2009-08-26 13:15:03,813 DatabaseProvider:successMessage - SUCCESS: Got parameters. Using configuration type JDBC_PROPERTIES INFO 2009-08-26 13:15:03,813 DatabaseProvider:successMessage - -- Using JDBC driver class: com.mysql.jdbc.Driver INFO 2009-08-26 13:15:03,813 DatabaseProvider:successMessage - -- Using JDBC connection URL: jdbc:mysql://localhost:3306/rollerdb INFO 2009-08-26 13:15:03,828 DatabaseProvider:successMessage - -- Using JDBC username: root INFO 2009-08-26 13:15:03,828 DatabaseProvider:successMessage - -- Using JDBC password: [hidden] INFO 2009-08-26 13:15:03,828 DatabaseProvider:successMessage - SUCCESS: loaded JDBC driver class [com.mysql.jdbc.Driver] INFO 2009-08-26 13:15:03,844 JPAPersistenceStrategy:<init> - openjpa.Log: commons INFO 2009-08-26 13:15:04,656 IndexManagerImpl:<init> - search enabled: true INFO 2009-08-26 13:15:04,656 IndexManagerImpl:<init> - index dir: C:\Documents and Settings\Default User\roller_data\search-index INFO 2009-08-26 13:15:04,687 ReferrerQueueManagerImpl:<init> - Instantiating Referrer Queue Manager INFO 2009-08-26 13:15:04,687 ReferrerQueueManagerImpl:<init> - Asynchronous referrer processing = false INFO 2009-08-26 13:15:04,687 ThreadManagerImpl:<init> - Instantiating Thread Manager INFO 2009-08-26 13:15:04,703 WebloggerFactory:bootstrap - Roller Weblogger business tier successfully bootstrapped INFO 2009-08-26 13:15:04,703 WebloggerFactory:bootstrap - Version: 4.0.1 INFO 2009-08-26 13:15:04,703 WebloggerFactory:bootstrap - Revision: 729109 INFO 2009-08-26 13:15:04,703 WebloggerImpl:initialize - Initializing Roller Weblogger business tier INFO 2009-08-26 13:15:08,109 ThemeManagerImpl:initialize - Loaded 29 themes from disk. INFO 2009-08-26 13:15:08,109 ThreadManagerImpl:initialize - Initializing task: ScheduledEntriesTask INFO 2009-08-26 13:15:08,202 ThreadManagerImpl:initialize - Initializing task: ResetHitCountsTask INFO 2009-08-26 13:15:08,234 ThreadManagerImpl:initialize - Initializing task: TurnoverReferersTask INFO 2009-08-26 13:15:08,265 ThreadManagerImpl:initialize - Initializing task: PingQueueTask INFO 2009-08-26 13:15:08,296 ThreadManagerImpl:initialize - Initializing task: RefreshRollerPlanetTask INFO 2009-08-26 13:15:08,343 ThreadManagerImpl:initialize - Initializing task: SyncWebsitesTask INFO 2009-08-26 13:15:08,655 WebloggerImpl:initialize - Roller Weblogger business tier successfully initialized INFO 2009-08-26 13:15:08,655 PlanetConfig:<clinit> - successfully loaded default properties. INFO 2009-08-26 13:15:08,655 PlanetConfig:<clinit> - successfully loaded custom properties file from classpath INFO 2009-08-26 13:15:08,655 PlanetConfig:<clinit> - no custom properties file specified via jvm option INFO 2009-08-26 13:15:08,671 DatabaseProvider:successMessage - SUCCESS: Got parameters. Using configuration type JDBC_PROPERTIES INFO 2009-08-26 13:15:08,671 DatabaseProvider:successMessage - -- Using JDBC driver class: com.mysql.jdbc.Driver INFO 2009-08-26 13:15:08,671 DatabaseProvider:successMessage - -- Using JDBC connection URL: jdbc:mysql://localhost:3306/rollerdb INFO 2009-08-26 13:15:08,671 DatabaseProvider:successMessage - -- Using JDBC username: root INFO 2009-08-26 13:15:08,671 DatabaseProvider:successMessage - -- Using JDBC password: [hidden] INFO 2009-08-26 13:15:08,671 DatabaseProvider:successMessage - SUCCESS: loaded JDBC driver class [com.mysql.jdbc.Driver] INFO 2009-08-26 13:15:08,749 PlanetFactory:bootstrap - Bootstrapping Roller Planet business tier INFO 2009-08-26 13:15:08,749 PlanetFactory:bootstrap - Planet Provider = org.apache.roller.planet.business.GuicePlanetProvider INFO 2009-08-26 13:15:08,780 JPARollerPlanetPersistenceStrategy:<init> - openjpa.Log: commons INFO 2009-08-26 13:15:08,812 PlanetFactory:bootstrap - Roller Planet business tier successfully bootstrapped INFO 2009-08-26 13:15:08,812 JPAPlanetImpl:initialize - Initializing Roller Planet business tier INFO 2009-08-26 13:15:09,062 JPAPlanetImpl:initialize - Roller Planet business tier successfully initialized Please help! Regards, --Vikas Dahiya __________ NOD32 4367 (20090825) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com __________ NOD32 4368 (20090826) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com
