Encryption by db realtime

Hi Everyone,

I tried to load the extension configuration(extensions.conf) from mysql, but there is not the encrytion option in the configuration table of mysql. In a word when I enable the realtime, I can not set the “encryption = yes”, How can I do it? Any idear? Thanks in advanced.

PS. in the directory /usr/src/asterisk-1.8.18.1/contrib/realtime/mysql
sippeers.sql

CREATE TABLE IF NOT EXISTS sippeers (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(10) NOT NULL,
ipaddr varchar(15) DEFAULT NULL,
port int(5) DEFAULT NULL,
regseconds int(11) DEFAULT NULL,
defaultuser varchar(10) DEFAULT NULL,
fullcontact varchar(35) DEFAULT NULL,
regserver varchar(20) DEFAULT NULL,
useragent varchar(20) DEFAULT NULL,
lastms int(11) DEFAULT NULL,
host varchar(40) DEFAULT NULL,
type enum(‘friend’,‘user’,‘peer’) DEFAULT NULL,
context varchar(40) DEFAULT NULL,
permit varchar(40) DEFAULT NULL,
deny varchar(40) DEFAULT NULL,
secret varchar(40) DEFAULT NULL,
md5secret varchar(40) DEFAULT NULL,
remotesecret varchar(40) DEFAULT NULL,
transport enum(‘udp’,‘tcp’,‘udp,tcp’,‘tcp,udp’) DEFAULT NULL,
dtmfmode enum(‘rfc2833’,‘info’,‘shortinfo’,‘inband’,‘auto’) DEFAULT NULL,
directmedia enum(‘yes’,‘no’,‘nonat’,‘update’) DEFAULT NULL,
nat enum(‘yes’,‘no’,‘never’,‘route’) DEFAULT NULL,
callgroup varchar(40) DEFAULT NULL,
pickupgroup varchar(40) DEFAULT NULL,
language varchar(40) DEFAULT NULL,
allow varchar(40) DEFAULT NULL,
disallow varchar(40) DEFAULT NULL,
insecure varchar(40) DEFAULT NULL,
trustrpid enum(‘yes’,‘no’) DEFAULT NULL,
progressinband enum(‘yes’,‘no’,‘never’) DEFAULT NULL,
promiscredir enum(‘yes’,‘no’) DEFAULT NULL,
useclientcode enum(‘yes’,‘no’) DEFAULT NULL,
accountcode varchar(40) DEFAULT NULL,
setvar varchar(40) DEFAULT NULL,
callerid varchar(40) DEFAULT NULL,
amaflags varchar(40) DEFAULT NULL,
callcounter enum(‘yes’,‘no’) DEFAULT NULL,
busylevel int(11) DEFAULT NULL,
allowoverlap enum(‘yes’,‘no’) DEFAULT NULL,
allowsubscribe enum(‘yes’,‘no’) DEFAULT NULL,
videosupport enum(‘yes’,‘no’) DEFAULT NULL,
maxcallbitrate int(11) DEFAULT NULL,
rfc2833compensate enum(‘yes’,‘no’) DEFAULT NULL,
mailbox varchar(40) DEFAULT NULL,
session-timers enum(‘accept’,‘refuse’,‘originate’) DEFAULT NULL,
session-expires int(11) DEFAULT NULL,
session-minse int(11) DEFAULT NULL,
session-refresher enum(‘uac’,‘uas’) DEFAULT NULL,
t38pt_usertpsource varchar(40) DEFAULT NULL,
regexten varchar(40) DEFAULT NULL,
fromdomain varchar(40) DEFAULT NULL,
fromuser varchar(40) DEFAULT NULL,
qualify varchar(40) DEFAULT NULL,
defaultip varchar(40) DEFAULT NULL,
rtptimeout int(11) DEFAULT NULL,
rtpholdtimeout int(11) DEFAULT NULL,
sendrpid enum(‘yes’,‘no’) DEFAULT NULL,
outboundproxy varchar(40) DEFAULT NULL,
callbackextension varchar(40) DEFAULT NULL,
timert1 int(11) DEFAULT NULL,
timerb int(11) DEFAULT NULL,
qualifyfreq int(11) DEFAULT NULL,
constantssrc enum(‘yes’,‘no’) DEFAULT NULL,
contactpermit varchar(40) DEFAULT NULL,
contactdeny varchar(40) DEFAULT NULL,
usereqphone enum(‘yes’,‘no’) DEFAULT NULL,
textsupport enum(‘yes’,‘no’) DEFAULT NULL,
faxdetect enum(‘yes’,‘no’) DEFAULT NULL,
buggymwi enum(‘yes’,‘no’) DEFAULT NULL,
auth varchar(40) DEFAULT NULL,
fullname varchar(40) DEFAULT NULL,
trunkname varchar(40) DEFAULT NULL,
cid_number varchar(40) DEFAULT NULL,
callingpres enum(‘allowed_not_screened’,‘allowed_passed_screen’,‘allowed_failed_screen’,‘allowed’,‘prohib_not_screened’,‘prohib_passed_screen’,‘prohib_failed_screen’,‘prohib’) DEFAULT NULL,
mohinterpret varchar(40) DEFAULT NULL,
mohsuggest varchar(40) DEFAULT NULL,
parkinglot varchar(40) DEFAULT NULL,
hasvoicemail enum(‘yes’,‘no’) DEFAULT NULL,
subscribemwi enum(‘yes’,‘no’) DEFAULT NULL,
vmexten varchar(40) DEFAULT NULL,
autoframing enum(‘yes’,‘no’) DEFAULT NULL,
rtpkeepalive int(11) DEFAULT NULL,
call-limit int(11) DEFAULT NULL,
g726nonstandard enum(‘yes’,‘no’) DEFAULT NULL,
ignoresdpversion enum(‘yes’,‘no’) DEFAULT NULL,
allowtransfer enum(‘yes’,‘no’) DEFAULT NULL,
dynamic enum(‘yes’,‘no’) DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY name (name),
KEY ipaddr (ipaddr,port),
KEY host (host,port)
) ENGINE=MyISAM;

There isnot “encryption”, if I add it by hand, it can not take effect.

Regards.
Hugo