3.23.42 version released?
Hi all. When is supposed the 3.23.42 mysql version released? Iago. __ mensaje enviado desde http://www.iespana.es emails (pop)-paginas web (espacio illimitado)-agenda-favoris (bookmarks)-foros - 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
Programs linked static give error when run: /tmp/mysql.sock missing
Here is what we have found while working on the 0.2.1 version of Escapade: Because Escapade is not open source, and is in the following sense similar to prepackaged Perl and PHP systems, Escapade is distributed as a static binary (because of library incompatibility issues among various Linux systems) on Linux which was linked with the current MySQL client library *at compile time*. This produces a rather interesting scenario when run on a system which specifies different compile-time options than as distributed. The problem arises when MySQL is configured and built with mysql.sock configured to be in a non-standard place (we usually find it in /var/lib/mysql/mysql.sock) on another machine, and the Escapade binary is run. The DBOPEN statement will fail with the complaint that /tmp/mysql.sock doesn't exist. Checking /tmp verified that, indeed, there is no mysql.sock file in that directory. What's going on? It turns out that, because MySQL needs to know where to put mysql.sock at runtime, and because all the MySQL client programs need to know where this is when they run, too, the socket file value as configured at compile time is compiled into the runtime client library. When mysql_connect() or mysql_real_connect() is called, it knows where to go to connect to mysql.sock, because it was specified at compile time. So what? Since the runtime library knows where mysql.sock is, all the client programs should run just fine, right? Well, sure - if your client isn't linked statically! If it is, whatever value that was compiled into the runtime library will be linked into the static binary - which may be wrong on the target system where the static binary is installed. The problem can be solved and therefore becomes a non-issue when /etc/my.cnf (or ~/my.cnf, etc.) exists and contains the socket file specification, because adding a call to mysql_options() will pick up the information in my.cnf. The only problem with this is that /etc/my.cnf isn't mandatory, nor is it apparently installed when MySQL itself is installed. If /etc/my.cnf (or path variations) don't exist, there is no way for the static client to figure out where the socket file is, and therefore the mysql_connect or mysql_real_connect call fails, while a dynamically linked program will succeed. The obvious solution is to force, in the client library, for my.cnf to exist, correctly configured, in a published place. Any other ideas on how to solve this problem? I've already mentioned why relinking as a dynamic binary isn't feasible. Thanks in advance :) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - 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: XML Support
Gary Huntress ([EMAIL PROTECTED]) writes: In the past few days 3 different people have asked me about xml support in mysql. I was unsure what to tell them actually, beyond saying you can easily export recordsets to xml documents.Obviously you can store entire XML documents in a TEXT field, but I'm not sure thats really the functionality that they want. I don't understand this. Do they want to wrap their data in XML to produce output? That's relatively trivial and shouldn't be done in the server, but any MySQL-aware language (PHP, Perl, Escapade, etc.) would be able to produce XML output easily from data. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - 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: Grants question..
Everything works great, except that I can't access a database created by root as another user. When I grant privileges, from the command line or phpmyadmin, things seem to work fine (no error message), but access is still denied. I did restart MySQL after granting rights. You can also check the following. Open the mysql database (the 'real' mysql db, the one that's part of the distribution). Issue a 'select * from user' command and check if the 'another user' is really there with the correct settings for the privileges. Issue also a 'select * from db'. Peter van der Kamp - 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: instalation Problem
muttaqin ([EMAIL PROTECTED]) writes: Description: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Fix: how to correct or work around the problem, if known (multiple lines) ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock is the easy fix :) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - 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: Programs linked static give error when run: /tmp/mysql.sock missing
Ed Carp ([EMAIL PROTECTED]) writes: The obvious solution is to force, in the client library, for my.cnf to exist, correctly configured, in a published place. Any other ideas on how to solve this problem? I've already mentioned why relinking as a dynamic binary isn't feasible. This won't fix existing systems and installations, obviously. Our workaround is to hard code places to look for mysql.sock: char *where_socket[] = { /tmp/mysql.sock, /var/lib/mysql/mysql.sock, /usr/local/lib/mysql/mysql.sock, NULL }; [...] mysql_init (mysql); mysql_options (mysql, MYSQL_READ_DEFAULT_GROUP, mysqld); if (!mysql_real_connect (mysql, host, name, pass, db, 0, NULL, 0)) { ptr = where_socket; while (*ptr != (char *) NULL) { if (mysql_real_connect (mysql, host, name, pass, db, 0, *ptr, 0)) break; if (mysql_errno (mysql) != CR_CONNECTION_ERROR) printf (!-- ERROR %d connecting to database: %s --\n, mysql_errno (mysql), mysql_error (mysql)); ptr++; } if (*ptr == (char *) NULL) { fprintf (stderr, ERROR %d connecting to database: %s\n, mysql_errno (mysql), mysql_error (mysql)); return (EOF); } } This is a hack because there are only so many places to look for mysql.sock and one can't hard-code them all, so this is only a short-term solution, and certainly one I wouldn't want to release in the engine! -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - 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
Linux semi static binary of MySQLGUI 1.7.5
I used the binary with Red Hat 6.2.All the functions except table related functions (specially table create functions) are working Do let me know what i should do to make the table create function work regards venkatesh e mail [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: The Mysql socket thing using Redhat 7.1
jason bailey ([EMAIL PROTECTED]) writes: I'm consistently getting the error (2002) : Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (111) You mean /var/lib/mysql/mysql.sock? Details are IMPORANT. I've deleted it and running something above has brought it back again!- this is good I think Bad idea. 1. Can i found out if the server is or is not running -which command and what am I looking for? mysqladmin status 2. Can I stop the mysql server mysqladmin shutdown 3. Can I start it? safe_mysqld Where is mysql.sock? In /tmp? If so: ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock Should get you going. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - 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 and Crypto
Matthew S. Hamrick ([EMAIL PROTECTED]) writes: Interfacing MySQL with standard crypto libraries: BSAFE, BDANGEROUS, CRYPTIX, CRYPTLIB, CRYPTO++, or even PAM? Why? What's the purpose? Export laws being what they are, it's probably not a good idea, anyway... Using any crypto library or hardware to encrypt data in a database. All of this stuff is easy. I've done a fair amount of compression/encryption of databased data, but it's almost too trivial and straightforward to pass along. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - 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
I am facing problems in creating tables
HI This is srikanth, and i am persuing my final semester of Masters in Computers Applications in India, I have been recently to you site on advice of one of my friend, and i have downloaded your setup file from the net and installed the database and the odbc setup file both in my c:\mysql directory. The problem what i am facing is i have created a database by name welcome and in that yesterday i have created 6 tables and after my work i have shut down my pc and today when i opened the pc and checked the databse exists but no tables are there in the database. I have not even used the option of temporary table creation. I have just created my table by using the following command create table welcomelist( uname varchar(30),reg_date datetime,lname varchar(50),product varchar(10),node varchar(5)) and the table got created and now when i open my database i didnt find any table there. Kindly help me through this problem, as for my final semester project i have already commited that i will use mysql as backend to complete the project. Expecting your reply very soon Regards Srikanth - This mail sent through : http://mail.sify.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
About Replicatation Features
Dear. I have questions About Replicatation Features. There is next sentence as follows (In Manual '11.4 Replication Features and known problems') MySQL only supports one master and many slaves. We will in 4.x add a voting algorithm to automatically change master if something goes wrong with the current master. We will also introduce 'agent' processes to help doing load balancing by sending select queries to different slaves. 1. about when do you introduce? will is it 4.0, will not ? 2. I expect that there is patch or proxy is advance developed in somewhere. Expecting any informations if anyone know. Regards. - 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
Column name in Big 5
Even my mysql is compile with Big5, I couldn't use Chinese charaters (big 5) as column name. Is that normal? == Best Regards Jason Kwok == --- Virus Free Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.274 / Virus Database: 144 - Release Date: 2001/8/23 - 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: XML Support
Gary Huntress wrote: In the past few days 3 different people have asked me about xml support in mysql. I was unsure what to tell them actually, beyond saying you can easily export recordsets to xml documents.Obviously you can store entire XML documents in a TEXT field, but I'm not sure thats really the functionality that they want. Ah! - buzywords, when you filter them out you are left with a markup, data descritption and somewhere to keep it - and in many cases that will be a RDBMS, although most people use one by default. Actually the observation made was that MySQL and PostgreSQL might be falling behind the commercial databases in terms of native XML support. Oracle, MSSQL, and Sybase (probably DB2 as well since IBM is pretty big in the XML arena) already have some type of support. Not falling behind, just less buzyword compliant. To me XML and a DOM tree are not the same as relational data. If your data is not relational why use a RDBMS ? I think XPath support in Selects might be a good place to start. So basically, is anything in the works for XML? No idea, but this was discussed on the list a few months ago - check the archives as I think a few MySQL chipped in. Sorry if this sounds a little negative and sarcastic, but I've delt with a few projects where it got over complicated because of the use of XML/XSLT, and managers whom want to use a product because its got nive brochures and buzwords . Greg Cope Regards, Gary SuperID Huntress === - 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: Column name in Big 5
Jason Kwok writes: Even my mysql is compile with Big5, I couldn't use Chinese charaters (big 5) as column name. Is that normal? Did you quote the names? And did they contain any of the illegal characters discused in http://www.mysql.com/doc/L/e/Legal_names.html ? I wonder why ÿ is not allowed in names. The only special thing about that character is that it has a special meaning in telnet, but that can hardly be relevant, can it? //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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
bug report / source compile error
Hi, I have Windows NT 4.0 (build 1381/SP6a) running IIS4 Webserver ( http://www.abadon.net or 212.30.85.173 ) connected via CableModem/LAN to Internet. I have also PHP ( Version 4.0.6 )scripting engine and MySQL server ( Client API version 3.23.32 said PHP info page, but in WinMySQL admin Ver 1.3 is : Server : 3.23.41-nt Client: 3.23.36 - but It doesen`t matter - MySQL working perfect without any problems or bugs ( info page is: http://212.30.85.173/phpinfo.php with UN info and PW guest, `cause my server is not public, only developing ...). But my problem is: I have downloaded SourceCode for MySQL ( mysql-3.23.41-win-src.zip ), unzip and open workspace with Visual C++ ( part of MS VisualStudio 6 Pro with SP 4 ) and rebuild all - without problem, excepcion one with describe: Configuration: strings - Win32 Debug Performing Custom Build Step on .\Strxmov.asm The name specified is not recognized as an internal or external command, operable program or batch file. Error executing e:\winnt\system32\cmd.exe. mysqld.exe - 1 error(s), 0 warning(s) I haven`t idea what`s that: bug or is something wrong with my machine or IDE ( my knowledge is not so perfect... )... regards ps - I haven`t any problems with other sources codes, like Macromedia SWF flash source, etc sorry to my bad english language... Slevec Brane, Slovenia mailto:[EMAIL PROTECTED] Here is complete log: Deleting intermediate files and output files for project 'heap - Win32 Debug'. Deleting intermediate files and output files for project 'isam - Win32 Debug'. Deleting intermediate files and output files for project 'merge - Win32 Debug'. Deleting intermediate files and output files for project 'mysys - Win32 Debug'. Deleting intermediate files and output files for project 'regex - Win32 Debug'. Deleting intermediate files and output files for project 'strings - Win32 Debug'. Deleting intermediate files and output files for project 'dbug - Win32 Debug'. Deleting intermediate files and output files for project 'zlib - Win32 Debug'. Deleting intermediate files and output files for project 'mysqlclient - Win32 Debug'. Deleting intermediate files and output files for project 'mysql - Win32 Debug'. Deleting intermediate files and output files for project 'mysqladmin - Win32 Debug'. Deleting intermediate files and output files for project 'mysqldump - Win32 Debug'. Deleting intermediate files and output files for project 'mysqlimport - Win32 Debug'. Deleting intermediate files and output files for project 'MySqlManager - Win32 Debug'. Deleting intermediate files and output files for project 'mysqlshow - Win32 Debug'. Deleting intermediate files and output files for project 'libmySQL - Win32 Debug'. Deleting intermediate files and output files for project 'myTest - Win32 Debug'. Deleting intermediate files and output files for project 'thr_test - Win32 Debug'. Deleting intermediate files and output files for project 'replace - Win32 Debug'. Deleting intermediate files and output files for project 'myisam - Win32 Debug'. Deleting intermediate files and output files for project 'myisammrg - Win32 Debug'. Deleting intermediate files and output files for project 'innobase - Win32 Debug'. Deleting intermediate files and output files for project 'bdb - Win32 Debug'. Deleting intermediate files and output files for project 'mysqld - Win32 Debug'. Configuration: heap - Win32 Debug Compiling... _check.c _rectest.c hp_block.c hp_clear.c hp_close.c hp_create.c hp_delete.c hp_extra.c hp_hash.c hp_info.c hp_open.c hp_panic.c hp_rename.c hp_rfirst.c hp_rkey.c hp_rlast.c hp_rnext.c hp_rprev.c hp_rrnd.c hp_rsame.c Generating Code... Compiling... hp_scan.c hp_static.c hp_update.c hp_write.c Generating Code... Creating library... Configuration: isam - Win32 Debug Compiling... _cache.c _dbug.c _dynrec.c _key.c _locking.c _packrec.c _page.c _search.c _statrec.c changed.c close.c create.c delete.c extra.c info.c log.c open.c panic.c range.c rfirst.c Generating Code... Compiling... rkey.c rlast.c rnext.c rprev.c rrnd.c rsame.c rsamepos.c static.c update.c write.c Generating Code... Creating library... Configuration: merge - Win32 Debug Compiling... _locking.c close.c create.c delete.c extra.c info.c open.c panic.c rrnd.c rsame.c static.c update.c Generating Code... Creating library... Configuration: mysys - Win32 Debug Compiling... array.c Compiling... charset.c checksum.c default.c errors.c getopt.c getopt1.c getvar.c hash.c list.c mf_brkhant.c mf_cache.c mf_casecnv.c mf_dirname.c mf_fn_ext.c mf_format.c mf_getdate.c mf_iocache.c mf_iocache2.c mf_keycache.c mf_loadpath.c Generating Code... Compiling... mf_pack.c mf_pack2.c mf_path.c mf_qsort.c mf_qsort2.c mf_radix.c mf_same.c mf_sort.c mf_soundex.c mf_stripp.c mf_tempfile.c mf_wcomp.c mf_wfile.c mulalloc.c my_alarm.c
Re: The Mysql socket thing using Redhat 7.1
Ed, Thanks for the email. I was a bit tired last night and was a little frustrated (4 nights getting nowhere), so apologies if I was little rude (I've just reread my email) and sarcastic, but thanks for the 'Details' pun. I've dug myself into a hole offering to set up a Linux/Apache Webserver for a friend. There's no rush but wanted to use it as a learning experience and am getting problems with mysql- everything else seems ok. jason bailey ([EMAIL PROTECTED]) writes: I'm consistently getting the error (2002) : Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (111) You mean /var/lib/mysql/mysql.sock? Details are IMPORANT. Yes, thanks for the pun. It was the above /var/lib/mysql/mysql.sock and I noted that deleting it and then running mysql_install_db or possible safe_mysqld recreated. I've deleted it and running something above has brought it back again!- this is good I think Bad idea. Slightly sarcastic- sorry 1. Can i found out if the server is or is not running -which command and what am I looking for? mysqladmin status As I remember and I'm not sure I was going round in circles- this was a call giving the error- I've just read somewhere to check that this is installed, so will do that tonight 2. Can I stop the mysql server mysqladmin shutdown Again an error on that one 3. Can I start it? safe_mysqld Yep it does produces a lot of information and then ends (I think- you see I'm not sure) Where is mysql.sock? In /tmp? If so: ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock mysql.sock is in the directory that the error produces i.e. /var/lib/mysql/mysql.sock ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock Should get you going. This, in my ignorance, looks like a soft link to the mysql.sock in the /var/lib/mysql/mysql.sock location. The file(?) does exist and I'm not sure why a softlink will help unless it's something to do with permissions. Thanks for your suggestions I'll give them a try. Regards Jason Dr Jason Bailey Desktop Applications Consultant Computing Service The University of Sussex - 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 get TABLENAME.FIELDNAME syntax in the return values from MySQL
In a SQL like : SELECT table1.f1,table2.f1 FROM table1,table2 you get a listing like this. +++ | f1 | f1 | +++ | 1 | 1 | | 1 | 2 | | 1 | 3 | +++ When using the DBI function fetchrow_hashref() you get only one value since the key is not unique. Is there a way to get MySQL to return with the syntax TABLENAME.FIELDNAME, and not just FIELDNAME ? I know that you can use aliases to get a similar effect but it's a hassle to write sql's like this : SELECT table1.f1 as 'table1.f1',table2.f1 as 'table2.f1' FROM table1,table2 Regards Terje K WebOn AS Norway - 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: bug report / source compile error
At 10:33 05/09/2001 +0200, abadon wrote: Hi, Hi, I have Windows NT 4.0 (build 1381/SP6a) running IIS4 Webserver ( http://www.abadon.net or 212.30.85.173 ) connected via CableModem/LAN to Internet. I have also PHP ( Version 4.0.6 )scripting engine and MySQL server ( Client API version 3.23.32 said PHP info page, but in WinMySQL admin Ver 1.3 is : Server : 3.23.41-nt Client: 3.23.36 - This means that the server is 3.23.41 release and the WinMySQLAdmin that is the client was compiled with the 3.23.36 library. I will update the libraries for the next release. but It doesen`t matter - MySQL working perfect without any problems or bugs ( info page is: http://212.30.85.173/phpinfo.php with UN info and PW guest, `cause my server is not public, only developing ...). But my problem is: I have downloaded SourceCode for MySQL ( mysql-3.23.41-win-src.zip ), unzip and open workspace with Visual C++ ( part of MS VisualStudio 6 Pro with SP 4 ) and rebuild all - without problem, excepcion one with describe: Configuration: strings - Win32 Debug Performing Custom Build Step on .\Strxmov.asm The name specified is not recognized as an internal or external command, operable program or batch file. Error executing e:\winnt\system32\cmd.exe. This means that you don't have the MS Macro Assembler Compiler in your environment to perform the custom build of strxmov.asm file. In your strings project file you have instructions for the MASM 5.0 and if you don't have it, your options are: - Change the strings.dsp and strings dsw files by the files you find in \strings\NOMASM directory. In this case you won't compile the strings stuff with the assembler. - Get the Masm 6.x from Microsoft and change the custom command. You find instructions about at: http://msdn.microsoft.com/vstudio/sp/vs6sp5/faq.asp - If you have the MASM 6.x: - Right click over the strings project and click Set as Active Project. - Right click again and click Settings. - Open the strings tree. - Click over the Strings.asm file and at right side click the tab Custom Build. In the windows Commands, change the line: masm -Mx -t -DDOS386 -DM_I386 $(InputPath),$(Outdir)\$(InputName).obj,,, by the line below: ml /Cx /nologo /DDOS386 /DM_I386 /Zm /coff /c /Fo $(Outdir)\$(InputName).obj $(InputPath) - Do the same with the file Strxmov.asm. - Change the assembler command for the Win32 debug and release trees. Regards, Miguel mysqld.exe - 1 error(s), 0 warning(s) I haven`t idea what`s that: bug or is something wrong with my machine or IDE ( my knowledge is not so perfect... )... regards ps - I haven`t any problems with other sources codes, like Macromedia SWF flash source, etc sorry to my bad english language... Slevec Brane, Slovenia mailto:[EMAIL PROTECTED] Here is complete log: Deleting intermediate files and output files for project 'heap - Win32 Debug'. Deleting intermediate files and output files for project 'isam - Win32 Debug'. Deleting intermediate files and output files for project 'merge - Win32 Debug'. Deleting intermediate files and output files for project 'mysys - Win32 Debug'. Deleting intermediate files and output files for project 'regex - Win32 Debug'. Deleting intermediate files and output files for project 'strings - Win32 Debug'. Deleting intermediate files and output files for project 'dbug - Win32 Debug'. Deleting intermediate files and output files for project 'zlib - Win32 Debug'. Deleting intermediate files and output files for project 'mysqlclient - Win32 Debug'. Deleting intermediate files and output files for project 'mysql - Win32 Debug'. Deleting intermediate files and output files for project 'mysqladmin - Win32 Debug'. Deleting intermediate files and output files for project 'mysqldump - Win32 Debug'. Deleting intermediate files and output files for project 'mysqlimport - Win32 Debug'. Deleting intermediate files and output files for project 'MySqlManager - Win32 Debug'. Deleting intermediate files and output files for project 'mysqlshow - Win32 Debug'. Deleting intermediate files and output files for project 'libmySQL - Win32 Debug'. Deleting intermediate files and output files for project 'myTest - Win32 Debug'. Deleting intermediate files and output files for project 'thr_test - Win32 Debug'. Deleting intermediate files and output files for project 'replace - Win32 Debug'. Deleting intermediate files and output files for project 'myisam - Win32 Debug'. Deleting intermediate files and output files for project 'myisammrg - Win32 Debug'. Deleting intermediate files and output files for project 'innobase - Win32 Debug'. Deleting intermediate files and output files for project 'bdb - Win32 Debug'. Deleting intermediate files and output files for project 'mysqld - Win32 Debug'. Configuration: heap - Win32 Debug Compiling... _check.c _rectest.c
RE: What does this error mean??!!
)-Original Message- )From: Deryck Henson [mailto:[EMAIL PROTECTED]] )Sent: Tuesday, September 04, 2001 10:10 PM )To: [EMAIL PROTECTED] )Cc: MySQL )Subject: Re: What does this error mean??!! ) ) )Would you be so kind as to do that step by step? I'm very new to this and )don't know half this stuff (although I am starting to learn books, etc.). )Please. Not tryin to get you mad or anything but I dont have a clue on how )to go about doing that. Hummmaaa ok, here is the link, which guides you step by step in depth than me. http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#Privilege_system Regards, venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu mailto:[EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ___/ www.mysql.com ) )- Deryck H )- http://www.comp-u-exchange.com )- Original Message - )From: Venu [EMAIL PROTECTED] )To: Deryck Henson [EMAIL PROTECTED]; Joshua J. Kugler )[EMAIL PROTECTED] )Cc: MySQL [EMAIL PROTECTED] )Sent: Wednesday, September 05, 2001 12:00 AM )Subject: RE: What does this error mean??!! ) ) ) ) )-Original Message- ) )From: Deryck Henson [mailto:[EMAIL PROTECTED]] ) )Sent: Tuesday, September 04, 2001 9:55 PM ) )To: Joshua J. Kugler ) )Cc: MySQL ) )Subject: Re: What does this error mean??!! ) ) ) ) ) )I know that!!! But how do I fix it? On the DSN, I put uid and ) )pwd to blank ) )because I did the same in the ODBC UserDSN setup window. ) ) Execute GRANT ALL ON *.* TO some@something.com IDENTIFIED BY ) mypassword at the root level, and then try to connect it. This )gives all ) types of access to user some from something.com. ) ) Regards, Venu ) -- ) For technical support contracts, go to https://order.mysql.com/ )__ ___ ___ __ ) / |/ /_ __/ __/ __ \/ /Mr. Venu mailto:[EMAIL PROTECTED] ) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer ) /_/ /_/\_, /___/\___\_\___/ Woodside, California USA )___/ www.mysql.com ) ) ) ) )- Deryck H ) )- http://www.comp-u-exchange.com ) )- Original Message - ) )From: Joshua J. Kugler [EMAIL PROTECTED] ) )To: Deryck Henson [EMAIL PROTECTED]; Deryck Henson ) )[EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] ) )Sent: Tuesday, September 04, 2001 7:02 PM ) )Subject: Re: What does this error mean??!! ) ) ) ) ) ) It means that access for the user connecting from the domain ) )something.com ) ) has been denied. You don't have permissions set up properly. ) ) ) ) j- k- ) ) ) ) On Tuesday 04 September 2001 15:59, Deryck Henson wrote: ) ) [TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]' )to database ) ) 'dbasename' ) ) ) ) I get this every time I try to connect with mysql. ) ) ) ) -- ) ) Joshua Kugler, Information Services Director ) ) Associated Students of the University of Alaska Fairbanks ) ) [EMAIL PROTECTED], 907-474-7601 ) ) ) ) - ) ) 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 ) ) ) - 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 doesn't allow to alias locked tables
Description: Mysql doesn't allow to alias locked tables. See how to repeat for details. This problem make impossible to use more complex select queries on locked tables. How-To-Repeat: -- let's suppose there's a MyISAM table testtable lock tables testtable write; select t.* from testtable t; -- mysql says ERROR 1100: Table 't' was not locked with LOCK TABLES Fix: Submitter-Id: submitter ID Originator:Pavel Kolesnikov Organization: Templation MySQL support: none Synopsis: Mysql doesn't allow to alias locked tables Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.36 (Source distribution) Environment: System: Linux emental 2.4.2-2 #1 Sun Apr 8 19:37:14 EDT 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 srp 28 13:55 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 5578134 dub 6 21:30 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 dub 6 21:27 /usr/lib/libc.a -rw-r--r--1 root root 178 dub 6 21:27 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --with-berkeley-db - 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 connect to source
Hi, Ive just started playing about with MySQL. I created a database called haworth, no problem there, then created a table called list. I put 3 entries in it, and checked it using SELECT * FROM list; It showed all the records fine. The MySQL server is running on NT, and I can connect remotely by using the following statement. Mysql h x u root p X being the IP address of my server. This works fine on any computer I tried it on. I then installed MyODBC on a Win2000 computer. All went well, then I setup the link to the database. But when I tried to access it, I got the following message. UNABLE TO CONNECT TO SOURCE MYTEST S1000 [TCX][MyODBC] Access Denied for user: @MAILSERVER To database roland 0414 I then reset the link to the test database, and tried again, this worked fine. Do I need to setup something else on the server so I can access the database? Some help would be appreciated, as Im about to throw the computer out of the window!!! Thanks Roland Manchester, England - 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: About 123box.co.uk
[EMAIL PROTECTED] writes: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: As I get more and more pissed off with every mail I get from 123box.co.uk I mailed the list owner the other day asking for something to be done about it. As my mail hasn't bounced I'm assuming that [EMAIL PROTECTED] is the correct address, but as I haven't received a response I'm turning directly to the list instead. The mailer daemon at 123box.co.uk is apparently broken, and it's causing inconvenience to anyone who's posting to this list. I have not been able to read the owner of 123box.co.uk, and the owner of the 123box.co.uk email address seems not to be active on this list (correct me if I'm wrong). Therefore I think it would be in the interest of this list to have any subscribed address at 123box.co.uk unsubscribed. If the list owner is not reading this, could someone please forward this to him/her/it? //Círdan / Carl / whatever -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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
search with wildcards
Hi folks! I need to search a mysql database using wildcards. I know about the * and the _ wildcards (any number of any character and 1 character of any kind, respectively) but I need to match any number, any letter and thing like that. An SQL book claimed it could be done using brackets and ranges like [1-9], but I can't get that to work. Does anyone have any ideas how I can solve my little problem? Regards Sam _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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: 3.23.42 version released?
Iago Sineiro writes: Hi all. When is supposed the 3.23.42 mysql version released? Iago. Very soon. -- 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
RE: search with wildcards
I need to search a mysql database using wildcards. I know about the * and the _ wildcards (any number of any character and 1 character of any kind, respectively) but I need to match any number, any letter and thing like that. An SQL book claimed it could be done using brackets and ranges like [1-9], but I can't get that to work. Does anyone have any ideas how I can solve my little problem? Regular expressions: http://www.mysql.com/doc/S/t/String_comparison_functions.html http://www.mysql.com/doc/P/a/Pattern_matching.html - 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 Installing mysql...
Carlos Augusto Perez Lima writes: Hi, I'm trying to install the mysql for Compaq Tru64 Unix 4.0f. I did the download of file mysql-3.23.41.tar # ./configure. # make ... ... + rm -f ./typelib.c + /sbin/ln -s ../libmysql/typelib.c ./typelib.c + rm -f ./violite.c + /sbin/ln -s ../libmysql/violite.c ./violite.c echo timestamp linked_libmysql_r_sources make all-recursive No suffix list. Making all in include No suffix list. Make: % rule can only use a single ':'. Stop. *** Exit 1 Stop. *** Exit 1 Stop. # What can i do ??? Can anyboy help me ??? Thank advanced. ** Carlos Augusto Perez Lima System Administrator Bioinformatic Milenia Biotecnologia Genética. Phone: (55) 43-371-9302 Street: Pedro Antonio de Souza, 405. Fax: (55) 43-371-9011. 86031-610 - Londrina, Pr - Brazil.mailto:[EMAIL PROTECTED] http://www.milenia.com.br http://www.bioinformatic.cjb.net ** Please use GNU make. -- 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
Linux semi static binary of MySQLGUI 1.7.5
I used MySQLGUI 1.7.5 binary with Red Hat 6.2. and MySql 3.22 All the functions except table related functions (specially table create functions) are working Do let me know what i should do to make the table create function work regards venkatesh e mail - [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: MyODBC, DBUG and multi-threaded clients
Peter Duffy writes: Hi Sinisa, My problems are within the mysqlclient and MyODBC libraries, both used directly by the application (and therefore all on the client side of the socket.) Both the mysqlclient and MyODBC libraries do (or in my case did) contain calls to the DBUG functions. Obviously, given the fact that the libraries are being called directly by the application, the amount of multi-threading done by the application is most emphatically relevant. First of all DBUG_* are not functions but macros and very simple macros for that fact. And if there was a bug in any of those macros, it would have surfaced in our server or in any of our multi-threaded client, like mysqlmanager. I have no interest in any other clients except possibly to investigate whether or not they produced anything like the same behaviour that I am observing with my own application. My only key objective is to fix my application, which, to repeat again, is coredumping during calls to DBUG functions within the mysqlclient and MyODBC libraries. Regards, Peter Exactly what I mean. There are several multithreaded clients out there all using libmysqlclient and some MyODBC and none of them experience the problems you describe. -- 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
Cannot compile on BSDI
BSD/OS 4.0.1, MySQL source 3.23.41, gcc 2.7.2.1, gmake 3.75, latest m4, autoconf, aclocal and automake: ../configure --prefix=/home/[u]/[user]/mysql --disable-shared \ --with-unix-socket-path=/home/[u]/[user]/mysql/run/mysqld.sock \ --with-tcp-port=[port] --with-mysqld-user=[user] \ --with-low-memory --enable-assembler --with-charset=latin1 \ --with-extra-charset=all crashes on compile with: gmake[2]: Leaving directory `/usr/local/WWW/[domain]/mysql-3.23.41/libmysql' Making all in client gmake[2]: Entering directory `/usr/local/WWW/[domain]/mysql-3.23.41/client' g++ -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I..-I..-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c mysql.cc cc1plus: Invalid option `-fno-exceptions' In file included from mysql.cc:28: .../include/global.h:646: warning: abstract declarator used as declaration gmake[2]: *** [mysql.o] Error 1 gmake[2]: Leaving directory `/usr/local/WWW/[domain]/mysql-3.23.41/client' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/usr/local/WWW/[domain]/mysql-3.23.41' gmake: *** [all-recursive-am] Error 2 Here and there the documentation suggests CXXFLAGS=-03, CXXFLAGS=-0 and CXXFLAGS=-O3 -felide-constructors (the latter in INSTALL-SOURCE specifically for my version of gcc. Nothing works, compiling crashes the same way every time. Since the crash happens in the client directory, I tried even configuring --without-client in pure desperation. It didn't help; the compiler went into the client directory even then and crashed just the same way. Does anyone know how to fix this? BTW, I cannot install a newer gcc; my space quota is in the way. Anyway, according to the docs 2.7.2.1 should work. Z - 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: LOAD DATA into multiple tables?
Brad Stockdale writes: Hello all, I'm new to the list... Been using MySQL for various things for a year now, but have never ran into the following situation... I have a flat text file that I have exported from FileMaker Pro. I want to import that into MySQL, but there's a catch... There are two tables I am trying to load, and some of the columns need to go into each... Is there a way to do this with a single LOAD DATA INFILE statement? The reason I want to do it all at once and not in multiple files is because I have auto_increment columns in each for a primary key. I want to make sure the two tables key columns dont get out of sync with each other. Is there a way to load multiple tables with a single LOAD DATA statement? Thanks, Brad No, but there is a workaround. Create a temporary table that would get all of the data. Then do INSERT from SELECT for each of the two tables and then drop a temporary table. -- 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
Re: Re: Cannot compile on BSDI
Since the crash happens in the client directory, I tried even configuring --without-client in pure desperation. It didn't help; the compiler went into the client directory even then and crashed just the same way. Does anyone know how to fix this? After you run the configure, edit the client/Makefile, and remove the -fno-exceptions. Tuc/TTSG Internet Services, Inc. database,sql,query,table database,sql,query,table database,sql,query,table database,sql,query,table database,sql,query,table - 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
connect VB to mysql over net
I want to build a VB application that connects to mysql (over the internet) running on linux. i have mysql currently running on LAMP system fine, but do i just need to install MyODBC for linux on the mysql server or what? also, are there any major security issues to this i should know about? any help is appreciated..thanks in advance. -d - 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
ISP Usage
IS their and ISP tracking list for MySQL adopters? -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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: Mysqld/FreeBSD 4.3 stuck in kernel
Ken Menzel writes: Hello Sir, cut Your return of Poll 1 seems to indicated that there is a descriptor ready to be serviced (hence the going in continuosly) but that the daemon does not seem to be able to complete the servicing of that descriptor. I am not sure why your daemon skips 'clock_gettime'. Maybe a mysql programmer could help with this. I have heard of this happening on some systems randomly, it does not happen to me. cut will be easy to find. Ken gettimeofday is called when mysqld is shutdown, or in inserting rows with timestamp and in replication. -- 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
Re: DSN-Less connection Strange error!
[EMAIL PROTECTED] writes: Hi People, I'm trying to connect to Mysql server using Access2k, VBA and DSN less connection, and mysql v3.23.36. All queries sent to the server exceute or returns records just fine except one simple query. cut show datbases ... is OK describe database is Ok Describe table ... -- E_Fail error. Please note if I use DSN, then everything works fine. Did Anybody tried this at home? Regards, Randy, - \__ \|/ Hello\ (@ @) -oo0( ^ )0oo--- Nader Shehayed \=/ Senior Application engineer /*\ IAR Systems Inc. Email : [EMAIL PROTECTED] --- Our ODBC driver still requires DSN. There is a new version in the works that will work without it. -- 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
Re: On Redhat 7.1
Neil Zanella writes: On Tue, 4 Sep 2001, Sinisa Milivojevic wrote: Red Hat 7.1 has a very nice apache + mysql + php installation and invoking mysql function calls from the php interface works very well. The only aspect that puzzles me a little bit is that when I look at the output of phpinfo(); I see a --without-mysql flag as a configure switch. How is this possible? Thanks, Neil I truly do not know. -- 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
Re: On Redhat 7.1
On Wed, 5 Sep 2001, Sinisa Milivojevic wrote: Red Hat 7.1 has a very nice apache + mysql + php installation and invoking mysql function calls from the php interface works very well. The only aspect that puzzles me a little bit is that when I look at the output of phpinfo(); I see a --without-mysql flag as a configure switch. How is this possible? PHP is configured with --without-mysql flag to not be compiled in main PHP. And after that is compiled only mysql module of PHP. You can see php-4...rpm and php-mysql-4...rpm. Is more easy to see if you will look in spec file. -- Cristian Paslaru http://devel.iasi.ro - 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 crashing
Hi Russell, have you applied patches M410-008, M410-012 and most important M410-014? Even after applying the patches there are major thread problems (althought MySQL should 'run' ). My advice to you is to update to 4.2 which seems to fix the threads problems, and apply current patches as there are some security patches (for both 4.1 and 4.2). Best of luck, Ken - Original Message - From: Russell A. Bell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 8:39 PM Subject: mysql crashing MySQL crashes almost every time we try to use it through a PHP script. We use 4.1 BSDI BSD/OS 4.1 Kernel #0 - 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
C-API
Hi guys, I've a question using the c-api. I sent a query to the server with mysql_query( pConnHandleArr[iDbHnd], pcQuery ) and stores the result on the client locally with pResSetArr[iDbHnd] = mysql_store_result( pConnHandleArr[iDbHnd] ); What happens if I do not free the result pointermysql_free_result(pResSetArr[iDbHnd]);? Is it possible to sent more querys and store the result without freeing it? Best regards --- Thorsten Guddack SIEMENS AG ICM MD MP SCM SCCM PI Information and Communication Mobile - Mobile Devices - Mobile Phones *+49-2842-95-4270 Fax +49-2842-95-4256 Südstraße 9 * [EMAIL PROTECTED] D-47475 Kamp-Lintfort --- - 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: Linux semi static binary of MySQLGUI 1.7.5
[EMAIL PROTECTED] writes: I used MySQLGUI 1.7.5 binary with Red Hat 6.2. and MySql 3.22 All the functions except table related functions (specially table create functions) are working Do let me know what i should do to make the table create function work regards venkatesh e mail - [EMAIL PROTECTED] Table edit is in the works and table create is on TODO. -- 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
Re: Cannot compile on BSDI
De-install gcc 2.7.2.1 and install 2.95.2 or gcc 3. -- 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
Re: Can't connect to local MySQL server through socket '/tmp/mysql.so ck'(2)
Is that the correct location for mysql.sock? If yes, is it world readable and writeable? If no, is the socket location defined in /etc/my.cnf? If it is, this file must be world readable. ½ÉÃ溸 wrote: I installed linux and mysql 3.23.40. Root installed and started mysql and user (charley) wants to connect mysql. When charley enters mysql, Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2) message appears. Of course root can connect to mysql server with above command. That is there was no problem. What's wrong with charley? - 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
Re: Can't connect to source
Read the manual, especially the section on the GRANT command. Roland Thompson wrote: Hi, I've just started playing about with MySQL. I created a database called 'haworth', no problem there, then created a table called 'list'. I put 3 entries in it, and checked it using SELECT * FROM list; It showed all the records fine. The MySQL server is running on NT, and I can connect remotely by using the following statement. Mysql -h x -u root -p X being the IP address of my server. This works fine on any computer I tried it on. I then installed MyODBC on a Win2000 computer. All went well, then I setup the link to the database. But when I tried to access it, I got the following message. UNABLE TO CONNECT TO SOURCE MYTEST - S1000 -[TCX][MyODBC] Access Denied for user: '@MAILSERVER' To database 'roland' - 0414 I then reset the link to the test database, and tried again, this worked fine. Do I need to setup something else on the server so I can access the database? Some help would be appreciated, as I'm about to throw the computer out of the window!!! Thanks Roland Manchester, England - 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
Re: The Mysql socket thing using Redhat 7.1
Jason Bailey ([EMAIL PROTECTED]) writes: You mean /var/lib/mysql/mysql.sock? Details are IMPORANT. Yes, thanks for the pun. It was the above /var/lib/mysql/mysql.sock and I noted that deleting it and then running mysql_install_db or possible safe_mysqld recreated. Well, it wasn't a pun :) Details are critically important, especially when you work with complex systems like these. I was commenting on the lack of detail in your post - you ran something and something happened, but you weren't quite sure what. It's much more difficult when people have to guess what you did. I'm not trying to flame you at all - but you will probably be able to get a lot more, and a lot higher quality, help if you can supply as much detail as possible. I've deleted it and running something above has brought it back again!- this is good I think Bad idea. Slightly sarcastic- sorry No, this really *is* a bad idea! The mysql.sock file is created by the server - if you delete it, you will not be able to connect locally. ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock Should get you going. This, in my ignorance, looks like a soft link to the mysql.sock in the /var/lib/mysql/mysql.sock location. The file(?) does exist and I'm not sure why a softlink will help unless it's something to do with permissions. If the server is creating mysql.sock in /var/lib/mysql and something else is looking for it in /tmp, this is the easiest way to get it to work, besides checking to make sure that the permissions are such that anyone who needs to can read and write to mysql.sock. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - 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 to get
Terje Kristensen ([EMAIL PROTECTED]) writes: In a SQL like : SELECT table1.f1,table2.f1 FROM table1,table2 you get a listing like this. +++ | f1 | f1 | +++ | 1 | 1 | | 1 | 2 | | 1 | 3 | +++ When using the DBI function fetchrow_hashref() you get only one value since the key is not unique. Is there a way to get MySQL to return with the syntax TABLENAME.FIELDNAME, and not just FIELDNAME ? I know that you can use aliases to get a similar effect but it's a hassle to write sql's like this : SELECT table1.f1 as 'table1.f1',table2.f1 as 'table2.f1' FROM table1,table2 Nope, you do it like select table.f1 as t1f1,table2.f1 as t2f1 from table1,table2 I tried to get it to return with tablename.fieldname, but I couldn't - I can't understand why you would want to, anyway. As I recall, it also breaks the SQL-92 standard. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - 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: replication problem
The slave does not have a server-id. Duc Chau wrote: Hi, this is my first time posting to the list. I've followed mysql replications how-tos to a tee...and I am still not able to get it to work. the master mysql is running on a sun sparc station (SunOS 2.8) with mysql 3.23.41 the file /etc/my.cnf is as follows: # The following options will be passed to all MySQL clients [client] port= 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16K set-variable= max_allowed_packet=1M set-variable= thread_stack=64K set-variable= table_cache=4 set-variable= sort_buffer=64K set-variable= net_buffer_length=2K server-id = 1 log-bin [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [myisamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [mysqlhotcopy] interactive-timeout The slave is running on a compaq prescario running red hat linux 7.1 with MySQL (Ver 10.12 Distrib 3.23.25-beta, for pc-linux-gnu (i686)) the file /etc/my.cnf is as follows: # The following options will be passed to all MySQL clients [client] port= 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] master-host=$host goes here master-user=$user goes here master-password=$password goes here master-port=3306 port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16K set-variable= max_allowed_packet=1M set-variable= thread_stack=64K set-variable= table_cache=4 set-variable= sort_buffer=64K set-variable= net_buffer_length=2K log-bin [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [myisamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [mysqlhotcopy] interactive-timeout Can someone tell me what i'm doing wrong? After reading thru all these how to's it seems so easy to get. Would the problem be cuz i'm going from solaris to linux? If that was the case though wouldnt i get errors importing the snapshots? The snapshot of the master data directory imported just fine. Another problem I noticed is if i put server-id = $any number here in the slave my.cnf i get this error /usr/sbin/mysqld: unrecognized option `--server-id=1'. Any help or direction on where i can find an answer would be great i've read through about 5 how to's. this is in my error log on the slave machine: 010904 14:05:12 mysqld started /usr/sbin/mysqld: ready for connections 010904 14:05:12 Slave thread: error connecting to master:Can't connect to MySQL server on 'sc-admin.admonitor.net' (111), retry in 60 sec Number of processes running now: 0 010904 14:05:27 mysqld restarted /usr/sbin/mysqld: ready for connections 010904 14:05:27 Error reading packet from server: Could not find first log (0) 010904 14:06:27 Error reading packet from server: Could not find first log (0) [root@dev mysql]# more dev.l90.com.err 010904 14:05:12 mysqld started /usr/sbin/mysqld: ready for connections 010904 14:05:12 Slave thread: error connecting to master:Can't connect to MySQL server on 'sc-admin.admonitor.net' (111), retry in 60 sec Number of processes running now: 0 010904 14:05:27 mysqld restarted /usr/sbin/mysqld: ready for connections 010904 14:05:27 Error reading packet from server: Could not find first log (0) 010904 14:06:27 Error reading packet from server: Could not find first log (0) 010904 14:07:27 Error reading packet from server: Could not find first log (0) 010904 14:08:27 Error reading packet from server: Could not find first log (0) 010904 14:09:28 Error reading packet from server: Could not find first log (0) 010904 14:10:28 Error reading packet from server: Could not find first log (0) - 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
Re: Mysqld/FreeBSD 4.3 stuck in kernel
Hi John, I've noticed rare occasions (about 1% of the time) when poll() returns 0 -- these are always preceeded in the trace output by a signal handler, like this: 45689 mysqld 0.08 CALL sigreturn(0x826ae7c) 45689 mysqld 0.10 RET sigreturn JUSTRETURN 45689 mysqld 0.24 CALL poll(0x827,0x91,0) 45689 mysqld 0.41 RET poll 0 45689 mysqld 0.23 CALL poll(0x827,0x92,0x1ff) 45689 mysqld 0.40 RET poll 1 I wonder which network card/driver you are using? (output from dmesg) Is poll 1 what you get when the server is idle? (Really, I'm not sure what to make of ktrace: which thread makes a particular call? Why are the timestamps interleaved?...) The timestamps are relative to the previous call (-R) if you want to see absolute timestamps use -T with kdump. I was also wondering how much RAM you had, I hope it is about 2 gig I have 768 MB here, for 50 databases with about 10 tables each, getting 6 queries per second. My current mysqld has been running since yesterday and now has a resident size of about 100MB. I did restart the The reason I asked about the memory is you are allocation 1 meg for sort_buffer and 1 meg for record buffers and allow 600 connections plus key buffer of 256Meg and Isam sort of 64Meg, this adds up to (600* 1meg (minimum))+256+64= 920Meg of potential memory usage maybe more if requests often use ORDER BY or need to sort the result. Of course this depends mainly on the number of connections happening. server yesterday to get it back to normal, and I can't reproduce the problem, but I can leave it running and expect the problem to reappear within about 10 days. When it comes back, I will take a good look at memory and the processlist. My recollection is that the condition will persist without there being any currently running query at all... Great I look forward to receiving this. Also try to recompile without the -O3, optimization sometimes causes problems because it can optimize away needed instructions. I don't think this is the case, but it would make my compile environment and yours equivalent and I don't have the problem. My guess might be something in the particular netword card. I use mostly Intel etherexpress and 3com 3905 cards. I may be away next week, however, I might cancel as I hurt my foot and am having trouble walking, so I might just sit in this chair! :( Ken - JD --- John David Duncan Systems Administrator Great Schools, Inc. - 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: DSN-Less connection Strange error!
)-Original Message- )From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] )Sent: Wednesday, September 05, 2001 5:35 AM )To: [EMAIL PROTECTED] )Cc: [EMAIL PROTECTED] )Subject: Re: DSN-Less connection Strange error! ) ) )[EMAIL PROTECTED] writes: ) Hi People, ) ) I'm trying to connect to Mysql server using Access2k, VBA and DSN less ) connection, and mysql v3.23.36. ) ) All queries sent to the server exceute or returns records just )fine except ) one simple query. ) ) )cut ) ) show datbases ... is OK ) describe database is Ok ) Describe table ... -- E_Fail error. ) ) Please note if I use DSN, then everything works fine. ) ) Did Anybody tried this at home? ) ) Regards, ) ) Randy, ) ) ) ) ) ) - ) \__ \|/ )Hello\ (@ @) ) -oo0( ^ )0oo--- ) Nader Shehayed \=/ ) Senior Application engineer /*\ ) IAR Systems Inc. ) Email : [EMAIL PROTECTED] ) --- ) ) )Our ODBC driver still requires DSN. ) )There is a new version in the works that will work without it. ) Also, when you are using DSN-less connection, you need to supply the OPTION flag in the connection string itself. When you said it is working fine with DSN connection, that means you have set some options in the connection dialog, might be Don't optimize column width. So when you are using other way, provide OPTION=1 (Check which one you need to supply) with the connection string, and everything will work fine. Also, there waa a bug in the driver, even when application is using DSN-less connection, driver always displays the connection dialog and waits for the DSN to be entered (atleast you need to insert space). I fixed this couple of days back, and the fix will be available for .39 version. Regards, Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu mailto:[EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California 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
insert a file wav ito a table
I have to insert a file wav into a blob field of a table. Is that possible?And how can I do it? Thanks in advance. __ Do You Yahoo!? Il tuo indirizzo gratis e per sempre @yahoo.it su http://mail.yahoo.it - 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
Date functions returning Strings
Hi, I'm using MM JDBC driver version 2.0.4 to access a MySQL database 3.23.40 on Solaris 2.8. When I do the following query SELECT NOW(), I always get String data and not Date data when fetching the data. Is it normal that Date functions returns a String? Is this a MySQL bug? Thanks for your help! Ghislain - 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: I am facing problems in creating tables
Hi Srikanth )-Original Message- )From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] )Sent: Wednesday, September 05, 2001 12:56 AM )To: [EMAIL PROTECTED] )Subject: I am facing problems in creating tables ) ) )HI ) )This is srikanth, and i am persuing my final semester of Masters )in Computers Applications in India, ) )I have been recently to you site on advice of one of my friend, )and i have downloaded your setup file from the net and installed )the database and the odbc setup file both in my c:\mysql directory. ) )The problem what i am facing is i have created a database by name )welcome and in that yesterday i have created 6 tables and after my )work i have shut down my pc and today when i opened the pc and )checked the databse exists but no tables are there in the )database. I have not even used the option of temporary table creation. ) )I have just created my table by using the following command ) )create table welcomelist( uname varchar(30),reg_date )datetime,lname varchar(50),product varchar(10),node varchar(5)) ) )and the table got created and now when i open my database i didnt )find any table there. ) )Kindly help me through this problem, as for my final semester )project i have already commited that i will use mysql as backend )to complete the project. ) )Expecting your reply very soon ) Nothing to woory, once you are in the hands of MySQL, MySQL will take to the exams...! Coming to your problem, how are you verifying whether tables are there in the db or not ? Did you connected through mysql command line utility or MySQLAdmin or any third party tools ? Regards, venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu mailto:[EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California 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
RE: Date functions returning Strings
Hi !!! )-Original Message- )From: Ghislain Gadbois [mailto:[EMAIL PROTECTED]] )Sent: Wednesday, September 05, 2001 7:37 AM )To: MySQL List (E-mail) )Subject: Date functions returning Strings ) ) )Hi, ) )I'm using MM JDBC driver version 2.0.4 to access a MySQL database )3.23.40 on Solaris 2.8. ) )When I do the following query SELECT NOW(), I always get String data )and not Date data when fetching the data. ) )Is it normal that Date functions returns a String? Is this a )MySQL bug? ) Someone pointed this already. There is nothing to do with the server, its all up to the driver how it is storing and returning the results to the application. Here mmmysql driver is returning timestamp stuff as string object instead of date object. Becuase of this there might be chances of getting the exceptions even if are assigned it to the date object. Any way, I will pass this to the JDBC development team. Regards, venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu mailto:[EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California 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
JDBC Connection help
Hi everyone, I just installed MySQL on my linux box. But when I tried to connect to my own box with jdbc (jdbc:mysql://localhost/red), it gave me SQLException: server configuration denies access to data source. I have already added root in the mysql.user and mysql.db, why is this happening?? What additional configuration change do I need to do?? Please help Tony _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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: Cannot compile on BSDI
On Wed, Sep 05, 2001 at 04:44:01PM +0300, Sinisa Milivojevic wrote: De-install gcc 2.7.2.1 and install 2.95.2 or gcc 3. Stay with gcc 2.95.X until 3 is fixed! -- 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 -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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: The Mysql socket thing using Redhat 7.1
Ed, Once again, thanks for the email response. I'm going to try all the suggestions I've received. A colleague has suggested as I'm new to Linux to select the 'Install Everything' option in red hat 7.1. He suggests that it's probably easier (for me) to get everything installed and work backward (uninstall the unnecessary) as I learn more. If the server is creating mysql.sock in and something else is looking for it in /tmp, this is the easiest way to get it to work, besides checking to make sure that the permissions are such that anyone who needs to can read and write to mysql.sock. -- I think this may be my problem in that I couldn't understand whether mysql.sock should be located in /var/lib/mysql but is required to be in /tmp. It certainly appears in /var/lib/mysql I'll try your suggestion for this and check permissions. Well, it wasn't a pun :) Details are critically important, especially when you work with complex systems like these. I was commenting on the lack of detail in your post - My mistake about the Pun. I do agree details are important; I will use mysqlbug next time, if I get no joy. I'd found several, if not more, postings from several people with the same type of question, regarding the error I was getting. I'd assumed that this common problem was well understood and didn't require explicit detail from myself. you ran something and something happened, but you weren't quite sure what. It's much more difficult when people have to guess what you did. I'm not trying to flame you at all - but you will probably be able to get a lot more, and a lot higher quality, help if you can supply as much detail as possible. I would'nt blame you for flaming my first email was a little rude. The detail I will try for next time. I've deleted it and running something above has brought it back again!- this is good I think Bad idea. Slightly sarcastic- sorry No, this really *is* a bad idea! The mysql.sock file is created by the server - if you delete it, you will not be able to connect locally. I'd been sarcastic and was apologising. I realised it was a bad idea but was getting frustrated and wanted to see if it would be recreated as a test if I was running the server at all. On deleting it I was finding that it was being recreated when running something. Something- I wasn't sure about at the time either mysql_install_db or safe_mysqld - still not sure but will check tonight when I get home. Dr Jason Bailey Desktop Applications Consultant Computing Service The University of Sussex - 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: JDBC Connection help
This may not be the best workaround, but I changed the 'localhost' to my actual server url, and then it worked. Someone else mentioned this as a means of fixing privileges: http://sourceforge.net/forum/forum.php?thread_id=123272forum_id=50480 cheers, Brett -Original Message- From: Silver Fox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 11:07 AM To: [EMAIL PROTECTED] Subject: JDBC Connection help Hi everyone, I just installed MySQL on my linux box. But when I tried to connect to my own box with jdbc (jdbc:mysql://localhost/red), it gave me SQLException: server configuration denies access to data source. I have already added root in the mysql.user and mysql.db, why is this happening?? What additional configuration change do I need to do?? Please help Tony _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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
cc/gcc during configure on solaris 2.8
During my attempt to configure the 3.23.41 source, I encountered the error: configure: error: no acceptable cc found in $PATH. As I'm using gcc on this box, where/how do I identify gcc for configure to use properly? Thanks, Brian - 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: insert a file wav ito a table
=?iso-8859-1?q?Cinzia=20Rubattino?= ([EMAIL PROTECTED]) writes: I have to insert a file wav into a blob field of a table. Is that possible?And how can I do it? Bad, bad, BAD IDEA! Read: http://www.bitbybit.dk/mysqlfaq/faq.html#storing_images -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - 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
Installation problem
I am new to MySQL. I've installed the package under SuSe Linux 7.1 (kernel 2.4). When I try to start the database using commands from the manual I get the following message. Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. I'm pretty much lost at this point as I have very little experience with database programs. Thansk for your help. Cliff Martin - 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: replication problem
If i put a server-id in the slave my.cnf file and start up the database with safe-mysqld, it starts and dies with this error in the log file. unrecognized option `--server-id=2' -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 7:25 AM To: Duc Chau Cc: [EMAIL PROTECTED] Subject: Re: replication problem The slave does not have a server-id. Duc Chau wrote: Hi, this is my first time posting to the list. I've followed mysql replications how-tos to a tee...and I am still not able to get it to work. the master mysql is running on a sun sparc station (SunOS 2.8) with mysql 3.23.41 the file /etc/my.cnf is as follows: # The following options will be passed to all MySQL clients [client] port= 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16K set-variable= max_allowed_packet=1M set-variable= thread_stack=64K set-variable= table_cache=4 set-variable= sort_buffer=64K set-variable= net_buffer_length=2K server-id = 1 log-bin [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [myisamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [mysqlhotcopy] interactive-timeout The slave is running on a compaq prescario running red hat linux 7.1 with MySQL (Ver 10.12 Distrib 3.23.25-beta, for pc-linux-gnu (i686)) the file /etc/my.cnf is as follows: # The following options will be passed to all MySQL clients [client] port= 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] master-host=$host goes here master-user=$user goes here master-password=$password goes here master-port=3306 port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16K set-variable= max_allowed_packet=1M set-variable= thread_stack=64K set-variable= table_cache=4 set-variable= sort_buffer=64K set-variable= net_buffer_length=2K log-bin [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [myisamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [mysqlhotcopy] interactive-timeout Can someone tell me what i'm doing wrong? After reading thru all these how to's it seems so easy to get. Would the problem be cuz i'm going from solaris to linux? If that was the case though wouldnt i get errors importing the snapshots? The snapshot of the master data directory imported just fine. Another problem I noticed is if i put server-id = $any number here in the slave my.cnf i get this error /usr/sbin/mysqld: unrecognized option `--server-id=1'. Any help or direction on where i can find an answer would be great i've read through about 5 how to's. this is in my error log on the slave machine: 010904 14:05:12 mysqld started /usr/sbin/mysqld: ready for connections 010904 14:05:12 Slave thread: error connecting to master:Can't connect to MySQL server on 'sc-admin.admonitor.net' (111), retry in 60 sec Number of processes running now: 0 010904 14:05:27 mysqld restarted /usr/sbin/mysqld: ready for connections 010904 14:05:27 Error reading packet from server: Could not find first log (0) 010904 14:06:27 Error reading packet from server: Could not find first log (0) [root@dev mysql]# more dev.l90.com.err 010904 14:05:12 mysqld started /usr/sbin/mysqld: ready for connections 010904 14:05:12 Slave thread: error connecting to master:Can't connect to MySQL server on 'sc-admin.admonitor.net' (111), retry in 60 sec Number of processes running now: 0 010904 14:05:27 mysqld restarted /usr/sbin/mysqld: ready for connections 010904 14:05:27 Error reading packet from server: Could not find first log (0) 010904 14:06:27 Error reading packet from server: Could not find first log (0) 010904 14:07:27 Error reading packet from server: Could not find first log (0) 010904 14:08:27 Error reading packet from server: Could not find first log (0) 010904 14:09:28 Error reading packet from server: Could not find first log (0) 010904 14:10:28 Error reading packet from server: Could not find first log (0) - 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]
MySQL and OpenBSD 2.8
subnet writes: Hi, I'm running OpenBSD 2.8 and MySQL 3.22.32 (recent cvs port). After time ( 1day) the cpu load for the mysqld process goes up to 98%.. Is this a known problem? any ideas? Thanks, Stu Hi! There is a known problem in 2.8 thread library. I do not know when will they fix it. You can ask them , though .. Regards, Sinisa I've seen that this has been addressed in the FAQ, does anyone know if the fix for the pthread problem has been applied to 2.8-stable. Is this the case? Or am I wasting my time and should just upgrade to 2.9? Thanks, Chris - 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 with BLOB and JPG files
Hi, I'm using : - Win NT 4.0 SP6 - Apache 1.3 - PHP 4.05 - MySQL 3.23 When I try to upload JPG files, the temporay files on the server are OK. But when I store them into a BLOB field into mySQL, some images (not all) are truncated after some lines. It's like an EOF byte found ... The SQL is: $reqSQL = UPDATE RESSOURCE SET NOM='.$fichier.' ,EXTENSION='.$extension.' , ; $reqSQL .= DATA=LOAD_FILE('.$ficherRessource.') WHERE ID_RESSOURCE=.$id_ressource; No problem with GIF files, and small JPG. Any idea ? Thanks ___ Hervé Debeire mailto:[EMAIL PROTECTED] COMTECH Software BP 235 - 31677 Labege Cedex Tel: 05 61 39 74 91 Fax: 05 61 39 86 67 - 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: cc/gcc during configure on solaris 2.8
hi. assuming you're using a bash-type shell and gcc is in /some/directory/gcc PATH=$PATH:/some/directory export PATH echo $PATH otherwise: setenv PATH /some/directory:${PATH} if more errors crop up, copy and paste the error message into google and see if any relevant results are returned. hth. -ravi. -Original Message- From: BW (ST) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 11:16 AM To: MySQL List Subject: cc/gcc during configure on solaris 2.8 During my attempt to configure the 3.23.41 source, I encountered the error: configure: error: no acceptable cc found in $PATH. As I'm using gcc on this box, where/how do I identify gcc for configure to use properly? Thanks, Brian - 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
Problem with BLOB and JPG files
Hi, I'm using : - Win NT 4.0 SP6 - Apache 1.3 - PHP 4.05 - MySQL 3.23 When I try to upload JPG files, the temporay files on the server are OK. But when I store them into a BLOB field into mySQL, some images (not all) are truncated after some lines. It's like an EOF byte found ... The SQL is: $reqSQL = UPDATE RESSOURCE SET NOM='.$fichier.' ,EXTENSION='.$extension.' , ; $reqSQL .= DATA=LOAD_FILE('.$ficherRessource.') WHERE ID_RESSOURCE=.$id_ressource; No problem with GIF files, and small JPG. Any idea ? Thanks ___ Hervé Debeire mailto:[EMAIL PROTECTED] COMTECH Software BP 235 - 31677 Labege Cedex Tel: 05 61 39 74 91 Fax: 05 61 39 86 67 - 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: Problem with BLOB and JPG files
Hi, I'm using : - Win NT 4.0 SP6 - Apache 1.3 - PHP 4.05 - MySQL 3.23 When I try to upload JPG files, the temporay files on the server are OK. But when I store them into a BLOB field into mySQL, some images (not all) are truncated after some lines. It's like an EOF byte found ... The SQL is: $reqSQL = UPDATE RESSOURCE SET NOM='.$fichier.' ,EXTENSION='.$extension.' , ; $reqSQL .= DATA=LOAD_FILE('.$ficherRessource.') WHERE ID_RESSOURCE=.$id_ressource; No problem with GIF files, and small JPG. Check the value of max_allowed_packet. You will probably find that your images are truncated to about this size. Then change it. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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 and OpenBSD 2.8/9
I'm running OpenBSD 2.8 and MySQL 3.22.32 (recent cvs port). After time ( 1day) the cpu load for the mysqld process goes up to 98%.. There is a known problem in 2.8 thread library. I do not know when will they fix it. You can ask them , though .. I've seen that this has been addressed in the FAQ, does anyone know if the fix for the pthread problem has been applied to 2.8-stable. Is this the case? Or am I wasting my time and should just upgrade to 2.9? I'm using OpenBSD 2.9-stable port of mysql-3.23.41, and the problem is still happening in the default install. On a low-traffic server, it's not a problem. But with LOTS of MySQL traffic (20,000 unique users a day on a 100% MySQL-driven website) - yes the mysqld process goes up to 99% and freezes the server until I reboot. I've tried the newest pth threads. I've tried all optimizing both MySQL install and the OpenBSD kernel. No luck. Still flies out of control. I know it's not the hardware itself because I had this *exact same server* running our website on Debian Linux, same amount of traffic, and it worked fine. No stress. But as soon as I switched it to OpenBSD 2.9, MySQL freaked out. I'd *LOVE* if someone would ever solve this. Hell - I'd *pay* for a solution! But as of now, nope. The MySQL / OpenBSD / pthread problem isn't fixed yet. (My short-term solution was to move MySQL to its own dedicated server with a 1.4 mHz processor, and 1 gig of RAM. Even then MySQLd is still at 50% CPU most of the time! There's got to be something wrong here Even if the problem is just my devotion to OpenBSD.) If someone wants to use my high-traffic site as a guinea-pig, that's fine. Contact me at [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: Problem with BLOB and JPG files
At 6:35 PM +0200 9/5/01, Carsten H. Pedersen wrote: Hi, I'm using : - Win NT 4.0 SP6 - Apache 1.3 - PHP 4.05 - MySQL 3.23 When I try to upload JPG files, the temporay files on the server are OK. But when I store them into a BLOB field into mySQL, some images (not all) are truncated after some lines. It's like an EOF byte found ... The SQL is: $reqSQL = UPDATE RESSOURCE SET NOM='.$fichier.' ,EXTENSION='.$extension.' , ; $reqSQL .= DATA=LOAD_FILE('.$ficherRessource.') WHERE ID_RESSOURCE=.$id_ressource; No problem with GIF files, and small JPG. Check the value of max_allowed_packet. You will probably find that your images are truncated to about this size. Does max_allowed_packed apply to values loaded with LOAD_FILE()? The truncation might be enforced by the Web server rather than MySQL. For example, CGI.pm has a $POST_MAX variable that controls the maximum amount of information that can be sent back to the script. Then change it. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq -- Paul DuBois, [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: MySQL and OpenBSD 2.8/9
Hi Derek, - Original Message - From: Derek Sivers [EMAIL PROTECTED] much cut But with LOTS of MySQL traffic (20,000 unique users a day on a 100% MySQL-driven website) - yes the mysqld process goes up to 99% and freezes the server until I reboot. Have you tried capturing information from ktrace or truss when this happens? Are there any locked or unusual queries running. Maybe a GDB backtrace would be useful? On a busy server I know things like this can be hard to get. Can you repro the problem on a test server? I've tried the newest pth threads. I've tried all optimizing both MySQL install and the OpenBSD kernel. No luck. Still flies out of control. I know it's not the hardware itself because I had this *exact same server* running our website on Debian Linux, same amount of traffic, and it worked fine. No stress. But as soon as I switched it to OpenBSD 2.9, MySQL freaked out. I'd *LOVE* if someone would ever solve this. Hell - I'd *pay* for a solution! Do you have a commercial support contract with MySQL AB? I have found them to be very helpful, however it may take a while to track down a difficult/hard to find problem and if it is in the OS all they can do is identify it for you then it would be up to you to bring it to the attention of the OS programmers. (Sometimes they can find a work around for a bug) rest cut I had problems at first with FreeBSD and BSDi (the two platforms I use) but they have a very aggressive support policy for paying customers and Monty seems to be dedicated to make MySQL available/proper on as many platforms as possible. The MySQL Dev team is really great but there is only so much work they can do for free! (They have to eat too). However with some patience and enough information I am confident, either way you decide to go, that a problem that reoccurs fairly frequently can be found and fixed. Pthreads seems to be a difficult thing to work through. ( I am not a threads programmer!). Best of luck, Ken - 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: Problem with BLOB and JPG files
-Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] At 6:35 PM +0200 9/5/01, Carsten H. Pedersen wrote: Hi, I'm using : - Win NT 4.0 SP6 - Apache 1.3 - PHP 4.05 - MySQL 3.23 When I try to upload JPG files, the temporay files on the server are OK. But when I store them into a BLOB field into mySQL, some images (not all) are truncated after some lines. It's like an EOF byte found ... The SQL is: $reqSQL = UPDATE RESSOURCE SET NOM='.$fichier.' ,EXTENSION='.$extension.' , ; $reqSQL .= DATA=LOAD_FILE('.$ficherRessource.') WHERE ID_RESSOURCE=.$id_ressource; No problem with GIF files, and small JPG. Check the value of max_allowed_packet. You will probably find that your images are truncated to about this size. Does max_allowed_packed apply to values loaded with LOAD_FILE()? Reading The Fine Manual sec. 6.3.2: (sorry, couldn't resist :-) ) LOAD_FILE(file_name) Reads the file and returns the file contents as a string. ... The file must ... be smaller than max_allowed_packet. The truncation might be enforced by the Web server rather than MySQL. For example, CGI.pm has a $POST_MAX variable that controls the maximum amount of information that can be sent back to the script. This was my first thought as well; However, Hervé does state that the temporay files on the server are OK. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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
Please help! I deleted all data in mysql.uesr table !
Hello! It seems that with a wrong command: mysql delete from user where host='%'; I have casually deleted all data in user table :((( It works for now but after reload all data in the table will be lost ... Can I recover the user table in such a situation ??? Thank you ! -- Piter - 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: Problem with BLOB and JPG files
At 7:34 PM +0200 9/5/01, Carsten H. Pedersen wrote: -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] At 6:35 PM +0200 9/5/01, Carsten H. Pedersen wrote: Hi, I'm using : - Win NT 4.0 SP6 - Apache 1.3 - PHP 4.05 - MySQL 3.23 When I try to upload JPG files, the temporay files on the server are OK. But when I store them into a BLOB field into mySQL, some images (not all) are truncated after some lines. It's like an EOF byte found ... The SQL is: $reqSQL = UPDATE RESSOURCE SET NOM='.$fichier.' ,EXTENSION='.$extension.' , ; $reqSQL .= DATA=LOAD_FILE('.$ficherRessource.') WHERE ID_RESSOURCE=.$id_ressource; No problem with GIF files, and small JPG. Check the value of max_allowed_packet. You will probably find that your images are truncated to about this size. Does max_allowed_packed apply to values loaded with LOAD_FILE()? Reading The Fine Manual sec. 6.3.2: (sorry, couldn't resist :-) ) Hey, that's no fair - countering with *facts*! LOAD_FILE(file_name) Reads the file and returns the file contents as a string. ... The file must ... be smaller than max_allowed_packet. Huh. You're right. I was thinking that because the file has to be on the server host, the server could read it directly and thus the contents wouldn't be subject to the network-traffic max_allowed_packet size. The truncation might be enforced by the Web server rather than MySQL. For example, CGI.pm has a $POST_MAX variable that controls the maximum amount of information that can be sent back to the script. This was my first thought as well; However, Hervé does state that the temporay files on the server are OK. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq -- Paul DuBois, [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
'tmp/mysql.sock' (2) error
I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've tried specifying socket=/path/to/socket in both [client] and [mysqld] sections of my.cnf, and I've tried to edit safe_mysqld directly with this path. In all cases, the mysql server appears to start (no error messages are generated when I run S99mysql start, anyway), but I get the ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) message. I'm guessing that some other file is overwriting the my.cnf settings so that the server still expects connections to come through the /tmp/mysql.sock socket. I can't, however, figure out which file that is/may be. In consulting the docs, all I can glean is that (1) I'm using the wrong socket file which is precisely what I'm attempting to do, or (2) per the third-to-last bullet at the bottom of p.571 of the mysql manual, I need to somehow notify the clients of the new path. I believe this is where I'm stuck since I thought the [client] setting in my.cnf was suppose to do this. All help to sort this out is appreciated. Thanks, Brian - 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
Please help! I deleted all data in mysql.user table ! (SOS!)
Hello again ! Sorry I made some mistakes. The the wrong command was - DELETE FROM user WHERE Host LIKE %; and got this: mysql select * from user; Empty set (0.00 sec) Can I recover the user table in such a situation ??? Thanks agin. It seems that with a wrong command: mysql delete from user where host='%'; I have casually deleted all data in user table :((( It works for now but after reload all data in the table will be lost ... Can I recover the user table in such a situation ??? Thank you ! -- Piter -- Petr Osenev System Administrator , SITEK ISP - 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: 'tmp/mysql.sock' (2) error
I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've tried specifying socket=/path/to/socket in both [client] and [mysqld] sections of my.cnf, and I've tried to edit safe_mysqld directly with this path. In all cases, the mysql server appears to start (no error messages are generated when I run S99mysql start, anyway), but I get the ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) message. I'm guessing that some other file is overwriting the my.cnf settings so that the server still expects connections to come through the /tmp/mysql.sock socket. I can't, however, figure out which file that is/may be. In consulting the docs, all I can glean is that (1) I'm using the wrong socket file which is precisely what I'm attempting to do, or (2) per the third-to-last bullet at the bottom of p.571 of the mysql manual, I need to somehow notify the clients of the new path. I believe this is where I'm stuck since I thought the [client] setting in my.cnf was suppose to do this. All help to sort this out is appreciated. Is my.cnf world readable? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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: 'tmp/mysql.sock' (2) error
Yes, I gave it 644 permissions. - Original Message - From: Carsten H. Pedersen [EMAIL PROTECTED] To: BW (ST) [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 10:58 AM Subject: RE: 'tmp/mysql.sock' (2) error I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've tried specifying socket=/path/to/socket in both [client] and [mysqld] sections of my.cnf, and I've tried to edit safe_mysqld directly with this path. In all cases, the mysql server appears to start (no error messages are generated when I run S99mysql start, anyway), but I get the ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) message. I'm guessing that some other file is overwriting the my.cnf settings so that the server still expects connections to come through the /tmp/mysql.sock socket. I can't, however, figure out which file that is/may be. In consulting the docs, all I can glean is that (1) I'm using the wrong socket file which is precisely what I'm attempting to do, or (2) per the third-to-last bullet at the bottom of p.571 of the mysql manual, I need to somehow notify the clients of the new path. I believe this is where I'm stuck since I thought the [client] setting in my.cnf was suppose to do this. All help to sort this out is appreciated. Is my.cnf world readable? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq _ 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
InnoDB-3.23.41b source released at www.innodb.com: the BLOB bug fixed
Hi! Since I heard Monty is in Sweden, which will probably delay the release of 3.23.42 still a couple of days, I decided to release the InnoDB-3.23.41b source at my website http://www.innodb.com right now. The release fixes the bad BLOB bug where any update of the primary key of a 8000-byte row corrupted the table. It is best that you reimport your tables which have 8000-byte rows. InnoDB Monitor is now divided into innodb_monitor, innodb_lock_monitor, and innodb_tablespace_monitor. See the online manual at http://www.innodb.com for details. Regards, Heikki Tuuri Innobase Oy - 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
Hi!
I am New at this Mailing List, `cause of it first of all lemme say Hi to everybody... I`m facing a problem with my Web Server, it`s a Conectiva Linux, running Apache We had a problem with it last night, all configuration files were lost and were forced to recover the backup. After this, trying to use my MySQL tables I receive an error that some files with the extension *.ISM are not being found. Does somebody knows how can I try to fix this? I`ll wait for you! Pedro - 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: my.cnf file
Hi all Is there a document available somewhere outlining some guidelines regarding what parameters should be set in the my.cnf files for the MySQL database and to what values? thanks = __ 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
MySQL/PHP
Hello all, I am trying to integrate the mysql with php. As I am using the Red Hat 7.0, I know that they come pre-installed and pre-configured. When i created test.php with the ?php phpinfo() ? line, the page shows that the php is able to recognize the presense of mysql. I created a small table 'namelist' in a database named 'newone'. I am trying to read the table through a php file. Here is the simple php page that i have created for this purpose. html head titleName List/title /head body ?php $db=mysql_connect (localhost,myname,mypassword); mysql_select_db (newone,$db); $result = mysql_query (select * from namelist); printf (First Name: %sbr\n, mysql_result($result, 0, firstname)); printf (Last Name: %sbr\n, mysql_result($result, 0, lastname)); ? /body /html It is producing the following bunch of errors. Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/namelist.php on line 7 Warning: Supplied argument is not a valid MySQL-Link resource in /var/www/html/namelist.php on line 8 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/namelist.php on line 9 Warning: MySQL: A link to the server could not be established in /var/www/html/namelist.php on line 9 Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/namelist.php on line 10 First Name: Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/namelist.php on line 11 Last Name: Can any one tell me what causing it to generate these errors. TIA Chakravarthy Sannedhi http://www.dpo.uab.edu/~kalyan __ 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: MySQL/PHP
Chakravarthy K Sannedhi wrote: $db=mysql_connect (localhost,myname,mypassword); mysql_select_db (newone,$db); $result = mysql_query (select * from namelist); [snip] Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/namelist.php on line 7 You could not connect (in case you did not figure that out) and: Warning: Supplied argument is not a valid MySQL-Link resource in /var/www/html/namelist.php on line 8 etc. are from the fact you do not have a valid $db. $db = mysql_connect( ... ); if( $db ){ ... } First, I would check the user/password with 'mysql', e.g.: mysql newone myname mypassword If that works, then it is a mystery to me as to why it is failing but you may want to connect using network sockets e.g. by specififying the host: $db = mysql_connect( 'the.host.name', 'myname', 'mypassword ); shameless_plug Also, you may want to check out class.DBI which abstracts the database like the perl module by the same name: http://evilbill.org/php/DBI.php3 /shameless_plug --Bill - 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/PHP
hmm. Are you sure that MySQL is running? Conversely, does the file /var/lib/mysql/mysql.sock exist? Steve At 11:52 AM 9/5/01 -0700, Chakravarthy K Sannedhi wrote: Hello all, I am trying to integrate the mysql with php. As I am using the Red Hat 7.0, I know that they come pre-installed and pre-configured. When i created test.php with the ?php phpinfo() ? line, the page shows that the php is able to recognize the presense of mysql. I created a small table 'namelist' in a database named 'newone'. I am trying to read the table through a php file. Here is the simple php page that i have created for this purpose. html head titleName List/title /head body ?php $db=mysql_connect (localhost,myname,mypassword); mysql_select_db (newone,$db); $result = mysql_query (select * from namelist); printf (First Name: %sbr\n, mysql_result($result, 0, firstname)); printf (Last Name: %sbr\n, mysql_result($result, 0, lastname)); ? /body /html It is producing the following bunch of errors. Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/namelist.php on line 7 Warning: Supplied argument is not a valid MySQL-Link resource in /var/www/html/namelist.php on line 8 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/namelist.php on line 9 Warning: MySQL: A link to the server could not be established in /var/www/html/namelist.php on line 9 Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/namelist.php on line 10 First Name: Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/namelist.php on line 11 Last Name: Can any one tell me what causing it to generate these errors. TIA Chakravarthy Sannedhi http://www.dpo.uab.edu/~kalyan __ 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 - 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
Too many session opened !!!
Hi, I' have installed mysql on linux 7.1 and when a web application open a new session of mysql it remain opened in memory, so my server goes in memory overload. please help me. thanks P.S.: Sorry for my english !!! - 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: 'tmp/mysql.sock' (2) error
Well, this is a client error, not a server error. What client is this? Maybe you have another my.cnf in the data directory, or possibly a .my.cnf file in your home directory. BW (ST) wrote: I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've tried specifying socket=/path/to/socket in both [client] and [mysqld] sections of my.cnf, and I've tried to edit safe_mysqld directly with this path. In all cases, the mysql server appears to start (no error messages are generated when I run S99mysql start, anyway), but I get the ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) message. I'm guessing that some other file is overwriting the my.cnf settings so that the server still expects connections to come through the /tmp/mysql.sock socket. I can't, however, figure out which file that is/may be. In consulting the docs, all I can glean is that (1) I'm using the wrong socket file which is precisely what I'm attempting to do, or (2) per the third-to-last bullet at the bottom of p.571 of the mysql manual, I need to somehow notify the clients of the new path. I believe this is where I'm stuck since I thought the [client] setting in my.cnf was suppose to do this. All help to sort this out is appreciated. Thanks, Brian - 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
Getting the pass mark
Is it possible to modify the following query: SELECT COUNT(*) AS pass WHERE test=x AND value BETWEEN low AND high; to also count the total number of records where 'test=x' and hence return the percentage pass mark all within one statement, or am I stuck using 2 statements 1 as above to count the passes and a second : SELECT COUNT(*) AS total WHERE test=x; to count the total?? Chris Thorpe Consultronics Europe Ltd - 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: replication problem
I think your slave version is too old. Duc Chau wrote: If i put a server-id in the slave my.cnf file and start up the database with safe-mysqld, it starts and dies with this error in the log file. unrecognized option `--server-id=2' -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 7:25 AM To: Duc Chau Cc: [EMAIL PROTECTED] Subject: Re: replication problem The slave does not have a server-id. Duc Chau wrote: Hi, this is my first time posting to the list. I've followed mysql replications how-tos to a tee...and I am still not able to get it to work. the master mysql is running on a sun sparc station (SunOS 2.8) with mysql 3.23.41 the file /etc/my.cnf is as follows: # The following options will be passed to all MySQL clients [client] port= 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16K set-variable= max_allowed_packet=1M set-variable= thread_stack=64K set-variable= table_cache=4 set-variable= sort_buffer=64K set-variable= net_buffer_length=2K server-id = 1 log-bin [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [myisamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [mysqlhotcopy] interactive-timeout The slave is running on a compaq prescario running red hat linux 7.1 with MySQL (Ver 10.12 Distrib 3.23.25-beta, for pc-linux-gnu (i686)) the file /etc/my.cnf is as follows: # The following options will be passed to all MySQL clients [client] port= 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] master-host=$host goes here master-user=$user goes here master-password=$password goes here master-port=3306 port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16K set-variable= max_allowed_packet=1M set-variable= thread_stack=64K set-variable= table_cache=4 set-variable= sort_buffer=64K set-variable= net_buffer_length=2K log-bin [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [myisamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [mysqlhotcopy] interactive-timeout Can someone tell me what i'm doing wrong? After reading thru all these how to's it seems so easy to get. Would the problem be cuz i'm going from solaris to linux? If that was the case though wouldnt i get errors importing the snapshots? The snapshot of the master data directory imported just fine. Another problem I noticed is if i put server-id = $any number here in the slave my.cnf i get this error /usr/sbin/mysqld: unrecognized option `--server-id=1'. Any help or direction on where i can find an answer would be great i've read through about 5 how to's. this is in my error log on the slave machine: 010904 14:05:12 mysqld started /usr/sbin/mysqld: ready for connections 010904 14:05:12 Slave thread: error connecting to master:Can't connect to MySQL server on 'sc-admin.admonitor.net' (111), retry in 60 sec Number of processes running now: 0 010904 14:05:27 mysqld restarted /usr/sbin/mysqld: ready for connections 010904 14:05:27 Error reading packet from server: Could not find first log (0) 010904 14:06:27 Error reading packet from server: Could not find first log (0) [root@dev mysql]# more dev.l90.com.err 010904 14:05:12 mysqld started /usr/sbin/mysqld: ready for connections 010904 14:05:12 Slave thread: error connecting to master:Can't connect to MySQL server on 'sc-admin.admonitor.net' (111), retry in 60 sec Number of processes running now: 0 010904 14:05:27 mysqld restarted /usr/sbin/mysqld: ready for connections 010904 14:05:27 Error reading packet from server: Could not find first log (0) 010904 14:06:27 Error reading packet from server: Could not find first log (0) 010904 14:07:27 Error reading packet from server: Could not find first log (0) 010904 14:08:27 Error reading packet from server: Could not find first log (0) 010904 14:09:28 Error reading packet from server: Could not find first log (0) 010904 14:10:28 Error reading packet from server: Could not find first log (0) - 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:
fields query
I need to read the fields of a table dynamically using DBI.pm The resulting cgi script should be a form that has a checkbox for each field...the user will then create a temporary table based on which fields are checked in the form. = -- Anthony Ettinger [EMAIL PROTECTED] 415-504-8048 http://chovy.com/resume.doc __ 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: Getting the pass mark
SELECT SUM( test=x ) AS total, COUNT(*) AS pass FROM table WHERE text=x AND value BETWEEN low AND high; b. Chris Thorpe wrote: Is it possible to modify the following query: SELECT COUNT(*) AS pass WHERE test=x AND value BETWEEN low AND high; to also count the total number of records where 'test=x' and hence return the percentage pass mark all within one statement, or am I stuck using 2 statements 1 as above to count the passes and a second : SELECT COUNT(*) AS total WHERE test=x; to count the total?? Chris Thorpe Consultronics Europe Ltd - 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 -- Bill Adams TriQuint Semiconductor - 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
OT: Survey style question
Apologies for the off topic, but I'm collecting some information, and I figured the lists that I'm on would provide a good feedback mechanism. Replies to me off-list if you would please. My apologies for the very short notice, but I just heard that I need this by ~8 AM EST Thu 6th Sept :( A college graduate, with only an Associate's Degree and a CCNE approaches you/your company, with a resume that indicates no experience whatsoever, just the schooling from an associate's degree, a CCNE and knowledge of layers 1 - 3 of the OSI model. Would you hire this individual? If not, why not? If so, approximately what salary (no including benefits etc, currency if not USD please) would you be prepared to offer, and what type of position? And, if you don't mind: What industry are you/your company in? My thanks in advance if you take some time to answer these questions. I don't need 10 paragraph answers :) (database, mysql) -- Sapere aude My mind not only wanders, it sometimes leaves completely. - 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: fields query
my $dbh = DBI-connect( ... ); my $sth = $dbh-prepare( SHOW COLUMNS FROM $table ) or die; $sth-execute( ) or die; my @columns; while( my( $column_name ) = $sth-fetchrow_array( )){ push @columns, $column_name; } $sth-finish( ); b. Anthony E. wrote: I need to read the fields of a table dynamically using DBI.pm The resulting cgi script should be a form that has a checkbox for each field...the user will then create a temporary table based on which fields are checked in the form. = -- Anthony Ettinger [EMAIL PROTECTED] 415-504-8048 http://chovy.com/resume.doc __ 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 -- Bill Adams TriQuint Semiconductor - 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: Getting the pass mark
On Wed, Sep 05, 2001 at 08:30:53PM +0100, Chris Thorpe wrote: Is it possible to modify the following query: SELECT COUNT(*) AS pass WHERE test=x AND value BETWEEN low AND high; to also count the total number of records where 'test=x' and hence return the percentage pass mark all within one statement, or am I stuck using 2 statements 1 as above to count the passes and a second : SELECT COUNT(*) AS total WHERE test=x; to count the total?? Chris Thorpe Consultronics Europe Ltd ponder this, SELECT COUNT(*) AS count, (value BETWEEN low AND high) AS aa WHERE test=x GROUP BY aa; -- - DISCLAIMER: Anyone sending me unsolicited commercial electronic mail automatically agrees to be held to the following legal terms: US Code Title 47, Sec.227(a)(2)(B), a computer/modem/printer meets the definition of a telephone fax machine. By Sec.227(b)(1)(C), it is unlawful to send any unsolicited advertisement to such equipment. By Sec.227(b)(3)(C), a violation of the aforementioned Section is punishable by action to recover actual monetary loss, or $500, whichever is greater, for each violation. - 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
table full error
Hello, I keep getting this: insert into tmp select * from ascend_log_2001_08_25; ERROR 1114: The table 'tmp' is full tmp is a heap table I've looked through the docs and mailing list archives and can't find anything that matches my problem. I'm using 3.23.41 so it should switch to disk if it runs out of mem for a temp table. Which shouldn't even be happening as I have plenty of mem free. Disk is no where near full. So I really have no idea what could be causing this. If anyone could help me out it would be appreciated. Oh and if I convert tmp to a MYISAM table it works fine. Thanks, -- Ian - 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: output to csv
On Wed, Sep 05, 2001 at 07:59:15AM +0800, Steve Doig wrote: Hi Folks, I'm running a batch command in win2K: cmd mysql batch-file output.txt In the batch file, can I specify that values are separated by commas instead of tabs? Cheers, Steve not using that syntax but with somethinig like this, maby. echo SELECT ... INTO outfile; | mysql /dev/null -- - DISCLAIMER: Anyone sending me unsolicited commercial electronic mail automatically agrees to be held to the following legal terms: US Code Title 47, Sec.227(a)(2)(B), a computer/modem/printer meets the definition of a telephone fax machine. By Sec.227(b)(1)(C), it is unlawful to send any unsolicited advertisement to such equipment. By Sec.227(b)(3)(C), a violation of the aforementioned Section is punishable by action to recover actual monetary loss, or $500, whichever is greater, for each violation. - 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
Expiring Binary Logs
I've been running a master/slave MySQL database system for about four months now and I've got nearly 360mb of binary logs. I want to archive anything over about a month old, but I've heard that there is a procedure that you have to go through to do that. - 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 startup problem - Linux 7.1
Hi folks, just signed up to the list so I hope this is the correct place to send such a question: I have recently upgraded to Red Hat Linux 7.1 from Red Hat 6.x I had successfully run MySQL under that distribution but am having problems with it under Red Hat 7.1 I have installed mysql-3.23.36 from the RPM file. When I attempt to run mysql from teh command line I get the following message: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) When I check my log file at /var/log/mysqld.log I get a message as follows: 010905 16:10:14 mysqld started 010905 16:10:14 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010905 16:10:14 mysqld ended I have checked /var/lib/mysql directory and have the following items: mysql mysql.sock test I am assuming the test directory is the test database though it doesn't contain anything. Inside the mysql directory (so inside /var/lib/mysql/mysql) I can see the following items: columns_priv.frm db.frm func.frm host.frm tables_priv.frm user.frm columns_priv.MYD db.MYD func.MYD host.MYD tables_priv.MYD user.MYD columns_priv.MYI db.MYI func.MYI host.MYI tables_priv.MYI user.MYI - I am not sure if I have included too little or too much information. above. I have attempted to figure out what I have done incorrectly by reading the installed mysql docs but can't figure out where I have gone wrong. Once I get MySQL running I more or less know what I am doing but to start it I am stumped. Any help would be appreciated. Dave Lake [EMAIL PROTECTED] p.s. Is it my imagination or did MySQL run when set up under Red Hat 6.x whereas there is more tweaking to do under Red Hat 7.1 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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: OT: Survey style question
On Wed, Sep 05, 2001 at 03:46:03PM -0400, Duncan Hill wrote: A college graduate, with only an Associate's Degree and a CCNE approaches you/your company, with a resume that indicates no experience whatsoever, just the schooling from an associate's degree, a CCNE and knowledge of layers 1 - 3 of the OSI model. Jeez, if that were the only way to measure a person's worth I'd never be employed. I entered my current employer as a nerd from from high school into a tech support position, and now (3 years later) I'm the lead developer. Would you hire this individual? You didn't mention what position they're applying for.. The best way to know if they're right for the job is to have them talk to people that would work with them, or maybe to the people that they're replacing. Ideally, you'd want to find a person who did the same thing at their last employer that they're doing now, but I've seen that backfire terribly if the interviewer was uneducated (Someone working on a Fortran compiler development group for the past 7 years is rejected from a Java compiler developer group position because he didn't have experience with Java, for example). You should not only evaluate their current worth but any potential future worth. If they're enthusiastic, a lack of industry experience may become a non-issue after they've been working there for 3 months. But then again, based on the position they're applying for, this could be terrible advice. (database,table) -- Michael Bacarella [EMAIL PROTECTED] Technical Staff / System Development, New York Connect.Net, Ltd. - 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: Getting the pass mark
Adams, Bill TQO wrote: SELECT SUM( test=x ) AS total, COUNT(*) AS pass FROM table WHERE text=x AND value BETWEEN low AND high; b. Ugh, brain fart. SELECT COUNT(*) AS total, SUM( value BETWEEN low AND high ) AS pass FROM table WHERE text=x; --Bill - 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: my.cnf file
FVFM (thats: From the Very Fine Manual ) http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Databa se_Administration.html#SHOW_VARIABLES You may have the above line split by your mail reader, just cut and paste the two havles in or go to: http://www.mysql.com/documentation/mysql/bychapter/ and Select chapter 4.5.5.4 Show Variables For example my.cnf files see your source code directory for mysql then change into 'cd ./support-files' adn looke for things like 'huge.cnf' etc. Ken - Original Message - From: Gene Gurevich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 2:45 PM Subject: Re: my.cnf file Hi all Is there a document available somewhere outlining some guidelines regarding what parameters should be set in the my.cnf files for the MySQL database and to what values? thanks = __ 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 - 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: table full error
[EMAIL PROTECTED] wrote: Hello, I keep getting this: insert into tmp select * from ascend_log_2001_08_25; ERROR 1114: The table 'tmp' is full tmp is a heap table There is a size limit to temp tables. See: http://www.mysql.com/doc/F/u/Full_table.html about increasing the allowed size for temp tables. You can write the temp tables to disk with the SQL 'SET SQL_BIG_TABLES = 1;' http://www.mysql.com/doc/S/E/SET_OPTION.html --Bill - 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
Slow replication question/problem
Greetings, This morning we sucessfully inserted a new record on our master MySQL machine. 4 1/2 hours later, the change showed up on the slaves. I was under the impression that MySQl replication would occur in a more timely fashion. We have a single master with 4 slaves replicating only one of our databases using MySQL v. 3.23.41 compiled from source on both the master and the slaves. There are no obvious (to me) errors in the error log or the binlog. The master is a dual 1Ghz PIII w/ 2GB RAM. The slaves consist of both dual 800Mhz PIII's w/ 2GB of RAM and quad 450MHZ Ultrasparc II's w/ 4GB RAM. Everything resides on a 100Mbit switched LAN. (Since we're still working the bugs out of the setup these systems have no real load). I'm not really sure where to start looking, so please let me know if there's anything I can provide that would shed some light on this. Thanks, Jeff Adams Webmaster Hoover's Online - 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: The Mysql socket thing using Redhat 7.1
[EMAIL PROTECTED] (Jason Bailey) writes: If the server is creating mysql.sock in and something else is looking for it in /tmp, this is the easiest way to get it to work, besides checking to make sure that the permissions are such that anyone who needs to can read and write to mysql.sock. -- I think this may be my problem in that I couldn't understand whether mysql.sock should be located in /var/lib/mysql but is required to be in /tmp. It certainly appears in /var/lib/mysql I'll try your suggestion for this and check permissions. As written before, it is a permissions problem - mysql_install_db (unnecesarry , don't run it - just run service mysqld start ) will create files owned by root. If you look in the default /etc/my.cnf, the database runs as user mysql (for security reasons). To fix it, do a chown -R mysql.mysql /var/lib/mysql If you had started mysql the same way you start other services (httpd, samba, etc) via tksysv/ntsysv(permanently, on every boot) or service httpd start (do it right now - equivalent to /etc/init.d/httpd start), it would have created the database with correct permissions automatically. mysql_install_db and safe_mysqld aren't necesarry, and will often cause problems. -- Trond Eivind Glomsrød Red Hat, Inc. - 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