Re: Error when compiling mysql 3.23.53 on Solaris 9
Jeremy, May not be helpful to you - perhaps you are seeking some specific compiled-in function, but for what it's worth: The mysql-max-4.0.4-beta-sun-solaris2.8-sparc tarball also runs great on Solaris 9 SPARC. We are using it... Lou Essex Systems Hi all, I am compiling mysql 3.23.53 on Solaris 9 using gcc 3.2. Any clue to the following errors: mkdir .libs g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o gen_lex_hash gen_lex_hash.o ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread make[4]: Leaving directory `/pub/mysql-3.23.53/sql' ./gen_lex_hash lex_hash.h ld.so.1: ./gen_lex_hash: fatal: libstdc++.so.5: open failed: No such file or directory Killed make[3]: *** [lex_hash.h] Error 137 make[3]: Leaving directory `/pub/mysql-3.23.53/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/pub/mysql-3.23.53/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/pub/mysql-3.23.53' make: *** [all-recursive-am] Error 2 Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB RAW devices under Solaris?
All: I am re-posting this in case someone may have an answer. RE: MySQL 4.01-max, InnoDB, Solaris, Raw device support Has anyone had any specific experience implementing a RAW DEVICE InnoDB tablespace under Sparc Solaris? A specific few lines in my.cnf would be very helpful... As we are using a SparcStorage Array, our device pathnames look something like: Innodb_data_file_path=/dev/rdsk/c1t4d0s7:1Gnewraw (OR) Innodb_data_file_path=/dev/dsk/c1t4d0s7:1Gnewraw Either of these options gives us an operating system error number 2 ... -- I have also tried things like: innodb_data_home_dir = /dev/ innodb_data_file_path = rdsk/c1t4d0s7:1Gnewraw Also with no luck. Are there specific Solaris slices we should be using?? Can't find any docs on this. Please note: using 'standard filesystem' InnoDB filespaces, everyting works AOK under this installation... Any help is appreciated. Lou - 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
InnoDB RAW devices under Solaris?
RE: MySQL 4.01-max, InnoDB, Solaris, Raw device support Has anyone had any specific experience implementing an InnoDB tablespace under Sparc Solaris? A specific few lines in my.cnf would be very helpful... As we are using a SparcStorage Array, our device pathnames look something like: Innodb_data_file_path=/dev/rdsk/c1t4d0s7:1Gnewraw (OR) Innodb_data_file_path=/dev/dsk/c1t4d0s7:1Gnewraw Either of these options gives us an operating system error number 2 ... Are there specific Solaris slices we should be using?? Can't find any docs on this. Please note: using 'standard' InnoDB filespaces, everyting works AOK... Any help is appreciated. Lou - 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: Some PHP - mySQL help please ... new to both
A quick diagnostic? Try the page phpinfo.php in the phpMyAdmin directory - this will give you the 'whole picture' in terms of your php installation... Even easier? Any php page which contains the code: ? phpinfo(); Will give you this full info report. Very useful! Lou Picciano Thanx Lou, this really helps out. One question though and maybe this runs deeper then I think. When I start my machine, and run phpMyAdmin (VD in IIS5) it works fine. When I close the browser window after making changes to a user, and then try to re-open it, I PHP is no longer working. I am not sure what it is doing at this point. Seems like it left the connection open to the database and it tries to re-connect after re-opening a browser and shuts everything down. I just get a blank page. Other then that this works great. Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com Dan, Have you taken a look at phpMyAdmin? This very good tool not only administers your MySQL databases, but their php code is a good teaching tool, as well. Simply drop the whole thing into an apache-served directory, and you're off to the races! It's on Sourceforge, and anyone on this list can benefit from it. http://sourceforge.net Let me know how this works out! Lou - 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: Some PHP - mySQL help please ... new to both
Dan, Have you taken a look at phpMyAdmin? This very good tool not only administers your MySQL databases, but their php code is a good teaching tool, as well. Simply drop the whole thing into an apache-served directory, and you're off to the races! It's on Sourceforge, and anyone on this list can benefit from it. http://sourceforge.net Let me know how this works out! Lou -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: SPARC Linux threads and fast mutexes?
All: For compiling (MySQL v4.0.1), can anyone tell me the preferred threads package to use under SuSE linux? The included mit threads? Or Linux portable threads pthreads¹? This is under a SPARC architecture. On a new build of 4.0.1, we are getting bdb errors related to architecture does not support fast mutexes¹ Seems to me in the past the config command found¹ the threads library without any user interaction, no??? Lou
Re: MySql 4.01 and libmysqlclient.so.10 - TEMP FIX
Ronald, I ran into exactly the same problem you describe after compiling a new MySQL v4... I think I can offer you an unsophisticated workaround (read: HACK!), but I'd defer to others on the list who know much more about this than I do... Your problem is because your new compile (or binary install) is expecting the layout previously used by mySQL v3. Until you sort this out, the quick fix is to make a link to libmysqlclient.so from where php 'thinks' it is. On SuSE SPARC, these directories work; you should interpret/infer/accommodate as required for your architecture: Create these links: /usr/lib/libmysqlclient.so.10 - /usr/local/lib/mysql/libmysqlclient.so.11 /usr/lib/libmysqlclient.so.11 - /usr/local/lib/mysql/libmysqlclient.so.11 This should make BOTH MySQL and PHP happy, but does not fix the problem with Apache - you may run into - about mod_auth_mysql. If anyone can offer us more, please do! LP I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql 3.23.49) I get a Php-mysql.4.xx requires libmysqlclient.so.10. My attempt to install MySql 4.01 ends there. I did some reading and found that libmysqlclient.so.10 comes with MySql 3.23.xx. I surfed my directories to find that MySql 4.01 installs libmysqlclient.so.11 I installed theses packages using the RH RPM Manager. Am I missing something? - 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
Raw Devices in MySQL?
Have a feeling I know the answer already, but here goes! ... Does anyone know if (and how) MySQL supports raw devices? I¹ve been searching the docs; can find nothing... Thanks - Lou - 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
Segmentation Fault at run-all-tests¹ script..
Hey all, Just did a compile and install of v4.01 for multiprocessor Sparc. Server has started, runs OK, have fiddled with privileges successfully... Naturally, next step: I¹d like to test everything. But now, I get a Segmentation Fault immediately at run-all-tests¹ script in sql-bench. Any ideas? Lou - 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
Undefined reference to 'btr_search_check_guess' ??
Dear Listers: In configuring for a 4.0.1 compile, all goes well. The compiler, however, reports (apparently in the InnoBase section of the compile): ../innobase/btr/libbtr.a(btr0sea.o): In nunction 'btr_search_guess_on_hash': btr0sea.o(.text+0x1c58): undefined reference to 'btr_search_check_guess' collect2: ld returned 1 exit status make[3]: *** [mysqld] Error 1 make[3]: Leaving directory '/usr/local/src/mysql-4.0.1-alpha/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory '/usr/local/src/mysql-4.0.1-alpha/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory '/usr/local/src/mysql-4.0.1-alpha make: *** [all-recursive-am] Error 2 I am no expert in using gcc, so have no idea how to recover from these messages. Does anyone have a hint? Thanks - Lou - 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
OpenSSL using v4.0.0?
Hello all - Does anyone know any tricks for compiling v4.0.0 with-openssl? I¹ve tried several variations, including different paths (or no path) in the with-openssl=/what/path/here? argument. Whatever I enter, configure output usually indicates it¹s _not_ using OpenSSL. After the compile and install, the SELECT VARIABLES LIKE query says I don¹t have SSL! Please note that OpenSSL is working on this box; I get proper startup of apache with ssl using mod_ssl, etc. This is all starting because we hope to compile PHP with the auth¹ capabilities, and are trying to link it to MySQL v4. Any ideas? Lou