| 14:45:44 | Jayce^ | whaddup HarleyPig |
| 14:46:20 | HarleyPig | Not much. |
| 14:47:50 | Jayce^ | so what'd you think of last night? |
| 15:32:30 | HarleyPig | It was pretty good. Woulda been better with a projector though. |
| 15:32:53 | HarleyPig | I like the program Sasha came up with. |
| 15:45:03 | | Slashdot - Updated 2002-08-15 15:49:07 | Paging Eliza: Patenting IM Bots | Python Programming with the Java Class Libraries | The Day The Music Died: Windows Media and DRM | Tracking Your Employees, Children |
| 15:45:03 | han_solo | ibot, slashdot? |
| 15:45:17 | | ...but ibot is "the" bot around... |
| 15:45:17 | han_solo | ibot, you are now a patent infringement. congratulations. |
| 15:45:30 | | ...but ibot is "the" bot around... |
| 15:45:30 | han_solo | ibot, you are an outlaw |
| 15:55:29 | Jayce^ | hehe |
| 15:55:38 | Jayce^ | yeah, that patent is quite ridiculous.. |
| 15:56:21 | Jayce^ | "we invented bots in late 2000".. but CPAN has had modules for this that are timestamped from before then.. "we arent' aware of any" |
| 15:56:34 | HarleyPig | AHHHHHHH CRAAAAAAAP I hate Hate HATE vircomm and rodopi and freakin' winblows in general! |
| 15:56:38 | HarleyPig | *pant* *pant* |
| 15:57:34 | Jayce^ | hehe |
| 15:57:37 | Jayce^ | what's up HarleyPig? |
| 15:58:06 | Jayce^ | han_solo: you are bad, now you got me back into tweaking/learning my vim settings... there goes another day.. |
| 15:58:30 | HarleyPig | I have to extract some information so a ... client (loosely called) can be sure they're getting due services. |
| 15:58:53 | HarleyPig | All of the information is contained in about 3 separate log files and a MSSQL database. |
| 15:59:07 | HarleyPig | Why the hell couldn't they talk to each other and put it one freakin place! |
| 15:59:22 | HarleyPig | considers going over to the client's place of business ... |
| 15:59:30 | Jayce^ | and why put it on winblows.. well, I'll tell you.. look who set that system up.. |
| 16:00:18 | han_solo | so sorry $jayce, but how do you think I came up with desert.vim last summer? |
| 16:00:25 | HarleyPig | Yeah, but he's no longer here, or even involved (thank goodness) but we can't take the time to convert (although we're working on a *n*x Radius solution). |
| 16:00:26 | Jayce^ | hehe |
| 16:01:25 | han_solo | if I ever lose my vimrc it would take a week of unproductivity to get back to normal. :) |
| 16:01:47 | HarleyPig | han_solo: Put it up on a website. |
| 16:02:16 | Jayce^ | han_solo, since you seem to be the vim guru amongst us.. can you set the syntax highlighting to use multiple types of syntax/indenting? eg.. I already have my perl syntax to recognice anything inside qq{ }; to be HTML, the highlighting works.. I tried repeating the process for SQL, but it won't work, only let's me do one. |
| 16:02:36 | HarleyPig | Can I setup mysql as a ODBC system dsn on winblows? |
| 16:02:44 | Jayce^ | yeha |
| 16:02:46 | Jayce^ | yeah even |
| 16:02:51 | HarleyPig | Do I need to do anything different with an existing mysql setup? |
| 16:02:53 | Jayce^ | myodbc |
| 16:03:02 | Jayce^ | nope, just create the user permissions |
| 16:03:13 | HarleyPig | Woops. |
| 16:03:19 | HarleyPig | Didn't state myself well. |
| 16:03:32 | Jayce^ | there is also a dll that allows direct connection if you are coding the app and don't want to use odbc |
| 16:03:34 | HarleyPig | I want to connect to mysql on a true os from winblows using odbc. |
| 16:03:57 | Jayce^ | yeah... that's how I understood you.. |
| 16:04:03 | HarleyPig | Just found an app that comes with vopradius that may do what I need. |
| 16:04:10 | HarleyPig | Oh. |
| 16:04:21 | Jayce^ | just have the winblows machine set up with myodbc, and fill in the dsn with the connect information.. |
| 16:04:29 | HarleyPig | Ah. |
| 16:04:35 | HarleyPig | Does myodbc require a license? |
| 16:04:41 | HarleyPig | fee? |
| 16:04:43 | Jayce^ | gpl I believe.. |
| 16:05:24 | Jayce^ | it works well, I've had to use it before. |
| 16:06:40 | HarleyPig | Hmmm ... I know the general answer, but in this case should I go with 2.5 (stable) or is the 3.? devel stable enough? |
| 16:06:52 | Jayce^ | myodbc? no idea |
| 16:07:04 | Jayce^ | look at the functions it supports? |
| 16:07:16 | HarleyPig | Reading docs now. |
| 16:07:49 | HarleyPig | Cool. myodbc is public domain. |
| 16:08:06 | han_solo | jayce^ you want things inside of qq{} to be highlighted as both html and sql? |
| 16:08:34 | Jayce^ | no, qq{} would stay html, then I'd do a different thing, maybe <<SQL; as my marker for sql |
| 16:11:44 | Jayce^ | syn include @Html <sfile>:p:h/html.vim |
| 16:11:44 | Jayce^ | syn region perlHTML start="qq{" end="};" contains=@Html keepend |
| 16:12:09 | Jayce^ | that does the html part, but switching the necessary parts to sql, and changing the delimiters doesn't work.. |
| 16:15:34 | Jayce^ | so: |
| 16:15:36 | Jayce^ | syn include @Sql <sfile>:p:h/sql.vim |
| 16:15:36 | Jayce^ | syn region perlSQL start="<<SQL" end="^SQL" contains=@Sql keepend |
| 16:15:53 | Jayce^ | doesn't do anything if I have the HTML in ahead of it, switch order, and just the sql works |
| 16:16:15 | Jayce^ | and it's just *too* cool that I have to have it.. |
| 16:19:14 | han_solo | hmm |
| 16:20:14 | Jayce^ | and then I want to apply indents in those blocks if possible.. |
| 16:21:12 | han_solo | HarleyPig: http://hans.fugal.net/vim |
| 16:22:18 | han_solo | have you tried giving it a different name? maybe the html file is defining @sql already? |
| 16:22:25 | han_solo | (unlikely) |
| 16:28:44 | HarleyPig | han_solo: Cool. Thanks. |
| 16:29:20 | HarleyPig | Hmmm ... I wonder if we could do a web interface for building a vimrc ... |
| 16:29:47 | HarleyPig | Does anyone know of a odbc based db gui browser? Linux preferred but winblows will be fine. |
| 16:30:03 | han_solo | i've thought about such a thing - more general even where you have metadata indicating the set of options for a configuration file |
| 16:30:28 | han_solo | someone already has a dotfiles something-or-other on the web, but iirc I wasn't extremely impressed |
| 16:31:17 | HarleyPig | :/ |
| 16:33:48 | han_solo | jayce^ it looks like html.vim does multiple syn include statements, but I don't see anything about sql |
| 16:33:56 | Jayce^ | me either |
| 16:41:08 | Jayce^ | stumps han_solo :D |
| 16:42:56 | Bradipo | Anyone mind testing DCC CHAT for a minute? |
| 16:43:34 | Jayce^ | uh, sure.. |
| 16:43:42 | Bradipo | Hmm. |
| 16:43:53 | Bradipo | Looks like I can accept the session, but it's not doing anything. |
| 16:51:05 | brailsmt | Jayce^: you can rather easily make something highlight the way you explain in vim... |
| 16:51:12 | brailsmt | I did it with flex and java |
| 16:51:36 | Jayce^ | yeah, I run that, and it will only do the first one that's defined.. |
| 16:51:59 | brailsmt | when working with a vim script you can do it in ruby via "ruby << END ... END" will be highlighted as ruby |
| 16:54:22 | brailsmt | instead of "syn include @Sql <sfile>:p:h/sql.vim" do "so $VIMRUNTIME/syntax/sql.vim" or "runtime syntax/sql.vim" |
| 16:54:23 | Jayce^ | how about sql? like I have will only work if I dont' have HTML defined, and vice versa |
| 16:55:43 | Jayce^ | so, say sql <<SQL ... SQL ? |
| 16:56:38 | brailsmt | Jayce^: if you want, you can do anything that you can identify uniquely... by the way there is no @Sql defined in sql.vim |
| 16:58:01 | brailsmt | hrmm... i guess you could do "syn include ..." but you don't need to |
| 16:58:41 | brailsmt | just source the sql.vim file and then add the appropriate contains=... to the highlighting rules |
| 16:59:32 | Jayce^ | example please :D |
| 17:00:45 | brailsmt | but after you source the sql.vim file do "syn cluster sqlTop contains=sqlComment,sqlSpecial,sqlKeyword,sqlOperator,sqlStatement,sqlType,sqlString,sqlNumber" |
| 17:01:36 | brailsmt | then ... "syn region perlSQL start="<<SQL" end="^SQL" contains=@sqlTop keepend" |
| 17:02:12 | brailsmt | here are some examples from my jflex syntax file |
| 17:02:23 | brailsmt | " Include java syntax {{{ |
| 17:02:23 | brailsmt | if version >= 600 |
| 17:02:23 | brailsmt | runtime! syntax/java.vim |
| 17:02:23 | brailsmt | unlet b:current_syntax |
| 17:02:23 | brailsmt | else |
| 17:02:27 | brailsmt | so $VIMRUNTIME/syntax/java.vim |
| 17:02:28 | brailsmt | endif |
| 17:02:29 | brailsmt | "}}} |
| 17:03:10 | brailsmt | syn cluster jflexOptions contains=jflexOption,jflexCodeInclude,jflexComment,jflexMacroIdent,jflexMacroRegExp,jflexOptionError |
| 17:03:10 | brailsmt | syn cluster jflexRules contains=jflexRule,jflexComment,jflexActionCode,jflexRuleStates,jflexRegExp |
| 17:03:10 | brailsmt | " java code section |
| 17:03:10 | brailsmt | syn region jflexStart start="/\*\|//\|import\|package\|class"me=s end="^%"me=e-2 contains=@javaTop nextgroup=jflexOptionReg |
| 17:03:10 | brailsmt | " % |
| 17:03:14 | brailsmt | " options |
| 17:03:16 | brailsmt | syn region jflexOptionReg matchgroup=jflexSectionSep start="^%" end="^%"me=e-2 contains=@jflexOptions nextgroup=jflexRulesReg |
| 17:03:42 | brailsmt | syn region jflexCodeInclude matchgroup=jflexCodeIncludeMark start="%{" end="%}" contains=@javaTop contained |
| 17:03:43 | brailsmt | syn region jflexCodeInclude matchgroup=jflexCodeIncludeMark start="%init{" end="%init}" contains=@javaTop contained |
| 17:03:43 | brailsmt | syn region jflexCodeInclude matchgroup=jflexCodeIncludeMark start="%initthrow{" end="%initthrow}" contains=@javaTop contained |
| 17:03:43 | brailsmt | syn region jflexCodeInclude matchgroup=jflexCodeIncludeMark start="%eof{" end="%eof}" contains=@javaTop contained |
| 17:03:44 | brailsmt | syn region jflexCodeInclude matchgroup=jflexCodeIncludeMark start="%eofthrow{" end="%eofthrow}" contains=@javaTop contained |
| 17:03:47 | brailsmt | syn region jflexCodeInclude matchgroup=jflexCodeIncludeMark start="%yylexthrow{" end="%yylexthrow}" contains=@javaTop contained |
| 17:03:50 | brailsmt | syn region jflexCodeInclude matchgroup=jflexCodeIncludeMark start="%eofval{" end="%eofval}" contains=@javaTop contained |
| 17:04:12 | brailsmt | ok, I'll stop now, but was that helpful? |
| 17:04:53 | Jayce^ | I think so.. let me finish reading :D |
| 17:07:05 | brailsmt | :) |
| 17:09:41 | brailsmt | ok, and here is an example from vim.vim using "syn include ..." |
| 17:09:41 | Jayce^ | runtime! syntax/sql.vim |
| 17:09:41 | Jayce^ | unlet b:current_syntax |
| 17:09:41 | Jayce^ | syn cluster sqlTop contains=sqlComment,sqlSpecial,sqlKeyword,sqlOperator,sqlStatement,sqlType,sqlString,sqlNumber |
| 17:09:42 | Jayce^ | syn region perlSQL start="<<QUERY" end="^QUERY" contains=@sqlTop keepend |
| 17:09:55 | Jayce^ | that's not quite working |
| 17:09:55 | brailsmt | if filereadable(expand("<sfile>:p:h")."/ruby.vim") |
| 17:09:55 | brailsmt | unlet! b:current_syntax |
| 17:09:55 | brailsmt | syn include @vimRubyScript <sfile>:p:h/ruby.vim |
| 17:09:55 | brailsmt | syn region vimRubyRegion matchgroup=vimScriptDelim start=+rub[y]\s*<<\s*\z(.*\)$+ end=+^\z1$+ contains=@vimRubyScript |
| 17:09:55 | brailsmt | syn region vimRubyRegion matchgroup=vimScriptDelim start=+rub[y]\s*<<\s*$+ end=+\.$+ contains=@vimRubyScript |
| 17:09:55 | brailsmt | endif |
| 17:10:13 | brailsmt | what isn't working? |
| 17:10:22 | Jayce^ | the highlightling.. |
| 17:11:28 | brailsmt | you said it isn't quite working, is any of it working? |
| 17:11:42 | Jayce^ | btw, this is my first experience with these files, so "be gentle" :D |
| 17:11:48 | Jayce^ | yeah, none is.. |
| 17:11:48 | brailsmt | :) |
| 17:12:42 | brailsmt | jflex was my first experience, and flex is a tough one to highlight correctly, it took me weeks to get it working... (but that is because flex is really tough, not because vim highlighting is tough) |
| 17:13:04 | brailsmt | hrmm... |
| 17:14:36 | brailsmt | wait, my jflex example are wrong... i didn't know about "syn include " at the time... :) |
| 17:14:55 | brailsmt | sorry |
| 17:15:01 | Jayce^ | heh |
| 17:15:31 | brailsmt | try "syn include @sqlTop syntax/sql.vim" |
| 17:16:12 | brailsmt | and remove the sourcing of sql.vim lines and the "syn cluster sqlTop ..." line |
| 17:17:14 | brailsmt | from vim help ":sy[ntax] include [@{grouplist-name}] {file-name} |
| 17:17:14 | brailsmt | All syntax items declared in the included file will have the |
| 17:17:14 | brailsmt | "contained" flag added. In addition, if a group list is specified, |
| 17:17:14 | brailsmt | all top-level syntax items in the included file will be added to |
| 17:17:14 | brailsmt | that list. " |
| 17:17:29 | brailsmt | that is exactly what you want... |
| 17:18:33 | brailsmt | consequently it is what I want in jflex.vim, too... |
| 17:19:36 | Jayce^ | hrmm... it gives the second < in red, then everything is the same color except the stuff in '' .. it's better, but not quite it.. |
| 17:21:41 | Jayce^ | no wait, that was an error, still had contains @Html there.. doing it right doesn't work, which is back to how I had it... it sems to only work on the first include |
| 17:21:57 | brailsmt | ok, i have a keymapping that tells me what the syntax group under the cursor is... |
| 17:22:10 | Jayce^ | cool.. |
| 17:22:52 | brailsmt | before the the second include do you have "unlet! b:current_syntax"? |
| 17:23:01 | brailsmt | lemme look for that keymap for you |
| 17:23:46 | Jayce^ | sweet... that was it.. you da man.. |
| 17:24:20 | brailsmt | after a wild goose chase... |
| 17:24:21 | brailsmt | :) |
| 17:25:24 | brailsmt | ok you want this keymap that I was talking about? |
| 17:25:31 | Jayce^ | yeah |
| 17:25:31 | brailsmt | it is actually a plugin... |
| 17:25:41 | brailsmt | you want me to dcc it, or email it? |
| 17:25:49 | Jayce^ | dcc is fine |
| 17:25:55 | brailsmt | ok... |
| 17:27:17 | brailsmt | put that in ~/.vim/plugin" and the \hlt will tell you what highlight group is under the cursor... |
| 17:28:19 | brailsmt | i have found that keymap to be indispensible while writing syntax highlighting files |
| 17:28:53 | Jayce^ | \hlt ? in command mode? |
| 17:29:05 | brailsmt | yes |
| 17:30:07 | Jayce^ | got it.. cool |
| 17:34:32 | Jayce^ | hrmm.. now, can you apply INDENT rules in a like manner? |
| 17:34:54 | brailsmt | sql doesn't have an indent plugin |
| 17:35:08 | brailsmt | Jayce^: i don't know, i've never tried |
| 17:35:36 | Jayce^ | but HTML does.. I love having it autoindent, and back-indent when I do a end tag |
| 17:35:59 | brailsmt | i don't know, i wouldn't bet against it |
| 17:37:47 | brailsmt | hrmm, it doesn't look like it... |
| 17:37:51 | han_solo | /me pops his head in |
| 17:38:32 | han_solo | that's right - i remember now that you have to unlet b:current_syntax |
| 17:38:47 | han_solo | it's just been so long |
| 17:43:08 | Jayce^ | makes sense |
| 19:28:50 | han_solo | didn't someone here work with bennet cookson? |
| 19:29:53 | brailsmt | :) |
| 19:30:00 | han_solo | that's what ibot stands for |
| 19:30:17 | han_solo | i always wondered |
| 19:35:52 | brailsmt | oops |
| 20:10:49 | han_solo | what was the env. variable for telling perl where to look? |
| 20:11:47 | Jayce^ | you mean to find libraries? |
| 20:12:23 | Jayce^ | the @INC ? |
| 20:13:18 | han_solo | i found it - PERL5LIB |
| 20:57:44 | han_solo | what's the 1; at the end of a package? |
| 20:57:48 | han_solo | (perl) |
| 20:58:17 | Jayce^ | in perl, the last thing in a scop is automatically returned.. |
| 20:58:24 | Jayce^ | so it's the same as return 1; or true.. |
| 21:01:12 | han_solo | ic |
| 21:14:57 | han_solo | do you use SOAP::Lite Jayce^? |
| 21:15:59 | Jayce^ | yeah |
| 21:16:19 | han_solo | I can't seem to get it to work |
| 21:16:39 | han_solo | going from the example in the oreilly book |
| 21:16:53 | Jayce^ | what's it giving? |
| 21:17:18 | han_solo | I can't tell what's wrong, but it doesn't seem to give a result |
| 21:17:36 | Jayce^ | so the client is getting null? |
| 21:17:50 | Jayce^ | what transport are you using? |
| 21:19:04 | han_solo | http with cgi |
| 21:19:25 | han_solo | I just tested a client against the temperature server in the man page and that worked, so it must be server side |
| 21:20:12 | han_solo | use SOAP::Transport::HTTP; |
| 21:20:12 | han_solo | SOAP::Transport::HTTP::CGI |
| 21:20:12 | han_solo | -> dispatch_to('Hello') |
| 21:20:12 | han_solo | -> handle |
| 21:20:12 | han_solo | ; |
| 21:20:23 | brailsmt | eww, perl... |
| 21:20:28 | brailsmt | :) |
| 21:20:41 | Jayce^ | smacks brailsmt |
| 21:20:50 | brailsmt | |lart perl |
| 21:20:52 | infringement_bot | uses the "Customer Appreciation Bat" on perl |
| 21:21:11 | Jayce^ | ok, are you using mod_soap, or just the cgi on the server? |
| 21:21:15 | Jayce^ | hehe PA |
| 21:21:39 | brailsmt | my wife just went water skiing at Utah lake |
| 21:22:05 | brailsmt | the ppl she went with told a story about a guy that got stuck in the lake |
| 21:22:16 | Jayce^ | eeewwwww.... that lake is nasty |
| 21:22:18 | brailsmt | they couldn't pull him out |
| 21:22:27 | brailsmt | so they called Search and Rescue |
| 21:22:57 | brailsmt | when S&R got him out they found that he had jumped off the boat and through the rib cage of a dead cow... |
| 21:23:06 | brailsmt | eewwwww |
| 21:23:12 | han_solo | mmmm yumm |
| 21:23:17 | han_solo | just cgi on the server |
| 21:24:29 | Jayce^ | k... let's see your server code.. |
| 21:25:17 | han_solo | #!/usr/bin/perl -w |
| 21:25:17 | han_solo | use lib '/home/fugalh/perl'; |
| 21:25:17 | han_solo | use SOAP::Transport::HTTP; |
| 21:25:17 | han_solo | SOAP::Transport::HTTP::CGI |
| 21:25:17 | han_solo | -> dispatch_to('Hello') |
| 21:25:18 | han_solo | -> handle; |
| 21:25:37 | han_solo | that was the server code. you want to see the Hello module? |
| 21:25:57 | han_solo | package Hello; |
| 21:25:57 | han_solo | sub sayHello { |
| 21:25:57 | han_solo | shift; |
| 21:25:57 | han_solo | return "Hello, ".shift; |
| 21:25:57 | han_solo | } |
| 21:25:59 | han_solo | sub hi { |
| 21:26:00 | han_solo | return "Hello, world!"; |
| 21:26:02 | han_solo | } |
| 21:26:04 | han_solo | 1; |
| 21:29:03 | Jayce^ | and that is in a web accessible location? |
| 21:29:16 | han_solo | yeah |
| 21:29:27 | Jayce^ | and does your apache error_log give you anything? errors? |
| 21:29:55 | han_solo | nothing |
| 21:30:36 | Jayce^ | slap a warn in there, see if it's getting loaded (the efficient way of debugging :D ) |
| 21:30:36 | han_solo | but access.log: |
| 21:30:44 | han_solo | 127.0.0.1 - - [15/Aug/2002:16:33:36 -0600] "POST /cgi-bin/hello.cgi HTTP/1.1" 500 666 |
| 21:32:10 | han_solo | the warn shows up in the error logs |
| 21:33:21 | Jayce^ | ok, so it's getting run then.. |
| 21:33:21 | Jayce^ | what's the client look like? |
| 21:35:14 | han_solo | #!/usr/bin/perl |
| 21:35:14 | han_solo | use SOAP::Lite; |
| 21:35:14 | han_solo | print 'The SOAP server says: "'; |
| 21:35:14 | han_solo | print SOAP::Lite |
| 21:35:14 | han_solo | -> uri('http://www.soaplite.com/Temperatures') |
| 21:35:14 | han_solo | -> proxy('http://localhost/cgi-bin/hello.cgi') |
| 21:35:16 | han_solo | -> hi() |
| 21:35:19 | han_solo | -> result . "\"\n\n"; |
| 21:35:21 | han_solo | and the output is |
| 21:35:24 | han_solo | The SOAP server says: "" |
| 21:37:40 | Jayce^ | umm, why the different URI? |
| 21:37:58 | han_solo | oh, that's from the example in the man page |
| 21:38:04 | han_solo | it's just a namespace anyhow, isn't it? |
| 21:38:20 | Jayce^ | I'm tyring to remember.. I'd try changing it.. |
| 21:39:34 | han_solo | i tried the exact same thing as the proxy and it still misbehaves |
| 21:41:04 | Jayce^ | I'm used to using mod_soap, and requiring a sub handler |
| 21:41:18 | han_solo | weird. well I was only going to code it up as a quick hack since we'll be using java and c++ anyhow |
| 21:41:27 | Jayce^ | that's it, your not calling the method.. |
| 21:41:35 | han_solo | that's what the hi() is |
| 21:41:48 | Jayce^ | yeah... duh... I can't believe I didn't see that right away.. |
| 21:41:50 | han_solo | also tried it with sayHello('Hans') |
| 21:42:28 | Jayce^ | it should need that... to call the method you want.. |
| 21:42:33 | Jayce^ | and pass your parameter |
| 21:42:56 | han_solo | i thought parameters might be a breaking point so I added hi() and called it |
| 23:25:56 | Jayce^ | wb HarleyPig |
| 23:27:09 | HarleyPig | Thanks. |
| 23:28:34 | Jayce^ | so what you working on now? |
| 23:28:58 | HarleyPig | Still working on that log crap for vircom and rodopi fiasco. |
| 23:29:05 | Jayce^ | fun |
| 23:29:05 | HarleyPig | At least now I know what I need to do. |
| 23:29:21 | HarleyPig | I mean, besides fdisk /mbr on the damn rodopi server. |
| 23:29:53 | Jayce^ | heh |
| 23:29:55 | HarleyPig | Radius can send the domain information to rodopi just fine, but rodopi chokes on it. And we need to be able to report on different domains. |
| 23:30:20 | HarleyPig | I even figured out how to fix the sql database so that it shouldn't be a problem ... |
| 23:30:35 | HarleyPig | but I'm waiting for rodopi to tell me it won't cause any problems elsewhere. |
| 23:30:49 | HarleyPig | "Uhhhh ... can you do that?" |
| 23:30:51 | HarleyPig | Morons. |
| 23:31:30 | Jayce^ | yup |
| 23:32:53 | HarleyPig | I'm pretty sure that they're gonna tell me that I can't do it (I just want to add a column to the usage table, and modify the stored procedure so it splits out the domain info) |
| 23:33:03 | HarleyPig | because I'm pretty sure they're using select * in their code. |
| 23:33:39 | Jayce^ | hehe.. |
| 23:36:38 | HarleyPig | So, in the meantime (since they have a history of getting back to us 2 weeks later) I get to parse a year and a half of radius logs looking for the necessary info. |
| 23:37:12 | Jayce^ | doing it in vb then 'eh ? :D |
| 23:37:21 | HarleyPig | And it's 3 logs per day for all of the info. Fortunately, the idjits at vircom put a session identifier with or near each piece of info I need. |
| 23:37:29 | HarleyPig | smacks Jayce^ |
| 23:38:00 | HarleyPig | I installed ActivePerl on the radius box, over scothoser's objections about changing the box. |
| 23:38:05 | HarleyPig | Also, myodbc. |
| 23:38:06 | HarleyPig | heh |
| 23:38:26 | HarleyPig | Hmmm ... can I use myodbc through perl? |
| 23:38:35 | Jayce^ | yeah, DBD::ODBC |
| 23:38:38 | HarleyPig | That'd make things even easier. |
| 23:38:52 | Jayce^ | why not use DBD::mysql ? |
| 23:39:08 | HarleyPig | I thought that was *n*x only. |
| 23:47:21 | HarleyPig | Is there a better/quicker way to do something like: |
| 23:47:23 | HarleyPig | next unless /^\s+Acct\s+SQL:\s+CALL Interface_VircomDetails\((.*)\)}/; |
| 23:47:23 | HarleyPig | $line = $1; |
| 23:47:24 | HarleyPig | $line =~ s/'//g; |
| 23:47:24 | HarleyPig | my @log = split /,/, $line; |
| 23:48:29 | HarleyPig | Hmmm ... wonder if : my @log = split /,/, ($line =~ s/ |
| 23:48:33 | HarleyPig | '//g) |
| 23:48:35 | HarleyPig | would work. |
| 23:50:24 | HarleyPig | Nope. |
| 23:51:16 | HarleyPig | Oh well, not that big a deal. |