| |
| |
| |
|
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 25
Comments:
<0> MySQL-test-standard-5.0.19-0.rhel4
<0> MySQL-Max-5.0.19-0
<0> MySQL-ndb-storage-5.0.19-0.glibc23
<0> MySQL-python-1.0.0-1.RHEL4.1
<0> MySQL-ndb-management-5.0.19-0.glibc23
<0> qt-MySQL-3.3.3-9.3
<0> MySQL-shared-compat-5.0.19-0.rhel4
<0> MySQL-standard-debuginfo-5.0.19-0.rhel4
<0> perl-DBD-MySQL-2.9004-3.1
<1> Well this is certainly long.
<0> MySQL-ndb-tools-5.0.19-0.glibc23
<0> qt-PostgreSQL-3.3.3-9.3
<0> MySQL-client-standard-5.0.19-0.rhel4
<0> MySQL-ndb-extra-5.0.19-0.glibc23
<0> [root@rbmain2 mysql50]#
<2> >:o
<3> blobaugh: i already changed accidentaly and now i recive error: 'Access denied for user: 'debian-sys-maint@localhost' (Using p***word: YES)'
<0> sorry mendell
<1> I think you need more rpms with "SQL" in their name, that's what I think
<4> what was the point of posting that?
<5> In my table, one of the columns is time, how do I select all rows where the time is between 09:00:00 and 12:00:00?
<6> my dialup is crying out in pain
<4> (out of curiosity)
<6> beginer: do you know what the p***word was?
<3> was default p***word... how can i reset to default or something...
<7> Hi, not sure if this is strictly MySQL, but I'm having a problem migrating a website from a server running mysql 4 + php 4 to a server running mysql 5 + php5. I intended to replicate the db, then point the old server at the new db to smooth the migration. However, this brings MySQL to a standstill with "Access denied to db for user" errors after a while
<0> blo...you asked me to #mysqld ...here it is:
<0> [root@rbmain2 mysql50]# mysqld
<0> 060329 15:24:39 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
<1> That's a good error
<8> indeed
<7> I then have to restart MySQL to get things going again
<6> lol
<0> 060329 15:24:39 [ERROR] Aborting
<0> 060329 15:24:39 [Note] mysqld: Shutdown complete
<9> Ok, so according to the internals manual (http://dev.mysql.com/doc/internals/en/p***word-functions.html), the client encrypts the p***word with the contents of the scramble_buff and sends it to the server. I'm good with that so far, but then the server is supposed to also encrypt the scramble_buff with the p***word and see if the results match. But the p***word is stored as a hash, so the server shouldn't know the p***word. Am I missing something here?
<0> permissions problem???
<1> rado2: What did the error message say?
<8> heheh
<6> beginer: im not sure what the default p*** is. i think it is created when you install mysql initially on a per machine basis
<3> i fond the p***word in /etc/mysql/debian.cnf but how i can syncronize with p***word from table users
<0> root@rbmain2 mysql50]# mysqld
<0> 060329 15:24:39 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
<10> where's the mysql stuff in FC5?
<3> blobaugh... yes, you right... i know that...
<1> Hanashi: AFAIK, both the client and the server hash the p***word.
<1> rado: No, read it to yourself.
<1> The error tells you to do something!
<0> but yet, mysqld is not the daemon name anymore
<6> beginer: well lucky for you they are both encrypted and look diff ;)
<0> I just ran that because blobaugh asked me to
<1> mysqld sure is the daemon name. what do you think you ran?
<6> rado2: thats the mysql server part
<9> mendel, that doesn't seem to make sense either. The server hashes the p***word so that it won't have to store the p***word. If the client hashes the p***word and uses that to encrypt the scramble_buff, and if the server is using the hash to encrypt the scramble_buff as well, then the server is effectively storing the p***word.
<8> Hanashi: you don't decrypt a hash
<6> if your script wasnt working then try that to make sure its not broken. something is though
<1> hanashi: No, it's not. You can't go the other way.
<3> It seems that the p***word in the /etc/mysql/debian.cnf file is just a plaintext p***word altough it looks like an encrypted one. (it has the same amount of random characters like all other encrypted p***words in the mysql.user table) So instead of putting the pwd directly in the table, I used the p***word() function to encrypt it and now it works fine again.
<3> where i find the p***word() function?
<0> [root@rbmain2 mysql50]# service mysqld status
<0> mysqld: unrecognized service
<1> rado: Which takes us to half an hour ago, when I told you that the init script is named "mysql".
<1> And service operates on init scripts.
<9> mendel, maybe I'm not being clear. Or maybe I'm being stupid today. I dunno. But if the client is expected to send CRYPT(scramble_buff + hash) and the server is also doing CRYPT(scramble_buf + hash) then hashing the p***word has no real effect...?
<6> lol
<6> beginer: so it worked when you did that ?
<1> hanashi: Hashing the p***word means that if you get a copy of the database, you don't have a list of p***words.
<1> Just like it does in Unix p***words.
<9> mendel, but you effectively do, if the hash is the input to the encryption function.
<9> Normal unix hashes the p***word, then compares the hash to the stored hash to see if it's correct.
<11> Hanashi: It basically goes like this.
<1> I don't think I can answer your question.
<11> Server sends seed.
<9> That's not what I'm understanding about mysql...
<0> mendel, I am sorry....I didn't see where you said that 1/2 hr ago
<11> Client hashes user's p***word
<6> so mendel how is your day going?
<9> mendel, that's ok. I can't answer it either. Thanks anyway, though.
<1> perl 1, nagios 0.
<8> oh, I thought nagios was written in perl :-)
<11> Client then hashes that hash, and xors the first hash with a hash of the seed + second hash)
<11> Server does the reverse.
<0> in my list of daemons...mysqld is not listed anymore. insted it's "mysql"
<11> In that way, basically neither p***word nor the hash of the p***word are ever on the "wire"
<6> rado2: right
<3> blobaugh: I don't did that... someone write that on the net... i don't know how to do that...
<12> is there a way I can have A ( some_id, random_info ) and B (some_id) and select from A where some_id NOT IN B ?
<12> without sub queries....
<6> !m beginer p***words
<13> beginer: (***igning Account P***words) : http://dev.mysql.com/doc/mysql/en/P***words.html
<11> Hanashi: If you're _really_ interested, the comments at top of p***word.c in the "libmysql" directory in a source distro has the details.
<0> something went wrong here and I tried going by the book w/this
<6> rado2: ok if it is named mysql now then try to start mysql with the init scripts
<9> mm-mysql, thanks for the extra detail. After the server reverses that sequence of events, it's then left with the user's p***word hash, which it then compares to the stored p***word hash to see if they match. Is that a correct understanding?
<0> you mean /ect/init.d/mysql?
<0> tried that
<6> rado2: '/etc/init.d/mysql start'?
<3> SQL: i know how to change a p***word... i dont know how to reset the p***word for debian-sys-maint...
<0> trying it again
<6> beginer: SQL is a bot ;)
<6> !m beginer set p***word
<13> beginer: (SET P***WORD Syntax) : http://dev.mysql.com/doc/mysql/en/SET_P***WORD.html
<0> [root@rbmain2 mysql50]# /etc/init.d/mysql start
<0> Starting MySQLCouldn't find MySQL manager or server [FAILED]
<0> [
<0> same thing
<1> rado: Read /etc/init.d/mysql, and see where it is screwing up.
<0> kk
<3> SQL: i already syncronize p***word from /etc/mysql/debian.cnf with p***word feom users table... and still error at restart...
<6> beginer: SQL is a bot
<0> ok...yes, the problem is in the script
<3> blobaugh: 10x :)
<12> guys, I am trying to select from table a where a.id NOT IN table b .... is that doable?
<14> Yes
<12> what would I be looking t ?
<12> s/t/at
<14> LEFT JOINs and NULLs
<9> mm-mysql, I've been reading through p***word.c, so thanks for the pointer. I'm going to work through this some more myself to see if I can make sure I understand, but I'm thinking that the hashes aren't doing what they are intended to do.
<9> But thank you very much for your help. I appreciate it.
<0> mendel, /etc/init.d/mysql: basedir= and datadir= ...both are blank
<12> will: so select from a left join b on a.id=b.id where b.id=null ?
<14> Try it :)
<12> every time someone say try it i give up and move on to something else :-/
<14> Why?
<12> because i have waaay too much to do :)
<14> Do you want your hand held?
<14> ****s to be you.
<12> no no ... i just dont have time to try this week ...
<1> tac: mysql is a lot more accurate than we are when the question is "what does mysql do".
<14> So why work on it now?
<14> You have time to ask on IRC?
<12> mendel: ?
<12> will ... yeah ...
<14> Bad time management.
<15> I am migrating mysql from latin1 to utf-8. I read a post in ubuntu that said I should add some lines to [mysqld], so I did, but now I get an error...
<15> http://pastebin.com/629738
<15> if anyones wants to see
<12> will .. takes me a few seconds to ask in here :0
<15> :(
<12> :) too
<3> i resolve: in /etc/mysql/debian.cnf i put abcd and in users table i put p***word('abcd')... now works fine
<14> Tac_Work, Takes a few seconds to do it in MySQL.
<1> danf: When it told you to look at the syslog, did you?
<8> Tac_Work: more importantly, it will take maybe 5-60 minutes to really understand what you're doing, and it will be incredibly useful for the rest of your life
<14> :)
<12> oh i know these things... i just dont have learning time right now .... ill be back later guys
<14> Yes you do.
<14> We're not here to do the work for you.
<6> oh will got smacked
Return to
#mysql
or
Go to some related
logs:
#css
+vmware tools +firegl +linux
gaim accels esc
dont use mandriva
ubuntu stop the xserver
#ubuntu
who to set root password for mysql in fedora care 4
#linux
#python
iptables + bad arguments
|
|