<html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><meta name="Generator" content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML con formato previo Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.HTMLconformatoprevioCar
{mso-style-name:"HTML con formato previo Car";
mso-style-priority:99;
mso-style-link:"HTML con formato previo";
font-family:Consolas;
color:black;}
span.EstiloCorreo19
{mso-style-type:personal;
font-family:Consolas;
color:windowtext;}
span.EstiloCorreo20
{mso-style-type:personal;
font-family:Consolas;
color:#1F497D;}
span.EstiloCorreo21
{mso-style-type:personal-reply;
font-family:Consolas;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style></head><body bgcolor="white" lang="ES-CL" link="blue" vlink="purple"><div class="WordSection1"><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Hi.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">I just found the problem.</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">It was a permissions problem. I was using chmod 777 only to the directory.. but I need to give permission to all the subdirectories and files.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Maybe would be helpful if someone can include a TIP or HINT in the install page indicating the “good” way to do a chmod.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Thanks anyway!</span><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Regards,</span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Ricardo.-</span></p><p class="MsoNormal">
<span style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p><div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span lang="ES" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">De:</span></b><span lang="ES" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"> Ricardo Martinez [mailto:<a href="mailto:rmartinez@redvoiss.net">rmartinez@redvoiss.net</a>] <br>
<b>Enviado el:</b> jueves, 06 de enero de 2011 9:43<br><b>Para:</b> '<a href="mailto:ramona@asipto.com">ramona@asipto.com</a>'<br><b>CC:</b> '<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>'<br>
<b>Asunto:</b> RE: [SR-Users] SIREMIS logging problem.</span></p></div></div><p class="MsoNormal"> </p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Hi Ramona.</span></p><p class="MsoNormal">
<span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Yes… i forgot to mention that the database is created. But for some reason the “contact” table is not present.</span></p><p class="MsoNormal">
<span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">mysql> use siremis;</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Reading table information for completion of table and column names</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">You can turn off this feature to get a quicker startup with -A</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Database changed</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">mysql> show tables;</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">+-------------------+</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| Tables_in_siremis |</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">+-------------------+</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| acl_action |</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| acl_role_action |</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| group |</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| menu |</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| meta_do |</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| meta_form |</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| meta_view |</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| module |</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| pass_token |</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| role |</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| user |</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| user_group |</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">| user_role |</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">+-------------------+</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">13 rows in set (0.00 sec)</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">mysql></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">What could be happening?</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Regards,</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D">Ricardo.-</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas;color:#1F497D"> </span></p>
<div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span lang="ES" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">De:</span></b><span lang="ES" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"> <a href="mailto:sr-users-bounces@lists.sip-router.org">sr-users-bounces@lists.sip-router.org</a> [mailto:<a href="mailto:sr-users-bounces@lists.sip-router.org">sr-users-bounces@lists.sip-router.org</a>] <b>En nombre de </b>Elena-Ramona Modroiu<br>
<b>Enviado el:</b> miércoles, 05 de enero de 2011 19:07<br><b>Para:</b> Ricardo Martinez<br><b>CC:</b> <a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br><b>Asunto:</b> Re: [SR-Users] SIREMIS logging problem.</span></p>
</div></div><p class="MsoNormal"> </p><p class="MsoNormal">Hi,<br><br>have you created siremis database? You have a checkbox at step 2 in the installation wizard:<br><br><a href="http://kb.asipto.com/siremis:install20:main#step_2">http://kb.asipto.com/siremis:install20:main#step_2</a><br>
<br>Regards,<br>Ramona<br><br>On 01/05/2011 09:48 PM, Ricardo Martinez wrote: </p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Hello.</span></p><p class="MsoNormal" style="margin-bottom:12.0pt">
<span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">I have Siremis 2.0 installed from scratch, but I’m unable to logging. This is the error that I’m getting from the logs : </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">'01/05/2011','12:41:36','ERR','DATAOBJ','Query Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'siremis.contact' doesn't exist','n/a'</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> </span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">I was checking the SIREMIS db and I can’t found the table “contact”. </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Is this a bug?.. can someone help me?</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas"> </span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Thanks</span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:Consolas">Regards,</span></p><p class="MsoNormal">
<b><span style="font-size:10.0pt;font-family:"Arial","sans-serif""> </span></b></p><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Ricardo Martinez.-</span></b></p>
<pre> </pre><pre> </pre><pre>_______________________________________________</pre><pre>SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list</pre><pre><a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a></pre>
<pre><a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a></pre><pre> </pre><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""> </span></p>
</div></body></html>