search for: varchar

...--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------+------+-----+---------+----------------+ | uniqueid | int(11) | | PRI | NULL | auto_increment | | name | varchar(30) | | UNI | | | | accountcode | varchar(30) | YES | | NULL | | | amaflags | char(1) | YES | | NULL | | | callgroup | varchar(30) | YES | | NULL | | | callerid | varchar...

...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 default '', `nat` varchar(5) NOT NULL default 'no', `type` enum('user','peer','friend') NOT NULL default 'friend', `accountcode` varchar(20) default NULL, `amaflags` varchar(13) default...

ok so my table looks like this... REATE TABLE `sip` ( `id` int(11) NOT NULL auto_increment, `name` varchar(80) NOT NULL default '', `accountcode` varchar(20) default NULL, `amaflags` varchar(7) default NULL, `callgroup` varchar(10) default NULL, `callerid` varchar(80) default NULL, `canreinvite` char(3) default 'yes', `context` varchar(80) default NULL, `defaultip` varchar(15) def...

...1 2 2 0 0 0 0 1 0 0 0 0 0 0 0 5 0 2 3 2 0 0 0 0 5 2 0 0 2 4 4 0 0 2 0 3 0 0 0 5 0 0 0 and it works fine.... (2) I have another problem to save a data frame in my xls file and for this case i do not have any alternatives: > sqlSave(connection,fau01,verbose=T) [1] "CREATE TABLE fau01 (a varchar(255) ,b varchar(255) ,c varchar(255) ,d varchar(255) ,e varchar(255) ,f varchar(255) ,g varchar(255) ,h varchar(255) ,i varchar(255) ,j varchar(255) ,k varchar(255) ,l varchar(255) ,m varchar(255) ,n varchar(255) ,o varchar(255) ,p varchar(255) ,q varchar(255) ,r varchar(255)...

Hi, ? I am trying to store queues.conf to a MySQL database using dynamic realtime. I have a working ODBC connection and the queueing system already works but I want to store the queues.conf file to a database. I am following the guide from Asterisk the definitive guide, the ebook can be found at: http://ofps.oreilly.com/titles/9781449332426/asterisk-DB.html ? I have a database called asterisk

...---------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+-------------------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(80) | | UNI | | | | accountcode | varchar(20) | YES | | NULL | | | amaflags | varchar(13) | YES | | NULL | | | callgroup | varchar(10) | YES | | NULL...

Hello, Right now there is not a table build script at: http://www.voip-info.org/wiki-Asterisk+RealTime+IAX Therefore I have taken the SIP build script and added a few fields that I use from my iax.conf (could be more out there, please see the complete build script below): `dbsecret` varchar(100) default '', `notransfer` varchar(100) default '', `inkeys` varchar(100) default '', `auth` varchar(100) default '', `qualify` varchar(4) default NULL, While most of IAX peers are working for inbound/outbound, Voicepulse is not (requires the 'qualify...

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

maybe a dumb question but what do we have here??? sip-friends.sql # # Table structure for table `sipfriends` # CREATE TABLE `sipfriends` ( `name` varchar(40) NOT NULL default '', `secret` varchar(40) NOT NULL default '', `context` varchar(40) NOT NULL default '', `username` varchar(40) default '', `ipaddr` varchar(20) NOT NULL default '', `port` int(6) NOT NULL default '0', `regsecond...

...sk,iax_buddies sipusers => mysql,asterisk,sip_buddies sippeers => mysql,asterisk,sip_buddies res_mysql.conf as: [general] dbhost = localhost dbname = asterisk dbuser = root dbpass = asterisk dbport = 3306 dbsock = /var/lib/mysql/mysql.sock My table as: CREATE TABLE iax_buddies ( name varchar(30) primary key NOT NULL, username varchar(30), type varchar(6) NOT NULL, secret varchar(50), callerid varchar(100), context varchar(100), host varchar(31) NOT NULL default 'dynamic', disallow varchar(100), allow varchar(100) ); I'...

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 varchar(80) NOT NULL default '', dstchannel varchar(80) NOT NULL default '', lastapp varch...

...ently 1 char long, should be 3 chars for values (Null, no, yes) >>> pickupgroup Since callgroup was set to 30 I just set this value to 30 chars since the example shows the same number of characters. CREATE TABLE `sip_buddies` ( `uniqueid` int(11) NOT NULL auto_increment, `name` varchar(250) NOT NULL default '', `accountcode` varchar(30) default NULL, `amaflags` char(1) default NULL, `callgroup` varchar(30) default NULL, `callerid` varchar(50) default NULL, `canreinvite` char(3) default NULL, `context` varchar(250) default NULL, `defaultip` varchar(15)...

...ump of Database CREATE TABLE `user` ( `logon_time` int(9) default NULL, `logoff_time` int(9) default NULL, `kickoff_time` int(9) default NULL, `pass_last_set_time` int(9) default NULL, `pass_can_change_time` int(9) default NULL, `pass_must_change_time` int(9) default NULL, `username` varchar(255) default NULL, `domain` varchar(255) default NULL, `nt_username` varchar(255) default NULL, `nt_fullname` varchar(255) default NULL, `home_dir` varchar(255) default NULL, `dir_drive` varchar(4) default NULL, `logon_script` varchar(255) default NULL, `profile_path` varchar(255) def...

...ssages" table is as follows: +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | msgnum | int(11) | YES | | NULL | | | dir | varchar(80) | YES | MUL | NULL | | | context | varchar(80) | YES | | NULL | | | macrocontext | varchar(80) | YES | | NULL | | | callerid | varchar(40) | YES | | NULL | | | origtime | varchar(40) | YES | | NULL | | | duration...

...Asterisk+SIP+chan_sip2 ), so I think I should consider how to eliminate that warning. Do you have any idea about, please? Since I use Realtime+rtcachefriends, below there's the table structure and data. TIA, Alex CREATE TABLE `sip_buddies` ( `id` int(11) NOT NULL auto_increment, `name` varchar(80) NOT NULL default '', `accountcode` varchar(20) default NULL, `amaflags` varchar(7) default NULL, `auth` char(3) default NULL, `authuser` varchar(80) default NULL, `callgroup` varchar(10) default NULL, `callerid` varchar(80) default NULL, `canreinvite` char(3) default '...

...-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(30) | NO | UNI | | | | username | varchar(30) | YES | | NULL | | | type | varchar(6) | NO | | | | | secret | varchar(50) | YES | | NULL | | | md5secret | varchar(32) | YES...

...the fields seem strange (to me that is :)) If anyone has gone through the process of creating the correct tables in MySQL and doesn't mind sharing I would be most appreciative. Regards, Nathan. ####MySQL Table#### CREATE TABLE voicemail_users ( id int NOT NULL auto_increment, customer_id varchar(255) NOT NULL default '0', context varchar(255) NOT NULL default '', mailbox varchar(255) NOT NULL default '', password varchar(4) NOT NULL default '0', fullname varchar(50) NOT NULL default '', email varchar(50) NOT NULL default '', pager varchar(50)...

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) NOT NULL default '', dstchannel va...

...ilbox basis using Realtime voicemail. I was successful at getting maxmsg to work by adding a field to the realtime voicemail table when using Asterisk 1.2.4: CREATE TABLE `voicemail` ( `uniqueid` bigint NOT NULL auto_increment, `customer_id` bigint NOT NULL default '0', `context` varchar(50) NOT NULL default '', `mailbox` bigint NOT NULL default '0', `password` varchar(5) NOT NULL default '0', `fullname` varchar(150) NOT NULL default '', `email` varchar(50) NOT NULL default '', `pager` varchar(50) NOT NULL default '', `tz`...

...| Type | Null | Key | Default | Extra | +-------------------------+---------------+------+-----+---------------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | replica_family_uuid | varchar(100) | | | | | | created_by | varchar(100) | | | | | | created_on | datetime | | | 0000-00-00 00:00:00 | | | server_host | varchar(50) |...