Displaying 5 results from an estimated 5 matches for "rlike".
Did you mean:
like
2004 Dec 14
2
Re: Asterisk-Users Digest, Vol 5, Issue 192
...hank you for your response. I had tried that before and it didn't work. I
am trying to look up the route for a dialed number, so its a full E.164
number. Please see my query below when I try to look up the route for a USA
number;
mysql> SELECT * FROM routes WHERE "^13237309880" RLIKE pattern ORDER BY
LENGTH(pattern) DESC;
+---------+------------+---------+----------+-------------+-----------------+------+
| pattern | country | comment | trunks | connectcost | includedseconds
| cost |
+---------+------------+---------+----------+-------------+-----------------+------+
| 8...
2005 Mar 21
1
ASTCC: perl / mysql or me???
...BALANCE,1)
---
> # exten => _00XXXXXXXXX,1,DeadAGI(astcc.agi,${CALLERIDNUM},BALANCE,'',1)
273,274c273,276
I added one parameter ${TARIFF}
< my ($number) = @_;
< my $sth = $dbh->prepare("SELECT * FROM routes WHERE " .
$dbh->quote($number) . " RLIKE pattern ORDER BY LENGTH(pattern) DESC");
---
> my ($number, $tariff1) = @_;
> my $sth = $dbh->prepare("SELECT * FROM " . $tariff1 . " WHERE "
. $dbh->quote($number) . " RLIKE pattern ORDER BY LENGTH(pattern) DESC");
> print S...
2006 Apr 26
3
astcc: need partial pin code
I have not used astcc with pin codes so far, since I set-up the phone
number as card number.
Some of my users want now to dial in to the system and than use their
card, which is their phone number.
For that I would need a way of authentication, like a pin.
I want to use something like:
What is your card number: <user keys in the number>
Enter your pin: <user enter a long pin>
2004 Dec 17
6
Realtime and PostgreSQL
Has anyone had any luck with PostgreSQL and Realtime? The realtime
instructions on voip-info seem pretty straight forward... just not woking for
me. I've included all of my config files below, and my console output.
Entire console bootup output:
[root@abox asterisk]# /usr/sbin/asterisk -vvvvvvc
== Parsing '/etc/asterisk/asterisk.conf': Found
== Parsing
2006 Feb 22
2
mysql phone number pattern match query
Does anyone have a mysql query that will compare a number from the
asterisk cdr to a table of international country+city codes to determine
the closest match?
The two fields are;
1. Asterisk mysql cdr 'dst' field - sample record value
'011441316551212'
2. rate table data like this
DialPattern
011447977
011447979
011447980
011447981
011447984
011447985
011447986