Author Topic: Switching from flatfile to Mysql  (Read 3272 times)

ew

  • Newbie
  • *
  • Posts: 5
  • Karma: 0
    • View Profile
Switching from flatfile to Mysql
« on: June 19, 2009, 19:41:46 »
hello,

how can i switch the storage type from the flatfile (/var/log/asterisk/queue_log) to an mysql storage typ?
the tables are already created.

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Switching from flatfile to Mysql
« Reply #1 on: June 22, 2009, 12:15:10 »
This is very simple, will take 5 minutes:
1. install qloaderd to upload data from Asterisk to the MySQL DB
2. tell QM to read data from MySQL and not directly form the file

We have a tutorial here: http://queuemetrics.com/download/QM_mysql_cluster_100.pdf


ew

  • Newbie
  • *
  • Posts: 5
  • Karma: 0
    • View Profile
Re: Switching from flatfile to Mysql
« Reply #2 on: June 25, 2009, 14:37:31 »
Easy as 1 2 3...

Thanks a lot

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Switching from flatfile to Mysql
« Reply #3 on: June 26, 2009, 17:21:39 »
Is it working?