irclog2html for #asterisk-doc on 20061205

03:17.49*** join/#asterisk-doc alerios (n=alerios@190.24.97.151)
13:38.54*** join/#asterisk-doc jsmith (n=jsmith@000-170-333.area3.spcsdns.net)
13:38.54*** mode/#asterisk-doc [+o jsmith] by ChanServ
14:42.15*** join/#asterisk-doc blitzrage (n=blitzrag@asterisk/documenteur-extraordinaire/blitzrage)
14:42.15*** mode/#asterisk-doc [+o blitzrage] by ChanServ
18:00.54blitzragejsmith-lunch: fyi -- I couldn't make that lo type as it gave me an error
18:06.46*** join/#asterisk-doc Alric (n=nbowyer@avantacom.com)
18:21.25AlricGone for one day and the whole world falls apart.
18:32.08blitzrageheh
18:37.20AlricSo I get this call today that an extension no longer works.
18:37.47AlricI check extensions.conf.  It says the extension points to a phone hanging off a zap card.  I ponder for a minute, then go... "the heck."  We removed that zap card over a year ago...
18:38.54Alricand they're like "it just stopped working the other day..."
18:42.36*** join/#asterisk-doc jsmith-lunch (n=jsmith@000-170-333.area3.spcsdns.net)
18:42.36*** mode/#asterisk-doc [+o jsmith-lunch] by ChanServ
18:44.49blitzrageAlric: hahaha
18:58.31*** join/#asterisk-doc ToTo (n=ToTo@host108-163-dynamic.2-87-r.retail.telecomitalia.it)
19:07.18AlricGrrr.
19:07.23AlricHate it when my customers bypass me for phones.
19:09.28AlricMissed an order for 27 phones, one Polycom IP4000, some Linksys ATAs...  Thats a significant amount of cashola!
19:22.48blitzrageaye
19:29.53*** join/#asterisk-doc alerios (n=alerios@190.24.97.151)
19:53.19*** part/#asterisk-doc alerios (n=alerios@190.24.97.151)
20:34.19jsmithblitzrage: You couldn't create it, huh?
20:34.37blitzragejsmith: nah... you get a weird error on anything post-7.3
20:34.48blitzrageI looked around on google, but found no solutions
20:35.01jsmithOK, maybe I'll check it out
20:35.17blitzragek cool, let me know what you find out
20:35.58jsmithWill do
20:36.11blitzrageexcellent
20:37.23jsmithFirst thought, I must fight an epic battle with JavaScript
20:39.09blitzrageoooo, good luck with that
20:40.32AlricEpic, hmm.
20:40.43jsmithI slayed three dragons and two wildebeasts yesterday... so the battle is almost won!
20:40.53AlricBah!  Generator test!
20:41.23AlricIsn't it slew for past tense? :P
20:41.36Alricslay, slaying, slew? :)
20:41.56jsmithNo, it's "I slayed a slough (pronounced "slew") of dragons..."
20:42.14jsmithWoo hoo!
20:42.20jsmithMake that three rhymes in a row!
20:42.27AlricI think the epic battle with javascript has made jsmith go batty.
20:47.20blitzragejavascript will do that to you
20:47.46blitzragedamn VM is really confusing me as to how to handle it in the cluster...
20:48.36blitzrageODBC storage seems ideal as it decentralized, but I can't read my VMs back out of PGsql, and I don't want to use MySQL
20:49.07blitzrageI guess unless I use MySQL JUST for VM.... but then I have to run two separate DB servers... at least until I can convince somoene to fix ODBC VM storage in pgsql
20:55.13jsmithblitzrage: There was a bug fixed in the last 24 hours re: getting VM back out of certain ODBC databases
20:55.53blitzragejsmith: I know... I tested, still have a bug
20:55.53jsmithblitzrage: Apparently if we try to pull it out and encounter a problem, we pull it out in smaller chunks
20:55.53blitzrageI want to know what field type that guy was using actually...
20:56.26blitzrageI'm using bytea... but maybe he was using something else
21:02.03jsmithSeems Omar was using bytea, but changed SQL_BINARY to SQL_LONGBINARY in the code
21:02.21jsmithSee bugs 6061,6337,6343
21:06.14blitzragebrb
21:07.31jsmithblitzrage: Let me know when you're back!
21:08.31jsmithAh, I'll just paste it in here, and you can try it when you get back
21:08.34jsmith<PROTECTED>
21:08.34jsmithCREATE FUNCTION loout (lo) RETURNS cstring AS 'oidout' LANGUAGE internal IMMUTABLE STRICT;
21:08.35jsmithCREATE FUNCTION lorecv (internal) RETURNS lo AS 'oidrecv' LANGUAGE internal IMMUTABLE STRICT;
21:08.35jsmithCREATE FUNCTION losend (lo) RETURNS bytea AS 'oidrecv' LANGUAGE internal IMMUTABLE STRICT;
21:08.35jsmithCREATE TYPE lo ( INPUT = loin, OUTPUT = loout, RECEIVE = lorecv, SEND = losend, INTERNALLENGTH = 4, PASSEDBYVALUE );
21:08.36jsmithCREATE CAST (lo AS oid) WITHOUT FUNCTION AS IMPLICIT;
21:08.38jsmithCREATE CAST (oid AS lo) WITHOUT FUNCTION AS IMPLICIT;
21:08.47jsmithFrom http://groups.google.com/group/pgsql.interfaces.odbc/browse_thread/thread/9e3743d26fba3c11/3b1bc708b8f59377%233b1bc708b8f59377
21:12.55jsmithThat may work, but I don't see why bytea doesn't work
21:13.01blitzragehrmmm....
21:13.13blitzragehttp://bugs.digium.com/view.php?id=8513
21:14.18jsmithMan, if we could only see what SQL was being passed back and forth...
21:14.26jsmithTry turning on logging at the ODBC layer, maybe?
21:15.43blitzragecan I do that?
21:16.11blitzrageI have full asterisk debug on and it shows me nothing... but if I can do it somewhere else I'd do it to find out
21:18.48blitzrageTraceFile       = /var/log/odbc.trace
21:18.48blitzrageTrace           = 1
21:18.48blitzrageDebugFile       = /var/log/odbc.debug
21:18.48blitzrageDebug           = 1
21:18.48blitzragemight do it... trying
21:21.42blitzrageok... getting no files...
21:24.44jsmithi think you have to compile the pgsql odbc driver with tracing to actually get them that way :-(
21:25.19blitzragedoh!
21:25.25blitzragesince I installed via RPM...
21:25.29blitzragemaybe there is a debug rpm....
21:26.31blitzragenoep
21:26.34blitzragenope even
21:27.20jsmithHmmmn... looking at the source RPM now
21:32.22blitzrageokie
21:45.49blitzrageany idea if the 7960 will "auto switch" its port if I plug the phone directly into a network card on a computer?
21:49.18jsmithNo clue... best guess is yese.
21:49.23jsmiths/yese/yes/
21:50.13jsmithblitzrage: On the PostgreSQL thing, try turning on logging in postgresql.conf
21:50.31jsmithlog_statement is what you want to turn on.
21:50.47jsmithThen, you'll have your queries logged in /var/lib/pgsql/data/pg_log/
21:51.01jsmithAnd then, we can maybe get to the bottom of why it's failing.
21:51.09jsmithIt's strange that the voicemail is getting in, but not getting back out.
21:54.49blitzragejsmith: ok, will do that now
22:03.41blitzragejsmith: just so you know I'm not using pgsql from RPM
22:03.46blitzragesince I'm using pgcluster
22:04.09jsmithOh.
22:04.09blitzrageso no idea where its being logged to :)
22:04.09blitzragemade the logging change in postgresql.conf though
22:04.18blitzragethere is no pg_log in the data/ dir
22:04.31jsmithOK, hold please...
22:05.48jsmithLook at the log_directory and log_filename settings is postgresql.conf
22:07.42blitzrageok found it
22:07.48blitzragegotta uncomment some more things I guess :)
22:09.15blitzrageoooo...pg_ctl also does reload... hallelujah!
22:26.25blitzrageok, off the phone with Infolink, now I can go back to testing this
22:27.50blitzragegrrrr... 1.4 still doesn't know how to reconnect to the DB if it goes down until I type "odbc show" at the CLI
22:29.01AlricYeah...
22:29.04blitzrageI've been doing a lot of the testing :)
22:29.08AlricIt does some other interesting things too if the HD fills :)
22:29.11Alric(Like stop working)
22:29.17blitzragewell duh :)
22:29.30AlricWell config from flat files didn't work that way :P
22:29.33blitzragenagios should be sending you an alert before it even gets full
22:29.54jsmithblitzrage: But what about the n00bs that don't put any type of system monitoring in place?!?
22:30.01blitzrage:D
22:30.11AlricHey!
22:30.14AlricI have monitoring in place!
22:30.37jsmithI didn't mean to imply that you didn't.
22:31.21AlricI need to get nagios installed though.
22:31.24AlricHobbit is flaking on me.
22:31.56jsmithBlame the orcs
22:32.19blitzrageLOG:  statement: SELECT * FROM voicemessages WHERE dir='/var/spool/asterisk/voicemail/lmentinc/100/INBOX' AND msgnum='0'
22:33.11blitzrageLOG:  statement: DELETE FROM voicemessages WHERE dir='/var/spool/asterisk/voicemail/lmentinc/100/Old' AND msgnum='4'
22:33.11blitzrageLOG:  statement:  
22:33.11blitzrageLOG:  statement: INSERT INTO voicemessages (dir, msgnum, context, macrocontext, callerid, origtime, duration, recording, mailboxuser, mailboxcontext) SELECT '/var/spool/asterisk/voicemail/lmentinc/100/Old','4',context,macrocontext,callerid,origtime,duration,recording,'100','lmentinc' FROM voicemessages WHERE dir='/var/spool/asterisk/voicemail/lmentinc/100/INBOX' AND msgnum='0'
22:33.25AlricYay! Got Office Installed!
22:33.29blitzrageLOG:  statement:  
22:33.29blitzrageLOG:  statement: SELECT COUNT(*) FROM voicemessages WHERE dir='/var/spool/asterisk/voicemail/lmentinc/100/INBOX' AND msgnum='1'
22:33.29blitzrageLOG:  statement: SELECT COUNT(*) FROM voicemessages WHERE dir='/var/spool/asterisk/voicemail/lmentinc/100/INBOX' AND msgnum='0'
22:33.30blitzrageLOG:  statement: DELETE FROM voicemessages WHERE dir='/var/spool/asterisk/voicemail/lmentinc/100/INBOX' AND msgnum='0'
22:33.31blitzrageLOG:  statement:  
22:34.05blitzragedoes a SELECT * from voicemessages, which seems fine.... no other errors after that
22:36.54AlricI do blame the orcs.
22:37.47blitzrageheh
22:38.04blitzrageok... to see what pgsql gives back when I run that SELECT statement...
22:39.25blitzragewow, its really cool being able to see the moon actually move in behind a building
22:40.05blitzrageif you can see the moon right now... its behind the BMO building in Toronto :)
22:42.34blitzrageok..... running the SELECT returns no errors....
22:43.05jsmithI can see the moon right now, and it's right over the hill where my house will be ;-)
22:43.06blitzragecool... we're looking in the same direction right now :)
22:43.22blitzragewell... almost... we're at different angles I'm sure
22:43.25jsmithRight, but our lines of sight aren't parallel
22:43.29blitzrageright :)
22:43.42blitzrageok..... so this postgresql log isn't giving me any new hints...
22:52.39jsmithAre you getting the binary data back for the VM?
22:52.49jsmithIn fact, is there binary data in there when you leave a VM?
22:54.01blitzragenot entirely sure how to check that....
23:04.20jsmithWell, if you leave a VM and then "SELECT * from voicemessages"
23:04.34jsmithIs there a big uber-long field with a bunch of junk in it?
23:04.35blitzrageyes, that's what I did in pgadmin
23:04.41blitzrageits a number
23:04.46blitzrage3 digits
23:04.53jsmithOh!
23:05.24blitzrageI was expecting to see something wierd myself
23:05.33jsmithInteresting... so it's storing the OID in this table, but putting the object itself into a large object table
23:05.35blitzragebut then I thought I read something that says its just a reference value to somethign else....
23:05.47blitzrageyah, something like that :)
23:05.49jsmithThat would seem to indicate it's not storing it as a bytea
23:06.06blitzragehrmmmmm
23:06.31blitzrageok, verified the 'recording' field really is bytea
23:10.21blitzrageheh, any other thoughts?
23:10.35jsmithNaw, I'll probably have to dive through the code :-(
23:11.27blitzragedarn
23:12.42blitzrageok well... I guess that's it for today then... might be back in a bit
23:15.40jsmithok... I probably won't do much until tomorrow anyway
23:16.02jsmithGotta get some dinner, do some laundry, celebrate my wife's birthday, etc.
23:16.17jsmith(her bday is tomorrow, but she has other things going on)

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.