MySQL v5.5.12 on Mac OSX - Server won't start...
I have installed MySQL v5.5.12 Community Server on Mac OS X v10.5.8 When I try and start the server I get these messages before it aborts... 110514 17:16:14 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 110514 17:16:16 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110514 17:16:17 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110514 17:16:17 [Note] Plugin 'FEDERATED' is disabled. /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist 110514 17:16:17 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 110514 17:16:17 InnoDB: The InnoDB memory heap is disabled 110514 17:16:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110514 17:16:17 InnoDB: Compressed tables use zlib 1.2.3 110514 17:16:17 InnoDB: Initializing buffer pool, size = 128.0M 110514 17:16:17 InnoDB: Completed initialization of buffer pool 110514 17:16:17 InnoDB: highest supported file format is Barracuda. 110514 17:16:19 InnoDB: Waiting for the background threads to start 110514 17:16:20 InnoDB: 1.1.6 started; log sequence number 1595675 110514 17:16:20 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'default-character-set=utf8' 110514 17:16:20 [ERROR] Aborting 110514 17:16:20 InnoDB: Starting shutdown... 110514 17:16:21 InnoDB: Shutdown completed; log sequence number 1595675 110514 17:16:21 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 110514 17:16:21 mysqld_safe mysqld from pid file /usr/local/mysql/data/x.local.pid ended Anybody point me towards where I can get this issue sorted... Googling didnt turn up much ... TIA Rich
Re: MySQL v5.5.12 on Mac OSX - Server won't start...
Am 14.05.2011 17:32, schrieb rich gray: I have installed MySQL v5.5.12 Community Server on Mac OS X v10.5.8 When I try and start the server I get these messages before it aborts... 110514 17:16:14 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 110514 17:16:16 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 110514 17:16:17 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 110514 17:16:17 [Note] Plugin 'FEDERATED' is disabled. /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist 110514 17:16:17 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 110514 17:16:17 InnoDB: The InnoDB memory heap is disabled 110514 17:16:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110514 17:16:17 InnoDB: Compressed tables use zlib 1.2.3 110514 17:16:17 InnoDB: Initializing buffer pool, size = 128.0M 110514 17:16:17 InnoDB: Completed initialization of buffer pool 110514 17:16:17 InnoDB: highest supported file format is Barracuda. 110514 17:16:19 InnoDB: Waiting for the background threads to start 110514 17:16:20 InnoDB: 1.1.6 started; log sequence number 1595675 110514 17:16:20 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'default-character-set=utf8' 110514 17:16:20 [ERROR] Aborting 110514 17:16:20 InnoDB: Starting shutdown... 110514 17:16:21 InnoDB: Shutdown completed; log sequence number 1595675 110514 17:16:21 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 110514 17:16:21 mysqld_safe mysqld from pid file /usr/local/mysql/data/x.local.pid ended Anybody point me towards where I can get this issue sorted... Googling didnt turn up much ... what about reading the line with error :-) [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'default-character-set=utf8' this is deprecated long ago and with 5.5 no longer supported replace charset/collation default in my.cnf by * character-set-server * collation-server -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm signature.asc Description: OpenPGP digital signature
Securing MySQL on Mac OSX
I am in the process of installing MySQL and PHP on my Mac following instruction in a book written by a chap called David Powers. I have come to a section that is called 'Securing MySQL on Mac OSX'. Basically it states that MySQL is up and running with a default account of 'root' and it's not password protected and so I need to plug that security gap. I've always used root as my account when working on PC's but having read this in David's book, I am now concerned; does this mean that I am open to attack from a potential hacker if I don't password protect MySQL? It mentions that root in MySQL has nothing to do with the root of Mac OSX, but I need to know if MySQL being unprotected in this way has opened a door for hackers. Thanks
Re: Securing MySQL on Mac OSX
It mentions that root in MySQL has nothing to do with the root of Mac OSX, but I need to know if MySQL being unprotected in this way has opened a door for hackers. it means that they can do whatever they want to the mysql db's without being prompted for a password. This does not mean that your box has open root access to the OS but its not good practice to have mysql as open as that -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Newbie First Use Connection Question - Mac OSX 10.5.6
I am brand new to MySQL and JAVA/Netbeans 6.5 so please excuse the stupid questions ... 1. I have just downloaded and successfully installed MySQL v5.1 on my MacBook Pro running OS X 10.5.6 2. I have also downloaded and installed MySQL Tools: Administrator Query Browser (I come from a Visual Basic MS SQL Server 2000/2005 environment) When you install MS SQL server the default login is sa with a blank password. My question is; How do I login (connection settings) to MySQL (for Administrator and Query Browser tools)? (I start my server by going to settings and then MySQL icon, Start Server, so my server is running) Unfortunately, I have never seen MySQL in action nor do I know anyone to ask/show me how to get started.
Re: Newbie First Use Connection Question - Mac OSX 10.5.6
The root Password will be blank after initial install. You can set it at a shell prompt with commands something like this... shell mysql -u root mysql SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd'); mysql FLUSH PRIVILEGES; mysql EXIT; Where newpwd is your desired password. Best to secure or delete all accounts with blank passwords :) You can then start MySQL administrator and log in using the username root, the password you specified in the SET PASSWORD command and the host of localhost. Regards John I am brand new to MySQL and JAVA/Netbeans 6.5 so please excuse the stupid questions ... 1. I have just downloaded and successfully installed MySQL v5.1 on my MacBook Pro running OS X 10.5.6 2. I have also downloaded and installed MySQL Tools: Administrator Query Browser (I come from a Visual Basic MS SQL Server 2000/2005 environment) When you install MS SQL server the default login is sa with a blank password. My question is; How do I login (connection settings) to MySQL (for Administrator and Query Browser tools)? (I start my server by going to settings and then MySQL icon, Start Server, so my server is running) Unfortunately, I have never seen MySQL in action nor do I know anyone to ask/show me how to get started. __ This email has been scanned by Netintelligence http://www.netintelligence.com/email -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Newbie First Use Connection Question - Mac OSX 10.5.6
or as the docs read: shell mysqladmin password your password John Daisley wrote: The root Password will be blank after initial install. You can set it at a shell prompt with commands something like this... shell mysql -u root mysql SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd'); mysql FLUSH PRIVILEGES; mysql EXIT; Where newpwd is your desired password. Best to secure or delete all accounts with blank passwords :) You can then start MySQL administrator and log in using the username root, the password you specified in the SET PASSWORD command and the host of localhost. Regards John I am brand new to MySQL and JAVA/Netbeans 6.5 so please excuse the stupid questions ... 1. I have just downloaded and successfully installed MySQL v5.1 on my MacBook Pro running OS X 10.5.6 2. I have also downloaded and installed MySQL Tools: Administrator Query Browser (I come from a Visual Basic MS SQL Server 2000/2005 environment) When you install MS SQL server the default login is sa with a blank password. My question is; How do I login (connection settings) to MySQL (for Administrator and Query Browser tools)? (I start my server by going to settings and then MySQL icon, Start Server, so my server is running) Unfortunately, I have never seen MySQL in action nor do I know anyone to ask/show me how to get started. __ This email has been scanned by Netintelligence http://www.netintelligence.com/email
unable to change root password on Mac OSX 10.5.2
Dear List, I have installed a binary package mysql-5.0.51a-osx10.5-x86_64.dmg I can start up/shutdown MySQL and connect to MySQL server, but I cant change a root password as required. ---begin example--- e7253:~ olichka$ cd /usr/local/mysql e7253:mysql olichka$ sudo ./bin/mysqld_safe Password: Starting mysqld daemon with databases from /usr/local/mysql-5.0.51a-osx10.5-x86_64/data ^Z [1]+ Stopped sudo ./bin/mysqld_safe e7253:mysql olichka$ bg [1]+ sudo ./bin/mysqld_safe e7253:mysql olichka$ /usr/local/mysql/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.0.51a MySQL Community Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql set password for 'root'@'localhost'=password('password'); ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql' ---end example- I can verify that server is running: ---begin example e7253:mysql olichka$ bin/mysqladmin version bin/mysqladmin Ver 8.41 Distrib 5.0.51a, for apple-darwin9.0.0b5 on i686 Copyright (C) 2000-2006 MySQL 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 5.0.51a Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 4 min 41 sec Threads: 1 Questions: 4 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.014 --end example--- And I can shutdown the server: --begin example- e7253:mysql olichka$ bin/mysqladmin -u root shutdown e7253:mysql olichka$ STOPPING server from pid file /usr/local/mysql-5.0.51a-osx10.5-x86_64/data/e7253.mb.qub.ac.uk.pid 080421 14:57:13 mysqld ended -end example Some tests: -begin example-- e7253:mysql olichka$ bin/mysqlshow ++ | Databases | ++ | information_schema | | test | ++ --end example--- As I understand, when I use a binary package I dont have to initialize the grant tables manually (i.e. mysql_install_db). Hovever as I see above I dont have a mysql db where all granted tables would be installed? I would expect installer to run 'mysql_install_db' for me or not? When I try to log in as a root, so I can change passwords: I get: --begin example-- e7253:/ olichka$ mysql -u root -bash: mysql: command not found -end example Sorry for my ignorance, most probably I am doing something wrong, but I am very new to both MySQL and UNIX. Could you please suggest anything? Thank you in advance, Olga -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: unable to change root password on Mac OSX 10.5.2
Olga Lyashevska wrote: e7253:mysql olichka$ /usr/local/mysql/bin/mysql Try: $ /usr/local/mysql/bin/mysql -u root -p It looks like you aren't logging into MySQL as root, so you don't have permission to set the root password. (If you don't give -u, it uses your OS X short user name as the MySQL user, which probably doesn't exist.) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: unable to change root password on Mac OSX 10.5.2
Dear List, I have solved my problem I think. For some reasons 'alias mysql=/usr/local/mysql/bin/mysql' didnt work for me. When I type '/usr/local/mysql/bin/mysql -u root' I can log in as a root and change password. Later I can log in: '/usr/local/mysql/bin/mysql -u root -p' Thank you, Olga -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Newbie Q- Mac OSX install - login to mysql not working...
(Sorry if this is a duplicate post, email issues w/multiple accts) I have a MacBook Leopard OS 10.5.1 2 GB RAM. I've got a good amount of knowledge of computer systems, but haven't setup or worked with mySQL before. (usually use it preinstalled on my hosting service). I downloaded the package and installed it via the automated setup that comes for the MacOS. It started fine. The MySQL Sys prefs tool shows the status of the server as running. However, I want to now setup Wordpress on my localhost. I need to create a database on mysql. I opened the shell and navigate to the location of mysql. I have been using the instructions as shown below. $ mysql -u adminusername -p Enter password: This is where I'm stuck. No matter what account I use, I am unable to login to the database. My personal account is the only account on the machine, while it's not root, it has full admin privs, and I've tried everything to login, including no password, my account's password, etc. Since I've not activated root on this machine (I understand that Apple, by default disables it), perhaps there's something I'm missing in my lack of knowledge of the way the Mac OS uses root? I'm sure this is a stupid newbie issue, but I'm a bit wrapped around the axle here. Do I need to use sudo? (I've even attempted this with no success). I've searched on a few lists to see if anyone has had this problem, but not seen it yet. Should I just reinstall? Am I just missing something that passed by in install (I don't remember adding a password other than entering the password that I use to admin the machine. Thoughts? Thanks in advance for any help.
Re: Newbie Q- Mac OSX install - login to mysql not working...
On Dec 13, 2007 12:11 PM, Al [EMAIL PROTECTED] wrote: (Sorry if this is a duplicate post, email issues w/multiple accts) I have a MacBook Leopard OS 10.5.1 2 GB RAM. I've got a good amount of knowledge of computer systems, but haven't setup or worked with mySQL before. (usually use it preinstalled on my hosting service). I downloaded the package and installed it via the automated setup that comes for the MacOS. It started fine. The MySQL Sys prefs tool shows the status of the server as running. However, I want to now setup Wordpress on my localhost. I need to create a database on mysql. I opened the shell and navigate to the location of mysql. I have been using the instructions as shown below. $ mysql -u adminusername -p Enter password: This is where I'm stuck. No matter what account I use, I am unable to login to the database. My personal account is the only account on the machine, while it's not root, it has full admin privs, and I've tried everything to login, including no password, my account's password, etc. Since I've not activated root on this machine (I understand that Apple, by default disables it), perhaps there's something I'm missing in my lack of knowledge of the way the Mac OS uses root? I'm sure this is a stupid newbie issue, but I'm a bit wrapped around the axle here. Do I need to use sudo? (I've even attempted this with no success). I've searched on a few lists to see if anyone has had this problem, but not seen it yet. Should I just reinstall? Am I just missing something that passed by in install (I don't remember adding a password other than entering the password that I use to admin the machine. Thoughts? Thanks in advance for any help. No idea about the particulars of OSX, however http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix should work. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem with starting mysql on mac osx 10.4
Hi, I constantly keep receiving this kind of error: mariuszlenks-ibook-g4:~ mariuszlenk$ cd /usr/local/mysql mariuszlenks-ibook-g4:/usr/local/mysql mariuszlenk$ sudo ./bin/mysqld_safe Password: ./bin/mysqld_safe: line 1: ./bin/my_print_defaults: cannot execute binary file ./bin/mysqld_safe: line 1: ./bin/my_print_defaults: cannot execute binary file Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/mariuszlenks-ibook-g4.local.pid 061108 23:28:05 mysqld ended I tried many other tricks, but the installation seems to be solvable by another smart one. Please help me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem installing MySQL on Mac OSX 10.4.3
Those message are kind of odd, even on a messed up system. I would first run the repair privileges in the disk utility for good measure, then delete all traces of MySQL and just start over. MySQL should be in /usr/local/mysql. To remove it just type: sudo rm -R /usr/local/mysql Then try installing again. If you are running OSX Server, things may be a little different. Apple puts MySQL files in different places on there server install as I recall. You may need to poke around a bit to find them. Check /usr/local and also /etc On Dec 2, 2005, at 5:26 PM, Ton Kuypers wrote: Hi, I've downloaded the mysql-max-4.1.15-apple-darwin8.2.0- powerpc.dmg and tried to install it, but I keep on getting the error You cannot continue. There is nothing to install. I've also tried the mysql-max-5.0.16-osx10.4-powerpc.dmg and the mysql-standard-4.1.15-apple-darwin8.2.0-powerpc.dmg, all give the same result... Can anyone help me? I think the previous person using this Mac screwed up some things, I've found traces of mySQL on the system, but I cannot find anything usable anymore. Any help is welcome! warm regards, Ton Kuypers Digital Media Partners bvba Tel. +32 (0)477 / 739 530 Fax +32 (0)14 / 71 03 04 http://www.dmp-int.com -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem installing MySQL on Mac OSX 10.4.3
Hi, I've downloaded the mysql-max-4.1.15-apple-darwin8.2.0-powerpc.dmg and tried to install it, but I keep on getting the error You cannot continue. There is nothing to install. I've also tried the mysql-max-5.0.16-osx10.4-powerpc.dmg and the mysql-standard-4.1.15-apple-darwin8.2.0-powerpc.dmg, all give the same result... Can anyone help me? I think the previous person using this Mac screwed up some things, I've found traces of mySQL on the system, but I cannot find anything usable anymore. Any help is welcome! warm regards, Ton Kuypers Digital Media Partners bvba Tel. +32 (0)477 / 739 530 Fax +32 (0)14 / 71 03 04 http://www.dmp-int.com
Re: Mac OSX Tiger and 64 Bit
On Tue, Jun 29, 2004 at 10:57:41PM -0700, Bruce Dembecki wrote: So I have a question for those who understand developer speak and MySQL builds and so on... Apple announced their new OS earlier this week, including this information on the improvements to 64 Bit version using the G5 processor: http://www.apple.com/macosx/tiger/64bit.html One of our biggest problems to date on our G5 servers is despite the bulk ram we have installed, the current Apple OS isn't really 64 Bit so we can't give the InnoDB caches more than 2Gb of ram, and thus there are always no empty pages. This statement from Apple stops short of saying the OS was fully 64 bit... But I think they are saying that apps such as mysqld will be able to call larger chunks of memory, which is what we want. It sure looks to me like Tiger will remove those limits... Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mac OSX Tiger and 64 Bit
So I have a question for those who understand developer speak and MySQL builds and so on... Apple announced their new OS earlier this week, including this information on the improvements to 64 Bit version using the G5 processor: http://www.apple.com/macosx/tiger/64bit.html One of our biggest problems to date on our G5 servers is despite the bulk ram we have installed, the current Apple OS isn't really 64 Bit so we can't give the InnoDB caches more than 2Gb of ram, and thus there are always no empty pages. This statement from Apple stops short of saying the OS was fully 64 bit... But I think they are saying that apps such as mysqld will be able to call larger chunks of memory, which is what we want. Between MySQL's strong Apple ties and the build engineers working on MySQL binaries and the knowledgeable members of this list can anyone interpret this statement from Apple and tell us if we will be able to increase the InnoDB cache settings to take advantage of the memory in the systems? As our application uses many different databases and any application server only ever speaks to one database I am seriously considering running multiple instances of MySQL on a single machine with different databases - but it's aheadache to administer... I'd rather use my 65 bit hardware and MySQL's 64 bit builds and use the memory in the machine in a single instance... Comments welcome. Best Regards, Bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mac OSX MySQL Client 4.1.1
My Mac mysql client does not appear to work correctly. The DB is fine and setup working great but I cannot use that version of the mysql client. Right now I'm using the 4.0.18 client on my mac. Are there known bugs with the 4.1.1 Mac OSX client? Sam Peterson
Re: Mac OSX MySQL Client 4.1.1
At 9:26 -0600 4/30/04, Sam Peterson wrote: My Mac mysql client does not appear to work correctly. The DB is fine and setup working great but I cannot use that version of the mysql client. Right now I'm using the 4.0.18 client on my mac. Are there known bugs with the 4.1.1 Mac OSX client? Yes: http://bugs.mysql.com/bug.php?id=2058 -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lower_case_table_names, Mac OSX, InnoDB and 4.0.18
There seems to be some issues we are experiencing with this new lower_case_table_names variable introduced in 4.0.17 and modified in 4.0.18. So much so that I can't upgrade to 4.0.18 at all. Here is the startup log from a 4.0.18 mysqld: 040227 02:00:22 mysqld started 040227 2:00:22 Warning: Setting lower_case_table_names=2 because file system for /mysqldata/ is case insensitive InnoDB: Error: tablespace size stored in header is 2438400 pages, but InnoDB: the sum of data file sizes is 256 pages 040227 2:00:23 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections. Version: '4.0.18-standard-log' socket: '/tmp/mysql.sock' port: 3306 040227 2:00:23 InnoDB error: Cannot find table jive_ebay_us/jiveuser from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? Look from section 15.1 of http://www.innodb.com/ibman.html how you can resolve the problem. ERROR: 1016 Can't open file: 'jiveuser.InnoDB'. (errno: 1) 040227 2:00:23 Slave: Error 'Can't open file: 'jiveuser.InnoDB'. (errno:1)' on query 'UPDATE jiveUser SET some user data WHERE some qualifer'. Default database: 'jive_ebay_us', Error_code: 1016 040227 2:00:23 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with SLAVE START. We stopped at log 'binary-log.008' position 781142831 So, let's walk through these... For starters mysqld decides on it's own it will set lower_case_table_names=2 on it's own because file system for /mysqldata/ is case insensitive... Yes, that's true, the file system is case insensitive, it's Mac OSX 10.3. However because we have had issues with this in the 4.0.17 introduction of this feature we have a statement in our my.cnf file which specifically says set-variable= lower_case_table_names=0. Despite us manually telling MySQL that we want it to be case sensitive in all cases it ignores our setting and chooses it's own. Now that it has ignored our request to be case sensitive all of the time for all of the requests we are experiencing problems with InnoDB not recognizing we have tables that we have. Specifically in the error cited above we have a table called jiveUser, that is evident in the way the request is made to to the database to set jiveUser... Yet InnoDB is failing because it can't find jiveuser. So it seems that MySQL has behaved as promised with a lower_case_table_names=2 value and converted the request to lower case... InnoDB however can't find a lower case version of this table. Of course all our table names have upper and lower case characters and this particular entry happened to score the jackpot because it was the first query too come along after we booted 4.0.18. It happens on all our databases, on all our tables. I don't know what we are doing wrong here... Any value of lower_case_table_names results in 4.0.18 not running (OK, it runs, but our applications don't run with it), so we can not upgrade to 4.0.18. MySQL seems to be ignoring our my.cnf startup value for lower_case_table_names and InnoDB seems to be unable to find our tables if MySQL changes the case to lower case. Best Regards, Bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: lower_case_table_names, Mac OSX, InnoDB and 4.0.18
Bruce, I have now filed bug report 2994 about this. Regards, Heikki List:MySQL General Discussion« Previous MessageNext Message » From:Bruce DembeckiDate:February 27 2004 2:01pm Subject:lower_case_table_names, Mac OSX, InnoDB and 4.0.18 There seems to be some issues we are experiencing with this new lower_case_table_names variable introduced in 4.0.17 and modified in 4.0.18. So much so that I can't upgrade to 4.0.18 at all. Here is the startup log from a 4.0.18 mysqld: 040227 02:00:22 mysqld started 040227 2:00:22 Warning: Setting lower_case_table_names=2 because file system for /mysqldata/ is case insensitive InnoDB: Error: tablespace size stored in header is 2438400 pages, but InnoDB: the sum of data file sizes is 256 pages 040227 2:00:23 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections. Version: '4.0.18-standard-log' socket: '/tmp/mysql.sock' port: 3306 040227 2:00:23 InnoDB error: Cannot find table jive_ebay_us/jiveuser from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? Look from section 15.1 of http://www.innodb.com/ibman.html how you can resolve the problem. ERROR: 1016 Can't open file: 'jiveuser.InnoDB'. (errno: 1) 040227 2:00:23 Slave: Error 'Can't open file: 'jiveuser.InnoDB'. (errno:1)' on query 'UPDATE jiveUser SET some user data WHERE some qualifer'. Default database: 'jive_ebay_us', Error_code: 1016 040227 2:00:23 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with SLAVE START. We stopped at log 'binary-log.008' position 781142831 So, let's walk through these... For starters mysqld decides on it's own it will set lower_case_table_names=2 on it's own because file system for /mysqldata/ is case insensitive... Yes, that's true, the file system is case insensitive, it's Mac OSX 10.3. However because we have had issues with this in the 4.0.17 introduction of this feature we have a statement in our my.cnf file which specifically says set-variable= lower_case_table_names=0. Despite us manually telling MySQL that we want it to be case sensitive in all cases it ignores our setting and chooses it's own. Now that it has ignored our request to be case sensitive all of the time for all of the requests we are experiencing problems with InnoDB not recognizing we have tables that we have. Specifically in the error cited above we have a table called jiveUser, that is evident in the way the request is made to to the database to set jiveUser... Yet InnoDB is failing because it can't find jiveuser. So it seems that MySQL has behaved as promised with a lower_case_table_names=2 value and converted the request to lower case... InnoDB however can't find a lower case version of this table. Of course all our table names have upper and lower case characters and this particular entry happened to score the jackpot because it was the first query too come along after we booted 4.0.18. It happens on all our databases, on all our tables. I don't know what we are doing wrong here... Any value of lower_case_table_names results in 4.0.18 not running (OK, it runs, but our applications don't run with it), so we can not upgrade to 4.0.18. MySQL seems to be ignoring our my.cnf startup value for lower_case_table_names and InnoDB seems to be unable to find our tables if MySQL changes the case to lower case. Best Regards, Bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem installing MYSql 4.0.12 on MAC OSX 10.1.3
Hi, I have downloaded MySql-standard-4.0.12 FOR MAC from the MySql website. I have installed it on Mac OS X 10.1.3. When i am starting the MySql, it starts and ends with the message 030821 time MySqld ended. Does anyone know what the problem is ...?? Devang. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem installing MYSql 4.0.12 on MAC OSX 10.1.3
Devang Panchalia [EMAIL PROTECTED] wrote: Hi, I have downloaded MySql-standard-4.0.12 FOR MAC from the MySql website. I have installed it on Mac OS X 10.1.3. When i am starting the MySql, it starts and ends with the message 030821 time MySqld ended. Does anyone know what the problem is ...?? Check error log. (You can find it in the MySQL data dir). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem installing MYSql 4.0.12 on MAC OSX 10.1.3
It may be that you did not give the mysql user ownership of the Data folder? Check your permissions first by typing: [KieranMac:~] kieran% ls -al /usr/local/mysql/ this shold show data folder as something like this: drwxr-x--- 13 mysql wheel 442 Aug 19 19:52 data Type this on the command line to make mysql the owner if it is not the owner: sudo chown -R mysql /usr/local/mysql/data For detailed support, this is a great site: http://www.entropy.ch/software/macosx/mysql/ On Thursday, August 21, 2003, at 07:00 AM, Devang Panchalia wrote: Hi, I have downloaded MySql-standard-4.0.12 FOR MAC from the MySql website. I have installed it on Mac OS X 10.1.3. When i am starting the MySql, it starts and ends with the message 030821 time MySqld ended. Does anyone know what the problem is ...?? Devang. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ___ Kieran Kelleher Palm Harbor, Florida USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mac osx
Hi, I have installed mysql-standard 4.0.13 for Mac OSX10.2. I cannot get the mysql application to work-the files are white and cannot be launched. Any ideas what to do? Regards JB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mac osx
There is no built-in graphically interface for running MySQL. It's all command line, meaning you need to use your terminal. You absolutely must read something on how to use MySQL. There are a lot of good books out there, I used MySQL by Paul DuBois (who is also on this list). MySQL is a database engine, which kind of works like FileMaker Server if you are familiar with that. On Thursday, June 19, 2003, at 02:14 PM, 4mula design wrote: Hi, I have installed mysql-standard 4.0.13 for Mac OSX10.2. I cannot get the mysql application to work-the files are white and cannot be launched. Any ideas what to do? Regards JB -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mac osx
There are some good Mac clients to access MySQL. I personally use CocoaMySQL for much of my day to day activity. You can find them all on versiontracker.org. YourSQL looks okay too. I agree though, the fancy interface, should you choose to use one of the above clients, is much more useful if you know some basics about how MySQL and Databases in general work. (Not assuming you don't, you may.) You'll need to use Terminal anyway to start the MySQL daemon. Marc Liyanage has some good documentation on MySQL on OS X. http://www.entropy.ch/software/macosx/mysql/ I followed his instructions and it works beautifully on my machine. On Thursday, June 19, 2003, at 03:31 PM, Brent Baisley wrote: There is no built-in graphically interface for running MySQL. It's all command line, meaning you need to use your terminal. You absolutely must read something on how to use MySQL. There are a lot of good books out there, I used MySQL by Paul DuBois (who is also on this list). MySQL is a database engine, which kind of works like FileMaker Server if you are familiar with that. On Thursday, June 19, 2003, at 02:14 PM, 4mula design wrote: Hi, I have installed mysql-standard 4.0.13 for Mac OSX10.2. I cannot get the mysql application to work-the files are white and cannot be launched. Any ideas what to do? Regards JB -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
OT - Of interest to Mac OSX users.
Hi all, Of interest to Mac OSX users. http://www.aaronfaby.com/mysql.php Contains everything you'll need to get MySQL installed and working on OSX. He also has installers for Apache and PHP (http://www.aaronfaby.com/). Goodness, I wasted days getting MySQL installed originally but using his package I had it all installed in less then 30 minutes. Sorry for the intrusion. Respect Brynley - 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
Failed Config on Mac OSX
This is my first time installing MySQL. I'm attempting to install MySQL on my Apple PowerBook G4 OSX 10.2. After downloading and unpacking mysql-3.23.53.tar.gz, my attempt to run ./configure failed. I'm including content from config.log, any help you might have would be appreciated. configure:1047: PATH=.;.; conftest.sh ./configure: conftest.sh: command not found configure:1050: $? = 127 configure:1090: checking build system type configure:1108: result: powerpc-apple-darwin6.0 configure:1118: checking host system type configure:1132: result: powerpc-apple-darwin6.0 configure:1142: checking target system type configure:1156: result: powerpc-apple-darwin6.0 configure:1185: checking for a BSD compatible install configure:1234: result: /usr/bin/install -c configure:1245: checking whether build environment is sane configure:1263: result: yes configure:1278: checking whether make sets ${MAKE} configure:1302: result: no configure:1326: checking for working aclocal configure:1333: result: found configure:1341: checking for working autoconf configure:1352: result: missing configure:1356: checking for working automake configure:1363: result: found configure:1371: checking for working autoheader configure:1382: result: missing configure:1386: checking for working makeinfo configure:1393: result: found configure:1476: checking whether to enable maintainer-specific portions of Makefiles configure:1485: result: no configure:1498: checking whether build environment is sane configure:1516: result: yes configure:1519: checking whether make sets ${MAKE} configure:1543: result: no configure:1588: checking for mawk configure:1614: result: no configure:1588: checking for gawk configure:1614: result: no configure:1588: checking for nawk configure:1614: result: no configure:1588: checking for awk configure:1603: found /usr/bin/awk configure:1611: result: awk configure:1664: checking for gcc configure:1690: result: no configure:1738: checking for cc configure:1764: result: no configure:1777: checking for cc configure:1822: result: no configure:1872: checking for cl configure:1898: result: no configure:1910: error: no acceptable cc found in $PATH Thank you, Russell Kenyon - 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: Failed Config on Mac OSX
Russell, Sounds like you don't have developer tools installed. You need the developer tools to build mysql on OSX. Though I think you can get hold of a pre-built distro as well - try versiontracker to find the link. Peter This is my first time installing MySQL. I'm attempting to install MySQL on my Apple PowerBook G4 OSX 10.2. After downloading and unpacking mysql-3.23.53.tar.gz, my attempt to run ./configure failed. I'm including content from config.log, any help you might have would be appreciated. configure:1047: PATH=.;.; conftest.sh ./configure: conftest.sh: command not found configure:1050: $? = 127 configure:1090: checking build system type configure:1108: result: powerpc-apple-darwin6.0 configure:1118: checking host system type configure:1132: result: powerpc-apple-darwin6.0 configure:1142: checking target system type configure:1156: result: powerpc-apple-darwin6.0 configure:1185: checking for a BSD compatible install configure:1234: result: /usr/bin/install -c configure:1245: checking whether build environment is sane configure:1263: result: yes configure:1278: checking whether make sets ${MAKE} configure:1302: result: no configure:1326: checking for working aclocal configure:1333: result: found configure:1341: checking for working autoconf configure:1352: result: missing configure:1356: checking for working automake configure:1363: result: found configure:1371: checking for working autoheader configure:1382: result: missing configure:1386: checking for working makeinfo configure:1393: result: found configure:1476: checking whether to enable maintainer-specific portions of Makefiles configure:1485: result: no configure:1498: checking whether build environment is sane configure:1516: result: yes configure:1519: checking whether make sets ${MAKE} configure:1543: result: no configure:1588: checking for mawk configure:1614: result: no configure:1588: checking for gawk configure:1614: result: no configure:1588: checking for nawk configure:1614: result: no configure:1588: checking for awk configure:1603: found /usr/bin/awk configure:1611: result: awk configure:1664: checking for gcc configure:1690: result: no configure:1738: checking for cc configure:1764: result: no configure:1777: checking for cc configure:1822: result: no configure:1872: checking for cl configure:1898: result: no configure:1910: error: no acceptable cc found in $PATH Thank you, Russell Kenyon - 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 - 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: Failed Config on Mac OSX
Hi Russell, You don¹t have a suitable compiler installed. For everything you need to know regarding installing MySQL on OS X go to http://www.entropy.ch/software/macosx/mysql/ Here you will find preconfigured mysql installs for OS X, plus step by step instruction on how to get it up and running. Regards, Gavin
MyODBC with iODBC on Mac OSX 10.2 Jaguar
Has anyone had any success in building the MySQL ODBC 3.51 Driver (formerly MyODBC) against iODBC on Mac OSX 10.2 Jaguar? Specifically, I would like to use the MySQL ODBC 3.51.04 Driver built using the iODBC Unix libraries, rather than the iODBC frameworks available on OSX through OpenLink. Has anyone had any success in building this target? One of my main problems is that one of the prerequisites of building MyODBC is that MySQL's libmysqlclient library must be installed as a shared library, but the binary distribution of MySQL for 10.2 does not include a shared version, only a static one. I cannot seem to get any success building a shared version of this library from the source distribution of MySQL on OSX 10.2. If anyone has any ideas, advice or comments, I'd really appreciate it. Thanks! Tarin Haig. PS: Please forgive me if any of this doesn't make sense - I'm very new to the world of MySQL. - 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: MyODBC with iODBC on Mac OSX 10.2 Jaguar
Tarin wrote: Has anyone had any success in building the MySQL ODBC 3.51 Driver (formerly MyODBC) against iODBC on Mac OSX 10.2 Jaguar? Specifically, I would like to use the MySQL ODBC 3.51.04 Driver built using the iODBC Unix libraries, rather than the iODBC frameworks available on OSX through OpenLink. Has anyone had any success in building this target? One of my main problems is that one of the prerequisites of building MyODBC is that MySQL's libmysqlclient library must be installed as a shared library, but the binary distribution of MySQL for 10.2 does not include a shared version, only a static one. I cannot seem to get any success building a shared version of this library from the source distribution of MySQL on OSX 10.2. If anyone has any ideas, advice or comments, I'd really appreciate it. Thanks! Hi !! What type of errors are you getting while building the driver as well as building mysql shared libraries. I built on HP 10 and 11 without any problems along with mysql shared ones. From next release onwards, I will also include the client shared libraries for download along with the driver. In case if you need client shared libs for HP 10/11, please let me know, I can provide you the link to download. Did you had any chance to test with the MyODBC 3.51.04 HP 10 binaries from the main download site ? Thanks. Tarin Haig. PS: Please forgive me if any of this doesn't make sense - I'm very new to the world of MySQL. -- Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306 ___/ www.mysql.com USA - 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: Getting mysql up and running on Mac OSX
Well the @INC is the enviroment array of perl so the perl script you're running needs DBI.pm perl module that appears not to be instaled on your box you can find more info about on http://dbi.perl.org/index.html and you can get it on http://search.cpan.org/author/TIMB/DBI-1.30/ -jose I've gotten mysql server running but am getting lots of errors when I try to run any of the scripts that come with it. for example when issuing the following command. [HDSK-Laptop:/library/mysql/sql-bench] haridass# ./run-all-tests The result I get is: Can't locate DBI.pm in @INC (@INC contains: /System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin /Library/Perl /Library/Pe rl /Network/Library/Perl/darwin /Network/Library/Perl /Network/Library/Perl .) at ./run-all-tests line 36. it looks to me like @INC is not pointing to the correct directory. I'm a pretty decent C++ programmer but haven't done much with using the command line. Any tips on what is wrong or where to go from here. i have the SAMS teach yourself mySQL but of course it is not at all Mac specific. Any help would be appreciated. === Hari Dass S. Khalsa [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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
Getting mysql up and running on Mac OSX
I've gotten mysql server running but am getting lots of errors when I try to run any of the scripts that come with it. for example when issuing the following command. [HDSK-Laptop:/library/mysql/sql-bench] haridass# ./run-all-tests The result I get is: Can't locate DBI.pm in @INC (@INC contains: /System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin /Library/Perl /Library/Perl /Network/Library/Perl/darwin /Network/Library/Perl /Network/Library/Perl .) at ./run-all-tests line 36. it looks to me like @INC is not pointing to the correct directory. I'm a pretty decent C++ programmer but haven't done much with using the command line. Any tips on what is wrong or where to go from here. i have the SAMS teach yourself mySQL but of course it is not at all Mac specific. Any help would be appreciated. === Hari Dass S. Khalsa [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
Mysql on Mac OSX
I'm new to the list trying to run Php Mysql on the Apache server built-in Mac OSX. I'm running with the following error : [localhost:/usr/local/mysql] pierreva% mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [localhost:/usr/local/mysql] pierreva% Can you help me to find what I'm doing wrong ? Pierre Vaudrey email [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
MySQL won't keep running on my Mac OSX
I'm having trouble keeping MySQL running on my computer (PowerBook G3 -Firewire, 576MB RAM, G3/400 - 40GB HD with plenty free in the main OS X partition). I'm running OS X 10.1.3. 1. I installed MySQL (binary) in \Users\hill\MySQL\ directory (logged in as me/hill, not root) 2. I can run the install and safe_mysqld and initially get the database up and running. I can log in as root (database not OS), assign passwords. I can even load PHPMyAdmin and manage the databases. 3. If I restart the computer or log-off/log-on, I've received different errors. The main error is Error 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). I've also gotten an error that the current user is not authorized or some other issue with password. I can't connect to the database to test out what the 'password' is supposed to be. So then . 4. If I delete the \data\ directory contents, I can reinstall and go through the process again. It will work well until I do a sleep or restart and then I must delete and do everything all over. I'm somewhat new to UNIX (used it many years ago) and don't know all the tricks, tests but am not uncomfortable digging around for fixes. And I know there are too many folks with success that it's obviously something on/about my system, but not sure where to dive in. Can someone give me an idea as to why the database won't keep running or at least some things to check for? Thanks in advance for any help. -- Jay Hill NetLearning, Inc. Knoxville, Tennessee 865.251.4335 www.net-learning.com - 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: MySQL won't keep running on my Mac OSX
I have the same exact setup down to the hardware (believe it or not). Your best game plan is to install the MySQL binary distro into /usr/local/mysql as the root user. And then run the MySQL server as root. You'll have to start the MySQL Server when you start the laptop. Otherwise, you can log out or put the laptop to sleep, and the MySQL server should keep running. This setup works fine on my G3-firewire Mac OS 10.1.3 Lap Top computer. -RG On Mon, 8 Apr 2002, Jay Hill wrote: I'm having trouble keeping MySQL running on my computer (PowerBook G3 -Firewire, 576MB RAM, G3/400 - 40GB HD with plenty free in the main OS X partition). I'm running OS X 10.1.3. 1. I installed MySQL (binary) in \Users\hill\MySQL\ directory (logged in as me/hill, not root) 2. I can run the install and safe_mysqld and initially get the database up and running. I can log in as root (database not OS), assign passwords. I can even load PHPMyAdmin and manage the databases. 3. If I restart the computer or log-off/log-on, I've received different errors. The main error is Error 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). I've also gotten an error that the current user is not authorized or some other issue with password. I can't connect to the database to test out what the 'password' is supposed to be. So then . 4. If I delete the \data\ directory contents, I can reinstall and go through the process again. It will work well until I do a sleep or restart and then I must delete and do everything all over. I'm somewhat new to UNIX (used it many years ago) and don't know all the tricks, tests but am not uncomfortable digging around for fixes. And I know there are too many folks with success that it's obviously something on/about my system, but not sure where to dive in. Can someone give me an idea as to why the database won't keep running or at least some things to check for? Thanks in advance for any help. -- Jay Hill NetLearning, Inc. Knoxville, Tennessee 865.251.4335 www.net-learning.com - 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 - 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: MySQL won't keep running on my Mac OSX
At 12:48 -0400 4/8/02, Jay Hill wrote: I'm having trouble keeping MySQL running on my computer (PowerBook G3 -Firewire, 576MB RAM, G3/400 - 40GB HD with plenty free in the main OS X partition). I'm running OS X 10.1.3. 1. I installed MySQL (binary) in \Users\hill\MySQL\ directory (logged in as me/hill, not root) DOS paths? What? 2. I can run the install and safe_mysqld and initially get the database up and running. I can log in as root (database not OS), assign passwords. I can even load PHPMyAdmin and manage the databases. 3. If I restart the computer or log-off/log-on, I've received different errors. The main error is Error 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). I've also gotten an error that the current user is not authorized or some other issue with password. I can't connect to the database to test out what the 'password' is supposed to be. So then . 4. If I delete the \data\ directory contents, I can reinstall and go through the process again. It will work well until I do a sleep or restart and then I must delete and do everything all over. Sounds like you don't have your system set up to start MySQL at boot time. Go to this page: http://www.entropy.ch/software/macosx/mysql/ The page contains a link for an item called mysql-startupitem.pkg.tar.gz. Download that package and install it. Then cd into /Library/StartupItems/MySQL and edit the file MySQL in that directory to reflect the actual pathname where your MySQL distribution is installed. I'm somewhat new to UNIX (used it many years ago) and don't know all the tricks, tests but am not uncomfortable digging around for fixes. And I know there are too many folks with success that it's obviously something on/about my system, but not sure where to dive in. Can someone give me an idea as to why the database won't keep running or at least some things to check for? Thanks in advance for any help. -- Jay Hill NetLearning, Inc. Knoxville, Tennessee 865.251.4335 www.net-learning.com - 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
MyODBC 3.51 build for Mac OSX
Sorry, Im new here and Im sure this has been discussed ad naseum, but does anyone have information on where to get an installer for the Mac OSX version of the MyODBC drivers? The latest build I could find on the web is 2.5. (mySQL, sql, query, etc.) TIA Brian - 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: MyODBC 3.51 build for Mac OSX
Hi, -Original Message- From: Brian Reed [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 9:52 AM To: [EMAIL PROTECTED] Subject: MyODBC 3.51 build for Mac OSX Sorry, Im new here and Im sure this has been discussed ad naseum, but does anyone have information on where to get an installer for the Mac OSX version of the MyODBC drivers? The latest build I could find on the web is 2.5. The 3.51 Mac build is not available for downloads. Possibly will add from 3.51.02 versions onwards. The alternative is to download the source and build the driver yourself. Here is a mail which describes how to build 3.51 driver on Mac. http://lists.mysql.com/cgi-ez/ezmlm-cgi?5:mss:4816:200202:kikmibdplecdpppfcd jm Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - 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: [PHP] Mac OSX !?!?!?
There is a utility called daemonic which is designed to deal with this as well, but works for more than just MySQL -- it's intended to be used for all server daemons. http://daemonic.sourceforge.net/ It is Mac OS X-specific at this time, but according to the web site is designed for future compatibility with any operating system. It can be installed via Fink (http://fink.sourceforge.net) very easily, and is in fact required by many Fink packages. I must confess that I do not know much about it. Erik On Wednesday, January 16, 2002, at 08:01 PM, Richard Baskett wrote: Although the MySQL warnings, I got those because MySQL does not automatically start in OSX, if you know it's started then Im not sure, but if not.. go here to get the autostart utility: http://www.entropy.ch/software/macosx/mysql/ - 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: [PHP] Mac OSX !?!?!?
There is a link at http://www.entropy.ch/software/macosx/mysql/ for a startup items package. This will cause MySQL to start when you restart the Mac OS X system. On 1/17/2002 8:30 AM, Erik Price [EMAIL PROTECTED] wrote: There is a utility called daemonic which is designed to deal with this as well, but works for more than just MySQL -- it's intended to be used for all server daemons. http://daemonic.sourceforge.net/ It is Mac OS X-specific at this time, but according to the web site is designed for future compatibility with any operating system. It can be installed via Fink (http://fink.sourceforge.net) very easily, and is in fact required by many Fink packages. I must confess that I do not know much about it. Erik On Wednesday, January 16, 2002, at 08:01 PM, Richard Baskett wrote: Although the MySQL warnings, I got those because MySQL does not automatically start in OSX, if you know it's started then Im not sure, but if not.. go here to get the autostart utility: http://www.entropy.ch/software/macosx/mysql/ - 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 -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ eFax: 1-419-791-8924 - 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 OSX and a pound of my flesh
Can someone PLEASE explain why I get the following error message under OSX (PHP+MySQL), but not under Windows ME or Linux? Warning: Cannot send session cache limiter - headers already sent (output started at /Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19 Warning: Unable to save MySQL query result in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44 Warning: Supplied argument is not a valid MySQL result resource in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45 --- ...Rene --- René Fournier [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
Mac OSX !?!?!?
Can someone PLEASE explain why I get the following error message under OSX (PHP+MySQL), but not under Windows ME or Linux? Warning: Cannot send session cache limiter - headers already sent (output started at /Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19 Warning: Unable to save MySQL query result in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44 Warning: Supplied argument is not a valid MySQL result resource in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45 --- After these lines, the pages load fine. I'm using PHP Session ID variables (or trying to)--they work fine as I said under other OSes, but now break under OSX. ...Rene --- René Fournier [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: [PHP] Mac OSX !?!?!?
Kind of hard to say without source code for the session part.. Although the MySQL warnings, I got those because MySQL does not automatically start in OSX, if you know it's started then Im not sure, but if not.. go here to get the autostart utility: http://www.entropy.ch/software/macosx/mysql/ This link will have information and a link of where you can download the utility. Rick The human mind is not capable of grasping the Universe. We are like a little child entering a huge library. The walls are covered to the ceilings with books in many different tongues. The child knows that someone must have written these books. It does not know who or how. It does not understand the languages in which they are written. But the child notes a definite plan in the arrangement of the books---a mysterious order which it does not comprehend, but only dimly suspects. - Albert Einstein From: René Fournier [EMAIL PROTECTED] Date: Wed, 16 Jan 2002 17:50:06 -0700 To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: [PHP] Mac OSX !?!?!? Can someone PLEASE explain why I get the following error message under OSX (PHP+MySQL), but not under Windows ME or Linux? Warning: Cannot send session cache limiter - headers already sent (output started at /Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19 Warning: Unable to save MySQL query result in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44 Warning: Supplied argument is not a valid MySQL result resource in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45 --- After these lines, the pages load fine. I'm using PHP Session ID variables (or trying to)--they work fine as I said under other OSes, but now break under OSX. ...Rene --- René Fournier [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [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: [PHP] Mac OSX !?!?!?
Somebody suggested I post the source--good idea! So here it is... The header.inc file, in its entirety: html head titleSite :: Jupiter :: Europa/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 link rel=stylesheet href=../../common/styles.css type=text/css ?php // DETERMINE THE LANGUAGE FROM THE PARENT DIRECTORY // GENERATE VARIABLES FOR LANGUAGE, FILENAME AND NAME $path = explode(/,$PHP_SELF); if (!$lang) { $lang = $path[sizeof($path)-2]; } $file = $path[sizeof($path)-1]; $prename = explode(.,$file); $name = $prename[sizeof($prename)-2]; // SECURITY CHECK session_start(); if (!$PHPSESSID) { die; } elseif (!$auth) { die; } elseif ($auth != $path[sizeof($path)-2]) { die; } $language = All Languages; if ($lang == en) { $language = English; } if ($lang == fr) { $language = FranÁais; } if ($lang == es) { $language = EspaÒol; } if ($lang == de) { $language = Deutsch; } if ($lang == it) { $language = Italiano; } $priv = 2; // CONNECT TO DATABASE $db = mysql_connect(localhost,database,password); mysql_select_db(database,$db); // FETCH TABLE NAMES $listtables = mysql_list_tables(database,$db); // FETCH SELECTED TABLE DATA $fields = mysql_list_fields(database, $table, $db); $columns = mysql_num_fields($fields); ? script language=JavaScript !-- function GP_popupConfirmMsg(msg) { //v1.0 document.MM_returnValue = confirm(msg); } //-- /script /head body bgcolor=#FF text=#00 link=#00 vlink=#00 alink=#00 leftmargin=20 topmargin=20 marginwidth=0 marginheight=0 background=../../common/bg.gif ?php if ($language) { echo span class=adminnormalgreya href=../index.php4Europa/a/span; } if ($table) { echo span class=adminnormalgrey : /spanspan class=adminnormalgreya href=tables.php4Tables/a/span; } ? pnbsp; On Wednesday, January 16, 2002, at 06:01 PM, Richard Baskett wrote: Kind of hard to say without source code for the session part.. Although the MySQL warnings, I got those because MySQL does not automatically start in OSX, if you know it's started then Im not sure, but if not.. go here to get the autostart utility: http://www.entropy.ch/software/macosx/mysql/ This link will have information and a link of where you can download the utility. Rick The human mind is not capable of grasping the Universe. We are like a little child entering a huge library. The walls are covered to the ceilings with books in many different tongues. The child knows that someone must have written these books. It does not know who or how. It does not understand the languages in which they are written. But the child notes a definite plan in the arrangement of the books---a mysterious order which it does not comprehend, but only dimly suspects. - Albert Einstein From: René Fournier [EMAIL PROTECTED] Date: Wed, 16 Jan 2002 17:50:06 -0700 To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: [PHP] Mac OSX !?!?!? Can someone PLEASE explain why I get the following error message under OSX (PHP+MySQL), but not under Windows ME or Linux? Warning: Cannot send session cache limiter - headers already sent (output started at /Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19 Warning: Unable to save MySQL query result in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44 Warning: Supplied argument is not a valid MySQL result resource in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45 --- After these lines, the pages load fine. I'm using PHP Session ID variables (or trying to)--they work fine as I said under other OSes, but now break under OSX. ...Rene --- René Fournier [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: php-list- [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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: [PHP] Mac OSX !?!?!?
Somebody suggested I post the source--good idea! So here it is... The header.inc file, in its entirety: html head titleSite :: Jupiter :: Europa/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 link rel=stylesheet href=../../common/styles.css type=text/css ?php // DETERMINE THE LANGUAGE FROM THE PARENT DIRECTORY // GENERATE VARIABLES FOR LANGUAGE, FILENAME AND NAME $path = explode(/,$PHP_SELF); if (!$lang) { $lang = $path[sizeof($path)-2]; } $file = $path[sizeof($path)-1]; $prename = explode(.,$file); $name = $prename[sizeof($prename)-2]; // SECURITY CHECK session_start(); if (!$PHPSESSID) { die; } elseif (!$auth) { die; } elseif ($auth != $path[sizeof($path)-2]) { die; } $language = All Languages; if ($lang == en) { $language = English; } if ($lang == fr) { $language = FranÁais; } if ($lang == es) { $language = EspaÒol; } if ($lang == de) { $language = Deutsch; } if ($lang == it) { $language = Italiano; } $priv = 2; // CONNECT TO DATABASE $db = mysql_connect(localhost,database,password); mysql_select_db(database,$db); // FETCH TABLE NAMES $listtables = mysql_list_tables(database,$db); // FETCH SELECTED TABLE DATA $fields = mysql_list_fields(database, $table, $db); $columns = mysql_num_fields($fields); ? script language=JavaScript !-- function GP_popupConfirmMsg(msg) { //v1.0 document.MM_returnValue = confirm(msg); } //-- /script /head body bgcolor=#FF text=#00 link=#00 vlink=#00 alink=#00 leftmargin=20 topmargin=20 marginwidth=0 marginheight=0 background=../../common/bg.gif ?php if ($language) { echo span class=adminnormalgreya href=../index.php4Europa/a/span; } if ($table) { echo span class=adminnormalgrey : /spanspan class=adminnormalgreya href=tables.php4Tables/a/span; } ? pnbsp; On Wednesday, January 16, 2002, at 06:01 PM, Richard Baskett wrote: Kind of hard to say without source code for the session part.. Although the MySQL warnings, I got those because MySQL does not automatically start in OSX, if you know it's started then Im not sure, but if not.. go here to get the autostart utility: http://www.entropy.ch/software/macosx/mysql/ This link will have information and a link of where you can download the utility. Rick The human mind is not capable of grasping the Universe. We are like a little child entering a huge library. The walls are covered to the ceilings with books in many different tongues. The child knows that someone must have written these books. It does not know who or how. It does not understand the languages in which they are written. But the child notes a definite plan in the arrangement of the books---a mysterious order which it does not comprehend, but only dimly suspects. - Albert Einstein From: René Fournier [EMAIL PROTECTED] Date: Wed, 16 Jan 2002 17:50:06 -0700 To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: [PHP] Mac OSX !?!?!? Can someone PLEASE explain why I get the following error message under OSX (PHP+MySQL), but not under Windows ME or Linux? Warning: Cannot send session cache limiter - headers already sent (output started at /Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19 Warning: Unable to save MySQL query result in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44 Warning: Supplied argument is not a valid MySQL result resource in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45 --- After these lines, the pages load fine. I'm using PHP Session ID variables (or trying to)--they work fine as I said under other OSes, but now break under OSX. ...Rene --- René Fournier [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: php-list- [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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: [PHP] Mac OSX !?!?!?
try calling session_start() as the very first thing in your php script. - Original Message - From: René Fournier [EMAIL PROTECTED] To: PHP General [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 7:41 PM Subject: Re: [PHP] Mac OSX !?!?!? Somebody suggested I post the source--good idea! So here it is... The header.inc file, in its entirety: html head titleSite :: Jupiter :: Europa/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 link rel=stylesheet href=../../common/styles.css type=text/css ?php // DETERMINE THE LANGUAGE FROM THE PARENT DIRECTORY // GENERATE VARIABLES FOR LANGUAGE, FILENAME AND NAME $path = explode(/,$PHP_SELF); if (!$lang) { $lang = $path[sizeof($path)-2]; } $file = $path[sizeof($path)-1]; $prename = explode(.,$file); $name = $prename[sizeof($prename)-2]; // SECURITY CHECK session_start(); if (!$PHPSESSID) { die; } elseif (!$auth) { die; } elseif ($auth != $path[sizeof($path)-2]) { die; } $language = All Languages; if ($lang == en) { $language = English; } if ($lang == fr) { $language = FranÁais; } if ($lang == es) { $language = EspaÒol; } if ($lang == de) { $language = Deutsch; } if ($lang == it) { $language = Italiano; } $priv = 2; // CONNECT TO DATABASE $db = mysql_connect(localhost,database,password); mysql_select_db(database,$db); // FETCH TABLE NAMES $listtables = mysql_list_tables(database,$db); // FETCH SELECTED TABLE DATA $fields = mysql_list_fields(database, $table, $db); $columns = mysql_num_fields($fields); ? script language=JavaScript !-- function GP_popupConfirmMsg(msg) { //v1.0 document.MM_returnValue = confirm(msg); } //-- /script /head body bgcolor=#FF text=#00 link=#00 vlink=#00 alink=#00 leftmargin=20 topmargin=20 marginwidth=0 marginheight=0 background=../../common/bg.gif ?php if ($language) { echo span class=adminnormalgreya href=../index.php4Europa/a/span; } if ($table) { echo span class=adminnormalgrey : /spanspan class=adminnormalgreya href=tables.php4Tables/a/span; } ? pnbsp; On Wednesday, January 16, 2002, at 06:01 PM, Richard Baskett wrote: Kind of hard to say without source code for the session part.. Although the MySQL warnings, I got those because MySQL does not automatically start in OSX, if you know it's started then Im not sure, but if not.. go here to get the autostart utility: http://www.entropy.ch/software/macosx/mysql/ This link will have information and a link of where you can download the utility. Rick The human mind is not capable of grasping the Universe. We are like a little child entering a huge library. The walls are covered to the ceilings with books in many different tongues. The child knows that someone must have written these books. It does not know who or how. It does not understand the languages in which they are written. But the child notes a definite plan in the arrangement of the books---a mysterious order which it does not comprehend, but only dimly suspects. - Albert Einstein From: René Fournier [EMAIL PROTECTED] Date: Wed, 16 Jan 2002 17:50:06 -0700 To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: [PHP] Mac OSX !?!?!? Can someone PLEASE explain why I get the following error message under OSX (PHP+MySQL), but not under Windows ME or Linux? Warning: Cannot send session cache limiter - headers already sent (output started at /Users/rene/Sites/smartslitters/jupiter/europa/header.inc:6) in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 19 Warning: Unable to save MySQL query result in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 44 Warning: Supplied argument is not a valid MySQL result resource in /Users/rene/Sites/smartslitters/jupiter/europa/header.inc on line 45 --- After these lines, the pages load fine. I'm using PHP Session ID variables (or trying to)--they work fine as I said under other OSes, but now break under OSX. ...Rene --- René Fournier [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: php-list- [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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive
Re: MySQL graphical front-end for Mac OSX
Robert Alexander writes: At 18:07 -0700 2001/12/06, René Fournier wrote: Does anyone know if such a thing exists? (Especially a freeware one?) I'd like to be able to create and modify table structures without hitting Terminal everytime. I was using MySQLFront on Windows for this, and it was quite nice. The only problem is... It's only available for Windows. ...Rene For Mac Classic environment - MacSQL Monitor. Shareware and very good. http://www.rtlabs.com/ For OS-X, any of a great variety of Unix/Linux tools. How about MySQL GUI? MyPHPAdmin? : HTH /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! MySQLGUI should be available on OS X, in the native Carbon graphics mode without a need for X Server, in about 3 months, as it will take 2 more months for FLTK people to port it to OS X and OS 9. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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: MySQL graphical front-end for Mac OSX
On Thursday, December 6, 2001, at 08:07 PM, René Fournier wrote: Does anyone know if such a thing exists? (Especially a freeware one?) I'd like to be able to create and modify table structures without hitting Terminal everytime. I was using MySQLFront on Windows for this, and it was quite nice. The only problem is... It's only available for Windows. ...Rene --- René Fournier [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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Try searching on versiontracker.com in the OS X section. --- Avast, Ye land lubbers! --- - 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: MySQL graphical front-end for Mac OSX
At 18:07 -0700 2001/12/06, René Fournier wrote: Does anyone know if such a thing exists? (Especially a freeware one?) I'd like to be able to create and modify table structures without hitting Terminal everytime. I was using MySQLFront on Windows for this, and it was quite nice. The only problem is... It's only available for Windows. ...Rene For Mac Classic environment - MacSQL Monitor. Shareware and very good. http://www.rtlabs.com/ For OS-X, any of a great variety of Unix/Linux tools. How about MySQL GUI? MyPHPAdmin? : HTH /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - 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: MySQL graphical front-end for Mac OSX
At 8:38 PM -0500 12/6/01, NDPTAL85 wrote: Does anyone know if such a thing exists? Free phpMyAdmin Phpwizard.net http://www.phpwizard.net/projects/phpMyAdmin/ Webmin James Cameron http://www.webmin.com/webmin/index.html Not Free MacSQL Monitor (and SQL Language Module for BBEdit) Runtime Labs http://www.rtlabs.com/ SQL4X Manager MacOS Guru http://www.macosguru.de/ JaneBUILDER http://www.seejanecode.com/ ProSQL http://www.intellisw.com/prosql/ SQLBoss Reinhard R. Blumauer http://www.sqlboss.com/ Webmin is a Web server administration tool based on Perl scripts. There are many modules for configuring Web servers, databases, and other Web applications, including modules for Apache and MySQL. These are my notes for setting up WebMin on Mac OS X. Version 2: Added notes on configuring Webmin for Lasso MySQL. Here are my Notes on Setting up WebMin on Mac OS X http://www.lassodev.com/pub/webminNotes02.sit The ones that stand out on the not free list include MacSQL Monitor, SQL4X Manager, and ProSQL (I haven't spent much time with JaneBUILDER). You get a lot more with these. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - 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: Mac OSX and MySQL
I have to create a MySQL for my PHP scripts. How do I do this in Mac OSX? There are a bunch of command line tools, but I'm not sure which one[s] to use. Not sure I understand this question. What do you mean by create a MySQL for my PHP? oops, I meant to write create a MySQL user for my PHP scripts. In other words, when my scripts try to connect to the database, they need to supply a user id and password (and that must be certain id/pwd to correspond with the 'real' online server we're using). So I would like to know how to create this user/password under Mac OSX. (Thanks.) Thanks. ...Rene Hope this helps, /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- René Fournier [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: [PHP] Mac OSX and MySQL
On Wednesday, December 5, 2001, at 12:24 AM, René Fournier wrote: I have to create a MySQL for my PHP scripts. How do I do this in Mac OSX? There are a bunch of command line tools, but I'm not sure which one[s] to use. Well, if you already have MySQL installed, then just use them as normal. Just remember that Unix syntax is different from DOS (lets you do more, actually). If you need to install MySQL, try these: http://developer.apple.com/internet/macosx/osdb.html the above link is for Apple's own recommendations for installing MySQL on Darwin. Just make sure that you use the source code for 3.23.45, not 3.43.44 (because the .44 doesn't shut down properly in Darwin). I used this technique (not the binary) and it works great. http://fink.sourceforge.net if you use Fink (debian-style package installer) you can have it install MySQL for you (as well as PHP and Apache) but I didn't go this route because I wanted more control over the install process. http://www.stepwise.com/Articles/Workbench/2001-10-11.01.html the above link isn't for MySQL at all, it's for PHP, but it's a useful article. Remember to add the --with-mysql configure option because this tutorial doesn't assume that you want to install MySQL. Any questions, email me. Erik - 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: [PHP] Re: Mac OSX and MySQL
Oh, okay, you want to know how to use NetInfo. Do man niutil and read the man pages on niutil. Also very useful, in the following link is a brief description of how to use NetInfo Manager to do the same thing if you prefer GUI: http://developer.apple.com/internet/macosx/osdb.html It tells you how to create a user. Erik PS: don't use System Preferences' Users to make dummy users for MySQL and other services. On Wednesday, December 5, 2001, at 10:04 AM, René Fournier wrote: I have to create a MySQL for my PHP scripts. How do I do this in Mac OSX? There are a bunch of command line tools, but I'm not sure which one[s] to use. Not sure I understand this question. What do you mean by create a MySQL for my PHP? oops, I meant to write create a MySQL user for my PHP scripts. In other words, when my scripts try to connect to the database, they need to supply a user id and password (and that must be certain id/pwd to correspond with the 'real' online server we're using). So I would like to know how to create this user/password under Mac OSX. (Thanks.) Thanks. ...Rene Hope this helps, /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- René Fournier [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [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: Mac OSX and MySQL
At 22:24 -0700 2001/12/04, René Fournier wrote: The migration continues... Now I have to get my mysql database running under MySQL 3.23.46 on OSX 10.1.1. I've dumped the structure and contents of the database (on Windows) into a text file, and now I'd like to recreate it in the new enivronment. I think I can use the mysql admin tools via command line (but really, what is the syntax for piping a 'dumped' database into a new database? mysqladmin create database dumpeddb.sql??), but one question about users... Allo René, Depending on the command you used to dump the data, the table creation commands will already be in the mysqldump file. You can look at it with a text editor. Your guess was almost right. : To bring the dump into your new database, just do: mysql database_name -p backup_file.sql The '-p' will prompt for your password. There's a bunch of good info in the manual about this. Check out 4.8.5 mysqldump, Dumping Table Structure and Data. I have to create a MySQL for my PHP scripts. How do I do this in Mac OSX? There are a bunch of command line tools, but I'm not sure which one[s] to use. Not sure I understand this question. What do you mean by create a MySQL for my PHP? Thanks. ...Rene Hope this helps, /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - 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 OSX and MySQL
The migration continues... Now I have to get my mysql database running under MySQL 3.23.46 on OSX 10.1.1. I've dumped the structure and contents of the database (on Windows) into a text file, and now I'd like to recreate it in the new enivronment. I think I can use the mysql admin tools via command line (but really, what is the syntax for piping a 'dumped' database into a new database? mysqladmin create database dumpeddb.sql??), but one question about users... I have to create a MySQL for my PHP scripts. How do I do this in Mac OSX? There are a bunch of command line tools, but I'm not sure which one[s] to use. Thanks. ...Rene --- René Fournier [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
MySQL source installation on Mac OSX, problems with compiling
Description: MySQL fails to make under Mac OSX. During the make process numerous errors are displayed, but are generally ignored until I start recieving these errors: /usr/bin/ld: multiple definitions of symbol _optarg /usr/lib/libcurses.dylib(getopt.o) definition of _optarg ../libmysql/.libs/libmysqlclient.a(getopt.o) definition of _optarg in section (__DATA,__data) I get several of these, for values such as _opterrr, _optind, _optopt. With it finally ending with: make[2]: *** [mysql] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive-am] Error 2 How-To-Repeat: Type following at prompt: ./configure --enable-assembler --with-mysqld-user=mysql --host=powerpc-apple-macos make Fix: Submitter-Id: Originator: Organization: MySQL support: none Synopsis: Cannot successfully build MySQL on OSX Severity: non-critical Priority: low Category: mysql Class: support Release: mysql-3.23.42 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Darwin betaserver 1.3.3 Darwin Kernel Version 1.3.3: Fri May 4 13:46:54 P\ DT 2001; root:xnu/xnu-124.8.obj~1/RELEASE_PPC Power Macintosh powerpc Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Sep 20 11:57 /usr/lib/libc.dylib - libSystem.dylib Configure command: ./configure --with-unix-socket- path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --with-innodb - 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