MySQL University session on Feb 19: Developing MySQL on Solaris
Developing MySQL on Solaris http://forge.mysql.com/wiki/Developing_MySQL_on_Solaris This Thursday (February 19th, 14:00 UTC), MC Brown Trond Norbye will give a MySQL University session on Developing MySQL on Solaris. MC works on the MySQL Documentation Team and has been involved with quite a few Solaris things, for example porting MySQL to openSolaris. Trond has been involved with many things, including openSolaris, as you can see from his blog (http://blogs.sun.com/trond/). For MySQL University sessions, point your browser to this page: http://webmeeting.dimdim.com/portal/JoinForm.action?confKey=mysqluniversity You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session. Here's the schedule for the upcoming weeks (see http://forge.mysql.com/wiki/MySQL_University for a better format of this list): February 19, 2009 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow) Developing MySQL on Solaris MC Brown Trond Norbye February 26, 2009 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow) Backing up MySQL using file system snapshotsLenz Grimmer March 5, 2009 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow)Good Coding Style Konstantin Osipov March 12, 2009 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow) MySQL and ZFS MC Brown March 19, 2009 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 BST / 15:00 CET / 17:00 MDT (Moscow) How to Use Charsets and Collations Properly Susanne Ebrecht Cheers, Stefan -- *** Sun Microsystems GmbHStefan Hinz Sonnenallee 1Manager Documentation, Database Group 85551 Kirchheim-Heimstetten Phone: +49-30-82702940 Germany Fax: +49-30-82702941 http://www.sun.de/mysql mailto: stefan.h...@sun.com Amtsgericht Muenchen: HRB161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: super-smack on mysql 5.0 solaris 10 x86_64
Maybe you should set your old_passwords = on. On Fri, Oct 17, 2008 at 4:36 PM, Sudhir Menon [EMAIL PROTECTED] wrote: Hi Ujang I could reproduce the same error mentioned by you in the actual post even after having all of the packages for MySQL. Figuring out the what could be the problem . Thanks Regards Sudhir Menon -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: super-smack on mysql 5.0 solaris 10 x86_64
Hi Ujang I could reproduce the same error mentioned by you in the actual post even after having all of the packages for MySQL. Figuring out the what could be the problem . Thanks Regards Sudhir Menon
Re: super-smack on mysql 5.0 solaris 10 x86_64
on this machine there are libs from solaris package... bash-3.00# pkginfo | grep mysql system SUNWmysqlr mysql - MySQL Database Management System (root component) system SUNWmysqlt mysql - MySQL Database Management System (test component) system SUNWmysqlu mysql - MySQL Database Management System (usr component) application mysqlMySQL Community Server (GPL) is this libmysqlclient v4? bash-3.00$ ldd /usr/local/bin/super-smack libmysqlclient.so.12 = /usr/sfw/lib/libmysqlclient.so.12 libcrypt_d.so.1 = /usr/lib/libcrypt_d.so.1 libsocket.so.1 =/usr/lib/libsocket.so.1 libnsl.so.1 = /usr/lib/libnsl.so.1 libstdc++.so.6 =/usr/sfw/lib/libstdc++.so.6 libm.so.2 = /usr/lib/libm.so.2 libgcc_s.so.1 = /usr/sfw/lib/libgcc_s.so.1 libc.so.1 = /usr/lib/libc.so.1 libz.so.1 = /usr/lib/libz.so.1 librt.so.1 =/usr/lib/librt.so.1 libcrypt_i.so.1 = /usr/lib/libcrypt_i.so.1 libgen.so.1 = /usr/lib/libgen.so.1 libmp.so.2 =/usr/lib/libmp.so.2 libmd.so.1 =/usr/lib/libmd.so.1 libscf.so.1 = /usr/lib/libscf.so.1 libaio.so.1 = /usr/lib/libaio.so.1 libdoor.so.1 = /usr/lib/libdoor.so.1 libuutil.so.1 = /usr/lib/libuutil.so.1 -- thanks and regards ujang | oracle dba jakarta | http://ora62.wordpress.com On Wed, Oct 15, 2008 at 12:18 AM, Sudhir Menon [EMAIL PROTECTED] wrote: Hi, Kindly ignore my first post, as that link was with respect to compiling super-smack on Solaris, which i found useful. As far as the problem is concerned can u check the below 1. Check if you have mysql4client package installed. 2. If then install mysql5client 3. Ensure that the binaries and .so files are in PATH. 4. Recompile super-smack again. I am using a CSW package other than the default SUNW package, let me see if i could reproduce the problem. Thanks Regards Sudhir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: super-smack on mysql 5.0 solaris 10 x86_64
Kindly check with the below commands, u will get the details of the package. pkginfo SUNWmysqlu system SUNWmysqlu mysql - MySQL Database Management System (usr component) [EMAIL PROTECTED] # pkginfo -l SUNWmysqlu PKGINST: SUNWmysqlu NAME: mysql - MySQL Database Management System (usr component) CATEGORY: system ARCH: sparc VERSION: 11.10.0,REV=2005.01.08.05.16 BASEDIR: / VENDOR: Sun Microsystems, Inc. DESC: mysql - MySQL Database Management System (usr component) 4.0.24 PSTAMP: sfw10-patch20050627114310 INSTDATE: Sep 23 2008 18:59 HOTLINE: Please contact your local service provider STATUS: completely installed FILES: 176 installed pathnames 6 shared pathnames 31 directories 47 executables 17634 blocks used (approx) -- pkgchk -l SUNWmysqlu Part of the output *Pathname: /usr/sfw/lib/libmysqlclient.so.12* Type: symbolic link Source of link: libmysqlclient.so.12.0.0 Referenced by the following packages: SUNWmysqlu Current status: installed pkgchk -l *CSWmysql5rt * Package that contains the library in my system. *Pathname: /opt/csw/mysql5/lib/mysql/libmysqlclient.so.15* Type: symbolic link Source of link: libmysqlclient.so.15.0.0 Referenced by the following packages: CSWmysql5rt Current status: installed Thanks Regards Sudhir Menon
Re: super-smack on mysql 5.0 solaris 10 x86_64
Hope this link has some workaround. http://mysqldatabaseadministration.blogspot.com/2006/10/mysql-benchmarking-4-compiling-super.html Meanwhile i do check out. Thanks Regards Sudhir Menon
super-smack on mysql 5.0 solaris 10 x86_64
all, does anyone has successful installing super-smack on solaris 10 x86_64 with mysql 5.0. I have installed, but when will doing stress testing, always complaining that client should be upgraded $ super-smack select-key.smack 30 1 super-smack: aborting because of a database error: Client does not support authentication protocol requested by server; consider upgrading MySQL client any idea? -- thanks and regards ujang | oracle dba jakarta | http://ora62.wordpress.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: super-smack on mysql 5.0 solaris 10 x86_64
Hi, Kindly ignore my first post, as that link was with respect to compiling super-smack on Solaris, which i found useful. As far as the problem is concerned can u check the below 1. Check if you have mysql4client package installed. 2. If then install mysql5client 3. Ensure that the binaries and .so files are in PATH. 4. Recompile super-smack again. I am using a CSW package other than the default SUNW package, let me see if i could reproduce the problem. Thanks Regards Sudhir
Compiling mysql on Solaris 10
Hi all, I'm having trouble compiling MySql on a Sun Sparc machine with Solaris 10. MySql is 5.0.27 Solaris is sparc.sun.solaris2.10 (64 bits) gcc version 3.4.3 (csl-sol210-3_4-branch+sol_rpath) I've installed zlib-1.2.3, but got no better luck. I'm using to compile: CC=gcc CFLAGS=-O3 -m64 \ CXX=gcc CXXFLAGS=-O3 -m64 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory Amid all the output that this gives, some suspicious errors appear: grep: illegal option -- q Usage: grep -hblcnsviw pattern file . . . configure: WARNING: term.h: present but cannot be compiled configure: WARNING: term.h: check for missing prerequisite headers? configure: WARNING: term.h: see the Autoconf documentation configure: WARNING: term.h: section Present But Cannot Be Compiled configure: WARNING: term.h: proceeding with the preprocessor's result configure: WARNING: term.h: in the future, the compiler will take precedence configure: WARNING: ## -- ## configure: WARNING: ## Report this to the AC_PACKAGE_NAME lists. ## configure: WARNING: ## -- ## configure: WARNING: sys/ptem.h: present but cannot be compiled configure: WARNING: sys/ptem.h: check for missing prerequisite headers? configure: WARNING: sys/ptem.h: see the Autoconf documentation configure: WARNING: sys/ptem.h: section Present But Cannot Be Compiled configure: WARNING: sys/ptem.h: proceeding with the preprocessor's result configure: WARNING: sys/ptem.h: in the future, the compiler will take precedence configure: WARNING: ## -- ## configure: WARNING: ## Report this to the AC_PACKAGE_NAME lists. ## configure: WARNING: ## -- ## configure: WARNING: extra-tools disabled because --enable-thread-safe-client wasn't used But, it goes on. Then, make stops with these lines: ... /bin/bash ../libtool --preserve-dup-deps --tag=CC --mode=link gcc -DDBUG_OFF -O3 -m64 -DHAVE_RWLOCK_T-o libz.la -rpath /usr/local/mysql/lib/mysql -version-info 3:3:2 adler32.lo compress.lo crc32.lo deflate.lo gzio.lo infback.lo inffast.lo inflate.lo inftrees.lo trees.lo uncompr.lo zutil.lo -lpthread -lthread -lposix4 -lgen -lsocket -lnsl -lm -lpthread -lthread gcc -shared -Wl,-h -Wl,libz.so.1 -o .libs/libz.so.1.2.3 .libs/adler32.o .libs/compress.o .libs/crc32.o .libs/deflate.o .libs/gzio.o .libs/infback.o .libs/inffast.o .libs/inflate.o .libs/inftrees.o .libs/trees.o .libs/uncompr.o .libs/zutil.o -lpthread -lthread -lposix4 -lgen -lsocket -lnsl -lm -lpthread -lthread -lc -m64 (cd .libs rm -f libz.so.1 ln -s libz.so.1.2.3 libz.so.1) (cd .libs rm -f libz.so ln -s libz.so.1.2.3 libz.so) false cru .libs/libz.a adler32.o compress.o crc32.o deflate.o gzio.o infback.o inffast.o inflate.o inftrees.o trees.o uncompr.o zutil.o *** Error code 1 make: Fatal error: Command failed for target `libz.la' Current working directory /export/home/jerry/installs/mysql-5.0.27/zlib *** Error code 1 The following command caused the error: failcom='exit 1'; \ for f in x $MAKEFLAGS; do \ case $f in \ *=* | --[!k]*);; \ *k*) failcom='fail=yes';; \ esac; \ done; \ dot_seen=no; \ target=`echo all-recursive | sed s/-recursive//`; \ list='. include Docs zlib cmd-line-utils sql-common pstack strings mysys dbug extra regex innobase myisam myisammrg heap vio sql libmysql client scripts man tests netware sql-bench mysql-test support-files server-tools'; for subdir in $list; do \ echo Making $target in $subdir; \ if test $subdir = .; then \ dot_seen=yes; \ local_target=$target-am; \ else \ local_target=$target; \ fi; \ (cd $subdir make $local_target) \ || eval $failcom; \ done; \ if test $dot_seen = no; then \ make $target-am || exit 1; \ fi; test -z $fail make: Fatal error: Command failed for target `all-recursive' Current working directory /export/home/jerry/installs/mysql-5.0.27 *** Error code 1 make: Fatal error: Command failed for target `all' Does anyone have a hint for what may be missing here ? Thank you, --- Luis Jeremias [EMAIL PROTECTED] TV CABO PORTUGAL Direcção de Desenvolvimento de Infraestruturas Rua Dr. Eduardo Neves, nº9 Edifício Pinta, 2° Piso, Sala 7 1069-203 Lisboa - PORTUGAL TM: 961360663, Tel: 217943522, Fax: 217824895 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restarting MySQL on Solaris 8?
- Original Message - From: Jay Paulson [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, September 08, 2006 9:51 PM Subject: Restarting MySQL on Solaris 8? A couple questions since I'm not a Solaris person I really don't know how to do the following and was hoping that someone could help me out (Google isn't much help on this). How does one start the MySQL daemon on Solaris 8? (it's running MySQL 3.23.49) How does one tell Solaris 8 to start the MySQL daemon on boot? When you've got the first problem fixed To have MySQL [or any application] restart at boot time, you need to copying the start script to /etc/rc3.d Start scripts in the rc3.d dir all start with 'S' followed by a number, like: S53mysql. As root, copy the /usr/local/mysql/support-files/mysql.server script to /etc/rc3.d, and rename it as say S53mysql. This should fix the boot problem. ~mm Lastly, tried running /usr/local/bin/safe_mysqld but got the following error: TIMESTAMP mysqld ended Thanks for any help! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restarting MySQL on Solaris 8?
Hi, Try /usr/local/bin/mysqld_safe to start MySQL /usr/local/bin/mysqld_safe to start MySQL as a background process. Thanks. ViSolve DB Team. - Original Message - From: Jay Paulson [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, September 08, 2006 9:51 PM Subject: Restarting MySQL on Solaris 8? A couple questions since I'm not a Solaris person I really don't know how to do the following and was hoping that someone could help me out (Google isn't much help on this). How does one start the MySQL daemon on Solaris 8? (it's running MySQL 3.23.49) How does one tell Solaris 8 to start the MySQL daemon on boot? Lastly, tried running /usr/local/bin/safe_mysqld but got the following error: TIMESTAMP mysqld ended Thanks for any help! -- 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: Restarting MySQL on Solaris 8?
Hi, /usr/local/bin/safe_mysqld must do good with MySQL 3.23.49. The error may be due to either one. a. configuration file set up b. data directory - anything removed/modified - not enough disk space c. log file size Thanks, ViSolve DB Team. - Original Message - From: Visolve DB Team [EMAIL PROTECTED] To: Jay Paulson [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Monday, September 11, 2006 9:35 AM Subject: Re: Restarting MySQL on Solaris 8? Hi, Try /usr/local/bin/mysqld_safe to start MySQL /usr/local/bin/mysqld_safe to start MySQL as a background process. Thanks. ViSolve DB Team. - Original Message - From: Jay Paulson [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, September 08, 2006 9:51 PM Subject: Restarting MySQL on Solaris 8? A couple questions since I'm not a Solaris person I really don't know how to do the following and was hoping that someone could help me out (Google isn't much help on this). How does one start the MySQL daemon on Solaris 8? (it's running MySQL 3.23.49) How does one tell Solaris 8 to start the MySQL daemon on boot? Lastly, tried running /usr/local/bin/safe_mysqld but got the following error: TIMESTAMP mysqld ended Thanks for any help! -- 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]
Restarting MySQL on Solaris 8?
A couple questions since I'm not a Solaris person I really don't know how to do the following and was hoping that someone could help me out (Google isn't much help on this). How does one start the MySQL daemon on Solaris 8? (it's running MySQL 3.23.49) How does one tell Solaris 8 to start the MySQL daemon on boot? Lastly, tried running /usr/local/bin/safe_mysqld but got the following error: TIMESTAMP mysqld ended Thanks for any help! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql and solaris upgrade
Hi, I need to upgrade a server from Solaris 8 to Solaris 10. There is one MySQL server running on it, (the binary mysql-standard-4.1.15-sun-solaris2.8-sparc from mysql.com), do I need to upgrade MySQL as well ? (to mysql-standard-4.1.x-sun-solaris2.10-sparc ?) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql and solaris upgrade
On Tuesday 16 May 2006 02:16 am, Philippe Poelvoorde wrote: Hi, I need to upgrade a server from Solaris 8 to Solaris 10. There is one MySQL server running on it, (the binary mysql-standard-4.1.15-sun-solaris2.8-sparc from mysql.com), do I need to upgrade MySQL as well ? (to mysql-standard-4.1.x-sun-solaris2.10-sparc ?) I'd recommend it simply because if the API/ABI changes on any one of the libraries that MySQL uses during the solaris upgrade, it will fail on you. That said, better safe than sorry. In fact, I'd also ask any solaris newsgroup/mailing list to verify the distribution specific details of the upgrade. -- Chris White PHP Programmer/DB Llama Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql on Solaris vs Linux
Hello All, We recently ran a few tests on mysql on both solaris and linux environments. It turned out that mysql was much faster and responsive on linux. After doing some digging, we found out one of the possible reasons is the fact that mysql source code uses malloc all over the place. On solaris malloc calls block all threads and create heap contention. Indeed, Sun actually dis-courages the use of malloc. This would explain why we could never see our CPU utilization go up on solaris. Question #1) are we right in our assumption that mysql runs way faster on linux rather then solaris or are we on drugs. Question #2) If it does indeed run faster, is there a way or a ported binary of mysql that runs equally fast on Solaris. Reason being I have two big Sun E3500 lying around that I would like to put to good use .. Thanks in advance, Aamir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql on solaris 8/9
Aysun Alay wrote: Our application needs to support both solaris 8 and solaris 9. I was wondering if mysql has a backwards compatibility in terms of operating systems. Can I use mysql-pro-4.0.20-sun-solaris2.9-sparc.tar file to install mysql on Solaris 8? Not sure, but it is usually not too hard to compile the package. For both Solaris 8 and 9, you can get required compilers and tools on the Companion Software CD which is available at http://wwws.sun.com/software/solaris/freeware/ Should you need newer versions of some of the packages (for instance, MySQL 4.1 requires a more recent bison package), get those from http://www.sunfreeware.com/ I've found it helpful (if not necessary) to perform the following additional steps: - create symbolic links to the GNU programs (which are installed with a 'g' prefix below /opt/sfw or /usr/sfw) and give those links the regular unix name; for instance, create a directory '/opt/gnulinks' and run $ cd /opt/gnulinks $ ln -s /opt/sfw/bin/gls ls $ ln -s /opt/sfw/bin/gfalse false $ ln -s /opt/sfw/bin/gecho echo $ ln -s /usr/sfw/bin/gtar tar ...[same for all required GNU programs]... - put the directory with the symbolic links pointing to the GNU programs in the first position of your PATH environment variable, e.g. $ PATH=/opt/gnulinks:$PATH $ export PATH Then configure and compile MySQL. Hope that helps, Hans-Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql on solaris 8/9
Our application needs to support both solaris 8 and solaris 9. I was wondering if mysql has a backwards compatibility in terms of operating systems. Can I use mysql-pro-4.0.20-sun-solaris2.9-sparc.tar file to install mysql on Solaris 8? Thanks Aysun
Re: link error gcc compiling mysql on solaris 9 (lib not found)
That's a mess of a problem. If the libraries were included in the link, configure must have detected them on your system somehow, but now they are not working. Did you by any chance use --with-mysqld-ldflags=-all-static ? Yes I did, now I realize this doesn't work on Solaris. I tried linking statically because of the error on the mysql-test script from the mysql client. So now I am back to a dynamic compile, which completes just fine and the mysqld starts OK! But now I get an error from the command line mysql: hill pwd /export/home/ken/mysql/mysql-4.0.18/client hill ./mysql ld.so.1: /export/home/ken/mysql/mysql-4.0.18/client/.libs/lt-mysql: fatal: libgcc_s.so.1: open failed: No such file or directory Killed hill But the mysqld daemon seems to star just fine for testing! Thanks for the hints, Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: link error gcc compiling mysql on solaris 9 (lib not found)
OK, sorry to answer my own post, libgcc was is /usr/local/lib which did not get properl added with crle! crle -u -l /usr/local/lib Problem gone! Sorry to waste bandwidth (we are just learning solaris!). Ken - Original Message - From: Ken Menzel [EMAIL PROTECTED] To: Sasha Pachev [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, March 12, 2004 10:33 AM Subject: Re: link error gcc compiling mysql on solaris 9 (lib not found) That's a mess of a problem. If the libraries were included in the link, configure must have detected them on your system somehow, but now they are not working. Did you by any chance use --with-mysqld-ldflags=-all-static ? Yes I did, now I realize this doesn't work on Solaris. I tried linking statically because of the error on the mysql-test script from the mysql client. So now I am back to a dynamic compile, which completes just fine and the mysqld starts OK! But now I get an error from the command line mysql: hill pwd /export/home/ken/mysql/mysql-4.0.18/client hill ./mysql ld.so.1: /export/home/ken/mysql/mysql-4.0.18/client/.libs/lt-mysql: fatal: libgcc_s.so.1: open failed: No such file or directory Killed hill But the mysqld daemon seems to star just fine for testing! Thanks for the hints, Ken -- 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]
link error gcc compiling mysql on solaris 9 (lib not found)
This may be more solaris related, but I need to compile mysql with gcc because perl is compiled with gcc and I need DBD::mysql. It seems the linker can't find the libs. I seem to have the same problem linked dynamicaly expect the build completes and then can't load the shared library when I start mysql. I hope I have include all relevant info, hope some one can point me the right way! Thanks Ken much cut ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -ldl -lz -lposix4 -lcrypt -lgen -lsocket -ln sl -lm -lpthread -lthread ld: fatal: library -lrt: not found ld: fatal: library -ldl: not found ld: fatal: library -lposix4: 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 gmake[4]: *** [mysqld] Error 1 gmake[3]: *** [all-recursive] Error 1 gmake[2]: *** [all] Error 2 gmake[1]: *** [all-recursive] Error 1 gmake: *** [all] Error 2 --- additional info hill crle Configuration file [3]: /var/ld/ld.config Default Library Path (ELF): /usr/lib:/usr/local/mysql/lib/mysql Trusted Directories (ELF):/usr/lib/secure (system default) Command line: crle -c /var/ld/ld.config -l /usr/lib:/usr/local/mysql/lib/mysql hillCC=gcc CFLAGS=-O3 CXX=gcc \ CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure $DEBUG --enable-large-files --with-innodb \ $LOWMEM --enable-assembler --with-mysqld-ldflags=-all-static hillgmake -s hill gcc -v Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.9/3.3.2/specs Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld --dis able-nls Thread model: posix gcc version 3.3.2 Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: link error gcc compiling mysql on solaris 9 (lib not found)
Ken Menzel wrote:
This may be more solaris related, but I need to compile mysql with
gcc because perl is compiled with gcc and I need DBD::mysql. It seems
the linker can't find the libs. I seem to have the same problem
linked dynamicaly expect the build completes and then can't load the
shared library when I start mysql.
I hope I have include all relevant info, hope some one can point me
the right way!
Thanks Ken
much cut
../dbug/libdbug.a ../regex/libregex.a
../strings/libmystrings.a -ldl -lz -lposix4 -lcrypt -lgen -lsocket -ln
sl -lm -lpthread -lthread
ld: fatal: library -lrt: not found
ld: fatal: library -ldl: not found
ld: fatal: library -lposix4: not found
ld: fatal: library -lpthread: not found
ld: fatal: library -lthread: not found
ld: fatal: File processing errors. No output written to mysqld
Ken:
That's a mess of a problem. If the libraries were included in the link,
configure must have detected them on your system somehow, but now they are not
working. Did you by any chance use --with-mysqld-ldflags=-all-static ?
If not, start troubleshooting by trying to get something like this to compile
and execute:
-test.c
#include pthread.h
void* run(void* p)
{
return 0;
}
int main()
{
pthread_t th;
pthread_create(th,0,run,0);
}
end test.c-
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with MySQL and Solaris 9 sparc
Hi, my name is Carlos Flores, and i have solaris 9 on ultra 10 workstation, but i can not up this daemon, with /opt/sfw/mysql/bin/mysqld_safe i try to up this daemon, but always begin but in second line tell me: mysql ended, and i try with mysql_install and anyone option finish telling me: mode=0, or mode=1, or mode=2, but no more action. I reboot my solaris and have three process here: sh -c /opt/local/bin/mysqld_safe --user=sql /bin/sh /opt /local/bin/mysqld_safe --user=sql .. /opt/local/libexec/mysqld --basedir=/opt/local --datadir=/var/data ... i believe that is not correctly installed and i dont know what happend incorrectly. i be grateful if you can help me. Thanks - Obtén tu correo en www.correo.unam.mx UNAMonos Comunicándonos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql on Solaris 8/9 with ultrasparc
Mysqlians, Greetings .. I am at my wits end trying to find a performance problem with 4.0.16 on solaris 9 with 4 ultrasparc III process (sunfire v880). I would be much obliged if the Mame's and Sir's out their with this setup(or similar) would share with me their show variables or any kernel or filesystem changes they made. In my particular, case single-threaded tests (sql-bench) compare similar for the sunfire against dual proc 2.4 xeon systems (redhat 9) but under site load the sunfire slows to a crawl. Happy Holidays, Trevor
MySQL on Solaris 9 sparc with Perl
Greetings, I can not get the DBD::mysql module for perl to install correctly. It continues to complain about the mysql.so file. What worries me is the solaris dist does not include a libmysqlclient.so file which I do believe the linux DBD:mysql needs to install. Any help is most welcome. Trevor
Mysql 4, Solaris 9 and Perl 5.8
We are getting new Solaris machines on which I plan to install MySQL. We will be installing Solaris 9 on these machines. Offhand, does anyone know if there are problems with compiling and installing MySQL 4 on Solaris 9. I am also planning on installing Perl 5.8 on these new machines. The last time I installed Perl 5.8 on my current machine, It caused problems with MySQL ( I do not remember anymore what the problems were - it was quite a while ago and it was with MySQL 3.23.49). Does anyone know if there are problems or is anyone successfully running MySQL 4 with Perl 5.8 on Solaris 9. Thanks for any information. Malki Cymbalista Webmaster, Weizmann Institute of Science Rehovot, Israel 76100 Internet: [EMAIL PROTECTED] 08-934-3036 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysql 4, Solaris 9 and Perl 5.8
Don't compile mySQL for Solaris 9. The mySQL team has invested months of work to get a very fast and stable static link of up-to-date libraries from their downloadable binaries section. I find that they are more stable and faster then the ones compiled by hand. For Perl 5.8 goto sunfreeware.com and get it there. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Malka Cymbalista [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 16, 2003 3:16 AM --To: [EMAIL PROTECTED] --Subject: Mysql 4, Solaris 9 and Perl 5.8 -- --We are getting new Solaris machines on which I plan to install MySQL. We --will be installing Solaris 9 on these machines. Offhand, does anyone --know if there are problems with compiling and installing MySQL 4 on --Solaris 9. I am also planning on installing Perl 5.8 on these new --machines. The last time I installed Perl 5.8 on my current machine, It --caused problems with MySQL ( I do not remember anymore what the problems --were - it was quite a while ago and it was with MySQL 3.23.49). Does --anyone know if there are problems or is anyone successfully running MySQL --4 with Perl 5.8 on Solaris 9. --Thanks for any information. -- -- --Malki Cymbalista --Webmaster, Weizmann Institute of Science --Rehovot, Israel 76100 --Internet: [EMAIL PROTECTED] --08-934-3036 -- -- --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]
compiler used to successfully compile mysql on solaris 8 machine
Hi, I have been trying to compile mysql on a solaris 8 machine. However, I am getting internal compiler errors. What compiler and version did anyone use to successfully compile mysql on a solaris machine. Thanks. Ren _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Best performance : 32 bit or 64 bit MySQL on Solaris 8
Hi, I've a SunFire V880 (4 proc., 8 Gb RAM) on Solaris 8. Which is the best solution (speed, security, ...) : the 32 bit or the 64 bit MySQL binaries ? Thank's Best regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Compiling MySql on Solaris 9
Hi Wim, I'm no expert with compilers and mysql either, but I have gotten mysql to compile sucessfully on Solaris 9 using gcc 2.95.2. If you look at http://www.mysql.com/downloads/mysql-3.23.html , in the source code download section, you'll see that they recommend using the compiler gcc-2.95.2, however they still offer instructions for building with other version of gcc. So, I used gcc-2.95.2 and the 3.23.52 source code (it appears they've got 3.23.53 up now). I did the following for configuring: setenv CC gcc setenv CFLAGS -O3 setenv CXX gcc setenv CXXFLAGS -O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql3.23.52 --with-low-memory --with-extra-charsets=complex --enable-assembler --with-libwrap gmake (The --with-libwrap is to provide tcp-wrapper support, which is the whole reason I'm using source code. The binaries don't come with this support). If you'd like to build with other versions of gcc you can find build instructions for different platfroms at: http://www.mysql.com/doc/en/MySQL_binaries.html unforntuantely, they don't have Solaris 9. It compiled fine, and installed fine. However, I'm having problems running all the tests. They don't fail, they just hang, although I'm able to use mysql normally. I'm curently looking into why these test cases are hanging. I hope this helps some. Stephen Hello all, I'm new to this list and I was wandering if one of you would be able to help me with the following problem. I've been trying, unsuccessfully, to compile mysql 3.23.51 on Solaris 9 (sparc). I'm using gcc 3.2 and bintools 2.13. I used the following configure command: ./configure -prefix=/usr/local/mysql -with-innodb Whatever I try I get the same errors (see end of message) when trying to compile. I looked and the only references to compile errors in this module I can find have to do with memory constraints. I tried the low-memory option, but no difference. When looking at the sql_lex.cc module it seems to reference some things from lex.h which is not included, but including it will fix some of these errors but not all. I was going to try to compile 3.23.52 instead but sourceforge tells me that there are no files for 3.23.52. and a max binary for Solaris 9 is not available yet. Any and all help/advice/pointers would be greatly appreciated, thanks in advance. Wim make[1]: Entering directory `/software/mysql-3.23.51/sql' g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DHAVE_CONFIG_H -I../innobase/include -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -c sql_lex.cc sql_lex.cc: In function `void lex_init()': sql_lex.cc:85: `symbols' undeclared (first use this function) sql_lex.cc:85: (Each undeclared identifier is reported only once for each function it appears in.) sql_lex.cc:87: `sql_functions' undeclared (first use this function) sql_lex.cc: In function `int find_keyword(LEX*, unsigned int, bool)': sql_lex.cc:168: `get_hash_symbol' undeclared (first use this function) make[1]: *** [sql_lex.o] Error 1 make[1]: Leaving directory `/software/mysql-3.23.51/sql' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compiling MySql on Solaris 9
Hello all, I'm new to this list and I was wandering if one of you would be able to help me with the following problem. I've been trying, unsuccessfully, to compile mysql 3.23.51 on Solaris 9 (sparc). I'm using gcc 3.2 and bintools 2.13. I used the following configure command: ./configure -prefix=/usr/local/mysql -with-innodb Whatever I try I get the same errors (see end of message) when trying to compile. I looked and the only references to compile errors in this module I can find have to do with memory constraints. I tried the low-memory option, but no difference. When looking at the sql_lex.cc module it seems to reference some things from lex.h which is not included, but including it will fix some of these errors but not all. I was going to try to compile 3.23.52 instead but sourceforge tells me that there are no files for 3.23.52. and a max binary for Solaris 9 is not available yet. Any and all help/advice/pointers would be greatly appreciated, thanks in advance. Wim make[1]: Entering directory `/software/mysql-3.23.51/sql' g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DHAVE_CONFIG_H -I../innobase/include -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -c sql_lex.cc sql_lex.cc: In function `void lex_init()': sql_lex.cc:85: `symbols' undeclared (first use this function) sql_lex.cc:85: (Each undeclared identifier is reported only once for each function it appears in.) sql_lex.cc:87: `sql_functions' undeclared (first use this function) sql_lex.cc: In function `int find_keyword(LEX*, unsigned int, bool)': sql_lex.cc:168: `get_hash_symbol' undeclared (first use this function) make[1]: *** [sql_lex.o] Error 1 make[1]: Leaving directory `/software/mysql-3.23.51/sql' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compiling mySQL on Solaris 8
Is someone succeed in compiling mySQL 3.23.x and 4.0.x on Solaris 8 (and how to do it - especialy with SunOne C compiler - ak Forte C v7). Sinceraly. - 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
Can't start mysql on Solaris, can't find libstdc++.so.4
Installed mysql-3.23.43-pkg on Solaris Sparc 8. Get the missing library error on everything I try. Anyone know what to do? Here's the error log entry for the command ./usr/local/bin/safe_mysqld --user=mysql 021004 21:41:12 mysqld started ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.4: open failed: No such file or directory 021004 21:41:12 mysqld ended -- Randy Perry sysTame Mac Consulting/Sales http://www.systame.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
compiling mysql on Solaris 9 on Ultra 5 using gcc 3.2 fails
Hello I'm Gunter and I tried to compile the mysql Database on Solaris 9 for Ultra Sparc arcitecture. I use the precompiled gcc 3.2 compiler form www.sunfreeware.com. This Compiler is linked to use the as and ld fom the Solaris operating system. Also I use the autoconf and the other gnu tools from this site. Becaus the precompiled version of mysql uses a version of the libstdc++.so.3.0.0 and on my system there is the libstdc++.so.5.0.0 version installed, I can not use the precompiled version. When I tried to compile the source distribution I got severel diferent errormessages in dependency for what I configured. I know that error reports shuold be made by msqlbug and sended directly, but the SUN I compiled it is a stand alone mashine without an smtp configured. So I copied and pasted the poutput of mysqlbug to an e-mail programm on an other machine and send it directly, but the mail returned as undeliverabe. The result is, that I subscribe to this mailing list. I used the minimum configure parameters --prefix=/usr/local/mysql It is also reproduceable with: ./configure --prefix=/usr/local/mysql --enable-thread-safe-client --enable-local-infile --disable-shared The error mesage I got: g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/u sr/local/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -c mysqld.cc mysqld.cc: In function `void* handle_connections_sockets(void*)': mysqld.cc:2410: invalid conversion from `size_socket*' to `socklen_t*' mysqld.cc:2476: invalid conversion from `size_socket*' to `socklen_t*' make[3]: *** [mysqld.o] Error 1 make[3]: Leaving directory `/opt/mysql-3.23.52/sql' make[2]: ***[all-recursive] Error 1 make[2]: Leaving directory `/opt/mysql-3.23.52/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/opt/mysql-3.23.52' make: *** [all-recursive-am] Error 2 A similar error message was created when I configured with some options(the options recommended for Solaris), but on an other file (sql_lex.cc also located in sql dir) Here in line 85 the symbols and in line 87 sql_functions was undefined. After configuring whithout any options the file sql_lex.cc compiled g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -c sql_lex.cc but the first mentioned error in mysqld.cc occoured. I also see that in the default compiler flags there is -mcpu=pentiumpro but the SUN Ultra 5 uses a Ultra II Processor. How-To-Repeat: Just unpack the distribution and call configure whithout any options. Than call make. Fix: Submitter-Id: Dont have one Originator: Super-User Organization: institute of applied physiks Frankfurt germany MySQL support: none Synopsis: dose not compile Severity: critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.52 (Source distribution) Environment: Sun Ultra 5, Solaris 8, Sun Untra 5,libc as delivered with the OS also the newest librarys which are delivered with the gcc 3.2 from www.sunfreeware.com libstdc++.so.5.0.0 libg2c.so.0.0.0 libgcj.so.3.0.0 System: SunOS cnna 5.9 Generic sun4u sparc SUNW,Ultra-5_10 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.9/3.2/specs Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld --disable-nls Thread model: posix gcc version 3.2 Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloa ded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors - fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1828460 Apr 6 21:46 /lib/libc.a lrwxrwxrwx 1 root root 11 Aug 20 13:32 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 855484 Apr 6 21:46 /lib/libc.so.1 -rw-r--r-- 1 root bin 1828460 Apr 6 21:46 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Aug 20 13:32 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 855484 Apr 6 21:46 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr
downloadable source distribution package of Mysql for solaris
query, mysql, sql A very basic question as I have no other options left but to ask. I need to download source distribution package of mysqlmax version 3.23.52 for solaris 2.8 but on the www.mysql.com site I always find the binary package version for mysqlmax for solaris. Please let me know the links where I can download the source distribution package of the same Rgds, - 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: downloadable source distribution package of Mysql for solaris
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Friday 06 September 2002 11:15, Chugh Shalini wrote: I need to download source distribution package of mysqlmax version 3.23.52 for solaris 2.8 but on the www.mysql.com site I always find the binary package version for mysqlmax for solaris. Please let me know the links where I can download the source distribution package of the same There is no separate source distribution for the max package, since they are all being built out of the same sources. It just depends on how you configure the sources what kind of binary you will build. If you need InnoDB, just download mysql-3.23.52.tar.gz and run configure with --with-innodb. Bye, LenZ (query, mysql, sql) - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9eLi9SVDhKrJykfIRAhtOAJ95aY60DLa1Wv4vY1Otb3PyhV/8vgCffynU KqSAx9UYhLzXG6oVF2Nx994= =7kU3 -END PGP SIGNATURE- - 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
How I compiled MySQL on Solaris 8
Hi All It seems that compiling MySQL on a Solaris 8 box is a non-trivial task if your environment is different to the MySQL developers (whatever that is). It has taken me a couple of days, hacking trawling the mailing list to get a successful compile. I thought I would share my findings with others, and hope that maybe it might be incorporated into the build and documentation (do I have to submit a bug??). Regards John Solaris Environment: * Solaris 8 02/02 + July 2002 Recommended Patches * gcc version 3.1.1 * Sun ld in /usr/ccs/bin * mysql-3.23.51 * Extra libraries (such as zlib) installed in /usr/local/lib NOTE: Setting LD_LIBRARY_PATH is required even though we tell the compiler to look for libraries in /usr/local/lib. sigh. LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib export LD_LIBRARY_PATH * Hack to ./configure because it *assumes* we are using gnu ld, but we only want to use Sun ld, which just doesn't like these options and dies with: Error: /usr/ccs/bin/ld: illegal option -- - ld: fatal: option -d has illegal argument `efsym' johnw@dawkins% diff -c configure /var/tmp/mysql-3.23.51/configure *** configure Tue Aug 13 16:56:07 2002 --- /var/tmp/mysql-3.23.51/configureMon Jun 3 20:39:20 2002 *** *** 3827,3837 then if $CXX -v 21 | grep 'version 3' /dev/null 21 then ! if test $ac_cv_prog_gnu_ld = yes ! then ! CXXFLAGS=$CXXFLAGS -DUSE_MYSYS_NEW ! CXXLDFLAGS=$CXXLDFLAGS -Wl,--defsym -Wl,__cxa_pure_virtual=0 ! fi fi fi fi --- 3827,3834 then if $CXX -v 21 | grep 'version 3' /dev/null 21 then ! CXXFLAGS=$CXXFLAGS -DUSE_MYSYS_NEW ! CXXLDFLAGS=$CXXLDFLAGS -Wl,--defsym -Wl,__cxa_pure_virtual=0 fi fi fi * Configure options as per documentation: CC=gcc CFLAGS=-O3 LDFLAGS=-L/usr/local/lib CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler Would very much like to include CXXLD=g++ into configure line so I don't have to hack client/Makefile, et al but it is ignored. * Hack to client/Makefile, mysys/Makefile, sql/Makefile as we are using Sun's ld and CXX=gcc, but don't want to get __cxa_pure_virtual symbol not found error. Ref solution from MySQL mailing list: http://www.geocrawler.com/archives/3/8/2001/11/50/7205532/ CXXLD = g++ * Edit config.h so that #define SOCKET_SIZE_TYPE size_t as per Problems Compiling? section of manual. I do not understand autoconf enough to work out why it is having problems picking this up. In the documentation, at the top of the section entitled Problems Compiling?, it is stated that All MySQL programs compile cleanly for us with no warnings on Solaris using `gcc'.. I really think that this needs to be qualified a bit more. Looking through the MySQL lists, it seems like compiling on Solaris for a lot of people is a major saga. Could you also state: * version of Solaris * version of gcc * whether you are using Sun ld or Gnu ld * location of libraries and binaries such as libz and ld - 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: How I compiled MySQL on Solaris 8
- Original Message - From: John Warburton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 3:17 AM Subject: How I compiled MySQL on Solaris 8 Hi All It seems that compiling MySQL on a Solaris 8 box is a non-trivial task if your environment is different to the MySQL developers (whatever that is). It has taken me a couple of days, hacking trawling the mailing list to get a successful compile. I thought I would share my findings with others, and hope that maybe it might be incorporated into the build and documentation (do I have to submit a bug??). Worked like a charm. Thanks for all your hard work. Looks like I'll be updating my aged HOWTO :) -- Alan W. Rateliff, II: RATELIFF.NET Independent Technology Consultant :[EMAIL PROTECTED] (Office) 850/350-0260: (Mobile) 850/559-0100 - [System Administration][IT Consulting][Computer Sales/Repair] - 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 On Solaris
Hi All Can anyone refer me to any document which speaks about Installing MySQL 3.23.51 on Solaris 2.8 Sparc -Arul 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: MySQL On Solaris
The Document at www.mysql.com/manual is not clear for a Mysql beginner like me... Any Step by Step procedure... What should i do with the downloaded tar file .. I Had installed MySql in Windows.. But installing it in Solaris is not clear... -Arul - Original Message - From: Arul [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 6:43 PM Subject: MySQL On Solaris Hi All Can anyone refer me to any document which speaks about Installing MySQL 3.23.51 on Solaris 2.8 Sparc -Arul 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 - 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 4.0.1 Solaris 2.7 slave crash / mysqlimport
Hello MySQL 4.0.1 Solaris 2.7 official binary reproducibly crashes with sig 11 when run in a slave mode and when its master (4.0.1 official Linux binary) is populated via mysqlimport tool from a remote machine. Here are some interesting log files [edited]: , $ mysqld --user=mysql | 020612 11:44:04 Slave: connected to master 'foo@bar:3306', replication started in |log 'foo-bin.004' at position 276991 | mysqld got signal 11; | This could be because you hit a bug. It is also possible that this binary [...] ` No stack is dumped. The crash is reproducible. The OS trace says: , $ truss mysqld --user=mysql | close(14) = 0 | Incurred fault #6, FLTBOUNDS %pc = 0x00106564 | siginfo: SIGSEGV SEGV_MAPERR addr=0x0200 | Received signal #11, SIGSEGV [caught] | siginfo: SIGSEGV SEGV_MAPERR addr=0x0200 | sysconfig(_CONFIG_SIGRT_MIN)= 38 | sigprocmask(SIG_SETMASK, 0xFF33D9A8, 0x) = 0 | sigaction(SIGSEGV, 0xFE780EB8, 0x) = 0 | mysqld got signal write(2, m y s q l d g o t s.., 18)= 18 ` The slave bin log says: , $ mysqlbinlog data/baz-bin.004 | #020612 2:56:21 server id 456 Query thread_id=1 exec_time=29835 error_code=0 | use a; | SET TIMESTAMP=1023843381; | DELETE FROM a; | # at 268641 | LOAD DATA INFILE '/var/tmp/SQL_LOAD-123-456-1.data' REPLACE INTO TABLE a FIELDS |TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' |LINES STARTING BY '' (a,b,c,d,e,f,g,h); | file_id=1, block_len=8191 ` The manual says that all forms of LOAD DATA INFILE should be properly replicated in MySQL 4.0. There might be a problem with remote mysqlimport, then. It was started on a remove machine with the -h option, but without the -L option. (Note that slave works perfectly fine after replicate-ignore-db=a, as I do not need a to be replicated. I just wanted to let you know of the problem...) Tibor - 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
Creating user and group mysql on Solaris
We have Solaris 2.8 and here is what we did to create the mysql user and group: - First add the group: groupadd mysql - Next add the user: useradd mysql -g mysql This also adds the user to the group mysql. - Put the user root in the mysql group: usermod -G mysql root - 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
Problem running MySql on Solaris 8?
Every time I run safe_mysqld, I get the following error message: # ./safe_mysqld chown: unknown user id mysql Starting mysqld daemon with databases from /usr/local/mysql/var Killed 020308 22:12:04 mysqld ended # How do I handle this? __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.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 on Solaris
Hi members, This is my first query :) My query is about installing MySql on Solaris. I am interested in downloading and installing the stable version of MySql on solaris 2.6. I downloaded mysql-3.22.25-solaris7-x86.pkg.tgz and MySQL 3.23. I tried to install the first one (used GNU tar) . I followed the documentation and tried to install the binary. I had various problems. when i ran mysql_install_db, it gives error thast user id mysql not created. make install is giving error saying mysql not intialized. Also when i tried with MySQL 3.23, i was unable to configure and build. I could succesfully download and install MySql for Windows 95, but Solaris has given me a lot of problems. I request members to please send me a doc or explain the installation of MySql on Solaris 2.6. The link http://www.mysql.com/doc/S/o/Solaris_2.7.html does not help me much as you can see. I am interested in downloading and installing the binaries only. Please help me to to get it up and running. In anticipation Best Regards, Anis - 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 on Solaris
Ahmed, Forget about it. I tried to do this, I tried for about two weeks, then got mad and downloaded the src and compile it mysql. It works great. -chad if you do get it working let me know On Thu, 07 Mar 2002 09:14:58 -0700 Ahmed S K Anis [EMAIL PROTECTED] wrote: Hi members, This is my first query :) My query is about installing MySql on Solaris. I am interested in downloading and installing the stable version of MySql on solaris 2.6. I downloaded mysql-3.22.25-solaris7-x86.pkg.tgz and MySQL 3.23. I tried to install the first one (used GNU tar) . I followed the documentation and tried to install the binary. I had various problems. when i ran mysql_install_db, it gives error thast user id mysql not created. make install is giving error saying mysql not intialized. Also when i tried with MySQL 3.23, i was unable to configure and build. I could succesfully download and install MySql for Windows 95, but Solaris has given me a lot of problems. I request members to please send me a doc or explain the installation of MySql on Solaris 2.6. The link http://www.mysql.com/doc/S/o/Solaris_2.7.html does not help me much as you can see. I am interested in downloading and installing the binaries only. Please help me to to get it up and running. In anticipation Best Regards, Anis - 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
how to setup mysql with Solaris 8?
I downloaded the following file from mysql.com. mysql-3.23.47-sun-solaris2.8-sparc.tar I untarred it into /mysql, then I have the following files. Look here: # ls bin include scripts sql-bench tests data lib share support-files # Then I went into /mysql/bin and tried running mysql like so: # mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) # And I get the error message shown above. What should I do to set it up? Thanks. Jack __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.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
Accessing large memory with 64-bit MySQL on Solaris
We've built MySQL 3.23.46 on Solaris 8/SPARC as a 64-bit executable using the Sun C compiler. Everything built OK. We built against ncurses, readline, and zlib, all built as 64-bit libraries. Are there any special settings to get MySQL to work properly in this environment or should things work as expected. If the server is started with the following settings: key_buffer=4608M max_allowed_packet=1M table_cache=1024 record_buffer=1M sort_buffer=1M thread_cache=12 thread_concurrency=12 myisam_sort_buffer_size=512M then mysqladmin variables shows key_buffer as 1G, not 4.5G. The Solaris 8 machine this is running on has 6GB real memory and 14.5GB of swap. -- albert chin ([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
Can't untar mysql on Solaris 8
Hi. I've downloaded the .tar.gz files for MySQL 3.23.48, 3.23.47 and 3.23.46 for Sparc-Solaris 8 and all of them complain of a checksum error on the tar-extract. Here's the output of tar xvf of the gunzip'd-tar file: x mysql-3.23.46-sun-solaris2.8-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.35_i686-cmp-adabas,mysql, 691 bytes, 2 tape blocks tar: directory checksum error All 3 versions give this error at the same spot. I've downloaded these versions off several mirror sites using both HTTP and FTP through my browser and also using FTP without using the browser and every one gives the same problem. Can anyone please tell me what's going on? Is this a known bug? I'm using Sun's /usr/sbin/tar program. The tar tvf lists out all the contents properly but the extract doesn't work. I've run the tar xf as root and as a normal id - same problem. I am running Solaris 8 on an Ultra-1 workstation. Thanks, Eurico - 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: Can't untar mysql on Solaris 8
Yes, it's a bug. In Solaris. You must use GNU tar, not Solaris tar. http://www.mysql.com/doc/S/o/Solaris.html At 12:15 -0500 1/30/02, Eurico de Sousa wrote: Hi. I've downloaded the .tar.gz files for MySQL 3.23.48, 3.23.47 and 3.23.46 for Sparc-Solaris 8 and all of them complain of a checksum error on the tar-extract. Here's the output of tar xvf of the gunzip'd-tar file: x mysql-3.23.46-sun-solaris2.8-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.35_i686-cmp-adabas,mysql, 691 bytes, 2 tape blocks tar: directory checksum error All 3 versions give this error at the same spot. I've downloaded these versions off several mirror sites using both HTTP and FTP through my browser and also using FTP without using the browser and every one gives the same problem. Can anyone please tell me what's going on? Is this a known bug? I'm using Sun's /usr/sbin/tar program. The tar tvf lists out all the contents properly but the extract doesn't work. I've run the tar xf as root and as a normal id - same problem. I am running Solaris 8 on an Ultra-1 workstation. Thanks, Eurico - 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: Can't untar mysql on Solaris 8
Use gtar. Eurico de Sousa wrote: Hi. I've downloaded the .tar.gz files for MySQL 3.23.48, 3.23.47 and 3.23.46 for Sparc-Solaris 8 and all of them complain of a checksum error on the tar-extract. Here's the output of tar xvf of the gunzip'd-tar file: x mysql-3.23.46-sun-solaris2.8-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.35_i686-cmp-adabas,mysql, 691 bytes, 2 tape blocks tar: directory checksum error All 3 versions give this error at the same spot. I've downloaded these versions off several mirror sites using both HTTP and FTP through my browser and also using FTP without using the browser and every one gives the same problem. Can anyone please tell me what's going on? Is this a known bug? I'm using Sun's /usr/sbin/tar program. The tar tvf lists out all the contents properly but the extract doesn't work. I've run the tar xf as root and as a normal id - same problem. I am running Solaris 8 on an Ultra-1 workstation. Thanks, Eurico - 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: Can't untar mysql on Solaris 8
Solaris tar is broken (can't handle long file names). You need to use GNU tar. See http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Solaris Michael On Wed, 30 Jan 2002, Eurico de Sousa wrote: Hi. I've downloaded the .tar.gz files for MySQL 3.23.48, 3.23.47 and 3.23.46 for Sparc-Solaris 8 and all of them complain of a checksum error on the tar-extract. Here's the output of tar xvf of the gunzip'd-tar file: x mysql-3.23.46-sun-solaris2.8-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.35_i686-cmp-adabas,mysql, 691 bytes, 2 tape blocks tar: directory checksum error All 3 versions give this error at the same spot. I've downloaded these versions off several mirror sites using both HTTP and FTP through my browser and also using FTP without using the browser and every one gives the same problem. Can anyone please tell me what's going on? Is this a known bug? I'm using Sun's /usr/sbin/tar program. The tar tvf lists out all the contents properly but the extract doesn't work. I've run the tar xf as root and as a normal id - same problem. I am running Solaris 8 on an Ultra-1 workstation. Thanks, Eurico - 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
Can't install mysql on Solaris-2.5.1.
Dear sir, I used mysql-4.0.1 running on Solaris-2.5.1 and compile with Gcc-2.95.3. (package from www.sunfreeware.com) I used command below. CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler \ --with-charset=tis620 And then when I used command make, it has error messages below. ft_dump.o: In function `main': ft_dump.o(.text+0x26c): undefined reference to `snprintf' collect2: ld returned 1 exit status *** Error code 1 make: Fatal error: Command failed for target `ft_dump' Current working directory /misc/mysql/mysql-4.0.1-alpha/myisam *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /misc/mysql/mysql-4.0.1-alpha *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' Please let me know how to solve this problem. thank you very much. regards, Somsak. - 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: Can't untar mysql on Solaris 8
Appreciate those of you referring me to GNU tar - it did untar mysql properly whereas SUN's tar couldn't. Eurico - 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
Can't install mysql on Solaris-2.5.1.
Dear sir, I used mysql-4.0.1 running on Solaris-2.5.1 and compile with Gcc-2.95.3. (package from www.sunfreeware.com) I used command below. CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler \ --with-charset=tis620 And then when I used command make, it has error messages below. ft_dump.o: In function `main': ft_dump.o(.text+0x26c): undefined reference to `snprintf' collect2: ld returned 1 exit status *** Error code 1 make: Fatal error: Command failed for target `ft_dump' Current working directory /misc/mysql/mysql-4.0.1-alpha/myisam *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /misc/mysql/mysql-4.0.1-alpha *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' Please let me know how to solve this problem. thank you very much. regards, Somsak. - 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
Can't install mysql on Solaris-2.5.1.
Dear sir, I used mysql-4.0.1 running on Solaris-2.5.1 and compile with Gcc-2.95.3. (package from www.sunfreeware.com) I used command below. CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler \ --with-charset=tis620 And then when I used command make, it has error messages below. ft_dump.o: In function `main': ft_dump.o(.text+0x26c): undefined reference to `snprintf' collect2: ld returned 1 exit status *** Error code 1 make: Fatal error: Command failed for target `ft_dump' Current working directory /misc/mysql/mysql-4.0.1-alpha/myisam *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /misc/mysql/mysql-4.0.1-alpha *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' Please let me know how to solve this problem. thank you very much. regards, Somsak. - 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
compiling and/or running 64-bit MySQL on Solaris 8/sparc?
Is it possible to compile and run MySQL as a 64-bit program on Solaris 8?
If so, are there precompiled bits available?
The primary reason for doing this is to determine if a 64-bit version would
allow the database to be larger than 4-gig. I have been told by another
member of our team MySQL has such a limit, and he suggested a 64-bit build
might overcome it. Is this correct?
I've been attempting to compile MySQL 3.23.47 and 4.0.1 as a 64-bit program
using gcc 3.0.3. To build the GCC 3.0.3 with 64 bit capabilities I believe
I followed the example found here faithfully:
http://www.well.com/~jax/rcfb/solaris_tips/build_gcc_3.0_64bit.html
http://www.well.com/~jax/rcfb/solaris_tips/build_gcc_3.0_64bit.html
When I attempt to build the MySQL I get an argument from the ./configure
script telling me checking return type of sprintf... configure: error: can
not run test program while cross compiling. I'm not an expert in the area
of gcc and the gnu tools, so I may well have done something wrong somewhere
along the line. I'd like to know if I am attempting something that can be
accomplished. Has anybody got this working?
Here is the complete dump of the configure script:
bash-2.03# ./configure --prefix=/opt/ --host=sparcv9-sun-solaris2
loading cache ./config.cache
checking host system type... sparcv9-sun-solaris2
checking target system type... sparcv9-sun-solaris2
checking build system type... sparcv9-sun-solaris2
checking for a BSD compatible install... (cached) /usr/local/bin/install -c
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... (cached) yes
checking for working aclocal... found
checking for working autoconf... found
checking for working automake... found
checking for working autoheader... found
checking for working makeinfo... missing
checking whether to enable maintainer-specific portions of Makefiles... no
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... (cached) yes
checking for gawk... (cached) nawk
checking for gcc... (cached) gcc
checking whether the C compiler (gcc ) works... yes
checking whether the C compiler (gcc ) is a cross-compiler... no
checking whether we are using GNU C... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking for c++... (cached) c++
checking whether the C++ compiler (c++ ) works... yes
checking whether the C++ compiler (c++ ) is a cross-compiler... yes
checking whether we are using GNU C++... (cached) yes
checking whether c++ accepts -g... (cached) yes
checking how to run the C preprocessor... (cached) gcc -E
checking for ranlib... (cached) ranlib
checking for ld used by GCC... (cached) /usr/ccs/bin/ld
checking if the linker (/usr/ccs/bin/ld) is GNU ld... (cached) no
checking for BSD-compatible nm... (cached) /usr/local/bin/nm -B
checking whether ln -s works... (cached) yes
loading cache ./config.cache within ltconfig
checking for object suffix... o
checking for executable suffix... (cached) no
checking for gcc option to produce PIC... -fPIC
checking if gcc PIC flag -fPIC works... yes
checking if gcc supports -c -o file.o... yes
checking if gcc supports -c -o file.lo... yes
checking if gcc supports -fno-rtti -fno-exceptions ... yes
checking if gcc static flag -static works... none
checking if the linker (/usr/ccs/bin/ld) is GNU ld... no
checking whether the linker (/usr/ccs/bin/ld) supports shared libraries...
yes
checking command to parse /usr/local/bin/nm -B output... ok
checking how to hardcode library paths into programs... immediate
checking for /usr/ccs/bin/ld option to reload object files... -r
checking dynamic linker characteristics... solaris2 ld.so
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
checking for objdir... .libs
creating libtool
loading cache ./config.cache
checking for a BSD compatible install... /usr/local/bin/install -c
checking for bison... bison -y
checking for pdftex... no
checking return type of sprintf... configure: error: can not run test
program while cross compiling
bash-2.03#
-
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
Fwd: Re: compiling and/or running 64-bit MySQL on Solaris 8/sparc?
Forgot to CC to the list. Here it goes, in case anyone else has these problems: -- Forwarded Message -- Subject: Re: compiling and/or running 64-bit MySQL on Solaris 8/sparc? Date: Fri, 18 Jan 2002 15:06:57 +0200 From: Markus Lervik [EMAIL PROTECTED] To: Hatton Steven [EMAIL PROTECTED] On Friday 18 January 2002 13:57, you wrote: [BIG snip] checking return type of sprintf... configure: error: can not run test program while cross compiling bash-2.03# [/snip] Try adding export LDFLAGS='-R/usr/local/lib' or export LDFLAGS='-R/opt/sfw/lib' before ./configure. Cheers, Markus -- Markus Lervik UNIX-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 - 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: Re: compiling and/or running 64-bit MySQL on Solaris 8/sparc?
-Original Message- From: Markus Lervik [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 8:08 AM To: [EMAIL PROTECTED] Subject:Fwd: Re: compiling and/or running 64-bit MySQL on Solaris 8/sparc? On Friday 18 January 2002 13:57, you wrote: [BIG snip] checking return type of sprintf... configure: error: can not run test program while cross compiling bash-2.03# [/snip] Try adding export LDFLAGS='-R/usr/local/lib' or export LDFLAGS='-R/opt/sfw/lib' before ./configure. Cheers, Markus Markus, Thank you for the reply. I'm not sure of the reason for the LDFLAGS variable. What library files should I be pointing to with it? I put my gcc in /opt/gcc-3.0.3-64. Will this influence the proper choice of value for LDFLAGS? Steven - 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
Obtaining MySQL for Solaris 8, Intel Version
Hello, Where can I get a version of MySQL for Solaris 8, Intel version? Do I use the FreeBSD version of MySQL or should I d/l the Linux version? I am just getting used to the Solaris / UNIX environment. Thanks, Paul __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.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: Obtaining MySQL for Solaris 8, Intel Version
On Wed, Sep 26, 2001 at 12:41:43PM -0700, Pauljames Dimitriu wrote: Hello, Where can I get a version of MySQL for Solaris 8, Intel version? Do I use the FreeBSD version of MySQL or should I d/l the Linux version? I am just getting used to the Solaris / UNIX environment. I do not see a binary version for solaris/intel so you should download the source code and recompile it. You will most probably need to install some tools for that. all the gnu development tools are available and mysql compiles fine with those. you can also install sun's compilers if you enjoy paying license fees. have a good time! - 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: Obtaining MySQL for Solaris 8, Intel Version
Pauljames Dimitriu writes: Hello, Where can I get a version of MySQL for Solaris 8, Intel version? Do I use the FreeBSD version of MySQL or should I d/l the Linux version? I am just getting used to the Solaris / UNIX environment. Hi, It seems that the latest build that we have of Solaris 8 (Intel) is for version 3.23.39. For a newer build, you will have to download the source tarball and compile yourself. You can find version 3.23.39 of standard MySQL (without transactions) here: http://www.mysql.com/downloads/mysql-3.23.html Or version 3.23.39 of MySQL-Max (with transactions): http://www.mysql.com/downloads/mysql-max-3.23.html Both are found in the Solaris section. Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA ___/ 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
Problems running MAKE for MySQL on SOlaris 2.7
My apologies in advance if this question has been answered in a previous thread. I am a novice at MySQL and would appreciate any guidance any of the more knowledable members of the list could provide. I am installing mysql-3.23.42 on Solaris 2.7. I run configure with the following: CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static Configure appears to complete with no problems, but when moving to the next step, running make, I get the following: ld.so.1: /usr/local/bin/perl: fatal: libgdbm.so.2: open failed: No such file or directory Killed make[2]: *** [manual.html] Error 137 I searched the net using this string and found that this appears to be a reoccuring problem with open-source software installs on Solaris. Has anyone else seen this problem installing MySQL? Myke Fisher Systems Engineering - IP Communications 972-248-8210 ext. 1432 [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: Error Compiling mysql under Solaris
David Turner writes: Does anyone have a good configure statement I could try for making MYSQL on Solaris for Sparc? I've got it compiling on X86 but I get a parser error I've only seen mention of once on the lists, and I did not see how to identify the reserved word I am using? I'll continue digging around, but if someone has a quick fix I would really appreciate it. Here's the error sql_yacc.yy, line 71: fatal: invalid escape, or illegal reserved word: pure_parser Os and mysql versions: 5.7 Generic_106541-09 sun4u sparc SUNW,UltraSPARC-IIi-cEngine mysql-3.23.41 Thanks, Dave You should use GNU bison in order to generate C++ out of sql_yacc.yy. -- 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
Error Compiling mysql under Solaris
Does anyone have a good configure statement I could try for making MYSQL on Solaris for Sparc? I've got it compiling on X86 but I get a parser error I've only seen mention of once on the lists, and I did not see how to identify the reserved word I am using? I'll continue digging around, but if someone has a quick fix I would really appreciate it. Here's the error sql_yacc.yy, line 71: fatal: invalid escape, or illegal reserved word: pure_parser Os and mysql versions: 5.7 Generic_106541-09 sun4u sparc SUNW,UltraSPARC-IIi-cEngine mysql-3.23.41 Thanks, Dave - 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
problems untarring mysql under solaris
Hi all: I am running solaris 2.5.1 and I am having difficulties untarring mysql. It decompresses a fair bit and then it shows a crc error. I tried 2 diff ver .38 and .39. In addition, I tried using gnu tar to decompress it however that binary just hangs. any help would be greatly appreciated. regards Imran.
Re: problems untarring mysql under solaris
Hi, This is a known problem with solaris tar, I suggest you use gnu tar for solaris, This should solve your current problem. You can get a pre-build package of gnu tar at www.sunfreeware.com [EMAIL PROTECTED] wrote: Hi all: I am running solaris 2.5.1 and I am having difficulties untarring mysql. It decompresses a fair bit and then it shows a crc error. I tried 2 diff ver .38 and .39. In addition, I tried using gnu tar to decompress it however that binary just hangs. any help would be greatly appreciated. regards Imran. - 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
asp dev looking to connect to mysql on solaris
Hello everyone, I should start by saying that though an experienced vb/asp/ado windows developer I have little experience with solaris or mysql. The task i am facing is to connect and read some data from a W2K box by connecticting to a Solaris box running MySQL. What do I do??? Please, provide step by step information. -- Best regards, Akan mailto:[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
Symbol not found error when installing mySQL on Solaris 2.5.1
I am trying to install mySQL on my Solaris 2.5.1 system. I have downloaded the latest binary and followed the instructions as best I understand them (not being very familiar with UNIX systems). I have not used the default directory (/usr/local/mysql). I have not found a solution for the following error message; ld.so.1: ./bin/mysqld: fatal: relocation error: symbol not found: fopen64: referenced in ./bin/mysqld This is generated when I run ./scripts/mysql_install_db. My searching has found many instances of others experiencing the same problem, but so far no fix! Any suggestions most gratefully received. RJS Robert J Sedman. Nimbus Technology Engineering Limited - 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: Symbol not found error when installing mySQL on Solaris 2.5.1
Rob Sedman writes: I am trying to install mySQL on my Solaris 2.5.1 system. I have downloaded the latest binary and followed the instructions as best I understand them (not being very familiar with UNIX systems). I have not used the default directory (/usr/local/mysql). I have not found a solution for the following error message; ld.so.1: ./bin/mysqld: fatal: relocation error: symbol not found: fopen64: referenced in ./bin/mysqld This is generated when I run ./scripts/mysql_install_db. My searching has found many instances of others experiencing the same problem, but so far no fix! Any suggestions most gratefully received. RJS Robert J Sedman. Nimbus Technology Engineering Limited Hi! We do not build anymore 2.5 binaries, so you are probably using 2.6 or 2.7 binaries which will not work on 2.5. So, either build it from source, or upgrade your Solaris. -- Regards, For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /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
MySQL on Solaris 2.8
System Sun Fire 280R with dual USIII @ 750Mhz and 8G RAM. Solaris 01/01
media kit installed
Can anyone point me to the reason this is happening?
[ paul@tbd /usr/src/mysql-3.23.38 ] $ sudo
./configure --prefix=/usr/local/mysql
loading cache ./config.cache
checking host system type... sparc-sun-solaris2.8
checking target system type... sparc-sun-solaris2.8
checking build system type... sparc-sun-solaris2.8
checking for a BSD compatible install... /opt/sfw/bin/ginstall -c
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... yes
checking for working aclocal... found
checking for working autoconf... found
checking for working automake... found
checking for working autoheader... found
checking for working makeinfo... found
checking whether to enable maintainer-specific portions of Makefiles... no
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... (cached) yes
checking for gawk... gawk
checking for gcc... gcc
checking whether the C compiler (gcc ) works... no
configure: error: installation or configuration problem: C compiler cannot
create executables.
Configure.log shows:
This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.
configure:812: checking host system type
configure:833: checking target system type
configure:851: checking build system type
configure:886: checking for a BSD compatible install
configure:939: checking whether build environment is sane
configure:974: checking whether make sets ${MAKE}
configure:1020: checking for working aclocal
configure:1033: checking for working autoconf
configure:1046: checking for working automake
configure:1059: checking for working autoheader
configure:1072: checking for working makeinfo
configure:1174: checking whether to enable maintainer-specific portions of
Makefiles
configure:1216: checking whether build environment is sane
configure:1233: checking whether make sets ${MAKE}
configure:1301: checking for gawk
configure:1333: checking for gcc
configure:1446: checking whether the C compiler (gcc ) works
configure:1462: gcc -o conftest conftest.c 15
gcc: installation problem, cannot exec `as': No such file or directory
configure: failed program was:
#line 1457 configure
#include confdefs.h
main(){return(0);}
I do have binutils installed
[ paul@tbd /usr/src/mysql-3.23.38 ] $ pkginfo | grep binutils
system SFWgbinbinutils - GNU binary utilities
Any help would be greatly appreciated. Thanks in advance,
Paul
-
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
Installing MySQL on Solaris as a user(not root)
I have a problem running MySQL on Solaris. I downloaded the source and compiled it following all the instructions and made mysql directory in my home directory. When I enter mysqladmin version I get: mysqladmin Ver 6.9 Distrib 3.21.33b, for sun-solaris2.8 on sparc TCX Datakonsult AB, by Monty Server version 3.23.37 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 2 hours 30 min 51 sec Threads: 1 Questions: 8 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.001 But when I give the command safe_mysqld I get: Starting mysqld demon with databases from /usr/local/mysql/var /usr/local/bin/safe_mysqld: /usr/local/mysql/var/grdmss57.log: cannot create It seems to me it can't create because I am not a root. What should I do? Also I can't create my password for MySQL. I get mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'm5051236@localhost' (Using password: YES)' If you have any information how to manage MySQL installed in home directory, please, help me. Maybe, I did smth wrong while installing(for example, if we install Apache in the home dir, we can choose port number etc.)? - 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: Installing MySQL on Solaris as a user(not root)
Since mysqladmin ran, the server is already running. Roman Shtykh wrote: I have a problem running MySQL on Solaris. I downloaded the source and compiled it following all the instructions and made mysql directory in my home directory. When I enter mysqladmin version I get: mysqladmin Ver 6.9 Distrib 3.21.33b, for sun-solaris2.8 on sparc TCX Datakonsult AB, by Monty Server version 3.23.37 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 2 hours 30 min 51 sec Threads: 1 Questions: 8 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.001 But when I give the command safe_mysqld I get: Starting mysqld demon with databases from /usr/local/mysql/var /usr/local/bin/safe_mysqld: /usr/local/mysql/var/grdmss57.log: cannot create It seems to me it can't create because I am not a root. What should I do? Also I can't create my password for MySQL. I get mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'm5051236@localhost' (Using password: YES)' If you have any information how to manage MySQL installed in home directory, please, help me. Maybe, I did smth wrong while installing(for example, if we install Apache in the home dir, we can choose port number etc.)? - 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 -- Gerald L. Clark [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
mysql on solaris
checking host system type... sparc-sun-solaris2.7 checking target system type... sparc-sun-solaris2.7 i am trying to install mysql 3.23.37 from source on solaris 2.7 on sparc. i managed to install the binary distribution, and it works, but it does not work with php4.0.4pl1 i suspect this is because there is no libmysql.so with the standard binary distribution, only a libmysql.a configure on my platform crashes. the first problem is that at a certain moment it thinks that it is cross compiling. i will send more error reports, because this is not the only problem this is what happens (icluded configure output and config.log checking build system type... sparc-sun-solaris2.7 checking for a BSD compatible install... ./install-sh -c checking whether build environment is sane... yes checking for bison... bison -y checking for pdftex... manual.pdf checking return type of sprintf... configure: error: can not run test program while cross compiling ltconfig:1654: gcc -cconftest.c 15 ltconfig:1657: eval /usr/ccs/bin/nm -p conftest.o | sed -n -e 's/^.*[ ]\([BDT] \)[ ][ ]*\(\)\([_A-Za-z][_A-Za-z0-9]*\)$/\1 \2\3 \3/p' conftest.nm ltconfig:1709: gcc -o conftest -fno-builtin -fno-rtti -fno-exceptions confte st.c conftstm.o 15 configure:2250: checking for a BSD compatible install configure:2308: checking for bison configure:2341: checking for pdftex configure:2369: checking return type of sprintf -- Erich Neuwirth, Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-38624 Fax: +43-1-4277-9386 - 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 XSQL (Solaris/Apache/Jserv)
I'm trying to get the Oracle XSQL servlet to work with MySQL (through the mm.mysql.jdbc-1.2c driver) under Solaris but I keep getting the following error message (using the xsql command-line tool): --- % sh $XSQL/bin/xsql test.xsql test.htm Oracle XSQL Command Line Page Processor 1.0.4.1 (Production) XSQL-007: Cannot acquire a database connection to process page. Cannot disable AUTO_COMMIT --- My configuration is: test.xsql - ?xml version="1.0"? DbTest elt="query" xmlns:xsql="urn:oracle-xsql" connection="xsqlDsin" xsql:query SELECT * AS text FROM text /xsql:query /DbTest XSQLConfig.xml -- ... connection name="xsqlDsin" usernameUSER_NAME/username passwordPASSWORD/password dburljdbc:mysql://host:3306/xsqlDsinTest/dburl driverorg.gjt.mm.mysql.Driver/driver /connection ... jserv.conf -- ApJServAction .xsql /servlets/oracle.xml.xsql.XSQLServlet jserv.properties wrapper.classpath=/xsql/mm.mysql.jdbc-1.2c/org/gjt/mm/mysql/Driver.class - 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 and Solaris.
I started this question yesterday. Since I can not get a compiled version of mysql to run on Sparc Solaris 2.6. I thought I would try and recompile mysql myself. This also failed miserably with the "cross compile" error. My question is this .. Has anyone gotten mysql to run on a sparc system runing Solairs 2.6. If so could you give details as what software you used to compile the native. Which version of complier and which version of mysql source code was used.. Thanks V/R Greg Wejrwoski - 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: Compiling MySQL on Solaris with -static: Impossible? Why??
Sinisa Milivojevic explained me that : "Unfortunately you can not build static programs on Solaris, as Sun has not provided static versions for many of it's libraries." Regards, -- Pascal Thivent -Message d'origine- De: Johan Andersson [mailto:[EMAIL PROTECTED]] Date: vendredi 23 mars 2001 14:25 : [EMAIL PROTECTED] Objet: Compiling MySQL on Solaris with -static: Impossible? Why?? Is it true that you can't compile on Solaris with -static ?? If so, why is that so?? Regards, Johan Andersson - 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 3.23.33 Solaris x86 Problem
Hello, I'm new to mySQL, and I need a binary release for Solaris x86. Unless somebody knows why I can't compile the source. I'm using the GCC compiler version 2.95.2. Here is my configure script: CC=gcc CFLAGS="-O6 -fomit-frame-pointer -DHAVE_CURSES_H" \ CXX=gcc \ CXXFLAGS="-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -DHAVE_CURSES_H" \ ../configure --prefix=/usr/local/mysql Here is the error I am getting in the make: In file included from mysql.cc:53: /opt/sfw/include/curses.h:96: declaration does not declare anything *** Error code 1 make: Fatal error: Command failed for target `mysql.o' Current working directory /u3/software/unix/install/mysql-3.23.33/client *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /u3/software/unix/install/mysql-3.23.33 *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' Any help either way would be greatly appreciated. Thanks, Rob - 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
help mysql on solaris
hi,all when i compile mysql on Solaris 2.6 , i just run : ./configure it allways said : checking return type of sprintf... configure: error: can not run test program wh ile cross compiling anybody help me ? thanks thanks thanks wallace
can't build mysql under solaris 7
Trying to build mysql-3.23.32 under solaris 7 with gcc version 2.95.2 19991024 (release) got error message : gcc -DDEFAULT_CHARSET_HOME=\"/usr/local\" -DDATADIR=\"/usr/local/var\" -DSHAREDIR=\"/usr/local/share/mysql\" -DUNDEF_THREADS_HACK -I./../include -I../include -I ./.. -I.. -I.. -O6 -DDBUG_OFF -DHAVE_CURSES_H -I/export/home/iav/mysql-3.23.32/include -DHAVE_RWLOCK_T -c libmysql.c -fPIC -DPIC -o .libs/libmysql.lo In file included from ../include/global.h:151, from libmysql.c:23: /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/include/math.h:5: math.h: No such file or directory make[2]: *** [libmysql.lo] Error 1 what does it mean? What is than math.h, it cann't find? I ried to find it myself - and fail: # find / -name math.h /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/include/math.h /export/home/iav/mysql-3.23.32/mit-pthreads/include/math.h What I do incorrect? best regards, Igor - 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
can't build mysql under solaris 7
Trying to build mysql-3.23.32 under solaris 7 with gcc version 2.95.2 19991024 (release) got error message : gcc -DDEFAULT_CHARSET_HOME=\"/usr/local\" -DDATADIR=\"/usr/local/var\" -DSHAREDIR=\"/usr/local/share/mysql\" -DUNDEF_THREADS_HACK -I./../include -I../include -I ./.. -I.. -I.. -O6 -DDBUG_OFF -DHAVE_CURSES_H -I/export/home/iav/mysql-3.23.32/include -DHAVE_RWLOCK_T -c libmysql.c -fPIC -DPIC -o .libs/libmysql.lo In file included from ../include/global.h:151, from libmysql.c:23: /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/include/math.h:5: math.h: No such file or directory make[2]: *** [libmysql.lo] Error 1 what does it mean? What is than math.h, it cann't find? I ried to find it myself - and fail: # find / -name math.h /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/include/math.h /export/home/iav/mysql-3.23.32/mit-pthreads/include/math.h What I do incorrect? best regards, Igor - 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
