Hi I am sorry, as I did not mention that I have root password for mysql. I have entered the root password(for mysql) in my db.properties file. I have specified in CLASSPATH as well for mysql connector in both $CATALINA_HOME/bin/setclasspath.sh and also the user's .bash_profile.
Today morning I found the mistake I was making.. mysql(user) is owner for /var/lib/mysql. tomcat(user) is owner for $CATALINA_HOME. If I start tomcat with tomcat ownership and tomcat user, I get this error. When I made $CATALINA_HOME to root ownership, and start tomcat with root user, Then the application is connecting to the database without any problem. However, It is working, until the database location is /var/lib/mysql. If I change the database location to any other directory and specify in /etc/my.cnf file as datadir, Then I will not be able to start MySQL server even. The detail of this new error is as below while starting the MySQL server with command # service mysqld start: Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED] I checked with /var/lib/mysqld.log file. It says, log as below: 060629 12:56:36 mysqld started 060629 12:56:36 [Warning] Can't create test file /data/mysql/swt04db.lower-test ^G/usr/libexec/mysqld: Can't change dir to '/data/mysql/' (Errcode: 13) 060629 12:56:36 [ERROR] Aborting 060629 12:56:36 [Note] /usr/libexec/mysqld: Shutdown complete 060629 12:56:36 mysqld ended I confirmed that the mysql directory inside the /data/mysql is having the ownership of mysql:mysql with appropriate permissions. Since the / is less disk space , I need to shft the data to /data (900GB). Any clue please.... On 6/29/06, Gordon Smith <[EMAIL PROTECTED]> wrote:
If Class.forName throws a null pointer exception, chances are it can't find the driver because you have a Tomcat configuration problem or other classpath-related problem relating to driver setup. Please check out the documentation on tomcat.apache.org for the details for your version of Tomcat. As an aside, please consult the MySQL documentation about setting a root password and disabling unneeded accounts in the database. You are leaving a gaping security hole in your app by not establishing a root db pwd. Once you put a root pwd in place, there's no reason to share it in this forum as long as you can connect by using that pwd from the MySQL client. Hope this helps. Cheers, Gordon Smith -----Original Message----- From: navaneethan loganathan [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 28, 2006 7:57 PM To: users@tomcat.apache.org Subject: Error while connecting to MySQL database Hi, I am facing a problem with my Apache-Tomcat-MySQL installation.MyEnvironment is as follows: Redhat ES4(2.6.9-5.EL), Apache-Tomcat-5.5.15, MySQL 4.1.12, Java version 1.5.0_06, Apache-Tomcat connector ajp13, mysql-connector-java-3.2.0-alpha-bin.jar. After installation and configuration I am unable to connect to the database through the application and getting the following exception in catalina.outlog file. java.lang.NullPointerException at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:164) However, I am able to browse my site perfectly with http://localhost/index.jsp (the connector also configured perfectly, so that I do not need to specify the port number in URL). I put the mysql-connector-java-3.2.0-alpha-bin.jar file in $CATALINA_HOME/common/lib and also specified in CLASSPATH. I am able to login to MySQL through command and access the database without any problem. My db.properties is as under: # MySQL database access properties db.driver = org.gjt.mm.mysql.Driver db.url = jdbc:mysql://localhost:3306/testdb db.user = root db.pwd = Any clue will be very much helpfull.Thanks in advance. --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
