Re: Compilation error on Solaris.
hi steve, there was a thread concerning compilation of mysql on solaris three days ago. one of the postings had a link: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:116929:200208:ngkbacmgkmgkdbbfgjdo to an earlier posting where j warburton describes how he successfully compiled mysql (3.23.51) on solaris 8. HTH, michael Steve Fulton wrote: Hi all, I've been trying to compile .51 and .52 under Solaris 8, and I get errors under both versions. Here's the error under .52: [...] - 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: provider for .net
Hi Jay, see http://www.mysql.com/press/release_2002_10.html for an overview. HTH, Michael Jay Fields wrote: I'm building an asp.net app and I want to connect to mysql, but I dont what which DataAdapter to use, and I don't know what Provider to specify in my connection string. Anyone have any advice? - 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: Solaris 8 Library Problems.
hi stephen, the ncurses library is not part of the mysql distribution. it's available as a solaris binary package at www.sunfreeware.com. look for ncurses-5.2. HTH michael Stephen D. Myles wrote: Hi, I am new to MYSQl so any help is much apreciated! I have recently instaled mysql version 3.23.45 on Sun solaris 8 (sparc). The server installed fine but I am unable to connect to the server using the mysql command due to some missing libs. Both the server and client are running locally. # ./mysql -h tilda -u mysql ld.so.1: ./mysql: fatal: libncurses.so.5: open failed: No such file or directory Killed A truss of the above output shows mw whitch lib files. # truss ./mysql execve(mysql, 0xE72C, 0xE734) argc = 1 mmap(0x, 4096, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON, -1, 0) = 0xEF7B resolvepath(/usr/lib/ld.so.1, /usr/lib/ld.so.1, 1023) = 16 open(/var/ld/ld.config, O_RDONLY) Err#2 ENOENT open(/usr/local/mysql/lib/mysql/libncurses.so.5, O_RDONLY) Err#2 ENOENT open(/usr/local/lib/libncurses.so.5, O_RDONLY) Err#2 ENOENT open(/usr/lib/libncurses.so.5, O_RDONLY) Err#2 ENOENT ld.so.1: ./mysql: fatal: libncurses.so.5: open failed: No such file or directory write(2, l d . s o . 1 : . / m.., 81) = 81 getpid()= 1028 [1027] I can find no reference to this files in any of the documentation at all which leaves me a little confused. Any ideas? thanx smyles - 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: libncurses.so.5 problem
hi, the ncurses library is available as a solaris binary package at sunfreeware, too. look for ncurses-5.2. Christopher Thompson wrote: This is not a MySQL question, it's a Solaris question. :) But anyway, you need to get and install ncurses (version 5). You can find more information at: http://www.gnu.org/software/ncurses/ncurses.html On Wednesday 06 March 2002 8:57 am, Atif Faruqui wrote: Hello, I feel i am dead in the water with this problem, it appears that libncurses.so.5 is a linux library, i downloaded mysql-3.23.45 from sunfreeware and did pkgadd on it on Soalris 8 Sparc box, i was able to start mysqld daemon and i can run mysqladmin commands but when i try to connect i m getting : bash-2.03$ mysql ld.so.1: mysql: fatal: libncurses.so.5: open failed: No such file or directory Killed bash-2.03$ I have done a whole find for libncurses.so.5 on system and couldn't find it anywhere. I am really confused, please HELP. - 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: Why v3.23.49 does not build on RedHat 6.2 ?????
hi, the source rpm for mysql 3.23.49 contains build instructions for gnu compilers 2.95 or newer. redhat 6.2 comes with a compiler that cannot handle the permissive flag (i think its ecgs-2.91). therefore the build fails. one solution could be to install a more recent compiler version and try to recompile again. be aware that actual rpm's will be created by rpm version 4, whereas redhat 6.2 has rpm version 3 installed which possibly cannot handle version-4-rpm's (although there had been a rpm-3 version which could _read_ rpm-4 packages - i think it was 3.0.5.) besides that, there may be glibc issues. redhat 6.2 has glibc 2.1.3 installed. i don't know if actual gcc or mysql versions work ok if compiled against this 'old' glibc. afaik, redhat does _not_ recommend to update the glibc version installed... if you dont have very specific reasons to stick with redhat 6.2 in my opinion it could be simpler just to install a later redhat version... not sure if this really helps... bye michael Gabriele Carioli wrote: Hi everybody... I've searched thrugh the lists (IMHO the search engine is slow and the output sucks: what about a date column at the beginning of each row in the post list and in search results?) and the manual. This is the 3rd time I post about this problems but it looks like nobody can give me an answer ... I wonder if it is possible at all to build rpm MySQL 3.23.49 binaries for RedHat 6.2. Is it possible? I've not been able to build rpm for my platform on three different machines. I've tried to rpm --rebuild MySQL-3.23.49-1.src.rpm - 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: upgrading mysql-3.23.48 and rpm package.
hi, on redhat 6.2, you have a package manager (rpm) version which cannot interpret rpm's created with package manager version 4. afaik, rpm 3.0.6 is able to read both formats, so you should upgrade your package manager software to version 3.0.6 to be able to install the new mysql package. don't know if there any libc issues, though. bye michael Ireneusz Piasecki wrote: Hi all. I would upgrade my mysql serever from RPM: rpm -i MySQL-3.23.48-1.i386.rpm only packages with major numbers = 3 are supported by this version of RPM error: MySQL-3.23.48-1.i386.rpm cannot be installed What can i solve this problem. I use Red Hat 6.2 Where can i find the RPM engine to install mysql 3.23.48 ? With mysql 3.23.47 was no problem Pleas help. Regards I. Piasecki -- Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! [ http://oferty.onet.pl ] - 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: How do I verify it's a 64-bit build
you could use: file /path-to/mysqld the output will tell you if mysqld is a 32 or 64 bit ELF executable. Hatton Steven wrote: Sorry about the previous, seemingly stupid question asking for clarification on the LDFLAGS. I was not able to hit http://home.earthlink.net/~jaymzh666/mysql.html , so I did not realize that answer was there. I now seem to have a successfully built MySQL 3.23.47 using what I believe is a 64-bit capable gcc-3.0.3. How might I verify that I indeed have a 64-bit MySQL? TIA, 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 - 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: math_iso.h / libm.a
hi mark, math_iso.h is c header file located in /usr/include/iso, part of SUMWlibm package. this is output of pkgchk from solaris 8 machine (german locale): # pkgchk -l -p /usr/include/iso/math_iso.h Pfadname: /usr/include/iso/math_iso.h Typ: reguläre Datei Erwarteter Modus: 0644 Erwarteter Eigentümer: root Erwartete Gruppe: bin Erwartete Dateigröße (Byte): 2461 Erwartetes Ergebnis für sum(1) des Inhalts: 14161 Erwartete letzte Änderung: Aug 08 06:34:43 1999 Referenziert von den folgenden Packages: SUNWlibm Aktueller Status: installiert hope this helps, michael Faine, Mark wrote: Solaris 8 Gcc 3.0.3 I cannot get mysql to compile without math_iso.h yet I cannot find math_iso.h anywhere, does anyone know where this file is located, also, does anyone know which Solaris Package contains libm.a it's missing also. -Mark - 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: FOLLOW UP on column names not liked by odbc/php/access
hi, in your sql command there are several errors: it has the form INSERT INTO (list of fieldnames) VALUES (list of values); but: - there are more items in the list of values than in the list of fieldnames. these lists should match. - there's an extra comma after fieldname 'unico', and the closing ) is missing. - you dont need apostrophes for numeric fields. you get the table definition using sql command 'DESC tablename' (- and the tablename -was- missing :) hope this helps, michael database,sql,query,table mweb wrote: Hello, On the same database, this query works: $SQL_Exec_String = INSERT INTO Multimedia (Titolo,Descrizione,Logo,Link) VALUES ('prova titolo','prova descrizione','.gif','prova link');; $cur= odbc_exec( $cnx, $SQL_Exec_String ); This one gives this error: ISQL_exec_String = Insert Into (Artista, Opera, Label, Anno, Nazione, CDNow, Autore, AutoreNome, Genere, GenereCustom, SulWeb, Autorizzato, Unico, VALUES ('prova2', 'inedita', 'ignota', '2001','IT', 'nonesiste', 'io', 'lui','3', 'ulteriori dettagli sul genere musicale', 'http://www.no.it', '1', '20011205111456', 'asdas erfver', 'ciao ni', '2.5', 'Non andare a capo!'); Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in C:\domini\m.net\inserzione3.php on line 115 Error in odbc_exec( no cursor returned ) Does the second qyury look syntactically wrong to you? May it be that some column name or quoting is wrong, or some value I try insert is not matching the column type? If so, why would this be a *syntax* error? Is it possible to query access via Php so that it will tell the internal strucure of the table? (this database was developed and left online by somebody else, that's why I don't have all this info) Any help is greatly appreciated, as are working sql statements for similar (php+odbc+access) cases. - 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