Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - mhcordeiro

Pages: [1]
1
Hello All,

I`m running Asterisk 1.6.0.3 and Installed Queuemetrics 1.5.4.

When accessing the Agent`s control panel, the following buttons are disabled:

Add Member
Remove Member
Dial

Do you I have to enable them in some config file??

Rgs,

Marco Cordeiro

2
Sorry my bad!! I was executing the load of the MYSQL Database in a wrong way, not specifying the destination database to the queuemetrics_sample.sql file.

After doing it in the right way as showed below, problem was solved.

mysql --user=queuemetrics --password=javadude queuemetrics < queuemetrics_sample.sql

Thanks,

Marco

3
MYSQL Connector is there. I checked WEB-INF/lib path and it had a logical link pointing to the file. Just to make sure I copied the file to the location, but it still not working.

I tried to load database configuration again (mysql -p < queuemetrics_sample.sql
) , and I get the following error:

ERROR 1046 (3D000) at line 28: No database selected

4
By uploading the database you mean the following command?

# mysql -p < queuemetrics_sample.sql

if yes, yes I did.

However, when I was installing  "mysql-connector-java-3.1.12-4.noarch.rpm" thru RPM, it gave a notice mentioning that it has mysql server dependency, even though the mysql server was already installed during the server instalation.

I performed the rpm command with the --nodeps option, and it went thru. Now I`m wondering if that has something to do.

Hope not... Mysql Server installed is version 5

Thanks again...

5
That's what I thought as weel, however I'm installing version queuemetrics-1.5.4.

As I already mentioned in installing in a Suse server, so I downloaded the RPM packages from http://loway.fileburst.com/RPMS/ , and installed them.

Is this ok? Is it possible to be done that way?

Marco

6
QueueMetrics installation / Unable to finish "JDBC connection tester"
« on: October 01, 2009, 22:31:19 »
Hello All,

I'm installing a brand new asterisk server, and started to install Queuemetrics on it. It is a Suse 10 Server.
Everything went well during installation, however, when I tried to access the application thru my browser (http://myip:8080/queuemetrics), I'm being forwarded to "JDBC connection tester" page.

I then choose to start the data base check. Then in the next page I have the following warning:
"Your database needs updating to run this version of QueueMetrics."
Following below in the same page, I have a table with many itens checked OK, except for 01 error in the end as follows:

Checking current version of table: 'dbversion'

Error

Java Error: Errore DB: java.sql.SQLException: Unknown column 'lic_version' in 'field list' The required database table 'dbversion' is missing some fields. Are you updating from a previous version of QM? 

I click on the "next" button to continue the wizard and have the following response:

"The database upgrade and repair process was terminated successfully. "

But in the same page I have an error as follows:

"Below you can find the performed check details: "

          |Test performed                                               |Result
1.2.0  | Adding the row counter on queue_log table | Err


Then, after going thru all the wizard, when I have the Start Queuemetrics button available, I click on it, and I'm taken back to the beginning of the process again, and keep on this eternal loop.

Could anybody help?

Thanks in advance,

Marco

7
Running QueueMetrics / Re: Making Outcome Pop-up window wider
« on: May 05, 2009, 18:52:23 »
Ok, here it goes as requested.

http://www.queuemetrics.com/img/screenshots/agscr_callstatus.png

The "Call Status" Field needs to be at least twice as large as the original.

Thanks again,

8
Running QueueMetrics / Making Outcome Pop-up window wider
« on: May 04, 2009, 16:05:50 »
Hello All,

I have implemented a list of outcome reasons in our Queuemetrics, so the analist can choose one that most applies for the call he/she just answered.
The fact is that the window and the drop-down box in it are to small related to long reason description they use in this call center.

Once I'm not so familiar with php programming, could some help me editing the files to make both, window and drop-down box wider?

The pop-up window I'm refering to is the one opened by clicking in the little pencil in the analist pannel, where he/she performs login, logoff, pauses, etc...

Thanks in advance for the help...

Marco

9
Thanks for the reply! I proceeded as recomended, and almost everything went great. The only thing that is still pending is the users and passwords configuration.
For Exemple: The Supervisor ID and password is not setup in the new machine after the configuration files migration.

Is it only setup manually?

thanks again,

Marco

10
QueueMetrics installation / Queuemetrics Migration to another machine
« on: December 26, 2008, 18:57:13 »
Hello All,

Soon, I'll have to migrate the Asterisk call center to a new server (New machine), and Queuemetrics will also migrate to this new machine. In order to start preparing for it, I'm trying to gather as much infoirmation I can to simulate this migration.
The intention is to keep all Queue data, and from the agents and supervisor point of view, the change won't be noticed.
Currently we are not using MySQL storage of the logs (it's a small CallCenter). So I was thinking about transferring the /var/log/asterisk/queue_log file, in order to keep the log to the reports.
My question is the agents and users configuration (Username, passwords, pauses configuration), which files should I backup to keep this current configuration.

Regarding the license info: Should I ask for a replacement? Or just use the same one?

Thanks again,

Marco Cordeiro

11
It was really the iptables. After disabling it, I was able to access the system.

Thanks for the tip.

Marco

12
Hello All, I have sucessfully installed Queuemetrics 1.5.0 thru yum process, and everything went very well.
I'm using CentOS 4.4 and Asterisk 1.4.22.

However, when I tried to access http://server:8080/queuemetrics it didn't work. When trying to access http://server:8080 it also didn't work.

I tried to restart queuemetrics as follows, but it also didn't work.
[root@asterisk WEB-INF]# /etc/init.d/queuemetrics restart
Stopping QueueMetrics: Using CATALINA_BASE:   /usr/local/queuemetrics/tomcat
Using CATALINA_HOME:   /usr/local/queuemetrics/tomcat
Using CATALINA_TMPDIR: /usr/local/queuemetrics/tomcat/temp
Using JAVA_HOME:       /usr/local/queuemetrics/java
Starting QueueMetrics:  Using CATALINA_BASE:   /usr/local/queuemetrics/tomcat
Using CATALINA_HOME:   /usr/local/queuemetrics/tomcat
Using CATALINA_TMPDIR: /usr/local/queuemetrics/tomcat/temp
Using JAVA_HOME:       /usr/local/queuemetrics/java

Then I tried checking the status of the queuemetrics process, and it looks OK. (I guess):

[root@asterisk WEB-INF]# ps -ef | grep queuemetrics
root      3368     1  0 17:55 ?        00:00:00 /usr/bin/perl /usr/local/qloader/qloader.pl -h localhost -d queuemetrics -u queuemetrics -p javadude /var/log/asterisk/queue_log P001 /var/log/asterisk/qloaderd.log
root      4508     1  1 18:47 pts/0    00:00:02 /usr/local/queuemetrics/java/bin/java -Xms128M -Xmx128M -Djava.endorsed.dirs=/usr/local/queuemetrics/tomcat/common/endorsed -classpath /usr/local/queuemetrics/java/lib/tools.jar:/usr/local/queuemetrics/tomcat/bin/bootstrap.jar:/usr/local/queuemetrics/tomcat/bin/commons-logging-api.jar -Dcatalina.base=/usr/local/queuemetrics/tomcat -Dcatalina.home=/usr/local/queuemetrics/tomcat -Djava.io.tmpdir=/usr/local/queuemetrics/tomcat/temp org.apache.catalina.startup.Bootstrap start
root      4553  4209  0 18:52 pts/0    00:00:00 grep queuemetrics

Everytime I try to access thru my web browser, I get "Internet Explorer cannot display the webpage".

Any clues that what might be wrong, or any configuration I should check??

Thanks,

Marco Cordeiro

Pages: [1]