installation problem with db-3.2.9a - makefile is not correct!
Hi, I'm progressing through the install of mysql-3.23.33 with the db-3.2.9a package extracted and built within the mysql source tree, but it looks like the creation of ./db-3.2.9a/build_unix/Makefile hasn't worked correctly... This is what I get when I run 'make install' from the top-level of the mysql source tree: 14 root@jedi # make install Making install in include /bin/sh ../mkinstalldirs /usr/local/include/mysql [ lots of stuff deleted ... ] .././install-sh -c .libs/mysqltest /usr/local/bin/mysqltest Making install in ./db-3.2.9a/build_unix install_include install_lib install_utilities install_docs sh: install_include: not found *** Error code 1 make: Fatal error: Command failed for target `install' Current working directory /var/azwan/mysql-3.23.33/db-3.2.9a/build_unix *** Error code 1 make: Fatal error: Command failed for target `install-recursive' Looking at ./db-3.2.9a/build_unix/Makefile reveals that the 'include_' parts have not had any substitutions performed when the configure script was run! For example, the 'install_include' part looks like this: install_include: @echo "Installing DB include files: $(includedir) ..." @test -d $(includedir) || \ ($(mkdir) -p $(includedir) $(chmod) $(dmode) $(includedir)) @cd $(includedir) $(rm) -f db.h db_185.h db_cxx.h @$(cp) -p db.h \ $(srcdir)/include/db_cxx.h $(includedir) @cd $(includedir) $(chmod) $(fmode) db.h db_cxx.h and from my (limited) understanding of Makefiles, that's supposed to have had all the parts preceded by a '@' sign substituted for a real command or pathname by the relevant configure script. Is that the correct interpretation? By way of more info, the 'install' macro in ./db-3.2.9a/build_unix/Makefile is currently: install: all# modified by MySQL configure install_include install_lib install_utilities install_docs That looks fine to me though it doesn't explain why 'make' is complaining that it apparently cannot find the 'install_include' part. Regards, Craig. -- Craig Ian Dewick ([EMAIL PROTECTED]). http://lios.apana.org.au/~craig Operator of Jedi (APANA Sydney member-access site) in Waterfall, Australia. Always striving for a secure long-term future in an insecure short-term world Have you exported a crypto system today? Do your bit to undermine the NSA. - 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 under FreeBSD4.2-STABLE
Hi! Sometimes I look a problem with mysqld which load CPU. It work fine one week, two ... But ones something was happend and mysqld catch all CPU time. I don't know why. Mysqld continue work, but CPU load increase :( It catch 99% CPU I look in process list, kill all id, flush all tables and try all that I found in mysqladmin help. But any results. If I restart mysqld, it work fine and will work fine some days or week. After that this story will repeat. mysql-3.23.32 FreeBSD-4.2-STABLE Any ideas. Best regards. ___ Andrey Kotrekhov [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
[ANN] MySQL Studio v0.7 Released.
** After months of development We are proud to announce the first public version of MySQL Studio. http://dba-tools.com/ MySQL Studio provides an extremely easy to use interface to MySQL servers. A straight-forward and easy-to-use interface. MySQL Studio combines a list-view/editor and a tree-view of the content in one window. It lets you easily navigate the database data and structure and modify database without much fuss. This simple and intuitive interface has much been copied but never reached the same usability level. MySQL Studio interface leaves out all text-based information about database structure and data. Instead of scuffling with SQL scripts and obscure commands, you can concentrate on more important things - design of your database. Everything you need is right there at your finger tips. With MySQL Studio you can easiliy create and administer MySQL database, including such tasks as updating table's structure and query optimization. Download a full-functional Demo version from: http://www.dba-tools.com/downloads.php?file=studiotrial.exe View screenshots at: http://www.dba-tools.com/products.php Best regards, MySQL Studio Development Team DBA Tools http://dba-tools.com/
Re: MySQL License
You can charge for any GPL'ed product you wish too. Ruben On 2001.03.05 22:31:41 -0500 Jeff Platzer wrote: Maybe someone can help me out with MySQL's commercial license. If MySQL server has a GPL license and MySQL client libraries have LGPL licenses, how can a paid commercial license be required for products that incorporate LGPL MySQL client libraries and depend on the GPL MySQL server? Does this not violate the GPL and LGPL license terms? MySQL commercial applications should be similar to Linux commercial applications that use the LGPL Linux shared libraries and depend on the GPL Linux OS. No Linux paid license can be required in this case. However, the developer can charge for the commercial application in this case. -- Brooklyn Linux Solutions http://www.mrbrklyn.com http://www.brooklynonline.com 1-718-382-5752 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Memory footprint
Hi On two separate but identical servers I am runing MySql, 3.22, on Debian (2.2.16) kernel. Using top, one mysqld server uses 10MB whilst the other uses just 3MB. Both servers have identical configuaration files, the only difference is that server 1 is much busier. Can anyone explain why one server is 7MB bigger than the other. Simon -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700744 Fax: +44 (0) 1249 700725 Email: mailto:[EMAIL PROTECTED] This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Thank you for your cooperation and assistance. - 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: Default values
On Mon, Mar 05, 2001 at 10:26:58PM -0600, MikemickaloBlezien wrote:
Hello All,
I've created a table(using MySQL 3.23.33), using default values:
DROP TABLE IF EXISTS referral;
CREATE TABLE referral (
refer_id int(10) UNSIGNED DEFAULT '100' NOT NULL,
refer_fname varchar(20) DEFAULT '' NOT NULL,
refer_lname varchar(20) DEFAULT '' NOT NULL,
refer_email varchar(40) DEFAULT '' NOT NULL,
UNIQUE INDEX idx_refid (refer_id)
) TYPE=MYISAM;
It creates the table, no problems. But for some reason, if the refer_id is left
blank during an INSERT, it defaults to "0" and not 100 ?? is this because of the
UNIQUE INDEX on this column?? If your wonder, the refer_id is assigned a random
5 digit number within the Perl program. I was just testing to see if it would
assign the default value if no value was assigned during an insert.
Exactly what does your INSERT look like?
A default value for refer_id should be inserted when you do:
INSERT INTO referral(refer_fname, refer_lname, refer_email)
VALUES ('xxx.yyy', 'xxx.yyy', '[EMAIL PROTECTED]');
or:
INSERT INTO referral
VALUES (NULL, 'xxx.yyy', 'xxx.yyy', '[EMAIL PROTECTED]');
But an INSERT like this:
INSERT INTO referral
VALUES ('', 'xxx.yyy', 'xxx.yyy', '[EMAIL PROTECTED]');
will probably use 0 for refer_id or give an error message. You do
supply a value in this case, so no default wil be used.
Regards,
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
-
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
Question regarding query optimising with between
Hello I have a table with a normal multiple key on a datetime field called "end". I want to search for the number of records in some months. I know that there are none. Now "explain" tells me that a querey with a WHERE clause of end between '2001-01-01' and '2001-04-01' affects just one row whereas end '2001-01-01' affects all 705949 rows! Why this? I cannot find the docs that explain this speed enhancement. I'd even thought that a "" would be faster as it is just one check and the parser could say "every row" starting from index position X. bye, -christian- Full explain results: mysql explain select count(*) from radius0800 where ende between "2001-01-01" and "2001-04-01"; ++---+---+--+-+--+--+--- --+ | table | type | possible_keys | key | key_len | ref | rows | Extra | ++---+---+--+-+--+--+--- --+ | radius0800 | range | ende | ende | 4 | NULL |1 | where used ; Using index | ++---+---+--+-+--+--+--- --+ 1 row in set (0.00 sec) mysql explain select count(*) from radius0800 where ende "2001-01-01"; ++---+---+--+-+--++- + | table | type | possible_keys | key | key_len | ref | rows | Extra | ++---+---+--+-+--++- + | radius0800 | range | ende | ende | 4 | NULL | 705949 | where us ed; Using index | ++---+---+--+-+--++- + 1 row in set (0.00 sec) -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner - Premium Certified - 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
Use of certain keywords in SQL statements problematic
Description: We have just upgraded from 3.22.26a to 3.23.33. One table has a column name "FullText". However, any SQL statements (either using PHP or the command line interface) that directly reference the column will cause an SQL error, like: --- Couldn't execute query: [UPDATE Resources SET Title = 'Cambridge Scientific Abstracts', Url = 'http://www.csa.com/htbin/dbrng.cgi?username=usfaccess=usf6cat=default', Vendor='62',Issn='',FullText='Some FullText',TOC='N',Coverage='', Access='Proxy', Notes = ' ', DB = 'Y', EJ = '', RT = '', IR = '', NW = '', EB = '', IM = '', DateAdded = '2000-10-30', Continues = 'Continues', ContinuedBy = '' WHERE (Id = '18765')] You have an error in your SQL syntax near 'FullText='Some FullText',TOC='N', Coverage='',Access='Proxy',Notes = ' ', DB = '' at line 1 --- (Original SQL query line was all one line, originating from a PHP page; it has been edited only for readability.) How-To-Repeat: I have not tested creating a table with such a column name. However, with an existing table, the line above, as well as an attempt to do a: SELECT FullText from Resources where Id='18765'; also bugs out. A similar "SELECT * from" worked fine. Fix: Beyond renaming the column, no idea as of yet. Submitter-Id: submitter ID Originator: Organization: Eric A. Stewart - Network Administrator - [EMAIL PROTECTED] University of South Florida, Tampa Campus Library - Systems Work: http://www.lib.usf.edu/ | MS/MIS | ICQ# Play: http://cerebus.lib.usf.edu/ | Graduate Student | 31285736 SSI MD#100762 MySQL support: none Synopsis: Some keywords appear no longer valid in SQL queries Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.33 (Source distribution) Environment: System: SunOS charlotte 5.8 Generic sun4u sparc SUNW,Ultra-250 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1731920 Jan 5 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Jul 10 2000 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1113260 Jan 5 2000 /lib/libc.so.1 -rw-r--r-- 1 root bin 1731920 Jan 5 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jul 10 2000 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1113260 Jan 5 2000 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql-3.23.33-sun-solaris2.8-sparc - 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: trying to install on RedHat 7.0 and need help
Charles L Hagen schrieb: mysqld dead but subsys locked it's successfully installed and running, but not really killed killall mysqld and start again you shouldn't post those long nonsense listings -- http://it97.dyn.dhs.org -- IrmundThum - 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
Searching for misses
I have a couple of SQL queries, both of which involve searching for misses rather than searching for hits. Would anybody be kind enough take a little time to assist me? Suppose I have a table of products, a table of components, and a table which says which components are used in which products. How do I search for obsolete components - i.e. all components which do NOT appear in any products? In another table, a subset of rows are to be given a quick reference tag, a maximum 4 digits, with which users can mark "important" entries. The tag must obviously be unique. When the user requests that a row be tagged with a given number, I wish to find the nearest unused tag to that which the user supplies. Is there any way of getting SQL to do this for me, or should I just do a SELECT tag WHERE tag NOT NULL ORDER BY tag, then search the results for a gap near my desired tag? Probably less than 1000 tags will actually be used, so 1000 16-bit values is not much to shuffle about and binary chop - but as a lazy man I believe in getting existing software to do the job if I can. Thanks in advance for any assistance. Alec - 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
troubles with joining list
I don't see an address for the list owner so I'm mailing this here in hope of getting help. Why is the connection constantly resetting and not allowing me to join the list? This mail also serves as a test to see if I can post to the list without joining via [EMAIL PROTECTED] Mar 6 04:34:49 Imani sendmail[90483]: f269Hm190455: to=[EMAIL PROTECTED], ctladdr=[EMAIL PROTECTED] (1000/69), delay=00:17:01, xdelay=00:05:00, mailer=esmtp, pri=120439, relay=lists.mysql.com. [192.58.197.162], dsn=4.0.0, stat=Deferred: Connection reset by lists.mysql.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default values
On Tue, 06 Mar 2001 09:18:34 -0600, "Gerald L. Clark" [EMAIL PROTECTED] wrote: Gerald, Try giving a number instead of a string as a default for an int. Not sure I follow, it is a number?? "MikeBlezien" wrote: Hello All, I've created a table(using MySQL 3.23.33), using default values: DROP TABLE IF EXISTS referral; CREATE TABLE referral ( refer_id int(10) UNSIGNED DEFAULT '100' NOT NULL, refer_fname varchar(20) DEFAULT '' NOT NULL, refer_lname varchar(20) DEFAULT '' NOT NULL, refer_email varchar(40) DEFAULT '' NOT NULL, UNIQUE INDEX idx_refid (refer_id) ) TYPE=MYISAM; It creates the table, no problems. But for some reason, if the refer_id is left blank during an INSERT, it defaults to "0" and not 100 ?? is this because of the UNIQUE INDEX on this column?? If your wonder, the refer_id is assigned a random 5 digit number within the Perl program. I was just testing to see if it would assign the default value if no value was assigned during an insert. Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - 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: Match Records
Hello ,
Can you please tell me how to use transaction in mysql. I am using mysql
version 3.23.32.
I want to use EJB over it , it is giving problem of transaction as it is not
supporting ENTITY with CMP.
Thanks ,
Neelesh
- Original Message -
From: "Bob Hall" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 06, 2001 10:25 AM
Subject: Re: Match Records
I`m trying to find the best method to match records between two tables in
a
MySQL database. But it must match atleast once, so here is a scenario for
you
to think about.
Member - Job, Salary, Location
Jobs - Job, Salary, Location
All values will be enum sets in both tables as follows
Job = enum 'developer','designer','none'
Salary = enum '10K','15K','none'
Location = enum 'usa','uk','none'
Ok so the user has come to the site and I have his Job Salary and
Location
stored, he clicks a link which then performs the search. His values are
as
follows..
Job = developer, Salary = 10K, Location = uk
I want to search the Jobs table and match it with the above, this part I
can
do. The next stage is if it doesn`t find any matches it then finds the
nearest. So if the only record I have in the Jobs table is as follows
Job = developer, Salary = none, Location = uk
How do I go about making it pick up the nearest.
At the moment I am using
SELECT * FROM Jobs where Job='$Job' and Salary='$Salary' and
Location='$Location'
So obviously it won`t match them, anyone wake me up from my slumber and
help
me out with this?
Cheers
Ade
Sir, the following, or some variation, should get you the closest
matches on salary. You can modify or remove the LIMIT clause to get
various numbers of results.
SELECT *, Abs('$Salery' - Salery) AS delta
FROM Jobs
WHERE Job='$Job' AND Location='$Location'
ORDER BY delta LIMIT 1;
For location, you'll have to have some sort of lookup system based
either on longitude and latitude or the British postal codes. The
easiest solution is to let the user handle it; the user does one
search for each location the user thinks is close enough to the ideal
location.
The problem of finding a job title that is close to another job title
is a problem outside of database theory. The US government uses a
numeric coding system for jobs. If the UK government does something
similar, you might be able to use that to make rough comparisons of
job titles. Even if you can find an existing solution that you can
adapt to your needs, you've still got your work cut out for you. An
easier solution might be to allow the user to view the available job
titles (SELECT DISTINCT Job ..., or have a predetermined list of
jobs) and then have your code build a query based on the jobs
selected by the user.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
-
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
3.22.25 and RAND()
SELECT * from tablename ORDER BY RAND() does not work in 3.22.25 what is the equivalent ?? It works great in later versions chris _ Do You Yahoo!? Get your free @yahoo.com address at 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
RE: BDB tables on Linux
You must compile from source to get BDB support into mysql. Make sure you download the appropriate BDB source and place it in the mysql directory. - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [EMAIL PROTECTED] - -Original Message- From: Stephen Faustino [mailto:[EMAIL PROTECTED]] Sent: Monday, March 05, 2001 4:11 PM To: '[EMAIL PROTECTED]' Subject: RE: BDB tables on Linux show variables showed that have_bdb is no, and none of the bdb variables are there. So does this mean that BDB is NOT compiled into the binary included in the Linux RPM, or does it mean that I need to add the necesary BDB-related variables to /etc/my.cnf? Stephen L. Faustino Senior Software Engineer SecureLogix Corporation Direct/Vmail (210)402-9669x949 mailto:[EMAIL PROTECTED] This email is intended for the named recipient(s) only and may contain information that is privileged and/or confidential. Nothing in this email is intended to constitute a waiver of any privilege or the confidentiality of this message. If you have received this email in error, please notify me immediately by reply and delete this message. -Original Message- From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, March 05, 2001 3:51 PM To: Stephen Faustino Cc: '[EMAIL PROTECTED]' Subject: Re: BDB tables on Linux On Mon, Mar 05, 2001 at 03:44:20PM -0600, Stephen Faustino wrote: Yes, I specified that the table should use the BDB table handler, but it does not appear that the table was created as a BDB table. Are you *sure* you're running a version with BDB support compiled in? The output of SHOW VARIBLES will probably tell you. Having not used them, though, it's hard to say... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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
load_file
Hi I have been trying to use load_file to store a file as a BLOB object in a database table but it always returns NULL although I have made sure that the path is correct and I have the appropriate priviliges. Any hints how to use load_file correctly ? Hesham Farouk Anan Computer Science Department Old Dominion University Norfolk, VA 23529
Off Topic Perl Mysql modules install problem
Hello, I'm now lost. I cannot figure out what the make file is looking for. Anyone have any ideas? LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i386-redhat-linux/2.9 6" cc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql-L/usr/lib/mysql -lmysqlclient -lm -lz -L/usr/lib/g cc-lib/i386-redhat-linux/2.96 -lgcc /usr/bin/ld: cannot find -lz collect2: ld returned 1 exit status make[1]: *** [../blib/arch/auto/DBD/mysql/mysql.so] Error 1 make[1]: Leaving directory `/home/curtis/Msql-Mysql-modules-1.2215/mysql' make: *** [subdirs] Error 2
Re: configure can't find LinuxThreads
That is an ancient version of Linux. [EMAIL PROTECTED] wrote: Description: When running ./configure it can't find LinuxThreads. Environment: Linux 2.0.35 downloaded and expanded LinuxThreads-2.1.3.tar.gz. It seems the tarball do not include pthread.h which "configure" looks for. How-To-Repeat: LinuxThreads-2.1.3.tar.gz does not include "pthread.h" Fix: include minimal include files necessary to compile mySQL?? Submitter-Id: Ethy Brito Originator: Organization: Phonet S/C Ltda. MySQL support: none Synopsis: trouble configuring mySQL on ancient Linux Severity: critical Priority: medium Category: mysql Class: doc-bug Release: mysql-3.23.32 (Source distribution) Environment: System: Linux jupiter 2.0.35 #1 Thu Dec 3 10:21:40 EDT 1998 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-pc-linux-gnulibc1/egcs-2.90.29/specs gcc version egcs-2.90.29 980515 (egcs-1.0.3 release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jul 30 1998 /lib/libc.so.4 - libc.so.4.7.6 -rwxr-xr-x 1 root root 634880 Jun 4 1996 /lib/libc.so.4.7.6 lrwxrwxrwx 1 root root 14 Jul 30 1998 /lib/libc.so.5 - libc.so.5.4.44 -rwxr-xr-x 1 root root 580816 Mar 23 1998 /lib/libc.so.5.4.44 -rw-r--r-- 1 root root 1120212 Feb 2 1998 /usr/lib/libc.a lrwxrwxrwx 1 root root 19 Jul 30 1998 /usr/lib/libc.so - /lib/libc.so.5.4.44 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --without-berkeley-db Perl: This is perl, version 5.004_04 built for i586-linux - 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: Perl/mysql.
N Sikkandar Dulkarnai wrote: Hello there, I just installed "mysql Ver 11.12 Distrib 3.23.33, for sun-solaris2.6 (sparc)". How do I insert rows into mysql database.tablevia PERL ?. It would be appreciated if some one can send some basic structure of connecting into sql using perl and some useful links. Thanks in advance. Regards, Sikkandar. Download some Perl based client programs and study them. - 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
One shot bug report
The Makefile generated by v3.23.33 for BDB 3.2.9a has a line which is incorrect. ./configure --with-raid In db-3.2.9a/build_unix/Makefile --snip install: all install_include install_lib install_utility install_docs --end snip (it tries to execute install_include as a command since it's on a new line) Changing it to "install: all install_include install_lib install_utility install_docs" corrected the problem. -Mike [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
