RE: installation problem of MySQL on OS Lion

2015-07-30 Thread Divesh
Share error log file

-Original Message-
From: Martin Mueller martinmuel...@northwestern.edu
Sent: ‎29-‎07-‎2015 21:05
To: mysql@lists.mysql.com mysql@lists.mysql.com
Subject: installation problem of MySQL on OS Lion

I installed MySQL on a Mac Pro running OS Lion.

The installation was successful, but starting the mysql server generated the 
following error message:

Martin-Muellers-Mac-Pro:~ martin$ sudo 
/usr/local/mysql/support-files/mysql.server start
Starting MySQL
... ERROR! Manager of pid-file quit without updating file.


I'll be grateful for any help


Martin Mueller
Professor emeritus of English and Classics
Northwestern University


RE: Installation Problem with 4.0.20

2004-08-02 Thread dave.prout
Thanks very much Michael, you were right.

I spent hours worrying about this yesterday. The documentation implied
that you don't have to log on at all.

Cheers

Dave 

 -Original Message-
 From: Michael Stassen [mailto:[EMAIL PROTECTED] 
 Sent: 02 August 2004 05:11
 To: Prout,DA,Dave,XSJ67 PROUTDA R
 Cc: [EMAIL PROTECTED]
 Subject: Re: Installation Problem with 4.0.20
 
 Which mysql username did you use to log in?  I've not used 
 mysql on Windows, but I expect that if you simply ran 
 mysqlshow on a new install, you'd connect as the anonymous 
 user.  The anonymous user only has rights to the test db, so 
 that's all you'd see.  Try
 
mysqlshow -u root
 
 or, if you've set the root password,
 
mysqlshow -u root -p
 
 instead.
 
 Michael
 
 [EMAIL PROTECTED] wrote:
 
  I've just downloaded 4.0.20 for windows
   
  Installed on the D: drive. Set up an .ini pointing at D: drive
   
  Ran  D:\mysql\bin\mysqld
   
  When I then ran mysqlshow I only had the test database, not 
 the mysql 
  database as the documentation said I should.
   
  I then deleted everything and installed again, and got the 
 same result.
   
  Does this mean the installation has failed ?
   
  Dave
  UK
 
 

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



Re: Installation Problem with 4.0.20

2004-08-02 Thread Whil Hentzen
 When I then ran mysqlshow I only had the test database, not the mysql
 database as the documentation said I should.

 I then deleted everything and installed again, and got the same result.

 Does this mean the installation has failed ?

When this happens on Linux, it means you're running mysqlshow as a regular 
user who doesn't have rights to the mysql database. I think there's a 
corrolary in Windows (anonymous user?)

-- 
Whil

Moving to Linux: Freedom, Choice, Security, Opportunity
http://www.hentzenwerke.com


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



Re: Installation Problem with 4.0.20

2004-08-01 Thread Michael Stassen
Which mysql username did you use to log in?  I've not used mysql on Windows, 
but I expect that if you simply ran mysqlshow on a new install, you'd 
connect as the anonymous user.  The anonymous user only has rights to the 
test db, so that's all you'd see.  Try

  mysqlshow -u root
or, if you've set the root password,
  mysqlshow -u root -p
instead.
Michael
[EMAIL PROTECTED] wrote:
I've just downloaded 4.0.20 for windows
 
Installed on the D: drive. Set up an .ini pointing at D: drive
 
Ran  D:\mysql\bin\mysqld
 
When I then ran mysqlshow I only had the test database, not the mysql
database as the documentation said I should.
 
I then deleted everything and installed again, and got the same result.
 
Does this mean the installation has failed ?
 
Dave
UK

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


RE: Installation problem!!!

2004-02-26 Thread Kirti S. Bajwa
No change. Any other suggestion?

Thanks.

Kirti

-Original Message-
From: Victor Medina [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 7:26 AM
To: Kirti S. Bajwa
Cc: '[EMAIL PROTECTED]'
Subject: Re: Installation problem!!!


Hi!

try using the one installed in /usr/local/mysql/bin/mysql_install_db

Best Regards!

On Wed, 2004-02-25 at 18:45, Kirti S. Bajwa wrote:

 Hello List:
 
 I have installed MySQL Master Server from Binaries 4-5 times without
 problem. Now I am installing MySQL CLIENT from source and have run into
 problem, as explained below:
   Download mysql-5.0.0-alpha.tar.gz in  /usr/local 
   % cd  /usr/local
   % gunzip  mysql-5.0.0-alpha.tar.gz  | tar -xvf -   
   % cd mysql-5.0.0-alpha
   % ./configure   --without-server   --prefix=/usr/local/mysql
   % make
   % make install
   % scripts/mysql_install_db
 
 When I run the last line scripts/mysql_install_db, I get an error
message
 No such file or directory.  I have looked into scripts folder and ther
 is mysql_install_db.sh.
 
 Has anybody else experienced the same problem? What is causing this error?
 
 Thanks in advance.
 
 Kirti

-- 

 |...|
 |  _    _|Victor Medina M   |
 |\ \ \| |  _ \ / \   |Linux - Java - MySQL  |
 | \ \ \  _| | |_) / _ \  |Dpto. Sistemas - Ferreteria EPA   |
 | / / / |___|  __/ ___ \ |[EMAIL PROTECTED]  |
 |/_/_/|_|_| /_/   \_\|ext. 325 - Tél: +58-241-8507325   |
 ||geek by nature - linux by choice  |
 |...|





















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



Re: Installation problem!!!

2004-02-26 Thread Victor Medina
Hi!

try using the one installed in /usr/local/mysql/bin/mysql_install_db

Best Regards!

On Wed, 2004-02-25 at 18:45, Kirti S. Bajwa wrote:

 Hello List:
 
 I have installed MySQL Master Server from Binaries 4-5 times without
 problem. Now I am installing MySQL CLIENT from source and have run into
 problem, as explained below:
   Download mysql-5.0.0-alpha.tar.gz in  /usr/local 
   % cd  /usr/local
   % gunzip  mysql-5.0.0-alpha.tar.gz  | tar -xvf -   
   % cd mysql-5.0.0-alpha
   % ./configure   --without-server   --prefix=/usr/local/mysql
   % make
   % make install
   % scripts/mysql_install_db
 
 When I run the last line scripts/mysql_install_db, I get an error message
 No such file or directory.  I have looked into scripts folder and ther
 is mysql_install_db.sh.
 
 Has anybody else experienced the same problem? What is causing this error?
 
 Thanks in advance.
 
 Kirti

-- 

 |...|
 |  _    _|Victor Medina M   |
 |\ \ \| |  _ \ / \   |Linux - Java - MySQL  |
 | \ \ \  _| | |_) / _ \  |Dpto. Sistemas - Ferreteria EPA   |
 | / / / |___|  __/ ___ \ |[EMAIL PROTECTED]  |
 |/_/_/|_|_| /_/   \_\|ext. 325 - Tél: +58-241-8507325   |
 ||geek by nature - linux by choice  |
 |...|






















Re: Installation Problem - PLEASE HELP

2004-02-18 Thread Alex Greg
 Hi all.  I am trying to install mySql on Solaris 2.6. I am getting the
following error during 'make':

 ld: fatal: library -lz: not found
 ld: fatal: File processing errors. No output written to
.libs/libmysqlclient.so.10.0.0
 make[2]: *** [libmysqlclient.la] Error 1
 make[2]: Leaving directory `/virtual/mysql-3.23.58/libmysql'
 make[1]: *** [all-recursive] Error 1
 make[1]: Leaving directory `/virtual/mysql-3.23.58'
 make: *** [all] Error 2

(from http://curl.haxx.se/mail/archive-2003-11/0018.html)

It means that it didn't find the zlib library at link time. The configure
script found it and enabled the use of it, but when it came to linking it
somehow doesn't find it.

You can fix this by setting up your LD_LIBRARY_PATH (or similar) to include
the path of your zlib.



-- Alex



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



Re: Installation Problem - PLEASE HELP

2004-02-18 Thread Michael Stassen
Alex Greg wrote:

Hi all.  I am trying to install mySql on Solaris 2.6. I am getting the
following error during 'make':

ld: fatal: library -lz: not found
ld: fatal: File processing errors. No output written to
.libs/libmysqlclient.so.10.0.0

make[2]: *** [libmysqlclient.la] Error 1
make[2]: Leaving directory `/virtual/mysql-3.23.58/libmysql'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/virtual/mysql-3.23.58'
make: *** [all] Error 2


(from http://curl.haxx.se/mail/archive-2003-11/0018.html)

It means that it didn't find the zlib library at link time. The configure
script found it and enabled the use of it, but when it came to linking it
somehow doesn't find it.
You can fix this by setting up your LD_LIBRARY_PATH (or similar) to include
the path of your zlib.


-- Alex
Presumably, you are using gcc to compile and Solaris ld to link.  That's 
fine, but the problem is that Solaris ld doesn't looks in /usr/local/lib 
(I'm assuming that's where you put zlib) by default.  You can set 
LD_LIBRARY_PATH, but that really isn't the Solaris way.  It works, 
sometimes, but not quite in the same way as other systems (e.g. Linux). 
 In any case, it isn't needed if you pass the proper flags.  It's been 
a while since I built anything under Solaris 2.6, but my memory is that 
you need to set the -L and -R flags.  So, assuming your zlib is in 
/usr/local/lib, you need to set

LDFLAGS=-L/usr/local/lib -R/usr/local/lib

before you run configure.  -L sets the link time library path and -R 
sets the run time library path.  This way, both ld and the program you 
build will look in /usr/local/lib in addition to /usr/lib, without the 
need to set LD_LIBRARY_PATH.  See `man ld` for details.

Michael



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


RE: Installation Problem - PLEASE HELP

2004-02-18 Thread Morgan, Andrew R.
Thanks all.. that worked perfectly!

-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 18, 2004 12:17 PM
To: Morgan, Andrew R.
Cc: [EMAIL PROTECTED]
Subject: Re: Installation Problem - PLEASE HELP



Alex Greg wrote:

Hi all.  I am trying to install mySql on Solaris 2.6. I am getting the
 
 following error during 'make':
 
ld: fatal: library -lz: not found
ld: fatal: File processing errors. No output written to
 
 .libs/libmysqlclient.so.10.0.0
 
make[2]: *** [libmysqlclient.la] Error 1
make[2]: Leaving directory `/virtual/mysql-3.23.58/libmysql'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/virtual/mysql-3.23.58'
make: *** [all] Error 2
 
 
 (from http://curl.haxx.se/mail/archive-2003-11/0018.html)
 
 It means that it didn't find the zlib library at link time. The configure
 script found it and enabled the use of it, but when it came to linking it
 somehow doesn't find it.
 
 You can fix this by setting up your LD_LIBRARY_PATH (or similar) to include
 the path of your zlib.
 
 
 
 -- Alex

Presumably, you are using gcc to compile and Solaris ld to link.  That's 
fine, but the problem is that Solaris ld doesn't looks in /usr/local/lib 
(I'm assuming that's where you put zlib) by default.  You can set 
LD_LIBRARY_PATH, but that really isn't the Solaris way.  It works, 
sometimes, but not quite in the same way as other systems (e.g. Linux). 
  In any case, it isn't needed if you pass the proper flags.  It's been 
a while since I built anything under Solaris 2.6, but my memory is that 
you need to set the -L and -R flags.  So, assuming your zlib is in 
/usr/local/lib, you need to set

LDFLAGS=-L/usr/local/lib -R/usr/local/lib

before you run configure.  -L sets the link time library path and -R 
sets the run time library path.  This way, both ld and the program you 
build will look in /usr/local/lib in addition to /usr/lib, without the 
need to set LD_LIBRARY_PATH.  See `man ld` for details.

Michael




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



Re: Installation Problem

2003-12-05 Thread Alex Brown
Hi.

Thanks for the prompt reply.

It seems strange that the installation procedure should include an 
instruction that requires a password with no indication that one is 
required (i.e. there is no -p in the command sequence). Reading through 
Mark Liyanage's installation instructions, I notice that the second 
command ( /usr/local/mysql/bin/mysqladmin -u root -h localhost password 
mysql) is not included.

Your recommended instruction to set the password from inside MySQL 
(GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'newpassword') 
worked fine.

My (perceived) problem with the PowerBook is that when at work the 
PowerBook is connected to a server via an Ethernet connection - the 
server then gives the PowerBook a hostname which is different from that 
when I have the PowerBook at home (and not networked): in both 
locations `hostname` gives different results. Could I set-up a root 
user (or any other user) with the '@%' hostname ?

I would hope to read through the Reference Manual, but at 800 - 1000 
pages, I thought I might wait for the video :)

Many thanks,

Cheers,

Alex Brown

MRC-T.

On Wednesday, December 3, 2003, at 09:39 PM, Michael Stassen wrote:

Alex Brown wrote:
Hi.
I installed MySQL on a Mac (OS 10.1) a while ago with the good 
intension of learning to use, and using, MySQL, but other things got 
in the way. However, I have finally found some time (so far) and I am 
now trying to install the latest version of MySQL (4.0.16) onto OSX 
10.2 (on an iMAC G4), and I must admit to having run into a problem ( 
I have a vague recollection of having problems before).
I have a similar setup: 4.0.16 on 10.2.8 on an iMac G3.

I downloaded the installation file mysql-standard-4.0.16.dmg from the 
MySQl web site as recommended by Mark Liyanage, and followed the 
installation instructions given in the README. All was fine until I 
reached the point where the root password is set - the following is 
what happened
[blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root password 
mysql
This set the password for [EMAIL PROTECTED] to mysql.  (I hope that's 
not the real password.)

[blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root -h 
`hostname` password mysql
/usr/local/mysql/bin/mysqladmin: connect to server at 'blah.local.' 
failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
The error says that you are connecting as [EMAIL PROTECTED], but you 
didn't supply the password, which is needed because you just set it in 
the first step.

[blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root -h 
localhost password mysql
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' 
failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
Same here.

The last command I got from the searchable Reference Manual, from a 
posting made by briantrino.
Could someone please explain. I must admit that the program is 
running, and I have four users, two of whom are 'root', one on 
'localhost' with a password and the other on 'blah.local.' with no 
password. The other two users have no user-name or password. Can I 
set the password for the other 'root' (on 'blah.local.') fromiside 
MySQL ? What are the other two unnamed users ?
Yes, you can do this within mysql.  Use

  mysql -u root -p mysql

to log into mysql as [EMAIL PROTECTED]  You'll be prompted for the 
password.  Use the one you set in step 1.  Then enter

  GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'newpassword'

Replace newpassword with the password you want for [EMAIL PROTECTED]

The two users with empty username and password fields are the 
anonymous user, one for localhost, one for external access.  If you do 
not need them, you can safely delete them.  (I'd definitely get rid of 
the external anonymous user.)

For more detailed info, see MySQL User Account Management 
http://www.mysql.com/doc/en/User_Account_Management.html in the 
manual.

I am hoping to install MySL onto a PowerBook G4. The above problem 
may more obvious here as the 'host' can appear to change depending on 
whether the PowerBook is on the internet or not.
Note that you don't actually need a [EMAIL PROTECTED] account if you 
connect from localhost.  You only need a [EMAIL PROTECTED] account if you want 
that user to be able to connect from the named external host.

I hope this all make some sense, and that someone can help.
Many thanks in advance,
You're welcome.

Alex Brown
MRC-T.
Michael



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


Re: Installation Problem

2003-12-05 Thread Michael Stassen
Alex Brown wrote:
Hi.

Thanks for the prompt reply.

It seems strange that the installation procedure should include an 
instruction that requires a password with no indication that one is 
required (i.e. there is no -p in the command sequence). Reading through 
Mark Liyanage's installation instructions, I notice that the second 
command ( /usr/local/mysql/bin/mysqladmin -u root -h localhost password 
mysql) is not included.
I assume you are talking about the directions given at the end of the 
run of mysql_install_db.  That script uses /bin/hostname to look up your 
mmachine's hostname.  When setting up the user table, it creates an 
entry for [EMAIL PROTECTED] with no password and an entry for 
[EMAIL PROTECTED] with no password.  At the end, it gives the instructions

  PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
  This is done with:
  $bindir/mysqladmin -u root password 'new-password'
  $bindir/mysqladmin -u root -h your_hostname password 'new-password'
  See the manual for more instructions.
where $bindir is the path to the mysql executables 
(/usr/local/mysql/bin, in our case).

In theory, when you run the second command given, you will be connecting 
as [EMAIL PROTECTED] rather than [EMAIL PROTECTED], so no password will be 
needed because you haven't set it yet. (So far you've only set the 
password for [EMAIL PROTECTED], in the first command).  I gather from your 
description that the second command was given to you as

  mysqladmin -u root -h localhost password 'new-password'

This is redundant (it's equivalent to the first command) and won't work 
without the password you set in the first step.  I have a suspicion that 
your /bin/hostname command is returning localhost instead of blah.local, 
or at least did so back when you ran mysql_install_db.

The other possible complication here is that mysql_install_db won't mess 
with your user table if you already have one.  This is a very good 
thing, but it sometimes bites people who, like you, installed mysql once 
before but didn't get very far, as the instructions assume the user 
table looks the way mysql_install_db creates it.

Your recommended instruction to set the password from inside MySQL 
(GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'newpassword') worked 
fine.

My (perceived) problem with the PowerBook is that when at work the 
PowerBook is connected to a server via an Ethernet connection - the 
server then gives the PowerBook a hostname which is different from that 
when I have the PowerBook at home (and not networked): in both locations 
`hostname` gives different results. Could I set-up a root user (or any 
other user) with the '@%' hostname ?
You shouldn't need a [EMAIL PROTECTED] account in mysql to connect to the 
mysql server on the same machine.  Simply leave out the -h hostname 
when you connect, like this:

  mysql -u username -p

This will prompt you for the password to connect as [EMAIL PROTECTED] 
 You usually use the [EMAIL PROTECTED] account(s) to allow connections from 
other hosts.

That said, you can set up mysql to work with your changing hostname if 
you want/need to.  You can, as you suggest, use the wildcard '%' for the 
hostname, but that allows that user access from EVERYWHERE, leaving only 
the password as protection.  A better idea would be to create 
[EMAIL PROTECTED] accounts with the hostname specified or constrained, so as 
to limit access to the named machines.  Some possibilities:

* If your PowerBook has 2 separate hostnames (1 at home, 1 at work), or 
you want to allow access from 2 specific external hosts, say host1 and 
host2, you can create a [EMAIL PROTECTED] account and a [EMAIL PROTECTED] account.

* If your hostname varies somewhat (using DHCP, for example), or you 
want to give a user access from any machine in your domain, say 1.2.3.x, 
where x varies, you can create a [EMAIL PROTECTED] account.

See section 4.4 in the manual for more details.
http://www.mysql.com/doc/en/User_Account_Management.html
I would hope to read through the Reference Manual, but at 800 - 1000 
pages, I thought I might wait for the video :)
It is huge, but I find reading the section relevant to my current task 
is usually quicker than figuring out what I did wrong.  YMMV.

Michael

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


Re: Installation Problem

2003-12-03 Thread Michael Stassen
Alex Brown wrote:
Hi.

I installed MySQL on a Mac (OS 10.1) a while ago with the good intension 
of learning to use, and using, MySQL, but other things got in the way. 
However, I have finally found some time (so far) and I am now trying to 
install the latest version of MySQL (4.0.16) onto OSX 10.2 (on an iMAC 
G4), and I must admit to having run into a problem ( I have a vague 
recollection of having problems before).
I have a similar setup: 4.0.16 on 10.2.8 on an iMac G3.

I downloaded the installation file mysql-standard-4.0.16.dmg from the 
MySQl web site as recommended by Mark Liyanage, and followed the 
installation instructions given in the README. All was fine until I 
reached the point where the root password is set - the following is what 
happened

[blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root password mysql
This set the password for [EMAIL PROTECTED] to mysql.  (I hope that's not 
the real password.)

[blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root -h 
`hostname` password mysql
/usr/local/mysql/bin/mysqladmin: connect to server at 'blah.local.' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
The error says that you are connecting as [EMAIL PROTECTED], but you didn't 
supply the password, which is needed because you just set it in the 
first step.

[blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root -h localhost 
password mysql
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
Same here.

The last command I got from the searchable Reference Manual, from a 
posting made by briantrino.

Could someone please explain. I must admit that the program is running, 
and I have four users, two of whom are 'root', one on 'localhost' with a 
password and the other on 'blah.local.' with no password. The other two 
users have no user-name or password. Can I set the password for the 
other 'root' (on 'blah.local.') fromiside MySQL ? What are the other two 
unnamed users ?
Yes, you can do this within mysql.  Use

  mysql -u root -p mysql

to log into mysql as [EMAIL PROTECTED]  You'll be prompted for the 
password.  Use the one you set in step 1.  Then enter

  GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'newpassword'

Replace newpassword with the password you want for [EMAIL PROTECTED]

The two users with empty username and password fields are the anonymous 
user, one for localhost, one for external access.  If you do not need 
them, you can safely delete them.  (I'd definitely get rid of the 
external anonymous user.)

For more detailed info, see MySQL User Account Management 
http://www.mysql.com/doc/en/User_Account_Management.html in the manual.

I am hoping to install MySL onto a PowerBook G4. The above problem may 
more obvious here as the 'host' can appear to change depending on 
whether the PowerBook is on the internet or not.
Note that you don't actually need a [EMAIL PROTECTED] account if you 
connect from localhost.  You only need a [EMAIL PROTECTED] account if you want 
that user to be able to connect from the named external host.

I hope this all make some sense, and that someone can help.

Many thanks in advance,
You're welcome.

Alex Brown

MRC-T.
Michael

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


RE: Installation problem

2003-10-09 Thread Fortuno, Adam
James,

Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First
question, are you running this on an X-Serve?

So you're doing the following 

# (1) Going to the mysql directory.
cd /usr/local/mysql

# (2) Kicking off mysql using the mysqld_safe script.
sudo -v
enter password
sudo mysqld_safe --user=mysql 

However, from looking at the output you pasted. It doesn't look like MySQL
isn't starting up (nothing about the daemon shutting down). How are you
seeing its not up?

Use the ampersand at the end of the line or you'll lose the terminal
session. Once you've kicked off mysql type mysqladmin version to confirm
the server is online. If you downloaded the absolute most recent version,
you should see the result 4.0.15-standard (or something like it). 

Drop me a note. Let me know the 411.

Regards,
Adam

-Original Message-
From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:32 AM
To: [EMAIL PROTECTED]
Subject: Installation problem


I'm running OS X 10.2.8 and installed the latest OS X mysql package. The
problem is the server won't start and there don't seem to be any logs
available to help diagnose the problem. I've tried both

sudo safe_mysqld
Starting mysqld daemon with databases from
/usr/local/mysql/data

sudo /Library/StartupItems/MySQL start
Starting MySQL database server

Any help greatly appreciated!

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: Installation problem

2003-10-09 Thread Anderson, James H [IT]
Adam,

Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's 
not running:

1. when I issue mysql -h localhost test I get this msg:
ERROR 2002: Can' connect to local MySQL server through socket 
'/tmp/mysql.sock' (61)

2. when I issue ps -auxww|grep mysql I get no results other than the grep job


Just to be sure, I did this:

su (to root)
mysqld_safe --user=mysql 

and got there msgs:

Starting mysqld daemon with databases from /usr/local/mysql/data
mysqld ended

-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:54 AM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE: Installation problem


James,

Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First
question, are you running this on an X-Serve?

So you're doing the following 

# (1) Going to the mysql directory.
cd /usr/local/mysql

# (2) Kicking off mysql using the mysqld_safe script.
sudo -v
enter password
sudo mysqld_safe --user=mysql 

However, from looking at the output you pasted. It doesn't look like MySQL
isn't starting up (nothing about the daemon shutting down). How are you
seeing its not up?

Use the ampersand at the end of the line or you'll lose the terminal
session. Once you've kicked off mysql type mysqladmin version to confirm
the server is online. If you downloaded the absolute most recent version,
you should see the result 4.0.15-standard (or something like it). 

Drop me a note. Let me know the 411.

Regards,
Adam

-Original Message-
From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:32 AM
To: [EMAIL PROTECTED]
Subject: Installation problem


I'm running OS X 10.2.8 and installed the latest OS X mysql package. The
problem is the server won't start and there don't seem to be any logs
available to help diagnose the problem. I've tried both

sudo safe_mysqld
Starting mysqld daemon with databases from
/usr/local/mysql/data

sudo /Library/StartupItems/MySQL start
Starting MySQL database server

Any help greatly appreciated!

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: Installation problem

2003-10-09 Thread Fortuno, Adam
James,

Yea, I have to agree its not starting.

Alright, you're probably already in the /usr/local/mysql or you would've
seen a nasty message reminding you to execute the mysqld_safe script from
mysql's directory. Ugh, (whatelse could it be).. if your running OS X
Server.. the scripts name is mysql_safed not mysqld_safe. If it were that
you'd probably get a script doesn't exist or something. If you were running
as something other than root, you'd get a permission error.

Hmm..

Well back to your earlier question. Yes, MySQL's got a bunch of logs. Take a
look in the /usr/local/mysql/data/ directory. Look for a file named
hostname.err. That log gets input from the mysqld_safe script.

This is an interesting problem! I'm running 4.0.13-standard on my laptop;
however, I'll throw 4.0.15 on a spare G4. Let me see if I can recreate the
issue, and if not, I can tell you what I've done not to get it - make sense?

Take a look at the error log and let us know what is says.

Regards,
Adam

-Original Message-
From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:15 AM
To: Fortuno, Adam
Cc: [EMAIL PROTECTED]
Subject: RE: Installation problem


Adam,

Yes, that's how I'm starting it. There are 2 reasons that lead me to believe
that it's not running:

1. when I issue mysql -h localhost test I get this msg:
ERROR 2002: Can' connect to local MySQL server through socket
'/tmp/mysql.sock' (61)

2. when I issue ps -auxww|grep mysql I get no results other than the grep
job


Just to be sure, I did this:

su (to root)
mysqld_safe --user=mysql 

and got there msgs:

Starting mysqld daemon with databases from /usr/local/mysql/data
mysqld ended

-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:54 AM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE: Installation problem


James,

Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First
question, are you running this on an X-Serve?

So you're doing the following 

# (1) Going to the mysql directory.
cd /usr/local/mysql

# (2) Kicking off mysql using the mysqld_safe script.
sudo -v
enter password
sudo mysqld_safe --user=mysql 

However, from looking at the output you pasted. It doesn't look like MySQL
isn't starting up (nothing about the daemon shutting down). How are you
seeing its not up?

Use the ampersand at the end of the line or you'll lose the terminal
session. Once you've kicked off mysql type mysqladmin version to confirm
the server is online. If you downloaded the absolute most recent version,
you should see the result 4.0.15-standard (or something like it). 

Drop me a note. Let me know the 411.

Regards,
Adam

-Original Message-
From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:32 AM
To: [EMAIL PROTECTED]
Subject: Installation problem


I'm running OS X 10.2.8 and installed the latest OS X mysql package. The
problem is the server won't start and there don't seem to be any logs
available to help diagnose the problem. I've tried both

sudo safe_mysqld
Starting mysqld daemon with databases from
/usr/local/mysql/data

sudo /Library/StartupItems/MySQL start
Starting MySQL database server

Any help greatly appreciated!

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: Installation problem

2003-10-09 Thread Anderson, James H [IT]
Adam,

Well, you were right about there being logs :) (I hadn't looked into the data dir 
since it required root and I was reluctant to setup a root user--live and learn.)

031009 11:12:10  mysqld started
031009 11:12:11  InnoDB: Operating system error number 13 in a file operation.
InnoDB: See http://www.innodb.com/ibman.html for installation help.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
031009 11:12:11  mysqld ended

Presumably this is due to the permissions on the data dir which are set to drwrxr-x---

What's the best way to solve this? Change the directory permissions or change the 
characteristics of the mysql user?

jim

-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:53 AM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED]
Subject: RE: Installation problem


James,

Yea, I have to agree its not starting.

Alright, you're probably already in the /usr/local/mysql or you would've
seen a nasty message reminding you to execute the mysqld_safe script from
mysql's directory. Ugh, (whatelse could it be).. if your running OS X
Server.. the scripts name is mysql_safed not mysqld_safe. If it were that
you'd probably get a script doesn't exist or something. If you were running
as something other than root, you'd get a permission error.

Hmm..

Well back to your earlier question. Yes, MySQL's got a bunch of logs. Take a
look in the /usr/local/mysql/data/ directory. Look for a file named
hostname.err. That log gets input from the mysqld_safe script.

This is an interesting problem! I'm running 4.0.13-standard on my laptop;
however, I'll throw 4.0.15 on a spare G4. Let me see if I can recreate the
issue, and if not, I can tell you what I've done not to get it - make sense?

Take a look at the error log and let us know what is says.

Regards,
Adam

-Original Message-
From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:15 AM
To: Fortuno, Adam
Cc: [EMAIL PROTECTED]
Subject: RE: Installation problem


Adam,

Yes, that's how I'm starting it. There are 2 reasons that lead me to believe
that it's not running:

1. when I issue mysql -h localhost test I get this msg:
ERROR 2002: Can' connect to local MySQL server through socket
'/tmp/mysql.sock' (61)

2. when I issue ps -auxww|grep mysql I get no results other than the grep
job


Just to be sure, I did this:

su (to root)
mysqld_safe --user=mysql 

and got there msgs:

Starting mysqld daemon with databases from /usr/local/mysql/data
mysqld ended

-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:54 AM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE: Installation problem


James,

Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First
question, are you running this on an X-Serve?

So you're doing the following 

# (1) Going to the mysql directory.
cd /usr/local/mysql

# (2) Kicking off mysql using the mysqld_safe script.
sudo -v
enter password
sudo mysqld_safe --user=mysql 

However, from looking at the output you pasted. It doesn't look like MySQL
isn't starting up (nothing about the daemon shutting down). How are you
seeing its not up?

Use the ampersand at the end of the line or you'll lose the terminal
session. Once you've kicked off mysql type mysqladmin version to confirm
the server is online. If you downloaded the absolute most recent version,
you should see the result 4.0.15-standard (or something like it). 

Drop me a note. Let me know the 411.

Regards,
Adam

-Original Message-
From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:32 AM
To: [EMAIL PROTECTED]
Subject: Installation problem


I'm running OS X 10.2.8 and installed the latest OS X mysql package. The
problem is the server won't start and there don't seem to be any logs
available to help diagnose the problem. I've tried both

sudo safe_mysqld
Starting mysqld daemon with databases from
/usr/local/mysql/data

sudo /Library/StartupItems/MySQL start
Starting MySQL database server

Any help greatly appreciated!

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: Installation problem

2003-10-09 Thread Anderson, James H [IT]
Adam,

Knowing that Mac OS comes with a version of MySQL pre-installed, I didn't do anything 
special when I downloaded and installed the latest version. I assumed that anything in 
need of doing would be taken care of during package install. I guess that was just 
wishful thinking. I'll make the ownership/group changes you suggest below and let you 
know the results.

Thanks!

jim


-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 12:49 PM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE: Installation problem


James:

Yea, you can enable root or just use sudo. Sometimes sudo'ing can be a pain
with the timeout and all.

Anyway, at first blush I agree with you. When you installed mysql did you
give mysql (or whatever account that runs MySQL) rights to the
/usr/local/mysql/data directory? Make root the owner of the MySQL directory
and place the directory under mysql (or whatever account that runs MySQL)
group permissions?

Assuming you're running MySQL as user 'mysql' in group 'mysql'.

Do the following:

chown -R root /usr/local/mysql
chgrp -R mysql /usr/local/mysql
chwon -R mysql /usr/local/mysql/data

Then try mysqld_safe --user=mysql  from the /usr/local/mysql directory.

Got to run to lunch. Be back in about 45 min.

Regards,
Adam

-Original Message-
From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 12:21 PM
To: Fortuno, Adam
Cc: [EMAIL PROTECTED]
Subject: RE: Installation problem


Adam,

Well, you were right about there being logs :) (I hadn't looked into the
data dir since it required root and I was reluctant to setup a root
user--live and learn.)

031009 11:12:10  mysqld started
031009 11:12:11  InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See http://www.innodb.com/ibman.html for installation help.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
031009 11:12:11  mysqld ended

Presumably this is due to the permissions on the data dir which are set to
drwrxr-x---

What's the best way to solve this? Change the directory permissions or
change the characteristics of the mysql user?

jim

-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:53 AM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED]
Subject: RE: Installation problem


James,

Yea, I have to agree its not starting.

Alright, you're probably already in the /usr/local/mysql or you would've
seen a nasty message reminding you to execute the mysqld_safe script from
mysql's directory. Ugh, (whatelse could it be).. if your running OS X
Server.. the scripts name is mysql_safed not mysqld_safe. If it were that
you'd probably get a script doesn't exist or something. If you were running
as something other than root, you'd get a permission error.

Hmm..

Well back to your earlier question. Yes, MySQL's got a bunch of logs. Take a
look in the /usr/local/mysql/data/ directory. Look for a file named
hostname.err. That log gets input from the mysqld_safe script.

This is an interesting problem! I'm running 4.0.13-standard on my laptop;
however, I'll throw 4.0.15 on a spare G4. Let me see if I can recreate the
issue, and if not, I can tell you what I've done not to get it - make sense?

Take a look at the error log and let us know what is says.

Regards,
Adam

-Original Message-
From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:15 AM
To: Fortuno, Adam
Cc: [EMAIL PROTECTED]
Subject: RE: Installation problem


Adam,

Yes, that's how I'm starting it. There are 2 reasons that lead me to believe
that it's not running:

1. when I issue mysql -h localhost test I get this msg:
ERROR 2002: Can' connect to local MySQL server through socket
'/tmp/mysql.sock' (61)

2. when I issue ps -auxww|grep mysql I get no results other than the grep
job


Just to be sure, I did this:

su (to root)
mysqld_safe --user=mysql 

and got there msgs:

Starting mysqld daemon with databases from /usr/local/mysql/data
mysqld ended

-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:54 AM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE: Installation problem


James,

Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First
question, are you running this on an X-Serve?

So you're doing the following 

# (1) Going to the mysql directory.
cd /usr/local/mysql

# (2) Kicking off mysql using the mysqld_safe script.
sudo -v
enter password
sudo mysqld_safe --user=mysql 

However, from looking at the output you pasted. It doesn't look like MySQL
isn't starting up (nothing about the daemon shutting down). How are you
seeing its not up?

Use the ampersand at the end of the line

RE: Installation problem

2003-10-09 Thread Fortuno, Adam
Sounds like a plan. Actually, MySQL ships with OS X Server - sounds like
your using the desktop version, which doesn't include it.

Over lunch I threw 4.0.15 on a G4 running 10.2.6 - love that new installer.
I had no issues.

- Downloaded it.
- Ran the installation package
- kicked-off MySQL via mysqld_safe script

I was able to rock and roll. It went even quicker than that ol'tar ball
installation, which I thought was pretty easy. Let me know if the permission
changes work. I'm curious to see what the issue is.

Regards,
Adam

-Original Message-
From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 2:02 PM
To: Fortuno, Adam
Cc: [EMAIL PROTECTED]
Subject: RE: Installation problem


Adam,

Knowing that Mac OS comes with a version of MySQL pre-installed, I didn't do
anything special when I downloaded and installed the latest version. I
assumed that anything in need of doing would be taken care of during package
install. I guess that was just wishful thinking. I'll make the
ownership/group changes you suggest below and let you know the results.

Thanks!

jim


-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 12:49 PM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE: Installation problem


James:

Yea, you can enable root or just use sudo. Sometimes sudo'ing can be a pain
with the timeout and all.

Anyway, at first blush I agree with you. When you installed mysql did you
give mysql (or whatever account that runs MySQL) rights to the
/usr/local/mysql/data directory? Make root the owner of the MySQL directory
and place the directory under mysql (or whatever account that runs MySQL)
group permissions?

Assuming you're running MySQL as user 'mysql' in group 'mysql'.

Do the following:

chown -R root /usr/local/mysql
chgrp -R mysql /usr/local/mysql
chwon -R mysql /usr/local/mysql/data

Then try mysqld_safe --user=mysql  from the /usr/local/mysql directory.

Got to run to lunch. Be back in about 45 min.

Regards,
Adam

-Original Message-
From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 12:21 PM
To: Fortuno, Adam
Cc: [EMAIL PROTECTED]
Subject: RE: Installation problem


Adam,

Well, you were right about there being logs :) (I hadn't looked into the
data dir since it required root and I was reluctant to setup a root
user--live and learn.)

031009 11:12:10  mysqld started
031009 11:12:11  InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See http://www.innodb.com/ibman.html for installation help.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
031009 11:12:11  mysqld ended

Presumably this is due to the permissions on the data dir which are set to
drwrxr-x---

What's the best way to solve this? Change the directory permissions or
change the characteristics of the mysql user?

jim

-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:53 AM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED]
Subject: RE: Installation problem


James,

Yea, I have to agree its not starting.

Alright, you're probably already in the /usr/local/mysql or you would've
seen a nasty message reminding you to execute the mysqld_safe script from
mysql's directory. Ugh, (whatelse could it be).. if your running OS X
Server.. the scripts name is mysql_safed not mysqld_safe. If it were that
you'd probably get a script doesn't exist or something. If you were running
as something other than root, you'd get a permission error.

Hmm..

Well back to your earlier question. Yes, MySQL's got a bunch of logs. Take a
look in the /usr/local/mysql/data/ directory. Look for a file named
hostname.err. That log gets input from the mysqld_safe script.

This is an interesting problem! I'm running 4.0.13-standard on my laptop;
however, I'll throw 4.0.15 on a spare G4. Let me see if I can recreate the
issue, and if not, I can tell you what I've done not to get it - make sense?

Take a look at the error log and let us know what is says.

Regards,
Adam

-Original Message-
From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:15 AM
To: Fortuno, Adam
Cc: [EMAIL PROTECTED]
Subject: RE: Installation problem


Adam,

Yes, that's how I'm starting it. There are 2 reasons that lead me to believe
that it's not running:

1. when I issue mysql -h localhost test I get this msg:
ERROR 2002: Can' connect to local MySQL server through socket
'/tmp/mysql.sock' (61)

2. when I issue ps -auxww|grep mysql I get no results other than the grep
job


Just to be sure, I did this:

su (to root)
mysqld_safe --user=mysql 

and got there msgs:

Starting mysqld daemon with databases from /usr/local/mysql/data
mysqld ended

-Original

RE: Installation problem

2003-10-09 Thread Anderson, James H [IT]
Adam,

It works! I also had to run the initialization script...

Thanks very much for the help.

jim

-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 12:49 PM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE: Installation problem


James:

Yea, you can enable root or just use sudo. Sometimes sudo'ing can be a pain
with the timeout and all.

Anyway, at first blush I agree with you. When you installed mysql did you
give mysql (or whatever account that runs MySQL) rights to the
/usr/local/mysql/data directory? Make root the owner of the MySQL directory
and place the directory under mysql (or whatever account that runs MySQL)
group permissions?

Assuming you're running MySQL as user 'mysql' in group 'mysql'.

Do the following:

chown -R root /usr/local/mysql
chgrp -R mysql /usr/local/mysql
chwon -R mysql /usr/local/mysql/data

Then try mysqld_safe --user=mysql  from the /usr/local/mysql directory.

Got to run to lunch. Be back in about 45 min.

Regards,
Adam

-Original Message-
From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 12:21 PM
To: Fortuno, Adam
Cc: [EMAIL PROTECTED]
Subject: RE: Installation problem


Adam,

Well, you were right about there being logs :) (I hadn't looked into the
data dir since it required root and I was reluctant to setup a root
user--live and learn.)

031009 11:12:10  mysqld started
031009 11:12:11  InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See http://www.innodb.com/ibman.html for installation help.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
031009 11:12:11  mysqld ended

Presumably this is due to the permissions on the data dir which are set to
drwrxr-x---

What's the best way to solve this? Change the directory permissions or
change the characteristics of the mysql user?

jim

-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:53 AM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED]
Subject: RE: Installation problem


James,

Yea, I have to agree its not starting.

Alright, you're probably already in the /usr/local/mysql or you would've
seen a nasty message reminding you to execute the mysqld_safe script from
mysql's directory. Ugh, (whatelse could it be).. if your running OS X
Server.. the scripts name is mysql_safed not mysqld_safe. If it were that
you'd probably get a script doesn't exist or something. If you were running
as something other than root, you'd get a permission error.

Hmm..

Well back to your earlier question. Yes, MySQL's got a bunch of logs. Take a
look in the /usr/local/mysql/data/ directory. Look for a file named
hostname.err. That log gets input from the mysqld_safe script.

This is an interesting problem! I'm running 4.0.13-standard on my laptop;
however, I'll throw 4.0.15 on a spare G4. Let me see if I can recreate the
issue, and if not, I can tell you what I've done not to get it - make sense?

Take a look at the error log and let us know what is says.

Regards,
Adam

-Original Message-
From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 11:15 AM
To: Fortuno, Adam
Cc: [EMAIL PROTECTED]
Subject: RE: Installation problem


Adam,

Yes, that's how I'm starting it. There are 2 reasons that lead me to believe
that it's not running:

1. when I issue mysql -h localhost test I get this msg:
ERROR 2002: Can' connect to local MySQL server through socket
'/tmp/mysql.sock' (61)

2. when I issue ps -auxww|grep mysql I get no results other than the grep
job


Just to be sure, I did this:

su (to root)
mysqld_safe --user=mysql 

and got there msgs:

Starting mysqld daemon with databases from /usr/local/mysql/data
mysqld ended

-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:54 AM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE: Installation problem


James,

Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First
question, are you running this on an X-Serve?

So you're doing the following 

# (1) Going to the mysql directory.
cd /usr/local/mysql

# (2) Kicking off mysql using the mysqld_safe script.
sudo -v
enter password
sudo mysqld_safe --user=mysql 

However, from looking at the output you pasted. It doesn't look like MySQL
isn't starting up (nothing about the daemon shutting down). How are you
seeing its not up?

Use the ampersand at the end of the line or you'll lose the terminal
session. Once you've kicked off mysql type mysqladmin version to confirm
the server is online. If you downloaded the absolute most recent version,
you should see the result 4.0.15-standard (or something like it). 

Drop me a note. Let me know the 411

Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2

2003-07-30 Thread sanjay gupta
I used the coammand rpm -i also.Like that
rpm -i  MySQL-server-4.0.13-0.i386.rpm  but it gives the mesaage

error : MySQL-server-4.0.13-0.i386.rpm  cannot be installed 

please help



- Original Message -
From: Matthew [EMAIL PROTECTED]
To: sanjay gupta [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 4:51 PM
Subject: Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2



  rpm -ivt  MySQL-server-4.0.13-0.i386.rpm
  returns  Only one major mode may be specified 

 this message is from the rpm utility and means that is it not being used
 correctly, there is no problem with mysql.

 maybe just try rpm -i MySQL-server-4.0.13-0.i386.rpm







 - Original Message -
 From: sanjay gupta [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Tuesday, July 29, 2003 6:52 AM
 Subject: installation problem Mysql 4.0.13 on Red Hat linux 6.2


  Dear All ,
 
 I  am facing problem in installing the mysql 4.0.13 on my
  linux 6.2 machine . I have pentium III server. When i give the command
  rpm -ivt  MySQL-server-4.0.13-0.i386.rpm it give the message  Only one
  major mode may be specified 
 
  I tried lot to install the mysql ver 4 on my machine but could not
succeed
 .
  please help
 
  Thanks in advance.
 
  sanjay
 
 
  --
  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: installation problem Mysql on Red Hat linux 6.2

2003-07-30 Thread sanjay gupta
Hi,

i have download all the versions of mysql  from 3 to 4 in rpm format
. but could not install any of them on my red hat 6.2 machine  When i
installing using rpm -i  it gives me the message error
MySQL-server-version number .rpm  cannot be installed 

do anybody have installed the mysql on Red Hat 6.2 machine

please help
thanks  in advance


- Original Message -
From: sanjay gupta [EMAIL PROTECTED]
To: Matthew [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 1:10 PM
Subject: Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2


 I used the coammand rpm -i also.Like that
 rpm -i  MySQL-server-4.0.13-0.i386.rpm  but it gives the mesaage

 error : MySQL-server-4.0.13-0.i386.rpm  cannot be installed 

 please help



 - Original Message -
 From: Matthew [EMAIL PROTECTED]
 To: sanjay gupta [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Sent: Tuesday, July 29, 2003 4:51 PM
 Subject: Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2


 
   rpm -ivt  MySQL-server-4.0.13-0.i386.rpm
   returns  Only one major mode may be specified 
 
  this message is from the rpm utility and means that is it not being used
  correctly, there is no problem with mysql.
 
  maybe just try rpm -i MySQL-server-4.0.13-0.i386.rpm
 
 
 
 
 
 
 
  - Original Message -
  From: sanjay gupta [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]
  Sent: Tuesday, July 29, 2003 6:52 AM
  Subject: installation problem Mysql 4.0.13 on Red Hat linux 6.2
 
 
   Dear All ,
  
  I  am facing problem in installing the mysql 4.0.13 on
my
   linux 6.2 machine . I have pentium III server. When i give the command
   rpm -ivt  MySQL-server-4.0.13-0.i386.rpm it give the message  Only
one
   major mode may be specified 
  
   I tried lot to install the mysql ver 4 on my machine but could not
 succeed
  .
   please help
  
   Thanks in advance.
  
   sanjay
  
  
   --
   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]




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



Re: installation problem Mysql 4.0.13 on Red Hat linux 6.2

2003-07-29 Thread Matthew

 rpm -ivt  MySQL-server-4.0.13-0.i386.rpm
 returns  Only one major mode may be specified 

this message is from the rpm utility and means that is it not being used
correctly, there is no problem with mysql.

maybe just try rpm -i MySQL-server-4.0.13-0.i386.rpm







- Original Message -
From: sanjay gupta [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 6:52 AM
Subject: installation problem Mysql 4.0.13 on Red Hat linux 6.2


 Dear All ,

I  am facing problem in installing the mysql 4.0.13 on my
 linux 6.2 machine . I have pentium III server. When i give the command
 rpm -ivt  MySQL-server-4.0.13-0.i386.rpm it give the message  Only one
 major mode may be specified 

 I tried lot to install the mysql ver 4 on my machine but could not succeed
.
 please help

 Thanks in advance.

 sanjay


 --
 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: installation problem Mysql 4.0.13 on Red Hat linux 6.2

2003-07-28 Thread sanjay gupta
i am unable to install mysql 4.0 on my Rh. 6.2 box.
i have glib 1.2.6. When try to install the mysql it
gives the message Mysql-server-version no.cannot be
installed

May i know what are the minimum requirment for
installtion of mysql 4.0 on 6.2.

Is it possible to install the mysql 4.0 on 6.2

thanks in advance

sankalap





- Original Message -
From: sanjay gupta [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 11:22 AM
Subject: installation problem Mysql 4.0.13 on Red Hat linux 6.2


 Dear All ,

I  am facing problem in installing the mysql 4.0.13 on my
 linux 6.2 machine . I have pentium III server. When i give the command
 rpm -ivt  MySQL-server-4.0.13-0.i386.rpm it give the message  Only one
 major mode may be specified 

 I tried lot to install the mysql ver 4 on my machine but could not succeed
.
 please help

 Thanks in advance.

 sanjay


 --
 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: installation problem from tarball

2003-06-14 Thread Paul DuBois
What kind of system is this?

If you put this line near the top of client/mysql.cc (say, after the
line that includes signal.h), does the compile proceed?
#include errno.h

(I'm assuming that you have an errno.h somewhere on your system.)

At 8:43 -0700 6/14/03, Gaurav Kumar wrote:
hello mysql users.
i have lately joined the wonderful world of mysql.
i downloaded tarball mysqla-3.23.54a.
./configure is not giving me any problem.
however on executing make to compile the source file i
am getting error
_
make[2]: Entering directory
`/gaurav/mysql-3.23.54a/client'
source='mysql.cc' object='mysql.o' libtool=no \
depfile='.deps/mysql.Po' tmpdepfile='.deps/mysql.TPo'
\
depmode=gcc3 /bin/sh ../depcomp \
g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I./../include
-I../include -I./.. -I.. -I
..-O3 -DDBUG_OFF   -fno-implicit-templates
-fno-exceptions -fno-rtti -c -o m
ysql.o `test -f mysql.cc || echo './'`mysql.cc
/bin/sh ../libtool --mode=link g++  -O3 -DDBUG_OFF 
-fno-implicit-templates -fn
o-exceptions -fno-rtti  -rdynamic  -o mysql  mysql.o
readline.o sql_string.o com
pletion_hash.o ../readline/libreadline.a -lncurses
../libmysql/libmysqlclient.la
  -lz -lcrypt -lnsl -lm
g++ -O3 -DDBUG_OFF -fno-implicit-templates
-fno-exceptions -fno-rtti -rdynamic -
o .libs/mysql mysql.o readline.o sql_string.o
completion_hash.o  ../readline/lib
readline.a -lncurses
../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl
-lm -
Wl,--rpath -Wl,/usr/local/lib/mysql
mysql.o(.text+0x189c): In function
`com_source(String*, char*)':
: undefined reference to `errno'
collect2: ld returned 1 exit status
make[2]: *** [mysql] Error 1
make[2]: Leaving directory
`/gaurav/mysql-3.23.54a/client'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/gaurav/mysql-3.23.54a'
make: *** [all] Error 2
[EMAIL PROTECTED] mysql-3.23.54a]#
__

plz help

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
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: installation problem from tarball

2003-06-14 Thread Gaurav Kumar
i am using red hat linux 9 on x86
i have copied that the errno.h file from /usr/include
and put #include errno.h at the top of the file 
here it is what it looke like..
__
/* mysql command tool
 * Commands compatible with mSQL by David J. Hughes
 *
 * Written by:
 *   Michael 'Monty' Widenius
 *   Andi Gutmans  [EMAIL PROTECTED]
 *   Zeev Suraski [EMAIL PROTECTED]
 *   Jani Tolonen [EMAIL PROTECTED]
 *
 **/
#include errno.h
#include client_priv.h
#include m_ctype.h
#include my_dir.h
#ifndef __GNU_LIBRARY__
#define __GNU_LIBRARY__   // Skip warnings in
getopt.h
#endif
#include my_readline.h
#include signal.h


still i am getting the same error.
plz help.



--- Paul DuBois [EMAIL PROTECTED] wrote:
 What kind of system is this?
 
 If you put this line near the top of client/mysql.cc
 (say, after the
 line that includes signal.h), does the compile
 proceed?
 
 #include errno.h
 
 (I'm assuming that you have an errno.h somewhere on
 your system.)
 
 At 8:43 -0700 6/14/03, Gaurav Kumar wrote:
 hello mysql users.
 i have lately joined the wonderful world of mysql.
 i downloaded tarball mysqla-3.23.54a.
 
 ./configure is not giving me any problem.
 however on executing make to compile the source
 file i
 am getting error

_
 make[2]: Entering directory
 `/gaurav/mysql-3.23.54a/client'
 source='mysql.cc' object='mysql.o' libtool=no \
 depfile='.deps/mysql.Po'
 tmpdepfile='.deps/mysql.TPo'
 \
 depmode=gcc3 /bin/sh ../depcomp \
 g++ -DUNDEF_THREADS_HACK -I. -I. -I..
 -I./../include
 -I../include -I./.. -I.. -I
 ..-O3 -DDBUG_OFF   -fno-implicit-templates
 -fno-exceptions -fno-rtti -c -o m
 ysql.o `test -f mysql.cc || echo './'`mysql.cc
 /bin/sh ../libtool --mode=link g++  -O3 -DDBUG_OFF 
 -fno-implicit-templates -fn
 o-exceptions -fno-rtti  -rdynamic  -o mysql 
 mysql.o
 readline.o sql_string.o com
 pletion_hash.o ../readline/libreadline.a -lncurses
 ../libmysql/libmysqlclient.la
-lz -lcrypt -lnsl -lm
 g++ -O3 -DDBUG_OFF -fno-implicit-templates
 -fno-exceptions -fno-rtti -rdynamic -
 o .libs/mysql mysql.o readline.o sql_string.o
 completion_hash.o  ../readline/lib
 readline.a -lncurses
 ../libmysql/.libs/libmysqlclient.so -lz -lcrypt
 -lnsl
 -lm -
 Wl,--rpath -Wl,/usr/local/lib/mysql
 mysql.o(.text+0x189c): In function
 `com_source(String*, char*)':
 : undefined reference to `errno'
 collect2: ld returned 1 exit status
 make[2]: *** [mysql] Error 1
 make[2]: Leaving directory
 `/gaurav/mysql-3.23.54a/client'
 make[1]: *** [all-recursive] Error 1
 make[1]: Leaving directory `/gaurav/mysql-3.23.54a'
 make: *** [all] Error 2
 [EMAIL PROTECTED] mysql-3.23.54a]#

__
 
 
 plz help
 
 __
 Do you Yahoo!?
 SBC Yahoo! DSL - Now only $29.95 per month!
 http://sbc.yahoo.com
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:   
 http://lists.mysql.com/[EMAIL PROTECTED]
 
 
 -- 
 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]
 


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

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



Re: Installation problem: mysql.sock missing (??)

2002-08-25 Thread Mike

Do a locate mysql.sock it's there. Do a search on the newsgroup at 
http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b

On mysql.sock

M;)

On Sat, 2002-08-24 at 21:34, Roger Young wrote:
 
 
 I'm trying to install the binary mysql-3.23.52 under Linux (Slackware
 8.2 distribution, kernel 2.4.18).
 
 I have followed the installation steps suggested in the INSTALL-BINARY
 file.  However the daemon will not start, or rather it startd and
 immediately exits, and there is this message in the error log
 
 020825 11:03:14  mysqld started
 020825 11:03:14  Can't start server : Bind on unix socket: No such
 file or directory
 020825 11:03:14  Do you already have another mysqld server running on
 socket: /var/run/mysql/mysql.sock ?
 020825 11:03:14  Aborting
 
 In fact neither the socket nor the socket directory /var/run/mysql
 have been created.
 
 I created the directory but still got the same error.
 How do I properly install mysql?
 
 Thanks for your help,
 
 Roger Young
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Installation problem: mysql.sock missing (??)

2002-08-25 Thread Roger Young




Thanks for your reply.

Do a locate mysql.sock it's there. 

For some reason on my machine the mysql install procedure 
does not create the socket. The locate utility (after updatedb)
does not find mysql.sock and the socket directory /var/run/mysql
is not established.

I must be omitting some vital step but what is it?
The mysql package is untarred in /usr/local
The scripts/mysql_install_db is run. But the socket
is missing...

Do a search on the newsgroup at 
http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b
On mysql.sock

Didn't have much luck with this either: Sorry, but search returned no results.
I did go through the August messages but couldn't find anything relevant.

What part of the install procedure sets up the socket?
Would it be better to compile from the source rather than
from the binary package?

Thanks for any further help or comment.

Roger Young


Do a locate mysql.sock it's there. Do a search on the newsgroup at 
http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b

On mysql.sock

M;)

On Sat, 2002-08-24 at 21:34, Roger Young wrote:
 
 
 I'm trying to install the binary mysql-3.23.52 under Linux (Slackware
 8.2 distribution, kernel 2.4.18).
 
 I have followed the installation steps suggested in the INSTALL-BINARY
 file.  However the daemon will not start, or rather it startd and
 immediately exits, and there is this message in the error log
 
 020825 11:03:14  mysqld started
 020825 11:03:14  Can't start server : Bind on unix socket: No such
 file or directory
 020825 11:03:14  Do you already have another mysqld server running on
 socket: /var/run/mysql/mysql.sock ?
 020825 11:03:14  Aborting
 
 In fact neither the socket nor the socket directory /var/run/mysql
 have been created.
 
 I created the directory but still got the same error.
 How do I properly install mysql?
 
 Thanks for your help,
 
 Roger Young
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Installation problem: mysql.sock missing (??)

2002-08-25 Thread Gelu Gogancea

Hi,

MySQL install do not create socket.This socket it's created when MySQL
daemon it's started.
My suggestion :
1.check if you have already mysqld processes.
2.
- Change the owner of directory which is created for mysql.sock from
root to mysql
...or
- Change in /etc/my.cnf(in [mysqld] section) the name of directory where
you wish to mysqld create the socket.You must be sure that directory is
*mysql* owner.
3.Start mysqld under init.d directory (/etc/rc.d/init.d...from what i
remember.I don't have Slackware installed in this moment)


Regards,

Gelu

_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: Roger Young [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, August 25, 2002 1:44 PM
Subject: Re: Installation problem: mysql.sock missing (??)





 Thanks for your reply.

 Do a locate mysql.sock it's there.

 For some reason on my machine the mysql install procedure
 does not create the socket. The locate utility (after updatedb)
 does not find mysql.sock and the socket directory /var/run/mysql
 is not established.

 I must be omitting some vital step but what is it?
 The mysql package is untarred in /usr/local
 The scripts/mysql_install_db is run. But the socket
 is missing...

 Do a search on the newsgroup at
 http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b
 On mysql.sock

 Didn't have much luck with this either: Sorry, but search returned no
results.
 I did go through the August messages but couldn't find anything relevant.

 What part of the install procedure sets up the socket?
 Would it be better to compile from the source rather than
 from the binary package?

 Thanks for any further help or comment.

 Roger Young

 
 Do a locate mysql.sock it's there. Do a search on the newsgroup at
 http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b

 On mysql.sock

 M;)

 On Sat, 2002-08-24 at 21:34, Roger Young wrote:
 
 
  I'm trying to install the binary mysql-3.23.52 under Linux (Slackware
  8.2 distribution, kernel 2.4.18).
 
  I have followed the installation steps suggested in the INSTALL-BINARY
  file.  However the daemon will not start, or rather it startd and
  immediately exits, and there is this message in the error log
 
  020825 11:03:14  mysqld started
  020825 11:03:14  Can't start server : Bind on unix socket: No such
  file or directory
  020825 11:03:14  Do you already have another mysqld server running on
  socket: /var/run/mysql/mysql.sock ?
  020825 11:03:14  Aborting
 
  In fact neither the socket nor the socket directory /var/run/mysql
  have been created.
 
  I created the directory but still got the same error.
  How do I properly install mysql?
 
  Thanks for your help,
 
  Roger Young
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
[EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 




 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Installation problem: mysql.sock missing (??)

2002-08-25 Thread Roger Young



MySQL install do not create socket.This socket it's created when MySQL
daemon it's started.
My suggestion :
1.check if you have already mysqld processes.
2.
- Change the owner of directory which is created for mysql.sock from
root to mysql
...or
- Change in /etc/my.cnf(in [mysqld] section) the name of directory where
you wish to mysqld create the socket.You must be sure that directory is
*mysql* owner.
3.Start mysqld under init.d directory (/etc/rc.d/init.d...from what i
remember.I don't have Slackware installed in this moment)


Thanks, I understand now.
Almost certainly this will solve my problem.
I think some additional explanation could be included
in the INSTALL_BINARY help file for the benefit of
mysql newbies like myself...:-)

Roger Young

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Installation Problem

2002-07-22 Thread Dexter S. Tan
... yes
checking for stdint.h... no
checking for unistd.h... yes
checking for size_t... yes
checking for dirent.h that defines DIR... yes
checking for opendir in -ldir... no
checking for ANSI C header files... (cached) yes
checking for sys/wait.h that is POSIX.1 compatible... yes
checking for fcntl.h... yes
checking for float.h... yes
checking for floatingpoint.h... yes
checking for ieeefp.h... yes
checking for limits.h... yes
checking for memory.h... (cached) yes
checking for pwd.h... yes
checking for select.h... no
checking for stdlib.h... (cached) yes
checking for stddef.h... yes
checking for strings.h... (cached) yes
checking for string.h... (cached) yes
checking for synch.h... yes
checking for sys/mman.h... yes
checking for sys/socket.h... yes
checking for netinet/in.h... yes
checking for arpa/inet.h... yes
checking for sys/timeb.h... yes
checking for sys/types.h... (cached) yes
checking for sys/un.h... yes
checking for sys/vadvise.h... no
checking for sys/wait.h... (cached) yes
checking for term.h... yes
checking for unistd.h... (cached) yes
checking for utime.h... yes
checking for sys/utime.h... yes
checking for termio.h... yes
checking for termios.h... yes
checking for sched.h... yes
checking for crypt.h... yes
checking for alloca.h... yes
checking for sys/ioctl.h... yes
checking for floor in -lm... yes
checking for gethostbyname_r in -lnsl_r... no
checking for gethostbyname_r in -lnsl... yes
checking for gethostbyname_r... yes
checking for setsockopt... no
checking for setsockopt in -lsocket... yes
checking for yp_get_default_domain... yes
checking for p2open... no
checking for p2open in -lgen... yes
checking for bind... yes
checking for crypt in -lcrypt... yes
checking for crypt... yes
checking if libz with compress... no
checking for int8... no
Fixing broken include files for sun-solaris2.8
  - Creating local copy of widec.h
checking LinuxThreads... Not found
checking DEC threads... no
checking DEC 3.2 threads... no
checking SCO threads... no
checking SCO UnixWare7 native threads... no
checking OpenUNIX8 native threads... no
checking Siemens threads... no
checking Solaris threads... yes
checking named thread libs:... -lpthread -lthread
checking for strtok_r in -lpthread... yes
checking for strtok_r... yes
checking for dlopen in -ldl... yes
checking for unistd.h... (cached) yes
checking for restartable system calls... no
checking need of special linking flags... none
checking for /usr/local/compiler/GNUgcc/root/usr/local/bin/c++ option to
accept ANSI C... none needed
checking for an ANSI C-conforming const... yes
checking for inline... inline
checking for off_t... yes
checking for struct stat.st_rdev... yes
checking whether time.h and sys/time.h may both be included... yes
checking whether struct tm is in sys/time.h or time.h... time.h
checking for char... yes
checking size of char... 1
checking for int... yes
checking size of int... 4
checking for long... yes
checking size of long... 4
checking for long long... yes
checking size of long long... 8
checking size of off_t... 8
checking whether byte ordering is bigendian... yes
checking base type of last arg to accept... socklen_t
checking stack direction for C alloca... -1
checking for working alloca.h... (cached) yes
checking for alloca... yes
checking if struct timespec has a ts_sec member... no
checking if we have tzname variable... yes
checking for type ulong... yes
checking for type uchar... no
checking for type uint... yes
checking for type fp_except... yes
checking if /usr/local/compiler/GNUgcc/root/usr/local/bin/c++ supports bool
types... yes
checking if conversion of longlong to float works... no
configure: error: Your compiler cannot convert a longlong value to a float!
If you are using gcc 2.8.# you should upgrade to egcs 1.0.3 or newer and try
again


Thank you very much..
Dexter

- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Dexter S. Tan [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 22, 2002 11:11 AM
Subject: Re: Installation Problem


 In the last episode (Jul 22), Dexter S. Tan said:
  _
  command i entered
  CC=gcc CFLAGS=-O3 \
  CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \
 
./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler
 [...]
  checking for C compiler default output... configure: error: C compiler
cannot create executables
 [...]
  configure:1948: checking for C compiler default output
  configure:1951: gcc -O3conftest.c  5
  ./configure: gcc: not found

 Configure can't find gcc.  Either make sure it's in your PATH, or put
 the pull path to gcc and c++ in your configure command.  Note, CXX=gcc
 will *not* work.  gcc is not a c++ compiler; g++ is.  Use CXX=g++.

 --
 Dan Nelson
 [EMAIL PROTECTED]



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http

Re: Installation Problem

2002-07-22 Thread Dexter S. Tan

Dan,

Hi, good news.. =) I've already successfully installed mysql...
Thank you very much to you and georg :)
Thanks for helping me out. I'm quite new here...

My last problem was solved by fixing my path... 
ok... 

Dexter...




- Original Message - 
From: Dan Nelson [EMAIL PROTECTED]
To: Dexter S. Tan [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 22, 2002 10:53 PM
Subject: Re: Installation Problem


 In the last episode (Jul 22), Dexter S. Tan said:
  Hi,
  
  I've tried it and I still encountered this.
  btw, my compiler version is 2.95.2
  Here is the result.
 [...] 
  checking for gcc... /usr/local/compiler/GNUgcc/root/usr/local/bin/c++
 
 Heh.  You don't want to set CC=g++. :)  You want CC=gcc, CXX=g++.
 
 -- 
 Dan Nelson
 [EMAIL PROTECTED]
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Installation Problem

2002-07-21 Thread Dexter S. Tan

Hi Georg,

I have tried to change the zero to letter O and still have this problem.
I'll paste below the config.log file and the output.

Thank you very much for your help.


_
command i entered
CC=gcc CFLAGS=-O3 \
CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \
./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler




_
screen output:
checking build system type... sparc-sun-solaris2.8
checking host system type... sparc-sun-solaris2.8
checking target system type... sparc-sun-solaris2.8
checking for a BSD compatible install... ./install-sh -c
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... ./configure: make: not found
no
checking for working aclocal... missing
checking for working autoconf... missing
checking for working automake... missing
checking for working autoheader... missing
checking for working makeinfo... missing
checking whether to enable maintainer-specific portions of Makefiles... no
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... (cached) no
checking for mawk... no
checking for gawk... no
checking for nawk... nawk
checking for gcc... gcc
checking for C compiler default output... configure: error: C compiler
cannot create executables


_
config.log file

This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.

It was created by configure, which was
generated by GNU Autoconf 2.52.  Invocation command line was

  $
./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler

## -- ##
## Platform.  ##
## -- ##

hostname = bigbird
uname -m = sun4u
uname -r = 5.8
uname -s = SunOS
uname -v = Generic_108528-13

/usr/bin/uname -p = sparc
/bin/uname -X = System = SunOS
Node = bigbird
Release = 5.8
KernelID = Generic_108528-13
Machine = sun4u
BusType = unknown
Serial = unknown
Users = unknown
OEM# = 0
Origin# = 1
NumCPU = 1

/bin/arch  = sun4
/usr/bin/arch -k   = sun4u
/usr/convex/getsysinfo = unknown
hostinfo   = unknown
/bin/machine   = unknown
/usr/bin/oslevel   = unknown
/bin/universe  = unknown

PATH = /usr/sbin:/usr/bin

##  ##
## Core tests.  ##
##  ##

configure:1044: PATH=.;.; conftest.sh
./configure: conftest.sh: not found
configure:1047: $? = 1
configure:1087: checking build system type
configure:1105: result: sparc-sun-solaris2.8
configure:1115: checking host system type
configure:1129: result: sparc-sun-solaris2.8
configure:1139: checking target system type
configure:1153: result: sparc-sun-solaris2.8
configure:1182: checking for a BSD compatible install
configure:1231: result: ./install-sh -c
configure:1242: checking whether build environment is sane
configure:1260: result: yes
configure:1275: checking whether make sets ${MAKE}
configure:1299: result: no
configure:1323: checking for working aclocal
configure:1334: result: missing
configure:1338: checking for working autoconf
configure:1349: result: missing
configure:1353: checking for working automake
configure:1364: result: missing
configure:1368: checking for working autoheader
configure:1379: result: missing
configure:1383: checking for working makeinfo
configure:1394: result: missing
configure:1473: checking whether to enable maintainer-specific portions of
Makefiles
configure:1482: result: no
configure:1495: checking whether build environment is sane
configure:1513: result: yes
configure:1516: checking whether make sets ${MAKE}
configure:1540: result: no
configure:1585: checking for mawk
configure:1611: result: no
configure:1585: checking for gawk
configure:1611: result: no
configure:1585: checking for nawk
configure:1600: found /usr/bin/nawk
configure:1608: result: nawk
configure:1661: checking for gcc
configure:1684: result: gcc
configure:1912: checking for C compiler version
configure:1915: gcc --version /dev/null 5
./configure: gcc: not found
configure:1918: $? = 1
configure:1920: gcc -v /dev/null 5
./configure: gcc: not found
configure:1923: $? = 1
configure:1925: gcc -V /dev/null 5
./configure: gcc: not found
configure:1928: $? = 1
configure:1948: checking for C compiler default output
configure:1951: gcc -O3conftest.c  5
./configure: gcc: not found
configure:1954: $? = 1
configure: failed program was:
#line 1932 configure
#include confdefs.h

int
main ()
{

  ;
  return 0;
}
configure:1977: error: C compiler cannot create executables

## - ##
## Cache variables.  ##
## - ##

ac_cv_build='sparc-sun-solaris2.8'
ac_cv_build_alias='sparc-sun-solaris2.8'
ac_cv_env_CC_set='set'
ac_cv_env_CC_value='gcc'
ac_cv_env_CFLAGS_set='set'
ac_cv_env_CFLAGS_value='-O3'
ac_cv_env_CPPFLAGS_set=''
ac_cv_env_CPPFLAGS_value=''
ac_cv_env_CPP_set=''

Re: Installation Problem

2002-07-21 Thread Dan Nelson

In the last episode (Jul 22), Dexter S. Tan said:
 _
 command i entered
 CC=gcc CFLAGS=-O3 \
 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \
 ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler
[...]
 checking for C compiler default output... configure: error: C compiler cannot create 
executables
[...]
 configure:1948: checking for C compiler default output
 configure:1951: gcc -O3conftest.c  5
 ./configure: gcc: not found

Configure can't find gcc.  Either make sure it's in your PATH, or put
the pull path to gcc and c++ in your configure command.  Note, CXX=gcc
will *not* work.  gcc is not a c++ compiler; g++ is.  Use CXX=g++.

-- 
Dan Nelson
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Installation Problem

2002-07-21 Thread Dexter S. Tan

Dan,

Thank you very much.
I'll try it again and update you as soon as i got the result...


Dexter.

- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Dexter S. Tan [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 22, 2002 11:11 AM
Subject: Re: Installation Problem


 In the last episode (Jul 22), Dexter S. Tan said:
  _
  command i entered
  CC=gcc CFLAGS=-O3 \
  CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \
 
./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler
 [...]
  checking for C compiler default output... configure: error: C compiler
cannot create executables
 [...]
  configure:1948: checking for C compiler default output
  configure:1951: gcc -O3conftest.c  5
  ./configure: gcc: not found

 Configure can't find gcc.  Either make sure it's in your PATH, or put
 the pull path to gcc and c++ in your configure command.  Note, CXX=gcc
 will *not* work.  gcc is not a c++ compiler; g++ is.  Use CXX=g++.

 --
 Dan Nelson
 [EMAIL PROTECTED]



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Installation Problem

2002-07-19 Thread Dexter S. Tan

Georg,

Here is the content of the config.log file..

config.log
This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.

It was created by configure, which was
generated by GNU Autoconf 2.52.  Invocation command line was

  $
./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler

## -- ##
## Platform.  ##
## -- ##

hostname = bigbird
uname -m = sun4u
uname -r = 5.8
uname -s = SunOS
uname -v = Generic_108528-13

/usr/bin/uname -p = sparc
/bin/uname -X = System = SunOS
Node = bigbird
Release = 5.8
KernelID = Generic_108528-13
Machine = sun4u
BusType = unknown
Serial = unknown
Users = unknown
OEM# = 0
Origin# = 1
NumCPU = 1

/bin/arch  = sun4
/usr/bin/arch -k   = sun4u
/usr/convex/getsysinfo = unknown
hostinfo   = unknown
/bin/machine   = unknown
/usr/bin/oslevel   = unknown
/bin/universe  = unknown

PATH = /usr/sbin:/usr/bin:/opt/DCT2000/GNU-C:/usr/ccs/bin:/usr/openwin/bin

##  ##
## Core tests.  ##
##  ##

configure:1044: PATH=.;.; conftest.sh
./configure: conftest.sh: not found
configure:1047: $? = 1
configure:1087: checking build system type
configure:1105: result: sparc-sun-solaris2.8
configure:1115: checking host system type
configure:1129: result: sparc-sun-solaris2.8
configure:1139: checking target system type
configure:1153: result: sparc-sun-solaris2.8
configure:1182: checking for a BSD compatible install
configure:1231: result: ./install-sh -c
configure:1242: checking whether build environment is sane
configure:1260: result: yes
configure:1275: checking whether make sets ${MAKE}
configure:1295: result: yes
configure:1323: checking for working aclocal
configure:1334: result: missing
configure:1338: checking for working autoconf
configure:1349: result: missing
configure:1353: checking for working automake
configure:1364: result: missing
configure:1368: checking for working autoheader
configure:1379: result: missing
configure:1383: checking for working makeinfo
configure:1394: result: missing
configure:1473: checking whether to enable maintainer-specific portions of
Makefiles
configure:1482: result: no
configure:1495: checking whether build environment is sane
configure:1513: result: yes
configure:1516: checking whether make sets ${MAKE}
configure:1536: result: yes
configure:1585: checking for mawk
configure:1611: result: no
configure:1585: checking for gawk
configure:1611: result: no
configure:1585: checking for nawk
configure:1600: found /usr/bin/nawk
configure:1608: result: nawk
configure:1661: checking for gcc
configure:1684: result: gcc
configure:1912: checking for C compiler version
configure:1915: gcc --version /dev/null 5
2.95.2
configure:1918: $? = 0
configure:1920: gcc -v /dev/null 5
Using builtin specs.
gcc version 2.95.2 19991024 (release)
configure:1923: $? = 0
configure:1925: gcc -V /dev/null 5
gcc: argument to `-V' is missing
configure:1928: $? = 1
configure:1948: checking for C compiler default output
configure:1951: gcc -03conftest.c  5
gcc: unrecognized option `-03'
cpp: Internal compiler error: program cpp got fatal signal 9
configure:1954: $? = 1
configure: failed program was:
#line 1932 configure
#include confdefs.h

int
main ()
{

  ;
  return 0;
}
configure:1977: error: C compiler cannot create executables

## - ##
## Cache variables.  ##
## - ##

ac_cv_build='sparc-sun-solaris2.8'
ac_cv_build_alias='sparc-sun-solaris2.8'
ac_cv_env_CC_set='set'
ac_cv_env_CC_value='gcc'
ac_cv_env_CFLAGS_set='set'
ac_cv_env_CFLAGS_value='-03'
ac_cv_env_CPPFLAGS_set=''
ac_cv_env_CPPFLAGS_value=''
ac_cv_env_CPP_set=''
ac_cv_env_CPP_value=''
ac_cv_env_CXXFLAGS_set='set'
ac_cv_env_CXXFLAGS_value='-03 -felide-constructors -fno-exceptions -fno-rtti
'
ac_cv_env_CXX_set='set'
ac_cv_env_CXX_value='gcc'
ac_cv_env_LDFLAGS_set=''
ac_cv_env_LDFLAGS_value=''
ac_cv_env_build_alias_set=''
ac_cv_env_build_alias_value=''
ac_cv_env_host_alias_set=''
ac_cv_env_host_alias_value=''
ac_cv_env_target_alias_set=''
ac_cv_env_target_alias_value=''
ac_cv_host='sparc-sun-solaris2.8'
ac_cv_host_alias='sparc-sun-solaris2.8'
ac_cv_prog_AWK='nawk'
ac_cv_prog_ac_ct_CC='gcc'
ac_cv_prog_make_make_set='yes'
ac_cv_target='sparc-sun-solaris2.8'
ac_cv_target_alias='sparc-sun-solaris2.8'

##  ##
## confdefs.h.  ##
##  ##

#define PACKAGE mysql
#define VERSION 3.23.51
#define PROTOCOL_VERSION 10
#define DOT_FRM_VERSION 6
#define SYSTEM_TYPE sun-solaris2.8
#define MACHINE_TYPE sparc


configure: exit 77






Thank you for your quick response.. =)

Dexter

- Original Message -
From: Georg Richter [EMAIL PROTECTED]
To: Dexter S. Tan [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, July 19, 2002 1:38 PM
Subject: Re: Installation Problem


 On Friday, 19. July 2002 07:03, Dexter S. Tan wrote:

 Hello Dexter,

 would be interesting to know the content from your config.log file.

 Regards

Re: Installation Problem

2002-07-19 Thread Georg Richter

Hi Dexter,

 configure:1948: checking for C compiler default output
 configure:1951: gcc -03conftest.c  5
 gcc: unrecognized option `-03'
 cpp: Internal compiler error: program cpp got fatal signal 9
 configure:1954: $? = 1
 configure: failed program was:
 #line 1932 configure
 #include confdefs.h

Hi Dexter,

Hmm.. looks like that you have specified CC=gcc -03 ?!
Should be gcc -O3 (Letter O, not zero).

Regards

Georg

mysql,query




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Installation Problem

2002-07-18 Thread Georg Richter

On Friday, 19. July 2002 07:03, Dexter S. Tan wrote:

Hello Dexter,

would be interesting to know the content from your config.log file.

Regards

Georg

mysql,query


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Installation problem

2002-06-10 Thread Gerald Clark

Mysql does not own the database and its tables;

chown -R mysql  /usr/local/mysql/var

( or whatever the database location is. )

Kariuki, JohnX K wrote:

Hi I am pretty new to linux and I was trying to setup and use mysql, I
followed the directions you provided about compiling it and installing it,
but when I try to start the server the mysql daemon fail right away : saying
mysqld ended. I looked at the error log and this is what it says :
/usr/local/mysql/bin/mysqld: Can't find file : './mysql/host.frm' (errno :
13).
Now the file host.frm is in the directory /var/lib/mysql/mysql/host.frm, I
was gonna put this somewhere in the msqld file but it is not in human
readeable form. 
Thank you.
John

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail 
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: installation problem

2002-06-05 Thread louie miranda

folders = /var/lib/mysql - db tables i think..
commands will be on bin* dir, i think 2.

louie.


- Original Message -
From: mandar m pohnerkar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 05, 2002 1:49 PM
Subject: installation problem


 Dear Sir,

 I  have R.H Linux 7.2  and i have installed mysql
 MySQL-client-3.23.49a-1.i386.rpm .But now i m confused that how
 should i proceed?how to start the database and afterinstallation
 where r the folders/files created?
 Is there any manual for basic step on installation and starting
 the database and further proceeding ?

 Thanking You,

 mandar,
 India.
 _
 Click below to visit monsterindia.com and review jobs in India or
 Abroad
 http://monsterindia.rediff.com/jobs


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: installation problem

2002-06-05 Thread Egor Egorov

mandar,
Wednesday, June 05, 2002, 8:49:42 AM, you wrote:

mmp I  have R.H Linux 7.2  and i have installed mysql 
mmp MySQL-client-3.23.49a-1.i386.rpm .But now i m confused that how 
mmp should i proceed?how to start the database and afterinstallation 
mmp where r the folders/files created?
mmp Is there any manual for basic step on installation and starting 
mmp the database and further proceeding ?

Please, check the MySQL manual:
http://www.mysql.com/doc/P/o/Post-installation.html

mmp mandar,
mmp India.





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



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: installation problem

2002-06-04 Thread Terence

yes. www.mysql.com

- Original Message -
From: mandar m pohnerkar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 05, 2002 1:49 PM
Subject: installation problem


Dear Sir,

I  have R.H Linux 7.2  and i have installed mysql
MySQL-client-3.23.49a-1.i386.rpm .But now i m confused that how
should i proceed?how to start the database and afterinstallation
where r the folders/files created?
Is there any manual for basic step on installation and starting
the database and further proceeding ?

Thanking You,

mandar,
India.
_
Click below to visit monsterindia.com and review jobs in India or
Abroad
http://monsterindia.rediff.com/jobs


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: installation problem

2002-03-13 Thread Gelu

Hi,
Try to start mySQL daemon like service in init 3.

Good luck,

Gelu

- Original Message -
From: Aman Raheja [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 13, 2002 12:00 AM
Subject: Re: installation problem


 This is what's going on


 [root@coolnis-ar mysql]# Starting mysqld daemon with databases from
 /var/lib/mysql
 020312 15:57:31  mysqld ended


 [1]+  Done./bin/safe_mysqld --user=mysql
 --err-log=my.err
 [root@coolnis-ar mysql]# more my.err
 020312 15:56:40  mysqld started
 020312 15:56:40  Can't start server : Bind on unix socket: Permission
denied
 020312 15:56:40  Do you already have another mysqld server running on
 socket: /var/lib/mysql/mysql.sock ?
 020312 15:56:40  Aborting

 020312 15:56:40  /usr/local/mysql/bin/mysqld: Shutdown Complete

 020312 15:56:40  mysqld ended

 020312 15:57:31  mysqld started
 020312 15:57:31  Can't start server : Bind on unix socket: Permission
denied
 020312 15:57:31  Do you already have another mysqld server running on
 socket: /var/lib/mysql/mysql.sock ?
 020312 15:57:31  Aborting

 020312 15:57:31  /usr/local/mysql/bin/mysqld: Shutdown Complete

 020312 15:57:31  mysqld ended

 [root@coolnis-ar mysql]#


 Any suggestions ?
 Thank you
 Aman Raheja

 _
 Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp.


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: installation problem

2002-03-12 Thread ds

Check /var/lib/mysql/hostname.err and permissions in that directory.
Does the mysql user have the permission to write on that directory ?

You you don't have the log error (it's very strange if you don't...), i
think safe_mysqld has the option --err-log=filename (but, by default,
it should be there).
I'm not shure of this, i'm just giving some ideas.


On Tue, 2002-03-12 at 21:01, Aman Raheja wrote:
 New to MySQL.
 Have got RH Linux 7.2 on Intel-based processor
 Installed MySql from a mysql-max-3.23.49a-pc-linux-gnu-i686.tar.gz
 Followed the documentation instructions given in Chapter 2 online at 
 
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Installing_binary
 I get the following
 
 [root@coolnis-ar mysql]# bin/safe_mysqld --user=mysql 
 [1] 2796
 [root@coolnis-ar mysql]# Starting mysqld daemon with databases from 
 /var/lib/mysql
 020312 14:56:50  mysqld ended
 
 
 [1]+  Donebin/safe_mysqld --user=mysql
 [root@coolnis-ar mysql]#
 
 I do not get any .err file either and the MySQL server doen't start.
 Please help
 Thank you
 Aman
 

-- 
dsoares
(sql)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: installation problem

2002-03-12 Thread Aman Raheja

This is what's going on


[root@coolnis-ar mysql]# Starting mysqld daemon with databases from 
/var/lib/mysql
020312 15:57:31  mysqld ended


[1]+  Done./bin/safe_mysqld --user=mysql 
--err-log=my.err
[root@coolnis-ar mysql]# more my.err
020312 15:56:40  mysqld started
020312 15:56:40  Can't start server : Bind on unix socket: Permission denied
020312 15:56:40  Do you already have another mysqld server running on 
socket: /var/lib/mysql/mysql.sock ?
020312 15:56:40  Aborting

020312 15:56:40  /usr/local/mysql/bin/mysqld: Shutdown Complete

020312 15:56:40  mysqld ended

020312 15:57:31  mysqld started
020312 15:57:31  Can't start server : Bind on unix socket: Permission denied
020312 15:57:31  Do you already have another mysqld server running on 
socket: /var/lib/mysql/mysql.sock ?
020312 15:57:31  Aborting

020312 15:57:31  /usr/local/mysql/bin/mysqld: Shutdown Complete

020312 15:57:31  mysqld ended

[root@coolnis-ar mysql]#


Any suggestions ?
Thank you
Aman Raheja

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: installation problem

2002-03-12 Thread ds

 [root@coolnis-ar mysql]# more my.err
 020312 15:56:40  mysqld started
 020312 15:56:40  Can't start server : Bind on unix socket: Permission denied
 020312 15:56:40  Do you already have another mysqld server running on 
 socket: /var/lib/mysql/mysql.sock ?
 020312 15:56:40  Aborting
 
 020312 15:56:40  /usr/local/mysql/bin/mysqld: Shutdown Complete
 
 020312 15:56:40  mysqld ended
 
 Any suggestions ?

Be shure you don't have any mysqld running:

# ps auxw | grep mysqld

If you have, kill all processes (i don't think you have).
I believe you don't have permission to create mysql.sock.
Find where mysql would create the socket:

# my_print_defaults mysqld | grep socket
--socket=/var/lib/mysql/mysql.sock

or

# /usr/sbin/mysqld --help | grep socket
--socket=...  Socket file to use for connection
Unix socket: /var/lib/mysql/mysql.sock

and check the user mysql permissions to write on the directory found.
In this case, you should check permissions /var/lib/mysql. 
Al least, you should have:

# ls -ld /var/lib/mysql/
drwxr-xr-x   10 mysqlmysql4096 Mar 12 10:39 /var/lib/mysql/

Don't forget to substitute /var/lib/mysql by your directory.


-- 
dsoares
(sql)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: installation problem

2002-03-12 Thread Aman Raheja

- The default socket parameter is correct
- mysqld is not running earlier
- I changed the required ownership

#ls -ld /var/lib/mysql/
drwxr-xr-x4 mysqlmysql4096 Mar 12 17:46 /var/lib/mysql/
#

I am still getting the same

#more my.err
020312 15:56:40  mysqld started
020312 15:56:40  Can't start server : Bind on unix socket: Permission denied
020312 15:56:40  Do you already have another mysqld server running on 
socket: /var/lib/mysql/mysql.sock ?
020312 15:56:40  Aborting

020312 15:56:40  /usr/local/mysql/bin/mysqld: Shutdown Complete

020312 15:56:40  mysqld ended

020312 15:57:31  mysqld started
020312 15:57:31  Can't start server : Bind on unix socket: Permission denied
020312 15:57:31  Do you already have another mysqld server running on 
socket: /var/lib/mysql/mysql.sock ?
020312 15:57:31  Aborting

020312 15:57:31  /usr/local/mysql/bin/mysqld: Shutdown Complete

020312 15:57:31  mysqld ended

#

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: installation problem

2002-03-12 Thread ds

You have a strange problem so i've searched the MySQL manual:

http://www.mysql.com/doc/S/t/Starting_server.html

-
 If you get the following error, it means that some other program (or
another mysqld server) is already using the TCP/IP port or socket mysqld
is trying to use:

Can't start server: Bind on TCP/IP port: Address already in use
  or
Can't start server : Bind on unix socket...

Use ps to make sure that you don't have another mysqld server running.
If you can't find another server running, you can try to execute the
command telnet your-host-name tcp-ip-port-number and press Enter a
couple of times. If you don't get an error message like telnet: Unable
to connect to remote host: Connection refused, something is using the
TCP/IP port mysqld is trying to use. See section 2.4.1 Problems Running
mysql_install_db and section 4.1.4 Running Multiple MySQL Servers on the
Same Machine.

---
So, try the telnet command...
I think i can't help you more :-(
Good luck!


On Tue, 2002-03-12 at 23:54, Aman Raheja wrote:
 - The default socket parameter is correct
 - mysqld is not running earlier
 - I changed the required ownership
 
 #ls -ld /var/lib/mysql/
 drwxr-xr-x4 mysqlmysql4096 Mar 12 17:46 /var/lib/mysql/
 #
 
 I am still getting the same
 
 #more my.err
 020312 15:56:40  mysqld started
 020312 15:56:40  Can't start server : Bind on unix socket: Permission denied
 020312 15:56:40  Do you already have another mysqld server running on 
 socket: /var/lib/mysql/mysql.sock ?
 020312 15:56:40  Aborting
 
 020312 15:56:40  /usr/local/mysql/bin/mysqld: Shutdown Complete
 
 020312 15:56:40  mysqld ended
 
 020312 15:57:31  mysqld started
 020312 15:57:31  Can't start server : Bind on unix socket: Permission denied
 020312 15:57:31  Do you already have another mysqld server running on 
 socket: /var/lib/mysql/mysql.sock ?
 020312 15:57:31  Aborting
 
 020312 15:57:31  /usr/local/mysql/bin/mysqld: Shutdown Complete
 
 020312 15:57:31  mysqld ended
 
 #
 
 _
 Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
-- 
dsoares
(sql)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Installation Problem mysql-3.23.49

2002-02-20 Thread Sinisa Milivojevic

[EMAIL PROTECTED] writes:
 Description:
 When I run a ./configure --prefix=/usr/local/mysql --with-libwrap the configure 
completes but the make fails.
 
 Making all in sql
 make[2]: Entering directory `/usr/local/src/mysql-3.23.49/sql'
 Making all in share
 make[3]: Entering directory `/usr/local/src/mysql-3.23.49/sql/share'
 make[3]: Nothing to be done for `all'.
 make[3]: Leaving directory `/usr/local/src/mysql-3.23.49/sql/share'
 make[3]: Entering directory `/usr/local/src/mysql-3.23.49/sql'
 c++ -DMYSQL_SERVER  -DDEFAULT_MYSQL_HOME=\/usr/local/mysql\  
   -DDATADIR=\/usr/local/mysql/var\   
-DSHAREDIR=\/usr/local/mysql/share/mysql\-DHAVE_CONFIG_H
 -I./../include  -I./../regex-I. -I../include 
-I.. -I.-O3 -DDBUG_OFF   -fno-implicit-templates -fno-exceptions -fno-rtti
 -c mysqld.cc
 mysqld.cc: In function `void *handle_connections_sockets (void *)':
 /usr/include/tcpd.h:131: too many arguments to function `void sock_host
 ()'
 mysqld.cc:2395: at this point in file
 /usr/include/tcpd.h:69: too many arguments to function `int
 hosts_access ()'
 mysqld.cc:2396: at this point in file
 /usr/include/tcpd.h:124: too many arguments to function `char
 *eval_client ()'
 mysqld.cc:2401: at this point in file
 make[3]: *** [mysqld.o] Error 1
 make[3]: Leaving directory `/usr/local/src/mysql-3.23.49/sql'
 make[2]: *** [all-recursive] Error 1
 make[2]: Leaving directory `/usr/local/src/mysql-3.23.49/sql'
 make[1]: *** [all-recursive] Error 1
 make[1]: Leaving directory `/usr/local/src/mysql-3.23.49'
 make: *** [all-recursive-am] Error 2
 

This definitely requires that we take a look at it.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Installation problem Windows98

2001-12-17 Thread Heikki Tuuri

Gitta,

in Windows the error number 32 means:

32 
 The process cannot access the file because it is being used by another
process. 
 ERROR_SHARING_VIOLATION 

Maybe the installation left the MySQL server mysqld running in your system?
When you try to start another mysqld instance, it rightfully complains that
the ibdata file is already in use.

You can try connecting to the first mysqld instance with the SQL client:

C:...mysql test

Regards,

Heikki
Innobase Oy
---
See http://www.innodb.com for the latest news about InnoDB
Order commercial MySQL/InnoDB support at https://order.mysql.com/

Hello,

may I ask for help concerning the following problem:
I just installed mysql, created a my.cnf under c:/, containing
the information
[mysqld]
innodb data file path = ibdata1:50M.

IBdata1 was created.

But trying to start the server there is the following message:

C:\mysql\binmysqld
InnoDB: Warning: operating system error number 32 in a file 
operation.
InnoDB: Cannot continue operation.

I already deinstalled, and installed again, but anyway there is still  
the same error.

I don´t have an idea, about the meaning of the message.
Is there someone who can help ?

Regards
G.H.




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Installation problem

2001-06-12 Thread Gerry Tool

This morning after a restart of the computer, mysqld starts.  For future 
reference, where are the mysql logs?

Thanks.

Gerry

Rolf Hopkins wrote:

 What do the mysql error logs say?
 
 - Original Message -
 From: Gerry Tool [EMAIL PROTECTED]
 To: Rolf Hopkins [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Tuesday, June 12, 2001 11:33
 Subject: Re: Installation problem
 
 
 No, the daemon isn't running.
 
 Gerry
 
 Rolf Hopkins wrote:
 
 Has it already started?  Check with ps -ef | grep mysqld
 
 - Original Message -
 From: Gerry Tool [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, June 12, 2001 10:38
 Subject: Installation problem
 
 
 I have just installed mysql on a RH7.1 system from
 mysql-3.23.38-pc-linux-gnu-i686.tar.gz  using the procedure in the
 
 manual.
 
 -
 shell useradd -g mysql mysql
 shell cd /usr/local
 shell gunzip  /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
 shell ln -s mysql-VERSION-OS mysql
 shell cd mysql
 shell scripts/mysql_install_db
 shell chown -R mysql /usr/local/mysql
 shell chgrp -R mysql /usr/local/mysql
 shell bin/safe_mysqld --user=mysql 
 
 
 
 When I try to start the daemon, it immediately stops as shown below:
 
 [root@gstpc mysql]# bin/safe_mysqld --user=mysql 
 [1] 1664
 [root@gstpc mysql]# Starting mysqld daemon with databases from
 /usr/local/mysql/data
 010611 21:20:10  mysqld ended
 
 Any suggestions will be appreciated.
 
 Gerry Tool ([EMAIL PROTECTED])
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 
 [EMAIL PROTECTED]
 
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





Re: Installation problem

2001-06-12 Thread Tonu Samuel

On Tue, 12 Jun 2001, Gerry Tool wrote:

 This morning after a restart of the computer, mysqld starts.  For future 
 reference, where are the mysql logs?

In manual :)

This question cannot be answered with single sentence. Check the manual as
there are few differet logs in different OS-s in different places.

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Security Administrator
/_/  /_/\_, /___/\___\_\___/   Hong Kong, China
   ___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Installation problem

2001-06-11 Thread Gerry Tool

No, the daemon isn't running.

Gerry

Rolf Hopkins wrote:

 Has it already started?  Check with ps -ef | grep mysqld
 
 - Original Message -
 From: Gerry Tool [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, June 12, 2001 10:38
 Subject: Installation problem
 
 
 I have just installed mysql on a RH7.1 system from
 mysql-3.23.38-pc-linux-gnu-i686.tar.gz  using the procedure in the manual.
 -
 shell useradd -g mysql mysql
 shell cd /usr/local
 shell gunzip  /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
 shell ln -s mysql-VERSION-OS mysql
 shell cd mysql
 shell scripts/mysql_install_db
 shell chown -R mysql /usr/local/mysql
 shell chgrp -R mysql /usr/local/mysql
 shell bin/safe_mysqld --user=mysql 
 
 
 
 When I try to start the daemon, it immediately stops as shown below:
 
 [root@gstpc mysql]# bin/safe_mysqld --user=mysql 
 [1] 1664
 [root@gstpc mysql]# Starting mysqld daemon with databases from
 /usr/local/mysql/data
 010611 21:20:10  mysqld ended
 
 Any suggestions will be appreciated.
 
 Gerry Tool ([EMAIL PROTECTED])
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 
 [EMAIL PROTECTED]
 
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Installation problem

2001-06-11 Thread Rolf Hopkins

What do the mysql error logs say?

- Original Message -
From: Gerry Tool [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, June 12, 2001 11:33
Subject: Re: Installation problem


 No, the daemon isn't running.

 Gerry

 Rolf Hopkins wrote:

  Has it already started?  Check with ps -ef | grep mysqld
 
  - Original Message -
  From: Gerry Tool [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, June 12, 2001 10:38
  Subject: Installation problem
 
 
  I have just installed mysql on a RH7.1 system from
  mysql-3.23.38-pc-linux-gnu-i686.tar.gz  using the procedure in the
manual.
  -
  shell useradd -g mysql mysql
  shell cd /usr/local
  shell gunzip  /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
  shell ln -s mysql-VERSION-OS mysql
  shell cd mysql
  shell scripts/mysql_install_db
  shell chown -R mysql /usr/local/mysql
  shell chgrp -R mysql /usr/local/mysql
  shell bin/safe_mysqld --user=mysql 
 
  
 
  When I try to start the daemon, it immediately stops as shown below:
 
  [root@gstpc mysql]# bin/safe_mysqld --user=mysql 
  [1] 1664
  [root@gstpc mysql]# Starting mysqld daemon with databases from
  /usr/local/mysql/data
  010611 21:20:10  mysqld ended
 
  Any suggestions will be appreciated.
 
  Gerry Tool ([EMAIL PROTECTED])
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
 
  [EMAIL PROTECTED]
 
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: installation problem

2001-06-08 Thread Gabriele Bartolini


/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'

Ciao Michela,

unless you changed the 'user' table contents, you could easily connect 
to every db as root without providing any password. What's the command line 
you typed? Can you connect with 'mysql'?

As root, type this:

  mysql mysql
  select * from user;

and give a look at the host, user and password fields.

Hope this helps!

Ciao
-Gabriele

-
Gabriele Bartolini - Computer Programmer
U.O. Rete Civica - Comune di Prato
Prato - Italia - Europa
e-mail: [EMAIL PROTECTED]
http://www.po-net.prato.it
-
A Supernova is the celestial
equivalent of rm -rf /* with
root permissions.
-


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: installation problem

2001-06-07 Thread Rolf Hopkins

Is this a new installation?  Then the -p option is not required.  -p is only
used once you have set the initial password.

- Original Message -
From: Michela Robustelli [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 23:20
Subject: installation problem


 i've tried to install mysql version 3.23.3 for linux, but I get always the
 error message
 if I try to connect to bd: for example


 /mysqladmin: connect to server at 'localhost' failed
 error: 'Access denied for user: 'root@localhost' (Using password: YES)'


 michela

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: installation problem with Linux

2001-04-10 Thread David Loszewski

um...what?



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 12:29 PM
To: [EMAIL PROTECTED]
Subject: installation problem with Linux


Description:
sadsa

How-To-Repeat:
sasa
Fix:
none

Submitter-Id:  submitter ID
Originator:Richard McMahon
Organization:  Institute of Astronomy, University of Cambridge
MySQL support: [none | licence | email support | extended email support ]
none
Synopsis:
installation problem
Severity:
critical
Priority:
Category:  mysql
Class:
Release:   mysql-3.23.36 (Official MySQL binary)

Environment:

System: Linux vis100a 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown
Architecture: i686

Some paths:  /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.0)
Compilation info: CC='gcc'  CFLAGS='-O6 -mpentium '  CXX='gcc'
CXXFLAGS='-O6 -mpentium  -felide-constructors'  LDFLAGS='-static'
LIBC:
lrwxrwxrwx1 root root   14 Dec 12 14:48 /lib/libc.so.6 -
libc-2.1.92.so
-rwxr-xr-x1 root root  4776568 Aug 30  2000 /lib/libc-2.1.92.so
-rw-r--r--1 root root 22607104 Aug 30  2000 /usr/lib/libc.a
-rw-r--r--1 root root  178 Aug 30  2000 /usr/lib/libc.so
Configure command: ./configure  --prefix=/usr/local/mysql
'--with-comment=Official MySQL
binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldfla
gs=-all-static --with-client-ldflags=-all-static --disable-shared


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: installation problem

2001-03-09 Thread Charles L Hagen

I just went through this.  I found that it would be better to download and
install the binary from mysql.com because there is scant information.

With the binary install you get specific instruction sheets.

Charles

On Fri, 9 Mar 2001, Randall Paulk wrote:

 Dear Sirs:

 I am trying to install MySQL on Red Hat Linux 7.0.  It seems to install correctly, 
but I am unable to test it.  I follow the instructions in the manual (starting on 
page 96), but I get an error after the command safe_mysqld --user=mysql .  The 
following is output to the scrreen:

 [1] 1299
 [root@localhost bin]# Starting mysql daemon with databases from /var/lib/mysql
 010309 14:01:27  mysql ended

 [1]+Done  safe_mysqld --user=mysql

 Any ideas?

 Thank you in advance.

 Randall Paulk
 IIS, SEC Specialist
 Universal Computer Systems
 Houston, TX 77040
 713-718-1800 Ext. 2126


-- 
Charles L. Hagen
Engineer
Hagen IT
920-261-8499


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Installation problem.

2001-01-12 Thread Miguel Angel Solórzano

At 09:08 12/01/2001 -0500, Jenny Lie wrote:
Hi!

I did reboot the machine and it still can't do mysqld-nt --install.

Anything I should do?  The first step, I did run setup.exe, then in
c:\mysql\bin, I ran mysqld-nt --install, was that right?
That is correct. What is your OS ?

Regards,
Miguel


Thanks for your time.



Jenny Lie
Web Developer
Onramp Network Services Inc.
200 Town Centre Blvd, #302
Markham, ON L3R 8G5
(905) 470-4064 EXT 241
E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http://www.onramp.ca




-Original Message-
From: Miguel Angel Solrzano [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 10:24 PM
To: Jenny Lie; [EMAIL PROTECTED]
Subject: Re: Installation problem.


At 16:19 11/01/2001 -0500, Jenny Lie wrote:
Hi!

That isn't a bug. This message is launched when:

- The service is already installed.

- The Service Control Manager is in bad state.

When you see this error message, reboot the machine.
Take a look if the service was started.
Take a look if the service exists.
If exist and doesn't was started, remove it: mysqld-nt --remove
Install the service: mysqld-nt --install.
Start the service: net start mysql

Regards,
Miguel






 Hi, I got a problem when I did this:
 
 msqld-nt --install
 
 it gave me an error message:
 Failed to install service.
 
 What's the problem exactly?
 
 Thanks for you time and help.
 
 
 
 Jenny Lie
 Web Developer
 Onramp Network Services Inc.
 200 Town Centre Blvd, #302
 Markham, ON L3R 8G5
 (905) 470-4064 EXT 241
 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 http://www.onramp.ca
 
 
 
 
 -
 Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail bugs-unsubscribe-#L=#[EMAIL PROTECTED]

 __  ___   __
/  |/  /_ __/ __/ __ \/ /   http://www.mysql.com/
   / /|_/ / // /\ \/ /_/ / /__  Miguel Solrzano [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/  So Paulo, Brazil
 ___/  Development Team



-
Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail 
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

__  ___   __
   /  |/  /_ __/ __/ __ \/ /   http://www.mysql.com/
  / /|_/ / // /\ \/ /_/ / /__  Miguel Solrzano [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/  So Paulo, Brazil
___/  Development Team


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Installation problem.

2001-01-12 Thread Miguel Angel Solórzano

At 09:08 12/01/2001 -0500, Jenny Lie wrote:
Hi!

I forget to say you in the last mails that you need to do
the login in the NT/W2k machine as Administrator privilege
or with an user which has the privilege to install services
in the machine.

Regards,
Miguel


I did reboot the machine and it still can't do mysqld-nt --install.

Anything I should do?  The first step, I did run setup.exe, then in
c:\mysql\bin, I ran mysqld-nt --install, was that right?

Thanks for your time.



Jenny Lie
Web Developer
Onramp Network Services Inc.
200 Town Centre Blvd, #302
Markham, ON L3R 8G5
(905) 470-4064 EXT 241
E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http://www.onramp.ca




-Original Message-
From: Miguel Angel Solrzano [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 10:24 PM
To: Jenny Lie; [EMAIL PROTECTED]
Subject: Re: Installation problem.


At 16:19 11/01/2001 -0500, Jenny Lie wrote:
Hi!

That isn't a bug. This message is launched when:

- The service is already installed.

- The Service Control Manager is in bad state.

When you see this error message, reboot the machine.
Take a look if the service was started.
Take a look if the service exists.
If exist and doesn't was started, remove it: mysqld-nt --remove
Install the service: mysqld-nt --install.
Start the service: net start mysql

Regards,
Miguel






 Hi, I got a problem when I did this:
 
 msqld-nt --install
 
 it gave me an error message:
 Failed to install service.
 
 What's the problem exactly?
 
 Thanks for you time and help.
 
 
 
 Jenny Lie
 Web Developer
 Onramp Network Services Inc.
 200 Town Centre Blvd, #302
 Markham, ON L3R 8G5
 (905) 470-4064 EXT 241
 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 http://www.onramp.ca
 
 
 
 
 -
 Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail bugs-unsubscribe-#L=#[EMAIL PROTECTED]

 __  ___   __
/  |/  /_ __/ __/ __ \/ /   http://www.mysql.com/
   / /|_/ / // /\ \/ /_/ / /__  Miguel Solrzano [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/  So Paulo, Brazil
 ___/  Development Team



-
Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail 
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

__  ___   __
   /  |/  /_ __/ __/ __ \/ /   http://www.mysql.com/
  / /|_/ / // /\ \/ /_/ / /__  Miguel Solrzano [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/  So Paulo, Brazil
___/  Development Team


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Installation problem.

2001-01-12 Thread Jenny Lie

Hi, Thanks!
I did log in as Administrator.
I'm running Windows NT Server 4.0



Jenny Lie
Web Developer
Onramp Network Services Inc.
200 Town Centre Blvd, #302
Markham, ON L3R 8G5
(905) 470-4064 EXT 241
E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http://www.onramp.ca




-Original Message-
From: Miguel Angel Solrzano [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 2:31 PM
To: Jenny Lie; Miguel Angel Solrzano
Cc: MySql Mailing List
Subject: RE: Installation problem.


At 09:08 12/01/2001 -0500, Jenny Lie wrote:
Hi!

I forget to say you in the last mails that you need to do
the login in the NT/W2k machine as Administrator privilege
or with an user which has the privilege to install services
in the machine.

Regards,
Miguel


I did reboot the machine and it still can't do mysqld-nt --install.

Anything I should do?  The first step, I did run setup.exe, then in
c:\mysql\bin, I ran mysqld-nt --install, was that right?

Thanks for your time.



Jenny Lie
Web Developer
Onramp Network Services Inc.
200 Town Centre Blvd, #302
Markham, ON L3R 8G5
(905) 470-4064 EXT 241
E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http://www.onramp.ca




-Original Message-
From: Miguel Angel Solrzano [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 10:24 PM
To: Jenny Lie; [EMAIL PROTECTED]
Subject: Re: Installation problem.


At 16:19 11/01/2001 -0500, Jenny Lie wrote:
Hi!

That isn't a bug. This message is launched when:

- The service is already installed.

- The Service Control Manager is in bad state.

When you see this error message, reboot the machine.
Take a look if the service was started.
Take a look if the service exists.
If exist and doesn't was started, remove it: mysqld-nt --remove
Install the service: mysqld-nt --install.
Start the service: net start mysql

Regards,
Miguel






 Hi, I got a problem when I did this:
 
 msqld-nt --install
 
 it gave me an error message:
 Failed to install service.
 
 What's the problem exactly?
 
 Thanks for you time and help.
 
 
 
 Jenny Lie
 Web Developer
 Onramp Network Services Inc.
 200 Town Centre Blvd, #302
 Markham, ON L3R 8G5
 (905) 470-4064 EXT 241
 E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 http://www.onramp.ca
 
 
 
 
 -
 Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail bugs-unsubscribe-#L=#[EMAIL PROTECTED]

 __  ___   __
/  |/  /_ __/ __/ __ \/ /   http://www.mysql.com/
   / /|_/ / // /\ \/ /_/ / /__  Miguel Solrzano [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/  So Paulo, Brazil
 ___/  Development Team



-
Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

__  ___   __
   /  |/  /_ __/ __/ __ \/ /   http://www.mysql.com/
  / /|_/ / // /\ \/ /_/ / /__  Miguel Solrzano [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/  So Paulo, Brazil
___/  Development Team


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php