| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Comments:
<0> Except*
<1> Therion: Its ok
<2> kuja: I love ##php so much I'm not even in there.
<1> Therion: Thank you for your help
<2> yep
<0> Therion: Hey cool, maybe we could love ##php the same, /part ##php
<0> :D
<3> Therion: I cannot discuss it w/ them... I don't have this choice
<2> afigueiredo: You can't write an email?
<0> Therion: He doesn't know Chinese.
<2> afigueiredo: anyway, remove the "default current_timestamp" junk...it's unnecessary in 3.23
<2> kuja: You write it for him!
<0> But, I don't know Chinaspeak either!
<3> Therion: and this version will insert the current timestamp automatically?
<4> kuja: your still in ##php, out with you! hater :/
<5> Darien thnks again =)
<0> Rhizome: Only cause I miss some people :(
<0> Miss people like enygma!
<0> :D
<4> hehe
<6> w3wt
<2> afigueiredo: That is the default behavior for TIMESTAMP columns.
<2> afigueiredo: it also updates to NOW() whenever the row is updated
<2> afigueiredo: Some people did not want it to do both things automatically, so 4.1 added stuff
<3> Therion: ok, thanks a lot
<0> afigueiredo: Oh and don't forget to learn Chinese on your way out.
<2> kuja: the few times I ever looked in there it looked like about what you would expect to see happen in a too-popular IRC channel
<2> full of geeks
<0> Free lessons, mandatory donations of $40, extra is welcomed.
<2> OMFG RTFM Y U R N H3R3!!!!11 ROFLCOPTER
<7> hello all
<0> Therion: Full of stupid geeks, who think they're 31337 cause they use PEEAYCHPEE
<8> can anyone tell me if there is a problem with this line?
<8> insert into test (username, p***word) values ('uname', md5('pword'));
<3> kuja: hehehe
<9> I have bad time problems with a query, it takes 30+ seconds the first time it's executed (than mysql probably caches the results so it takes almost no time)
<6> hodoh - I believe "p***word" is a reserved word
<2> hodoh: How about the server tells you if there is a problem with that line.
<8> so i need to change my table heading to say p***w or something?
<2> p***word should not be reserved
<9> http://www.rafb.net/paste/results/eMS3rr67.html
<10> !man reserved words
<11> (Treatment of Reserved Words in MySQL) : http://dev.mysql.com/doc/mysql/en/Reserved_words.html
<8> the server dosent say anything just adds the line but dosent md5 encrypt the p***word
<9> the query is here... do you think there are ways to make it take less time to execute?
<2> quit guessing and see what the server says
<2> hodoh: What does it do, then? :)
<10> what do you know? p***word isn't reserved
<12> ok
<12> i need to dump a few diff datbases
<2> mysqldump --help
<12> putting the p***word in .my.cnf trick isn't going to work with 5 users
<2> What 5 users?
<10> use root and forget about other users
<2> They can put their own p***words in their own directories
<12> i don't have a root account on this system
<12> these are mysql users only
<10> but you have 5 user accounts?
<12> 5 mysql users
<12> one unix user
<2> then script the dumping
<10> do you have mysql root?
<8> 47e2a2bc8c8a6988 is what that line of code puts into my p***word when it should be be a3bd297ab65e283c5d69e0950949502f
<2> with p***words int he script and good file privileges on the script
<12> shabbs: no
<2> hodoh: How about you make your column the proper size...
<12> hmmm
<12> you can p*** the p***word to mysqldump
<2> hodoh: md5() is not going to generate a bad hash, however
<8> lol yea i forgot about that
<12> ok
<12> i don't want to p*** it on the command line
<12> is there another option?
<2> I just gave one
<12> Therion: i don't understand
<2> This is the day in which people love to see themselves typing
<2> Dreamer3: SCRIPT IT
<12> i heard you
<2> Place The Mysqldump Comands In A Script File
<12> *listens*
<12> and how do i get the p***words to mysqldump?
<2> With -pp***word
<2> Same way you would do it on the command-line
<2> Since this is the command-line
<12> um, but they someone running ps aux can see the p***word
<2> Yep
<12> that's bad
<12> that's what i'm asking how to avoid
<2> use different config files
<2> p*** --defaults-file option
<2> though usually we mask the p***word after program is running
<2> still a window of opportunity to catch it though
<7> whois xorian
<10> how should I know?
<12> i can't find defaults-file in the mysqldump manpage
<12> is that only for a new version?
<2> Dreamer3: stop reading the man page
<2> Dreamer3: and mysqldump --help
<10> !m Dreamer3 mysqldump
<11> Dreamer3: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<2> God I wish people would stop distributing the friggin manpages
<12> hahaha
<12> Therion: ok :-) so put the p***words in secure files... and use --defaults-file?
<13> manpages.... sounds so gay
<10> DjViper: man mount
<13> :!
<2> Dreamer3: That's one way to do it, yes.
<14> and with -f sounds illegal.
<12> Therion: or i could have the script rewrite the config file each time :-)
<12> Therion: that might not be so hard :-)
<2> Dreamer3: not difficult at all
<10> Therion: yak yak yak yak yak yak. I love to see myself type. yak yak yak
<12> but i'm not familiar with shells... echo " " >> blah... that wouldn't run a process that could be spied on with ps aux ?
<12> i'm pretty sure echo is a builtin
<2> shabbs: i love to see you type too!
<15> Dreamer3: you want that to appear on ps ?
<8> ok thanks guys it was cause the p***word was varchar(16) not 32. i get so stupid sometimes lol
<12> lokus: NO, i don't want it to :-)
<12> lokus: i'm trying to deal with this shared hosting env :-)
<15> Dreamer3: with echo
<12> lokus: i'm thinking echo is a bash built-in so it should be safe
<14> echo isn't generally built-in.
<10> what are the actual chances of someone catching the p***word with ps aux?
<4> Dreamer3: it will show in ps if your quick enough :P
<12> shabbs: small but possible
<14> which echo # will tell you.
<12> Rhizome: huh? echo? it's a bash built-in
<14> Nope.
<12> well
<12> there is a /bin/echo too... but it's built-in? no?
<10> rename /bin/echo and try it
<12> shabbs: i can't :-) guess i'l just stick with config files for each user
<12> at least i know that's safe
<14> Looks like it may be built-in as well.
<12> yeah, i thoguht so, but i don't think i'll do that anyways
<12> better safe than sorry
<4> nah, it won't show echo, hehe. watch -n1 ps ax and spam echo :/
<2> Leithal: Got punted
<16> yea I saw
<16> few people did
<2> It starts with V and ends with PAIN IN MY ***
<16> heh
<16> you on udp or tcp?
<2> TCP
<16> try udp
<2> no thank you
<16> works better for me ;p
Return to
#mysql
or
Go to some related
logs:
#python
yum repo REL4
#physics
#perl
vesafb-tng 1440x900
gentoo stdc++ compatibility
/bin/bash: -c: line 0: unexpected EOF while looking for matching `)'
#math
#oe
#linux
|
|