Problems with MyODBC 3.51.12 for MacOSX Panther

[Thurgood Alex]

Hi all,

I have downloaded and installed the myodbc3 driver for MacOSX onto my
Panther machine (10.3.9). First surprise, the MySQL graphical installer
doesn't seem to appear in the Applications folder, has it been dropped ?

Secondly, although I have manage to configure ODBCAdministrator, the
datasource is declared, and visible to the user, it is however
inaccessible, and I get an error message when trying to connect. I have
noticed that the readme says that an executable file should be installed
in /usr/bin/ as myodbc3i, when I start this command as sudo from a
terminal, I get the following error message :

/usr/lib/libltdl.3.dylib (No such file or directory)

and indeed the libtool library isn't installed.

The README provided with the MyODBC dmg package states that you don't
actually need anything else to get MyODBC working, not even the MySQL
client libraries, so what gives with the libtool dependencies ?

After trawling with Google, I found on a mysql list a suggestion that
one should install the XCode development package provided by Apple,
since that package provides the library in question. Here's the crunch,
my disks with the Mac machines are tiny, thw whole point is to access
data remotely and not have to store stuff locally, and that also means
not having space to install a development environment on every machine.
So what am I to do ? Is this problem not going to be fixed ? Is there no
solution other than that (some solution !!) 

Thirdly, I notice that the installation hasn't provided a file called
libmyodbc3S.dylib, which is traditionally the shared library to which
function calls are made for setup of the connection to the mysql server.
Has this been dropped too, or is the MacOSX package deficient ?

The worst bit about all of this is that a binary package was previously
available (3.51.9 or 10 I think), that had all of these things in it,
but I don't seem to be able to find it anymore on the servers.

Any help most gratefully taken.


Alex  


-- 
Thurgood Alex <[EMAIL PROTECTED]>
Cabinet Michel Richebourg


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installation Instructions for MySQL for Mac OS X Panther

[daniel]

> Does anyone know where I can find in-depth, precise instructions to
> install MySQL on Mac OS X Panther client?
>
> - Asad
>

Just get the binary for OSX and follow the readme its simple.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installation Instructions for MySQL for Mac OS X Panther

[Brent Baisley]

Just download the install package from the mysql website. Instructions 
for configuring it (i.e. setting root password) are the same for all 
platforms.

But, if you really need handholding, head over to entropy.ch.
On Feb 16, 2005, at 3:43 PM, Asad Habib wrote:
Does anyone know where I can find in-depth, precise instructions to
install MySQL on Mac OS X Panther client?
- Asad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
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]

Installation Instructions for MySQL for Mac OS X Panther

[Asad Habib]

Does anyone know where I can find in-depth, precise instructions to
install MySQL on Mac OS X Panther client?

- Asad

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Connecting MySQL in Panther

[Ware Adams]

chueewowee wrote:

>[raisinspace:/usr/local/mysql] chueewow% Starting mysqld daemon with
>databases from /usr/local/mysql/data
>040612 23:32:05  mysqld ended

mysqld isn't starting.  See what the error log says, it will likely be
in /usr/local/mysql/data

--Ware

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Connecting MySQL in Panther

[chueewowee]

Hello, I'm new to the list and need help of course.
My problems are in connecting to MySQL. I am running Panther 10.38. , MySQL
4.018.
I have removed all old files before reinstalling MySQL. I have installed
the MySQL Startup Item and it is correctly located.
Output from the Terminal is as follows:

[raisinspace:~] chueewow% sudo /Library/StartupItems/MySQL/MySQL start
Starting MySQL database server
[raisinspace:~] chueewow% /usr/local/mysql/bin/mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
[raisinspace:~] chueewow% sudo /Library/StartupItems/MySQL/MySQL start
Starting MySQL database server
[raisinspace:~] chueewow% cd /usr/local/mysql
[raisinspace:/usr/local/mysql] chueewow% sudo ./bin/mysqld_safe &
[1] 2966
[raisinspace:/usr/local/mysql] chueewow% Starting mysqld daemon with
databases from /usr/local/mysql/data
040612 23:32:05  mysqld ended
Also, from my HTML browser (SAfari) when :
Warning: mysql_connect(): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2) in /Users/chueewowee/Sites/index.php on line 21
Warning: mysql_select_db(): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2) in /Users/chueewowee/Sites/index.php on line 25
Warning: mysql_select_db(): A link to the server could not be established
in /Users/chueewowee/Sites/index.php on line 25
Warning: mysql_create_db(): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2) in /Users/chueewowee/Sites/index.php on line 29
Warning: mysql_create_db(): A link to the server could not be established
in /Users/chueewowee/Sites/index.php on line 29
2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(2)
Warning: mysql_select_db(): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2) in /Users/chueewowee/Sites/index.php on line 37
Warning: mysql_select_db(): A link to the server could not be established
in /Users/chueewowee/Sites/index.php on line 37
Can't Select CONTACT
Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resource in /Users/chueewowee/Sites/index.php on line 43
2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(2)
I have sought and tried  all kinds of advice. But either it is not clear or
working for me.
JP
JP
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: What distribution should I use for Mac OS X 10.3.x (Panther?

[Brent Baisley]

You can use the one that comes with Panther. But if you want to install 
the latest, download the standard version 4.0.18. I assume you were 
wondering between standard and max editions.

On Apr 13, 2004, at 3:34 PM, Daniel Lahey wrote:

Which distribution should I install on Mac OS X Panther?  Thanks.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
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: Panther

[John Mistler]

This was the answer for my installaton on Panther, as well.  Scott's
instructions provide those extra commands you might need.  I thought I had
followed the standard installation instructions VERY carefully, and yet I
got stuck.  This got me through . . . .

on 4/14/04 12:26 AM, Daniel Lahey at [EMAIL PROTECTED] wrote:

> Just thought I'd share my experience with MySQL under Panther.  I think
> the critical thing that got me going was that the /usr/local/mysql/data
> directory was owned by root instead of mysql.  I changed that (chown
> mysql /usr/local/mysql/data) and everything seems to be a) Hunky b)
> Dory, thanks to Scott Haneda.  (See below...)
> 
> From Scott:
> 
> For some reason I get a lot of email from users on Mac OS X that can not
> install MySql.  I have written a step by step in hopes it will help.  I
> really did little more than copy the notes on the MySql site, but alas,
> it
> seems some people are not following those correctly.
> 
> Hopefully, people can point others to this link
> <http://newgeo.com/mysql/>
> 
> Cheers,
> 
> Dan (aka Zippy Appletush)
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Panther

[Daniel Lahey]

Just thought I'd share my experience with MySQL under Panther.  I think 
the critical thing that got me going was that the /usr/local/mysql/data 
directory was owned by root instead of mysql.  I changed that (chown 
mysql /usr/local/mysql/data) and everything seems to be a) Hunky b) 
Dory, thanks to Scott Haneda.  (See below...)

From Scott:

For some reason I get a lot of email from users on Mac OS X that can not
install MySql.  I have written a step by step in hopes it will help.  I
really did little more than copy the notes on the MySql site, but alas, 
it
seems some people are not following those correctly.

Hopefully, people can point others to this link 
<http://newgeo.com/mysql/>

Cheers,

Dan (aka Zippy Appletush)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

What distribution should I use for Mac OS X 10.3.x (Panther?

[Daniel Lahey]

Which distribution should I install on Mac OS X Panther?  Thanks.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Getting mysql to work in Panther

[Brent Baisley]

It sounds like you are able to login as a guest, but not as 'root'. 
Please note that 'root' for MySQL is not the same as root user for the 
OS, they are totally unrelated. I typically change the account name for 
MySQL root to 'mysqlroot', so my login would be mysql -u mysqlroot -p. 
There is no "regular" user after the initial install of MySQL, there is 
only MySQL root.

As long as you followed the directions and did nothing else after you 
installed and started MySQL, the mysqladmin command to set the initial 
password should have worked. I'm guessing you might have tried some 
other things first.

When in a total jam, you can startup mysqld without having it check 
access rights. You can then login as a guest and set the root password 
manual. You can kill the mysql process and start it backup up with out 
the grant tables.
mysqld --skip-grant-tables

But if you don't know how to set the password "manually" (you need to 
encrypt it), you should probably reinstall MySQL and see if you can set 
the root password. Download the install from the MySQL website. I've 
done about a dozen installs of MySQL on Macs over the past two years 
without a problem, so it does work.

On Apr 12, 2004, at 1:26 AM, Daniel Lahey wrote:

I have been trying for months to set up mysql on my Mac (Panther) with 
no success.  I can't run mysqladmin as root. I get an access denied 
error message.  If I try to use SHELL>mysqladmin -u root password 
'password' I get access denied as either root or the regular user.  I 
can't run mysql as root.  'access denied'  I can't create databases.  
I can run mysql as the regular user and mess with the test db, and 
that's about all I can do.  I've followed every instruction I could 
find online at the command line.  I've tried CocoaMySQL.  I have 
practically resorted to prayer.

Are there step-by-step instructions anywhere?  I would be eternally 
grateful for any help.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
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: Getting mysql to work in Panther

[Egor Egorov]

Daniel Lahey <[EMAIL PROTECTED]> wrote:
> I have been trying for months to set up mysql on my Mac (Panther) with 
> no success.  I can't run mysqladmin as root. I get an access denied 
> error message.  If I try to use SHELL>mysqladmin -u root password 
> 'password' I get access denied as either root or the regular user.  I 
> can't run mysql as root.  'access denied'  I can't create databases.  I 
> can run mysql as the regular user and mess with the test db, and that's 
> about all I can do.  I've followed every instruction I could find 
> online at the command line.  I've tried CocoaMySQL.  I have practically 
> resorted to prayer.
> 
> Are there step-by-step instructions anywhere?  I would be eternally 
> grateful for any help.
> 

What exactly error message did you receive? 



-- 
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]

Getting mysql to work in Panther

[Daniel Lahey]

I have been trying for months to set up mysql on my Mac (Panther) with 
no success.  I can't run mysqladmin as root. I get an access denied 
error message.  If I try to use SHELL>mysqladmin -u root password 
'password' I get access denied as either root or the regular user.  I 
can't run mysql as root.  'access denied'  I can't create databases.  I 
can run mysql as the regular user and mess with the test db, and that's 
about all I can do.  I've followed every instruction I could find 
online at the command line.  I've tried CocoaMySQL.  I have practically 
resorted to prayer.

Are there step-by-step instructions anywhere?  I would be eternally 
grateful for any help.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Uninstall MySQL for Panther?

[Paul DuBois]

At 21:31 -0800 3/12/04, John Mistler wrote:
First I want to thank all of you guys for responding.  I feel a new sense of
confidence that I will be able to get this thing going!
However, my problems have compounded.  We now have a new problem.  I took
the advice of one archived postings and dragged the four files seemingly
installed by the mysql package at the location (in Mac language)
users:johnmistler: to the trash.  That didn't feel right to
me once I did it, so I dragged them back.  They were named:
1. cd
2. md5
3. md5 sum
4. mysql
Now, when I go to the terminal and type:

/usr/local/mysql/bin/mysql

I get:

tcsh: /usr/local/mysql/bin/mysql: Command not found

This suggests to me that the mysql file it is being directed to is not
there.  However, I can verify that the file "mysql" exists at this path (in
Mac Language):
users:johnmistler:mysql

It is listed as a document with Zero KB for its size (?).  It definitely is
one of the files that I dragged back from the trash.
Should I attempt to fix all of this, or go ahead with an uninstall?
Well, it's maybe a little risky to go ahead and trash all that stuff,
but I'd guess that's what you want to do.  If the mysql program isn't
found as a command (as shown above), it's not doing you any good.  You
might try this command to see what kind of thing it actually is now:
file /usr/local/mysql/bin/mysql

If I do need to uninstall, how do I do it?  I installed the latest PACKAGE
from the MySQL.com site 4.0.18-standard along with the startup item package.
Use the rm commands that Scott Haneda suggested in his message.  Then
reinstall.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Uninstall MySQL for Panther?

[Scott Haneda]

on 03/12/2004 09:31 PM, John Mistler at [EMAIL PROTECTED] wrote:

> First I want to thank all of you guys for responding.  I feel a new sense of
> confidence that I will be able to get this thing going!
> 
> However, my problems have compounded.  We now have a new problem.  I took
> the advice of one archived postings and dragged the four files seemingly
> installed by the mysql package at the location (in Mac language)
> users:johnmistler: to the trash.  That didn't feel right to
> me once I did it, so I dragged them back.  They were named:
> 
> 1. cd
> 2. md5
> 3. md5 sum
> 4. mysql

I don't know what those files are, they are not part of where mysql should
have installed its stuff, so there should in theory be no hard in removing
them.


You can remove mysql by doing the following
rm -r /usr/local/mysql
rm -r /Library/StartupItems/MySQL

This will get you back to a clean machine with no mysql, from there, run the
installer and this time follow the instructions exactly on how to start
mysql as well as how to set the root password to the mysql permissions
database.

If you still get stuck, drop me a email directly and I can walk you thought
it.

-- 
-
Scott HanedaTel: 415.898.2602
http://www.newgeo.com   Fax: 313.557.5052
[EMAIL PROTECTED]Novato, CA U.S.A.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Uninstall MySQL for Panther?

[John Mistler]

First I want to thank all of you guys for responding.  I feel a new sense of
confidence that I will be able to get this thing going!

However, my problems have compounded.  We now have a new problem.  I took
the advice of one archived postings and dragged the four files seemingly
installed by the mysql package at the location (in Mac language)
users:johnmistler: to the trash.  That didn't feel right to
me once I did it, so I dragged them back.  They were named:

1. cd
2. md5
3. md5 sum
4. mysql

Now, when I go to the terminal and type:

/usr/local/mysql/bin/mysql

I get:

tcsh: /usr/local/mysql/bin/mysql: Command not found

This suggests to me that the mysql file it is being directed to is not
there.  However, I can verify that the file "mysql" exists at this path (in
Mac Language):

users:johnmistler:mysql

It is listed as a document with Zero KB for its size (?).  It definitely is
one of the files that I dragged back from the trash.

Should I attempt to fix all of this, or go ahead with an uninstall?

If I do need to uninstall, how do I do it?  I installed the latest PACKAGE
from the MySQL.com site 4.0.18-standard along with the startup item package.

If you guys still think I need to tough it out, what is the next step?

Once again (embarrassingly) -- THANK YOU!

John



on 3/12/04 7:22 PM, Paul DuBois at [EMAIL PROTECTED] wrote:

> At 18:33 -0800 3/12/04, John Mistler wrote:
>> I am two days into troubleshooting this.  I need some help badly.
>> 
>> I installed MySQL 4.0.18 for Mac.  I was able to get in at first:
>> 
>> Welcome to MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 14 to server version: 4.0.18-standard
> 
> Please show us the command you entered to start the mysql program.
> 
>> 
>> then I would type mysql> create database mytest;
>> 
>> and get: ERROR 1044: Access denied for user: '@localhost' to database
>> 'mytest'
> 
> The account name (@localhost) has no username before the '@' character,
> which indicates that you have connected as the anonymous user.  This
> user has no privileges to create the mytest database.
> 
>> 
>> I tried all kinds of commands to change the root password, and every single
>> one would result in "Access denied for user . . . "
> 
> Please show what these commands were.  No one can help you diagnose
> the problem without information to go on.
> 
>> 
>> I would like to install, instead, CompleteMySQL from the
>> serverlogisitics.com site, which has interfaces to help newbies like me.
>> However, it is only at version 4.0.15.  So my question is:
>> 
>> How can I UNINSTALL the current 4.0.18 version I already have, before
>> installing the other one?
> 
> Well ... I'm afraid we cannot tell you that, either, because although
> you've indicated that you installed MySQL 4.0.18 for Mac, you haven't
> told us how you installed it.  Did you use the PKG distribution? Did you
> install from source?
> 
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Uninstall MySQL for Panther?

[Paul DuBois]

At 18:33 -0800 3/12/04, John Mistler wrote:
I am two days into troubleshooting this.  I need some help badly.

I installed MySQL 4.0.18 for Mac.  I was able to get in at first:

Welcome to MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14 to server version: 4.0.18-standard
Please show us the command you entered to start the mysql program.

then I would type mysql> create database mytest;

and get: ERROR 1044: Access denied for user: '@localhost' to database
'mytest'
The account name (@localhost) has no username before the '@' character,
which indicates that you have connected as the anonymous user.  This
user has no privileges to create the mytest database.
I tried all kinds of commands to change the root password, and every single
one would result in "Access denied for user . . . "
Please show what these commands were.  No one can help you diagnose 
the problem without information to go on.

I would like to install, instead, CompleteMySQL from the
serverlogisitics.com site, which has interfaces to help newbies like me.
However, it is only at version 4.0.15.  So my question is:
How can I UNINSTALL the current 4.0.18 version I already have, before
installing the other one?
Well ... I'm afraid we cannot tell you that, either, because although
you've indicated that you installed MySQL 4.0.18 for Mac, you haven't
told us how you installed it.  Did you use the PKG distribution? Did you
install from source?


--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Uninstall MySQL for Panther?

[Hassan Schroeder]

John Mistler wrote:

I installed MySQL 4.0.18 for Mac.  I was able to get in at first:

I tried all kinds of commands to change the root password, and every single
one would result in "Access denied for user . . . "
I would like to install, instead, CompleteMySQL from the
serverlogisitics.com site, which has interfaces to help newbies like me.
No, no! Be strong, you don't need the training wheels :-)

Re-read the doc about grant tables and then restart the server with
the `--skip-grant-tables` flag so you can reset the root password.
  

HTH,
--
Hassan Schroeder - [EMAIL PROTECTED]
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com
  dream.  code.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Uninstall MySQL for Panther?

[John Mistler]

I am two days into troubleshooting this.  I need some help badly.

I installed MySQL 4.0.18 for Mac.  I was able to get in at first:

Welcome to MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14 to server version: 4.0.18-standard

then I would type mysql> create database mytest;

and get: ERROR 1044: Access denied for user: '@localhost' to database
'mytest'

I tried all kinds of commands to change the root password, and every single
one would result in "Access denied for user . . . "

I would like to install, instead, CompleteMySQL from the
serverlogisitics.com site, which has interfaces to help newbies like me.
However, it is only at version 4.0.15.  So my question is:

How can I UNINSTALL the current 4.0.18 version I already have, before
installing the other one?

Thanks,

John



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Server AutoStart on Mac OS X 10.3.2 Panther

[Paul DuBois]

At 16:26 -0500 2/24/04, Tristan Fiedler wrote:
Hi All,

Thank you very much for the kind and ample help !

I am running Mac OS X 10.3.2 Panther, and per the MySQL (DuBois) book have
created a new user 'mysqladm' to run the server.
I manually start the server now via :

sudo mysqld_safe --user=mysqladm

I have two questions :

1. Why does 'mysqld' appear as a process under both (Is this OK/secure?):

top -U root   (although here, it does not seem to be "consuming any time")

top -U mysqladm

2.  Since I have created this new account solely for running the server,
how do I enable automatic starting of the server when I reboot?  I read
that Mac OSX has /Library/StartupItems /System/Library/StartupItems & also
a nice packaged 'Installer' but I am worried that my --user=mysqladm will
not be configured properly with this installer.
Grab that Startup Item package from www.mysql.com and install it.
Then look under /System/Library/StartupItems/MySQL.  In that directory,
you'll find a file named "MySQL".  Find the lines where it looks for the
server and change them to have values appropriate for your system.
For example, the edited version might look like this:

cd /usr/local/mysql

# We have to find out if we're starting a 3.x or a 4.x
# MySQL database server
#
if [ -e ./bin/safe_mysqld ]
then
   
# This is version 3.x
#
#./bin/safe_mysqld --user=mysql &
./bin/safe_mysqld --user=mysqladm &
   
elif [ -e ./bin/mysqld_safe ]
then
   
# This is version 4.x
#
#./bin/mysqld_safe --user=mysql &
./bin/mysqld_safe --user=mysqladm &

You'll probably want to change the cd command, too, if your installation
is located somewhere other than /usr/local/mysql.
Or else make /usr/local/mysql a symlink to your actual installation
directory.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Server AutoStart on Mac OS X 10.3.2 Panther

[Tristan Fiedler]

Hi All,

Thank you very much for the kind and ample help !

I am running Mac OS X 10.3.2 Panther, and per the MySQL (DuBois) book have
created a new user 'mysqladm' to run the server.

I manually start the server now via :

sudo mysqld_safe --user=mysqladm

I have two questions :

1. Why does 'mysqld' appear as a process under both (Is this OK/secure?):

top -U root   (although here, it does not seem to be "consuming any time")

top -U mysqladm

2.  Since I have created this new account solely for running the server,
how do I enable automatic starting of the server when I reboot?  I read
that Mac OSX has /Library/StartupItems /System/Library/StartupItems & also
a nice packaged 'Installer' but I am worried that my --user=mysqladm will
not be configured properly with this installer.

Thank you all for any help!

Cheers,

Tristan

-- 
Tristan J. Fiedler, Ph.D.
Postdoctoral Research Fellow - Walsh Laboratory
NIEHS Marine & Freshwater Biomedical Sciences Center
Rosenstiel School of Marine & Atmospheric Sciences
University of Miami

[EMAIL PROTECTED]
[EMAIL PROTECTED] (alias)
305-361-4626

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: can't install DBI on panther

[tait sanders]

well I finally got DBI 1.40 installed thanks to all you lot.

FYI - I installed all the developer tools - not the select few I had  
chosen previously,
then modified the mysql_config and the makefile created.
this worked.

thanks heaps for all the help.

ta
tait
On 27/01/2004, at 6:00 PM, Steve Folly wrote:

On 27 Jan 2004, at 00:37, tait sanders wrote:

i've run both 'perl -MCPAN -eshell' and 'make DBI' and both come back  
reporting heaps of errors like the following:

"from Perl.xs:1:
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
380:30: sys/types.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
411:19: ctype.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
423:23: locale.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
440:20: setjmp.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
446:26: sys/param.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
451:23: stdlib.h: No such file or directory


At a guess, I'd say you haven't installed the Developer Tools. That  
installs /usr/include which you appear to be missing.

HTH
Steve.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

tait sanders
computer technician
sir robert webster bldg
trc
unsw

Re: can't install DBI on panther

[Steve Folly]

On 27 Jan 2004, at 00:37, tait sanders wrote:

i've run both 'perl -MCPAN -eshell' and 'make DBI' and both come back  
reporting heaps of errors like the following:

"from Perl.xs:1:
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:380: 
30: sys/types.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:411: 
19: ctype.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:423: 
23: locale.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:440: 
20: setjmp.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:446: 
26: sys/param.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:451: 
23: stdlib.h: No such file or directory


At a guess, I'd say you haven't installed the Developer Tools. That  
installs /usr/include which you appear to be missing.

HTH
Steve.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: can't install DBI on panther

[Adam Goldstein]

Fink works excellent for DBI, and even for mysql. You can also change  
the mysql.info file to add compiler options, like G5 optimizations,  
openssl, etc.

http://fink.sourceforge.net/
--  
Adam Goldstein
White Wolf Networks
http://whitewlf.net

On Jan 26, 2004, at 8:50 PM, tait sanders wrote:

i'm already logged in as SU so sudo won't help.
thanks anyways.
ta
tait
On 27/01/2004, at 12:12 PM, Douglas Sims wrote:

I installed DBI and dbd:mysql on 10.3.2 a few months ago and had all  
sort of problems but I finally got it to work.

I don't exactly remember what finally did it, though.  I think it  
might have been running the install with sudo, as in:
sudo perl -MCPAN ... etc.

but I'm not sure.  If you haven't tried that, perhaps it will work.

I've been trying to install GD (gd-2.0.21) off and on for a few days  
now and meeting with the same frustration.  I build zlib, libpng,  
jpeg-6b without any errors, but gd blows up when I make.

Here is the specific part of the build which blows up:

gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/X11R6/include  
-I/usr/X11R6/include/freetype2 -I/usr/X11R6/include -g -O2 -MT  
gd_jpeg.lo -MD -MP -MF .deps/gd_jpeg.Tpo -c gd_jpeg.c  -fno-common  
-DPIC -o .libs/gd_jpeg.lo
gd_jpeg.c:41:21: jpeglib.h: No such file or directory
gd_jpeg.c:42:20: jerror.h: No such file or directory
gd_jpeg.c:54: error: parse error before "cinfo"
gd_jpeg.c: In function `fatal_jpeg_error':

I don't find gd_jpeg.lo anywhere, but I'm not sure what this means.

I find gd_jpeg.Plo in the .deps directory.  I'm sorry, I don't know  
what a .Plo or .lo file is.  The .Plo file just contains "#dummy".   
This is a bit off-topic from mysql or the original question, I'm  
afraid.



tait sanders wrote:

i've run both 'perl -MCPAN -eshell' and 'make DBI' and both come  
back  reporting heaps of errors like the following:

"from Perl.xs:1:
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
380: 30: sys/types.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
411: 19: ctype.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
423: 23: locale.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
440: 20: setjmp.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
446: 26: sys/param.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
451: 23: stdlib.h: No such file or directory

/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
1749:  error: parse error before "STRLEN"
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
1749:  warning: type defaults to `int' in declaration of `STRLEN'
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
1749:  warning: data definition has no type or storage class
In file included from   
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h: 
121,
 from   
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
1805,
 from DBIXS.h:19,
 from Perl.xs:1:
/usr/include/gcc/darwin/3.3/inttypes.h:33:72: sys/cdefs.h: No such  
file  or directory
/usr/include/gcc/darwin/3.3/inttypes.h:34:56: machine/ansi.h: No  
such  file or directory
In file included from /usr/include/gcc/darwin/3.3/inttypes.h:35,
 from   
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h: 
121,
 from   
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
1805,
 from DBIXS.h:19,
 from Perl.xs:1:
/usr/include/gcc/darwin/3.3/stdint.h:24:27: machine/types.h: No such  
 file or directory
In file included from /usr/include/gcc/darwin/3.3/inttypes.h:35,
 from   
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h: 
121,
 from   
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
1805,
 from DBIXS.h:19,
 from Perl.xs:1:
/usr/include/gcc/darwin/3.3/stdint.h:34: error: parse error before   
"uint8_t"
/usr/include/gcc/darwin/3.3/stdint.h:35: error: parse error before   
"uint16_t"
/usr/include/gcc/darwin/3.3/stdint.h:36: error: parse error before   
"uint32_t"
/usr/include/gcc/darwin/3.3/stdint.h:37: error: parse error before   
"uint64_t"
/usr/include/gcc/darwin/3.3/stdint.h:41: error: parse error before   
"int_least8_t"
/usr/include/gcc/darwin/3.3/stdint.h:42: error: parse error before   
"int_least16_t"
/usr/include/gcc/darwin/3.3/stdint.h:43: error: parse error before   
"int_least32_t""

etc etc etc

this just goes on and on...

what am I to do to get DBI installed on my OS10.3??

please help

ta
tait


On 22/01/2004, at 5:42 AM, Moritz von Schweinitz wrote:

i've never used MT, but this kinda sounds as if you dont have the  
DBI  installed:

$ perl -MCPAN -eshell
install DBI
c

Re: can't install DBI on panther

[tait sanders]

i'm already logged in as SU so sudo won't help.
thanks anyways.
ta
tait
On 27/01/2004, at 12:12 PM, Douglas Sims wrote:

I installed DBI and dbd:mysql on 10.3.2 a few months ago and had all  
sort of problems but I finally got it to work.

I don't exactly remember what finally did it, though.  I think it  
might have been running the install with sudo, as in:
sudo perl -MCPAN ... etc.

but I'm not sure.  If you haven't tried that, perhaps it will work.

I've been trying to install GD (gd-2.0.21) off and on for a few days  
now and meeting with the same frustration.  I build zlib, libpng,  
jpeg-6b without any errors, but gd blows up when I make.

Here is the specific part of the build which blows up:

gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/X11R6/include  
-I/usr/X11R6/include/freetype2 -I/usr/X11R6/include -g -O2 -MT  
gd_jpeg.lo -MD -MP -MF .deps/gd_jpeg.Tpo -c gd_jpeg.c  -fno-common  
-DPIC -o .libs/gd_jpeg.lo
gd_jpeg.c:41:21: jpeglib.h: No such file or directory
gd_jpeg.c:42:20: jerror.h: No such file or directory
gd_jpeg.c:54: error: parse error before "cinfo"
gd_jpeg.c: In function `fatal_jpeg_error':

I don't find gd_jpeg.lo anywhere, but I'm not sure what this means.

I find gd_jpeg.Plo in the .deps directory.  I'm sorry, I don't know  
what a .Plo or .lo file is.  The .Plo file just contains "#dummy".   
This is a bit off-topic from mysql or the original question, I'm  
afraid.



tait sanders wrote:

i've run both 'perl -MCPAN -eshell' and 'make DBI' and both come back  
 reporting heaps of errors like the following:

"from Perl.xs:1:
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
380: 30: sys/types.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
411: 19: ctype.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
423: 23: locale.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
440: 20: setjmp.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
446: 26: sys/param.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
451: 23: stdlib.h: No such file or directory

/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
1749:  error: parse error before "STRLEN"
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
1749:  warning: type defaults to `int' in declaration of `STRLEN'
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
1749:  warning: data definition has no type or storage class
In file included from   
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h: 
121,
 from   
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
1805,
 from DBIXS.h:19,
 from Perl.xs:1:
/usr/include/gcc/darwin/3.3/inttypes.h:33:72: sys/cdefs.h: No such  
file  or directory
/usr/include/gcc/darwin/3.3/inttypes.h:34:56: machine/ansi.h: No such  
 file or directory
In file included from /usr/include/gcc/darwin/3.3/inttypes.h:35,
 from   
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h: 
121,
 from   
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
1805,
 from DBIXS.h:19,
 from Perl.xs:1:
/usr/include/gcc/darwin/3.3/stdint.h:24:27: machine/types.h: No such   
file or directory
In file included from /usr/include/gcc/darwin/3.3/inttypes.h:35,
 from   
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h: 
121,
 from   
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h: 
1805,
 from DBIXS.h:19,
 from Perl.xs:1:
/usr/include/gcc/darwin/3.3/stdint.h:34: error: parse error before   
"uint8_t"
/usr/include/gcc/darwin/3.3/stdint.h:35: error: parse error before   
"uint16_t"
/usr/include/gcc/darwin/3.3/stdint.h:36: error: parse error before   
"uint32_t"
/usr/include/gcc/darwin/3.3/stdint.h:37: error: parse error before   
"uint64_t"
/usr/include/gcc/darwin/3.3/stdint.h:41: error: parse error before   
"int_least8_t"
/usr/include/gcc/darwin/3.3/stdint.h:42: error: parse error before   
"int_least16_t"
/usr/include/gcc/darwin/3.3/stdint.h:43: error: parse error before   
"int_least32_t""

etc etc etc

this just goes on and on...

what am I to do to get DBI installed on my OS10.3??

please help

ta
tait


On 22/01/2004, at 5:42 AM, Moritz von Schweinitz wrote:

i've never used MT, but this kinda sounds as if you dont have the  
DBI  installed:

$ perl -MCPAN -eshell
install DBI
cheers,
M.
tait sanders wrote:

hi all,
not sure if this is the appropriate place to post this -- so please  
 point me in the right direction if not here...
I have a G4 with os10.3.2 server, mysql v4.0.16, and MoveableType  
2.6
I'm trying to initialise the moveabletype system by running   
mt-lo

Re: can't install DBI on panther

[Douglas Sims]

I installed DBI and dbd:mysql on 10.3.2 a few months ago and had all 
sort of problems but I finally got it to work.

I don't exactly remember what finally did it, though.  I think it might 
have been running the install with sudo, as in:
sudo perl -MCPAN ... etc.

but I'm not sure.  If you haven't tried that, perhaps it will work.

I've been trying to install GD (gd-2.0.21) off and on for a few days now 
and meeting with the same frustration.  I build zlib, libpng, jpeg-6b 
without any errors, but gd blows up when I make.

Here is the specific part of the build which blows up:

gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/X11R6/include 
-I/usr/X11R6/include/freetype2 -I/usr/X11R6/include -g -O2 -MT 
gd_jpeg.lo -MD -MP -MF .deps/gd_jpeg.Tpo -c gd_jpeg.c  -fno-common -DPIC 
-o .libs/gd_jpeg.lo
gd_jpeg.c:41:21: jpeglib.h: No such file or directory
gd_jpeg.c:42:20: jerror.h: No such file or directory
gd_jpeg.c:54: error: parse error before "cinfo"
gd_jpeg.c: In function `fatal_jpeg_error':

I don't find gd_jpeg.lo anywhere, but I'm not sure what this means.

I find gd_jpeg.Plo in the .deps directory.  I'm sorry, I don't know what 
a .Plo or .lo file is.  The .Plo file just contains "#dummy".  This is a 
bit off-topic from mysql or the original question, I'm afraid.



tait sanders wrote:

i've run both 'perl -MCPAN -eshell' and 'make DBI' and both come back  
reporting heaps of errors like the following:

"from Perl.xs:1:
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:380: 
30: sys/types.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:411: 
19: ctype.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:423: 
23: locale.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:440: 
20: setjmp.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:446: 
26: sys/param.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:451: 
23: stdlib.h: No such file or directory

/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1749:  
error: parse error before "STRLEN"
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1749:  
warning: type defaults to `int' in declaration of `STRLEN'
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1749:  
warning: data definition has no type or storage class
In file included from  
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h:121,
 from  
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1805,
 from DBIXS.h:19,
 from Perl.xs:1:
/usr/include/gcc/darwin/3.3/inttypes.h:33:72: sys/cdefs.h: No such 
file  or directory
/usr/include/gcc/darwin/3.3/inttypes.h:34:56: machine/ansi.h: No such  
file or directory
In file included from /usr/include/gcc/darwin/3.3/inttypes.h:35,
 from  
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h:121,
 from  
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1805,
 from DBIXS.h:19,
 from Perl.xs:1:
/usr/include/gcc/darwin/3.3/stdint.h:24:27: machine/types.h: No such  
file or directory
In file included from /usr/include/gcc/darwin/3.3/inttypes.h:35,
 from  
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h:121,
 from  
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1805,
 from DBIXS.h:19,
 from Perl.xs:1:
/usr/include/gcc/darwin/3.3/stdint.h:34: error: parse error before  
"uint8_t"
/usr/include/gcc/darwin/3.3/stdint.h:35: error: parse error before  
"uint16_t"
/usr/include/gcc/darwin/3.3/stdint.h:36: error: parse error before  
"uint32_t"
/usr/include/gcc/darwin/3.3/stdint.h:37: error: parse error before  
"uint64_t"
/usr/include/gcc/darwin/3.3/stdint.h:41: error: parse error before  
"int_least8_t"
/usr/include/gcc/darwin/3.3/stdint.h:42: error: parse error before  
"int_least16_t"
/usr/include/gcc/darwin/3.3/stdint.h:43: error: parse error before  
"int_least32_t""

etc etc etc

this just goes on and on...

what am I to do to get DBI installed on my OS10.3??

please help

ta
tait


On 22/01/2004, at 5:42 AM, Moritz von Schweinitz wrote:

i've never used MT, but this kinda sounds as if you dont have the 
DBI  installed:

$ perl -MCPAN -eshell
install DBI
cheers,
M.
tait sanders wrote:

hi all,
not sure if this is the appropriate place to post this -- so please  
point me in the right direction if not here...
I have a G4 with os10.3.2 server, mysql v4.0.16, and MoveableType 2.6
I'm trying to initialise the moveabletype system by running  
mt-load.cgi and am recieving the following error:
"Unsupported driver MT::ObjectDriver::DBI::mysql: Can't locate 
DBI.pm  in @INC..."
I've checked in my mt.cfg file and I have adde

can't install DBI on panther

[tait sanders]

i've run both 'perl -MCPAN -eshell' and 'make DBI' and both come back  
reporting heaps of errors like the following:

"from Perl.xs:1:
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:380: 
30: sys/types.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:411: 
19: ctype.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:423: 
23: locale.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:440: 
20: setjmp.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:446: 
26: sys/param.h: No such file or directory
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:451: 
23: stdlib.h: No such file or directory

/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1749:  
error: parse error before "STRLEN"
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1749:  
warning: type defaults to `int' in declaration of `STRLEN'
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1749:  
warning: data definition has no type or storage class
In file included from  
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h:121,
 from  
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1805,
 from DBIXS.h:19,
 from Perl.xs:1:
/usr/include/gcc/darwin/3.3/inttypes.h:33:72: sys/cdefs.h: No such file  
or directory
/usr/include/gcc/darwin/3.3/inttypes.h:34:56: machine/ansi.h: No such  
file or directory
In file included from /usr/include/gcc/darwin/3.3/inttypes.h:35,
 from  
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h:121,
 from  
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1805,
 from DBIXS.h:19,
 from Perl.xs:1:
/usr/include/gcc/darwin/3.3/stdint.h:24:27: machine/types.h: No such  
file or directory
In file included from /usr/include/gcc/darwin/3.3/inttypes.h:35,
 from  
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/handy.h:121,
 from  
/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE/perl.h:1805,
 from DBIXS.h:19,
 from Perl.xs:1:
/usr/include/gcc/darwin/3.3/stdint.h:34: error: parse error before  
"uint8_t"
/usr/include/gcc/darwin/3.3/stdint.h:35: error: parse error before  
"uint16_t"
/usr/include/gcc/darwin/3.3/stdint.h:36: error: parse error before  
"uint32_t"
/usr/include/gcc/darwin/3.3/stdint.h:37: error: parse error before  
"uint64_t"
/usr/include/gcc/darwin/3.3/stdint.h:41: error: parse error before  
"int_least8_t"
/usr/include/gcc/darwin/3.3/stdint.h:42: error: parse error before  
"int_least16_t"
/usr/include/gcc/darwin/3.3/stdint.h:43: error: parse error before  
"int_least32_t""

etc etc etc

this just goes on and on...

what am I to do to get DBI installed on my OS10.3??

please help

ta
tait


On 22/01/2004, at 5:42 AM, Moritz von Schweinitz wrote:

i've never used MT, but this kinda sounds as if you dont have the DBI  
installed:

$ perl -MCPAN -eshell
install DBI
cheers,
M.
tait sanders wrote:
hi all,
not sure if this is the appropriate place to post this -- so please  
point me in the right direction if not here...
I have a G4 with os10.3.2 server, mysql v4.0.16, and MoveableType 2.6
I'm trying to initialise the moveabletype system by running  
mt-load.cgi and am recieving the following error:
"Unsupported driver MT::ObjectDriver::DBI::mysql: Can't locate DBI.pm  
in @INC..."
I've checked in my mt.cfg file and I have added:
"ObjectDriver DBI::mysql
Database /var/mysql/mtweblog
DBUser labadmin"
so I don't understand what's going on.
please help
ta
tait
tait sanders
computer technician
sir robert webster bldg
trc
unsw


tait sanders
computer technician
sir robert webster bldg
trc
unsw

Re: So, how do you REALLY install MySQL in Mac OS X (Panther)?!

[Michael Stassen]

Daniel Lahey wrote:

Ok, I've read the release notes, the manual, the threads on this mailing 
list, installed/removed/re-installed about 5 times, tried 4.0.1, 4.1, 
5.0, and I can't get MySQL to run on my Mac (dual-proc 867MHz, 768MB 
RAM).  When I run configure, it tells me everything is hunky-dory and 
that I should just be happy and run mysqld.  I try to run mysqld and it 
immediately aborts and tells me that /tmp/mysql.sock isn't set up.  If I 
try to run mysqladmin -u root password  just like the manual 
tells me to, it aborts as above and tells me to run mysqld (or 
mysqld_safe).  The manual tells me I can "just click on the dmg file and 
follow the instructions."  I've done that for both the distribution and 
the startup item several times (and re-started several times in 
between).  I've read the manual about security and the root user account 
as the message instructed me to do.  No help.  I even tried to compile 
the control center using the instructions I found for that, installed Qt 
as instructed, compiled it (I think, the instructions for that were 
along the lines of: "Now just compile it and you're all done!"  Hah!  Do 
you hear me?  Hah, I say.)  The "instructions" don't tell me where to 
install it or how to test for a valid installation.  When I try to 
compile CC it says "install Qt first."  I did.  3 times.  In 3 different 
places.  Copied all of the include and lib files all over the freakin' 
hard drive to try to make it happy.  Not happy.

Ok, now, are there REAL instructions for installing some working version 
of MySQL on a Mac somewhere?  What do I REALLY have to do?  Has someone 
actually documented the entire process or does the documentation consist 
of the vague, scattered hints I've been able to find?  I'd love to check 
out MySQL, but do I have to learn a secret handshake or pledge 
allegiance to Open Source or something?

Thanks for any help.  Sorry to rant, but I've been working on this for 
three days now.

- Dan

P.S. Any notes on using it with Xcode would be appreciated, too.

Dan,

I started with mysql 4.0.15 on 10.2.1 and am currently running 4.0.17 on 
10.3.2, so the good news is that this should be possible for you.  I can 
 imagine your frustration at this point, but you haven't provided 
enough information to diagnose the problem.  I can tell that the server, 
mysqld, is failing to start for you, so none of the steps after that 
(mysqladmin, for example) will work until that problem is fixed, as they 
all require a running server.

Because it is often the problem, and easy to fix, I'll go out on a limb 
and guess the problem may be the permissions on your /tmp directory. 
(At least one of the Mac OS X updates incorrectly sets the permissions 
on /tmp.)  MySQL runs as the mysql user, so that user must have 
permission to create the socket (/tmp/mysql.sock) in /tmp.  In the 
terminal, try this

  cd /tmp
  ls -l
The second line of output from ls (the one with ./) should look like this

  drwxrwxrwt  5 root   wheel  170 22 Jan 17:00 ./

If it does not, you should run

  sudo chmod 1777 .

then try to start mysql (sudo mysqld_safe) again.

As I said, that was just a guess.  If that's not it, we'll need more 
information to properly diagnose the problem.  The first thing to do is 
look at the error log.  I expect you have mysql installed in 
/usr/local/mysql, with data and log files in /usr/local/mysql/data.  In 
the data directory there should be a file named hostname.err (where 
hostname is the name of your computer).  This file should contain a line 
or two explaining why mysql failed to start up.  If you need further 
help, tell us what error message you get when you try mysqld_safe 
(copy/paste), what hostname.err says, what version of mysql, and what 
version of OS X you have.

Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: So, how do you REALLY install MySQL in Mac OS X (Panther)?!

[Santino]

I installed MySql 4.0.x on MacOs 10.2.x and it works fine.

There are some problems of permissions: check /tmp and mysql data directory.

Santino

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: So, how do you REALLY install MySQL in Mac OS X (Panther)?!

[Paul DuBois]

At 22:39 -0800 1/21/04, Daniel Lahey wrote:
Ok, I've read the release notes, the manual, the threads on this 
mailing list, installed/removed/re-installed about 5 times, tried 
4.0.1, 4.1, 5.0, and I can't get MySQL to run on my Mac (dual-proc 
867MHz, 768MB RAM).  When I run configure, it tells me everything is 
hunky-dory and that I should just be happy and run mysqld.  I try to 
run mysqld and it immediately aborts and tells me that 
/tmp/mysql.sock isn't set up.  If I try to run mysqladmin -u root
Exact command used to start mysqld, and exact text of the error messages,
please -- not a text description of what happened.
password  just like the manual tells me to, it aborts as 
above and tells me to run mysqld (or mysqld_safe).  The manual tells 
me I can "just
That makes sense. mysqladmin has to connect to the server. If the server
isn't running, none of the client programs will work.
click on the dmg file and follow the instructions."  I've done that 
for both the distribution and the startup item several times (and 
re-started several times in between).  I've read the manual about 
security and the root user account as the message instructed me to 
do.  No help.  I even tried to compile the control center using the 
instructions I found for that, installed Qt as instructed, compiled 
it (I think, the instructions for that were along the lines of: "Now 
just compile it and you're all done!"  Hah!  Do you hear me?  Hah, I 
say.)  The "instructions" don't tell me where to install it or how 
to test for a valid installation.  When I try to compile CC it says 
"install Qt first."  I did.  3 times.  In 3 different places. 
Copied all of the include and lib files all over the freakin' hard 
drive to try to make it happy.  Not happy.

Ok, now, are there REAL instructions for installing some working 
version of MySQL on a Mac somewhere?  What do I REALLY have to do? 
Has someone actually documented the entire process or does the 
documentation consist of the vague, scattered hints I've been able 
to find?  I'd love to check out MySQL, but do I have to learn a 
secret handshake or pledge allegiance to Open Source or something?

Thanks for any help.  Sorry to rant, but I've been working on this 
for three days now.

- Dan

P.S. Any notes on using it with Xcode would be appreciated, too.


--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: So, how do you REALLY install MySQL in Mac OS X (Panther)?!

[sulewski]

wow! That is nice

On Thursday, January 22, 2004, at 01:28  PM, Eve Atley wrote:

This one actually installs a preference pane that allow you to 
manipulate
settings, start/stop server, and change root password. It's quite nice.

- Eve

-Original Message-
From: sulewski [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 7:25 AM
To: Eve Atley
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: So, how do you REALLY install MySQL in Mac OS X 
(Panther)?!

I think this is the package I used. The one that I used actually wrote
and init script so if you reboot mysql will start automagically.   I
think this is the one.
Joe

On Thursday, January 22, 2004, at 08:51  AM, Eve Atley wrote:

I successfully used the packages from Server Logistics for this task,
installing PHP, Apache and MySQL first on my 10.2.8 Jaguar, then on my
10.3.2 Panther G4.
http://www.serverlogistics.com/mysql.php
- Eve



--
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]

RE: So, how do you REALLY install MySQL in Mac OS X (Panther)?!

[Eve Atley]

This one actually installs a preference pane that allow you to manipulate
settings, start/stop server, and change root password. It's quite nice.

- Eve

-Original Message-
From: sulewski [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 7:25 AM
To: Eve Atley
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: So, how do you REALLY install MySQL in Mac OS X (Panther)?!


I think this is the package I used. The one that I used actually wrote
and init script so if you reboot mysql will start automagically.   I
think this is the one.

Joe

On Thursday, January 22, 2004, at 08:51  AM, Eve Atley wrote:

>
> I successfully used the packages from Server Logistics for this task,
> installing PHP, Apache and MySQL first on my 10.2.8 Jaguar, then on my
> 10.3.2 Panther G4.
> http://www.serverlogistics.com/mysql.php
>
> - Eve
>
>
>
> --
> 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]

Re: So, how do you REALLY install MySQL in Mac OS X (Panther)?!

[sulewski]

I think this is the package I used. The one that I used actually wrote 
and init script so if you reboot mysql will start automagically.   I 
think this is the one.

Joe

On Thursday, January 22, 2004, at 08:51  AM, Eve Atley wrote:

I successfully used the packages from Server Logistics for this task,
installing PHP, Apache and MySQL first on my 10.2.8 Jaguar, then on my
10.3.2 Panther G4.
http://www.serverlogistics.com/mysql.php
- Eve



--
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]

Re: So, how do you REALLY install MySQL in Mac OS X (Panther)?!

[Eve Atley]

I successfully used the packages from Server Logistics for this task,
installing PHP, Apache and MySQL first on my 10.2.8 Jaguar, then on my
10.3.2 Panther G4.
http://www.serverlogistics.com/mysql.php

- Eve



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: So, how do you REALLY install MySQL in Mac OS X (Panther)?!

[Nicholas]

Hi Daniel,

You are not alone in your quest to successfully start the mysqld 
server on a Mac OSX platform.  I am having similiar difficulty 
on my ibook...


 --- On Thu 01/22, Daniel Lahey < [EMAIL PROTECTED] > wrote:
From: Daniel Lahey [mailto: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Wed, 21 Jan 2004 22:39:39 -0800
Subject: So, how do you REALLY install MySQL in Mac OS X (Panther)?!

Ok, I've read the release notes, the manual, the threads on this mailing list, 
installed/removed/re-installed about 5 times, tried 4.0.1, 4.1, 5.0, and I can't 
get MySQL to run on my Mac (dual-proc 867MHz, 768MB RAM).  When I run configure, 
it tells me everything is hunky-dory and that I should just be happy and run 
mysqld.  I try to run mysqld and it immediately aborts and tells me that 
/tmp/mysql.sock isn't set up.  If I try to run mysqladmin -u root password 
 just like the manual tells me to, it aborts as above and tells me to 
run mysqld (or mysqld_safe).  The manual tells me I can "just click on the dmg 
file and follow the instructions."  I've done that for both the distribution and 
the startup item several times (and re-started several times in between).  I've 
read the manual about security and the root user account as the message instructed 
me to do.  No help.  I even tried to compile the control center using the 
instructions I found for that, installed Qt as instructed, compiled it (I think, 
the instructions for that were along the lines of: "Now just compile it and 
you're all done!"  Hah!  Do you hear me?  Hah, I say.)  The "instructions" 
don't tell me where to install it or how to test for a valid installation.  When I 
try to compile CC it says "install Qt first."  I did.  3 times.  In 3 different 
places.  Copied all of the include and lib files all over the freakin' hard drive 
to try to make it happy.  Not happy.Ok, now, are there REAL instructions 
for installing some working version of MySQL on a Mac somewhere?  What do I REALLY 
have to do?  Has someone actually documented the entire process or does the 
documentation consist of the vague, scattered hints I've been able to find?  
I'd love to check out MySQL, but do I have to learn a secret handshake or pledge 
allegiance to Open Source or something?Thanks for any help.  Sorry to rant, 
but I've been working on this for three days now.- DanP.S. Any 
notes on using it with Xcode would be appreciated, too.-- MySQL 
General Mailing ListFor list archives: http://lists.mysql.com/mysqlTo 
unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

___
Join Excite! - http://www.excite.com
The most personalized portal on the Web!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

So, how do you REALLY install MySQL in Mac OS X (Panther)?!

[Daniel Lahey]

Ok, I've read the release notes, the manual, the threads on this 
mailing list, installed/removed/re-installed about 5 times, tried 
4.0.1, 4.1, 5.0, and I can't get MySQL to run on my Mac (dual-proc 
867MHz, 768MB RAM).  When I run configure, it tells me everything is 
hunky-dory and that I should just be happy and run mysqld.  I try to 
run mysqld and it immediately aborts and tells me that /tmp/mysql.sock 
isn't set up.  If I try to run mysqladmin -u root password  
just like the manual tells me to, it aborts as above and tells me to 
run mysqld (or mysqld_safe).  The manual tells me I can "just click on 
the dmg file and follow the instructions."  I've done that for both the 
distribution and the startup item several times (and re-started several 
times in between).  I've read the manual about security and the root 
user account as the message instructed me to do.  No help.  I even 
tried to compile the control center using the instructions I found for 
that, installed Qt as instructed, compiled it (I think, the 
instructions for that were along the lines of: "Now just compile it and 
you're all done!"  Hah!  Do you hear me?  Hah, I say.)  The 
"instructions" don't tell me where to install it or how to test for a 
valid installation.  When I try to compile CC it says "install Qt 
first."  I did.  3 times.  In 3 different places.  Copied all of the 
include and lib files all over the freakin' hard drive to try to make 
it happy.  Not happy.

Ok, now, are there REAL instructions for installing some working 
version of MySQL on a Mac somewhere?  What do I REALLY have to do?  Has 
someone actually documented the entire process or does the 
documentation consist of the vague, scattered hints I've been able to 
find?  I'd love to check out MySQL, but do I have to learn a secret 
handshake or pledge allegiance to Open Source or something?

Thanks for any help.  Sorry to rant, but I've been working on this for 
three days now.

- Dan

P.S. Any notes on using it with Xcode would be appreciated, too.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Installing Mysql on Panther

[Ed Leafe]

On Dec 19, 2003, at 12:58 AM, Trebor Scholz wrote:

I'd like to install mysql on OSX Panther.
In my tutorial it suggests to switch
Web Sharing off in the preferences but
There are many options in the menu there and web sharing off
Is not one of them.
	Perhaps they mean to go to the System Preferences, and turn off Web 
Sharing in the "Sharing" preference pane.

 ___/
/
   __/
  /
 /
 Ed Leafe
 http://leafe.com/
 http://opentech.leafe.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Installing Mysql on Panther

[Trebor Scholz]

Hi,

I'd like to install mysql on OSX Panther.
In my tutorial it suggests to switch
Web Sharing off in the preferences but
There are many options in the menu there and web sharing off
Is not one of them.

Any suggestions?

Best,
Trebor


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

[Jan Pieter Kunst]

If you're using only MyISAM tables for your data, then key_buffer 
should generally have as much RAM as it can have (up to the point 
where it makes sense, i.e., only has much RAM as is needed to store 
your index data). myisam_sort_buffer_size ought to be about 1/4 of 
your RAM.
I re-ran the benchmarks with a 'tuned' my.cnf (much more memory for 
various variables). It looks to me like there is no significant 
difference in the results.

I checked (with phpmyadmin, MySQL system variables) if the new my.cnf 
was actually being used: it was.

JP

New my.cnf + benchmark results:
==
set-variable= key_buffer=512M
set-variable= max_allowed_packet=1M
set-variable= table_cache=1024
set-variable= sort_buffer=8M
set-variable= net_buffer_length=32K
set-variable= record_buffer=8M
set-variable= thread_cache=8
set-variable= myisam_sort_buffer_size=256M
alter-table: Total time: 181 wallclock secs ( 0.21 usr  0.05 sys + 
0.00 cusr  0.00 csys =  0.26 CPU)
ATIS: Total time: 63 wallclock secs ( 5.06 usr  6.26 sys +  0.00 cusr 
0.00 csys = 11.32 CPU)
big-tables: Total time: 55 wallclock secs ( 6.60 usr 14.08 sys + 
0.00 cusr  0.00 csys = 20.68 CPU)
connect: Total time: 235 wallclock secs (36.76 usr 37.77 sys +  0.00 
cusr  0.00 csys = 74.53 CPU)
create: Total time: 287 wallclock secs ( 7.25 usr  2.56 sys +  0.00 
cusr  0.00 csys =  9.81 CPU)
insert: Total time: 3018 wallclock secs (415.53 usr 260.06 sys + 
0.00 cusr  0.00 csys = 675.59 CPU)
select: Total time: 1371 wallclock secs (46.60 usr 23.62 sys +  0.00 
cusr  0.00 csys = 70.22 CPU)
transactions: Test skipped because the database doesn't support transactions
wisconsin: Total time: 25 wallclock secs ( 2.67 usr  2.41 sys +  0.00 
cusr  0.00 csys =  5.08 CPU)

Old my.cnf + benchmark results:
==
set-variable   = key_buffer=64M
set-variable   = max_allowed_packet=1M
set-variable   = table_cache=256
set-variable   = sort_buffer=4M
set-variable   = net_buffer_length=8K
set-variable   = record_buffer=1M
set-variable   = thread_cache=8
set-variable   = myisam_sort_buffer_size=8M
alter-table: Total time: 141 wallclock secs ( 0.22 usr  0.11 sys + 
0.00 cusr  0.00 csys =  0.33 CPU)
ATIS: Total time: 59 wallclock secs (10.59 usr  6.30 sys +  0.00 cusr 
0.00 csys = 16.89 CPU)
big-tables: Total time: 57 wallclock secs ( 7.53 usr 13.50 sys + 0.00 
cusr  0.00 csys = 21.03 CPU)
connect: Total time: 252 wallclock secs (44.31 usr 38.81 sys +  0.00 
cusr  0.00 csys = 83.12 CPU)
create: Total time: 298 wallclock secs ( 8.76 usr  3.06 sys +  0.00 
cusr  0.00 csys = 11.82 CPU)
insert: Total time: 3316 wallclock secs (594.82 usr 261.66 sys + 0.00 
cusr  0.00 csys = 856.48 CPU)
select: Total time: 1428 wallclock secs (67.50 usr 25.18 sys +  0.00 
cusr  0.00 csys = 92.68 CPU)
transactions: Test skipped because the database doesn't support transactions
wisconsin: Total time: 27 wallclock secs ( 4.19 usr  2.58 sys +  0.00 
cusr  0.00 csys =  6.77 CPU)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

64bit G5 Panther compiles

[Adam Goldstein]

Is there any definitive answer yet for the ability to compile a 
working, 64bit Mysql?

The mysql documentation says that mysql performs far better for heavy 
queries using 64bit. I assume, also, that the new memory limits also 
help if you allow mysql to take advantage of them, as I have read in 
some recent ML entries. (which is not 8GB, btw,but 16GB according to 
the tech docs... 2GB sticks are just not really 'normal' yet.)

I am trying to move a client with a very heavy load off a current linux 
box (Dual Athlon, Dual U160) to use a Dual G5 2Ghz as a primary server 
(3G currently, 5G shortly), using the linux box as a backup&slave 
machine and for offloading mail and other services, and providing a hot 
rollover function. His site produces huge amounts of load currently, 
mostly due to large amounts of queries/page and large amounts of 
concurrent users.

Some info I found below, and I was wondering what would be the best 
config to try to compile mysql with to produce the best results.

http://developer.apple.com/technotes/tn/tn2087.html
...
"Take advantage of the full precision hardware square root
The G5 has a full-precision hardware square root implementation. If 
your code executes square root, check for the availability of the 
hardware square root in the G5 and execute code calling the instruction 
directly (e.g. __fsqrt()) instead of calling the sqrt() routine. (Use 
__fsqrts() for single-precision.) You can use the GCC compiler 
flags-mpowerpc-gpopt and -mpowerpc64 to transform sqrt() function calls 
directly into the PPC sqrt instruction.

Align hot code for maximum instruction dispatch

Alignment of code in memory is a more significant factor for 
performance on the G5 than on the G4. The G5 fetches instructions in 
aligned 32 byte blocks. Therefore, it is often profitable to align hot 
loops, branches, or branch targets to fetch boundaries. GCC 3.3 offers 
the following flags to align code: -falign-functions=32, 
-falign-labels=32,-falign-loops=32, -falign-jumps=32. Additionally, you 
may need to specify -falign-[functions, labels, loops, 
jumps]-max-skip=[15,31] to get the desired alignment."

...
I assume that adding -mpowerpc-gpopt and -mpowerpc64 to the gcc 
compiler will generally format the code towards the g5 and 64bit.. then 
again, I do not know much  about compiling past using configure and 
make ;)

I need it to be the fastest model, using the least resources but be 
stable... able to handle as many requests/sec as possible.  Sort of a 
"High Performance" fork of the Apache2/php/mysql set.  Mysql being the 
most important. ;)

--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

[Gabriel Ricard]

This is what I'm currently using on the dual 2GHz w/4GB of RAM:

set-variable = query_cache_type=1
set-variable = query_cache_size=1024M
set-variable = net_buffer_length=32760
set-variable = bulk_insert_buffer_size=32M
set-variable= key_buffer=1024M
set-variable= join_buffer_size=128M
set-variable= max_allowed_packet=8M
set-variable= table_cache=1024
set-variable= myisam_sort_buffer_size=1024M
set-variable= thread_concurrency=16
set-variable = thread_cache_size=16
set-variable = sort_buffer=8M
set-variable = read_rnd_buffer_size=8M
set-variable= record_buffer=8M
If you're using only MyISAM tables for your data, then key_buffer 
should generally have as much RAM as it can have (up to the point where 
it makes sense, i.e., only has much RAM as is needed to store your 
index data). myisam_sort_buffer_size ought to be about 1/4 of your RAM.

If you're using InnoDB as well, or if you use InnoDB tables only, then 
you should give innodb_buffer_pool_size a good portion of your RAM, and 
perhaps 16-32MB or so for innodb_additional_mem_pool_size.

- Gabriel

On Friday, November 7, 2003, at 06:32  PM, Jan Pieter Kunst wrote:

At 13:21 -0500 07-11-2003, Gabriel Ricard wrote:

[1.8 GHz G5:]

select: Total time: 1428 wallclock secs (67.50 usr 25.18 sys + 0.00 
cusr  0.00 csys = 92.68 CPU)
[dual 2.0 GHz G5:]

select: Total time: 146 wallclock secs (42.52 usr 33.74 sys +  0.00 
cusr  0.00 csys = 76.26 CPU)

How the select portion of the test could be 10x slower, I'm not sure. 
Have you tuned MySQL at all? key_buffer, etc?


Well, I'm looking for advice on how I should tune MySQL. These are the 
relevant parts of the my.cnf I used:

[mysqld]
skip-locking
set-variable   = key_buffer=64M
set-variable   = max_allowed_packet=1M
set-variable   = table_cache=256
set-variable   = sort_buffer=4M
set-variable   = net_buffer_length=8K
set-variable   = record_buffer=1M
set-variable   = thread_cache=8
set-variable   = myisam_sort_buffer_size=8M
log-bin
server-id   = 1
[mysqldump]
quick
set-variable   = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable   = key_buffer=20M
set-variable   = sort_buffer=20M
set-variable   = read_buffer=2M
set-variable   = write_buffer=2M
[myisamchk]
set-variable   = key_buffer=20M
set-variable   = sort_buffer=20M
set-variable   = read_buffer=2M
set-variable   = write_buffer=2M
If you have any advice on what I could change here to get faster 
selects, I'm all ears.

Thanks in advance,
Jan Pieter Kunst
--
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]

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

[Brent Baisley]

Look in the support-files directory in the mysql directory. There are a 
bunch of sample config files that you can look at that named pretty 
obviously: small,medium,large,huge.
Each one has a description on what kind of system these should be used 
on, based on RAM and usage. For instance, huge is for systems with 
512MB. If you have 2GB on your box, you may want to base your settings 
on the huge config file, which is for systems with 1-2GB.
I'm no expert on the settings so you may have to dig in the online 
manual to customize for your needs.

On Friday, November 7, 2003, at 06:32 PM, Jan Pieter Kunst wrote:

At 13:21 -0500 07-11-2003, Gabriel Ricard wrote:

[1.8 GHz G5:]

select: Total time: 1428 wallclock secs (67.50 usr 25.18 sys + 0.00 
cusr  0.00 csys = 92.68 CPU)
[dual 2.0 GHz G5:]

select: Total time: 146 wallclock secs (42.52 usr 33.74 sys +  0.00 
cusr  0.00 csys = 76.26 CPU)

How the select portion of the test could be 10x slower, I'm not sure. 
Have you tuned MySQL at all? key_buffer, etc?


Well, I'm looking for advice on how I should tune MySQL. These are the 
relevant parts of the my.cnf I used:

[mysqld]
skip-locking
set-variable   = key_buffer=64M
set-variable   = max_allowed_packet=1M
set-variable   = table_cache=256
set-variable   = sort_buffer=4M
set-variable   = net_buffer_length=8K
set-variable   = record_buffer=1M
set-variable   = thread_cache=8
set-variable   = myisam_sort_buffer_size=8M
log-bin
server-id   = 1
[mysqldump]
quick
set-variable   = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable   = key_buffer=20M
set-variable   = sort_buffer=20M
set-variable   = read_buffer=2M
set-variable   = write_buffer=2M
[myisamchk]
set-variable   = key_buffer=20M
set-variable   = sort_buffer=20M
set-variable   = read_buffer=2M
set-variable   = write_buffer=2M
If you have any advice on what I could change here to get faster 
selects, I'm all ears.

Thanks in advance,
Jan Pieter Kunst
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
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: MySQL benchmarks on the G5: Jaguar vs. Panther

[Jan Pieter Kunst]

At 13:21 -0500 07-11-2003, Gabriel Ricard wrote:

[1.8 GHz G5:]

select: Total time: 1428 wallclock secs (67.50 usr 25.18 sys + 
0.00 cusr  0.00 csys = 92.68 CPU)
[dual 2.0 GHz G5:]

select: Total time: 146 wallclock secs (42.52 usr 33.74 sys +  0.00 
cusr  0.00 csys = 76.26 CPU)

How the select portion of the test could be 10x slower, I'm not 
sure. Have you tuned MySQL at all? key_buffer, etc?


Well, I'm looking for advice on how I should tune MySQL. These are 
the relevant parts of the my.cnf I used:

[mysqld]
skip-locking
set-variable   = key_buffer=64M
set-variable   = max_allowed_packet=1M
set-variable   = table_cache=256
set-variable   = sort_buffer=4M
set-variable   = net_buffer_length=8K
set-variable   = record_buffer=1M
set-variable   = thread_cache=8
set-variable   = myisam_sort_buffer_size=8M
log-bin
server-id   = 1
[mysqldump]
quick
set-variable   = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable   = key_buffer=20M
set-variable   = sort_buffer=20M
set-variable   = read_buffer=2M
set-variable   = write_buffer=2M
[myisamchk]
set-variable   = key_buffer=20M
set-variable   = sort_buffer=20M
set-variable   = read_buffer=2M
set-variable   = write_buffer=2M
If you have any advice on what I could change here to get faster 
selects, I'm all ears.

Thanks in advance,
Jan Pieter Kunst
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

[Gabriel Ricard]

On Friday, November 7, 2003, at 03:06  AM, Jan Pieter Kunst wrote:

Hardware: 1.8 GHz G5 with 1GB RAM

Panther (Mac OS X 10.3) doesn't have the sudden slowness in the  
'insert' test that Jaguar (Mac OS X 10.2) has. Total time for Panther  
is faster than total time for Jaguar (5561.00 secs vs. 6770.00 secs).  
'Insert' is faster on Panther than on Jaguar (3316 secs vs. 5215  
secs), but all other benchmarks are somewhat slower on Panther. I'm a  
bit worried about the 'select', which is about twice as  slow on  
Panther than on Jaguar (1428 secs vs. 743 secs).

Complete benchmark results below, sorry for the possible bandwidth  
waste, but I'm not sure what I could snip, if anything.

JP

Panther benchmarks:
=== 
==
Benchmark DBD suite: 2.14
Date of test:2003-11-07  0:12:11
Running tests on:Darwin 7.0.0 Power Macintosh
Arguments:
Comments:
Limits from: mysql,pg,solid
Server version:  MySQL 4.0.15 standard log
Optimization:None
Hardware:

alter-table: Total time: 141 wallclock secs ( 0.22 usr  0.11 sys +  
0.00 cusr  0.00 csys =  0.33 CPU)
ATIS: Total time: 59 wallclock secs (10.59 usr  6.30 sys +  0.00 cusr  
0.00 csys = 16.89 CPU)
big-tables: Total time: 57 wallclock secs ( 7.53 usr 13.50 sys + 0.00  
cusr  0.00 csys = 21.03 CPU)
connect: Total time: 252 wallclock secs (44.31 usr 38.81 sys +  0.00  
cusr  0.00 csys = 83.12 CPU)
create: Total time: 298 wallclock secs ( 8.76 usr  3.06 sys +  0.00  
cusr  0.00 csys = 11.82 CPU)
insert: Total time: 3316 wallclock secs (594.82 usr 261.66 sys + 0.00  
cusr  0.00 csys = 856.48 CPU)
select: Total time: 1428 wallclock secs (67.50 usr 25.18 sys +  0.00  
cusr  0.00 csys = 92.68 CPU)
transactions: Test skipped because the database doesn't support  
transactions
wisconsin: Total time: 27 wallclock secs ( 4.19 usr  2.58 sys +  0.00  
cusr  0.00 csys =  6.77 CPU)


I'm not sure how useful it is for comparison, but our dual 2GHz G5 w/  
4GB of RAM had these results (for MyISAM tables):

alter-table: Total time: 11 wallclock secs ( 0.02 usr  0.04 sys +  0.00  
cusr  0.00 csys =  0.06 CPU)
ATIS: Total time: 21 wallclock secs ( 9.41 usr  9.44 sys +  0.00 cusr   
0.00 csys = 18.85 CPU)
big-tables: Total time: 34 wallclock secs ( 7.90 usr 20.86 sys +  0.00  
cusr  0.00 csys = 28.76 CPU)
connect: Total time: 180 wallclock secs (45.56 usr 51.51 sys +  0.00  
cusr  0.00 csys = 97.07 CPU)
create: Total time: 118 wallclock secs ( 3.87 usr  2.55 sys +  0.00  
cusr  0.00 csys =  6.42 CPU)
insert: Total time: 1437 wallclock secs (432.84 usr 358.12 sys +  0.00  
cusr  0.00 csys = 790.96 CPU)
select: Total time: 146 wallclock secs (42.52 usr 33.74 sys +  0.00  
cusr  0.00 csys = 76.26 CPU)
transactions: Test skipped because the database doesn't support  
transactions
wisconsin: Total time: 12 wallclock secs ( 2.91 usr  2.76 sys +  0.00  
cusr  0.00 csys =  5.67 CPU)

How the select portion of the test could be 10x slower, I'm not sure.  
Have you tuned MySQL at all? key_buffer, etc?

- Gabriel

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

[Jan Pieter Kunst]

I was wondering if you had journaling turned on in Panther and not 
in Jaguar? I'm not sure if it would have any effect on selects, I 
would think it would slow down inserts not selects. You notice the 
CPU breakdown is different.
Journaling was turned on in both cases.

JP

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

[Brent Baisley]

Thanks for posting the comparison, it's something I've been meaning to 
do myself.

I was wondering if you had journaling turned on in Panther and not in 
Jaguar? I'm not sure if it would have any effect on selects, I would 
think it would slow down inserts not selects. You notice the CPU 
breakdown is different.

On Friday, November 7, 2003, at 03:06 AM, Jan Pieter Kunst wrote:

Hardware: 1.8 GHz G5 with 1GB RAM

Panther (Mac OS X 10.3) doesn't have the sudden slowness in the 
'insert' test that Jaguar (Mac OS X 10.2) has. Total time for Panther 
is faster than total time for Jaguar (5561.00 secs vs. 6770.00 secs). 
'Insert' is faster on Panther than on Jaguar (3316 secs vs. 5215 
secs), but all other benchmarks are somewhat slower on Panther. I'm a 
bit worried about the 'select', which is about twice as  slow on 
Panther than on Jaguar (1428 secs vs. 743 secs).

Complete benchmark results below, sorry for the possible bandwidth 
waste, but I'm not sure what I could snip, if anything.

--
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 benchmarks on the G5: Jaguar vs. Panther

[Jan Pieter Kunst]

Hardware: 1.8 GHz G5 with 1GB RAM

Panther (Mac OS X 10.3) doesn't have the sudden slowness in the 
'insert' test that Jaguar (Mac OS X 10.2) has. Total time for Panther 
is faster than total time for Jaguar (5561.00 secs vs. 6770.00 secs). 
'Insert' is faster on Panther than on Jaguar (3316 secs vs. 5215 
secs), but all other benchmarks are somewhat slower on Panther. I'm a 
bit worried about the 'select', which is about twice as  slow on 
Panther than on Jaguar (1428 secs vs. 743 secs).

Complete benchmark results below, sorry for the possible bandwidth 
waste, but I'm not sure what I could snip, if anything.

JP

Panther benchmarks:
=
Benchmark DBD suite: 2.14
Date of test:2003-11-07  0:12:11
Running tests on:Darwin 7.0.0 Power Macintosh
Arguments:
Comments:
Limits from: mysql,pg,solid
Server version:  MySQL 4.0.15 standard log
Optimization:None
Hardware:
alter-table: Total time: 141 wallclock secs ( 0.22 usr  0.11 sys + 
0.00 cusr  0.00 csys =  0.33 CPU)
ATIS: Total time: 59 wallclock secs (10.59 usr  6.30 sys +  0.00 cusr 
0.00 csys = 16.89 CPU)
big-tables: Total time: 57 wallclock secs ( 7.53 usr 13.50 sys + 
0.00 cusr  0.00 csys = 21.03 CPU)
connect: Total time: 252 wallclock secs (44.31 usr 38.81 sys +  0.00 
cusr  0.00 csys = 83.12 CPU)
create: Total time: 298 wallclock secs ( 8.76 usr  3.06 sys +  0.00 
cusr  0.00 csys = 11.82 CPU)
insert: Total time: 3316 wallclock secs (594.82 usr 261.66 sys + 
0.00 cusr  0.00 csys = 856.48 CPU)
select: Total time: 1428 wallclock secs (67.50 usr 25.18 sys +  0.00 
cusr  0.00 csys = 92.68 CPU)
transactions: Test skipped because the database doesn't support transactions
wisconsin: Total time: 27 wallclock secs ( 4.19 usr  2.58 sys +  0.00 
cusr  0.00 csys =  6.77 CPU)

All 9 test executed successfully

Totals per operation:
Operation seconds usr sys cpu   tests
alter_table_add  134.000.200.090.29 992
connect   16.006.711.308.01   1
connect+select_1_row  23.007.652.219.86   1
count 38.000.040.020.06 100
count_distinct27.000.390.090.481000
count_distinct_big   124.009.596.03   15.62 120
count_distinct_group 184.001.590.802.391000
count_distinct_group_on_key   31.000.490.100.591000
count_distinct_group_on_key_parts182.001.360.752.111000
count_distinct_key_prefix 21.000.460.090.551000
count_group_on_key_parts  38.001.260.671.931000
count_on_key 383.00   15.733.78   19.51   50100
create+drop  111.003.390.984.37   1
create_MANY_tables46.001.150.361.515000
create_index   3.000.000.000.00   8
create_key+drop  121.003.161.164.32   1
create_table   0.000.010.000.01  31
delete_all_many_keys  59.000.020.020.04   1
delete_big 0.000.000.000.00   1
delete_big_many_keys  59.000.020.020.04 128
delete_key 5.000.470.310.78   1
delete_range  11.000.000.000.00  12
drop_index 3.000.000.000.00   8
drop_table 1.000.010.000.01  28
drop_table_when_MANY_tables   12.000.440.140.585000
insert   188.00   18.93   10.96   29.89  350768
insert_duplicates 33.004.583.027.60  10
insert_key   168.00   12.504.27   16.77  10
insert_many_fields10.000.410.160.572000
insert_select_1_key5.000.000.000.00   1
insert_select_2_keys   6.000.000.000.00   1
min_max   20.000.050.000.05  60
min_max_on_key   169.00   22.065.41   27.47   85000
order_by_big 128.00   24.08   17.32   41.40  10
order_by_big_key  89.00   27.07   19.61   46.68  10
order_by_big_key2 86.00   24.30   18.88   43.18  10
order_by_big_key_desc 94.00   27.52   20.67   48.19  10
order_by_big_key_diff116.00   25.02   16.13   41.15  10
order_by_big_key_prefix   87.00   24.71   18.71   43.42  10
order_by_

Re: Mysql on panther

[Nestor Florez]

Thanks to all the help...I got it working!!!


Basically, as recommended, I created a my.cnf
I also chown my /var/mysql directory to user 'mysql'

and I am cooking now


Thanks again!!

Nestor :-)

Nestor A. Florez


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: strange OS X (Panther) & MySql 4.0.16 behaviour!!! HELP!!!

[Brent Baisley]

Is the live site also running Apache 2? Are they both using the same  
version of PHP? Panther upgrades the version of php installed as well  
as overwriting your httpd.conf file. I'm pretty sure Apple renames the  
existing copy to httpd.conf.applesaved. If you are using PEAR to handle  
your pagination, there may be a configuration issue there.
I don't use PEAR (for no good reason) and I have no problems with my  
own pagination code. I would go over your PHP configuration,  
specifically the include parameters, which you need for PEAR.

On Thursday, November 6, 2003, at 11:20 AM, g4 wrote:

Hi list,

I'm still trying to ascertain if this is in fact an MySql problem,  
here goes.

I'm developing locally on My G4 box running Apache 2 + MySql 4.0.16, I  
have a live site on a FreeBSD box running Apache 1.3 + MySql 3.x. The  
site is an e-commerce site (PHP 4.3). When I try and access a page  
that paginates because of the number of items has exceeded 6 items I  
get in Safari:

Could not open the page  
“http://192.168.0.11/Englishhall/shopping/ 
index.php?p=1%7C5%7C10%7C14%7C19&id=27” because Safari could not load  
any data for this location.

and in Mozilla, well just nothing!

When I try an access a page with no pagination it works. So for  
example   
“http://192.168.0.11/Englishhall/shopping/ 
index.php?p=1%7C5%7C10%7C14%7C19&id=30” will work.

My local Database (on my G4 box) has been created from dumps from the  
live site. At first I thought this was a problem with My PHP, so I  
downloaded the unchanged PHP source from the live site, so essentially  
an exact copy of a working site. and it still produces the same  
results. So it must be a Database issue right?

I have upgraded to Panther recently and this caused some of the tables  
to lose their permissions, which I've fixed. I reinstalled the DB and  
the issue still remains. Is there a limiter of some sort I have to  
increase?

Anyway any help much appreciated.

--
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: Mysql on panther

[Jan Pieter Kunst]

 [MySQL won't start]
Maybe this knowledge base article is useful:



JP

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql on panther

[Brent Baisley]

There is no my.cnf by default on OS X. Unless you want to override 
default compiled settings, it's not really needed. But you usually do, 
so you need to create your own. MySQL comes with some samples you can 
use.

As for your problems. Your directories where everything is located look 
like where things were placed in OS X 10.1. Apple and the MySQL package 
installer install everything in the /user/local/ directory. This 
started with 10.2. That's probably where all your problems are coming 
from.
I would highly recommend removing your current MySQL install and 
installing it again so that are your files are in the default 
locations. That will make things much easier going forward, especially 
if you don't know how changing directory permissions will affect the OS.

The graphical package installer for OSX available from mysql website 
does a good job of setting things up and putting things in the right 
place. There is also an installer for having MySQL startup 
automatically when you boot. The startup script adheres to Apple's 
guidelines including an XML based parameter list file.

On Thursday, November 6, 2003, at 10:27 AM, Nestor Florez wrote:

My OS X does not have my.cnf anywhere on the machine.

:-)

Nestor A. Florez

--
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: strange OS X (Panther) & MySql 4.0.16 behaviour!!! HELP!!!

[Fortuno, Adam]

Jason,

The possiblity exists that the issue is Apache. I only use 1.3 so I cannot
give specific feedback. Is the PHP.ini file the same in production and as in
development?

Regards,
Adam

-Original Message-
From: g4 [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 11:20 AM
To: [EMAIL PROTECTED]
Subject: strange OS X (Panther) & MySql 4.0.16 behaviour!!! HELP!!!


Hi list,

I'm still trying to ascertain if this is in fact an MySql problem, here  
goes.

I'm developing locally on My G4 box running Apache 2 + MySql 4.0.16, I  
have a live site on a FreeBSD box running Apache 1.3 + MySql 3.x. The  
site is an e-commerce site (PHP 4.3). When I try and access a page that  
paginates because of the number of items has exceeded 6 items I get in  
Safari:

Could not open the page  
“http://192.168.0.11/Englishhall/shopping/index.php? 
p=1%7C5%7C10%7C14%7C19&id=27” because Safari could not load any data  
for this location.

and in Mozilla, well just nothing!

When I try an access a page with no pagination it works. So for example  
   
“http://192.168.0.11/Englishhall/shopping/index.php? 
p=1%7C5%7C10%7C14%7C19&id=30” will work.

My local Database (on my G4 box) has been created from dumps from the  
live site. At first I thought this was a problem with My PHP, so I  
downloaded the unchanged PHP source from the live site, so essentially  
an exact copy of a working site. and it still produces the same  
results. So it must be a Database issue right?

I have upgraded to Panther recently and this caused some of the tables  
to lose their permissions, which I've fixed. I reinstalled the DB and  
the issue still remains. Is there a limiter of some sort I have to  
increase?

Anyway any help much appreciated.

TIA.

Jason Lane

Developer
Root10 developments

-- 
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]

strange OS X (Panther) & MySql 4.0.16 behaviour!!! HELP!!!

[g4]

Hi list,

I'm still trying to ascertain if this is in fact an MySql problem, here  
goes.

I'm developing locally on My G4 box running Apache 2 + MySql 4.0.16, I  
have a live site on a FreeBSD box running Apache 1.3 + MySql 3.x. The  
site is an e-commerce site (PHP 4.3). When I try and access a page that  
paginates because of the number of items has exceeded 6 items I get in  
Safari:

Could not open the page  
“http://192.168.0.11/Englishhall/shopping/index.php? 
p=1%7C5%7C10%7C14%7C19&id=27” because Safari could not load any data  
for this location.

and in Mozilla, well just nothing!

When I try an access a page with no pagination it works. So for example  
  
“http://192.168.0.11/Englishhall/shopping/index.php? 
p=1%7C5%7C10%7C14%7C19&id=30” will work.

My local Database (on my G4 box) has been created from dumps from the  
live site. At first I thought this was a problem with My PHP, so I  
downloaded the unchanged PHP source from the live site, so essentially  
an exact copy of a working site. and it still produces the same  
results. So it must be a Database issue right?

I have upgraded to Panther recently and this caused some of the tables  
to lose their permissions, which I've fixed. I reinstalled the DB and  
the issue still remains. Is there a limiter of some sort I have to  
increase?

Anyway any help much appreciated.

TIA.

Jason Lane

Developer
Root10 developments
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql on panther

[Paul DuBois]

At 8:04 -0800 11/6/03, Nestor Florez wrote:
Egor,

Where is the datadir locate?

:-)
The message below says:

 > Starting mysqld daemon with databases from /var/mysql
Which indicates that /var/mysql is the datadir.  Change location
into the directory and have a look around.  Try "ls -la ." to see
what the ownerships are.  You should also find a subdirectory named
"mysql", which is where the grant tables are.
Nestor A. Florez


 Egor Egorov <[EMAIL PROTECTED]> 11/6/2003 7:40:28 AM >>>
"Nestor Florez" <[EMAIL PROTECTED]> wrote:
 I tried running mysql_install_db and I get:
 *---
 # /usr/bin/mysql_install_db --force
 Preparing db table
 Preparing host table
 Preparing user table
 Preparing func table
 Preparing tables_priv table
 Preparing columns_priv table
 Installing all prepared tables
 031106  7:19:56  /usr/libexec/mysqld: Shutdown Complete
 *---
 Then I tried running=20
 *-
 #  /usr/bin/mysqld_safe
 > Starting mysqld daemon with databases from /var/mysql
 > 031106 07:23:11  mysqld ended
 *-
 I still get the error on the /var/mysql/'hostname.err' file
 *--
 031106 07:23:08  mysqld started
 031106  7:23:09  InnoDB: Started
 031106  7:23:09  Fatal error: Can't open privilege tables: Can't find
=
 file: './mysql/host.frm' (errno: 13)
 031106  7:23:09  Aborting
 031106  7:23:09  InnoDB: Starting shutdown...
 031106  7:23:11  InnoDB: Shutdown completed
 031106  7:23:11  /usr/libexec/mysqld: Shutdown Complete
 031106 07:23:11  mysqld ended
 *--
 Any other ideas?

perror 13
Error code  13:  Permission denied
MySQL should be owner of the data dir.


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql on panther

[Nestor Florez]

Egor,


Where is the datadir locate?

:-)

Nestor A. Florez


>>> Egor Egorov <[EMAIL PROTECTED]> 11/6/2003 7:40:28 AM >>>
"Nestor Florez" <[EMAIL PROTECTED]> wrote:
> I tried running mysql_install_db and I get:
> *---
> # /usr/bin/mysql_install_db --force
> Preparing db table
> Preparing host table
> Preparing user table
> Preparing func table
> Preparing tables_priv table
> Preparing columns_priv table
> Installing all prepared tables
> 031106  7:19:56  /usr/libexec/mysqld: Shutdown Complete
> *---
> 
> Then I tried running=20
> *-
> #  /usr/bin/mysqld_safe
> Starting mysqld daemon with databases from /var/mysql
> 031106 07:23:11  mysqld ended
> *-
> I still get the error on the /var/mysql/'hostname.err' file
> *--
> 031106 07:23:08  mysqld started
> 031106  7:23:09  InnoDB: Started
> 031106  7:23:09  Fatal error: Can't open privilege tables: Can't find
=
> file: './mysql/host.frm' (errno: 13)
> 031106  7:23:09  Aborting
> 
> 031106  7:23:09  InnoDB: Starting shutdown...
> 031106  7:23:11  InnoDB: Shutdown completed
> 031106  7:23:11  /usr/libexec/mysqld: Shutdown Complete
> 
> 031106 07:23:11  mysqld ended
> *--
> 
> Any other ideas?
> 

perror 13
Error code  13:  Permission denied

MySQL should be owner of the 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]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Mysql on panther

[Barry Byrne]

> -Original Message-
> From: Nestor Florez [mailto:[EMAIL PROTECTED]
> Sent: 06 November 2003 15:28

> My OS X does not have my.cnf anywhere on the machine.
>
> :-)

Copy/edit on of the my-*.cnf files from the support-files directory in the
mysql distribution directory to /etc/my.cnf


> > I just was given the OK to play with a new server running
> > Mac OS X (Panther)
> >
> > When I give the command (it is recommended to use mysqld_safe instead
>

> > I look at the .err file in /var/mysql/ and it looks like this:
> > *
> > 031105 13:09:38  mysqld started
> > 031105 13:09:38  InnoDB: Started
> > 031105 13:09:38  Fatal error: Can't open privilege tables: Table
> > 'mysql.host' doesn't exist
> > 031105 13:09:38  Aborting

Make sure you have run the scripts/mysql_install_db script.
Also make sure that the mysql data directory has the correct rights for the
mysql user:

Something like:

chown -R mysql:mysql /usr/local/mysql/var
chmod -R 770 /usr/local/mysql/var

should probably work.

 - Barry


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql on panther

[Egor Egorov]

"Nestor Florez" <[EMAIL PROTECTED]> wrote:
> I tried running mysql_install_db and I get:
> *---
> # /usr/bin/mysql_install_db --force
> Preparing db table
> Preparing host table
> Preparing user table
> Preparing func table
> Preparing tables_priv table
> Preparing columns_priv table
> Installing all prepared tables
> 031106  7:19:56  /usr/libexec/mysqld: Shutdown Complete
> *---
> 
> Then I tried running=20
> *-
> #  /usr/bin/mysqld_safe
> Starting mysqld daemon with databases from /var/mysql
> 031106 07:23:11  mysqld ended
> *-
> I still get the error on the /var/mysql/'hostname.err' file
> *--
> 031106 07:23:08  mysqld started
> 031106  7:23:09  InnoDB: Started
> 031106  7:23:09  Fatal error: Can't open privilege tables: Can't find =
> file: './mysql/host.frm' (errno: 13)
> 031106  7:23:09  Aborting
> 
> 031106  7:23:09  InnoDB: Starting shutdown...
> 031106  7:23:11  InnoDB: Shutdown completed
> 031106  7:23:11  /usr/libexec/mysqld: Shutdown Complete
> 
> 031106 07:23:11  mysqld ended
> *--
> 
> Any other ideas?
> 

perror 13
Error code  13:  Permission denied

MySQL should be owner of the 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: Mysql on panther

[Nestor Florez]

My OS X does not have my.cnf anywhere on the machine.

:-)

Nestor A. Florez


>>> Gabriel Ricard <[EMAIL PROTECTED]> 11/5/2003 4:33:07 PM >>>
Are you using Panther client or server? my.cnf is usually in /etc. Have

you run mysql_install_db yet?

- Gabriel

On Wednesday, November 5, 2003, at 05:57  PM, Nestor Florez wrote:

> Hi guys,
>
> I just was given the OK to play with a new server running
> Mac OS X (Panther)
>
> When I give the command (it is recommended to use mysqld_safe instead

> of mysqld in some website)
> *---
> # /usr/bin/mysqld_safe
> Starting mysqld daemon with databases from /var/mysql
> 031105 13:09:40  mysqld ended
> *---
>
>
> I look at the .err file in /var/mysql/ and it looks like this:
> *
> 031105 13:09:38  mysqld started
> 031105 13:09:38  InnoDB: Started
> 031105 13:09:38  Fatal error: Can't open privilege tables: Table 
> 'mysql.host' doesn't exist
> 031105 13:09:38  Aborting
>
> 031105 13:09:38  InnoDB: Starting shutdown...
> 031105 13:09:40  InnoDB: Shutdown completed
> 031105 13:09:40  /usr/libexec/mysqld: Shutdown Complete
>
> 031105 13:09:40  mysqld ended
> *
>
> I search for the my.cnf and I do not find it, but I know that Mac OS
X 
> puts
> things in different places.
>
> Any ideas?
>
> Thanks :-)
>
>
> Nestor A. Florez
>
>
>
> --
> 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]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql on panther

[Nestor Florez]

I tried running mysql_install_db and I get:
*---
# /usr/bin/mysql_install_db --force
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
031106  7:19:56  /usr/libexec/mysqld: Shutdown Complete
*---

Then I tried running 
*-
#  /usr/bin/mysqld_safe
Starting mysqld daemon with databases from /var/mysql
031106 07:23:11  mysqld ended
*-
I still get the error on the /var/mysql/'hostname.err' file
*--
031106 07:23:08  mysqld started
031106  7:23:09  InnoDB: Started
031106  7:23:09  Fatal error: Can't open privilege tables: Can't find file: 
'./mysql/host.frm' (errno: 13)
031106  7:23:09  Aborting

031106  7:23:09  InnoDB: Starting shutdown...
031106  7:23:11  InnoDB: Shutdown completed
031106  7:23:11  /usr/libexec/mysqld: Shutdown Complete

031106 07:23:11  mysqld ended
*--

Any other ideas?

Thanks,

:-)

Nestor A. Florez


>>> Gabriel Ricard <[EMAIL PROTECTED]> 11/5/2003 4:33:07 PM >>>
Are you using Panther client or server? my.cnf is usually in /etc. Have 
you run mysql_install_db yet?

- Gabriel

On Wednesday, November 5, 2003, at 05:57  PM, Nestor Florez wrote:

> Hi guys,
>
> I just was given the OK to play with a new server running
> Mac OS X (Panther)
>
> When I give the command (it is recommended to use mysqld_safe instead 
> of mysqld in some website)
> *---
> # /usr/bin/mysqld_safe
> Starting mysqld daemon with databases from /var/mysql
> 031105 13:09:40  mysqld ended
> *---
>
>
> I look at the .err file in /var/mysql/ and it looks like this:
> *
> 031105 13:09:38  mysqld started
> 031105 13:09:38  InnoDB: Started
> 031105 13:09:38  Fatal error: Can't open privilege tables: Table 
> 'mysql.host' doesn't exist
> 031105 13:09:38  Aborting
>
> 031105 13:09:38  InnoDB: Starting shutdown...
> 031105 13:09:40  InnoDB: Shutdown completed
> 031105 13:09:40  /usr/libexec/mysqld: Shutdown Complete
>
> 031105 13:09:40  mysqld ended
> *
>
> I search for the my.cnf and I do not find it, but I know that Mac OS X 
> puts
> things in different places.
>
> Any ideas?
>
> Thanks :-)
>
>
> Nestor A. Florez
>
>
>
> --
> 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]

Re: Mysql on panther

[Gabriel Ricard]

Are you using Panther client or server? my.cnf is usually in /etc. Have 
you run mysql_install_db yet?

- Gabriel

On Wednesday, November 5, 2003, at 05:57  PM, Nestor Florez wrote:

Hi guys,

I just was given the OK to play with a new server running
Mac OS X (Panther)
When I give the command (it is recommended to use mysqld_safe instead 
of mysqld in some website)
*---
# /usr/bin/mysqld_safe
Starting mysqld daemon with databases from /var/mysql
031105 13:09:40  mysqld ended
*---

I look at the .err file in /var/mysql/ and it looks like this:
*
031105 13:09:38  mysqld started
031105 13:09:38  InnoDB: Started
031105 13:09:38  Fatal error: Can't open privilege tables: Table 
'mysql.host' doesn't exist
031105 13:09:38  Aborting

031105 13:09:38  InnoDB: Starting shutdown...
031105 13:09:40  InnoDB: Shutdown completed
031105 13:09:40  /usr/libexec/mysqld: Shutdown Complete
031105 13:09:40  mysqld ended
*
I search for the my.cnf and I do not find it, but I know that Mac OS X 
puts
things in different places.

Any ideas?

Thanks :-)

Nestor A. Florez



--
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]

Mysql on panther

[Nestor Florez]

Hi guys,

I just was given the OK to play with a new server running
Mac OS X (Panther)

When I give the command (it is recommended to use mysqld_safe instead of mysqld in 
some website)
*---
# /usr/bin/mysqld_safe
Starting mysqld daemon with databases from /var/mysql
031105 13:09:40  mysqld ended
*---


I look at the .err file in /var/mysql/ and it looks like this:
*
031105 13:09:38  mysqld started
031105 13:09:38  InnoDB: Started
031105 13:09:38  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't 
exist
031105 13:09:38  Aborting

031105 13:09:38  InnoDB: Starting shutdown...
031105 13:09:40  InnoDB: Shutdown completed
031105 13:09:40  /usr/libexec/mysqld: Shutdown Complete

031105 13:09:40  mysqld ended
*

I search for the my.cnf and I do not find it, but I know that Mac OS X puts
things in different places.

Any ideas?

Thanks :-)


Nestor A. Florez



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: problem with 'mysql' command on Mac OS X 1.3 (Panther)

[Brent Baisley]

What version of mysql are you using? I'm running 4.0.14 and I upgraded 
without a problem.

On Friday, October 31, 2003, at 01:20 PM, Anderson, James H [IT] wrote:

Ever since upgrading I haven't been able to use the 'mysql' 
command--it just
hangs. Otherwise, the database seems to be working properly. I even 
tried
rebuilding from source but it didn't solve the problem. I've attached
ktrace/kdump output of the problem. I'm hoping someone can interpret 
this
stuff and let me know what the problem is.

Thanks,

jim

 <>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
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 with 'mysql' command on Mac OS X 1.3 (Panther)

[Anderson, James H [IT]]

Ever since upgrading I haven't been able to use the 'mysql' command--it just
hangs. Otherwise, the database seems to be working properly. I even tried
rebuilding from source but it didn't solve the problem. I've attached
ktrace/kdump output of the problem. I'm hoping someone can interpret this
stuff and let me know what the problem is.

Thanks,

jim

 <> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL Package Install for Mac OS X 10.3 (Panther)

[Sam Carpenter]

I used the MySQL Complete package from Server Logistics and it 
installed fine on my clean Panther install.  Also, the MySQL Preference 
Pane and CocoaSQL work fine as well.

Thanks,

-Sam

On Tuesday, October 28, 2003, at 11:08 PM, Sam Carpenter wrote:

My bad, I should have been more precise.  I am not upgrading - I have 
done a clean install.  So, now I need to re-install MySQL.

-Thanks

On Tuesday, October 28, 2003, at 11:00 PM, Kim Kohen wrote:

I am upgrading to Panther


--
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]

FW: problem with MySQL and latest release of Mac OX X (Panther)

[Anderson, James H [IT]]

I should add that I can access the database via a java program, just not
using the mysql command.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: problem with MySQL and latest release of Mac OX X (Panther)

[Anderson, James H [IT]]

'mysql -A sampdb' hangs as does every other mysql command. There are no
recent entries in hostname.err.

-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 5:52 PM
To: Anderson, James H [IT]; [EMAIL PROTECTED]
Subject: RE: problem with MySQL and latest release of Mac OX X (Panther)


Could you look at you're hostname.err file and see if it says checking
table?

Also try mysql -A sampdb


- Dathan Vance Pattishall
  - Sr. Programmer and mySQL DBA for FriendFinder Inc.
  - http://friendfinder.com/go/p40688


-->-Original Message-
-->From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, October 28, 2003 2:03 PM
-->To: 'Dathan Vance Pattishall'; [EMAIL PROTECTED]
-->Subject: RE: problem with MySQL and latest release of Mac OX X
(Panther)
-->
-->BTW, nothing's changed in my.cnf...
-->
-->.my.cnf
-->---
-->[client]
-->host=localhost
-->user=jim
-->password=password
-->
-->No query, I just entered 'mysql sampdb'. It hung indefinitely; I had
to
-->kill
-->the window.
-->Since I couldn't get into mysql I don't know the value of any
variables.
-->
-->
-->-Original Message-
-->From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, October 28, 2003 4:42 PM
-->To: Anderson, James H [IT]; [EMAIL PROTECTED]
-->Subject: RE: problem with MySQL and latest release of Mac OX X
(Panther)
-->
-->
-->Can you post you're my.cnf options / your query in question / how
long
-->have you seen it hang / what status it is in / and your show status
-->vars.
-->
-->
-->
-->- Dathan Vance Pattishall
-->  - Sr. Programmer and mySQL DBA for FriendFinder Inc.
-->  - http://friendfinder.com/go/p40688
-->
-->
-->-->-Original Message-
-->-->From: Anderson, James H [IT]
[mailto:[EMAIL PROTECTED]
-->-->Sent: Tuesday, October 28, 2003 1:06 PM
-->-->To: [EMAIL PROTECTED]
-->-->Subject: problem with MySQL and latest release of Mac OX X
(Panther)
-->-->
-->-->Much to my surprise and chagrin, I'm having a problem using MySQL
-->after
-->-->upgrading to the latest release of Mac OS X this past weekend. As
far
-->as
-->-->I can tell, the server seems to be running, but when I attempt to
-->execute
-->-->the mysql command it just hangs. Any ideas?
-->-->
-->-->Thanks,
-->-->
-->-->jim
-->-->
-->-->
-->-->--
-->-->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]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL Package Install for Mac OS X 10.3 (Panther)

[Sam Carpenter]

My bad, I should have been more precise.  I am not upgrading - I have 
done a clean install.  So, now I need to re-install MySQL.

-Thanks

On Tuesday, October 28, 2003, at 11:00 PM, Kim Kohen wrote:

I am upgrading to Panther


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL Package Install for Mac OS X 10.3 (Panther)

[Kim Kohen]

G'day Sam

> I am upgrading to Panther and I need to install MySQL.  Does anybody
> know if the Mac OS X Installer Package v10.2 (Standard) works with
> 10.3?  If it doesn't then what would be the best installation method on
> a clean 10.3 installation?
€€€€
FWIW, I upgraded to Panther on the weekend and MySQL 4.0.12 is still humming
along just fine. I don't use the MySQL build, I use MySQL Complete from
www.serverlogistics.com . I have seen something strange with PHP (can't echo
anything shorter than 17 characters) but I believe they are working on new
builds anyway.

cheers

kim


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Package Install for Mac OS X 10.3 (Panther)

[Sam Carpenter]

I am upgrading to Panther and I need to install MySQL.  Does anybody 
know if the Mac OS X Installer Package v10.2 (Standard) works with 
10.3?  If it doesn't then what would be the best installation method on 
a clean 10.3 installation?

Thanks,

-Sam Carpenter	

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: problem with MySQL and latest release of Mac OX X (Panther)

[Dathan Vance Pattishall]

Could you look at you’re hostname.err file and see if it says checking
table?

Also try mysql -A sampdb


- Dathan Vance Pattishall
  - Sr. Programmer and mySQL DBA for FriendFinder Inc.
  - http://friendfinder.com/go/p40688


-->-Original Message-
-->From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, October 28, 2003 2:03 PM
-->To: 'Dathan Vance Pattishall'; [EMAIL PROTECTED]
-->Subject: RE: problem with MySQL and latest release of Mac OX X
(Panther)
-->
-->BTW, nothing's changed in my.cnf...
-->
-->.my.cnf
-->---
-->[client]
-->host=localhost
-->user=jim
-->password=password
-->
-->No query, I just entered 'mysql sampdb'. It hung indefinitely; I had
to
-->kill
-->the window.
-->Since I couldn't get into mysql I don't know the value of any
variables.
-->
-->
-->-Original Message-
-->From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, October 28, 2003 4:42 PM
-->To: Anderson, James H [IT]; [EMAIL PROTECTED]
-->Subject: RE: problem with MySQL and latest release of Mac OX X
(Panther)
-->
-->
-->Can you post you're my.cnf options / your query in question / how
long
-->have you seen it hang / what status it is in / and your show status
-->vars.
-->
-->
-->
-->- Dathan Vance Pattishall
-->  - Sr. Programmer and mySQL DBA for FriendFinder Inc.
-->  - http://friendfinder.com/go/p40688
-->
-->
-->-->-Original Message-
-->-->From: Anderson, James H [IT]
[mailto:[EMAIL PROTECTED]
-->-->Sent: Tuesday, October 28, 2003 1:06 PM
-->-->To: [EMAIL PROTECTED]
-->-->Subject: problem with MySQL and latest release of Mac OX X
(Panther)
-->-->
-->-->Much to my surprise and chagrin, I'm having a problem using MySQL
-->after
-->-->upgrading to the latest release of Mac OS X this past weekend. As
far
-->as
-->-->I can tell, the server seems to be running, but when I attempt to
-->execute
-->-->the mysql command it just hangs. Any ideas?
-->-->
-->-->Thanks,
-->-->
-->-->jim
-->-->
-->-->
-->-->--
-->-->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]




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: problem with MySQL and latest release of Mac OX X (Panther)

[Anderson, James H [IT]]

BTW, nothing's changed in my.cnf...

.my.cnf
---
[client]
host=localhost
user=jim
password=password

No query, I just entered 'mysql sampdb'. It hung indefinitely; I had to kill
the window.
Since I couldn't get into mysql I don't know the value of any variables.


-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 4:42 PM
To: Anderson, James H [IT]; [EMAIL PROTECTED]
Subject: RE: problem with MySQL and latest release of Mac OX X (Panther)


Can you post you're my.cnf options / your query in question / how long
have you seen it hang / what status it is in / and your show status
vars.



- Dathan Vance Pattishall
  - Sr. Programmer and mySQL DBA for FriendFinder Inc.
  - http://friendfinder.com/go/p40688


-->-Original Message-
-->From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, October 28, 2003 1:06 PM
-->To: [EMAIL PROTECTED]
-->Subject: problem with MySQL and latest release of Mac OX X (Panther)
-->
-->Much to my surprise and chagrin, I'm having a problem using MySQL
after
-->upgrading to the latest release of Mac OS X this past weekend. As far
as
-->I can tell, the server seems to be running, but when I attempt to
execute
-->the mysql command it just hangs. Any ideas?
-->
-->Thanks,
-->
-->jim
-->
-->
-->--
-->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]

RE: problem with MySQL and latest release of Mac OX X (Panther)

[Dathan Vance Pattishall]

Can you post you’re my.cnf options / your query in question / how long
have you seen it hang / what status it is in / and your show status
vars.



- Dathan Vance Pattishall
  - Sr. Programmer and mySQL DBA for FriendFinder Inc.
  - http://friendfinder.com/go/p40688


-->-Original Message-
-->From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, October 28, 2003 1:06 PM
-->To: [EMAIL PROTECTED]
-->Subject: problem with MySQL and latest release of Mac OX X (Panther)
-->
-->Much to my surprise and chagrin, I'm having a problem using MySQL
after
-->upgrading to the latest release of Mac OS X this past weekend. As far
as
-->I can tell, the server seems to be running, but when I attempt to
execute
-->the mysql command it just hangs. Any ideas?
-->
-->Thanks,
-->
-->jim
-->
-->
-->--
-->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]

problem with MySQL and latest release of Mac OX X (Panther)

[Anderson, James H [IT]]

Much to my surprise and chagrin, I'm having a problem using MySQL after upgrading to 
the latest release of Mac OS X this past weekend. As far as I can tell, the server 
seems to be running, but when I attempt to execute the mysql command it just hangs. 
Any ideas?

Thanks,

jim


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]