From Luke Jackson

Revision as of 05:34, 4 May 2007 (edit) Ljackson (Talk | contribs) (→Custom Install) ← Previous diff		Revision as of 02:25, 19 July 2007 (edit) Ljackson (Talk | contribs) Next diff →
Line 22:		Line 22:
	database to the latest version.		database to the latest version.
	</pre>		</pre>
		+
		+	= Configure MySQL Storage =
		+
		+	Create a softlink for the init.d script:
		+
		+	cd /usr/local/
		+	ln -s queuemetrics/webapps/queuemetrics-1.3.4/WEB-INF/mysql-utils/qloader/ qloader
		+
		+	Copy over the init.d script:
		+
		+	cp /usr/local/qloader/qloaderd /etc/init.d/
		+	chmod +x /etc/init.d/qloaderd
		+
		+	Patch the logroate file for qloader
		+
		+	vi /etc/logrotate.d/asterisk
	= FAQ =		= FAQ =

---

Revision as of 02:25, 19 July 2007

Contents 1 Install 2 Configure MySQL Storage 3 FAQ 3.1 Errore JDBC:java.lang.ClassNotFoundException: com.mysql.jdbc.Driver 3.1.1 RPM or Yum 3.1.2 Custom Install 4 Sources

Install

wget -P /etc/yum.repos.d http://yum.loway.ch/loway.repo
yum install queuemetrics

If you are installing QM for the first time, run the following
commands to install the database:

cd /usr/local/queuemetrics/webapps/queuemetrics-1.3.4/WEB-INF/README
./installDb.sh

When you are done, point your browser to:
. http://thismachine:8080/queuemetrics
and login as user demoadmin / password demo.

If you are updating from a previous version, just point your
browser to:
. http://thismachine:8080/queuemetrics/dbtest
to check if your database link is working and update the
database to the latest version.

Configure MySQL Storage

Create a softlink for the init.d script:

cd /usr/local/
ln -s queuemetrics/webapps/queuemetrics-1.3.4/WEB-INF/mysql-utils/qloader/ qloader

Copy over the init.d script:

cp /usr/local/qloader/qloaderd /etc/init.d/
chmod +x /etc/init.d/qloaderd 

Patch the logroate file for qloader

vi /etc/logrotate.d/asterisk

FAQ

Errore JDBC:java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

RPM or Yum

If you installed via yum it is most likely that the symlink to the mysql java connect is broken and will need to be changed. You can find this link in the directory:

/usr/local/queuemetrics/webapps/queuemetrics-1.3.4/WEB-INF/lib

Broken Link

connector.jar -> /usr/share/java/mysql-connector-java-3.1.12-bin.jar

Issue the commands below to fix the symlink and then restart queuemetrics

cd /usr/local/queuemetrics/webapps/queuemetrics-1.3.4/WEB-INF/lib
unlink connector.jar
ln -s /usr/share/java/mysql-connector-java.jar connector.jar
/etc/init.d/queuemetrics restart

Custom Install

If you have not installed via rpm your situation my differ from what is listed above. If so simply download the MySQL Java Connector from the MySQL site.

Extract the MySQL Java Connector you have downloaded and locate a file named mysql-connector-java-X.X.X.jar. Move the file into /usr/share/java and follow the steps above to create a symlink to it. Once completed restart QueueMetrics.

Sources

• http://www.mysql.com/products/connector-j/index.html