From Luke Jackson

Revision as of 02:25, 19 July 2007 (edit) Ljackson (Talk | contribs) ← Previous diff		Revision as of 02:28, 19 July 2007 (edit) Ljackson (Talk | contribs) (→Configure MySQL Storage) Next diff →
Line 24:		Line 24:
	= Configure MySQL Storage =		= Configure MySQL Storage =
		+
		+	== Import Statistics ==
		+
		+	perl /usr/local/queuemetrics/webapps/queuemetrics-1.3.4/WEB-INF/mysql-utils/queueLoader.pl /var/log/asterisk/queue_log P01 >>/dev/null 2>>/dev/null
		+
		+	== Configure Statistics Update Service ==
	Create a softlink for the init.d script:		Create a softlink for the init.d script:
Line 32:		Line 38:
	Copy over the init.d script:		Copy over the init.d script:
-	cp /usr/local/qloader/qloaderd /etc/init.d/	+	cp /usr/local/qloader/RedHat-style-initscripts/qloaderd /etc/init.d/
	chmod +x /etc/init.d/qloaderd		chmod +x /etc/init.d/qloaderd

---

Revision as of 02:28, 19 July 2007

Contents 1 Install 2 Configure MySQL Storage 2.1 Import Statistics 2.2 Configure Statistics Update Service 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

Import Statistics

perl /usr/local/queuemetrics/webapps/queuemetrics-1.3.4/WEB-INF/mysql-utils/queueLoader.pl /var/log/asterisk/queue_log P01 >>/dev/null 2>>/dev/null

Configure Statistics Update Service

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/RedHat-style-initscripts/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