| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
<matt_> all the unix stuff dosn't touch any smb atall
<c0rni> Hi, I've got a problem with mysql 4.1 and freebsd5.4, I described it here http://www.bsdforums.org/forums/showthread.php?t=35760 cause it's not really easy to explain. If someone can help me... :)
<_k> corni: Have you checked the typical issues? locking, slow queries, threads, etc?
<c0rni> I've got lots of slow queries but I don't really know how to solve this issue
<c0rni> I don't understand why mysql is not caching more
<Equinox> I'm having a lot of trouble setting lower case table names.. Even set in the command line resulERROR 1193 (HY000): Unknown system variable 'lower_case_table_names'ts in:
<Equinox> I'm also finding stuff on the web about others having issues.
<Equinox> mysql> set @@global.lower_case_table_names=2;
<Equinox> ERROR 1193 (HY000): Unknown system variable 'lower_case_table_names'
<Equinox> .. Anyone have any clue where to find out why it's doing this? The manual says it should work.(doesn't work in my.cnf either.)
<EricB`> one at a time guys
<EricB`> c0rni, key buffer size is a good one to increase
<EricB`> only don't increase it too far
<dammit> Equinox: you can really start mysql with --lower-case-table-names=..
<dammit> c0rni: fight each slow query
<dammit> until there're none..
<EricB`> Equinox, http://dev.mysql.com/doc/refman/4.1/en/name-case-sensitivity.html
<EricB`> hi dammit
<dammit> hey EricB`
<dammit> what's cooking? :)
<c0rni> EricB`: I'll try to increase it so
<Equinox> EricB` -- mysqld_safe --user=mysql --lower-case-tables-names=2 should work?
<c0rni> dammit: bah the pb is that i'm just the sysadmin of the server, not the developper. i'm a big mysql noob
<c0rni> dammit: but thanks anyway i'll try to optimize the slow queries, i've got all of them in a logfile
<dammit> c0rni: you can beat developers.
<Equinox> How do I see if mysql is producing errors from my my.cnf?
<EricB`> the error log
<Equinox> Got it.. Apparently =2 is a no-no on a case sensitive file system.
<EricB`> makes sense
<Cicciux> hey
<Cicciux> I'm having doubts with a multiple join...
<Cicciux> when I have three tables, and I need to join all three of them, the query I use would be something like
<Cicciux> SELECT a.col1,b.col2,c.col3 FROM a AS table_a INNER JOIN table_b AS b INNER JOIN table_c AS c ON MATCH (id) AGAINST (id)? ***uming all the tables have the id col?
<Keithamus> Yo, anyone available to help me out please?
<Cicciux> don't know If I'll be able to... but ask away.
<Keithamus> erm, well its kind of long winded but here goes:
<Keithamus> Basically, I have an apache server setup on my home computer, along with PHP and mysql. The problem is I cant seem to connect to any MYSQL database.
<Keithamus> I beleive
<Keithamus> And I need 4.1+ to authenticate with the new 32 bit p***words. no?
<Keithamus> So yea, basically my question is, how do I fix this?
<Keithamus> Im using ubuntu-breezy btw.
<MHillyer> http://www.openwin.org/mike/index.php/faq/mysql/error-client-does-not-support-authentication-protocol-requested/
<Cicciux> ehm..... what version of mysql do you have installed?
<Keithamus> Well its a bit here and there.
<Keithamus> PHP mysql wise, I have 4.0.24.
<MHillyer> http://www.openwin.org/mike/index.php/faq/mysql/error-client-does-not-support-authentication-protocol-requested/
<Keithamus> Yes I am reading that.
<Keithamus> what I am confused about is.
<Keithamus> I have a paid for hosting account.
<Keithamus> on which it has its mysql db
<Keithamus> and it uses the non MsqlI (so mysql) php libraries.
<Keithamus> so surely it is also using the old p***words?
<MHillyer> Yes indeedy.
<Keithamus> if so, then surely, if I use the non mysqli libraries
<Keithamus> I should be able to connect to the db on the hosting space.
<MHillyer> Not necesscarily.
<Keithamus> Care to elaborate?
<MHillyer> This depends on factors such as firewalls, whether they custom compiled PHP against MySQL 4.1+, their version of PHP, etc etc etc
<Keithamus> hmm
<Keithamus> ok, let me simplify matters (hopefully)
<Keithamus> I had an old windows system, running PHP5 locally, which could connect to the database using the provided mysql libraries.
<_k> Hi Mike.
<Keithamus> now in linux, using the exact same code, I cant.
<MHillyer> Hey K
<MHillyer> Keithamus: So, what is different about the Linux system?
<Keithamus> I wish I knew.
<Keithamus> Im use(d) apache2 on both windows and linux
<Keithamus> erm, PHP4 on nix, but PHP5 on doze.
<MHillyer> Well my mysterious psycic powers are on the fritz, so I cannot tell you.
<Keithamus> exact same php code.
<MHillyer> Aah..
<MHillyer> Perhaps it is time to use PHP 5 on Linux.
<Keithamus> Well, thats just it
<Keithamus> I was using 5
<Keithamus> but I downgraded hoping to fix this problem.
<Keithamus> I cant seem to find "msqli.so" for love nor money, its not in apt-get repositories, and i havent found it while googling.
<MHillyer> Ok, so did you compile on linux against the MySQL libraries? WHat is your MySQL version on the linux box?
<Keithamus> Erm
<Keithamus> I havent compiled it, I isntalled it from the repositories.
<Keithamus> but erm, the server and client are 4.1
<MHillyer> This is why I do not like RPMs ;)
<Keithamus> although, i did try 4.0.something to see if that would cure it.
<Keithamus> lol, there not RPMs, they are DEBs
<MHillyer> This is why I do not like packages.
<MHillyer> Better?
<Keithamus> lol
<Darien> better
<Darien> when I want to custom-compile something, I custom-compile my debian packages
<Darien> then mark them as hold so they don't get overwritten
<Keithamus> I really am confused as to why I had no problems on either PHP4 or 5 on windows, but seem to have problems with both on linux.
<MHillyer> Because Windows is t3h r0xx0r!
<Keithamus> LOL
<Darien> omg teh windaws
<Keithamus> this is the thing, if I use the code "mysql_connect(...." on my payed for webserver.
<Keithamus> it works, both on the paid for mysql dbs, and the ones hosted on my compute.r
<Keithamus> using that code over here, locally, however, doesnt seem to want to connect to either.
<Keithamus> well..
<Keithamus> ive had enough of pulling my hair out for the day.
<Keithamus> thanks everyone for your help.
<EricB`> :)
<Keithamus> im going to go and get some grub. cya.
<CPUnerd_> Darien, I got the funds
<CPUnerd_> hehe
<Darien> nice
<Darien> got the hookupz
<CPUnerd_> haha
<CPUnerd_> now time for the chicks to fall ;-)
<EricB`> haha
<Darien> flash that cash and they'll fall at your feet, baby
<MHillyer> !weather cyql
<SQL> Current conditions at Lethbridge, Alta., Canada: It is 8 C (48 F), windspeed is 12.87 km/h, and visibility is 32.19 km. (Information current as of 2005.10.22 1900 UTC).
<sunshine82> i need to rest my root p***word havin problem with this website can someone please this website http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
<sunshine82> read the website and tell me what i am doin wrong i cna t kill
<EricB`> what?
<EricB`> no
<sunshine82> ericb are u talkkin to me
<EricB`> yes
<EricB`> you want someone to read a website and tell you what you're doing wrong?
<sunshine82> yea the one above
<EricB`> if you can't follow instructions on a website you can't follow them in a chat room
<sunshine82> im havin proble with the kill `cat /mysql-data-directory/host_name.pid`
<EricB`> ok
<EricB`> what's the problem?
<sunshine82> i put myssqld as the host mane it still does not work
<EricB`> are you only running one instance of mysqld?
<sunshine82> ericb im listenin to the instruction the best i can but im gettin error
<EricB`> did you change mysql-data-directory to the path of your actual data directory?
<sunshine82> yea i change it to kill `cat /var/run/mysqld/mysqld.pid`
<EricB`> what's the error?
<sunshine82> permission denied
<EricB`> ok you need to run that as root or the mysql user
<sunshine82> with sudo i tried it it still say permission denied
<EricB`> sudo kill `sudo cat
<sunshine82> sudo kill cat
<sunshine82> ...
<EricB`> do like I do
<EricB`> sudo kill `sudo cat
<EricB`> sudo kill `sudo cat /var/run/mysqld/mysqld.pid`
<sunshine82> ok that seem to have worked now when i put in mysql -u root it say Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<sunshine82> i've tried it with sudo
<EricB`> because mysql is not running
<EricB`> follow the rest of the instructions
<sunshine82> i did
<sunshine82> it said stop the restart it with mysqld --skip-grant-tables --user=root which i have done
<EricB`> ok check the error file to see why it didn't start
<sunshine82> hold on when i put in mysqld --skip-grant-tables --user=root it said Warning: Ignoring user change to 'root' because the user was set to 'mysql' earl ier on the command line
<sunshine82> ericb do u know how to fix that
<Kinkew> is there any way to lock an entire database (ie. all tables within the database) without actually doing a LOCK TABLES on every table?
<sunshine82> it also say Do you already have another mysqld server running on socket: /va r/run/mysqld/mysqld.sock ?
Return to mysql
or
Go to some related
logs:
beginner
|
|