<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Several questions inline - no answers<br>
<br>
Edwin Blommaerts wrote:
<blockquote
cite="mid:80794E7C46A6A3419A97F7E803739A1C855D2E00D4@SERVER1.JFS.local"
type="cite">
<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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
-->
</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hello everyone,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US">I have some questions
regarding implementing asterisk and my-sql. I’m no expert at asterisk
but I’m going to list up my questions and hopefully someone will be
able to help.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">-The people that setup our
server made asterisk write the sound files onto the hard drive, and
then somewhat later store these files into my-sql. Is this the proper
way to do it? Or would it make more sense to just have my-sql store the
path to the file? Or is it possible to store the data directly into
my-sql from asterisk? So in general what is the best way to make this
happen? Has anyone implemented something similar?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">-They also claim that for
performance and other issues no queries should be done on the main
asterisk my-sql database, but instead we should setup replication
between two my-sql databases and queries should be run on the slave. Is
this needed and why is this needed, because my-sql prefers insert above
read actions I don’t really see why? Our current server now shows
segmentation errors at boot and they claim that this is due to queries
on the database. I’ve also checked the query it returns the data to us
in less then 3 seconds, so I’m doubting this can be the trouble.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
</blockquote>
How large is the PBX ?<br>
How many users, phones, technology of phones, etc<br>
Hardware platform for Asterisk - CPU memory,etc<br>
<blockquote
cite="mid:80794E7C46A6A3419A97F7E803739A1C855D2E00D4@SERVER1.JFS.local"
type="cite">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">-Sometimes the phone lines
hang waiting, people can’t call out because asterisk seems to be
holding on to these lines for a certain amount of time. What could be
the cause of this?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
</blockquote>
phone "lines" POTS analog? SIP trunks? IAX trunks? <br>
POTS analog may not be communicating to Asterisk, or asterisk may not
be listening for any hangup signal, if it exists. What does the PSTN
provider supply?<br>
<blockquote
cite="mid:80794E7C46A6A3419A97F7E803739A1C855D2E00D4@SERVER1.JFS.local"
type="cite">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">-What is the best hardware
architecture for asterisk implementation? My-sql and asterisk on
separate servers, or doesn’t it really matter?
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
</div>
</blockquote>
Size of installation and amount of data handled with MySQL?<br>
<blockquote
cite="mid:80794E7C46A6A3419A97F7E803739A1C855D2E00D4@SERVER1.JFS.local"
type="cite">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">I really hope to get some
advice, because, I’ve began to doubt/question the people who set the
server up. I’m happy with any information, good references that you can
give me.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thanks a lot in advance<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">EB<o:p></o:p></span></p>
</div>
<br>
</blockquote>
John Novack<br>
<pre class="moz-signature" cols="10000">--
Dog is my Co-pilot</pre>
</body>
</html>