IRC log for #uphpu on 20080908

00:11.25*** join/#uphpu NoticZ (n=NoticZ@68.178.8.212)
00:11.33NoticZhowdy fellas?
00:11.49thebigdoghow you doing NoticZ
00:12.33NoticZpretty good, yourself?
00:12.53thebigdognot too bad...just compiling some kernel crap
00:13.45NoticZfun, hey mysql shell, how do I display results on a per page basis?
00:14.39thebigdogi usually set mine to page with less
00:14.49thebigdogmysql> pager less
00:14.56thebigdogmysql> SHOW innodb STATUS\G
00:15.03thebigdogthen do something like that
00:15.23thebigdogwhat version of mysql you on?
00:16.14thebigdogi have seen people write their own pager too
00:16.23thebigdoga simple shell script or something
00:16.28NoticZlatest version I beleive
00:16.46thebigdogthis might be a good read for ya - http://www.walkernews.net/2008/07/06/mysql-dummy-guide-how-to-display-long-sql-output-in-page-by-page/
00:20.09NoticZthanks buddy, that will do the trick.
00:20.19thebigdogk np
00:20.19NoticZso what do you for work?
00:36.57thebigdogsoftware engineer
00:37.02thebigdogand sys admin stuff
00:37.05thebigdogpretty much everything
00:37.15thebigdog-graphic stuff
00:37.22thebigdogi dont do ui/graphics
00:45.32thebigdogwhat do you do NoticZ for work?
00:45.43thebigdogi do consulting a ton too
00:50.25NoticZahh sorry was away for a sec
00:50.47NoticZI sell white gauges actually
00:50.57NoticZwww.whitegauges.net/catalog
00:59.14thebigdogoh nice
00:59.31thebigdogwhen my kids move out and i can have a cool car then i will have to get the hook up
00:59.41thebigdogactually there are some guys here that might be interested
00:59.50thebigdogthey do some racing at the salt flats
01:05.03NoticZnice
01:05.37NoticZyeah, been doing it for a while. So do you work for a company? Or do you do your own thing?
01:05.57thebigdogi have my own company
01:06.23thebigdogwww.torosys.com
01:07.07thebigdogi own that with a buddy and we have contracts with companie
01:07.09thebigdogcompanies
01:08.18NoticZnice
01:08.45NoticZif you ever need any signage done I do signs as well. www.durangedesign.com
01:09.18NoticZpretty slick
01:09.25thebigdogsweet i will have to check it out
01:09.31thebigdogi need to get a banner
01:09.41thebigdogfor a baseball field done up
01:09.52thebigdoglike they put on the fences
14:58.20*** join/#uphpu jbot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt)
14:58.20*** topic/#uphpu is Utah PHP Users Group | uphpu.org
14:58.20*** mode/#UPHPU [+v jbot] by ChanServ
15:00.27*** join/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net)
15:00.27*** mode/#UPHPU [+o Utah_Dave] by ChanServ
15:02.00*** join/#uphpu _psychic_ (n=_psychic@raisinbread.fttp.xmission.com)
15:02.01*** mode/#UPHPU [+v _psychic_] by ChanServ
15:03.00Utah_DaveI have a Fedora 8 server running a php / mysql app.
15:11.58*** join/#uphpu jbot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt)
15:11.58*** topic/#uphpu is Utah PHP Users Group | uphpu.org
15:11.58*** mode/#UPHPU [+v jbot] by ChanServ
15:12.06mgearyor you could (temporarily) set mysql to log all queries, assuming seeing the query would give enough info to know the culprit
15:12.25fungusPersonally i would just use tcpdump
15:12.53fungusOr, if you can get a mysql monitor in you can run "show processlist"
15:13.10tierra"mysqladmin processlist" will also list the active processes and which user/db
15:14.33Utah_DaveOK, "show processlist" say 425 | unauthenticated user | 191.1.8.1:58197 | NULL | Connect | NULL | login | NULL
15:14.43Utah_Dave191.1.8.1 is my server address
15:15.44mindjujucuriouser and curiouser
15:18.16Utah_Davemindjuju: did you sneak into my server room and play a trick on me?
15:19.51tierrayou could also try to catch which process is doing the login at the same time then by running "mysqladmin processlist; netstat -pl" and link up the source port with the process using that outgoing port
15:21.35tierraer, no need for -l
15:22.24fungusnetstat -antp | grep 3306
15:22.44Utah_Daveah, I'll try that.
15:26.52Utah_Davefungus: I ran that. and it looks like mysqld is trying to connect to itself
15:27.26funguspastebin?
15:30.46Utah_Davefungus: http://snipr.com/3o7uo
15:31.35fungusThose are the server connection side.
15:31.54fungusYou should see more entries with the local and foreign addresses reversed
15:32.09Utah_DaveYou know, we changed the hostname in the DNS server the other day
15:32.25Utah_Daveand I just changed the hostname on the server to match. Would that have been causing problems?
15:33.09fungusPerhaps.  gotta find the source of the connections.
15:34.43Utah_DaveI think that fixed it. I'm not showing all those unauthenticated users anymore
15:40.37*** join/#uphpu carmony (n=justin@c-67-164-249-224.hsd1.ut.comcast.net)
15:41.23Utah_Davethanks for the help fungus, mindjuju, tierra, mgeary, and _psychic_
15:41.31Utah_Daveit's working a lot better now
16:00.08*** join/#uphpu josephscott (n=josephsc@97-117-6-10.slkc.qwest.net)
16:00.08*** mode/#UPHPU [+v josephscott] by ChanServ
16:01.49carmonywow..... a run-away script just created a 107GB message and the server hung trying to email it.....
16:02.39carmonydf
16:02.53carmonywhoops, that was intented for my shell window :p
16:12.48*** join/#uphpu thebigdog (n=thebigdo@70.103.91.98)
16:12.48*** mode/#UPHPU [+o thebigdog] by ChanServ
16:19.03*** join/#uphpu mgeary (n=mgeary@166.70.44.49)
16:19.03*** mode/#UPHPU [+v mgeary] by ChanServ
16:52.59*** join/#uphpu wps (n=wps@64.0.193.170)
16:52.59*** mode/#UPHPU [+o wps] by ChanServ
16:59.47*** part/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net)
17:02.30*** join/#uphpu wps (n=wps@64.0.193.170)
17:02.30*** mode/#UPHPU [+o wps] by ChanServ
17:03.01*** join/#uphpu Paldimo (n=BBertola@0006yE-Yn.dsl.xmission.com)
17:04.08*** part/#uphpu Paldimo (n=BBertola@0006yE-Yn.dsl.xmission.com)
17:04.28*** join/#uphpu wps (n=wps@64.0.193.170)
17:04.28*** mode/#UPHPU [+o wps] by ChanServ
17:36.23*** join/#uphpu thebigdog (n=thebigdo@70.103.91.98)
17:36.23*** mode/#UPHPU [+o thebigdog] by ChanServ
17:39.06*** join/#uphpu bradym (n=bradym@12.89.250.154)
17:39.06*** mode/#UPHPU [+v bradym] by ChanServ
17:44.46*** join/#uphpu redroy (n=redroy@72.8.106.55)
17:46.14*** join/#uphpu _psychic_ (n=_psychic@raisinbread.fttp.xmission.com)
17:46.14*** mode/#UPHPU [+v _psychic_] by ChanServ
17:51.23*** join/#uphpu shadow_delta (n=cro@207-135-129-4.ip.xmission.com)
17:55.43*** join/#uphpu SunSparc (n=sparky@75.148.101.137)
17:55.43*** mode/#UPHPU [+v SunSparc] by ChanServ
18:03.37*** join/#uphpu mrkrow (n=chad@12.107.194.162)
18:03.37*** mode/#UPHPU [+v mrkrow] by ChanServ
18:20.27*** join/#uphpu Paldimo (n=BBertola@0006yE-Yn.dsl.xmission.com)
18:37.36*** join/#uphpu SunSparc (n=sparky@75.148.101.137)
18:37.36*** mode/#UPHPU [+v SunSparc] by ChanServ
18:43.00thebigdogafternoon all
18:57.29mgearyheya
19:08.01*** join/#uphpu SunSparc (n=sparky@75.148.101.137)
19:08.01*** mode/#UPHPU [+v SunSparc] by ChanServ
19:22.27thebigdoghaha i keep all my email
19:29.32*** join/#uphpu TheDruidXpawX2 (n=cgoudie@charon.thna.net)
19:32.01*** part/#uphpu TheDruidXpawX2 (n=cgoudie@charon.thna.net)
19:36.16mgearywell, i generally keep all my email, but i want to slim things down so i don't clog up my iphone
19:36.28mgearyi figure i can archive or delete email older that 3 years
19:39.39josephscottanyone tried spore yet?
19:40.07SunSparcjosephscott: I have seen someone try out Spore.  Looks pretty cool.
19:44.05fungusI bought it yesterday, but didn't get the chance to install it yet
19:44.26fungusBeen running the Creature Creator for quite a while though.
20:14.21wpsI hate how everyone says "bless you" after you sneeze
20:14.25wpsit's embarrassing enough already
20:14.52SunSparcHow about, "curse you!"
20:15.51optikalYeah, I prefer gesundheit or "good health."  We don't think our souls are escaping anymore.
20:16.00optikalEven though most people have adapted "bless you" to mean "bless you good health."
20:17.01wpsI don't even mind once
20:17.10wpsbut if I sneeze three times… you don't need to say it after each sneeze
20:17.47optikalhaha, yeah... that's a bit much
20:27.43SunSparcI just do it out of habit, or sometimes to be annoying.
20:38.12*** join/#uphpu wps (n=wps@64.0.193.170)
20:38.12*** mode/#UPHPU [+o wps] by ChanServ
21:08.09*** join/#uphpu romanovic (n=romanovi@m340e36d0.tmodns.net)
21:33.35orsonjI find it odd that people who say "bless me" when they are sick still say "bless you" when you sneeze
21:34.35orsonjthey expect two very different responses from each "bless" statement
21:51.23mgearywell bless my soul
22:06.11*** join/#uphpu _psychic_ (n=_psychic@raisinbread.fttp.xmission.com)
22:06.11*** mode/#UPHPU [+v _psychic_] by ChanServ
22:22.53thebigdogclear
22:34.13mgearyPonies!!!
22:50.29*** join/#uphpu shadow_delta (n=cro@207-135-129-4.ip.xmission.com)
23:00.53orsonjperhaps people say "bless you" when they mean "just acknowledging you sneezed to avoid awkward silence"
23:37.17*** join/#uphpu SunSparc (n=sparky@75.148.101.137)
23:37.17*** mode/#UPHPU [+v SunSparc] by ChanServ

Generated by irclog2html.pl Modified by Tim Riker to work with infobot.