2.6.6.2 Примечания к HP-UX версии 10.20

При компиляции MySQL на HP-UX существует пара небольших проблем. Мы рекомендуем применять вместо собственного компилятора HP-UX gcc, потому что код, созданный gcc, лучше!

Для HP-UX рекомендуется использование gcc 2.95. Не следует применять высокие уровни оптимизации (наподобие -O6), поскольку на HP-UX это может быть небезопасно.

Заметим, что MIT-pthreads не могут быть скомпилированы компилятором HP-UX, поскольку он не компилирует ассемблерные файлы .S.

Должна работать следующая строка конфигурации:

CFLAGS="-DHPUX -I/opt/dce/include -fpic" \
CXXFLAGS="-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions \
-fno-rtti" CXX=gcc ./configure --with-pthread \
--with-named-thread-libs='-ldce' --prefix=/usr/local/mysql
--disable-shared

Если вы компилируете gcc 2.95 самостоятельно, то для того, чтобы компилировать MySQL с MIT-pthreads, НЕ следует линковать его с DCE-библиотеками (libdce.a или libcma.a). Если смешать пакеты DCE и MIT-pthreads, то в результате получится mysqld, к которому нельзя подсоединиться. Удалите DCE-библиотеки во время компиляции gcc 2.95!

User Comments

BSDI 4.1 ships with way outdated build tools. If
you're building and getting problems, do yourself
and everyone around you a favor and build your
tools before you comment:

GCC
aclocal
autoconf
automake
gmake

If you're still having problems, check and see if
it's a virtual memory issue. If so, try
using: 'limit datasize unlimited' and compile. If
you're still in trouble. THEN ask for help.

When trying to run the mysql server on Windows
2000 I overwrote the CTL3D32.DLL with a newer
version, which can be downloaded from this site.
Rebooting, copying the my.cnf to mysql and
typing "net start mysql" finally turned
the "green light on".

I found problems with compiling Mysql-3.23.37 on
Amdk6-2-450+ and 32Mb memory. Low memory option
didn't help. Computer hangs on compiling
sql_yacc.o

So, If you had the same problem, go to ~/mysql-
3.23.37/sql and edit Makefile:
find there string 'sql_yacc.o:' and add there no
optimization key : -O0

If you encountered error 1067 you may want to run
the server in standalone mode and with debug on.
For example: mysqld-max-nt --standalone --debug.
This will give you a clue on what's wrong with
the database startup. Hope this help. (wanw)

Here's a good explanation of how to build on OS X: http://www.devshed.com/Server_Side/Administration/BuildingOnOSX/page3.html

You do NOT need the pthreads for Mac OS X Public Beta, only for Mac OS X Server.

16-5-2001 - In Mac OS X 10.0.3, MySQL 3.23.38
compiles fine with --with-innodb configure option.
But mysqld need still to be -9
killed. Standard kill doesn't works. And
mysql-test-run fail on rpl00001.test and can't
continue following tests.

I got 3.23.37 to compile without changes on MacOS X 10.0.3. I had to enable the root account and then log in as root to get it to work. Once I did that configure and make ran fine. Trying to install it as a non root user (even su!!!) didn't work.

I have installed Mysql and the ODBC connector on
Windows 2000 Advanced Server. I also have PHP
4.05 running. Php is running fine but I get this
error when I try to start Mysql from a command
prompt. I have Mysql installed in C:/mysql. I try
to start it buy typing mysql. this is from the
c:/mysql/bin directory. Please help.

ERROR 2003: Can't connect to MySQL server
on 'localhost' (10061)

I just installed mysql-3.22.30 on BSDI 4.1
I had to use --disable-shared
and I increased datasize-cur=32M (was 16M) in /etc/login.conf
I still need to run the self tests.

LS,

When tried to compile the mysql/client part on
HPUX-10.20 w. gcc 2.95 I ran into problems. Lots
of errors including <stdio.h> (and some more
standard include files) about 'fpos_t' and 'int64'
stuff.

Used the setup they mention in here: didn't make a
difference. Suspected it had to do with large-file
support.

Did a ./configure, with one of the options being
'--disable-large-file'. Again no success.

Went into 'include/my_config.h'. It appeared that
the typical #define's for large-file support were
still in there.

Did a #undef on the following variables:
_FILE_OFFSET_BITS
_LARGEFILE_SOURCE
_LARGE_FILES

and *she-bang*! Compiles and runs like a charm!

With the pending Mac OS X release, I would
think it a prime time for developers of MySQL
to offer a version as easy to install and use on
that platform as FrontBase or OpenBase. With
MySQL becoming a cross-platform standard,
many (like me) might flock to it on OS X if it
didn't demand recompiling and tweaking.

At the very least, clear and simple instructions
for getting MySQL working on the coming Mac
OS X release would help. It's more of an
opportunity than with on some platforms
because Oracle, Microsoft, and IBM have
recently ignored the database needs of the
Mac world. Remember, we're still a good five
percent of the bazillion users, and contrary to
market perceptions we're not all so limited as
to be satisfied with FileMaker Pro. Some of us
would simply rather spend our time using
MySQL than learning to compile it.

RPM's won't install on RH, complaining about Perl5 not being there, when it actually is? just use --nodeps. it's looking for /usr/bin/perl5 in the rpm database, not in your filesystem. if you don't use rpms for perl (or maybe even if you do in some circumstances), then that won't be in there. i think the -bench rpm always required perl, but the others didn't. do they all now? nevertheless, rpm -ivh --nodeps MySQL*rpmor whatever. should be fine as long as /usr/bin/perl and /usr/bin/perl5 exist in the filesystem, regardless of the rpm db. From http://lists.omnipotent.net/mysql/

I agree that an easy to install 'package' for Mac OS X
final would be a great idea.
I have compiled the source on OS X using the
suggested change and confirm that it compiles without
any errors. However it does not pass the tests in the
manual (test 4) as mysqld does not shut down.

With Mac OS X 10.0 (final shipping version)
during make I got the following errors with
version 3.23.36:


mysqld.cc: In function `void init_signals()':
mysqld.cc:1241: assignment to `void (*)(int)'
from `void (*)()'
make[3]: *** [mysqld.o] Error 1
make[2]: *** [all-recursive] Error 1
make[1]: *** [all-recursive] Error 1
make: *** [all-recursive-am] Error 2


Just change line 1241 of sql/mysqld.cc to use:
void (*)(int) rather than void (*)().

Then it seems to compile fine.

I still get the "/usr/bin/perl5 is needed" with my brand new 4.0-4 version of RPM even after I linked perl5 to perl5.005_03 or perl5.6.0.
See the link "4.6.3.1 Linux Notes for Binary Distributions." above for more info...
Thankz Sheed ;)

The Fink installs mySQL very easily.
fink.sourceforge.net

On BSDi 4.1, I got the "virtual memory exhausted" message as well. Doing 'limit datasize unlimited' made it work, but understand that the compilation may then take up over 20 megs
of memory, so if you're short of memory, you might not want to do this. Also, "make" didn't
want to work right, so I used "gmake," and that got rid of some make errors.

On BSDi 4.1, I got the "virtual memory exhausted" message as well when compiling 3.23.27.. Doing 'limit datasize unlimited' (under tcsh) made it work, but understand that the compilation may then take up over 20 megs of memory, so if you're short of memory, you might not want to do this. Also, "make" didn't want to work right, so I used "gmake," and that got rid of some make errors.

Compilation with Berkeley DB does not seem
to work on OS X 10.0. It seems to be a thread
problem, which perhaps requires these
patches again?? Compiles fine, but on
starting up the daemon get:
010410 02:05:17 mysqld started
010410 2:05:17 bdb: architecture lacks fast
mutexes: applications cannot be t
hreaded
010410 2:05:17 Can't init databases
010410 02:05:17 mysqld

The innobase compilation bugs out also on
OSX 10.0... unable to get any transaction safe
table support so far.

NOTE: If you add a password for the root user and
you want to use the command line tool, you have
to use e.g. following syntax (further described
in <6.5 MySQL User Names and Passwords>):

mysql -u monty -p database_name

Note that in the last example the password is
NOT 'database_name'.
-->You'll be prompted for the password!

One of my clients is very, very interested in
this, as OS X on a TiBook is his preferred demo
platform, and we need SOME database to talk to.
MySql is our preferred choice.

HI to all, as I installed Mysql, Apache, PHP
under win2000 to test my program I realized that
it doesn't work correctly - maybe my code is
incorrect -, as follow as I tried to insert new
data into the table it was not be saved, and I
did not recieved any message (the program worked
correctly under win98, and gave the needed grants
too), I need rush help on the upper e-mail
addresse, thanks forward :: Alex

Modifying the "base_dir=..." line in \my.cfg does
not work properly in some situations... Just use
c:\mysql!

MySQL is included in the public release of
Mac OS X 10.0 but there is no obvious way to
get it launched at startup. When trying to
launch the deamon, I get this:

The file /BinaryCache/MySQL/MySQL-
1Z13.root~9/usr/local/mysql/libexec/mysqld
doesn't exist or is not executable

which makes me think Apple engineers had
to include it in a hurry because marketing
wrote "MySQL" on the box before they could
finish testing :-). It's like PHP, it won't work
until you uncomment two lines in the proper
Apache configuration file.

Has anyone got the Apple-provided version
running?

It seems the current DBD::mysql 2.0415 does not
support transactions in the DBI standard way.

Regarding Kelvin Luck's post on Windows 2000
special treatment of .cnf files and also related
to Error 1067 (which is what you get if mysql is
installed to a directory other than c:\mysql, and
also why you need to have a c:\my.cnf file),
you won't see the .cnf extension even if you have
"show file extensions" in Win2k. But you can
still
rename the file to my.cnf (and not my.cnf.cnf) by
just renaming the file to "my" (no quotes) in
Windows Explorer, or in DOS prompt, use the
rename command "ren my.cnf.cnf my.cnf" (no
quotes).

Hello
I have a problem to start mysql under Windows
2000.
I followed instructions in Winmyadmin.hlp, I
tried to do instructions in the documentation but
there is always the same problem:
Error 1067 : the process can't start !

What is the problem ?
Is someone has a solution.

Thanks in advance.

Regarding the "Could not start MySQL service on
local computer Error 1067: The process terminated
unexpectedly" problem - I had this one to when I
tried to install MySQL on Win2K with
path "c:\program files\MySQL". So I just
deinstallied it and tried again with the default
path "c:\mysql" - and it works!

If you install in a directory other than c:\mysql
you must create a file called "my.cnf" in the
following location "c:\" (sans quotes) it must
contain the following:

[mysqld]
basedir=c:/filepath/mysql/

The binary most recent binary installation for
windows does not seem to give one the option to
install the header files. This makes it
impossible to build the DBD driver for mysql.
One could get around this by installing the mysql
specific installation of perl; however, in my
case, working with Interwoven TeamSite, I need to
use its existing installation of perl.

I have tried to start MySQL up as a service on
Win2k Pro by setting the basedir option in my.cnf
to point to D:\MySQL and got System Error 1067 (I
even tried replacing the CTL3D32.DLL and
rebooting). However, when I manually set the
option as a parameter via the NT services GUI it
started up with no problems. In sec# 4.1.2 it
lists some programs that can use the my.cnf file
and mysqld-nt isn't listed. Seems to me that you
can't use the my.cnf option file with mysqld-nt.
I don't believe you can use the --debug option
with mysqld-nt either, only mysqld.

Blue :

if u have installd mysql in another directory
than c:\mysql and u reinstall it in c:\mysql
think about changing the path of service if this
one make an error when u try to launch it
just check in control panel ---> admin tools -->
services if the path is correct if it is not
just edit the registry to put correct path

Fix for MySQL included on Mac OS X 10.0
Problem: error when trying to launch daemon
The file /BinaryCache/MySQL/MySQL-
1Z13.root~9/usr/local/mysql/libexec/mysqld
doesn't exist or is not executable

Solution:
open all the files in /usr/local/mysql/bin
some will be none text files - obviously leave
these files alone
however for the text files do a search and
replace for:
"/BinaryCache/MySQL/MySQL-1Z13.root~9"
and replace it with
"" (nothing)

then carry on - everything will work fine -
except known bugs - ie. shutdown...

Add your own comment.