Re: MySQL on Darwin (Mac OS X 10.2) grant problem
2. Grants aren't working. Almost for each db we have the grant I did is something like : grant all on db.* to 'user'@'%.domain.com' identified by 'password'; So, I end up with a user with no global privilege in the user table, and a entry in the db table with all privs. User table : '%.domain.com', user, pass, N for the rest, exept Lock_tables_priv is Y. Db table : '%.domain.com', db, user, Y for the rest. When users connect from the web server (another machine), they can connect to the mysql server, but they can't do anything. We get : select command denied to user: '[EMAIL PROTECTED]' for table 'table' Have one of these users connect and issue this statement: SELECT CURRENT_USER(); If the username part of the result value is empty (nothing before the '@' character), you probably have a problem of these users actually being authenticated using an anonymous-user account. Dump those accounts by connecting to the server as root and issuing these statements: mysql DELETE FROM mysql.user WHERE User = ''; mysql FLUSH PRIVILEGES; Then have the user try again. I get something like : [EMAIL PROTECTED], which fits the user in the user and db table. I suppose it's right... Also, I want to point out that those exacts same privs where working right on my intel box... Any new hints on this ? Nicolas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL on Darwin (Mac OS X 10.2) grant problem
Hi ! Our normal server is on RedHat 7.3 / mysql-max 4.0.14. The server just crached, I had to recover on another hardware, a Mac OS X 10.2, wih mysql-max 4.0.15. The restore went well, but I have some problems : 1. All tables/database are now lower case. This not a major issue, as the dbs are still running ok. I'll handle it later when the intel server is back up again. 2. Grants aren't working. Almost for each db we have the grant I did is something like : grant all on db.* to 'user'@'%.domain.com' identified by 'password'; So, I end up with a user with no global privilege in the user table, and a entry in the db table with all privs. User table : '%.domain.com', user, pass, N for the rest, exept Lock_tables_priv is Y. Db table : '%.domain.com', db, user, Y for the rest. When users connect from the web server (another machine), they can connect to the mysql server, but they can't do anything. We get : select command denied to user: '[EMAIL PROTECTED]' for table 'table' If we connect as root, the select is working properly. It's not the host either, I tried with % as hosts, and it didn't work. Any hints ? Nicolas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on Darwin (Mac OS X 10.2) grant problem
At 11:30 -0400 10/14/03, Nicolas Ross wrote: Hi ! Our normal server is on RedHat 7.3 / mysql-max 4.0.14. The server just crached, I had to recover on another hardware, a Mac OS X 10.2, wih mysql-max 4.0.15. The restore went well, but I have some problems : 1. All tables/database are now lower case. That's because HFS+ filesystems on Mac OS X are not case sensitive. The server runs with lower_case_table_names on by default on Mac OS X as a result. This not a major issue, as the dbs are still running ok. I'll handle it later when the intel server is back up again. 2. Grants aren't working. Almost for each db we have the grant I did is something like : grant all on db.* to 'user'@'%.domain.com' identified by 'password'; So, I end up with a user with no global privilege in the user table, and a entry in the db table with all privs. User table : '%.domain.com', user, pass, N for the rest, exept Lock_tables_priv is Y. Db table : '%.domain.com', db, user, Y for the rest. When users connect from the web server (another machine), they can connect to the mysql server, but they can't do anything. We get : select command denied to user: '[EMAIL PROTECTED]' for table 'table' Have one of these users connect and issue this statement: SELECT CURRENT_USER(); If the username part of the result value is empty (nothing before the '@' character), you probably have a problem of these users actually being authenticated using an anonymous-user account. Dump those accounts by connecting to the server as root and issuing these statements: mysql DELETE FROM mysql.user WHERE User = ''; mysql FLUSH PRIVILEGES; Then have the user try again. If we connect as root, the select is working properly. It's not the host either, I tried with % as hosts, and it didn't work. Any hints ? Nicolas -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on Darwin (Mac OS X 10.2) grant problem
2. Grants aren't working. Almost for each db we have the grant I did is something like : grant all on db.* to 'user'@'%.domain.com' identified by 'password'; So, I end up with a user with no global privilege in the user table, and a entry in the db table with all privs. User table : '%.domain.com', user, pass, N for the rest, exept Lock_tables_priv is Y. Db table : '%.domain.com', db, user, Y for the rest. When users connect from the web server (another machine), they can connect to the mysql server, but they can't do anything. We get : select command denied to user: '[EMAIL PROTECTED]' for table 'table' Have one of these users connect and issue this statement: SELECT CURRENT_USER(); If the username part of the result value is empty (nothing before the '@' character), you probably have a problem of these users actually being authenticated using an anonymous-user account. Dump those accounts by connecting to the server as root and issuing these statements: mysql DELETE FROM mysql.user WHERE User = ''; mysql FLUSH PRIVILEGES; Then have the user try again. I get something like : [EMAIL PROTECTED], which fits the user in the user and db table. I suppose it's right... Also, I want to point out that those exacts same privs where working right on my intel box... Thanks Nicolas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mac OS X 10.2 ?
On Sat, 28 Dec 2002 15:40:37 -0500, Richard Nagle wrote: try to get back into mysql, no luck can see mysqld is still running. how does one get back in ? At the prompt, type: mysql -u root -p And you will be prompted for the password to your mysql root-account. That's it. ~/j -- // Jonas C. Voss // http://verture.net/ // - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mac OS X 10.2 ?
just install 3.23.53 for ( Mac OS X 10.2 ) from: www.entropy.ch/software/macosx/mysql all went well, saw prompt mysql type command: show database, saw test, and mysql database did a \q (quit) exit okay, AND THEN ! try to get back into mysql, no luck can see mysqld is still running. how does one get back in ? Anyone, Thanks in Advance Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqladmin -f forgets -u user on Mac OS X 10.2
Description: mysqladmin -f -u bugs drop gdr_bugs fails with error: 'Access denied for user: '@localhost' to database 'gdr_bugs'' even though user bugs has access. Omitting the -f option makes it work. Somehow, the -f option is making mysqladmin forget the user. This occurs on Mac OS X 10.2.1, but not on FreeBSD 4.7 with 3.23.52. How-To-Repeat: Grant user bugs access to gdr_bugs.*, then mysqladmin -f -u bugs drop gdr_bugs Fix: Submitter-Id: [EMAIL PROTECTED] Originator:[EMAIL PROTECTED] Organization: Ravenbrook Limited MySQL support: none Synopsis: mysqladmin -f forgets -u user on Mac OS X 10.2 Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.53 (Official MySQL binary) Server: /usr/local/bin/mysqladmin Ver 8.23 Distrib 3.23.53, for apple-darwin6.1 on powerpc Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.53 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 1 hour 16 min 56 sec Threads: 2 Questions: 135 Slow queries: 0 Opens: 9 Flush tables: 1 Open tables: 4 Queries per second avg: 0.029 Environment: I can send full Apple System Profiler output if desired -- please ask. System: Darwin skylark.ravenbrook.com 6.1 Darwin Kernel Version 6.1: Fri Sep 6 23:24:34 PDT 2002; root:xnu/xnu-344.2.obj~2/RELEASE_PPC Power Macintosh powerpc Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/libexec/gcc/darwin/ppc/3.1/specs Thread model: posix Apple Computer, Inc. GCC version 1151, based on gcc version 3.1 20020420 (prerelease) Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Sep 23 13:15 /usr/lib/libc.dylib - libSystem.dylib Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-local-infile --disable-shared --without-innodb CC=gcc 'CFLAGS=-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' CXX=gcc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Bug] compile problem on Mac OS X 10.2
A number of people have asked about this, and some have figured it out and posted info somewhere, but not in the www.mysql.com docs. Perhaps, I need to report it on this list for it to get into a distro, yes? In configure, there is a bit that starts at line 7514: *darwin*) if test $ac_cv_c_compiler_gnu = yes then CFLAGS=$CFLAGS -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_ BREAK_READ -DHAVE_BROKEN_REALPATH CXXFLAGS=$CXXFLAGS -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_D ONT_BREAK_READ MAX_C_OPTIMIZE=-O with_named_curses= fi ;; Change: with_named_curses= to: with_named_curses=-ltermcap ... and then it builds. Voila! Note, this is for Mac OS X 10.2, and not earlier Mac OS X systems. thanx - ray - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bug with stopping mysql 3.23.52 on Mac OS X 10.2 ?
Hi (I tried posting this to bugs@lists, but got rejected..), I have a brand new installation of Mac OS X 10.2 (client), with the developer tools (including the August 2002 Dev Tools update). Using the system's gcc 3.1, I compiled mysql 3.23.52 with: /configure --prefix=/usr/local/mysql And everything compiles and runs fine (as far as I can tell). However, I cannot seem to send a signal that will cleanly shutdown mysql. It ignores SIGTERM. There is no output in the error log whatsoever. SIGKILL (and other) signals work, fine, but not TERM. Is this an OS X issue or a mysql one? I have gotten around it by using the mysqladmin and the root password, but I'd rather not have the password in the StartupItem script. Any help you can give on this will be appreciated... thanks, adam arrowood [EMAIL PROTECTED] -- Adam Arrowood || http://www.gatech.edu/adam || [EMAIL PROTECTED] Office of Information Technology/OE/CS Georgia Institute of Technology, Atlanta, GA USA (404) 894-0372 work || (404) 310-0108 cell - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Won't compile on Mac OS X 10.2
Dear Sir, MySQL 3.23.52 won't compile on Mac OS X 10.2 based on Darwin 6.0 which comes pre-installed with gcc 3.1 I don't want to uninstall it as it would probably bring down other major functions of the new system. Regards, Mitch Leung -- __ __ __ __ _ _ Mitch Leung ( \/ )( )(_ _)( _)| |_| | mailto:[EMAIL PROTECTED] )( )( )( ((_ | _ | http://www.mitchleung.com/ (_/\/\_)(__) (__) (__)|_| |_| +852 9361-6984 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Won't compile on Mac OS X 10.2
I got MySQL 4.0.2-alpha compiled on Mac OS X 10.2 (final version - Jaguar6C115). I am having problems with getting any client to connect to it, so perhaps I am doing something else wrong, which is possible since I am new to MySQL First I tried: ./configure --with-named-curses-libs=/usr/lib/libncurses.dylib This did not work. Then I manually executed the one compile that was failing, adding the libncurses.dylib to the list of libraries to use, as such: g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_ VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -o mysql mysql.o readline.o sql_string.o completion_hash.o ../ readline/libreadline.a ../libmysql/.libs/libmysqlclient.a /usr/lib/libncurses.dylib -lz -lm -lz -lm Then I did a make again and everything went along to the end. For some reason my client sub-directory did not get re-named to bin and, as I said, I cannot connect. Keep getting: % mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ... so I may have messed something up. Maybe someone else, with more experience with installing, can pick the ball up and move it along... thanx - ray On Sunday, August 25, 2002, at 05:39 PM, Mitch Leung wrote: Dear Sir, MySQL 3.23.52 won't compile on Mac OS X 10.2 based on Darwin 6.0 which comes pre-installed with gcc 3.1 I don't want to uninstall it as it would probably bring down other major functions of the new system. Regards, Mitch Leung - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Won't compile on Mac OS X 10.2
For some reason my client sub-directory did not get re-named to bin and, as I said, I cannot connect. Keep getting: % mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) The one time I got MySQL running under Mac OS X (10.1), I had to mkdir the socket directory and chown/chmod by hand. I think I also built the bin structure by hand, as well, don't remember why. You might try that, just to see. -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Won't compile on Mac OS X 10.2
On 8/25/02 11:36 PM, Joel Rees [EMAIL PROTECTED] wrote: For some reason my client sub-directory did not get re-named to bin and, as I said, I cannot connect. Keep getting: % mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) You might want to take a look at: http://www.entropy.ch/software/macosx/mysql/ Some very helpful information there. BTW, I have MySQL running on 10.2 as we speak. -Calvin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem: MySQL Client Mac OS X 10.2 (Jaguar: Build 6C106)
On 26/7/02 6:07 pm, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Binary builds often break when tried with a newer version of Mac OS X than the one they were built on. Can you try building from source? I tried building with the following configure options: ./configure --without-server --prefix=/usr/local/mysql All goes well. However when I try to 'make' it fails with the following error: g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -o mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a ../libmysql/.libs/libmysqlclient.a -lz -lm -lz -lm ld: Undefined symbols: _tgoto _tputs _tgetent _tgetflag _tgetnum _tgetstr make[2]: *** [mysql] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive-am] Error 2 This is using the Build 6C106 Developer Tools. I'm afraid I don't have a clue as to what the problem is but maybe some one else who knows a bit more may be able to shed some light on the situation. Cheers, Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem: MySQL Client Mac OS X 10.2 (Jaguar: Build 6C106)
Hi, Is anybody else having a problem using the MySQL client with Mac OS X 10.2 (Jaguar: Build 6C106)? When I try to connect to the server on 'localhost' I get the following: dyld: ./bin/mysql Undefined symbols: ./bin/mysql undefined reference to _BC expected to be defined in /usr/lib/libSystem.B.dylib ./bin/mysql undefined reference to _PC expected to be defined in /usr/lib/libSystem.B.dylib ./bin/mysql undefined reference to _UP expected to be defined in /usr/lib/libSystem.B.dylib Trace/BPT trap If I then try to connect to the same server from another machine I get the following: ERROR 2003: Can't connect to MySQL server on server ip address (61) A socket problem of some sort??? The strange thing is I can connect using 'phpMyAdmin' without a problem from both machines. Just for the record I'm using binary of MySQL 3.23.51 obtained from http://www.entropy.ch. Any ideas? Cheers, Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem: MySQL Client Mac OS X 10.2 (Jaguar: Build 6C106)
At 13:24 +0100 7/26/02, Ian Fieldhouse wrote: Hi, Is anybody else having a problem using the MySQL client with Mac OS X 10.2 (Jaguar: Build 6C106)? When I try to connect to the server on 'localhost' I get the following: dyld: ./bin/mysql Undefined symbols: ./bin/mysql undefined reference to _BC expected to be defined in /usr/lib/libSystem.B.dylib ./bin/mysql undefined reference to _PC expected to be defined in /usr/lib/libSystem.B.dylib ./bin/mysql undefined reference to _UP expected to be defined in /usr/lib/libSystem.B.dylib Trace/BPT trap If I then try to connect to the same server from another machine I get the following: ERROR 2003: Can't connect to MySQL server on server ip address (61) A socket problem of some sort??? The strange thing is I can connect using 'phpMyAdmin' without a problem from both machines. Just for the record I'm using binary of MySQL 3.23.51 obtained from http://www.entropy.ch. Binary builds often break when tried with a newer version of Mac OS X than the one they were built on. Can you try building from source? Any ideas? Cheers, Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
