Probably some permission problem on the user, check error logs in your db.<div><br><br><div class="gmail_quote">On Wed, Oct 31, 2012 at 10:05 AM, Archana Venugopan <span dir="ltr"><<a href="mailto:a.venugopan@mundio.com" target="_blank">a.venugopan@mundio.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-GB" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="color:#1f497d">Hi,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">To give you further information. This is my version<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">FreeSWITCH Version 1.2.3+git~20121004T033301Z~94664868a8 (1.2.3; git at commit 94664868a8 on Thu, 04 Oct 2012 03:33:01 Z)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<p class="MsoNormal"><span style="color:#1f497d">Regards,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Archana</span><span style="font-size:10.0pt;color:#1f497d"><u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></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="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a> [mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>]
<b>On Behalf Of </b>Archana Venugopan<br>
<b>Sent:</b> 31 October 2012 12:40</span></p><div><div class="h5"><br>
<b>To:</b> FreeSWITCH Users Help<br>
<b>Subject:</b> Re: [Freeswitch-users] SQL ERR while running freeswitch<u></u><u></u></div></div><p></p>
</div>
</div><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="color:#1f497d">Hi,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Database connection is executed<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">[root@squay-laptop-1 log]# isql -v SMEPBX smepbx smeswitch<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">+---------------------------------------+<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">| Connected! |<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">| |<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">| sql-statement |<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">| help [tablename] |<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">| quit |<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">| |<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">+---------------------------------------+<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">SQL><u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">But still when I run freeswitch I am getting SQL ERR errors. Can someone please help me out, this looks so peculiar for me.
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Many thanks.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<p class="MsoNormal"><span style="color:#1f497d">Regards,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Archana</span><span style="font-size:10.0pt;color:#1f497d"><u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></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="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a> [mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>]
<b>On Behalf Of </b>Archana Venugopan<br>
<b>Sent:</b> 31 October 2012 08:46<br>
<b>To:</b> FreeSWITCH Users Help<br>
<b>Subject:</b> Re: [Freeswitch-users] SQL ERR while running freeswitch<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="color:#1f497d">Hi,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">As per the installation procedure after changing odbc.ini I ran this command<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">/usr/local/freeswitch/bin/freeswitch<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">After which I got this error.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<p class="MsoNormal"><span style="color:#1f497d">Regards,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Archana</span><span style="font-size:10.0pt;color:#1f497d"><u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></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="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a> [mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>]
<b>On Behalf Of </b>Tim Meade<br>
<b>Sent:</b> 30 October 2012 18:42<br>
<b>To:</b> FreeSWITCH Users Help<br>
<b>Subject:</b> Re: [Freeswitch-users] SQL ERR while running freeswitch<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">I know it’s simple, but did you restart Freeswitch after configuring odbc.ini so that FS would create the appropriate tables?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></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="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a> [mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>]
<b>On Behalf Of </b>Archana Venugopan<br>
<b>Sent:</b> Tuesday, October 30, 2012 1:53 PM<br>
<b>To:</b> <a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank">freeswitch-users@lists.freeswitch.org</a><br>
<b>Subject:</b> [Freeswitch-users] SQL ERR while running freeswitch<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal">Hi all,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I have been facing issues while running freeswitch and I am facing with the below errors and I have installed the latest version of git. I have configured /etc/odbc.ini with the username and password.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">012-10-29 16:53:22.108686 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_registrations]<u></u><u></u></p>
<p class="MsoNormal">[delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='<a href="http://squay-laptop-1.squay.com" target="_blank">squay-laptop-1.squay.com</a>' and network_ip like '%' and network_port like '%' and sip_username like
'%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%']<u></u><u></u></p>
<p class="MsoNormal">Auto Generating Table!<u></u><u></u></p>
<p class="MsoNormal">2012-10-29 16:53:22.108761 [DEBUG] switch_core_sqldb.c:979 SQL ERR [no such table: sip_registrations]<u></u><u></u></p>
<p class="MsoNormal">[drop table sip_registrations]<u></u><u></u></p>
<p class="MsoNormal">2012-10-29 16:53:22.111151 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_subscriptions]<u></u><u></u></p>
<p class="MsoNormal">[delete from sip_subscriptions where hostname='<a href="http://squay-laptop-1.squay.com" target="_blank">squay-laptop-1.squay.com</a>' and full_to='XXX']<u></u><u></u></p>
<p class="MsoNormal">Auto Generating Table!<u></u><u></u></p>
<p class="MsoNormal">2012-10-29 16:53:22.111246 [DEBUG] sofia.c:2413 Creating agent for internal<u></u><u></u></p>
<p class="MsoNormal">2012-10-29 16:53:22.111424 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_subscriptions]<u></u><u></u></p>
<p class="MsoNormal">[delete from sip_subscriptions where hostname='<a href="http://squay-laptop-1.squay.com" target="_blank">squay-laptop-1.squay.com</a>' and full_to='XXX']<u></u><u></u></p>
<p class="MsoNormal">Auto Generating Table!<u></u><u></u></p>
<p class="MsoNormal">2012-10-29 16:53:22.111485 [DEBUG] switch_core_sqldb.c:979 SQL ERR [no such table: sip_subscriptions]<u></u><u></u></p>
<p class="MsoNormal">[DROP TABLE sip_subscriptions]<u></u><u></u></p>
<p class="MsoNormal">2012-10-29 16:53:22.112236 [DEBUG] switch_core_sqldb.c:972 SQL ERR [no such table: sip_registrations]<u></u><u></u></p>
<p class="MsoNormal">[delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='<a href="http://squay-laptop-1.squay.com" target="_blank">squay-laptop-1.squay.com</a>' and network_ip like '%' and network_port like '%' and sip_username like
'%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%']<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Please do guide me on this. Many thanks.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Regards,<u></u><u></u></p>
<p class="MsoNormal">Archana<span style="font-size:10.0pt"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div></div></div>
</div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Anthony Minessale II<br><br>FreeSWITCH <a href="http://www.freeswitch.org/">http://www.freeswitch.org/</a><br>ClueCon <a href="http://www.cluecon.com/">http://www.cluecon.com/</a><br>
Twitter: <a href="http://twitter.com/FreeSWITCH_wire">http://twitter.com/FreeSWITCH_wire</a><br><br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net">irc.freenode.net</a> #freeswitch<br><br>FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br><a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>
pstn:+19193869900<br>
</div>