Install problem on MySQL Enterprise Monitor on linux

[Bheemsen Aitha]

I tried to install the mysql monitor, but stumbled on some problems.


Here is what I did.

1. Installed a second instance of mysql server on one of our servers into a
different folder rather than into the regular folder because there is
already another instance of mysql server running on the same server.
2. created the user service_manager user with a password.
3. The new instance runs on different socket, different port, different pid
file and different binaries.
4. Now I switched to the regular env. and installed myql monitor.
5. Install had one error which is below.

Setup has completed installing the MySQL Enterprise Monitor files on your
computer (errors were found during the installation process).

No other error and no log files are created.
6. Started the mysql monitor. Here is what I found.

$ ./mysqlmonitorctl.sh status
MySQL Enterprise MySQL is not running
MySQL Enterprise Tomcat is not running
$ ./mysqlmonitorctl.sh start
Using CATALINA_BASE:   /opt/app/mysql_mon/ent_mon/apache-tomcat
Using CATALINA_HOME:   /opt/app/mysql_mon/ent_mon/apache-tomcat
Using CATALINA_TMPDIR: /opt/app/mysql_mon/ent_mon/apache-tomcat/temp
Using JRE_HOME:/opt/app/mysql_mon/ent_mon/java

$ ./mysqlmonitorctl.sh status
MySQL Enterprise MySQL is not running
MySQL Enterprise Tomcat is running
$

I believe mysql monitor is conflicting with the old instance of mysql
server.

Did anyone come across this problem? I can't use the existing mysql server
as the version is not compatible with mysql monitor requirements.

Any help is appreciated.
Thanks
BA

Re: Install problem: log file issue

[Paul DuBois]

On Feb 12, 2009, at 6:28 PM, csego...@gmail.com wrote:


Andy, Michael, and Walter - thank you!

Adding a [mysqld_safe] group to my.cnf gets me further but the start
still fails.  The good thing is that the failure is no longer due to  
the
inability to write the log file.  The [mysqld_safe] section of  
my.cnf reads:


[mysqld_safe]
port= 3306
socket  = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
datadir = /app/mysql/data
#data_file_path = /app/mysql/data
#log = /app/mysql/log/mysqld.log
log-bin = /app/mysql/log/mysql-bin.log
log-output = FILE
general_log = 1
general_log_file = /app/mysql/log/msyql_general.log
socket = /app/mysql/var/mysql.sock
log-error = /app/mysql/log/error.log

Luckily, I now have an error log which reads:

090212 18:24:04 mysqld_safe Starting mysqld daemon with databases from
/app/mysql/data
InnoDB: Log scan progressed past the checkpoint lsn 0 39548
090212 18:24:04  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the  
doublewrite

InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 46409
090212 18:24:04  InnoDB: Starting an apply batch of log records to the
database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41  
42
43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65  
66
67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89  
90

91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
090212 18:24:04  InnoDB: Started; log sequence number 0 46409
090212 18:24:04 [ERROR] /app/mysql/libexec/mysqld: Can't create/ 
write to

file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
090212 18:24:04 [ERROR] Can't start server: can't create PID file: No
such file or directory
090212 18:24:04 mysqld_safe mysqld from pid file
/var/run/mysqld/mysqld.pid ended

Now I need to figure out how to point PID file creation the  
appropriate

directory.



Sounds like you want:

pid-file = /app/mysql/log/mysql.pid

http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_pid-file

--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Install problem: log file issue

[csego...@gmail.com]

Andy, Michael, and Walter - thank you!

Adding a [mysqld_safe] group to my.cnf gets me further but the start
still fails.  The good thing is that the failure is no longer due to the
inability to write the log file.  The [mysqld_safe] section of my.cnf reads:

[mysqld_safe]
port= 3306
socket  = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
datadir = /app/mysql/data
#data_file_path = /app/mysql/data
#log = /app/mysql/log/mysqld.log
log-bin = /app/mysql/log/mysql-bin.log
log-output = FILE
general_log = 1
general_log_file = /app/mysql/log/msyql_general.log
socket = /app/mysql/var/mysql.sock
log-error = /app/mysql/log/error.log

Luckily, I now have an error log which reads:

090212 18:24:04 mysqld_safe Starting mysqld daemon with databases from
/app/mysql/data
InnoDB: Log scan progressed past the checkpoint lsn 0 39548
090212 18:24:04  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 46409
090212 18:24:04  InnoDB: Starting an apply batch of log records to the
database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90
91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
090212 18:24:04  InnoDB: Started; log sequence number 0 46409
090212 18:24:04 [ERROR] /app/mysql/libexec/mysqld: Can't create/write to
file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
090212 18:24:04 [ERROR] Can't start server: can't create PID file: No
such file or directory
090212 18:24:04 mysqld_safe mysqld from pid file
/var/run/mysqld/mysqld.pid ended

Now I need to figure out how to point PID file creation the appropriate
directory.

C


Walter Heck wrote:
> I haven't looked into it in detail an don't have time right nw, but it
> is also hardcoded in mysqld_safe. I have seen a case where it had to
> be changed there to make it work. try that and please report back :)
>
> Walter
>
> OlinData: Professional services for MySQL
> Support * Consulting * Administration
> http://www.olindata.com
>
>
>
> On Thu, Feb 12, 2009 at 6:39 PM, csego...@gmail.com  
> wrote:
>   
>> Andy,
>>
>> Thanks for the suggestion.  my_print_defaults mysqld indicates that it
>> is reading my my.cnf.  Furthermore, I have tried both the log and
>> log-output variables in my.cnf with no success.  Any other ideas?
>>
>> Thanks!
>> C
>>
>>
>>
>>
>> Andy Smith wrote:
>> 
>>> It could be that your my.cnf isn't being read (permissions or in the
>>> wrong directory), or that you have multiple my.cnf files.
>>>
>>> Quoting "csego...@gmail.com" :
>>>
>>>   
 That is intentional.  I want to write the log to a non-standard
 location.

 
>>> 
>>> This message was sent using IMP, the Internet Messaging Program.
>>>
>>>   
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:http://lists.mysql.com/mysql?unsub=li...@olindata.com
>>
>>
>> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Install problem: log file issue

[Walter Heck]

I haven't looked into it in detail an don't have time right nw, but it
is also hardcoded in mysqld_safe. I have seen a case where it had to
be changed there to make it work. try that and please report back :)

Walter

OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com



On Thu, Feb 12, 2009 at 6:39 PM, csego...@gmail.com  wrote:
> Andy,
>
> Thanks for the suggestion.  my_print_defaults mysqld indicates that it
> is reading my my.cnf.  Furthermore, I have tried both the log and
> log-output variables in my.cnf with no success.  Any other ideas?
>
> Thanks!
> C
>
>
>
>
> Andy Smith wrote:
>> It could be that your my.cnf isn't being read (permissions or in the
>> wrong directory), or that you have multiple my.cnf files.
>>
>> Quoting "csego...@gmail.com" :
>>
>>> That is intentional.  I want to write the log to a non-standard
>>> location.
>>>
>>
>> 
>> This message was sent using IMP, the Internet Messaging Program.
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=li...@olindata.com
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Install problem: log file issue

[csego...@gmail.com]

Andy,

Thanks for the suggestion.  my_print_defaults mysqld indicates that it
is reading my my.cnf.  Furthermore, I have tried both the log and
log-output variables in my.cnf with no success.  Any other ideas?

Thanks!
C




Andy Smith wrote:
> It could be that your my.cnf isn't being read (permissions or in the
> wrong directory), or that you have multiple my.cnf files.
>
> Quoting "csego...@gmail.com" :
>
>> That is intentional.  I want to write the log to a non-standard
>> location.
>>
>
> 
> This message was sent using IMP, the Internet Messaging Program.
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Install problem: log file issue

[Andy Smith]

It could be that your my.cnf isn't being read (permissions or in the  
wrong directory), or that you have multiple my.cnf files.


Quoting "csego...@gmail.com" :


That is intentional.  I want to write the log to a non-standard location.




This message was sent using IMP, the Internet Messaging Program.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Install problem: log file issue

[csego...@gmail.com]

That is intentional.  I want to write the log to a non-standard location.

Thanks!
C


fire9 wrote:
> Colin,
> hi, so I think your mysql account doesn't have access /var/log/
> directory Permission.
>
>
> Yours,
> fire9
> ÔÚ 2009-2-13£¬ÉÏÎç1:02£¬ csego...@gmail.com
>  дµÀ£º
>
>> In the process of installing MySQL 5.1.31, I receive the following error
>> when I attempt to start mysqld_safe:
>>
>> 090212 10:57:40 mysqld_safe Logging to '/var/log/mysqld.log'.
>> 090212 10:57:40 mysqld_safe Starting mysqld daemon with databases from
>> /app/mysql/data
>> /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission
>> denied
>> /app/mysql/bin/mysqld_safe: line 133: /var/log/mysqld.log: Permission
>> denied
>> 090212 10:57:40 mysqld_safe mysqld from pid file
>> /var/run/mysqld/mysqld.pid ended
>> /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission
>> denied
>>
>>
>> My my.cnf file reads:
>>
>> # The MySQL server
>> [mysqld]
>> port= 3306
>> socket  = /tmp/mysql.sock
>> skip-locking
>> key_buffer = 16M
>> max_allowed_packet = 1M
>> table_cache = 64
>> sort_buffer_size = 512K
>> net_buffer_length = 8K
>> read_buffer_size = 256K
>> read_rnd_buffer_size = 512K
>> myisam_sort_buffer_size = 8M
>> datadir = /app/mysql/data
>> #data_file_path = /app/mysql/data
>> general_log = 1
>> general_log_file = /app/mysql/log/
>> socket = /app/mysql/var/mysql.sock
>> log-error = /app/mysql/log/error.log
>>
>> I thought the general_log_file variable would define the location of the
>> log file, yet mysqld is trying to write the log file to a different
>> directory.  Does anyone have any suggestions on how to fix this?
>>
>> Thanks!
>> Colin
>>
>> -- 
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>>http://lists.mysql.com/mysql?unsub=fire9di...@gmail.com
>>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Install problem: log file issue

[fire9]

Colin,
hi, so I think your mysql account doesn't have access /var/log/  
directory Permission.



Yours,
fire9
在 2009-2-13，上午1:02， csego...@gmail.com 写道：

In the process of installing MySQL 5.1.31, I receive the following  
error

when I attempt to start mysqld_safe:

090212 10:57:40 mysqld_safe Logging to '/var/log/mysqld.log'.
090212 10:57:40 mysqld_safe Starting mysqld daemon with databases from
/app/mysql/data
/app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission  
denied
/app/mysql/bin/mysqld_safe: line 133: /var/log/mysqld.log:  
Permission denied

090212 10:57:40 mysqld_safe mysqld from pid file
/var/run/mysqld/mysqld.pid ended
/app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission  
denied



My my.cnf file reads:

# The MySQL server
[mysqld]
port= 3306
socket  = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
datadir = /app/mysql/data
#data_file_path = /app/mysql/data
general_log = 1
general_log_file = /app/mysql/log/
socket = /app/mysql/var/mysql.sock
log-error = /app/mysql/log/error.log

I thought the general_log_file variable would define the location of  
the

log file, yet mysqld is trying to write the log file to a different
directory.  Does anyone have any suggestions on how to fix this?

Thanks!
Colin

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=fire9di...@gmail.com

Install problem: log file issue

[csego...@gmail.com]

In the process of installing MySQL 5.1.31, I receive the following error
when I attempt to start mysqld_safe:

090212 10:57:40 mysqld_safe Logging to '/var/log/mysqld.log'.
090212 10:57:40 mysqld_safe Starting mysqld daemon with databases from
/app/mysql/data
/app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied
/app/mysql/bin/mysqld_safe: line 133: /var/log/mysqld.log: Permission denied
090212 10:57:40 mysqld_safe mysqld from pid file
/var/run/mysqld/mysqld.pid ended
/app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied


My my.cnf file reads:

# The MySQL server
[mysqld]
port= 3306
socket  = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
datadir = /app/mysql/data
#data_file_path = /app/mysql/data
general_log = 1
general_log_file = /app/mysql/log/
socket = /app/mysql/var/mysql.sock
log-error = /app/mysql/log/error.log

I thought the general_log_file variable would define the location of the
log file, yet mysqld is trying to write the log file to a different
directory.  Does anyone have any suggestions on how to fix this?

Thanks!
Colin

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Install problem: configure --prefix not working

[Walter Heck]

/var/lib/mysql is the standard loation for the data_file_path, the
data directory. change it in my.cnf.

var/log is the default location for log files, also changeable in the
config file.

Walter

OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com



On Wed, Feb 11, 2009 at 5:35 PM, csego...@gmail.com  wrote:
> I am trying to install mysql in a non-standard directory - specifically
> /app/mysql
>
> Subsequently, I ran the following configure command:
>
> ./configure --prefix=/app/mysql --with-plugins=innobase,myisam
>
> There were no problems with the compile, but mysql failed to start.
> Furthermore, the following output was produced in the nohup.out file
>
> -bash-3.2$ cat nohup.out
> 090211 09:40:35 mysqld_safe Logging to '/var/log/mysqld.log'.
> mkdir: cannot create directory `/var/lib/mysql': Permission denied
> chown: cannot access `/var/lib/mysql': No such file or directory
> chmod: cannot access `/var/lib/mysql': No such file or directory
> 090211 09:40:35 mysqld_safe Starting mysqld daemon with databases from
> /var/lib/mysql
> /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied
> /app/mysql/bin/mysqld_safe: line 133: /var/log/mysqld.log: Permission denied
> 090211 09:40:35 mysqld_safe mysqld from pid file
> /var/run/mysqld/mysqld.pid ended
> /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied
>
> For some reason, the mysql install is looking to /var even though I
> specificied /app/mysql in the compile.
>
> How do I fix this?
>
> Thanks!
> Colin
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=li...@olindata.com
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Install problem: configure --prefix not working

[csego...@gmail.com]

I am trying to install mysql in a non-standard directory - specifically
/app/mysql

Subsequently, I ran the following configure command:

./configure --prefix=/app/mysql --with-plugins=innobase,myisam

There were no problems with the compile, but mysql failed to start.
Furthermore, the following output was produced in the nohup.out file

-bash-3.2$ cat nohup.out
090211 09:40:35 mysqld_safe Logging to '/var/log/mysqld.log'.
mkdir: cannot create directory `/var/lib/mysql': Permission denied
chown: cannot access `/var/lib/mysql': No such file or directory
chmod: cannot access `/var/lib/mysql': No such file or directory
090211 09:40:35 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
/app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied
/app/mysql/bin/mysqld_safe: line 133: /var/log/mysqld.log: Permission denied
090211 09:40:35 mysqld_safe mysqld from pid file
/var/run/mysqld/mysqld.pid ended
/app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied

For some reason, the mysql install is looking to /var even though I
specificied /app/mysql in the compile.

How do I fix this?

Thanks!
Colin

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL 5.0.22 install problem with NetBSD

[Abdullah Ibn Hamad Al-Marri]

I guess MySQL should make binary for NetBSD too.

- Original Message 
From: Clay R White <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Sunday, July 30, 2006 2:01:58 AM
Subject: MySQL 5.0.22 install problem with NetBSD

From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: MySQL 5.0.22 install problems with NetBSD

>Description:
Started the install (new install). Reached the step:
"scripts/mysql_install_db --user=mysql".
Recieved the following errors:
scripts/mysql_install_db: line 86: ./bin/my_print_defaults: cannot execute
binary file
Neither host 'roswell.lazyrockinw.com' nor 'localhost' could be looked up
with
./bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option

I then tried to run ./bin/resolveip localhost received  

-bash:./bin/resolveip: cannot execute binary file

file is currently set as: -rwxr-xr-x  1 root  wheel  1144116 May 26 13:24
bin/resolveip

The distribution was mysql-standard-5.0.22-freebsd6.0-i386.tar.gz although
I've also tried the openbsd distribution. 
I followed the instructions in the INSTALL_BINARY file, both distributions
failed with identical errors on the same script.

>How-To-Repeat:

 Repeated whenerver I attempted to run scripts/mysql_install_db

>Fix:
I did notice in the support pages that this was a known bug back in one of
the 4.X distributions. I could
not find where there was a fix, patch or workaround. 

>Submitter-Id:  
>Originator:Clay White
>Organization:
 C&J Enterprises
Bertram, TX 78605
>MySQL support: none
>Synopsis:  Unable to install MySQL on NetBSD due to unknown
installation script errors
>Severity:  serious
>Priority:  medium 
>Release:   mysql-5.0.22-standard (MySQL Community Edition - Standard
(GPL))

>C compiler:gcc (GCC) 3.4.4 [FreeBSD] 20050518
>C++ compiler:  gcc (GCC) 3.4.4 [FreeBSD] 20050518
>Environment:

System: NetBSD roswell.lazyrockinw.com 3.99.20 NetBSD 3.99.20 (piggy) 
#2: Mon Jun 12 22:59:37 CDT 2006
[EMAIL PROTECTED]:/stuff/src_current/sys/arch/i386
/compile/obj/piggy i386


Some paths:  /usr/pkg/bin/perl /usr/bin/make /usr/pkg/bin/gmake /usr/bin/gcc
/us
r/bin/cc
GCC: Using built-in specs.
>C compiler:gcc (GCC) 3.4.4 [FreeBSD] 20050518
>C++ compiler:  gcc (GCC) 3.4.4 [FreeBSD] 20050518
>Environment:

System: NetBSD roswell.lazyrockinw.com 3.99.20 NetBSD 3.99.20 (piggy) #2:
Mon Ju
n 12 22:59:37 CDT 2006
[EMAIL PROTECTED]:/stuff/src_current/sys/arch/i386
/compile/obj/piggy i386


Some paths:  /usr/pkg/bin/perl /usr/bin/make /usr/pkg/bin/gmake /usr/bin/gcc
/us
r/bin/cc
GCC: Using built-in specs.
Configured with:
/home/nick/work/netbsd/src/tools/gcc/../../gnu/dist/gcc/configu
re --enable-long-long --disable-multilib --enable-threads --disable-symvers
--bu
ild=i386-unknown-netbsdelf2.0. --host=i386--netbsdelf
--target=i386--netbsdelf
Thread model: posix
gcc version 3.3.3 (NetBSD nb3 20040520)
Compilation info: CC='ccache gcc'  CFLAGS=''  CXX='ccache gcc'  CXXFLAGS=''
LDF
LAGS=''  ASFLAGS=''
LIBC:
lrwxr-xr-x  1 root  wheel  16 Jun 13 01:15 /lib/libc.so -> libc.so.12.128.2
lrwxr-xr-x  1 root  wheel  16 Jun 13 01:15 /lib/libc.so.12 ->
libc.so.12.128.2
-r--r--r--  1 root  wheel  881693 Jun 13 01:15 /lib/libc.so.12.128.2
lrwxr-xr-x  1 root  wheel  16 Jun 13 01:15 /lib/libc.so -> libc.so.12.128.2
lrwxr-xr-x  1 root  wheel  16 Jun 13 01:15 /lib/libc.so.12 ->
libc.so.12.128.2
-r--r--r--  1 root  wheel  881693 Jun 13 01:15 /lib/libc.so.12.128.2
-r--r--r--  1 root  wheel  1702186 Jun 13 01:15 /usr/lib/libc.a
lrwxr-xr-x  1 root  wheel  21 Jun 13 01:15 /usr/lib/libc.so ->
/lib/libc.so.12.1
28.2
lrwxr-xr-x  1 root  wheel  21 Jun 13 01:15 /usr/lib/libc.so.12 ->
/lib/libc.so.1
2.128.2
lrwxr-xr-x  1 root  wheel  21 Jun 13 01:15 /usr/lib/libc.so.12.128.2 ->
/lib/lib
c.so.12.128.2

Configure command: ./configure '--prefix=/usr/local/mysql'
'--localstatedir=/usr
/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL
Com
munity Edition - Standard (GPL)' '--with-server-suffix=-standard'
'--enable-thre
ad-safe-client' '--enable-local-infile' '--enable-assembler' '--with-pic'
'--dis
able-shared' '--with-zlib-dir=bundled' '--with-big-tables' '--with-yassl'
'--wit
h-readline' '--with-archive-storage-engine' '--with-innodb'
'--with-extra-charse
ts=complex' 'CC=ccache gcc' 'CXX=ccache gcc'  

MySQL 5.0.22 install problem with NetBSD

[Clay R White]

From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: MySQL 5.0.22 install problems with NetBSD

>Description:
Started the install (new install). Reached the step:
"scripts/mysql_install_db --user=mysql".
Recieved the following errors:
scripts/mysql_install_db: line 86: ./bin/my_print_defaults: cannot execute
binary file
Neither host 'roswell.lazyrockinw.com' nor 'localhost' could be looked up
with
./bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option

I then tried to run ./bin/resolveip localhost received  

-bash:./bin/resolveip: cannot execute binary file

file is currently set as: -rwxr-xr-x  1 root  wheel  1144116 May 26 13:24
bin/resolveip

The distribution was mysql-standard-5.0.22-freebsd6.0-i386.tar.gz although
I've also tried the openbsd distribution. 
I followed the instructions in the INSTALL_BINARY file, both distributions
failed with identical errors on the same script.

>How-To-Repeat:

 Repeated whenerver I attempted to run scripts/mysql_install_db

>Fix:
I did notice in the support pages that this was a known bug back in one of
the 4.X distributions. I could
not find where there was a fix, patch or workaround. 

>Submitter-Id:  
>Originator:Clay White
>Organization:
 C&J Enterprises
Bertram, TX 78605
>MySQL support: none
>Synopsis:  Unable to install MySQL on NetBSD due to unknown
installation script errors
>Severity:  serious
>Priority:  medium 
>Release:   mysql-5.0.22-standard (MySQL Community Edition - Standard
(GPL))

>C compiler:gcc (GCC) 3.4.4 [FreeBSD] 20050518
>C++ compiler:  gcc (GCC) 3.4.4 [FreeBSD] 20050518
>Environment:

System: NetBSD roswell.lazyrockinw.com 3.99.20 NetBSD 3.99.20 (piggy) 
#2: Mon Jun 12 22:59:37 CDT 2006
[EMAIL PROTECTED]:/stuff/src_current/sys/arch/i386
/compile/obj/piggy i386


Some paths:  /usr/pkg/bin/perl /usr/bin/make /usr/pkg/bin/gmake /usr/bin/gcc
/us
r/bin/cc
GCC: Using built-in specs.
>C compiler:gcc (GCC) 3.4.4 [FreeBSD] 20050518
>C++ compiler:  gcc (GCC) 3.4.4 [FreeBSD] 20050518
>Environment:

System: NetBSD roswell.lazyrockinw.com 3.99.20 NetBSD 3.99.20 (piggy) #2:
Mon Ju
n 12 22:59:37 CDT 2006
[EMAIL PROTECTED]:/stuff/src_current/sys/arch/i386
/compile/obj/piggy i386


Some paths:  /usr/pkg/bin/perl /usr/bin/make /usr/pkg/bin/gmake /usr/bin/gcc
/us
r/bin/cc
GCC: Using built-in specs.
Configured with:
/home/nick/work/netbsd/src/tools/gcc/../../gnu/dist/gcc/configu
re --enable-long-long --disable-multilib --enable-threads --disable-symvers
--bu
ild=i386-unknown-netbsdelf2.0. --host=i386--netbsdelf
--target=i386--netbsdelf
Thread model: posix
gcc version 3.3.3 (NetBSD nb3 20040520)
Compilation info: CC='ccache gcc'  CFLAGS=''  CXX='ccache gcc'  CXXFLAGS=''
LDF
LAGS=''  ASFLAGS=''
LIBC:
lrwxr-xr-x  1 root  wheel  16 Jun 13 01:15 /lib/libc.so -> libc.so.12.128.2
lrwxr-xr-x  1 root  wheel  16 Jun 13 01:15 /lib/libc.so.12 ->
libc.so.12.128.2
-r--r--r--  1 root  wheel  881693 Jun 13 01:15 /lib/libc.so.12.128.2
lrwxr-xr-x  1 root  wheel  16 Jun 13 01:15 /lib/libc.so -> libc.so.12.128.2
lrwxr-xr-x  1 root  wheel  16 Jun 13 01:15 /lib/libc.so.12 ->
libc.so.12.128.2
-r--r--r--  1 root  wheel  881693 Jun 13 01:15 /lib/libc.so.12.128.2
-r--r--r--  1 root  wheel  1702186 Jun 13 01:15 /usr/lib/libc.a
lrwxr-xr-x  1 root  wheel  21 Jun 13 01:15 /usr/lib/libc.so ->
/lib/libc.so.12.1
28.2
lrwxr-xr-x  1 root  wheel  21 Jun 13 01:15 /usr/lib/libc.so.12 ->
/lib/libc.so.1
2.128.2
lrwxr-xr-x  1 root  wheel  21 Jun 13 01:15 /usr/lib/libc.so.12.128.2 ->
/lib/lib
c.so.12.128.2

Configure command: ./configure '--prefix=/usr/local/mysql'
'--localstatedir=/usr
/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL
Com
munity Edition - Standard (GPL)' '--with-server-suffix=-standard'
'--enable-thre
ad-safe-client' '--enable-local-infile' '--enable-assembler' '--with-pic'
'--dis
able-shared' '--with-zlib-dir=bundled' '--with-big-tables' '--with-yassl'
'--wit
h-readline' '--with-archive-storage-engine' '--with-innodb'
'--with-extra-charse
ts=complex' 'CC=ccache gcc' 'CXX=ccache gcc'  

Re: MySQL 4.1 Win 2003 server install problem

[Ashok Kumar]

hi,
 if u'r uninstalled the mysql and try to reinstalling
means, try the following.
 1.Delete all the corresponding files that are created
by the prev installation after the uninstallation.
 2.Install the MySQL again. Now it'll work.

 This is due to some configuration prob between the
prev and new installation.

 Try it, all the best.

Thanks and Regards,
 Ashok.

--- Carlos J Souza <[EMAIL PROTECTED]> wrote:

> 
> Dear Friends,
> 
> Iam trying to install MySQL 4.1.2 in Windows 2003
> Server, and on error occurs when installation try a
> start de service. The service does not start and
> installation don't finish.
> 
> I Need a help about it.
> 
> 
> Regards for all.
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
>
http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

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

MySQL 4.1 Win 2003 server install problem

[Carlos J Souza]

Dear Friends,

Iam trying to install MySQL 4.1.2 in Windows 2003 Server, and on error occurs 
when installation try a start de service. The service does not start and 
installation don't finish.

I Need a help about it.


Regards for all.


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

anyone know any AIX experts for install problem.

[Damian McMenamin]

after gunzipping and untarring i get to point
in instructions to run script mysql_install_db

i get the following error:


# scripts/mysql_install_db
exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of
the foll
owing errors:
Symbol resolution failed for my_print_defaults because:
Symbol stpcpy (number 52) is not exported from dependent
  module /usr/lib/libc.a(shr.o).
Symbol isinf (number 53) is not exported from dependent
  module /usr/lib/libc.a(shr.o).
Examine .loader section symbols with the 'dump -Tv' command.
Neither host '?' nor 'localhost' could be looked up with
./bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option
# 

in need of hand holding, first timeer on mysql.




heres the mysqlbug output.

>Submitter-Id:  
>Originator:
>Organization:
 
>MySQL support: [none | licence | email support | extended email
support ]
>Synopsis:  
>Severity:  <[ non-critical | serious | critical ] (one line)>
>Priority:  <[ low | medium | high ] (one line)>
>Category:  mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one
line)>
>Release:   mysql-4.1.11-standard (MySQL Community Edition -
Standard (GPL))
>C compiler:  VisualAge C++ Professional / C for AIX Compiler,
Version 6
>C++ compiler:VisualAge C++ Professional / C for AIX Compiler,
Version 6
>Environment:

System: AIX concord1 3 4 000C55BD4C00


Some paths:  /usr/bin/make

Compilation info: CC='xlc_r'  CFLAGS='-ma -O2 -qstrict -qoptimize=2
-qmaxmem=819
2'  CXX='xlC_r'  CXXFLAGS='-ma -O2 -qstrict -qoptimize=2 -qmaxmem=8192'
 LDFLAGS
=''  ASFLAGS=''
LIBC: 
lrwxrwxrwx   1 bin  bin   19 Sep 07 2004  /lib/libc.a ->
/usr/ccs/li
b/libc.a
lrwxrwxrwx   1 bin  bin   19 Sep 07 2004  /usr/lib/libc.a
-> /usr/cc
s/lib/libc.a
Configure command: ./configure '--prefix=/usr/local/mysql'
'--localstatedir=/usr
/local/mysql/data' '--libexecdir=/usr/local/mysql/bin'
'--with-comment=MySQL Com
munity Edition - Standard (GPL)' '--with-extra-charsets=complex'
'--with-server-
suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile'
'--with-
named-z-libs=no' '--disable-shared' '--with-readline'
'--with-embedded-server' '
--with-archive-storage-engine' '--with-innodb' 'CC=xlc_r' 'CFLAGS=-ma
-O2 -qstri
ct -qoptimize=2 -qmaxmem=8192' 'CXXFLAGS=-ma -O2 -qstrict -qoptimize=2
-qmaxmem=
8192' 'CXX=xlC_r'

# 
# 

Yours Sincerely,
Damian McMenamin
Analyst Programmer
Melbourne 
Australia
Cell: (61)040-0064107
Email: [EMAIL PROTECTED]

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

Re: Install Problem on Fedora Core 2 w/ ver 4.0.21

[Jigal van Hemert]

From: "Dennis Skinner" <[EMAIL PROTECTED]>
> http://lists.mysql.com/mysql/168700

 I've been searching through the 15502 messages from this
list that I have archived since Jan 16, 2004 but I must've missed this
one...

Thanks for looking it up!

Regards, Jigal.


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

Re: Install Problem on Fedora Core 2 w/ ver 4.0.21

[Egor Egorov]

"Jigal van Hemert" <[EMAIL PROTECTED]> wrote:

>> > 040925 21:50:34 Warning: Asked for 196608 thread stack, but got 126976
>> Databases are installed. You can ignore the above warning.
> 
> Egor,
> 
> 1) A warning usually indicates an error that has limited impact on the
> system, but still an error!

Well, not always and not in this case. This warning is shown in logs by default
since .19 or .20 afair; but it existed in earlier versions, just not being
shown. 

> 2) Can you explain this warning and what to do to solve (and not supress)
> it? This issue shows up very regularly on this list and nobody here seems to
> have a clue what causes it...

Because it's a minor warning with a recomendation to ignore it. :) 

Your question forwarded to developers. I will publish an answer here. 





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




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

Install Problem on Fedora Core 2 w/ ver 4.0.21

[Kevin_karigna]

I was attempting to install mysql ver. 4.0.21 when I encountered a 
premature ending to the install as shown here:

[EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user=mysql
Installing all prepared tables
040925 21:50:34 Warning: Asked for 196608 thread stack, but got 126976
040925 21:50:34 ./bin/mysqld: Shutdown Complete
Is this permissions related? I hope this is enough information to 
pinpoint the issue, if not  let me know.

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

FW: MySQL install problem on RH 3.0 IA64

[Sagar, Sanjeev]

Small correction :

"Kernel 2.4.21-9.ELsmp on an x86_64" is not valid in this case. It came form
another machine.

Real kernel version is 

Linux pinhpe02 2.4.21-9.EL #1 SMP Thu Jan 8 16:54:40 EST 2004 ia64 ia64 ia64
GNU/Linux

MySQL:

mysql-pro-4.0.18-unknown-linux-ia64

Problem Description:

/usr/local/mysql> ./scripts/mysql_install_db --user=hybmysql


WARNING: The host 'pinhpe02' could not be looked up with resolveip.

This probably means that your libc libraries are not 100 % compatible

with this binary MySQL version. The MySQL daemon, mysqld, should work

normally with the exception that host name resolving will not work.

This means that you should use IP addresses instead of hostnames

when specifying MySQL privileges !

Preparing db table

Preparing host table

Preparing user table

Preparing func table

Preparing tables_priv table

Preparing columns_priv table

Installing all prepared tables

mysqld got signal 11;

This could be because you hit a bug. It is also possible that this binary

or one of the libraries it was linked against is corrupt, improperly built,

or misconfigured. This error can also be caused by malfunctioning hardware.

We will try our best to scrape up some info that will hopefully help
diagnose 
the problem, but since we have already crashed, something is definitely
wrong 
and this may fail.

 

key_buffer_size=8388600

read_buffer_size=131072

max_used_connections=0

max_connections=100

threads_connected=0

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
225791 K
bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

 

Installation of grant tables failed!

 

Examine the logs in ./data for more information.

You can also try to start the mysqld daemon with:

./bin/mysqld --skip-grant &

You can use the command line tool

./bin/mysql to connect to the mysql

database and look at the grant tables:

 

shell> ./bin/mysql -u root mysql

mysql> show tables

 

Try 'mysqld --help' if you have problems with paths. Using --log

gives you a log in ./data that may be helpful.

 

The latest information about MySQL is available on the web at

http://www.mysql.com 

Please consult the MySQL manual section: 'Problems running
mysql_install_db', 
and the manual section that describes problems on your OS.

Another information source is the MySQL email archive.

Please check all of the above before mailing us!

And if you do mail us, you MUST use the ./bin/mysqlbug script!


As you can see grant table installation failed.

Following is the output from ./bin/mysqlbug

SEND-PR: -*- send-pr -*-

SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as

SEND-PR: will all comments (text enclosed in `<' and `>').

SEND-PR:

From: hybmysql

To: [EMAIL PROTECTED]

Subject: [50 character or so descriptive subject here (for reference)]

 

>Description:



>How-To-Repeat:



>Fix:



 

>Submitter-Id:  

>Originator:

>Organization:

 

>MySQL support: [none | licence | email support | extended email support 
>]

>Synopsis:  

>Severity:  <[ non-critical | serious | critical ] (one line)>

>Priority:  <[ low | medium | high ] (one line)>

>Category:  mysql

>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>

>Release:   mysql-4.0.18-pro (Official MySQL-pro binary)

 

>C compiler:

>C++ compiler:

>Environment:



System: Linux pinhpe02 2.4.21-9.EL #1 SMP Thu Jan 8 16:54:40 EST 2004 ia64
ia64 ia64 GNU/Linux
Architecture: ia64

 

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc

GCC: Reading specs from /usr/lib/gcc-lib/ia64-redhat-linux/3.2.3/specs

Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix
--disable-checkin g --with-system-zlib --enable-__cxa_atexit
--host=ia64-redhat-linux

Thread model: posix

gcc version 3.2.3 20030502 (Red Hat Linux 3.2.3-24)

Compilation info: CC='ecc'  CFLAGS='-O2 -tpp2 -ip -nolib_inline'  CXX='ecc'
CXXFLAGS='-O2 -tpp2 -ip -nolib_inline'  LDFLAGS=''  ASFLAGS=''   
LIBC:

lrwxrwxrwx1 root root   13 Mar 26 04:44 /lib/libc.so.6.1 ->
libc-2.3.2.so 
-rwxr-xr-x1 root root  2898136 Nov  7 12:45 /lib/libc-2.3.2.so

-rw-r--r--1 root root  5171628 Nov  7 12:46 /usr/lib/libc.a

-rw-r--r--1 root root  213 Nov  7 12:01 /usr/lib/libc.so

Configure command: ./configure '--prefix=/usr/local/mysql'
'--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin'
'--with-comment =Official MySQL-pro binary' '--with-extra-charsets=complex'
'--with-server-suffix=-pro' '--enable-thread-safe-client'
'--enable-local-infile' '--disab le-shared'
'--with-

MySQL install problem on RH 3.0 IA64

[Sagar, Sanjeev]

Hello Everyone,

We are already working with MySQL support on this issue but just wondering
if there are anyone using MySQL database on RH 3.0. Following is our O/S and
DB version info

O/S : 

Red Hat Enterprise Linux AS release 3 (Taroon Update 1)
Kernel 2.4.21-9.ELsmp on an x86_64
Linux pinhpe02 2.4.21-9.EL #1 SMP Thu Jan 8 16:54:40 EST 2004 ia64 ia64 ia64
GNU/Linux

MySQL:

mysql-pro-4.0.18-unknown-linux-ia64

Problem Description:

/usr/local/mysql> ./scripts/mysql_install_db --user=hybmysql


WARNING: The host 'pinhpe02' could not be looked up with resolveip.

This probably means that your libc libraries are not 100 % compatible

with this binary MySQL version. The MySQL daemon, mysqld, should work

normally with the exception that host name resolving will not work.

This means that you should use IP addresses instead of hostnames

when specifying MySQL privileges !

Preparing db table

Preparing host table

Preparing user table

Preparing func table

Preparing tables_priv table

Preparing columns_priv table

Installing all prepared tables

mysqld got signal 11;

This could be because you hit a bug. It is also possible that this binary

or one of the libraries it was linked against is corrupt, improperly built,

or misconfigured. This error can also be caused by malfunctioning hardware.

We will try our best to scrape up some info that will hopefully help
diagnose 
the problem, but since we have already crashed, something is definitely
wrong 
and this may fail.

 

key_buffer_size=8388600

read_buffer_size=131072

max_used_connections=0

max_connections=100

threads_connected=0

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
225791 K
bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

 

Installation of grant tables failed!

 

Examine the logs in ./data for more information.

You can also try to start the mysqld daemon with:

./bin/mysqld --skip-grant &

You can use the command line tool

./bin/mysql to connect to the mysql

database and look at the grant tables:

 

shell> ./bin/mysql -u root mysql

mysql> show tables

 

Try 'mysqld --help' if you have problems with paths. Using --log

gives you a log in ./data that may be helpful.

 

The latest information about MySQL is available on the web at

http://www.mysql.com 

Please consult the MySQL manual section: 'Problems running
mysql_install_db', 
and the manual section that describes problems on your OS.

Another information source is the MySQL email archive.

Please check all of the above before mailing us!

And if you do mail us, you MUST use the ./bin/mysqlbug script!


As you can see grant table installation failed.

Following is the output from ./bin/mysqlbug

SEND-PR: -*- send-pr -*-

SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as

SEND-PR: will all comments (text enclosed in `<' and `>').

SEND-PR:

From: hybmysql

To: [EMAIL PROTECTED]

Subject: [50 character or so descriptive subject here (for reference)]

 

>Description:



>How-To-Repeat:



>Fix:



 

>Submitter-Id:  

>Originator:

>Organization:

 

>MySQL support: [none | licence | email support | extended email support ]

>Synopsis:  

>Severity:  <[ non-critical | serious | critical ] (one line)>

>Priority:  <[ low | medium | high ] (one line)>

>Category:  mysql

>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>

>Release:   mysql-4.0.18-pro (Official MySQL-pro binary)

 

>C compiler:

>C++ compiler:

>Environment:



System: Linux pinhpe02 2.4.21-9.EL #1 SMP Thu Jan 8 16:54:40 EST 2004 ia64
ia64 ia64 GNU/Linux
Architecture: ia64

 

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc

GCC: Reading specs from /usr/lib/gcc-lib/ia64-redhat-linux/3.2.3/specs

Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix
--disable-checkin
g --with-system-zlib --enable-__cxa_atexit --host=ia64-redhat-linux

Thread model: posix

gcc version 3.2.3 20030502 (Red Hat Linux 3.2.3-24)

Compilation info: CC='ecc'  CFLAGS='-O2 -tpp2 -ip -nolib_inline'  CXX='ecc'
CXXFLAGS='-O2 -tpp2 -ip -nolib_inline'  LDFLAGS=''  ASFLAGS=''   
LIBC:

lrwxrwxrwx1 root root   13 Mar 26 04:44 /lib/libc.so.6.1 ->
libc-2.3.2.so 
-rwxr-xr-x1 root root  2898136 Nov  7 12:45 /lib/libc-2.3.2.so

-rw-r--r--1 root root  5171628 Nov  7 12:46 /usr/lib/libc.a

-rw-r--r--1 root root  213 Nov  7 12:01 /usr/lib/libc.so

Configure command: ./configure '--prefix=/usr/local/mysql'
'--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin'
'--with-comment =Official MySQL-pro binary'

RE: install problem

[Maria Yndefors]

Thanks for the help, changing the privileges and resetting the root
password I managed to log in.
Best Regards
/Maria Yndefors

-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] 
Sent: den 24 februari 2004 14:14
To: [EMAIL PROTECTED]
Subject: Re: install problem

"Maria Yndefors" <[EMAIL PROTECTED]> wrote:
> Hi,
> No I have not have MySql installed before and I am using version 1.4,
> but I used an my.cnf from another host with mysql 3.x
> 
> Now I can't even manage to start it I get the following in the log
file
> 
> 040224 14:39:01  mysqld started
> 040224 14:39:04  InnoDB: Started
> 040224 14:39:04  Fatal error: Can't open privilege tables: Can't find
> file: './mysql/host.frm' (errno: 13)
> 040224 14:39:04  Aborting
> 
> 040224 14:39:04  InnoDB: Starting shutdown...
> 040224 14:39:06  InnoDB: Shutdown completed
> 040224 14:39:06  /usr/sbin/mysqld-max: Shutdown Complete
> 
> 040224 14:39:07  mysqld ended

$ perror 13
Error code  13:  Permission denied

Check privileges on the data dir. MySQL should be owner of the data dir.

> After installing it the first time I did not manage to log in as root
to
> change the password.
> Is there some way to reset everything uninstall mysql and start all
over
> from the beginning again?

If you want re-create grant tables, you should remove files from
directory of the database 'mysql' and then run mysql_install_db script.


-- 
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





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


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

Re: install problem

[Victoria Reznichenko]

"Maria Yndefors" <[EMAIL PROTECTED]> wrote:
> Hi,
> No I have not have MySql installed before and I am using version 1.4,
> but I used an my.cnf from another host with mysql 3.x
> 
> Now I can't even manage to start it I get the following in the log file
> 
> 040224 14:39:01  mysqld started
> 040224 14:39:04  InnoDB: Started
> 040224 14:39:04  Fatal error: Can't open privilege tables: Can't find
> file: './mysql/host.frm' (errno: 13)
> 040224 14:39:04  Aborting
> 
> 040224 14:39:04  InnoDB: Starting shutdown...
> 040224 14:39:06  InnoDB: Shutdown completed
> 040224 14:39:06  /usr/sbin/mysqld-max: Shutdown Complete
> 
> 040224 14:39:07  mysqld ended

$ perror 13
Error code  13:  Permission denied

Check privileges on the data dir. MySQL should be owner of the data dir.

> After installing it the first time I did not manage to log in as root to
> change the password.
> Is there some way to reset everything uninstall mysql and start all over
> from the beginning again?

If you want re-create grant tables, you should remove files from directory of the 
database 'mysql' and then run mysql_install_db script.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





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

RE: install problem

[Maria Yndefors]

Hi,
No I have not have MySql installed before and I am using version 1.4,
but I used an my.cnf from another host with mysql 3.x

Now I can't even manage to start it I get the following in the log file

040224 14:39:01  mysqld started
040224 14:39:04  InnoDB: Started
040224 14:39:04  Fatal error: Can't open privilege tables: Can't find
file: './mysql/host.frm' (errno: 13)
040224 14:39:04  Aborting

040224 14:39:04  InnoDB: Starting shutdown...
040224 14:39:06  InnoDB: Shutdown completed
040224 14:39:06  /usr/sbin/mysqld-max: Shutdown Complete

040224 14:39:07  mysqld ended

After installing it the first time I did not manage to log in as root to
change the password.
Is there some way to reset everything uninstall mysql and start all over
from the beginning again?

Best Regards
/maria

-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] 
Sent: den 24 februari 2004 11:15
To: [EMAIL PROTECTED]
Subject: Re: install problem

"Maria Yndefors" <[EMAIL PROTECTED]> wrote:
> Hi, Thanks for the fast reply,
> 
> I have not set the root password and I get the same result
> 
> [EMAIL PROTECTED] gms]# mysql -u root -p
> Enter password:
> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
> NO)
> 

Do you have installed MySQL server before? Seems MySQL server uses old
data dir.

You can reset root password: start MySQL server with --skip-grant-tables
option, set up new password for root and restart MySQL server or just
reload privilege tables. More detailed instruction you can find at:
http://www.mysql.com/doc/en/Resetting_permissions.html


-- 
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





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


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

Re: install problem

[Nitin Mehta]

are you using MySql 4.x?

try only
>mysql

Hope that helps
Nitin

- Original Message - 
From: "Davut Topcan" <[EMAIL PROTECTED]>
To: "Maria Yndefors" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 24, 2004 3:37 PM
Subject: Fw: install problem


> Hi,
> From: "Maria Yndefors" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 24, 2004 11:54 AM
> > I have not set the root password and I get the same result
> hmm..
> You should set root password :)
>
> Regards,
> Jack..
>
>
> -- 
> 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: install problem

[Victoria Reznichenko]

"Maria Yndefors" <[EMAIL PROTECTED]> wrote:
> Hi, Thanks for the fast reply,
> 
> I have not set the root password and I get the same result
> 
> [EMAIL PROTECTED] gms]# mysql -u root -p
> Enter password:
> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
> NO)
> 

Do you have installed MySQL server before? Seems MySQL server uses old data dir.

You can reset root password: start MySQL server with --skip-grant-tables option, set 
up new password for root and restart MySQL server or just reload privilege tables. 
More detailed instruction you can find at:
http://www.mysql.com/doc/en/Resetting_permissions.html


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





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

Fw: install problem

[Davut Topcan]

Hi,
From: "Maria Yndefors" <[EMAIL PROTECTED]>
Sent: Tuesday, February 24, 2004 11:54 AM
> I have not set the root password and I get the same result
hmm..
You should set root password :)
 
Regards,
Jack..


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

Re: install problem

[Victoria Reznichenko]

"Maria Yndefors" <[EMAIL PROTECTED]> wrote:
> I have installed the mysql server and client on an RedHat 7.3 but after
> installation I can't login as root. The message I get is:
> 
> I installed by using rpms
>
> 
> mysql -u root mysql
> 
>ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
> NO)

Does user root have a password? Use -p option of mysql client to specify user password.

mysql -uroot -p mysql

and then enter root password.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





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

RE: install problem

[Maria Yndefors]

Hi, Thanks for the fast reply,

I have not set the root password and I get the same result

[EMAIL PROTECTED] gms]# mysql -u root -p
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)

Best Regards
/Maria Yndefors

-Original Message-
From: Davut Topcan [mailto:[EMAIL PROTECTED] 
Sent: den 24 februari 2004 10:48
To: Maria Yndefors
Cc: [EMAIL PROTECTED]
Subject: Re: install problem

Hi
From: "Maria Yndefors" <[EMAIL PROTECTED]>
Sent: Tuesday, February 24, 2004 11:35 AM

> mysql -u root mysql
> 
> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
> NO)

Try of following;

-
#mysql -u root -p password 
-

connected in then

-
mysql> \u mysql;
-

Regards..
Jack..
 


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

Re: install problem

[Davut Topcan]

Hi
From: "Maria Yndefors" <[EMAIL PROTECTED]>
Sent: Tuesday, February 24, 2004 11:35 AM

> mysql -u root mysql
> 
> ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
> NO)

Try of following;

-
#mysql -u root -p password 
-

connected in then

-
mysql> \u mysql;
-

Regards..
Jack..
 


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

install problem

[Maria Yndefors]

Hi!

I have installed the mysql server and client on an RedHat 7.3 but after
installation I can't login as root. The message I get is:

I installed by using rpms

 

mysql -u root mysql

ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
NO)

 

The access rights to the /var/lib/mysql is:

 

[EMAIL PROTECTED] mysql]# ll /var/lib/

total 40

drwxr-xr-x2 root root 4096 Jan  8 17:39 alternatives

drwxr-xr-x2 root root 4096 Feb  6  1996 games

-rw-r--r--1 root root  293 Feb 24 10:48 logrotate.status

drwxr-xr-x2 root root 4096 May 15  2000 misc

drwxrwxrwx5 mysqlmysql4096 Feb 24 11:20 mysql

drwxrwxrwx4 mysqlmysql4096 Feb 23 16:10 mysql-innodb

-rw---1 root root  512 Feb 24 10:43 random-seed

drwxr-xr-x2 rpm  rpm  4096 Feb 24 10:48 rpm

drwxr-x---2 root slocate  4096 Feb 24 10:49 slocate

drwxrwxrwt2 root root 4096 Jan  8 17:40 texmf

 

 

Hoping for some help on this matter

 

Best Regards

 

/Maria Yndefors

Install Problem on AIX 4.3.3

[sgo]

I did a search of the list before posting. Noticed
several others having the same issue, but could not
find a resolution in any of the posts.

 I seem to be having some clib problems with the
current 
AIX mysql binary (AIX 4.3.3,  mysql-standard 4.0.17
(ibm c++ compiled) -- downloaded on 02/11/2004)

 The install notes for "other unix" are not explicit
regarding any requirements.  

 I did need to download gnu.gettext, gnu.tar and
gnu.gzip from http://www.bullfreeware.com/  in order
to extract the  archive (hope that help someone out
there!)

Below is the std out and error out from running
scripts/mysql_install_db:


exec(): 0509-036 Cannot load program
./bin/my_print_defaults because of the following
errors:
0509-130 Symbol resolution failed for
my_print_defaults because:
0509-136   Symbol stpcpy (number 50) is not exported
from
   dependent module /usr/lib/libc.a(shr.o).
0509-136   Symbol strnlen (number 51) is not exported
from
   dependent module /usr/lib/libc.a(shr.o).
0509-192 Examine .loader section symbols with the
 'dump -Tv' command.
WARNING: The host 'curly' could not be looked up with
resolveip.
This probably means that your libc libraries are not
100 % compatible
with this binary MySQL version. The MySQL daemon,
mysqld, should work
normally with the exception that host name resolving
will not work.
This means that you should use IP addresses instead of
hostnames
when specifying MySQL privileges !
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
exec(): 0509-036 Cannot load program ./bin/mysqld
because of the following errors:
0509-130 Symbol resolution failed for mysqld because:
0509-136   Symbol stpcpy (number 144) is not exported
from
   dependent module /usr/lib/libc.a(shr.o).
0509-136   Symbol strnlen (number 145) is not
exported from
   dependent module /usr/lib/libc.a(shr.o).
0509-192 Examine .loader section symbols with the
 'dump -Tv' command.
Installation of grant tables failed!

Examine the logs in ./data for more information.
You can also try to start the mysqld daemon with:
./bin/mysqld --skip-grant &
You can use the command line tool
./bin/mysql to connect to the mysql
database and look at the grant tables:

shell> ./bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths.
Using --log
gives you a log in ./data that may be helpful.

The latest information about MySQL is available on the
web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems
running mysql_install_db',
and the manual section that describes problems on your
OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug
script!


___
note that the /data directory in its 2 databases do
seem to have been created.


trying to start the deamon results in the following
std. out and error:
___
exec(): 0509-036 Cannot load program
./bin/my_print_defaults because of the following
errors:
0509-130 Symbol resolution failed for
my_print_defaults because:
0509-136   Symbol stpcpy (number 50) is not exported
from
   dependent module /usr/lib/libc.a(shr.o).
0509-136   Symbol strnlen (number 51) is not exported
from
   dependent module /usr/lib/libc.a(shr.o).
0509-192 Examine .loader section symbols with the
 'dump -Tv' command.
Starting mysqld daemon with databases from
/usr/local/mysql/data
040211 15:53:37  mysqld ended


___


seems to be a c library issue.  Is there a known fix
for this?  Are there more libraries I need to install?
Sorry about the long post...but I hope completeness
helps.

 thanks for any help!
 Scott

__
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html

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

4.0.14 install problem: mysqld crashes

[Gary Cote]

>Description:
I've recently compiled mysql 4.0.14 on redhat 8.0.
The installation fails, however, when running mysql_install_db.
I've attached a transcript below.

I gather from searching the 'net that this isn't an entirely
unusual thing to happen, and is likely the result of some
misconfiguration on my part, or perhaps a version incompatability
with my libc. Unfortunately, I haven't seen any concrete suggestions
on how to get past it.

I've studied the installation instructions pretty closely,
experimented with various compilation flags. I just keep getting
the same results.

This should be a pretty vanilla installation. Can someone please
point me in the direction of figuring out what I'm doing wrong?

>How-To-Repeat:
Geez ... how *not* to repeat it :)

>Fix: dunno

>Submitter-Id:  [EMAIL PROTECTED]
>Originator:Gary
>Organization:  personal use

>MySQL support: email support
>Synopsis:  4.0.14 install problems; mysqld crashes
>Severity:  minor
>Priority:  low
>Category:  mysql
>Class: sw-bug
>Release:   mysql-4.0.14 (Source distribution)

>C compiler:gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
>C++ compiler:  gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
>Environment:

System: Linux xeon 2.4.20-19.7 #2 Wed Aug 20 14:21:18 CDT 2003 i686 i686
i386 GNU/Linux
Architecture: i686

Some paths:  /usr/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/3.2/specs
Configured with:
../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info
 --enable-shared --enable-threads=posix --disable-checking --host=i386-redha
t-linux --with-system-zlib --enable-__cxa_atexit
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Compilation info: CC='gcc'  CFLAGS='-O3 '  CXX='gcc'
 CXXFLAGS='-O3 -fno-exceptions -fno-rtti -felide-constructors'  LDFLAGS=''
ASFLAGS=''
LIBC:
lrwxrwxrwx1 root root   14 Aug 21 17:58 /lib/libc.so.6 ->
libc-2.2.93.so
-rwxr-xr-x1 root root  1235468 Sep  5  2002 /lib/libc-2.2.93.so
-rw-r--r--1 root root  2233342 Sep  5  2002 /usr/lib/libc.a
-rw-r--r--1 root root  178 Sep  5  2002 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql'
'--enable-assembler' '--with-mysqld-ldflags=-all-static' 'CFLAGS=-O3 '
'CXXFLAGS=-O3 -fno-exceptions -fno-rtti -felide-constructors' 'CXX=gcc'



$ ./mysql_install_db

Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.

key_buffer_size=8388600
read_buffer_size=131072
max_used_connections=0
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
225791 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0x83cc2d8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xbf5fea68, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x8089a26
0x82402f8
0x8251796
0x809a0e5
0x809ce2f
0x8099f04
0x8094718
0x823b74d
0x82720ba
./mysql_install_db: line 1: 31298 Segmentation fault
/usr/local/mysql/libexec/mysqld --bootstrap --skip-grant-tables --basedir=/u
sr/local/mysql --datadir=/usr/local/mysql/var --skip-innodb --skip-bdb
Installation of grant tables failed!

Examine the logs in /usr/local/mysql/var for more information.
You can also try to start the mysqld daemon with:
/usr/local/mysql/libexec/mysqld --skip-grant &
You can use the command line tool
/usr/local/mysql/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/local/mysql/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /usr/local/mysql/var that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running
mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/local/mysql/bin/mysqlbug
script!



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l

RE: Linux install problem

[Steve Mansfield]

>>I'll bet you didn't run mysql_install_db with the --user=mysql option.
chown -R mysql.mysql /var/lib/mysql
should do the trick.

That's right, because I didn't see anything to that effect in the manual,
although the manual is a little confusing at this point. Following another
post (not in response to mine) I did a chmod on the mysql dir and its
contents and that seemed to do the trick.


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

Re: Linux install problem

[gerald_clark]

Steve Mansfield wrote:

Having run MySQL successfully for a while in a WAMP environment, I'm trying
to set up on Linux now (and am a real Linux newbie). I'm using the 4.3.1
version that came as an RPM with SuSE 8.2. The problem is - it doesn't work.
Here's where the various elements have installed to:

/usr/bin
   various mysql progs & scripts, incl
   mysql
   mysqladmin
   mysql_install_db
   safe_mysqld
etc
/usr/sbin
   mysqld
/var/lib/mysql
   mysql.sock
   mysql.log
   linux-bin.001 etc
when I run mysql_install_db (in /usr/bin), it creates the 'mysql' dir in
var/lib/mysql - so the path to the default database files becomes:
/var/lib/mysql/mysql/
I'll bet you didn't run mysql_install_db with the --user=mysql option.
chown -R mysql.mysql /var/lib/mysql
should do the trick.

From /usr/bin, I run:
   safe_mysqld --user=mysql &
and get the message
   Starting mysqld daemon with databases from /var/lib/mysql
but then the daemon shuts down straight away.
When I look in the log file, I find:
   /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
This is because mysqld can't access /var/lib/mysql/mysql.
perror 13
will show you that it is a permissions problem.
It looks as though the mysql_install_db has put the files in the wrong
place.
No, just installed them owned by the user running the script.
I am assuming 'root'.
Can anyone give me some advice as to how I sort this out...? Thanks.

Steve

 



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

Linux install problem

[Steve Mansfield]

Having run MySQL successfully for a while in a WAMP environment, I'm trying
to set up on Linux now (and am a real Linux newbie). I'm using the 4.3.1
version that came as an RPM with SuSE 8.2. The problem is - it doesn't work.

Here's where the various elements have installed to:

/usr/bin
various mysql progs & scripts, incl
mysql
mysqladmin
mysql_install_db
safe_mysqld
 etc

/usr/sbin
mysqld

/var/lib/mysql
mysql.sock
mysql.log
linux-bin.001 etc

when I run mysql_install_db (in /usr/bin), it creates the 'mysql' dir in
var/lib/mysql - so the path to the default database files becomes:
/var/lib/mysql/mysql/

>From /usr/bin, I run:
safe_mysqld --user=mysql &
and get the message
Starting mysqld daemon with databases from /var/lib/mysql
but then the daemon shuts down straight away.

When I look in the log file, I find:
/usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)

It looks as though the mysql_install_db has put the files in the wrong
place. Can anyone give me some advice as to how I sort this out...? Thanks.

Steve

Re: RedHat 8.0 and MySQL 3.23.55 install problem

[Csongor Fagyal]

I get this message back:
	Failed dependencies: 
	MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.55-1
I know I have this dependency installed, but I think I know where the
problem is just not sure how to fix it.  Here is what I get when I do a
'rpm -qa | grep DBI-perl':
	Mysql-DBI-perl-bin-1.1825-1

I think the problem is in the name of the dependency, 'bench' is looking
for MySQL-DBI-perl-bin and I have Mysql-DBI-perl-bin installed - 'MySQL'
and 'Mysql' do not match so the dependency is failing.  AM I correct in
this?  If so how do I fix it?
 

Not very nice, but I would simply use --nodeps.

- Cs.


-
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

RedHat 8.0 and MySQL 3.23.55 install problem

[Wes Hegge]

I am having problems installing MySQL 3.23.55 on RedHat 8.0.  The
version that came with RedHat will not let me remotely login.  I found a
thread at RedHat that said that this is a known problem. One of the
suggestions was to upgrade MySQL.  That is what I am attempting to do. 
This is what happens.

I have these files:
MySQL-3.23.55-1.i386.rpm
MySQL-bench-3.23.55-1.i386.rpm
MySQL-client-3.23.55-1.i386.rpm
MySQL-devel-3.23.55-1.i386.rpm
MySQL-shared-3.23.55-1.i386.rpm
I do this command to upgrade:
rpm -Uvh MySQL*
I get this message back:
Failed dependencies: 
MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.55-1
I know I have this dependency installed, but I think I know where the
problem is just not sure how to fix it.  Here is what I get when I do a
'rpm -qa | grep DBI-perl':
Mysql-DBI-perl-bin-1.1825-1

I think the problem is in the name of the dependency, 'bench' is looking
for MySQL-DBI-perl-bin and I have Mysql-DBI-perl-bin installed - 'MySQL'
and 'Mysql' do not match so the dependency is failing.  AM I correct in
this?  If so how do I fix it?

Thanks for the help,

Wes Hegge
SignalBlast.com, Inc.
p: (815) 397-1700
e: [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: install problem... (permissions?)

[Diana Soares]

[root@localhost ~]# perror 13
Error code  13:  Permission denied

Also check the permissions and ownership of /usr/local/var .

See the "Post installation setup" chapter from the manual.
http://www.mysql.com/doc/en/Post-installation.html

and
http://www.mysql.com/doc/en/File_permissions.html

On Sat, 2003-01-11 at 22:12, Stefan Hinz, iConnect (Berlin) wrote:
> Christopher,
> 
> > 030111 13:41:11  /usr/local/libexec/mysqld: Can't find file:
> > './mysql/host.frm' (errno: 13)
> 
> Did you run the install_db script? If not, MySQL can't find the grant
> tables.
> 
> See http://www.mysql.com/doc/en/Post-installation.html for details.
> 
> Regards,
> --
>   Stefan Hinz <[EMAIL PROTECTED]>
>   Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
>   Heesestr. 6, 12169 Berlin (Germany)
>   Tel: +49 30 7970948-0  Fax: +49 30 7970948-3
> 
> - Original Message -
> From: "Christopher Bergeron" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, January 11, 2003 7:29 PM
> Subject: install problem... (permissions?)
> 
> 
> > Hey guys, I'm having a little problem with my new mysql installation.
> I
> > built from source, and everything built find and installed okay (I
> > think).  Here's the problem:  when I start safe_mysqld  it just ends.
> >  Here's the snippet from my error log:
> >
> > /usr/local/libexec/mysqld: File './proto2-bin.1' not found (Errcode:
> 13)
> > 030111 13:41:11  Could not use proto2-bin for logging (error 13)
> > 030111 13:41:11  /usr/local/libexec/mysqld: Can't create/write to file
> > '/usr/local/var/proto2.pid' (Errcode: 13)
> > 030111 13:41:11  /usr/local/libexec/mysqld: Can't find file:
> > './mysql/host.frm' (errno: 13)
> > 030111 13:41:11  /usr/local/libexec/mysqld: Error on delete of
> > '/usr/local/var/proto2.pid' (Errcode: 13)
> > 030111 13:41:11  mysqld ended
> >
> > Is there an ownership or permission problem here?
> >
> > Can anyone help me out here?
> >
> > Much thanks in advance,
> > CB
> >
> >
> > -
> > 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
> 
-- 
Diana Soares


-
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: install problem... (permissions?)

[Stefan Hinz, iConnect \(Berlin\)]

Christopher,

> 030111 13:41:11  /usr/local/libexec/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)

Did you run the install_db script? If not, MySQL can't find the grant
tables.

See http://www.mysql.com/doc/en/Post-installation.html for details.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: "Christopher Bergeron" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 11, 2003 7:29 PM
Subject: install problem... (permissions?)


> Hey guys, I'm having a little problem with my new mysql installation.
I
> built from source, and everything built find and installed okay (I
> think).  Here's the problem:  when I start safe_mysqld  it just ends.
>  Here's the snippet from my error log:
>
> /usr/local/libexec/mysqld: File './proto2-bin.1' not found (Errcode:
13)
> 030111 13:41:11  Could not use proto2-bin for logging (error 13)
> 030111 13:41:11  /usr/local/libexec/mysqld: Can't create/write to file
> '/usr/local/var/proto2.pid' (Errcode: 13)
> 030111 13:41:11  /usr/local/libexec/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 030111 13:41:11  /usr/local/libexec/mysqld: Error on delete of
> '/usr/local/var/proto2.pid' (Errcode: 13)
> 030111 13:41:11  mysqld ended
>
> Is there an ownership or permission problem here?
>
> Can anyone help me out here?
>
> Much thanks in advance,
> CB
>
>
> -
> 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

install problem... (permissions?)

[Christopher Bergeron]

Hey guys, I'm having a little problem with my new mysql installation.  I 
built from source, and everything built find and installed okay (I 
think).  Here's the problem:  when I start safe_mysqld  it just ends. 
Here's the snippet from my error log:

/usr/local/libexec/mysqld: File './proto2-bin.1' not found (Errcode: 13)
030111 13:41:11  Could not use proto2-bin for logging (error 13)
030111 13:41:11  /usr/local/libexec/mysqld: Can't create/write to file 
'/usr/local/var/proto2.pid' (Errcode: 13)
030111 13:41:11  /usr/local/libexec/mysqld: Can't find file: 
'./mysql/host.frm' (errno: 13)
030111 13:41:11  /usr/local/libexec/mysqld: Error on delete of 
'/usr/local/var/proto2.pid' (Errcode: 13)
030111 13:41:11  mysqld ended

Is there an ownership or permission problem here?  

Can anyone help me out here?

Much thanks in advance,
CB


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

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

re: MySQL install Problem?

[Victoria Reznichenko]

Daniel,
Tuesday, October 08, 2002, 11:14:06 PM, you wrote:

DM> I have am having problems getting the MySQL server to start running, please help 
me, here are my problems, I have also displayed my error logs below, at least I hope 
they are the error logs;


DM> I have been trying to install the  
DM> mysql-3.23.52-pc-linux-gnu-i686.tar.gz 
DM> Everything seems to be going smoothly until I entered the command

DM> ./scripts/mysql_install_db

DM> I got this output which i believe is ok;

[skip]

DM> 021007 18:05:01  mysqld started
DM> 021007 18:05:01  /usr/local/mysql/mysql/bin/mysqld: Table 'mysql.host' 
DM> doesn't exist
DM> 021007 18:05:02  mysqld ended

DM> 021007 19:01:35  mysqld started
DM> 021007 19:01:35  /usr/local/mysql/mysql/bin/mysqld: Can't find file: 
DM> './mysql/host.frm' (errno: 13)
DM> 021007 19:01:35  mysqld ended

[skip]

DM> I believe I have viewed my err logs but I still don't know what I have to do to 
get MySQL server to start working? What must I do to get the MySQL server to start 
working?


Error 13 means "permission denied"

Check permissions on the MySQL data dir.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [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

MySQL install Problem?

[Daniel Miller]

I have am having problems getting the MySQL server to start running, please help me, 
here are my problems, I have also displayed my error logs below, at least I hope they 
are the error logs;


I have been trying to install the  
mysql-3.23.52-pc-linux-gnu-i686.tar.gz 
Everything seems to be going smoothly until I entered the command

./scripts/mysql_install_db

I got this output which i believe is ok;




cords-orj86jfje:/usr/local/mysql/mysql # ./scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
021007 18:15:39  ./bin/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
./bin/mysqladmin -u root  password 'new-password'
./bin/mysqladmin -u root -h cords-orj86jfje  password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd . ; ./bin/safe_mysqld &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' 
directory:
cd sql-bench ; run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com





Then I try to enter this command to configure my passwords;


Firstly

cords-orj86jfje:/usr/local/mysql/mysql # ./bin/safe_mysqld --user=mysql &
[1] 1346
cords-orj86jfje:/usr/local/mysql/mysql # Starting mysqld daemon with 
databases from /usr/local/mysql/mysql/data
021007 19:15:21  mysqld ended

[1]+  Done./bin/safe_mysqld --user=mysql

THEN,

cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root password 
sqlpass
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket 
'/tmp/mysql.sock' (111)'

OR
cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root sqlpass
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket 
'/tmp/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!


Now I was told my a few intelligent guys that I must check the mysql error 
logs and that they should tell me what is going wrong so I went looking for 
these mysterious error logs;


mike@cords-orj86jfje:/var/lib/mysql> locate *.err
/var/lib/mysql/cords-orj86jfje.err
mike@cords-orj86jfje:/var/lib/mysql> ls
cords-orj86jfje.err  mysql  test
mike@cords-orj86jfje:/var/lib/mysql> pico cords-orj86jfje.err

21002 10:09:23  mysqld started
/usr/sbin/mysqld: ready for connections
A mysqld process already exists at  Wed Oct 2 10:11:58 EDT 2002
A mysqld process already exists at  Wed Oct 2 10:13:36 EDT 2002
021002 10:21:37  /usr/sbin/mysqld: Normal shutdown

021002 10:21:37  /usr/sbin/mysqld: Shutdown Complete

021002 10:21:37  mysqld ended


ALSO;


cords-orj86jfje:/usr/local/mysql/mysql/data # ls
.  ..  cords-orj86jfje.err  cords-orj86jfje.err.save  mysql  test
cords-orj86jfje:/usr/local/mysql/mysql/data # pico  cords-orj86jfje.err


021007 17:41:08  mysqld started
021007 17:41:08  /usr/local/mysql/mysql/bin/mysqld: Table 'mysql.host' 
doesn't exist
021007 17:41:08  mysqld ended

021007 18:03:06  mysqld started
021007 18:03:07  /usr/local/mysql/mysql/bin/mysqld: Table 'mysql.host' 
doesn't exist
021007 18:03:07  mysqld ended

021007 18:05:01  mysqld started
021007 18:05:01  /usr/local/mysql/mysql/bin/mysqld: Table 'mysql.host' 
doesn't exist
021007 18:05:02  mysqld ended

021007 19:01:35  mysqld started
021007 19:01:35  /usr/local/mysql/mysql/bin/mysqld: Can't find file: 
'./mysql/host.frm' (errno: 13)
021007 19:01:35  mysqld ended

021007 19:03:17  mysqld started
021007 19:03:17  /usr/local/mysql/mysql/bin/mysqld: Can't find file: 
'./mysql/host.frm' (errno: 13)
021007 19:03:17  mysqld ended

021007 19:09:55  mysqld started
021007 19:09:55  /usr/local/mysql/mysql/bin/mysqld: Can't find file: 
'./mysql/host.frm' (errno: 13)
021007 19:09:55  mysqld ended

021007 19:15:21  mysqld started
021007 19:15:21  /usr/local/mysql/mysql/bin/mysqld: Can't find file: 
'./mysql/host.frm' (errno: 13)
021007 19:15:21  mysqld ended

021008 13:41:20  mysqld started
021008 13:41:21  /usr/local/mysql/mysql/bin/mysqld: Can't find file: 
'./mysql/host.frm' (errno: 13)
021008 13:41:21  mysqld ended



Where is this file host.frm ???



cords-orj86jfje:/usr/local/mysql/mysql/data # locate *.frm
cords-orj86jfje:/usr/local/mysql/mysql/data # locate host*
cords-orj86jfje:/usr/local/mysql/mysql/data #


/**MILLION DOLLAR QUESTION*/

I believe I have viewed my err logs but I still don't know what I have to do to get 
MySQL server to start working? What must I do to get the MySQL server to start 
working?



Thanks

re: Install Problem

[Egor Egorov]

Daniel,
Tuesday, October 08, 2002, 2:18:31 AM, you wrote:

DM> I have been trying to install the  
DM> mysql-3.23.52-pc-linux-gnu-i686.tar.gz on my SUSE Linux 7.3 machine.
DM> Everything seems to be going smoothly until I entered the command

DM> ./scripts/mysql_install_db

DM> I got this output which i believe is ok;

[skip]

DM> Then I try to enter this command to configure my passwords;

DM> Firstly

DM> cords-orj86jfje:/usr/local/mysql/mysql # ./bin/safe_mysqld --user=mysql &
DM> [1] 1346
DM> cords-orj86jfje:/usr/local/mysql/mysql # Starting mysqld daemon with databases 
from /usr/local/mysql/mysql/data
DM> 021007 19:15:21  mysqld ended

DM> [1]+  Done./bin/safe_mysqld --user=mysql

DM> THEN,

DM> cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root password sqlpass
DM> ./bin/mysqladmin: connect to server at 'localhost' failed
DM> error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'

[skip]

DM> What am I doing wrong ??

MySQL server isn't running. What is mentioned in the error log?



-- 
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: Install Problem

[John Coder]

On Mon, 2002-10-07 at 19:18, Daniel Miller wrote:
> 
> I have been trying to install the  
> mysql-3.23.52-pc-linux-gnu-i686.tar.gz on my SUSE Linux 7.3 machine.
> Everything seems to be going smoothly until I entered the command
> 
> ./scripts/mysql_install_db
> 
> I got this output which i believe is ok;
> 
> 
> 
> 
> cords-orj86jfje:/usr/local/mysql/mysql # ./scripts/mysql_install_db
> Preparing db table
> Preparing host table
> Preparing user table
> Preparing func table
> Preparing tables_priv table
> Preparing columns_priv table
> Installing all prepared tables
> 021007 18:15:39  ./bin/mysqld: Shutdown Complete
> 
> 
> To start mysqld at boot time you have to copy support-files/mysql.server
> to the right place for your system
> 
> PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
> This is done with:
> ./bin/mysqladmin -u root  password 'new-password'
> ./bin/mysqladmin -u root -h cords-orj86jfje  password 'new-password'
> See the manual for more instructions.
> 
> You can start the MySQL daemon with:
> cd . ; ./bin/safe_mysqld &
> 
> You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
> cd sql-bench ; run-all-tests
> 
> Please report any problems with the ./bin/mysqlbug script!
> 
> The latest information about MySQL is available on the web at
> http://www.mysql.com
> Support MySQL by buying support/licenses at https://order.mysql.com
> 
> 
> 
> 
> 
> Then I try to enter this command to configure my passwords;
> 
> Firstly
> 
> cords-orj86jfje:/usr/local/mysql/mysql # ./bin/safe_mysqld --user=mysql &
> [1] 1346
> cords-orj86jfje:/usr/local/mysql/mysql # Starting mysqld daemon with databases from 
>/usr/local/mysql/mysql/data
> 021007 19:15:21  mysqld ended
> 
> [1]+  Done./bin/safe_mysqld --user=mysql
> 
> THEN,
> 
> cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root password sqlpass
> ./bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'
> 
> OR
> cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root sqlpass
> ./bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'
> Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
> 
> What am I doing wrong ??
> 
> 
> Thanks, Daniel
it's easier to do this from and rpm that suse provides. if you do
reinstall using a rpm from suse before you issue the command
mysql_install_db run the command from any terminal 'rcmysql start' that
runs a script that is located in /etc/init.d . For further explanation
read the README.SUSE. I suspect the problem is where you are installing
it. by definition by tar it usually winds up wherever you tar gunzip it.
by rpm it winds up in /var/lib/mysql. I've also have done a soft link
from one to the other. Hope this helps.

John Coder




-
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

Install Problem

[Daniel Miller]

I have been trying to install the  
mysql-3.23.52-pc-linux-gnu-i686.tar.gz on my SUSE Linux 7.3 machine.
Everything seems to be going smoothly until I entered the command

./scripts/mysql_install_db

I got this output which i believe is ok;




cords-orj86jfje:/usr/local/mysql/mysql # ./scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
021007 18:15:39  ./bin/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
./bin/mysqladmin -u root  password 'new-password'
./bin/mysqladmin -u root -h cords-orj86jfje  password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd . ; ./bin/safe_mysqld &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com





Then I try to enter this command to configure my passwords;

Firstly

cords-orj86jfje:/usr/local/mysql/mysql # ./bin/safe_mysqld --user=mysql &
[1] 1346
cords-orj86jfje:/usr/local/mysql/mysql # Starting mysqld daemon with databases from 
/usr/local/mysql/mysql/data
021007 19:15:21  mysqld ended

[1]+  Done./bin/safe_mysqld --user=mysql

THEN,

cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root password sqlpass
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'

OR
cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root sqlpass
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

What am I doing wrong ??


Thanks, Daniel


-
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

install problem

[richard . mail]

Dear list, 

I’ve been trying to install mysql 4.0.2. alpha. 

The configuration is going well.
That also count’s for the “make” command.
But when I run the “make test” command I’m getting the following error: 

ERROR: /down/mysql-4.0.2-alpha/mysql-test/var/run/master.pid was not created 
in 30 seconds;  Aborting
make: *** [test] Error 1 


Does any one know what I’m doing wrong?? 

Thanks in advance, 

Richard Pijnenburg
Klik-on Internet solutions
The Netherlands 


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

install problem

[Richard Pijnenburg]

Dear list,

I've been trying to install mysql 4.0.2. alpha.

The configuration is going well.
That also count's for the "make" command.
But when I run the "make test" command I'm getting the following error:

ERROR: /down/mysql-4.0.2-alpha/mysql-test/var/run/master.pid was not
created in 30 seconds;  Aborting
make: *** [test] Error 1


Does any one know what I'm doing wrong??

Thanks in advance,

Richard Pijnenburg
Klik-on Internet solutions
The Netherlands


Sql,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: install problem

[Dicky Wahyu Purnomo]

Pada Tue, 23 Jul 2002 03:20:54 +0200
"Richard Pijnenburg" <[EMAIL PROTECTED]> menulis :

> Dear list,
> 
> I've been trying to install mysql 4.0.2. alpha.
> 
> The configuration is going well.
> That also count's for the "make" command.
> But when I run the "make test" command I'm getting the following error:
> 
> ERROR: /down/mysql-4.0.2-alpha/mysql-test/var/run/master.pid was not
> created in 30 seconds;  Aborting
> make: *** [test] Error 1
> 
> 
> Does any one know what I'm doing wrong??

don't botter the error from make test  try to continue with make install, 

and start your mysqld  ... ;-)

-- 
Let's call it an accidental feature.
-- Larry Wall
 
MySQL 3.23.51 : up 32 days, Queries : 354.179 per second (avg).

--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790)
Phone : +62 21 79199577 - Web : http://1rstwap.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

install problem

[Richard Pijnenburg]

Dear list,

I've been trying to install mysql 4.0.2. alpha.

The configuration is going well.
That also count's for the "make" command.
But when I run the "make test" command I'm getting the following error:

ERROR: /down/mysql-4.0.2-alpha/mysql-test/var/run/master.pid was not
created in 30 seconds;  Aborting
make: *** [test] Error 1


Does any one know what I'm doing wrong??

Thanks in advance,

Richard Pijnenburg
Klik-on Internet solutions
The Netherlands


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

Fw: Minor install problem w/max-4.0.2

[Larry Irwin]

Concerning mysql-max-4.0.2-alpha-pc-linux-gnu-i686.tar.gz on SuSE 7.3

If you cd /usr/local and unpack the tarball then create a symlink to mysql,
cd into mysql and run ./bin/mysqld.safe the daemon can't locate
mysql-max-4.0.2-alpha-pc-linux-gnu-i686/share/mysql/english/errmsg.sys.

If you remove the symlink and mv the distro name dir to mysql, then it
works.

Larry Irwin
CCA Medical


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

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

Mysql install problem ..

[Subhrajyoti]

Hi folks,
I am facing problems in running mysql with apache and perl on my system.
The version of mysql i am using is 3.23.39
Below is the program i wrote
to check the mysql connectivity with perl.

#!/usr/bin/perl

use lib qw(/home/www/pm);

$ENV{'DBI_DSN' } = "dbi:mysql:z";
$ENV{'DBI_USER'} = "db";
$ENV{'DBI_PASS'} = "db";

my @t = (localtime)[5,4,3];
my $today = join '-', ($t[0]+"1900", $t[1]+1, $t[2]);


use DBI;
my $database   =   $ENV{DBI_DSN};
my $users  =   $ENV{DBI_USER};
my $password   =   $ENV{DBI_PASS};

my $dbh=   DBI->connect($database, $users, $password) || die
$DBI::errstr;


my $query = "select id from users limit 10";
my $sth   = $dbh->prepare($query);

$sth->execute();

my $obj = $sth->fetchall_arrayref();

if(defined $obj && @$obj){
foreach my $row (@$obj){
my $id = $$row[0];
print "Id = $id \n";
}
}

$sth->finish();
$dbh->disconnect();

I am getting the following error.

install_driver(mysql) failed: Can't load
'/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/mysql/mysql.so' for
module DBD::mysql: libmysqlclient.so.6: cannot open shared object file: No
such file or directory at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm
line 169.

 at (eval 1) line 3
Perhaps a required shared library or dll isn't installed where expected
 at /home/pawan/check.pl line 19

please tell me what is wrong?

subhro.



-
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: Install problem!

[Egor Egorov]

João,
Saturday, April 27, 2002, 5:29:54 PM, you wrote:

JPS> Some time ago I have installed MySQL and after a 
JPS> short period of time I uninstalled it.
JPS> Now when I try to install it again the installshield 
JPS> makes a sound (like a warning) show a message box to 
JPS> quickly (it disappears right after) and don’t install 
JPS> MySQL.

JPS> I’m using windowsxp professional. I Have tried to 
JPS> install version 3.23.49 and 4.0 alpha.

JPS> ANyone can help me?

How did you uninstalled MySQL? Was your uninstallation clear? 
Probably there were some records in Windows registry that 
prevents you to install MySQL again.

JPS> Thanks in advance,
JPS> Eduardo David





-- 
For technical support contracts, goto https://order.mysql.com/
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

Install problem!

[João Paulo Silva]

Hello there.


Some time ago I have installed MySQL and after a 
short period of time I uninstalled it.
Now when I try to install it again the installshield 
makes a sound (like a warning) show a message box to 
quickly (it disappears right after) and don’t install 
MySQL.

I’m using windowsxp professional. I Have tried to 
install version 3.23.49 and 4.0 alpha.

ANyone can help me?

Thanks in advance,
Eduardo David


-
Email Enviado utilizando o serviço MegaMail

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

[Dicky Wahyu Purnomo]

On Mon, 08 Apr 2002 21:04:36 -0500
"Terry & Cheryl Haimann" <[EMAIL PROTECTED]> wrote:

> I have installed mysql-3.23.49a from an rpm(both the development and the client) on 
>a Redhat 7.1 system. After installation I 
> ran the mysql_install_db.  Now everytime I try to run any of the client programs, I 
>get an illegal instruction(core dump.)  What 
> do I need to do to make this a working version?

Have you try to use client from other host or different version ?

You still can use client from lower version ;-) or just try to use tar.gz mysql binary 
file :D

-- 
Let's call it an accidental feature.
-- Larry Wall

-
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

Install problem

[Terry & Cheryl Haimann]

I have installed mysql-3.23.49a from an rpm(both the development and the client) on a 
Redhat 7.1 system. After installation I 
ran the mysql_install_db.  Now everytime I try to run any of the client programs, I 
get an illegal instruction(core dump.)  What 
do I need to do to make this a working version?


Thx Terry



-
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: Msql-Mysql install problem...

[Philip Molter]

On Wed, Apr 03, 2002 at 06:10:02PM +0300, Egor Egorov wrote:
: Murali,
: Wednesday, April 03, 2002, 1:55:57 PM, you wrote:

You know, I don't meant to be a bother, but can you folks at Ensita 
reply to the list using standard reply conventions?  All of your
replies have the exact same subject as the message they're replying 
to.  Since the messages don't seem to have any sort of reference
headers and since you're not prefixing them with 'Re:' (or some 
variant thereof), most mail clients that group by thread (which is  
probably one of the easiest ways to read such an active list) can't 
group them.  It's really quite annoying, not to mention the fact
that you can't tell from the subject that it's a reply. 

Do you think the Ensita gang there can set their mail clients to
prefix replies with 'Re:'?  Otherwise, the list as it appears in
my (and probably many others') mail clients is extremely hard to
follow. 

Thanks, 
Philip

sql, query, mysql

* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [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

Msql-Mysql install problem...

[Egor Egorov]

Murali,
Wednesday, April 03, 2002, 1:55:57 PM, you wrote:

MP>   When I try to install the Msql-Mysql module it throws up a list of
MP> questions.One of them is :

MP> Where is your MySQL installed? Please tell me the directory that
MP> contains the subdir 'include'. [/usr/local]

It looks like in your case you should specify /usr directory.

MP> I had installed MYSQL 3.23.49a using the rpm technique.I checked out in my
MP> /usr/local and it does not have an 'include' sub dir.When I ran a search for
MP> 'Mysql' from the root I got a list of directories,once again I never found a
MP> sub dir called 'include' in any of these directories.Can you please tell me
MP> which is the right directory that I need to specify or if I need to search
MP> for any particular mySql module and give that directory as input to the
MP> query above.
MP> Thanks for your time,
MP> Best Regards,
MP> Prakash.   






-- 
For technical support contracts, goto https://order.mysql.com/
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

Msql-Mysql install problem...

[Murali Prakash]

Hi,
  When I try to install the Msql-Mysql module it throws up a list of
questions.One of them is :

Where is your MySQL installed? Please tell me the directory that
contains the subdir 'include'. [/usr/local]

I had installed MYSQL 3.23.49a using the rpm technique.I checked out in my
/usr/local and it does not have an 'include' sub dir.When I ran a search for
'Mysql' from the root I got a list of directories,once again I never found a
sub dir called 'include' in any of these directories.Can you please tell me
which is the right directory that I need to specify or if I need to search
for any particular mySql module and give that directory as input to the
query above.
Thanks for your time,
Best Regards,
Prakash.   

-
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

Super-smack install problem

[george]

Warning
Unable to process data: 
multipart/mixed; boundary="--==_846811060==_"

MySQL ver 3.23.47 install Problem

[Sk Islam]

Dear sir
I have a problem to install MySQL for windows on my standalone PC.

When I run 'WINMYSQLADMIN.EXE'  from dos prompt or windows explorer then it
did not run and gives and error message
'Access violation at address 00040298D in module 'WINMYSQLADMIN.EXE'. Read
of address '
when I press OK button then a window (WinMySQLadmin 1.3 ) pops up. It should
be 'WinMySQLadmin Quick Setup' window for the first time.

After going through the help file in MySQL I download  wiinsock 2 driver.
But after installing the driver it also failed to install.

My PC-Config.is  P 233, 32 MB SDRAM, WIN95 OSR2, 4GB partition.

Please help

Sk Islam



-
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: source install problem - solaris2.6

[Salada, Duncan]

Please ignore my original message.  I was finally able to get it to work
using:
CC=gcc CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors
 -fno-exceptions -fno-rtti" ./configure
--prefix=/usr/local/mysql-3.23.49
 --with-low-memory --enable-assembler

Duncan
--
Duncan Salada | Titan | www.titan.com/testeval
Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216

> -Original Message-
> From: Salada, Duncan [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 06, 2002 8:14 AM
> To: '[EMAIL PROTECTED]'
> Subject: source install problem - solaris2.6
> 
> 
> Hello all,
> 
> I am having some problems with installing 3.23.49 from 
> source.  Below is the
> output from mysqlbug with my additions to help explain the 
> problem.  Any
> help would be great - my experience with this kind of stuff 
> is not that
> great.
> 
> >Description:
> I am trying to upgrade from 3.20.32a by installing 
> the source since
> there is no binary for Solaris 2.6.  While attempting to 
> install make
> fails:
>   I used
>   CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3
> -felide-constructors 
>   -fno-exceptions -fno-rtti" ./configure
> --prefix=/usr/local/mysql 
>   --enable-assembler 
> --with-mysqld-ldflags=-all-static
>   Here's the end of the output from the make
> 
> mkdir .libs
> gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti
> -fno-implicit-templates -fno-exceptions -fno-rtti 
> -DHAVE_RWLOCK_T -o mysqld
> sql_lex.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o
> item_strfunc.o item_timefunc.o thr_malloc.o item_create.o 
> field.o key.o
> sql_class.o sql_list.o net_serv.o violite.o net_pkg.o lock.o my_lock.o
> sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o
> hostname.o convert.o sql_parse.o sql_yacc.o sql_base.o 
> table.o sql_select.o
> sql_insert.o sql_update.o sql_delete.o sql_do.o procedure.o 
> item_uniq.o
> sql_test.o log.o log_event.o init.o derror.o sql_acl.o unireg.o time.o
> opt_range.o opt_sum.o opt_ft.o records.o filesort.o handler.o 
> ha_heap.o
> ha_myisam.o ha_myisammrg.o ha_berkeley.o ha_innobase.o 
> ha_gemini.o ha_isam.o
> ha_isammrg.o sql_db.o sql_table.o sql_rename.o sql_crypt.o sql_load.o
> mf_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o 
> sql_cache.o
> slave.o sql_repl.o mini_client.o mini_client_errors.o md5.o 
> stacktrace.o
> -static ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a
> ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a
> ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -ldl
> -lpthread -lthread -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread
> ld: fatal: library -ldl: not found
> ld: fatal: library -lpthread: not found
> ld: fatal: library -lthread: not found
> ld: fatal: library -lpthread: not found
> ld: fatal: library -lthread: not found
> ld: fatal: File processing errors. No output written to mysqld
> collect2: ld returned 1 exit status
> make[3]: *** [mysqld] Error 1
> make[3]: Leaving directory `/tmp/mysql-3.23.49/sql'
> make[2]: *** [all-recursive] Error 1
> make[2]: Leaving directory `/tmp/mysql-3.23.49/sql'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory `/tmp/mysql-3.23.49'
> make: *** [all-recursive-am] Error 2
> 
> 
> >How-To-Repeat:
> make
> >Fix:
>  lines)>
> 
> >Submitter-Id:  
> >Originator:Duncan Salada
> >Organization:
>  
> >MySQL support: [none | licence | email support | extended 
> email support ]
> >Synopsis:  
> >Severity:  <[ non-critical | serious | critical ] (one line)>
> >Priority:  <[ low | medium | high ] (one line)>
> >Category:  mysql
> >Class: <[ sw-bug | doc-bug | change-request | 
> support ] (one line)>
> >Release:   mysql-3.23.49 (Source distribution)
> >Server: mysqladmin  Ver 8.23 Distrib 3.23.49, for 
> sun-solaris2.6 on sparc
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free 
> software,
> and you are welcome to modify and redistribute it under the 
> GPL license
> 
> Server version  3.20.32a
> Protocol version9
> Connection  Localhost via UNIX socket
> UNIX socket /tmp/mysql.sock
> Uptime: 20 hours 2 min 24 sec
> 
> Running threads: 1  Questions: 35871  Reloads: 1  Open tables: 15
> >Environment:
> 
> System: SunOS literacy 5.6 Ge

source install problem - solaris2.6

[Salada, Duncan]

Hello all,

I am having some problems with installing 3.23.49 from source.  Below is the
output from mysqlbug with my additions to help explain the problem.  Any
help would be great - my experience with this kind of stuff is not that
great.

>Description:
I am trying to upgrade from 3.20.32a by installing the source since
there is no   binary for Solaris 2.6.  While attempting to install make
fails:
I used
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3
-felide-constructors 
-fno-exceptions -fno-rtti" ./configure
--prefix=/usr/local/mysql 
--enable-assembler --with-mysqld-ldflags=-all-static
Here's the end of the output from the make

mkdir .libs
gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti
-fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o mysqld
sql_lex.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o
item_strfunc.o item_timefunc.o thr_malloc.o item_create.o field.o key.o
sql_class.o sql_list.o net_serv.o violite.o net_pkg.o lock.o my_lock.o
sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o
hostname.o convert.o sql_parse.o sql_yacc.o sql_base.o table.o sql_select.o
sql_insert.o sql_update.o sql_delete.o sql_do.o procedure.o item_uniq.o
sql_test.o log.o log_event.o init.o derror.o sql_acl.o unireg.o time.o
opt_range.o opt_sum.o opt_ft.o records.o filesort.o handler.o ha_heap.o
ha_myisam.o ha_myisammrg.o ha_berkeley.o ha_innobase.o ha_gemini.o ha_isam.o
ha_isammrg.o sql_db.o sql_table.o sql_rename.o sql_crypt.o sql_load.o
mf_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o sql_cache.o
slave.o sql_repl.o mini_client.o mini_client_errors.o md5.o stacktrace.o
-static ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a
../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a
../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -ldl
-lpthread -lthread -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread
ld: fatal: library -ldl: not found
ld: fatal: library -lpthread: not found
ld: fatal: library -lthread: not found
ld: fatal: library -lpthread: not found
ld: fatal: library -lthread: not found
ld: fatal: File processing errors. No output written to mysqld
collect2: ld returned 1 exit status
make[3]: *** [mysqld] Error 1
make[3]: Leaving directory `/tmp/mysql-3.23.49/sql'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/tmp/mysql-3.23.49/sql'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/tmp/mysql-3.23.49'
make: *** [all-recursive-am] Error 2


>How-To-Repeat:
make
>Fix:


>Submitter-Id:  
>Originator:Duncan Salada
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:  
>Severity:  <[ non-critical | serious | critical ] (one line)>
>Priority:  <[ low | medium | high ] (one line)>
>Category:  mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release:   mysql-3.23.49 (Source distribution)
>Server: mysqladmin  Ver 8.23 Distrib 3.23.49, for sun-solaris2.6 on sparc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.20.32a
Protocol version9
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 20 hours 2 min 24 sec

Running threads: 1  Questions: 35871  Reloads: 1  Open tables: 15
>Environment:

System: SunOS literacy 5.6 Generic_105181-12 sun4u sparc SUNW,Ultra-1
Architecture: sun4

Some paths:  /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc
/usr/ucb/cc
GCC: Reading specs from
/usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'  CXXFLAGS=''  LDFLAGS=''
LIBC:

Duncan
--
Duncan Salada | Titan | www.titan.com/testeval
Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216

-
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

Strange install problem

[Jan . Albrecht]

Hi,

after ./configure, make, make install of Version 4.0.1-alpha I executed the
mysql_install_db script to finish the installation of mysql.
The script says I should execute the commands
$/mysql/bin/mysqladmin -u root password 'mypass'
$/mysql/bin/mysqladmin -u root -h admin08-1 password 'mypass'

The first command worked but when I try the second I get the message:

#error: 'HOST 'XXX.XXX.XXX.XXX' is not allowed to connect to this MySQL
server'

Are there already set rights or what might be the problem?

Thanks.

Kind regards

Jan Albrecht

-- 
Jan AlbrechtSystem Consultant 
Bertelsmann mediaSystems NMI-DC UNIX/NT/Windows 2000
An der Autobahn
33311 Gütersloh
Germany
Phone:  +49-5241-80-88404 mobile: +49-172-2978914
Fax:+49-5241-80-688404  Mail: [EMAIL PROTECTED]

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

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

Install problem

[Egor Egorov]

HQ,

Saturday, February 02, 2002, 1:46:37 AM, you wrote:
H> Dear all,

H> I am new to MySQL.  

H> I have just installed the rpm package of mySQL on my RedHat Linux, but
H> found many problems.  First, I can not run the following command:
H> mysqladmin -u root password "Mypasswd"
H> Second, it does not allow me to create any databases.  
H> I can log in using "mysql" command by default, but not like "mysql -u
H> hqin2 -h shanghai -p".  The later is refused by the daemon.

Please, cite your error code and check the following links:
http://www.mysql.com/doc/S/t/Starting_server.html
http://www.mysql.com/doc/A/c/Access_denied.html
http://www.mysql.com/doc/U/s/User_names.html
http://www.mysql.com/doc/D/e/Default_privileges.html

H> I appreciate your helps.  

H> Hong





-- 
For technical support contracts, goto https://order.mysql.com/
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

Install problem

[HQ]

Dear all,

I am new to MySQL.  

I have just installed the rpm package of mySQL on my RedHat Linux, but
found many problems.  First, I can not run the following command:
mysqladmin -u root password "Mypasswd"
Second, it does not allow me to create any databases.  
I can log in using "mysql" command by default, but not like "mysql -u
hqin2 -h shanghai -p".  The later is refused by the daemon.

I appreciate your helps.  

Hong

-
 Hong Qin
 Department of Ecology and EvolutionUniversity of Chicago
 1101 East 57th Street, Room 111Chicago, IL 60637  
 Phone: (773) 834-3964  FAX: (773) 702-9740
 Email: [EMAIL PROTECTED]
-


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

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

Linux Install Problem

[Kevin Smith]

Hi,

Can anyone shed some light on this problem I got when trying to compile on a
Linux platform?

/usr/local/mysql/lib/mysql
../libmysql/.libs/libmysqlclient.so: undefined reference to `atexit'
collect2: ld returned 1 exit status

Thanks,

Kevin


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

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

Re: MySQL RPM Install Problem - Ignorance

[DWilliams]

Trevor,

Thanks for the tip...This is probably what I should have done in the first
place.  I can't now though, at least not at the moment, this is a Cobalt
RAQ4 web server set up at a hosting service in Atlanta, GA.

I went ahead and used a symlink at the compiled data directotry pointing
back to a "roomier" /home directory.

Thanks,
Dennis Williams


- Original Message -
From: "Trevor Forrester" <[EMAIL PROTECTED]>
To: "DWilliams" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, December 31, 2001 12:59 AM
Subject: RE: MySQL RPM Install Problem - Ignorance


> Dennis if you want to see if the /var/lib/mysql directory is on it's own
> partition or drive look at /etc/fstab and see which /dev it is mounted on.
> If you wanted to you can mount a new drive at /var/lib/mysql and have you
> data on it's own drive. If you have some sort of system failure you can
just
> mount the drive on a new installation using the /etc/fstab file.
>
> Some people mount there individual databases on standalone drives. Not
> saying this the best way but it is one way if you can afford hardware.
That
> leaves you root drives for programs.
>
> Regards
> Trevor
> -Original Message-
> From: DWilliams [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 31 December 2001 2:56 AM
> To: [EMAIL PROTECTED]
> Subject: MySQL RPM Install Problem - Ignorance
>
>
> Hi all,
>
> I have recently installed a MySQL server and client RPM 3.23.47 on a Linux
> system.  The system that I am setting up is a Cobalt RAQ4, first time for
me
> to install MySQL on Linux.
>
> The installed datadir turned out to be /var/lib/mysql.  I get errors when
> trying to move a very large MySQL data (800MB) directory from a previous
> host system.  It turns out that the /var directory has it's own partition,
I
> think.  A 'df' command shows not enough room on the /var directory for the
> MySQL data files.
>
> I am thinking I need to change the datadir variable to somewhere on the
> /home directory, where I have > 15GB free.
>
> How can I achieve this?  Or is this the right approach?  I think I
> understood that the server can be started up with a different --datadir
> option, but I would like this to be more permanent in case of system
> reboots.
>
> Thanks,
> Dennis Williams
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



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

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

RE: MySQL RPM Install Problem - Ignorance

[Trevor Forrester]

Dennis if you want to see if the /var/lib/mysql directory is on it's own
partition or drive look at /etc/fstab and see which /dev it is mounted on.
If you wanted to you can mount a new drive at /var/lib/mysql and have you
data on it's own drive. If you have some sort of system failure you can just
mount the drive on a new installation using the /etc/fstab file.

Some people mount there individual databases on standalone drives. Not
saying this the best way but it is one way if you can afford hardware. That
leaves you root drives for programs.

Regards
Trevor
-Original Message-
From: DWilliams [mailto:[EMAIL PROTECTED]]
Sent: Monday, 31 December 2001 2:56 AM
To: [EMAIL PROTECTED]
Subject: MySQL RPM Install Problem - Ignorance


Hi all,

I have recently installed a MySQL server and client RPM 3.23.47 on a Linux
system.  The system that I am setting up is a Cobalt RAQ4, first time for me
to install MySQL on Linux.

The installed datadir turned out to be /var/lib/mysql.  I get errors when
trying to move a very large MySQL data (800MB) directory from a previous
host system.  It turns out that the /var directory has it's own partition, I
think.  A 'df' command shows not enough room on the /var directory for the
MySQL data files.

I am thinking I need to change the datadir variable to somewhere on the
/home directory, where I have > 15GB free.

How can I achieve this?  Or is this the right approach?  I think I
understood that the server can be started up with a different --datadir
option, but I would like this to be more permanent in case of system
reboots.

Thanks,
Dennis Williams


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

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



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

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

Re: MySQL RPM Install Problem - Ignorance

[DWilliams]

Robert,

Thanks again...

I think I am on the right track, maybe.  I am trying to use the symlink
method you suggested.

Below is the command I used to create a symlink named 'amgr' in
/var/lib/mysql/ pointing to the real data directory of 'amgr' in
/home/mysql/amgr/.  The database 'amgr' shows up as a reference (with
tables) when I use phpMyAdmin to view it, but the database and tables are
totally empty of records...which of course it has many.

ln -s /home/mysql/amgr/ /var/lib/mysql/

Also, it produces an error when I click to view one of the tables in
phpMyAdmin.


MySQL said:

Can't find file: './amgr/.frm' (errno: 13)


Did I miss something?  Did I mention I was ignorant?

Thanks,
Dennis Williams

- Original Message -
From: "Robert Alexander" <[EMAIL PROTECTED]>
To: "DWilliams" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, December 30, 2001 3:29 PM
Subject: Re: MySQL RPM Install Problem - Ignorance


> At 14:37 -0600 2001/12/30, DWilliams wrote:
> >Robert,
> >
> >Thanks for the tips...
> >
> >>>1. create a symlink at /var/lib/mysql that points to your data
directory<<
> >
> >I had read that this was not the best way prior to v4.0, something about
an
> >"alter table" statement might ignore the symlink?
>
> I've used symlinks a lot and have never had any problems.  I usually just
install the binary distro, and symlink from /usr/local/mysal/data ->
my/data/location.
>
>
>
> >>>2. you can change or add the 'datadir' variable in your my.cnf file
> >(usually /etc/my.cnf) see:<<
> >
> >I apparently don't have a 'my.cnf' file after install...I found the
> >following in /usr/share/mysql/:
> >
> >my-huge.cnf
> >my-large.cnf
> >my-medium.cnf
> >my-small.cnf
> >
> >I guess these are example my.cnf files to use...If so, the next question
> >which is the appropriate/best type?
>
> Just open them up in an editor and read what it says at the top.  Then
copy the one you want to /etc/my.cnf
>
>
> >I guess whatever choice should be
> >renamed and located as 'my.cnf' in /var/lib/mysql directory?  I'm
assuming
> >the server on start-up reads this file and overrides compiled commands.
>
> Not in the data dir.  You're telling it where to *look* for the data,
right?  This would be your global settings and goes into /etc/my.cnf.
>
>
> >Which section does the 'datadir=path/to/data/' command go...to the
[mysqld]
> >section?
>
> Yup.
>
>
> >There is no mention of this command on:
> >http://www.mysql.com/doc/O/p/Option_files.html
>
> In a browser, open up the manual that came with your distro and do a
search for 'my.cnf'  Lots o' good stuff...  :>
>
>
>
> >>>3. you can specify the data directory location as a configure option
> >before compiling.<<
> >
> >Eventually, I will learn how to do this...but I opted for the RPM
instead.
> >I guess that is why I have these sort of configuration difficulties.
> >
> >Thanks again,
> >Dennis Williams
>
>
> Regards,
> /Rob
> --
> Robert Alexander  ([EMAIL PROTECTED])  416-823-6599
> http://www.workmate.ca  WWW Database Applications and Web Hosting
>
> Searchable MySQL List Archive: http://archive.workmate.ca/myarchive
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


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

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

Re: MySQL RPM Install Problem - Ignorance

[Robert Alexander]

At 14:37 -0600 2001/12/30, DWilliams wrote:
>Robert,
>
>Thanks for the tips...
>
>>>1. create a symlink at /var/lib/mysql that points to your data directory<<
>
>I had read that this was not the best way prior to v4.0, something about an
>"alter table" statement might ignore the symlink?

I've used symlinks a lot and have never had any problems.  I usually just install the 
binary distro, and symlink from /usr/local/mysal/data -> my/data/location.



>>>2. you can change or add the 'datadir' variable in your my.cnf file
>(usually /etc/my.cnf) see:<<
>
>I apparently don't have a 'my.cnf' file after install...I found the
>following in /usr/share/mysql/:
>
>my-huge.cnf
>my-large.cnf
>my-medium.cnf
>my-small.cnf
>
>I guess these are example my.cnf files to use...If so, the next question
>which is the appropriate/best type?  

Just open them up in an editor and read what it says at the top.  Then copy the one 
you want to /etc/my.cnf


>I guess whatever choice should be
>renamed and located as 'my.cnf' in /var/lib/mysql directory?  I'm assuming
>the server on start-up reads this file and overrides compiled commands.

Not in the data dir.  You're telling it where to *look* for the data, right?  This 
would be your global settings and goes into /etc/my.cnf.


>Which section does the 'datadir=path/to/data/' command go...to the [mysqld]
>section?  

Yup.


>There is no mention of this command on:
>http://www.mysql.com/doc/O/p/Option_files.html

In a browser, open up the manual that came with your distro and do a search for 
'my.cnf'  Lots o' good stuff...  :>



>>>3. you can specify the data directory location as a configure option
>before compiling.<<
>
>Eventually, I will learn how to do this...but I opted for the RPM instead.
>I guess that is why I have these sort of configuration difficulties.
>
>Thanks again,
>Dennis Williams


Regards,
/Rob
--
Robert Alexander  ([EMAIL PROTECTED])  416-823-6599
http://www.workmate.ca  WWW Database Applications and Web Hosting

Searchable MySQL List Archive: http://archive.workmate.ca/myarchive

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

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

Re: MySQL RPM Install Problem - Ignorance

[DWilliams]

Robert,

Thanks for the tips...

>>1. create a symlink at /var/lib/mysql that points to your data directory<<

I had read that this might not be the best way prior to v4.0, something
about an
"alter table" statement might ignore the symlink?

>>2. you can change or add the 'datadir' variable in your my.cnf file
(usually /etc/my.cnf) see:<<

I apparently don't have a 'my.cnf' file after install...I found the
following in /usr/share/mysql/:

my-huge.cnf
my-large.cnf
my-medium.cnf
my-small.cnf

I guess these are example my.cnf files to use...If so, the next question
which is the appropriate/best type?  I guess whatever choice should be
renamed and located as 'my.cnf' in /var/lib/mysql directory?  I'm assuming
the server on start-up reads this file and overrides compiled commands.

Which section does the 'datadir=path/to/data/' command go...to the [mysqld]
section?  There is no mention of this command on:
http://www.mysql.com/doc/O/p/Option_files.html


>>3. you can specify the data directory location as a configure option
before compiling.<<

Eventually, I will learn how to do this...but I opted for the RPM instead.
I guess that is why I have these sort of configuration difficulties.

Thanks again,
Dennis Williams



- Original Message -
From: "Robert Alexander" <[EMAIL PROTECTED]>
To: "DWilliams" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, December 30, 2001 11:51 AM
Subject: Re: MySQL RPM Install Problem - Ignorance


> Hi Dennis,
>
> There's several ways you can move the datafile location:
>
> 1. create a symlink at /var/lib/mysql that points to your data directory
> 2. you can change or add the 'datadir' variable in your my.cnf file
(usually /etc/my.cnf) see:
http://www.mysql.com/doc/C/o/Configuring_MySQL.html
> 3. you can specify the data directory location as a configure option
before compiling.
>
> Lots about this issue in the archives, too. Take a look.
>
> Hope this helps,
>
> /Rob
>
>
>
> At 09:56 -0600 2001/12/30, DWilliams wrote:
> >Hi all,
> >
> >I have recently installed a MySQL server and client RPM 3.23.47 on a
Linux
> >system.  The system that I am setting up is a Cobalt RAQ4, first time for
me
> >to install MySQL on Linux.
> >
> >The installed datadir turned out to be /var/lib/mysql.  I get errors when
> >trying to move a very large MySQL data (800MB) directory from a previous
> >host system.  It turns out that the /var directory has it's own
partition, I
> >think.  A 'df' command shows not enough room on the /var directory for
the
> >MySQL data files.
> >
> >I am thinking I need to change the datadir variable to somewhere on the
> >/home directory, where I have > 15GB free.
> >
> >How can I achieve this?  Or is this the right approach?  I think I
> >understood that the server can be started up with a different --datadir
> >option, but I would like this to be more permanent in case of system
> >reboots.
> >
> >Thanks,
> >Dennis Williams
> --
> Robert Alexander  ([EMAIL PROTECTED])  416-823-6599
> http://www.workmate.ca  WWW Database Applications and Web Hosting
>
> Searchable MySQL List Archive: http://archive.workmate.ca/myarchive
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>



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

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

Re: MySQL RPM Install Problem - Ignorance

[Robert Alexander]

Hi Dennis,

There's several ways you can move the datafile location:

1. create a symlink at /var/lib/mysql that points to your data directory
2. you can change or add the 'datadir' variable in your my.cnf file (usually 
/etc/my.cnf) see: http://www.mysql.com/doc/C/o/Configuring_MySQL.html
3. you can specify the data directory location as a configure option before compiling.

Lots about this issue in the archives, too. Take a look.

Hope this helps,

/Rob



At 09:56 -0600 2001/12/30, DWilliams wrote:
>Hi all,
>
>I have recently installed a MySQL server and client RPM 3.23.47 on a Linux
>system.  The system that I am setting up is a Cobalt RAQ4, first time for me
>to install MySQL on Linux.
>
>The installed datadir turned out to be /var/lib/mysql.  I get errors when
>trying to move a very large MySQL data (800MB) directory from a previous
>host system.  It turns out that the /var directory has it's own partition, I
>think.  A 'df' command shows not enough room on the /var directory for the
>MySQL data files.
>
>I am thinking I need to change the datadir variable to somewhere on the
>/home directory, where I have > 15GB free.
>
>How can I achieve this?  Or is this the right approach?  I think I
>understood that the server can be started up with a different --datadir
>option, but I would like this to be more permanent in case of system
>reboots.
>
>Thanks,
>Dennis Williams
--
Robert Alexander  ([EMAIL PROTECTED])  416-823-6599
http://www.workmate.ca  WWW Database Applications and Web Hosting

Searchable MySQL List Archive: http://archive.workmate.ca/myarchive

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

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

MySQL RPM Install Problem - Ignorance

[DWilliams]

Hi all,

I have recently installed a MySQL server and client RPM 3.23.47 on a Linux
system.  The system that I am setting up is a Cobalt RAQ4, first time for me
to install MySQL on Linux.

The installed datadir turned out to be /var/lib/mysql.  I get errors when
trying to move a very large MySQL data (800MB) directory from a previous
host system.  It turns out that the /var directory has it's own partition, I
think.  A 'df' command shows not enough room on the /var directory for the
MySQL data files.

I am thinking I need to change the datadir variable to somewhere on the
/home directory, where I have > 15GB free.

How can I achieve this?  Or is this the right approach?  I think I
understood that the server can be started up with a different --datadir
option, but I would like this to be more permanent in case of system
reboots.

Thanks,
Dennis Williams


-
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: Newbie install problem

[Carsten H. Pedersen]

> I've just downloaded and installed the rpm (to RH7.1), thus:



> 
>PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
>This is done with:
>/usr/bin/mysqladmin -u root -p password 'new-password'
>/usr/bin/mysqladmin -u root -h potty.coho -p password 'new-password'

There's an error in that message: Don't use "-p". But
that's not all...



> So I tried to locate my copy of mysqladmin.  I don't have one.  I can't 
> find any mention of it on the MySQL site.  Where do I get it from? 

You need to get and install the MySQL-client-x-x-x.rpm as well...

/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq



-
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: Newbie install problem

[Luis A]

You know what i download a different on. go to rpmfind.net do a mysql
search. also down load the client plus the common ... 

it should work. 

if you have trouble let me know ok ...

Luis


On Wed, 2001-12-26 at 10:09, Richard Lyons wrote:
> I've just downloaded and installed the rpm (to RH7.1), thus:
> 
># rpm -iv MySQL-3.23.46-1.i386.rpm
>Preparing packages for installation...
>MySQL-3.23.46-1
>Preparing db table
>Preparing host table
>Preparing user table
>Preparing func table
>Preparing tables_priv table
>Preparing columns_priv table
>Installing all prepared tables
>011226 12:32:20  /usr/sbin/mysqld: Shutdown Complete
> 
> 
>PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
>This is done with:
>/usr/bin/mysqladmin -u root -p password 'new-password'
>/usr/bin/mysqladmin -u root -h potty.coho -p password 'new-password'
>See the manual for more instructions.
>
>Please report any problems with the /usr/bin/mysqlbug script!
> 
>The latest information about MySQL is available on the web at
>http://www.mysql.com
>Support MySQL by buying support/licenses at https://order.mysql.com
> 
>Starting mysqld daemon with databases from /var/lib/mysql
>
> Following the instructions given on screen, I immediately did:
>   
># /usr/bin/mysqladmin -u root -p password 'mynewpassword'
>bash: /usr/bin/mysqladmin: No such file or directory
> 
> So I tried to locate my copy of mysqladmin.  I don't have one.  I can't 
> find any mention of it on the MySQL site.  Where do I get it from? 
> 
> The installation seems otherwise complete, inasmuch as chkconfig now 
> shows mysqld in the right places.
> 
> Can anyone enlighten me?
> 
> --
> richard
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
-- 




-
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

Newbie install problem

[Richard Lyons]

I've just downloaded and installed the rpm (to RH7.1), thus:

   # rpm -iv MySQL-3.23.46-1.i386.rpm
   Preparing packages for installation...
   MySQL-3.23.46-1
   Preparing db table
   Preparing host table
   Preparing user table
   Preparing func table
   Preparing tables_priv table
   Preparing columns_priv table
   Installing all prepared tables
   011226 12:32:20  /usr/sbin/mysqld: Shutdown Complete


   PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
   This is done with:
   /usr/bin/mysqladmin -u root -p password 'new-password'
   /usr/bin/mysqladmin -u root -h potty.coho -p password 'new-password'
   See the manual for more instructions.
   
   Please report any problems with the /usr/bin/mysqlbug script!

   The latest information about MySQL is available on the web at
   http://www.mysql.com
   Support MySQL by buying support/licenses at https://order.mysql.com

   Starting mysqld daemon with databases from /var/lib/mysql
   
Following the instructions given on screen, I immediately did:
  
   # /usr/bin/mysqladmin -u root -p password 'mynewpassword'
   bash: /usr/bin/mysqladmin: No such file or directory

So I tried to locate my copy of mysqladmin.  I don't have one.  I can't 
find any mention of it on the MySQL site.  Where do I get it from? 

The installation seems otherwise complete, inasmuch as chkconfig now 
shows mysqld in the right places.

Can anyone enlighten me?

--
richard

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

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

Re: Install Problem

[Boyd Lynn Gerber]

On Wed, 28 Nov 2001, Arp, Jo-An wrote:
> This all started when the Boss asked for Mysql...and perl...and...
>
> I started by updating the installation of gcc (2.95). No problems.
> I installed perl (5.005_03) with gcc, again no problems.
> Except for gcc, no other configure flags were given to perl.
>
> Someone else installed a binary distribution of Mysql (3.23.43),
> and reported no problems. I can start/stop mysql, and it'll
> tell me the version, etc (taken from the "Post-Installation & Testing"
> section of the manual).
> So, from all accounts mysql works as expected.
>
> Repeated failed attempts to install Msql-Mysql-modules-1.2219. It fails on
> "make test". From the README file, the reason the driver can't load the
> mysql.so is because the linker doesn't include libgcc.a . To fix it, the
> README suggests I recompile perl or mysql. I figured mysql was the unknown,
> so I set out to recompile it. (The README also suggested one other fix, but
> that didn't work either.)

You need to make sure you have a FSU-threads library installed in
/usr/lib.  You can get this from ftp.mysql.com in the SCO directory or
There is another site listed on the Caldera(SCO) Programmer FAQ on

http://www.zenez.com/cgi-bin/scoprogfaq/faq.pl

The answer to you perl problem is also there.  Do a search for perl.  You
need to edit the mysql Makefile and add the -gthreads as instructed on the
FAQ page.

Good Luck,

--
Boyd Gerber <[EMAIL PROTECTED]>
ZENEZ   3748 Valley Forge Road, Magna Utah  84044
Office 801-250-0795 FAX 801-250-7975


-
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

Install Problem

[Arp, Jo-An]

This all started when the Boss asked for Mysql...and perl...and...

I started by updating the installation of gcc (2.95). No problems.
I installed perl (5.005_03) with gcc, again no problems. 
Except for gcc, no other configure flags were given to perl.

Someone else installed a binary distribution of Mysql (3.23.43), 
and reported no problems. I can start/stop mysql, and it'll 
tell me the version, etc (taken from the "Post-Installation & Testing" 
section of the manual). 
So, from all accounts mysql works as expected.

Repeated failed attempts to install Msql-Mysql-modules-1.2219. It fails on
"make test". From the README file, the reason the driver can't load the 
mysql.so is because the linker doesn't include libgcc.a . To fix it, the
README suggests I recompile perl or mysql. I figured mysql was the unknown,
so I set out to recompile it. (The README also suggested one other fix, but
that didn't work either.)

I downloaded a source distribution of mysql. Read the documentation, and
execute :
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions \
-fno-rtti" ./configure --prefix=/usr/local/mysql \
--enable-assembler --with-mysqld-ldflags=-all-static --with-low-memory

Then "make". It runs for a bit (20-25 minutes) and then dies with :
...
mkdir .libs
gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -DSCO
-fno
-implicit-templates -fno-exceptions -fno-rtti -o mysqld sql_lex.o item.o
item_su
m.o item_buff.o item_func.o item_cmpfunc.o item_strfunc.o item_timefunc.o
thr_ma
lloc.o item_create.o field.o key.o sql_class.o sql_list.o net_serv.o
violite.o n
et_pkg.o lock.o my_lock.o sql_string.o sql_manager.o sql_map.o mysqld.o
password
.o hash_filo.o hostname.o convert.o sql_parse.o sql_yacc.o sql_base.o
table.o sq
l_select.o sql_insert.o sql_update.o sql_delete.o procedure.o item_uniq.o
sql_te
st.o log.o log_event.o init.o derror.o sql_acl.o unireg.o time.o opt_range.o
opt
_sum.o opt_ft.o records.o filesort.o handler.o ha_heap.o ha_myisam.o
ha_myisammr
g.o ha_berkeley.o ha_innobase.o ha_gemini.o ha_isam.o ha_isammrg.o sql_db.o
sql_
table.o sql_rename.o sql_crypt.o sql_load.o mf_iocache.o field_conv.o
sql_show.o
 sql_udf.o sql_analyse.o sql_cache.o slave.o sql_repl.o mini_client.o
mini_clien
t_errors.o md5.o stacktrace.o -static ../isam/libnisam.a ../merge/libmerge.a
../
myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a
../mysys/libmys
ys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -ldl
-lgthr
eads -lsocket -lgthreads -lcrypt -lm -lgthreads -lsocket -lgthreads
 fatal error: library not found: -ldl
collect2: ld returned 1 exit status
*** Error code 1 (bu21)
*** Error code 1 (bu21)
*** Error code 1 (bu21)
*** Error code 1 (bu21)

I've applied to svr5.sh patch (and set LD_LIBRARY_PATH as it suggests),
but the result doesn't change.

HELP!

Cheers,
Jo-an


Release:mysql-3.23.43 (Source distribution)
Server: lt-mysqladmin  Ver 8.21 Distrib 3.23.43, for pc-sco3.2v5.0.6 on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.36
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 23 hours 13 min 45 sec

Threads: 1  Questions: 2  Slow queries: 0  Opens: 5  Flush tables: 1  Open
tables: 0 Queries per second avg: 0.000
>Environment:

System: SCO_SV mm242a 3.2 5.0.6 i386


Some paths:  /usr/bin/perl /bin/make /usr/local/bin/gmake /usr/local/bin/gcc
/bin/cc
GCC: Reading specs from
/usr/local/lib/gcc-lib/i686-pc-sco3.2v5.0.6/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc'  CFLAGS=' '  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx   1 root sys   35 Nov  9 12:49 /lib/libc.a ->
/opt/K/SCO/unixds/5.1.2A/lib/libc.a
lrwxrwxrwx   1 root sys   36 Nov  9 12:49 /lib/libc.so ->
/opt/K/SCO/unixds/5.1.2A/lib/libc.so
lrwxrwxrwx   1 root sys   39 Nov  9 12:49 /usr/lib/libc.a ->
/opt/K/SCO/unixds/5.1.2A/usr/lib/libc.a
lrwxrwxrwx   1 root sys   40 Nov  9 12:49 /usr/lib/libc.so ->
/opt/K/SCO/unixds/5.1.2A/usr/lib/libc.so
lrwxrwxrwx   1 root root  41 Apr 10  2001 /usr/lib/libc.so.1 ->
/opt/K/SCO/Unix/5.0.6Ga/usr/lib/libc.so.1
Configure command: ./configure  --prefix=/usr/local/mysql
Perl: This is perl, version 5.005_03 built for i386-sco

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

[Sinisa Milivojevic]

VIDAL Thomas writes:
> Hello,
> 
> I have a problem to install Mysql Source (3.23.39) I have gcc (2.96) but
> at the start ./configure i have :
> 
> cheking for gcc... gcc
> checking whether the c compiler (gcc ) works... no
> configure: error: ... C compiler cannot create executable
> 
> 
> Can you help me please ??
> Must i install an other compiler ???
> 
> Thank you
> 
> 
> 
> 
> 
> 
> VIDAL Thomas
> Service Informatique
> CIHEAM-IAMM
> 04.67.04.60.24
> [EMAIL PROTECTED]
> ¤¤
> Envie de vacances ??
> D'un grand bol d'air ??
> http://www.giteslozere.com
> La Location de gîtes en lozère
> ¤¤
> 

Please try gcc 2.95.2 and follow other instructions from the manual
for your OS. 

Also, if there is a binary for your OS, skip the building part.

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

install problem

[VIDAL Thomas]

Hello,

I have a problem to install Mysql Source (3.23.39) I have gcc (2.96) but
at the start ./configure i have :

cheking for gcc... gcc
checking whether the c compiler (gcc ) works... no
configure: error: ... C compiler cannot create executable


Can you help me please ??
Must i install an other compiler ???

Thank you






VIDAL Thomas
Service Informatique
CIHEAM-IAMM
04.67.04.60.24
[EMAIL PROTECTED]
¤¤
Envie de vacances ??
D'un grand bol d'air ??
http://www.giteslozere.com
La Location de gîtes en lozère
¤¤


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

[oltra jean-michel]

> Installing mysql on solaris 6 sun4u sparc SUNW,Ultra-5_10
> release:
>
>  -- mysql-3.23.38.tar.gz
>
> via
> ./configure --prefix=/dir --with-low-memory

Is that really what you type: --prefix=/dir ?
strange name for a DIRectory? Can be a reserved word.
> make
> make install
>
> I get to:
>
> yacc  -d sql_yacc.yy && mv y.tab.c sql_yacc.cc
> "sql_yacc.yy", line 71: fatal: invalid escape, or illegal reserved word:
> pure_parser
> make[2]: *** [sql_yacc.cc] Error 1
> make[2]: Leaving directory `/home/smith/solaris.6/mysql/sql'
> make[1]: *** [install-recursive] Error 1
> make[1]: Leaving directory `/home/smith/solaris.6/mysql/sql'
> make: *** [install-recursive] Error 1
>
> Any ideas?
>
> thanks
>
>
>
>
>
>
>
> -
> 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
>

jean-michel


-
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

install problem

[Sonia Van Tassel]

Hi all,

Installing mysql on solaris 6 sun4u sparc SUNW,Ultra-5_10
release:

 -- mysql-3.23.38.tar.gz

via
./configure --prefix=/dir --with-low-memory
make
make install

I get to:

yacc  -d sql_yacc.yy && mv y.tab.c sql_yacc.cc
"sql_yacc.yy", line 71: fatal: invalid escape, or illegal reserved word:
pure_parser
make[2]: *** [sql_yacc.cc] Error 1
make[2]: Leaving directory `/home/smith/solaris.6/mysql/sql'
make[1]: *** [install-recursive] Error 1
make[1]: Leaving directory `/home/smith/solaris.6/mysql/sql'
make: *** [install-recursive] Error 1

Any ideas?

thanks







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

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

Re: Mysql DBI install problem

[Brooklyn Linux Solutions]

Yes

That was the trouble.

Thanks

I just upgraded the entire thing while I was at it,
perl 5.6, DBI, mod_perl, embperl



Thank you very much.  I thought I did get the latest version.  Maybe I go a
pre-release version.

Ruben



On 2001.06.11 11:06:01 -0400 Dave FitzPatrick wrote:
Ruben,

I ran into the same thing on a Compaq Tru64 box last week.  Version 
1.1835 of the Msql-Mysql-modules is WAY out of date.  For some reason 
it is still listed in the CPAN database if you try to install 
Bundle::Mysql or Bundle::Msql.

Try again by:

cpan> install J/JW/JWIED/Msql-Mysql-modules-1.2216.tar.gz

This way you will be sure to get the correct version.

Hope this helps,
D=

On 11 Jun 2001, at 8:09, Brooklyn Linux Solutions <[EMAIL PROTECTED]>
wrote:

> I have a slackware box with Apache Perl 5.6, DBI and mod_perl.  I can't
get
> the MYSQL DBI module to install.  It's dieing on this line.
> 
> I'm very perplexed.
> 
> Ruben
> 
> umask -a
> Linux vidor 2.2.13 #127 Thu Oct 21 13:13:20 CDT 1999 i686 unknown
> 
> 
> 
> make[1]: Entering directory `/root/.cpan/build/Msql-Mysql-modules-1.1835/Mysql'
> cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
> -I/usr/local/include/mysql -I../dbd 
-I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
> -I/usr/local/lib/perl5/5.6.1/i686-linux -fno-strict-aliasing
> -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2  
> -DVERSION=\"1.1835\" -DXS_VERSION=\"1.1835\" -fpic
> -I/usr/local/lib/perl5/5.6.1/i686-linux/CORE -DDBD_MYSQL
> 
> Mysql.xs: In function `XS_Mysql_listdbs':
> Mysql.xs:945: `sv_undef' undeclared (first use in this function)
> Mysql.xs:949: `dowarn' undeclared (first use in this function)
> Mysql.xs: In function `XS_Mysql_listtables':
> Mysql.xs:970: `sv_undef' undeclared (first use in this function)
> Mysql.xs:974: `dowarn' undeclared (first use in this function)
> Mysql.xs: In function `XS_Mysql_listfields':
> Mysql.xs:1005: `dowarn' undeclared (first use in this function)
> make[1]: *** [Mysql.o] Error 1
> make[1]: Leaving directory `/root/.cpan/build/Msql-Mysql-modules-1.1835/Mysql'
> make: *** [subdirs] Error 2
> 
> -- 
> Brooklyn Linux Solutions
> http://www.mrbrklyn.com
> http://www.brooklynonline.com
> 
> 1-718-382-5752
> 
> -- 
> Brooklyn Linux Solutions
> http://www.mrbrklyn.com
> http://www.brooklynonline.com
> 
> 1-718-382-5752
> 
> -
> 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
> 
> 


-- 
 Dave FitzPatrick   [EMAIL PROTECTED]
 Webmaster  978-681-1599
 Quantic Communications An MHI Company  http://www.quantic.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


-- 
Brooklyn Linux Solutions
http://www.mrbrklyn.com
http://www.brooklynonline.com

1-718-382-5752

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

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

Re: Mysql DBI install problem

[Dave FitzPatrick]

Ruben,

I ran into the same thing on a Compaq Tru64 box last week.  Version 
1.1835 of the Msql-Mysql-modules is WAY out of date.  For some reason 
it is still listed in the CPAN database if you try to install 
Bundle::Mysql or Bundle::Msql.

Try again by:

cpan> install J/JW/JWIED/Msql-Mysql-modules-1.2216.tar.gz

This way you will be sure to get the correct version.

Hope this helps,
D=

On 11 Jun 2001, at 8:09, Brooklyn Linux Solutions <[EMAIL PROTECTED]> wrote:

> I have a slackware box with Apache Perl 5.6, DBI and mod_perl.  I can't get
> the MYSQL DBI module to install.  It's dieing on this line.
> 
> I'm very perplexed.
> 
> Ruben
> 
> umask -a
> Linux vidor 2.2.13 #127 Thu Oct 21 13:13:20 CDT 1999 i686 unknown
> 
> 
> 
> make[1]: Entering directory `/root/.cpan/build/Msql-Mysql-modules-1.1835/Mysql'
> cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
> -I/usr/local/include/mysql -I../dbd  
>-I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
> -I/usr/local/lib/perl5/5.6.1/i686-linux -fno-strict-aliasing
> -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2  
> -DVERSION=\"1.1835\" -DXS_VERSION=\"1.1835\" -fpic
> -I/usr/local/lib/perl5/5.6.1/i686-linux/CORE -DDBD_MYSQL
> 
> Mysql.xs: In function `XS_Mysql_listdbs':
> Mysql.xs:945: `sv_undef' undeclared (first use in this function)
> Mysql.xs:949: `dowarn' undeclared (first use in this function)
> Mysql.xs: In function `XS_Mysql_listtables':
> Mysql.xs:970: `sv_undef' undeclared (first use in this function)
> Mysql.xs:974: `dowarn' undeclared (first use in this function)
> Mysql.xs: In function `XS_Mysql_listfields':
> Mysql.xs:1005: `dowarn' undeclared (first use in this function)
> make[1]: *** [Mysql.o] Error 1
> make[1]: Leaving directory `/root/.cpan/build/Msql-Mysql-modules-1.1835/Mysql'
> make: *** [subdirs] Error 2
> 
> -- 
> Brooklyn Linux Solutions
> http://www.mrbrklyn.com
> http://www.brooklynonline.com
> 
> 1-718-382-5752
> 
> -- 
> Brooklyn Linux Solutions
> http://www.mrbrklyn.com
> http://www.brooklynonline.com
> 
> 1-718-382-5752
> 
> -
> 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
> 
> 


-- 
 Dave FitzPatrick   [EMAIL PROTECTED]
 Webmaster  978-681-1599
 Quantic Communications An MHI Company  http://www.quantic.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

Mysql DBI install problem

[Brooklyn Linux Solutions]

I have a slackware box with Apache Perl 5.6, DBI and mod_perl.  I can't get
the MYSQL DBI module to install.  It's dieing on this line.

I'm very perplexed.

Ruben

umask -a
Linux vidor 2.2.13 #127 Thu Oct 21 13:13:20 CDT 1999 i686 unknown



make[1]: Entering directory `/root/.cpan/build/Msql-Mysql-modules-1.1835/Mysql'
cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
-I/usr/local/include/mysql -I../dbd  
-I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
-I/usr/local/lib/perl5/5.6.1/i686-linux -fno-strict-aliasing
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2  
-DVERSION=\"1.1835\" -DXS_VERSION=\"1.1835\" -fpic
-I/usr/local/lib/perl5/5.6.1/i686-linux/CORE -DDBD_MYSQL

Mysql.xs: In function `XS_Mysql_listdbs':
Mysql.xs:945: `sv_undef' undeclared (first use in this function)
Mysql.xs:949: `dowarn' undeclared (first use in this function)
Mysql.xs: In function `XS_Mysql_listtables':
Mysql.xs:970: `sv_undef' undeclared (first use in this function)
Mysql.xs:974: `dowarn' undeclared (first use in this function)
Mysql.xs: In function `XS_Mysql_listfields':
Mysql.xs:1005: `dowarn' undeclared (first use in this function)
make[1]: *** [Mysql.o] Error 1
make[1]: Leaving directory `/root/.cpan/build/Msql-Mysql-modules-1.1835/Mysql'
make: *** [subdirs] Error 2

-- 
Brooklyn Linux Solutions
http://www.mrbrklyn.com
http://www.brooklynonline.com

1-718-382-5752

-- 
Brooklyn Linux Solutions
http://www.mrbrklyn.com
http://www.brooklynonline.com

1-718-382-5752

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

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

mysql DBI install problem

[Brooklyn Linux Solutions]

I have a slackware box with Apache Perl 5.6, DBI and mod_perl.  I can't get
the MYSQL DBI module to install.  It's dieing on this line.

I'm very perplexed.

Ruben

umask -a
Linux vidor 2.2.13 #127 Thu Oct 21 13:13:20 CDT 1999 i686 unknown



make[1]: Entering directory `/root/.cpan/build/Msql-Mysql-modules-1.1835/Mysql'
cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
-I/usr/local/include/mysql -I../dbd  
-I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
-I/usr/local/lib/perl5/5.6.1/i686-linux -fno-strict-aliasing
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2  
-DVERSION=\"1.1835\" -DXS_VERSION=\"1.1835\" -fpic
-I/usr/local/lib/perl5/5.6.1/i686-linux/CORE -DDBD_MYSQL

Mysql.xs: In function `XS_Mysql_listdbs':
Mysql.xs:945: `sv_undef' undeclared (first use in this function)
Mysql.xs:949: `dowarn' undeclared (first use in this function)
Mysql.xs: In function `XS_Mysql_listtables':
Mysql.xs:970: `sv_undef' undeclared (first use in this function)
Mysql.xs:974: `dowarn' undeclared (first use in this function)
Mysql.xs: In function `XS_Mysql_listfields':
Mysql.xs:1005: `dowarn' undeclared (first use in this function)
make[1]: *** [Mysql.o] Error 1
make[1]: Leaving directory `/root/.cpan/build/Msql-Mysql-modules-1.1835/Mysql'
make: *** [subdirs] Error 2

-- 
Brooklyn Linux Solutions
http://www.mrbrklyn.com
http://www.brooklynonline.com

1-718-382-5752

-
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: New install Problem

[Sinisa Milivojevic]

rjtalbo writes:
> Paul
>  I am a newbie regarding MySQL but have been using Postgresql, DB2 and
> for years Sybase..
>  My installations are Linux (Caldera 2.3 & 2.4), OS/2 and WinNt.
> My needs are a lan / Wan database..encompassing above OS's.
> Problems: DB2 in Lan format too expensive
> Postgresql w/ JDBC will not compile on Caldera edesktop.
> Sybase 11 not available for OS/2..
> Mysql compiled nicely on Caldera and msql2-3.22.26a installed easily on
> OS/2.
> 1/  But on OS/2 I get this error version 3.22.26a
>mysql> mysqladmin -u ME password 'topsecret'
> process terminated by SIGSEGV
> C:\
>(this happens on 2 OS/2 machines) but not on Linux..
> 
> 2/  Also is there a JDBC for OS\2 or ODBC either which I can use for
> MySQL with OS/2.. If not what do you suggest for application/bridge
> development language on OS/2..
> 
> Thank You
> Bob T
> 


HI!

One user is developing latest MySQL version for OS/2.

In a few weeks time it should appear as a contributed binary on the
download page.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers 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

New install Problem

[rjtalbo]

Paul
 I am a newbie regarding MySQL but have been using Postgresql, DB2 and
for years Sybase..
 My installations are Linux (Caldera 2.3 & 2.4), OS/2 and WinNt.
My needs are a lan / Wan database..encompassing above OS's.
Problems: DB2 in Lan format too expensive
Postgresql w/ JDBC will not compile on Caldera edesktop.
Sybase 11 not available for OS/2..
Mysql compiled nicely on Caldera and msql2-3.22.26a installed easily on
OS/2.
1/  But on OS/2 I get this error version 3.22.26a
   mysql> mysqladmin -u ME password 'topsecret'
process terminated by SIGSEGV
C:\
   (this happens on 2 OS/2 machines) but not on Linux..

2/  Also is there a JDBC for OS\2 or ODBC either which I can use for
MySQL with OS/2.. If not what do you suggest for application/bridge
development language on OS/2..

Thank You
Bob T


-
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

Install problem

[[EMAIL PROTECTED]]

Hi,

I try to install mysql 3.23.27-beta, but when i execute ./configure 
--prefix=/usr/local/mysql i ha ve an error message saying that it can't create 
executable file
so i install gcc 2.95.2 and make 3.77, but it's same

What can i do?

François

Re: Install problem

[David]

> I am having a problem installing the MyODBC drivers. I run setup but
> nothing happens. Any ideas?
>
> David



[EMAIL PROTECTED] wrote:

> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,query
>
> If you just reply to this message, and include the entire text of it in the
> reply, your reply will go through. However, you should
> first review the text of the message to make sure it has something to do
> with MySQL. You have written the following:
>
> I am having a problem installing the MyODBC drivers. I run setup but
> nothing happens. Any ideas?
>
> David


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

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

Re: mysql install problem

[Rolf Hopkins]

May mean that it is already running.  Check with ps -ef | grep mysqld

- Original Message -
From: "Xiaowu Gai" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 05, 2001 6:07
Subject: mysql install problem


> Hi:
>
> I tried to install mysql on my machine. So I download the binary tarball
> and proceed according to the instruction in the INSTALL file (same problem
> happened for two different versions that I tried). However, when I tried
to
> run the last step "bin/safe_mysqld --user=mysql &". It says mysqld ended
> and just hangs there. Nothings seems to be happening. Can someone tell me
> what's going on? Thank you very much.
>
> Xiaowu
>
> Xiaowu Gai
> 2104 Molecular Biology Building
> Department of Zoology & Genetics
> Iowa State University
> Ames, IA 50010
> Tel: (515)-2940022
>
>
> -
> 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

mysql install problem

[Xiaowu Gai]

Hi:

I tried to install mysql on my machine. So I download the binary tarball 
and proceed according to the instruction in the INSTALL file (same problem 
happened for two different versions that I tried). However, when I tried to 
run the last step "bin/safe_mysqld --user=mysql &". It says mysqld ended 
and just hangs there. Nothings seems to be happening. Can someone tell me 
what's going on? Thank you very much.

Xiaowu

Xiaowu Gai
2104 Molecular Biology Building
Department of Zoology & Genetics
Iowa State University
Ames, IA 50010
Tel: (515)-2940022


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

[Rolf Hopkins]

These are usually FAQs but your getting both which seems strange. "mysqld
ended" usually means that mysqld has already started but the other says it's
not.  What does "ps -ef | grep mysql" give you?  Also check your
permissions.  Log files should be located in /var/lib/mysql

- Original Message -
From: "Dane Knudson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 9:59
Subject: Install problem


I have installed MySQL by running  mysql_install_db after completing the
installation of RH Linux 7.1 from scratch.  The file seems to indicate
that it installs OK.  When I try to start the server from the command
line it get a message that says "Starting mysqld daemon with databases
from /var/lib/mysql", next line gives that date and time and says
"mysqld ended".  I then have to hit enter to get a prompt back.

If I try to use the "mysqladmin version" commend I get the following
error:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket:
'/var/mysql/mysqld.sock' exists!

The file mysql.sock is in the right place but I can't open the file even
as root.  I have also looked for an error log, but haven't found one
yet.

Any help would be appreciated.

The machine does have two NIC's, though one has been disabled.
Dane Knudson
Account Manager - Technical
Freedom Technologies
Level 20, Tower 2
500 Oxford Street
Bondi Junction NSW 2022
Australia
Tel: +61 (0) 2 9386-1777
Fax: +61 (0) 2 9386-1577
Mobile: 0417 252697
E-mail:[EMAIL PROTECTED]
www.freedomtechnologies.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

Install problem

[Dane Knudson]

I have installed MySQL by running  mysql_install_db after completing the
installation of RH Linux 7.1 from scratch.  The file seems to indicate
that it installs OK.  When I try to start the server from the command
line it get a message that says "Starting mysqld daemon with databases
from /var/lib/mysql", next line gives that date and time and says
"mysqld ended".  I then have to hit enter to get a prompt back.

If I try to use the "mysqladmin version" commend I get the following
error:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket:
'/var/mysql/mysqld.sock' exists!

The file mysql.sock is in the right place but I can't open the file even
as root.  I have also looked for an error log, but haven't found one
yet.

Any help would be appreciated.

The machine does have two NIC's, though one has been disabled.
Dane Knudson
Account Manager - Technical
Freedom Technologies
Level 20, Tower 2
500 Oxford Street
Bondi Junction NSW 2022
Australia
Tel: +61 (0) 2 9386-1777
Fax: +61 (0) 2 9386-1577
Mobile: 0417 252697
E-mail:[EMAIL PROTECTED]
www.freedomtechnologies.com 

Re: more on the install problem

[Gerald Clark]

Well, where IS the socket?

If it is not where mysqladmin is looking, then you should add to
/etc/my.cnf:

[client]
socket=/tmp/mysql.sock

Substituting the correct full path/name for the socket.

Make sure /etc/my.cnf is world readable.

Mike Millner wrote:
> 
> I've narrowed it down some. I'm not finding the answer in archives. From the
> manual I found these commands:
> 
> shell> mysqladmin version
> shell> mysqladmin variables
> shell> mysqladmin -h `hostname` version variables
> shell> mysqladmin -h `hostname` --port=3306 version
> shell> mysqladmin -h 'ip for your host' version
> shell> mysqladmin --socket=/tmp/mysql.sock version
> 
> All these work except the first two. I tried changing the permission on /tmp
> to mysql:mysql for owner and group
> 
> I don't know what else to do. Its like mysqladmin can't find the path to
> /tmp if I don't provide the full path.
> 
> Please, any hints :)
> Thanks,
> Mike
> 
> >
> > > Hello,
> > > I just installed mysql 3.23.36 on a Debian Potato system. I know your
> > going
> > > to tell me to read the manual. I have been and will continue.
> > >
> > > Any help would be greatly appreciated.
> > >
> > > Thanks,
> > > Mike
> > >
> > > I have (at least) two problems
> > >
> > > When I do a ps-ef | grep mysqld:
> > > root 19004 25880  0 20:04 pts/100:00:00 sh
> > > /usr/local/mysql/bin/safe_mysqld --user
> > > =mysql
> > > mysql19024 19004  0 20:04 pts/100:00:00
> > > /usr/local/mysql/libexec/mysqld --basedir=
> > >
> >
> /usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr
> > > /local/mysql/v
> > > ar/mail.mikeshome.com.pid --skip-locking
> > > mysql19026 19024  0 20:04 pts/100:00:00
> > > /usr/local/mysql/libexec/mysqld --basedir=
> > >
> >
> /usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr
> > > /local/mysql/v
> > > ar/mail.mikeshome.com.pid --skip-locking
> > > mysql19027 19026  0 20:04 pts/100:00:00
> > > /usr/local/mysql/libexec/mysqld --basedir=
> > >
> >
> /usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr
> > > /local/mysql/v
> > > ar/mail.mikeshome.com.pid --skip-locking
> > > root 19104 25880  0 20:40 pts/100:00:00 grep mysqld
> > >
> > >
> > >
> > > The server appears to be running. I'm new to mysql but that looks like
> > > running.
> > >
> > > If I do a :/usr/local/mysql# /usr/bin/mysqladmin version
> > > /usr/bin/mysqladmin: connect to server at 'localhost' failed
> > > error: 'Can't connect to local MySQL server through socket
> > > '/var/run/mysqld/mysqld.sock' (
> > > 111)'
> > > Check that mysqld is running and that the socket:
> > > '/var/run/mysqld/mysqld.sock' exists!
> > >
> >
> > Two other people have had this exact same problem in the last 24hrs.
> Please
> > lookup the archive of the list to find your answer to this one.
> >
> > >
> > > If I do a : /usr/local/mysql/bin/mysqladmin -u root -p password
> > > Enter password:
> > > /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
> > > error: 'Access denied for user: 'root@localhost' (Using password: YES)'
> > >
> >
> > If this is a fresh installation, root currently has no password.
> >  mysqladmin -u root will suffice.  Also there is no space between -p and
> > your password when you do finally get around to changing it.
> >
> > >

-
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

more on the install problem

[Mike Millner]

I've narrowed it down some. I'm not finding the answer in archives. From the
manual I found these commands:

shell> mysqladmin version
shell> mysqladmin variables
shell> mysqladmin -h `hostname` version variables
shell> mysqladmin -h `hostname` --port=3306 version
shell> mysqladmin -h 'ip for your host' version
shell> mysqladmin --socket=/tmp/mysql.sock version


All these work except the first two. I tried changing the permission on /tmp
to mysql:mysql for owner and group

I don't know what else to do. Its like mysqladmin can't find the path to
/tmp if I don't provide the full path.

Please, any hints :)
Thanks,
Mike

>
> > Hello,
> > I just installed mysql 3.23.36 on a Debian Potato system. I know your
> going
> > to tell me to read the manual. I have been and will continue.
> >
> > Any help would be greatly appreciated.
> >
> > Thanks,
> > Mike
> >
> > I have (at least) two problems
> >
> > When I do a ps-ef | grep mysqld:
> > root 19004 25880  0 20:04 pts/100:00:00 sh
> > /usr/local/mysql/bin/safe_mysqld --user
> > =mysql
> > mysql19024 19004  0 20:04 pts/100:00:00
> > /usr/local/mysql/libexec/mysqld --basedir=
> >
>
/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr
> > /local/mysql/v
> > ar/mail.mikeshome.com.pid --skip-locking
> > mysql19026 19024  0 20:04 pts/100:00:00
> > /usr/local/mysql/libexec/mysqld --basedir=
> >
>
/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr
> > /local/mysql/v
> > ar/mail.mikeshome.com.pid --skip-locking
> > mysql19027 19026  0 20:04 pts/100:00:00
> > /usr/local/mysql/libexec/mysqld --basedir=
> >
>
/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr
> > /local/mysql/v
> > ar/mail.mikeshome.com.pid --skip-locking
> > root 19104 25880  0 20:40 pts/100:00:00 grep mysqld
> >
> >
> >
> > The server appears to be running. I'm new to mysql but that looks like
> > running.
> >
> > If I do a :/usr/local/mysql# /usr/bin/mysqladmin version
> > /usr/bin/mysqladmin: connect to server at 'localhost' failed
> > error: 'Can't connect to local MySQL server through socket
> > '/var/run/mysqld/mysqld.sock' (
> > 111)'
> > Check that mysqld is running and that the socket:
> > '/var/run/mysqld/mysqld.sock' exists!
> >
>
> Two other people have had this exact same problem in the last 24hrs.
Please
> lookup the archive of the list to find your answer to this one.
>
> >
> > If I do a : /usr/local/mysql/bin/mysqladmin -u root -p password
> > Enter password:
> > /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
> > error: 'Access denied for user: 'root@localhost' (Using password: YES)'
> >
>
> If this is a fresh installation, root currently has no password.
>  mysqladmin -u root will suffice.  Also there is no space between -p and
> your password when you do finally get around to changing it.
>
> >
> > -
> > 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: install problem

[Rolf Hopkins]

- Original Message -
From: "Mike Millner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 12, 2001 10:49
Subject: install problem


> Hello,
> I just installed mysql 3.23.36 on a Debian Potato system. I know your
going
> to tell me to read the manual. I have been and will continue.
>
> Any help would be greatly appreciated.
>
> Thanks,
> Mike
>
> I have (at least) two problems
>
> When I do a ps-ef | grep mysqld:
> root 19004 25880  0 20:04 pts/100:00:00 sh
> /usr/local/mysql/bin/safe_mysqld --user
> =mysql
> mysql19024 19004  0 20:04 pts/100:00:00
> /usr/local/mysql/libexec/mysqld --basedir=
>
/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr
> /local/mysql/v
> ar/mail.mikeshome.com.pid --skip-locking
> mysql19026 19024  0 20:04 pts/100:00:00
> /usr/local/mysql/libexec/mysqld --basedir=
>
/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr
> /local/mysql/v
> ar/mail.mikeshome.com.pid --skip-locking
> mysql19027 19026  0 20:04 pts/100:00:00
> /usr/local/mysql/libexec/mysqld --basedir=
>
/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr
> /local/mysql/v
> ar/mail.mikeshome.com.pid --skip-locking
> root 19104 25880  0 20:40 pts/100:00:00 grep mysqld
>
>
>
> The server appears to be running. I'm new to mysql but that looks like
> running.
>
> If I do a :/usr/local/mysql# /usr/bin/mysqladmin version
> /usr/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock' (
> 111)'
> Check that mysqld is running and that the socket:
> '/var/run/mysqld/mysqld.sock' exists!
>

Two other people have had this exact same problem in the last 24hrs.  Please
lookup the archive of the list to find your answer to this one.

>
> If I do a : /usr/local/mysql/bin/mysqladmin -u root -p password
> Enter password:
> /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: YES)'
>

If this is a fresh installation, root currently has no password.
 mysqladmin -u root will suffice.  Also there is no space between -p and
your password when you do finally get around to changing it.

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

install problem

[Mike Millner]

Hello,
I just installed mysql 3.23.36 on a Debian Potato system. I know your going
to tell me to read the manual. I have been and will continue.

Any help would be greatly appreciated.

Thanks,
Mike

I have (at least) two problems

When I do a ps-ef | grep mysqld:
root 19004 25880  0 20:04 pts/100:00:00 sh
/usr/local/mysql/bin/safe_mysqld --user
=mysql
mysql19024 19004  0 20:04 pts/100:00:00
/usr/local/mysql/libexec/mysqld --basedir=
/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr
/local/mysql/v
ar/mail.mikeshome.com.pid --skip-locking
mysql19026 19024  0 20:04 pts/100:00:00
/usr/local/mysql/libexec/mysqld --basedir=
/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr
/local/mysql/v
ar/mail.mikeshome.com.pid --skip-locking
mysql19027 19026  0 20:04 pts/100:00:00
/usr/local/mysql/libexec/mysqld --basedir=
/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr
/local/mysql/v
ar/mail.mikeshome.com.pid --skip-locking
root 19104 25880  0 20:40 pts/100:00:00 grep mysqld



The server appears to be running. I'm new to mysql but that looks like
running.

If I do a :/usr/local/mysql# /usr/bin/mysqladmin version
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (
111)'
Check that mysqld is running and that the socket:
'/var/run/mysqld/mysqld.sock' exists!



If I do a : /usr/local/mysql/bin/mysqladmin -u root -p password
Enter password:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'



-
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

solaris 2.6 install problem

[Greg Wejrowski]

I can get the basic compiled version installed, but when I run
scrpits/mysql_install_db I get the following error.
ld.so.1: ./bin/mysql: fatal: libcrypt_i.so.1: open failed: No such file
or directory.

I'm a neebie when it come to Solaris sysadmin.. I've done a find and can
locate a file called
libcrypt_i.so.1, but I can find a file called libcrypt_i.a in the
/usr/lib directory..
I installed mysql in x86 linux box with little problem.
Any help would be appreciated..
V/R Greg Wejrowski (wedge)



-
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