Opensips control panel installation problem

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: 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
> [hidden email]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

--


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




_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users