Displaying 5 results from an estimated 5 matches for "row_format".
2007 Aug 09
1
usage of each field
...;',
`port` smallint(5) unsigned NOT NULL default '0',
`regserver` varchar(100) default NULL,
`regseconds` int(11) NOT NULL default '0',
`username` varchar(80) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `name_2` (`name`)
) TYPE=MyISAM ROW_FORMAT=DYNAMIC;
2005 Mar 24
1
realtime - unable to find key
...NULL,
`regseconds` int(11) NOT NULL default '0',
`ipaddr` varchar(15) NOT NULL default '',
`regexten` varchar(80) NOT NULL default '',
`cancallforward` char(3) default 'yes',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `name_2` (`name`)
) TYPE=MyISAM ROW_FORMAT=DYNAMIC;
and my extconfig.conf looks like this...
[settings]
sipusers => mysql,voip,sip
sippeers => mysql,voip,sip
voicemail => mysql,voip,voicemail
extensions => mysql,voip,extensions
and when my phone tries to register i get
Mar 24 21:26:32 DEBUG[28397]: res_config_mysql.c:117...
2014 Nov 07
0
Virtual alias with dovecot
...uery = SELECT deliver_to FROM dovecot_aliases WHERE alias='%s'
where the table structure is:
CREATE TABLE `dovecot_aliases` (
`id` int(11) NOT NULL,
`alias` varchar(255) NOT NULL,
`deliver_to` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
Records are, considering that the main address is a at a.com:
Insert into dovecot_alias values (1,'b at a.com','a at a.com');
Should be postfix that should had send this to the main address right? What
could be wrong?
SQL Logs for this, show's that dovecot...
2006 Mar 02
1
Sip Realtime Configs Samples with MySQL
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
2005 Jun 04
2
chan_sip + MD5 encryption: WARNING Format for authentication entry is user[:secret]@realm
...T NULL default '0',
`ipaddr` varchar(15) NOT NULL default '',
`regexten` varchar(80) NOT NULL default '',
`cancallforward` char(3) default 'yes',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `name_2` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
INSERT INTO `sip_buddies` VALUES (1, '304', NULL, NULL, 'md5', '304', '1',
'Alessandro <304>', 'no', 'sip-in', NULL, 'rfc2833', NULL, NULL, 'dynamic',
NULL, NULL, NULL, 'fd56e4ddc29bd8c1f85ac4a12f4f3ece'...