irclog2html for #asterisk-doc on 20061128

05:30.27*** join/#asterisk-doc jsmith_ (n=jsmith@64-151-42-78.dyn.everestkc.net)
05:33.01*** mode/#asterisk-doc [+o jsmith] by ChanServ
06:41.19*** join/#asterisk-doc khris (n=nnnnkris@mrtg.sisgroup.com.au)
13:59.39*** join/#asterisk-doc alerios (n=alerios@69.79.145.100)
14:13.19*** join/#asterisk-doc jsmith (n=jsmith@199.227.185.35)
14:13.19*** mode/#asterisk-doc [+o jsmith] by ChanServ
14:30.19*** join/#asterisk-doc trelane_ (n=trelane@unaffiliated/trelane)
14:34.08trelane_any thoughts on how we can better deal with the "I just installed asterisk, started it and got a CLI*> prompt, now what do I do? users?
14:36.05jsmithYeah... teach them about the dialplan
14:36.18jsmithTake chapters 4 and 5 from the book, expand them out into about 5 chapters ;-)
14:36.28jsmithWith lots of examples that'll keep them happy
15:24.25trelane_agreed\
15:29.08jsmithDid you get my email last week?
15:31.10trelane_yes
15:32.02trelane_now I need to do something with it!
15:33.42*** join/#asterisk-doc blitzrage (n=blitzrag@asterisk/documenteur-extraordinaire/blitzrage)
15:33.42*** mode/#asterisk-doc [+o blitzrage] by ChanServ
15:33.46blitzragemorning all!
15:34.04blitzrageI posted this to #asterisk as well.... but here's an open question
15:34.13blitzrageI currently keep my CDRs in a database via ODBC. I want to link a CDR record number to another place in the database for recording calls so I can say, "this call has CDR record XXX.X" so the call stats and such with the CDRs are associated with the call recording file. Any thoughts on how I might get this?
15:35.09trelane_yeah hang on a sec?
15:35.14blitzrageof course
15:37.34trelane_you're going to end up storing a variable in hte CDR and using the same variable for the filename
15:37.49trelane_without breaking the cdr structure you could use the userfield or accountcode field
15:38.52trelane_you could really cheat if you're using something like areski's asterisk-stat, and format it as a url and embed it in the html for the page
15:39.51trelane_so that the recording of the call would be downloadable (assuming it's web-accessable) via the CDR
15:40.59blitzragetrelane_: oh thats a great idea! I get the field value back from the DB when I insert the recording, so I could create a new CDR field called 'recording' or something, then just save the value there when I record something...
15:41.09trelane_no!
15:41.12blitzragenever thought about it going the other way...
15:41.26trelane_use user field if possible because it's a spare field set aside by design for such things
15:41.27blitzragewhy not?
15:41.36trelane_which means that third party cdr stuff will support it
15:41.36blitzrageoh ok.. I could do that :)
15:41.42trelane_indeed!
15:42.13trelane_things like astbilling and asterisk-stat will still be able to deal with your CDRs
15:42.34blitzrageyah -- we're creating a custom solution, so no third party stuff
15:42.39trelane_generally, cheat anyone and go to any length to avoid having to change around the cdr
15:42.41trelane_ok
15:42.52blitzragetrelane_: ok, will look into that. Thanks!
15:49.27trelane_projects sometimes outrun their lifespan
15:49.57trelane_well the software which was a private hackup got reprovisioned as a tool used by $BOSS
15:50.05trelane_(fortunate this wasn't me)
15:50.31jsmithblitzrage: We seriously need to do some CDR work during Geek Week.
15:51.00blitzragejsmith: very much agreed!
15:51.22blitzragetrelane_: haha, nice :)
15:51.39blitzragejsmith: and see if we can get Steve to make us a DUNDi-multi() function :)
15:52.06trelane_CDR appears so billing oriented... it could do a lot more for PBX style systems where I want to know who fucked up the transfer, not where it was transferred to
15:55.34jsmithThat's what AMA flags are for ;-)
15:55.43jsmithTo show which CDR records are for billing, and which are for documentation only
15:57.02trelane_my point is I want better documentation
15:57.24jsmithAh, the point of this channel, you mean.
15:58.59trelane_no in the cdr itself!
15:59.14trelane_ok fine it went to extension 100, who transferred it there?
16:29.48blitzragehrmmm.... I can't seem to setup a FK relationship for some reason... wonder if the cdr table doesn't like the FK to be a SERIAL....
16:30.00blitzragesorry... the referenced column being SERIAL
16:30.43jsmithShouldn't matter...
16:30.52jsmithMost foreign keys are serials
16:31.31blitzrageyah... I know it shouldn't... but it still gives me an error
16:31.38blitzrageKey (userfield)=() is not present in table
16:36.09blitzragejsmith-teaching: when you get back from teaching, would you mind taking a crack at trying to setup this FK? I don't get what it doesn't like.
17:53.05*** join/#asterisk-doc ToTo (n=ToTo@host97-157-dynamic.2-87-r.retail.telecomitalia.it)
17:57.15jsmith-lunchblitzrage: What's the error?
17:58.44blitzrageKey (userfield)=() is not present in table
17:58.56jsmith-lunchOK, show me the two tables
17:58.57jsmith-lunch\d table1
17:58.59jsmith-lunch\d table2
17:59.16jsmith-lunchand then show me your foreign key definition
18:04.06blitzragehttp://pastebin.ca/260778
18:05.17blitzragecan't really show you the FK def. because I'm using pgAdmin3
18:05.52blitzrageGUI says: (userfield) REFERENCES ast_monitor (id)
18:06.03blitzragewhen in the cdr table
18:06.43blitzrageoh there it goes
18:06.46blitzrageALTER TABLE cdr ADD CONSTRAINT ast_monitor_id_fk FOREIGN KEY (userfield) REFERENCES ast_monitor (id)    ON UPDATE CASCADE ON DELETE SET NULL;
18:11.28jsmith-lunchOK
18:11.30jsmith-lunchThat looks good.
18:12.20jsmith-lunchOh, the space between ast_monitor and (id) might be the problem.
18:13.01jsmith-lunchBut that's only a guess.
18:13.06jsmith-lunchCan I log into this machine?
18:14.39blitzragesure, it's tampa4
18:14.54blitzrageand the space was put there by pgadmin3
18:15.24blitzragejsmith-lunch: need me to reset your pass on that machine?
18:20.29jsmith-lunchprobably
18:20.29jsmith-lunchHold please...
18:20.29blitzragek
18:22.12jsmith-lunchYes, please reset it to something...
18:22.30blitzragek -- it'll be the usual sokol pass
18:22.44jsmith-lunchEasy 'nuff
18:22.45blitzragedone
18:22.59jsmith-lunchjsmith?
18:23.11blitzrageyep, that's the user
18:24.56jsmith-lunchOk, one second
18:25.02blitzragenp
18:26.24jsmith-lunchDoesn't work.
18:26.48blitzrageI just logged in with it...
18:27.10blitzragetampa4 right?
18:27.13jsmith-lunchYes.
18:27.23blitzragewhen the star goes upon high?
18:27.31jsmith-lunchI feel my blood pressure rising, right?
18:27.33jsmith-lunch;-)
18:27.35blitzrage:D
18:27.55blitzragewith altered i's ?
18:28.02jsmith-lunchYup... typo
18:28.03jsmith-lunchI'm in.
18:28.07blitzragea gotcha
18:28.41jsmith-lunchpgsql isn't running on tampa4
18:28.47blitzragesure it is
18:28.55blitzrageits in /usr/local/pgsql (binaries)
18:29.23blitzragepostgres is the running bin
18:29.30jsmith-lunchWhat, no RPM?
18:29.36blitzragenope, was compiled
18:29.52blitzrage(I didn't set it up :))
18:30.04blitzrageprobably because its RH9 and the RPM is pgsql 6.0 or something
18:33.37jsmith-lunchWhich database?
18:33.53blitzrageasterisk
18:34.09jsmith-lunchI should have guessed
18:34.25blitzrageheh
18:35.10jsmith-lunchOh, duh!
18:35.13jsmith-lunchI'm an idiot
18:35.51jsmith-lunchIt's saying you can't add the foreign key contraint, because there's at least one line in the cdr table that has a blank userfield, so it can't be linked to the ast_monitor table
18:35.59blitzrageahhhhhh!
18:36.10blitzragethey are all blank in the cdr table
18:36.17blitzragebecause I haven't used that column yet
18:39.16blitzrageOT: have you tried the applicationmap in features.conf lately (in 1.2.x)? I can't seem to get it to do anything :)
18:39.21blitzragethinking I'm going to file a bug
18:40.28jsmith-lunchNope.
18:40.31jsmith-lunchI haven't.
18:49.54*** join/#asterisk-doc ToTo (n=ToTo@host97-157-dynamic.2-87-r.retail.telecomitalia.it)
18:51.12blitzragejsmith-lunch: so I have to have at least one field populated with a value before I can make that FK ?
19:36.11blitzragehrmmm... read-only CDR variables are annoying.  Now I have to modify my dialplan :)
19:42.59*** join/#asterisk-doc alerios (n=alerios@69.79.145.100)
20:08.58jsmithblitzrage: Yes -- not only do they have to have a value, they have to have a value that's in the foreign table ;-)
20:10.12blitzrageshoot... because not every entry is going to have a value... only the records where a recording was made
20:10.53jsmithThat's fine... you just need to make your contraint so that NULLs are allowed
20:11.43blitzragein which column?
20:12.09blitzrageuserfield is already allowed to be NULL
20:12.23blitzrageand 'id' can not (or never will be) null because its serial
20:12.23jsmithWhen you build your foreign key constraint, I'm almost positive there's a way to say "NULLs are allowed, but if it's not null, it has to be a foreign key"
20:12.34jsmithbrb, and then I'll look for it.
20:12.40blitzrageahhhh ok... maybe pgadmin3 isn't that clever
20:39.40blitzrageback shortly -- grocery run on my bike while its still reasonably light out
20:39.53blitzrageshoot! temperature just dropped a degree. Better get my butt in gear
21:06.49jsmithblitzrage: When you get back -- I'm not able to dial a number through Louie -- you wanna check it out?
21:06.51jsmith3123050540
21:51.28blitzragejsmith: sure thing
21:51.34blitzragejsmith: sorry it took so long
21:51.44blitzragegirl at the counter was rediculously slow checking people through
22:04.31jsmithNo problem
22:04.42jsmithEntire 312 area code seems to be having problems
22:05.03blitzrageoh nice... probably a routing issue on the SS
22:05.17blitzragelet me login to tampa2 and have a look
22:05.26blitzragegot a number I can call with an IVR or something?
22:50.46*** join/#asterisk-doc alerios (n=alerios@69.79.145.100)

Generated by irclog2html.pl by Jeff Waugh - find it at freshmeat.net! Modified by Tim Riker to work with blootbot logs, split per channel, etc.