#mysql
16 October 2007
Total 19 pages. You are browsing page 4/19.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
04:12 <****> dwxreaper: so ##php is a good start
04:12 <****> it's the best software for free, it's a front-end for snort intrustion detection systems
04:13 <****> and snort is the best intrustion detection software, as good or better than commercial
04:13 <****> it's abandoned.
04:13 <****> no other front-end, so this is it
04:13 <****> good luck with it.
04:29 <****> ebergen must have pulled a firewire
04:38 <****> chadmaynard: why
04:38 <****> he has @ beside his name
04:39 <****> and what is the meaning of 'pulling a firewire'?
04:39 <****> pulling a trick out of your hat.
04:39 * thoughtful gives this some thought
04:40 <****> thoughtful: firewire/ebergen = split personality
04:40 <****> firewire is the bad cop
04:42 <****> so, they get you in a channel by yourself and describe beating you senseless with a phone book?
04:43 * chadmaynard is confused
04:44 * thumbs volunteers
04:44 <****> good cop... bad cop... you know, one of them asks you if you want cigarettes, the other one stubs them out on your face...?
04:47 <****> where is the phone book? I need to talk to chadmaynard in private...
04:47 <****> near the phone. no, the other phone... the one that's near the phone book.
04:50 * chadmaynard is very confused
04:51 <****> chadmaynard: come over here, and I'll explain it to you...
04:51 <****> huh
05:16 <****> C API (Ruby actually): what is the maximum size of a statement (insert) submitted through the API?
05:18 <****> max_allowed_packet
05:22 <****> thumbs: damn got it working, only thing the database wasn't populated with after i delted all the records
05:23 <****> dwxreaper: that is pretty obvious yes.
05:23 <****> was the schema table which hold the database version, the php scripts referenced the database version, the version was only poulated with the .sql script
05:23 <****> deleting all the records does deplete a database.
05:23 <****> thumbs: yeah but snort or the barnyard plugin i use repopulates it, so it wasn't obvious
05:24 <****> I suppose I should congratulate you for figuring it out (on your own?)
05:24 <****> i dunno, but snort is fucking leet, it'll be inline functioning as an ips with the bsd firewall
05:25 <****> basically you try and hack something and it will block you
05:25 <****> dwxreaper: you don't need to tell me what snort does.
05:26 <****> when I do an insert command it says it works, but says there are 4 warnings, how do I view those warnings?
05:26 <****> show warnings();
05:26 <****> cool thanks
05:27 <****> that command doesnt work
05:27 <****> might have gotten the exact spelling wrong.
05:28 <****> !man show warnings
05:28 <****> (SHOW WARNINGS Syntax) : http://dev.mysql.com/doc/mysql/en/show-warnings.html
05:28 <****> thumbs, do I have to put anything in the ()?
05:28 <****> dwxreaper: you can snort all the BSD you want in your own time.
05:28 <****> riddlebox: read the link.
05:29 <****> BSD is an OS
05:29 <****> this is for 3 /19's, it will block hack attempts, where you can't with a firewall, quite advanced
05:30 <****> dwxreaper: now is the time you should drop it.
05:30 <****> thumbs: you have a bad attitude
05:31 <****> dwxreaper: I don't tolerate folks like you very well.
05:31 <****> anyhow.
05:41 <****> is it possible to increase the maximum allowed connections to mysql?
05:44 <****> sure
05:45 <****> ebergen is still in bully mode
05:45 <****> Fushuing: check my.cnf
06:20 <****> hello folks
06:22 <****> chadmaynard; thanks, but it doesn't mention anything about maximum connections
06:22 <****> or where the real my.cnf is @.@
06:23 <****> Fushuing: it is the max_connections system variable.
06:23 <****> you can set it to whatever
06:24 <****> well there is a max
06:24 <****> 65535?
06:24 <****> bye
06:25 <****> Fushuing: like 1000 on binaries provided by mysql i think
06:25 <****> Fushuing: if you have enough ram for that
06:25 <****> Fushuing: ahh, http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html
06:25 <****> 4000
06:26 <****> hmmm...is there a way i can find out where the real my.cnf is?
06:26 <****> like a sql query?
06:27 <****> yes
06:27 <****> show variables like 'datadir';
06:27 * Fushuing hugs chadmaynard, "Thank you so much!"
06:28 <****> whoops
06:28 <****> ...no my.cnf here
06:28 <****> i dunno why i typed datadir
06:28 <****> lol
06:28 <****> show variables like 'defaults%';
06:28 <****> maybe not
06:28 <****> no result
06:29 <****> yea maybe it isn't in the variable list. Maybe i'm just stupid.
06:30 <****> i'm screwed
06:40 <****> INNER JOIN tipo_planilla as tp
06:40 <****> ON alba.id_planilla = tp.id_planilla ON alba.id_empleado = tp.id_empleado
06:40 <****> why you can't do that?
06:40 <****> two on's in a line
06:41 <****> hello :)
06:41 <****> or one follow by the other w/e
06:41 <****> Could anyone recommend a free X or Windows client to manage MySQL?
06:41 <****> I'm just using mysql over ssh right now, and I'd rather use a GUI if possible to make things easier.
06:42 <****> phpadmi
06:42 <****> phpadmin
06:42 <****> That's a web interface though, right?
06:42 <****> __xor__: check out mysql tools and change you gay nick.
06:43 <****> xuser_: What do you mean MySQL tools?
06:43 <****> s/you/your
06:44 <****> __xor__: http://www.mysql.com/products/tools/
06:44 <****> Those don't look free though.
06:46 <****> :S
06:47 <****> that's not the right term
07:00 <****> Hmmmm we are thinking about making a large portion of our site DB Driven instead of static content, is there any value in making the content which will mostly not change, written to a file, or will MySQL caching mean it's about the same speed?
07:03 <****> SJrX: the file will be faster
Total 19 pages. You are browsing page 4/19.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last