Starting .36 with innobase failed on HPUX-11 / problem with my.cnf

2001-04-05 Thread Andre . Konopka

Hi,

after succesfully compiling mysql-3.23.36 on my HP-UX11 box (Heikki, thank you
for your hints), I can't start start the DB with the start.server script.

I created a /etc/my.cnf file with the following values:

[mysqld]
innobase_data_home_dir = /opt/mysql/var/
innobase_log_group_home_dir = /opt/mysql/var
innobase_log_arch_dir = /opt/mysql/mysql/var
innobase_data_file_path = ib_data1:10M
set-variable = innobase_mirrored_log_groups=1
set-variable = innobase_log_files_in_group=3
set-variable = innobase_log_file_size=5M
set-variable = innobase_log_buffer_size=8M
innobase_flush_log_at_trx_commit=1
innobase_log_archive=0
set-variable = innobase_buffer_pool_size=16M
set-variable = innobase_additional_mem_pool_size=2M
set-variable = innobase_file_io_threads=4
set-variable = innobase_lock_wait_timeout=50
~


After starting I found the following error in the .err file:

010405 14:30:32  mysqld started
/opt/mysql/libexec/mysqld: unrecognized option `--~'
/opt/mysql/libexec/mysqld  Ver 3.23.36 for hp-hpux11.00 on hppa1.1
Copyright (C) 2000 MySQL AB  MySQL Finland AB, by Monty and others
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Starts the MySQL server

Usage: /opt/mysql/libexec/mysqld [OPTIONS]

  --ansiUse ANSI SQL s.

snip


After removing the /etc/my.cnf file the server starts sucessfully, but without
initializing the innobase stuff because the necessary pathes/variables are not
set.

Okay, second I tried, sucessfully, to start mysqld manually with the
following commandline

 /opt/mysql/libexec/mysqld --user=mysql --basedir=/opt/mysql \ 
--datadir=/opt/mysql/var --innobase_data_home_dir=/opt/mysql/var/ \
--innobase_data_file_path=ib_data1:10M


I suppose that mysqld (on HP-UX11) doesn't handle the my.cnf options
correctly???

By the way, I need to append a '/' at the end of the innobase_data_home_dir
path in contrast to documentation. 

Greetings from Germany 

Andre


--
E-Mail: [EMAIL PROTECTED]
Date: 05-Apr-01
Time: 14:20:03

()  Join the ASCII ribbon campaign against html email
/\  and Microsoft attachments.

"I heard if you play the NT-4.0-CD backwards, you get a satanic message"
"That is nothing, if you play it forward, it installs NT-4.0"

--

-
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: Starting .36 with innobase failed on HPUX-11 / problem with my.cnf

2001-04-05 Thread Sinisa Milivojevic

[EMAIL PROTECTED] writes:
  Hi,
  
  after succesfully compiling mysql-3.23.36 on my HP-UX11 box (Heikki, thank you
  for your hints), I can't start start the DB with the start.server script.
  
  I created a /etc/my.cnf file with the following values:
  
  [mysqld]
  innobase_data_home_dir = /opt/mysql/var/
  innobase_log_group_home_dir = /opt/mysql/var
  innobase_log_arch_dir = /opt/mysql/mysql/var
  innobase_data_file_path = ib_data1:10M
  set-variable = innobase_mirrored_log_groups=1
  set-variable = innobase_log_files_in_group=3
  set-variable = innobase_log_file_size=5M
  set-variable = innobase_log_buffer_size=8M
  innobase_flush_log_at_trx_commit=1
  innobase_log_archive=0
  set-variable = innobase_buffer_pool_size=16M
  set-variable = innobase_additional_mem_pool_size=2M
  set-variable = innobase_file_io_threads=4
  set-variable = innobase_lock_wait_timeout=50
  ~
  
  
  After starting I found the following error in the .err file:
  
  010405 14:30:32  mysqld started
  /opt/mysql/libexec/mysqld: unrecognized option `--~'
  /opt/mysql/libexec/mysqld  Ver 3.23.36 for hp-hpux11.00 on hppa1.1
  Copyright (C) 2000 MySQL AB  MySQL Finland AB, by Monty and others
  This software comes with ABSOLUTELY NO WARRANTY. This is free software,
  and you are welcome to modify and redistribute it under the GPL license
  
  Starts the MySQL server
  
  Usage: /opt/mysql/libexec/mysqld [OPTIONS]
  
--ansiUse ANSI SQL s.
  
  snip
  
  
  After removing the /etc/my.cnf file the server starts sucessfully, but without
  initializing the innobase stuff because the necessary pathes/variables are not
  set.
  
  Okay, second I tried, sucessfully, to start mysqld manually with the
  following commandline
  
   /opt/mysql/libexec/mysqld --user=mysql --basedir=/opt/mysql \ 
  --datadir=/opt/mysql/var --innobase_data_home_dir=/opt/mysql/var/ \
  --innobase_data_file_path=ib_data1:10M
  
  
  I suppose that mysqld (on HP-UX11) doesn't handle the my.cnf options
  correctly???
  
  By the way, I need to append a '/' at the end of the innobase_data_home_dir
  path in contrast to documentation. 
  
  Greetings from Germany 
  
  Andre
  
  
  --
  E-Mail: [EMAIL PROTECTED]
  Date: 05-Apr-01
  Time: 14:20:03
  
  ()  Join the ASCII ribbon campaign against html email
  /\  and Microsoft attachments.
  
  "I heard if you play the NT-4.0-CD backwards, you get a satanic message"
  "That is nothing, if you play it forward, it installs NT-4.0"
  


Hi!

May be you have some weird characters in the file.

I can see in your message ^[^[ at start and - at the end.


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