search for: var_val

...revision 1.158 diff -u -p -r1.158 session.c --- session.c 7 Dec 2001 17:26:49 -0000 1.158 +++ session.c 18 Dec 2001 19:07:14 -0000 @@ -918,25 +918,29 @@ void do_pam_environment(char ***env, u_i #ifdef HAVE_CYGWIN void copy_environment(char ***env, u_int *envsize) { - char *equals, var_name[512], var_val[512]; + char *var_name = NULL, *var_val; + size_t size = 0, i_size; int i; for(i = 0; environ[i] != NULL; i++) { - if ((equals = strstr(environ[i], "=")) == NULL) + if ((i_size = strlen(environ[i]) + 1) < 3) continue; - if (strlen(environ[i]) < (sizeof(var_name) - 1))...

...9; > , filename varchar(128) not null default '' > , category varchar(128) not null default > 'default' > , var_name varchar(128) not null default '' > , var_val varchar(128) not null default '' > , primary key (id) > ) > ; > > -- defaults > set @CAT_METRIC = 0; > set @FILENAME = 'musiconhold.conf...

I swear I read somewhere on one of the MANY pages that there is a script out there that can read the extensions.conf file and create the MySQL DB records on the fly. Anyone know where I look for such a thing? Sure speeds up migration! Chris Coulthurst chris@shuksan.com

...`) ); ####### ####res_mysql.conf#### [general] dbhost = localhost dbname = asterisk dbuser = asterisk dbpass = ******** dbport = 3306 dbsock = /var/run/mysqld/mysqld.sock #### ####Debug Log#### Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Static SQL: 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 Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Everything is fine. Aug 11 01:16:23 DEBUG[1028] res_config_...

Thank you... but "just update the database" - hmm, what database? Did you mean ARI? I still can't find the command! The asterisk wiki is somewhat, um... spread around! On Sat, 13 Jun 2020 at 16:56, Steve Edwards <asterisk.org at sedwards.com> wrote: > > On Sat, 13 Jun 2020, Jonathan H wrote: > > > I need to ensure that a MusicOnHold stream is only running when

...ot null default '0' , filename varchar(128) not null default '' , category varchar(128) not null default 'default' , var_name varchar(128) not null default '' , var_val varchar(128) not null default '' , primary key (id) ) ; -- defaults set @CAT_METRIC = 0; set @FILENAME = 'musiconhold.conf'; set @VAR_METRIC...

Hi iam using 1.2.17 does any one have information meetme in realtime and store in mysql i dont see any document could some one help me is this possible ? ram -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070606/36d236c2/attachment.htm

Here is what happens on startup: Sep 15 13:23:51 DEBUG[28130] res_config_mysql.c: MySQL RealTime: Static SQL: SELECT category, var_name, var_val, cat_metric FROM settings WHERE filename='voicemail.conf' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id Sep 15 13:23:51 DEBUG[28130] res_config_mysql.c: MySQL RealTime: Everything is fine. Sep 15 13:23:51 DEBUG[28130] res_config_mysql.c:...

...                 , filename              varchar(128) not null default '' >                  , category              varchar(128) not null default 'default' >                  , var_name              varchar(128) not null default '' >                  , var_val               varchar(128) not null default '' >                  , primary key           (id) >                  ) >                  ; > > -- defaults >          set @CAT_METRIC                 = 0; >          set @FILENAME                   =...

On Mon, Aug 11, 2014 at 3:29 AM, Deepak Rawat <deepaksingh.rawat at gmail.com> wrote: > Hi, > > I modified the query in res/res_config_odbc.c. > Original: "SELECT MAX(LENGTH(var_val)) FROM %s WHERE filename='%s'" > Modified: "SELECT MAX(LEN(var_val)) FROM %s WHERE filename='%s'" > > I rebuilt the code and installed Asterisk again. Now static realtime is > working. Should I file a bug report? > > > On Mon, Aug 11, 2014 at 2:37...

I did an ngrep trace of what Asterisk realtime static does when it queries the database. Here's what I saw SELECT category, var_name, var_val, cat_metric FROM rt_pbx1_sip_vw WHERE filename='sip.conf' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id; Firstly, why does it order in DESCENDING order by cat_metric? Shouldn't it be ASCENDING order? The docs imply that you use cat_...

...es (likely -simplifycfg) will cleanup the code properly and doing this in LoopUnswtich pass is duplicated. However, consider the following case: define i32 @test(i32* %var, i1 %cond1, i1 %cond2) { br label %loop_begin loop_begin: br i1 %cond1, label %continue, label %loop_exit continue: %var_val = load i32, i32* %var br i1 %cond2, label %do_something, label %loop_exit do_something: call void @some_func() noreturn nounwind br label %loop_begin loop_exit: ret i32 0 } Assume you don't have enough budget to do non-trivial loop unswtich (for test purpose, set -loop-unswitch-thr...

Hi I have 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 h...

...ODBC driver for Linux and Windows Driver=/usr/local/lib/psqlodbc.so Setup=/usr/lib/odbc/libodbcpsqlS.so Debug = 1 CommLog = 1 root@pbx:# echo "select * from ast_config where filename='iax.conf' and commented=0 order by filename,cat_metric desc,var_metric asc,category,var_name,var_val,id" | isql Asterisk <lot of output from table> SQLRowCount returns 39 39 rows fetched So the odbc thingy works! root@pbx:# cat res_config_odbc.conf [settings] table = ast_config connection = myconn root@pbx:# cat res_odbc.conf [myconn] dsn=Asterisk username=XXXXX p...

...ig - The following is the table in the database: mysql> select * from bit_ast_config; +----+------------+-------------+----------------+-----------------------+-----------+---------------+----------+ | id | cat_metric | var_metric | commented | filename | category | var_name | var_val | +----+------------+-------------+----------------+-----------------------+-----------+---------------+----------+ | 2 | 0 | 0 | 0 | musiconhold.conf | yaron | directory | moh | | 3 | 0 | 0 | 0...

...have MySQL all setup and am filling it with my data. Everything seems very straight forward. One thing catches me so far: 1) How are register lines in sip.conf and iax.conf represented? i.e. register=> username:password@fwd.pulver.com/700 insert into ast_config (filename,category,var_name,var_val) values('sip.conf','register','username:password','fwd.pulver.com/700); Is that a good guess? 2) Ditto extensions.conf and other files that make more use of the => format. Thanks! -- Kristian Kielhofner

...or deny how I think the schema works. cat_metric = sort order for category var_metric = sort order for vars filename = equivalent .conf file in /etc/asterisk category = anything that would be enclosed in braces ([]) var_name = variable/command/directive such as an extension, global variable, etc.. var_val = value for var_name Also, I'm assuming the metric starts at 1 for each category? Chris

...efault '0', `var_metric` int(11) NOT NULL default '0', `commented` int(11) NOT NULL default '0', `filename` varchar(128) NOT NULL default '', `category` varchar(128) NOT NULL default 'default', `var_name` varchar(128) NOT NULL default '', `var_val` varchar(128) NOT NULL default '', PRIMARY KEY (`id`), KEY `filename_comment` (`filename`,`commented`) ) TYPE=MyISAM; Thanks, Tielin

...pieces of info together I've come with the following : I want to have my "register =>" statements in a MySQL-database, so I've made the following table. table ast_config : id 1 cat_metric 0 var_metric 0 commented 0 filename sip.conf category general var_name register var_val username:password at sip.provider.net In ext_config (text file) I have : sipusers => mysql,AsteriskDB,sip_buddies sippeers => mysql,AsteriskDB,sip_buddies sip.conf => mysql,AsteriskDB,ast_config In sip.conf (text file) I have also : sip.conf : rtcachefriends=yes ; Cache r...

...t(11) NOT NULL auto_increment, `cat_metric` int(11) NOT NULL default '0', `var_metric` int(11) NOT NULL default '0', `commented` int(11) NOT NULL default '0', `filename` varchar(128) NOT NULL, `category` varchar(128) NOT NULL, `var_name` varchar(128) NOT NULL, `var_val` varchar(200) NOT NULL, PRIMARY KEY (`id`), KEY `filename_comment` (`filename`,`commented`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; What changed since 1.6.1.X to break realtime static? I do not see any errors on startup, the dialplan simply does not load. Since we hav...