#mysql
21 October 2007
Total 22 pages. You are browsing page 3/22.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
00:35 <****> sivik: Change that user.
00:35 <****> my.cnf says user=sivik
00:35 <****> should be user=mysql
00:35 <****> under mysqld
00:36 <****> The command line option must be ignored in this case. That's not normal behavior. Maybe mysqld maps to a shell script.
00:36 <****> just changed it
00:36 <****> sivik_: type which mysqld
00:36 <****> /usr/sbin/mysqld
00:36 <****> Strange.
00:36 <****> sivik_: file /usr/sbin/mysqld
00:38 <****> http://pastebin.com/m30469b0e
00:38 <****> oh well. try to start with /etc/init.d/mysql start
00:38 <****> that's the binary alright
00:38 <****> or someone went overboard with a shell script : )
00:38 <****> sivik: Same error on start?
00:38 <****> yes
00:38 <****> [fail]
00:39 <****> sivik_: try the mysqld --user=mysql again
00:39 <****> sivik: lsof can help you identify which absolute path is involved. I still think you could be accessing some strange pase directory that you have no access to.
00:39 <****> How do I install mysqli extension when compiling mysql from source?
00:39 <****> s/pace/base/
00:41 <****> cmanns: mysqli is php related. not related to the mysqld
00:41 <****> this is pissing me off, konsole is not coping for some reason, will xterm copy?
00:41 <****> ah
00:41 <****> will xterm copy? and if so, how?
00:41 <****> Still, mysqli requires mysql_config, I don't have that file :S
00:42 <****> cmanns: it requires client libraries yes
00:42 <****> How do I get the client libraries?
00:42 <****> ohh don't I have to install something else ?
00:42 <****> will xterm copy text?
00:43 <****> cmanns: what OS/distro are you using?
00:43 <****> chadmaynard, http://pastebin.com/m335e4394
00:43 <****> Centos but I used source mysql (I did it before just forgot how to get mysql client)
00:43 <****> centos blows
00:44 <****> i hate how you have to configure multiple files to do one thing
00:44 <****> thank you for your contribution sivik
00:44 <****> cmanns, yw
00:44 <****> cmanns: you can yum install everything easily. no point in compiling
00:44 <****> I like centos
00:44 <****> Unfortunitly its not my server so the os choice isnt mine
00:44 <****> sivik: mysqld --user=mysql
00:44 <****> chadmaynard, meh I already compiled it, less use of yum pleases me
00:44 <****> cmanns, i know how that goes, we have a whole bunch of them at work and i hate it
00:45 <****> chadmaynard, a bunch of output and then an error
00:45 <****> i lock some tables from write, but i did use a select mysql statemen and it showed me an error
00:45 <****> sivik: you know the drill, i need to read it
00:45 <****> i just lock that table too
00:45 <****> http://pastebin.com/m663009f1
00:45 <****> and it works
00:45 <****> but why?
00:46 <****> if i use LOCK i must LOCK all the tables i am about to use even if im not going to write in all of them?
00:46 <****> sivik_: how did you install?
00:46 <****> via apt-get
00:46 <****> sivik: Run lsof in continuous mode and then attempt to start mysqld. Then stop lsof and show the output.
00:46 <****> how do i do that Xgc
00:46 <****> sivik: Not sure offhand. It's been a while since I did that.
00:47 <****> sivik: Should be a simple option.
00:47 <****> I would look but I don't have lsof
00:47 <****> lol
00:47 <****> i'm looking
00:47 <****> i am getting an error "lock wait timeout exceeded" when trying to delete a complex structure from db (i am removing "machine" from machines table and there are a lot of tables holding large amounts of data referencing that table), what can i do to make this work ?
00:48 <****> I looked through ./configure --help, can't find a option for client, looks like its installed by default :S
00:48 <****> if i use LOCK TABLES i need to add all the tables even if i just need to read from one of them?
00:48 <****> poncha: wait?
00:48 <****> Oh shi, i did it again I forgot to make && make install :(
00:48 <****> chadmaynard: wait for what? mysqld rolls back transaction and fires an error
00:48 <****> cmanns: if you install the server the client is installed.
00:48 <****> poncha: oh.
00:49 <****> Whats ../depcomp: line 512: exec: g++: not found
00:49 <****> Never had that on a centos box before :/
00:49 <****> poncha: what has it locked?
00:49 <****> i dont know.. i am not doing locks personally... all i did is "delete from machines where machine_id=32"
00:50 <****> it's about internal locking i guess
00:50 <****> poncha: you could try to acquire the lock before running the transaction i suppose.
00:50 <****> lock tables read?
00:50 <****> that's stop everything else from using them
00:51 <****> yeah
00:51 <****> that'd**
00:51 <****> Is this a help channel by any chance?
00:51 <****> Manacit: sometimes : )
00:51 <****> Manacit, yes
00:51 <****> alright
00:51 <****> sivik: where are we on your problem?
00:51 <****> sivik: See: +/-r modes
00:52 <****> I'm trying to INSERT INTO woot (Item, Price, Condition, Date, Category, Shipping) VALUES('Targus 90 Watt Universal Notebook AC Adaptor', '$14.99', 'Refurbished','1192920893', 'woot', '+ $5 shipping'); but it keeps erroring on me
00:52 <****> all of my feilds are varchar
00:52 <****> how does that one work Xgc
00:52 <****> Manacit: the error is:
00:52 <****> chadmaynard, looking at the lsof and trying to figure out how to do the lsof
00:52 <****> sivik: Use -r option.
00:52 <****> ok
00:52 <****> sivik: That will run until you interrupt it (^c).
00:52 <****> ok
00:53 <****> then run mysql --user=mysql?
00:53 <****> sivik: Yes. Be sure to capture the output. There may be quite a bit.
00:53 <****> Xgc is going to review it all
00:53 * chadmaynard hehe's
00:54 <****> http://pastebin.com/m1d15f911
00:54 <****> sivik: There are ways to limit the output to mysqld related accesses. That's probably not important. We can sift through the mess.
00:54 <****> mysqld not mysql
Total 22 pages. You are browsing page 3/22.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last