search for: voicemail_us

...sions.conf and that works fine, So I though I'd go back and test a static configuration mapping. I used the table structure from the asterisk guru postgres howto to create something similar in MySQL (shown below) and included the following in extconfig; voicemail.conf => mysql,asterisk,voicemail_users The result is that app_voicemail fails to load and it appears from the debug that it is not happy with the table structure... however the names it has for the fields seem strange (to me that is :)) If anyone has gone through the process of creating the correct tables in MySQL and doesn'...

Hi, I was wondering if anyone has had a problem adding the 'delete' field to the voicemail_users table. I have no problems adding other fields e.g. alter table voicemail_users add column hidefromdir varchar(3) NOT NULL default 'no'; However when I do alter table voicemail_users add column delete varchar(3) NOT NULL default 'no'; I get a message telling me that I hav...

...call attempts to db through ODBC using the same DSN. unixODBC and the mysql drivers are installed from source. Here are the relevant parts of the config: Extconfig.conf (Under the [settings] section) sipusers => odbc,voip,sip_users sippeers => odbc,voip,sip_users voicemail => odbc,voip,voicemail_users extensions => odbc,voip,extensions_table res_odbc.conf [asterisk] dsn => MySQL-asterisk username => voip password => temp123 pre-connect => yes Under extensions.conf, in the [from-sip] context: switch => Realtime/from-sip@extensions. Running isql MySQL-asterisk voip <pa...

...to drop the invalid keys, on the Wiki): - /etc/asterisk/res_mysql.conf [general] dbhost = 127.0.0.1 dbname = my_db dbuser = my_uname dbpass = my_secret dbport = 3306 dbsock = /tmp/mysql.sock - /etc/asterisk/extconfig.conf ; Extconfig.conf for realtime configuration voicemail => mysql,my_db,voicemail_users (Just want to try something simple such as voicemail for the initial testing.) I have removed the [default] section from my voicemail.conf. When I try to access voicemail after restarting Asterisk, no voicemail config is found. Anyone have any luck? --------------------- I notice I get this e...

Hi, Realtime SIP and Extensions are working fine but facing some problems with Voicemail. Added an entry to extconfig.conf voicemail => mysql,asterisk,voicemail_users Created the corresponding table and an entry for mailbox 201. This is also reflected in the CLI as shown below. CLI> realtime load voicemail mailbox 201 Column Name Column Value -------------------- -------------------- uniqueid 1...

I''m having problems in a controller i am writing. i get this exception: wrong number of arguments (1 for 0) ## this does not work: @voicemail_user = VoicemailUser.find(session[:asterisk][:user_id]) if (@voicemail_user.password == params[:pwd][:current]) @voicemail_user.update_attributes({"password" => params[:pwd][:newpwd2]}) end ## but this works: @voicemail_user = VoicemailUser.find(session[:asterisk][:us...

...EAD for asterisk, and for asterisk-addons. MySQL seems to be loading correctly (the cdr table is recording incoming calls). But the RealTime Voicemail doesn't seem to be checking the database table for the voicemail users. When trying to login to voicemailMain if I use a user in the database voicemail_users the user is not found/doesn't exist. If I log in with a user in the voicemail.conf file it works correctly. Any suggestions? Thanks, Michael extconfig.conf: [settings] ;uncomment to load queues.conf via the db engine. ;queues.conf => odbc voicemail => mysql,tenant_new, voicemail_u...

...ig file for '999alijawad' -- Executing [999alijawad at a2billing:2] Hangup("SIP/alijawad-08aaf0f0", "") in new stack == Spawn extension (a2billing, 999alijawad, 2) exited non-zero on 'SIP/alijawad-08aaf0f0' Even though I do have 999alijawad as a mailbox in voicemail_users If I do setup the mailbox in voicemail.conf it works fine. [a2billing] 999alijawad => 123456, alijawad, alijawad1 at gmail.com I did setup extconfig.conf as it should be: voicemail => mysql,mya2billing,voicemail_users Please advice -------------- next part -------------- An HTML attach...

...'<sip:testsip at 192.168.1.150;transport=UDP>' failed for '192.168.1.105' - No matching peer found The CLI shows : [Feb 22 19:58:23] == Parsing '/etc/asterisk/extconfig.conf': [Feb 22 19:58:23] Found [Feb 22 19:58:23] == Binding voicemail to mysql/AsteriskHosted/voicemail_users [Feb 22 19:58:23] == Binding sipusers to mysql/AsteriskHosted/sip_buddies [Feb 22 19:58:23] == Binding sippeers to mysql/AsteriskHosted/sip_buddies I have the following in extconfig.conf : sipusers => mysql,Asterisk,sip_buddies sippeers => mysql,Asterisk,sip_buddies I have the follo...

.../contrib/realtime/postgresql/realtime.sql:CREATE TABLE extensions_conf ( asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE cdr ( asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE sip_conf ( asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE voicemail_users ( asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE queue_table ( asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE queue_member_table asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE "queue_log" ( Any help is appreciated. -...

...> /etc/asterisk/res_mysql.conf (or whereever your conf dir is). > > Edit the res_mysql.conf to your liking. > > Now edit /etc/asterisk/extconfig.conf. Down at the bottom is the RealTime > config stuff. If you want voicemail, add this line: > > voicemail => mysql,asterisk,voicemail_users > > This basically says "Please use the RealTime MySQL driver, the database > asterisk and the table voicemail_users and bind that to the voicemail > family". You can change to your liking: > > voicemail => <driver>,<databasename>,<tablename> >...

...to drop the invalid keys, on the Wiki): - /etc/asterisk/res_mysql.conf [general] dbhost = 127.0.0.1 dbname = my_db dbuser = my_uname dbpass = my_secret dbport = 3306 dbsock = /tmp/mysql.sock - /etc/asterisk/extconfig.conf ; Extconfig.conf for realtime configuration voicemail => mysql,my_db,voicemail_users (Just want to try something simple such as voicemail for the initial testing.) I have removed the [default] section from my voicemail.conf. When I try to access voicemail after restarting Asterisk, no voicemail config is found. Anyone have any luck? --------------------- I notice I get this e...

...he sip, extension working, but voicemail seems still looking for config file, not from the database. the extconfig.conf looks like ... sipusers => mysql,asterisk,sip_buddies sippeers => mysql,asterisk,sip_buddies extensions => mysql,asterisk,extensions_table voicemail => mysql,asterisk,voicemail_users .. the table looks like mysql> select * from voicemail_users; +----------+-------------+---------+---------+----------+----------+-------- ---------------+------+ | uniqueid | customer_id | context | mailbox | password | fullname | email | page | +----------+-------------+---------+---------...

...the part that actually sets up the mailboxes. If you already have mailboxes in /etc/asterisk/voicemail.conf you'll have to load them into the table defined in etc/asterisk/extconfig.conf. That entry look like this: voicemail => mysql,asterisk,voicemail_users documented here: http://www.voip-info.org/wiki/view/Asterisk+RealTime+Voicemail so... a complete voicemail entry is either two lines in /etc/asterisk/extconfig.conf like so: voicemail.conf => mysql,asterisk,ast_config voicemail => mysql,asterisk,voicemail_users...

hi all, I can not get voicemail working in realtime with asterisk-1.2.6. extconfig.conf is correct voicemail => odbc,asterisk,voicemail_users i am getting the fallowing error Executing Answer("SIP/xx.xx.xx.xxx-0a02e1c0", "") in new stack -- Executing Set("SIP/xx.xx.xxx-0a02e1c0", "foo=102") in new stack -- Executing NoOp("SIP/xx.xx.xx.xxx-0a02e1c0", "102") in new sta...

...pped to the database: == Parsing '/etc/asterisk/asterisk.conf': == Found == Parsing '/etc/asterisk/extconfig.conf': == Found == Binding extensions.conf to mysql/general/ast_config == Binding agents.conf to mysql/general/ast_config == Binding voicemail to mysql/general/voicemail_users == Binding sipusers to mysql/general/sip_buddies == Binding sippeers to mysql/general/sip_buddies == Binding iaxusers to mysql/general/iax_buddies == Binding iaxpeers to mysql/general/iax_buddies == Binding meetme to mysql/general/meetme == Binding queues to mysql/general/queue_table...

Hello, I'm having a problem when trying to create realtime stuff for asterisk 13 in mysql DB. Following https://wiki.asterisk.org/wiki/display/AST/Managing+Realtime+Databases+with+Alembic, I've successfully created the main tables using "config" schema. > Update |script_location|to the schema to update. Asterisk currently > supports two sets of schemas: > > 1.

...been playing with trying to get voicemail.conf from DB, I am using cvs-head, but when I start asterisk, it dies a horrible death, because it cant load any voicemil setting. I looked at my mysql logs to see what query was being sent, and I get SELECT category, var_name, var_val, cat_metric FROM voicemail_users WHERE filename='voicemail.conf' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id; which is in no way related to the table I created following the example on the wiki. Is there another table format , I have +-------------+----------...

...r extensions. Any thoughts? Dialplan exten => _5[14-9]XXX,1,Answer() exten => _5[14-9]XXX,n,Playtones(ring) exten => _5[14-9]XXX,n,MYSQL(Connect CONNID localhost asterisk HG06e6kghpUjtGvnX asterisk) exten => _5[14-9]XXX,n,MYSQL(Query RESULTID ${CONNID} Select 'fullname' from voicemail_users Where mailbox=${EXTEN}) exten => _5[14-9]XXX,n,MYSQL(Fetch FETCHID ${RESULTID} FULLNAME) exten => _5[14-9]XXX,n,MYSQL(Disconnect ${CONNID}) exten => _5[14-9]XXX,n,GotoIf($[${FETCHID} = 1]?connect:disconn) exten => _5[14-9]XXX,n(connect),StopPlaytones() exten => _5[14-9]XXX,n,W...

Hi all, we use OpenSER together with Asterisk. All SIP users registers with OpenSER and asterisk is doing the voicemail thing. We use the Asterisk RealtimeArchitecture for voicemail users and SIP peers. The database table for the sip peers is a view from the OpenSER subscriber table. The MWI for a user will only work, if the user object (sip peer) is loaded into memory and visible with the CLI