[OpenSIPS-Users] Opensips control panel installation problem

[Soner Kacar]

Hi All

I tried to install opensips control panel today, but I have some problems with sql scripts

1) installation instruction states that :
   install opensips_cdrs_1_2.sql a mysql stored procedure that generates cdrs  from the acc table
        mysql -Dopensips -p < opensips_cdrs_1_4.sql

but script file opensips_cdrs_1_4.sql is not exists, I found only openser_cdrs_1_2.sql

:/usr/src/opensips-cp# find . -name "*sql"
./web/tools/cdrviewer/openser_cdrs_1_2.sql
./web/tools/cdrviewer/cdrs.sql
./web/tools/siptrace/template/prepaid.sql
./web/tools/smonitor/monitoring_stats.sql
./web/tools/smonitor/tables.sql
./web/tools/smonitor/monitored_stats.sql
./web/tools/drouting/drouting.sql

openser_cdrs_1_2.sql file is also not correct, After I have changed the sql file accordingly I run the comman again.

/usr/src/opensips-cp# mysql -Dopensips -p < ./web/tools/cdrviewer/openser_cdrs_1_2.sql
Enter password:
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PROCEDURE IF EXISTS openser_cdrs_1_2' at line 1

I deleted the line 'PROCEDURE IF EXISTS openser_cdrs_1_2' and tried again ......

/usr/src/opensips-cp# mysql -Dopensips -p < ./web/tools/cdrviewer/openser_cdrs_1_2.sql
Enter password:
ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PROCEDURE openser_cdrs_1_2()
BEGIN
  DECLARE done INT DEFAULT 0;
  DECLARE bye_r' at line 1


my mysql version:
:/usr/src/opensips-cp# mysql -V
mysql  Ver 14.7 Distrib 4.1.11, for unknown-linux-gnu (sparc)


any idea ??
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20081104/3f5d5612/attachment.htm