Displaying 20 results from an estimated 50000 matches similar to: "Realtime dbase table mods"
2004 Dec 14
2
Asterisk Realtime IAX - Adding fields for database table
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)
2006 Jun 09
0
Need to react to row additions in dbase table
Hello,
I need my rails app to react to row additions on table in the dbase. Is
there an elegant way to handle this in rails? Essentially I am treating
the table as a sort of queue from which I pull items and process, one at
a time.
Thanks,
Doug
--
Posted via http://www.ruby-forum.com/.
2006 Jul 18
2
Scaffold a Plural table w/ No Pluralization in environment
Hi guys,
I have a situation here. I have my project set to no pluralization due
to legacy tables in environment.rb. Now, I have some new tables which
I''m starting to pluralize. When I do a generate a scaffold to this new
table:
script/generate scaffold my_tables table
it seems to work out fine for certain sections like
http://mysite.com/railsapp/new (which also inserts properly to
2004 Dec 12
3
Problems getting Asterisk Realtime to work
I have installed the CVS Head as of 12/12/04, as well
as the asterisk-addons to ensure that
/usr/lib/asterisk/modules/res_config_mysql.so exists.
I have configured the following (after building a new
DB with the appropriate SQL examples, with mods to
drop the invalid keys, on the Wiki):
- /etc/asterisk/res_mysql.conf
[general]
dbhost = 127.0.0.1
dbname = my_db
dbuser = my_uname
dbpass =
2007 Jan 15
0
Asterisk Realtime and MD5 authentication
Hi,
I've troubles with setting up Asterisk Realtime and MD5 authentication.
With clear text passwords everything is working fine.
-- Registered SIP 'edwin' at 10.0.0.37 port 5060 expires 600
-- Saved useragent "Cisco-CP7940G/8.0" for peer edwin
[2007-01-15 10:18:12] DEBUG[28528]: res_config_mysql.c:651 mysql_reconnect:
MySQL RealTime: Everything is fine.
2010 Apr 17
1
Realtime changes not reflected realtime
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Helvetica, Arial, sans-serif">Hello list,<br>
<br>
Using Asterisk 1.4.25.1<br>
Using realtime sip_buddies<br>
<br>
I notice
2011 Sep 09
0
Re: Visual Fox Pro 9 with dBase tables
If you want an excellent POS system (http://www.retailexpress.com.au/) on the cheap, you should try Retail Express. The offering of Retail Express doesn't require expensive hardware because of its cloud-based nature.
2009 Mar 02
2
Asterisk realtime
Hi all,
I'm using asterisk in real time mode...All extensions are defined in table
sip_buddies...Everything looks fine and asterisk is reading extensions info
from the sip_buddies table...The problem occurs as soon as any information
on an extension is changed from sip_buddies table...Which mean, if I change
the secret field in sip_buddies table then i should reload asterisk to read
again the
2011 May 12
2
Realtime - ara180
Hi all,
A week or so down the list, i read that not many people were using
realtime on an Asterisk18, so i had this afternoon a go at it...
[sorry for the inconveneant line-wraps]
First i did:
mysql> create database asterisk;
mysql> grant all on asterisk.* to 'voipadmin'@'localhost' identified by
next i used the info from the wiki:
CREATE TABLE `sip_devices` (
`id`
2011 Jun 09
3
Visual Fox Pro 9 with dBase tables
Hi everyone. I have a though one here.
In a friend's company they use n accounting and POS software which was designed by someone that passed away. The problem is that he doesn't have much money right now, thus can't license windows and MSoffice in his office.
I offered him the possibility of using Linux (Mint or Ubuntu) and having him run the software on Wine.
This is the software
2007 Nov 20
0
iaxpeers from Realtime
Hello asterisk users, here is a little problem pulling out iax peers from
real time database
I have the following peer configured in my database
mysql> select
name,username,secret,type,context,host,disallow,allow,defaultip,deny,permit,
ipaddr,port from iax_users where name='iaxtermination';
+----------------+----------+----------------------------------+------+-----
2006 Nov 02
0
Static Realtime Select from Database
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
2006 May 23
3
ez-where headscratch
Hi there,
I''m puzzled by this apparently simple query I can''t manage to reassemble
using ez_where plugin.
cond = Caboose::EZ::Condition.new :my_table do
start_on < Time.now
any {end_on > Time.now; end_on.nil?}
end
I keep getting the following result :
>> cond.to_sql
=> ["my_table.start_on < ? AND (my_table.end_on > ?)", Tue May 23
2009 Oct 01
1
Help me replace a for loop with an "apply" function
...if that is possible
My task is to find the longest streak of continuous days a user participated
in a game.
Instead of writing an sql function, I chose to use the R's rle function, to
get the longest streaks and then update my db table with the results.
The (attached) dataframe is something like this:
day user_id
2008/11/01 2001
2008/11/01 2002
2008/11/01 2003
2007 Dec 28
1
sip.conf & realtime
Hi -
I'm looking into realtime and I'm having a bit of a problem with the SIP
part.
My review of the posts seems to indicate that I should use realtime static
for the [general] part of my sip.conf including the registration commands:
register=><did>:<secret>@<domain>/<did context>
and use realtime realtime (funny name!) for peers and friends:
[myprovider]
2008 Nov 12
1
What are the minimum realtime fields for sipusers?
I'm trying to get sipusers working with a realtime odbc database on
Asterisk 1.6. We have sippeers working from the database, but need
sipusers to be in a separate table for other implementation reasons.
sip show user test load returns results from the database.
CLI> sip show user test load
* Name : test
Secret : <Set>
MD5Secret : <Not set>
2011 May 18
1
asterisk18 - realtime/mysql - take 3
Still a couple of questions......
I did configure extconfig.conf
...
;iaxusers => odbc,asterisk
;iaxpeers => odbc,asterisk
;sipusers => odbc,asterisk
sipusers => mysql,asterisk,sip_devices
sippeers => mysql,asterisk,sip_devices
;sippeers => odbc,asterisk
;sipregs => odbc,asterisk
;voicemail => odbc,asterisk
;extensions => odbc,asterisk
;meetme => mysql,general
2007 Dec 29
1
Realtime & sip.conf
Hi -
I'm looking into realtime and I'm having a bit of a problem with the SIP part.
My review of the posts seems to indicate that I should use realtime
static for the [general] part of my sip.conf including the
registration commands:
register=><did>:<secret>@<domain>/<did context>
and use realtime realtime (funny name!) for peers and friends:
[myprovider]
2013 Apr 09
0
realtime peer w/ callbackextension does not register after 'sip reload'
Hello everybody,
I am having a problem with realtime SIP peers.
On Asterisk 1.8, I had SIP peers for external SIP providers configured in database and additional register lines in sip.conf so they would register.
Now I upgraded to Asterisk 11.3.0, partly because of the promised callbackextension feature for realtime peers (https://reviewboard.asterisk.org/r/1717/). Removed the 'register'
2011 Mar 02
1
Asterisk 1.8 SIP realtime and NAT
Hi
After recently upgrading to 1.8.3 I have noticed that the nat setting
for my peer in my sip table is not making it into the realtime cache.
For example
* Name : 501
Realtime peer: Yes, cached
Secret : <Set>
MD5Secret : <Not set>
Remote Secret: <Not set>
Context : pack-local
Subscr.Cont. : <Not set>
Language :
AMA flags :