[OpenSIPS-Users] Opensips control panel installation problem

[Dragos Oancea]

Hi

Soner Kacar wrote:
> 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


The stored procedure that generates CDRs from the acc table is here:
/web/tools/cdrviewer/openser_cdrs_1_2.sql -  so you should be installing 
it with smth like this:
       mysql -Dopensips -p < ./web/tools/cdrviewer/opensips_cdrs_1_2.sql

The project doc is not that good yet...

> 
> 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 ??
> 

You should be using Mysql 5 . Mysql 4 does not have stored procedures , 
as far as I know.

> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-- 


Dragos Oancea
VOIP Developer
Voice System
www.voice-system.ro
+40 21 637 2407