[OpenSIPS-Users] having problems installing opensips-cp opensips.acc doesn't exist

[Mimi Cafe]

Normally you would run "opensipsdbctl create"  to create the opensips 
database (including tables) during installation. I believe you can still 
go back and use it to create the tables because they are to omany of 
them and this makes life easier.

If you run it and it give an error that the db exist, then clonsider 
dropping the existing one (if it doesn't contain data) and have 
opensipsdbctl create it.

Hoper this helps

Mimi

On 08/12/2012 19:59, Paul Snom wrote:
> thanks for the input, I will try to create this table manually,  but 
> at what point/step is this table created?
>
> thanks
> P
>
> ------------------------------------------------------------------------
> Date: Sat, 8 Dec 2012 19:26:36 +0000
> From: mimicafe at gmail.com
> To: users at lists.opensips.org
> Subject: Re: [OpenSIPS-Users] having problems installing opensips-cp 
> opensips.acc doesn't exist
>
> Hi,
> it says table acc does not exist (this is probably true). If you have 
> followed all the steps correctly, then you shouldn't have this issue. 
> Perhaps,  you should go on and create the acc table and then load the 
> SQL again.
>
> Mimi
>
> On 08/12/2012 19:19, Paul Snom wrote:
>
>     Hi;
>
>     I'm having problems installing opensips-cp, these are my steps
>     1. I manually create an empty MySQL 5.5 table 'opensips' I execute
>     mysql -D opensips -p < cdrs.mysql  -> this creates 1 table 'cdrs'
>     2. mysql -D opensips -p < opensips_cdrs_1_6.mysql
>
>     when I exucute step 2 I get the error: ERROR 1146 (42S02) at line
>     2: Table 'opensips.acc' doens't exist
>
>     Is there something I'm missing or overlooking?
>
>     Thanks
>
>
>
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> _______________________________________________ Users mailing list 
> Users at lists.opensips.org 
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121208/91833b21/attachment.htm>