<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix"><small>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. <br>
<br>
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.<br>
<br>
Hoper this helps<br>
<br>
Mimi</small><br>
<br>
On 08/12/2012 19:59, Paul Snom wrote:<br>
</div>
<blockquote cite="mid:SNT126-W1487616BDC6F1DC1BFBEFBD84B0@phx.gbl"
type="cite">
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
<div dir="ltr">
thanks for the input, I will try to create this table manually,
but at what point/step is this table created? <br>
<br>
thanks<br>
P<br>
<br>
<div>
<hr id="stopSpelling">Date: Sat, 8 Dec 2012 19:26:36 +0000<br>
From: <a class="moz-txt-link-abbreviated" href="mailto:mimicafe@gmail.com">mimicafe@gmail.com</a><br>
To: <a class="moz-txt-link-abbreviated" href="mailto:users@lists.opensips.org">users@lists.opensips.org</a><br>
Subject: Re: [OpenSIPS-Users] having problems installing
opensips-cp opensips.acc doesn't exist<br>
<br>
<div class="ecxmoz-cite-prefix"><small>Hi, <br>
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.<br>
<br>
Mimi</small><br>
<br>
On 08/12/2012 19:19, Paul Snom wrote:<br>
</div>
<blockquote
cite="mid:SNT126-W88C3279EA72E76B7BAC48D84B0@phx.gbl">
<style><!--
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
--></style>
<div dir="ltr"> Hi;<br>
<br>
I'm having problems installing opensips-cp, these are my
steps<br>
1. I manually create an empty MySQL 5.5 table 'opensips' I
execute mysql -D opensips -p < cdrs.mysql -> this
creates 1 table 'cdrs'<br>
2. mysql -D opensips -p < opensips_cdrs_1_6.mysql<br>
<br>
when I exucute step 2 I get the error: ERROR 1146 (42S02)
at line 2: Table 'opensips.acc' doens't exist<br>
<br>
Is there something I'm missing or overlooking? <br>
<br>
Thanks<br>
<br>
<br>
</div>
<br>
<fieldset class="ecxmimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Users mailing list
<a moz-do-not-send="true" class="ecxmoz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true" class="ecxmoz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
<br>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a></div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>