similar to: realtime - unable to find key

Hi all, From the web, I can find a table scheme of sipusers for ARA using. However, I can't find any meaning of each field, especially for the field regserver which is new in the table. Can any tell me more detail about the usage of each field? CREATE TABLE `sip_buddies` ( `id` int(11) NOT NULL auto_increment, `name` varchar(80) NOT NULL default '', `host` varchar(31) NOT NULL

So this is what i've done so far... my extconfig.conf looks like this [settings] ;example => odbc,asterisk,alttable ;iaxusers => odbc,asterisk ;iaxpeers => odbc,asterisk sipusers => mysql,voip,sip sippeers => mysql,voip,sip voicemail => mysql,voip,voicemail extensions => mysql,voip,extensions -------------------- and my extensions.conf has the following lines in it.

Guys, I'm having a hellava time getting realtime to work, focused on sipusers right now, followed the wiki and other examples but still no luck. Using mysql on a seperate server, asterisk actually sees the database and can poll the table "realtime load sipusers" at the cli but asterisk realtime engine is no pulling the user info. I'm using 1.2.4 stable and have the database

Hi all! So far I've always used plaintext passwords for SIP, but now I've decided to use MD5 encryption. For each client I edited its section as follows, then: auth=md5 md5secret=hashed_passwd ;secret=plaintext_passwd where hashed_passwd is the output of echo -n "user:realm:plaintext_passwd" | md5sum When the first SIP clients registers with Asterisk after a "sip

Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk softphones. I followed the steps of "how to" of voip-org but always have this error: Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime:

Hi, I've troubles with setting up Asterisk Realtime and MD5 authentication. With clear text passwords everything is working fine. -- Registered SIP 'edwin' at 10.0.0.37 port 5060 expires 600 -- Saved useragent "Cisco-CP7940G/8.0" for peer edwin [2007-01-15 10:18:12] DEBUG[28528]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine.

Hi list! I'd like to save all information about calls (CDR) in a MySQL-Database. I created the DB and a user for Asterisk on a separate server, then I configured my cdr_mysql.conf so: [global] hostname=192.168.10.3 dbname=asterisk table=cdr password=MYSECRET user=asterisk port=3306 and my cdr.conf so: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no

-----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of jg Sent: Monday, July 06, 2015 4:14 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR in an MySQL-Database > Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database.

I'm having a few issues with the MySQL realtime configuration in CVS-HEAD. I tested it initially with realtime extensions (realtime_ext => mysql,asterisk,extensions) and a realtime switch in extensions.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

On Sat, 25 Apr 2015 17:11:34 +0200 jg <webaccounts173 at jgoettgens.de> wrote: > > > Hi All > > > > I have dozens of these messages on CLI complaining about database > > connection and error writing CDR to disk. > > > > The curious thing is I can find them all inside the database. > > I "selected" them using uniqueid and manually

Hi, I am using Realtime for sip configuration. When there is an INVITE which arrives at asterisk asterisk makes the following selects: Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine. [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE name = 'tzl' [Nov

It seems that when setting qualify = 200 or qualify = yes in the database for a sip friend/peer, RealTime does not update the registration status like it should. I also have several peers which have been offline and Asterisk still reports them as registered, even though the registration seconds are only 200. Asterisk Ver: CVS HEAD 12/1/2004 Layout of sip_buddies: mysql> describe

Hello, I am trying to play with RODBC library and Excel Files. In my file (doubs.xls) there are 2 spreadsheets: > library(RODBC) > connection<-odbcConnect("Excel Files") > sqlTables(connection) TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 F:\\Th?se\\R\\Doubs NA Faune$ SYSTEM TABLE NA 2 F:\\Th?se\\R\\Doubs NA Milieu$

So I'm noticing from the docs/ on Asterisk Addons 1.4.10 that the database structure for cdr_mysql is: CREATE TABLE cdr ( calldate datetime NOT NULL default '0000-00-00 00:00:00', clid varchar(80) NOT NULL default '', src varchar(80) NOT NULL default '', dst varchar(80) NOT NULL default '', dcontext varchar(80) NOT NULL default '', channel

Hi, i want to run a standalone-samba-PDC with a mysql-passdb backend and i configured the mysql-database as required. but how should i add/remove users ? when i try smbpasswd -a username most columns in database have [NULL] values i also tried pdbedit but it exits with "No user SID retrieved from database!" is there another tool to add/remove users ? is my smb.conf ok, or do i need to

Hello, I wish to use asterisk as a voicemail server with ser . I want to use asterisk external configuration toHello, I wish to use asterisk as a voicemail server with ser . I want to use asterisk external configuration to manage users and storing voicemail messages according to ser database. Where can i find the schema of the SQL DB for voicemail accounts . for example in extconfig ;

For the information of others (and Google) this is the table structure I used to get cdr_mysql working: CREATE TABLE cdr ( calldate varchar(255) NOT NULL default '', clid varchar(255) NOT NULL default '', src varchar(255) NOT NULL default '', dst varchar(255) NOT NULL default '', dcontext varchar(255) NOT NULL default '', channel varchar(255)

I'm having trouble with the Realtime setup. I've followed the instructions on voip-info using odbc but I get this message during asterisk boot: Parsing '/etc/asterisk/sip.conf': Not found (No such file or directory) Dec 14 16:11:37 NOTICE[8868]: chan_sip.c:8462 reload_config: Unable to load config sip.conf, SIP disabled == Registered channel type 'SIP' (Session

I''m new at this so please be patient. I have a very simple schema consisting of a around 10 tables in Postgresql. The aim is to provide a system for PC administrators to keep track of PC''s dotted around various venues (shops, libraries etc.). The sort of info I want to store is PC specs, PC network specs, PC ownership specs, PC location specs and contact person details. So I end

Hi, I am having issues with a one to many relationship(it never works :-)). Jokes aside, I am getting an error: Mysql::Error: #23000Cannot add or update a child row: a foreign key constraint fails: INSERT INTO adverts (`image_url`, `price`, `title`, `website_url`, `description`, `user_id`) VALUES(''bb'', 22.0, ''aa'',