how to start mysql server & apache server at startup and then tomcat at last at boot

sanjay87 · 06-16-2012, 01:01 AM

HI all

I have webserver running following application apache mysql tomcat .I had made chkconfig level enable for httpd mysql tomcat at startup .But i could find apache startup first and then tomcat and then mysql startup third ,So my tomcat application fail to startup due to my mysql it could not connect since it startup at last of boot .How can i set boot priority to make httpd mysql and tomcat to boot at my boot level.

Quote:

How can i set Boot priority in chkconfig in order of Boot apache first second mysql then at last tomcat application

Quote:

** BEGIN NESTED EXCEPTION **

2012-Jun-07 08:53:27:401(MasterDataApplicationScopeListener.java:contextInitialized:75)-contextInitialized(ServletContextEvent) - start
2012-Jun-07 08:53:28:743(JDBCExceptionReporter.java:logExceptions:72)-Communications link failure due to underlying exception:

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2555)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverMan agerDataSource.java:174)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDat aSource.java:165)

centos123 · 06-16-2012, 01:24 AM

just run

chkconfig mysqld on
chkconfig httpd on

whenever you boot your system its services start automatically always....

sanjay87 · 06-16-2012, 01:28 AM

Yes Wright i had made chkconfig level enabled But apache tomcat startuping up first and then mysql get starting up at boot level .thats my problem ,Since tomcat startup fails Due to mysql startup later after tomcat application start .

bathory · 06-16-2012, 03:39 AM

Hi,

You should change the startup order of these services. Check /etc/rc.3.d

Code:

ls -l /etc/rc.3.d

to see the startup order of apache an tomcat and change mysql's order to a minor number, so it starts first.
E.g. in centos

Code:

ls -l /etc/rc3.d/*http*  /etc/rc3.d/*mysql*
lrwxrwxrwx. 1 root root 16 Jun 15 14:20 /etc/rc3.d/S64mysqld -> ../init.d/mysqld
lrwxrwxrwx. 1 root root 15 Jun 14 18:38 /etc/rc3.d/S85httpd -> ../init.d/httpd

So open /etc/init.d/mysqld, find the line

Quote:

# chkconfig: - 64 36

and change it to something like

Code:

# chkconfig: - 50 36

50 is the new starting priority. Must be less from the one of apache (85 in my case, see the above ls output) and the one of tomcat (I don't run it, so I don't know its priority)
After that run

Code:

chkconfig  mysqld resetpriorities

Regards

sanjay87 · 06-16-2012, 04:26 AM

[root@example rc3.d]# ls -l /etc/rc3.d/*httpd* /etc/rc3.d/*mysql* /etc/rc3.d/*tomcat*
lrwxrwxrwx. 1 root root 16 Jun 15 23:30 /etc/rc3.d/S64mysqld -> ../init.d/mysqld
lrwxrwxrwx. 1 root root 16 Jun 15 23:30 /etc/rc3.d/S73tomcat -> ../init.d/tomcat
lrwxrwxrwx. 1 root root 15 Jun 15 23:30 /etc/rc3.d/S85httpd -> ../init.d/httpd
[root@example rc3.d]# cd
[root@example ~]# vi /etc/init.d/mysqld

Quote:

vi /etc/init.d/mysqld
#!/bin/sh
#
# mysqld This shell script takes care of starting and stopping
# the MySQL subsystem (mysqld).
#

Quote:

chkconfig: - 50 36

# description: MySQL database server.
# processname: mysqld
# config: /etc/my.cnf
# pidfile: /var/run/mysqld/mysqld.pid

# Source function library.
. /etc/rc.d/init.d/functions

# Source networking configuration.

[root@example ~]# service mysqld restart
/etc/init.d/mysqld: line 6: chkconfig:: command not found
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
[root@example ~]# vi /etc/init.d/mysqld

tomcat service

Quote:

#!/bin/bash
# chkconfig: - 73 37
#
# processname: tomcat
# pidfile: /var/run/tomcat.pid

CATALINA_PID=/var/run/tomcat.pid

JAVA_OPTS="-server -Xms1024m -Xmx1024m -XX:MaxPermSize=512m"

CATALINA_HOME=/tomcat/apache-tomcat-6.0.16/

CATALINA_BASE=/tomcat/apache-tomcat-6.0.16/

Then too it shows same problem

bathory · 06-16-2012, 08:19 AM

Quote:

[root@example ~]# service mysqld restart
/etc/init.d/mysqld: line 6: chkconfig:: command not found

What distro are you running? You mentioned in your previous post that you did the chkconfig stuff, so I thought you're running a RHEL based distro.
Anyway, you can rename the /etc/rc3.d/S73tomcat symlink to /etc/rc3.d/S99tomcat, so tomcat starts last (after all other services). You should do the same for the rest of runlevels (e.g in /etc/rc2.d, //etc/rc4.d, etc/rc5.d)

Regards