Is an error like this normal when doing the db install?
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'VIEW usr_preferences_view AS SELECT id, username,
domain, attribute, type AS att' at line 1
By the way, while ruby on rails might be a great development platform,
it's a right pain in the behind to install.
Hi Users......
A doubt For me in Codec....
I'm Using openSER and RTPProxy
openser didn't take the Media tranmmision , it transmmit to RTPproxy or
mediaproxy.
Media(voice) taking place in RTP proxy...
UA1 using the G729 codec -------> openser server -------------------> UA2
using G711u
for above case it will not generate the porper handshanking............
But RTP Proxy may has transmiits the media , because it has codecs in
( media proxy or rtpproxy)
For a realtime producttion, UAs may having the differnet codecs.
plz resolve my doubt.....
--
Thanks and Regards with cheers
Sunkara Ravi Prakash (Voip Developer)
Hyperion Technology
www.hyperion-tech.com
+91-9985077535
Hi all,
I'm trying to install CDRTool
(http://www.ag-projects.com/CDRTool.html) and some
errors happened.
When I try to access the CDRTool webpage, I'm able log
in the page, but when I try to enter in the "call
search page" some warnings appears:
"Warning: main(SOAP/Client.php): failed to open
stream: Arquivo ou diretório não encontrado in
/var/www/CDRTool/rating_lib.phtml on line 4"
"Fatal error: main(): Failed opening required
'SOAP/Client.php'
(include_path='.:/opt/lampp/lib/php') in
/var/www/CDRTool/rating_lib.phtml on line 4"
In the file "rating_lib.phtml", the line 4 is:
"require_once("SOAP/Client.php");"
The file Client.php does not exist... But a file named
"client.php" exists..and into it, theres an
instruction calling "Client.php":
"include("SOAP/Client.php");"
An additional information is that I'm using the XAMPP
Server Apache.
Please, Can you help me?
Thanks in advance!
Alberto
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Hi
iam integrating with asterisk voice mail with Openser
when we are creating openser views with asterisk
the secret going to be Binary(0);, how can i change to numeric ?
why i need is, take example
If the user Phone logged in and the user have person voicemessage box
he only can access his voice messages, when he dial secret
If not any one can come and access voice message by dialing access number.
with the config seen in the examples, person can dial *98 and hear all the
messages
and delete too.
so for the security reason, how can i change the secret, iam trying to
alter the table, but its say;s in view mode.
any suggestions.
Ra,
Hi list,
I was exploring the example configuration file in the following URL:
http://voip-info.org/wiki/view/OpenSER+And+RTPProxy
The following block bewilders me:
% failure_route[1] {
% if (isflagset(6) || isflagset(5)) {
% unforce_rtp_proxy();
% }
% }
How a flag happens to be turned on there ? 6 is the registrar's nat_flag
but no lookup() is performed. Furthermore, the tm module doesn't even
depend on the registrar module. Flag 5 is set in route[2] which is
obviously not called from failure_route[1]. Is there some black magic
around here ?
Thank you.
Regards,
--
Jeremie Le Hen
< jeremie at le-hen dot org >< ttz at chchile dot org >
Hi list,
I was wondering whether I could use multiple rtpproxy daemons along one
OpenSER instance, in order to both provide a failover mechanism as well
as load-balacing.
Google immediately pointed me out the following thread:
http://www.openser.org/pipermail/users/2005-October/001071.html
It happens that openser/modules/nathelper/nathelper.c contains the
following comment:
% 2005-02-24 Added support for using more than one rtp proxy, in which
% case traffic will be distributed evenly among them. In addition,
% each such proxy can be assigned a weight, which will specify
% which share of the traffic should be placed to this particular
% proxy.
%
% Introduce failover mechanism, so that if SER detects that one
% of many proxies is no longer available it temporarily decreases
% its weight to 0, so that no traffic will be assigned to it.
% Such "disabled" proxies are periodically checked to see if they
% are back to normal in which case respective weight is restored
% resulting in traffic being sent to that proxy again.
%
% Those features can be enabled by specifying more than one "URI"
% in the rtpproxy_sock parameter, optionally followed by the weight,
% which if absent is assumed to be 1, for example:
%
% rtpproxy_sock="unix:/foo/bar=4 udp:1.2.3.4:3456=3 udp:5.6.7.8:5432=1"
At first glance, I would say the aforementioned comment states that
nathelper achieves both failover and weighted load-balancing. Can anyone
confirm this ?
Ultimately, I would like to do use the following arch :
________+----------+
/________| RTPProxy |
+---------+ // +----------+
| OpenSER |_____//
+---------+ /\_________+----------+
/ \ ______| RTPProxy |
+---------+ / \/ +----------+
| OpenSER |__/_____/\
+---------+ \ \_____+----------+
\____________| RTPProxy |
+----------+
If I understand correctly how it works, this should be possible to use N
OpenSER instances along with M RTProxy instances. Am I right ?
Thank you.
Best regards,
--
Jeremie Le Hen
< jeremie at le-hen dot org >< ttz at chchile dot org >
Hello,
I'm new to this server, and I ask for help! I don't undertand for now
how to configure openSER.
Can someone send me simple configuration file "openser.cfg" wich
included:
-- accounting loggoing to a specific file ( like "/home/agb/acc.log")
-- authentication from simple text file (if possible), or using SQL
-- routing numbers started with 00 to specific gateway with ip
(123.123.123.123)
Another question is: how to enable debugs of this server?
Please reply ASAP and best regards,
Vladimir Orehov
SIA Velkoms
Support engineer
Hi list,
I was exploring the example configuration file in the following URL:
http://voip-info.org/wiki/view/OpenSER+And+RTPProxy
The following block bewilders me:
% failure_route[1] {
% if (isflagset(6) || isflagset(5)) {
% unforce_rtp_proxy();
% }
% }
How a flag happens to be turned on there ? 6 is the registrar's nat_flag
but no lookup() is performed. Furthermore, the tm module doesn't even
depend on the registrar module. Flag 5 is set in route[2] which is
obviously not called from failure_route[1]. Is there some black magic
around here ?
Thank you.
Regards,
--
Jeremie Le Hen
< jeremie at le-hen dot org >< ttz at chchile dot org >
Dear all,
First of all, I would like to say thanks to all of you for your help and suggestion to solve my problem untill now. Thank you very much.
Now, I try to install serweb_2004-07-27 in my openser server. I have read the installation note that I got from the serweb packet carefully.
So, I can build the serweb in my openser server successfully. It means that it can display a login screen in the browser.
But, I have a problem when I try to login by using username "admin" with password "openserrw". (This is based on the installation note that I have read before)
I got error message. This is the error message :
Database error: Invalid SQL: select username, perms from subscriber where phplib_id = '721153ca8942ea1a08900f5b61b69a6c'
MySQL Error: 1054 (Unknown column 'perms' in 'field list')
Session halted.
As I try to understand from the error message, it says that there is no "perms" column. So I try to check it in the subscriber table in mysql.But, I did not find "perms" column in the subscriber table.
I just see these columns in the subscriber table:
-phplib_id -last_name - sendnotification - rpid
-username - phone - greeting -domn
-domain - email_address - ha1 -uuid
-password - datetime_created - hdb1
-first_name - datetime_modified - allow_find
-confirmation - flag - timezone
What should i do to solve this problem? What should I do if there is no "perms" column in the subscriber table?
I do hope anybody can give me a suggestion because this is my first time to build the serweb and mysql. Please help me....Please...
Note: I user openser1.1.0-tls and serweb_2004-07-27
As I see from the error message that the phplib_id is exactly matched with phplib_id where username "admin" with password "openserrw" (from the subscriber table).
Thank you very much
Regards,
Ferianto
---------------------------------
Get your email and more, right on the new Yahoo.com
Hi all
I have VoIP CDrouter running
But i have seen lot of limitation
How can i migrate from SER to Open Ser
with out lossing any data of users information and CDR
Help will be appriciated
Ram