MySQL installation on HP-UX 10.20
Hi! Can anybody guide me to the link for MySQL on a HP-UX 10.20 system. I have found the binaries for HP-UX 11 and 11.11, but nothing for 10.20. Thanx for the help in advance, Gagneet -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5 problem with select and stored procs
It's just a simple select: select * from mytable but run from within the control center The error returned: [RM_SERVER] ERROR 1146: Table 'rm_development.1' doesn't exist where RM_SERVER is the server I created and rm_development is the database. I did see someone else has posted with the same issue in Mysql 5. Any help appreciated. - Original Message - From: Aleksandar Bradaric [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, January 16, 2004 1:15 PM Subject: Re: MySQL 5 problem with select and stored procs Hi, Any ideas why it's looking for the table .1? Could you post your query? Take care, Aleksandar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Memory leaks using MySQL C Api
Hi! You're looking for the function my_free(). Enjoy! Regards, Chris John McCaskey wrote: I have the following code: //try the mysql connection mysql_init(mysql_connection); if(!mysql_real_connect(mysql_connection, db_host, db_user, db_pass, db_db, 0, NULL, 0)) { flockfile(stderr); fprintf(stderr, %s: Failed to connect to database: Error: %s\n, timestamp, mysql_error(mysql_connection)); funlockfile(stderr); mysql_close(mysql_connection); return(2); } mysql_close(mysql_connection); This code is creating a memory leak. Am I missing some cleanup calls? I'm under the impression all I should need to do is call mysql_close to clean up the connection? I'm testing this using mtrace, if I place a return directly above the code segment it reports no leaks, if I place it direcly below the fragment there are several variables reported as not being freed. Any ideas? John A. McCaskey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Tallkoz a kvetkezvel: 'MySQL List'
BEGIN:VCALENDAR PRODID:-//Microsoft Corporation//Outlook 11.0 MIMEDIR//EN VERSION:2.0 METHOD:REQUEST BEGIN:VEVENT ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:[EMAIL PROTECTED] ORGANIZER:MAILTO:[EMAIL PROTECTED] DTSTART:20040117T11Z DTEND:20040117T113000Z TRANSP:OPAQUE SEQUENCE:0 UID:04008200E00074C5B7101A82E008B0352F3BEFDCC301100 023E0A6F1FEAEE9408DB4A936D48D1688 DTSTAMP:20040117T104414Z DESCRIPTION:When: 2004. janur 17. 12:00-12:30. Idzna: (GMT+01:00) Belgrd\, Budapest\, Ljubljana\, Pozsony\, Prga.\n\n*~*~*~*~*~*~*~*~*~*\n\n\n SUMMARY:Tallkoz a kvetkezvel: 'MySQL List' PRIORITY:5 X-MICROSOFT-CDO-IMPORTANCE:1 CLASS:PUBLIC BEGIN:VALARM TRIGGER:-PT15M ACTION:DISPLAY DESCRIPTION:Reminder END:VALARM END:VEVENT END:VCALENDAR -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Do I need Innodb?
On Fri, 16 Jan 2004 13:43:55 -0800 Ron McKeever [EMAIL PROTECTED] wrote: Scenario 1: I have noticed that if two users open a record to edit it in two different browsers and they edit the same field and then click update, the last user/browser gets written to the db, where the first users data is over written. I would hope it would write user ones info then write user twos info, without over writing user ones updates Will INNODB table type fix Scenario 1? No. You should use INSERT instead of UPDATE if you don't want the data to be overwritten. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
table info
Is it possible to find out when the table was created? How to get information about the table? Thanks
Re: MySQL and Perl DBI Persistent Connection
On Fri, 16 Jan 2004 17:54:06 -0500 Syed Ali [EMAIL PROTECTED] wrote: I have a Perl CGI script which uses DBI to access MySQL. I noticed that each query through the Perl CGI script using DBI has a connect, query and then quit. I was wondering if there is a way of keeping the connection persistent to Mysql through the Perl CGI script. In my Apache httpd.conf I inserted PerlModule Apache::DBI before all LoadModule lines, but that does not solve the problem. I also downloaded the Apache::DBI module from CPAN and installed it. Perhaps I need to do something else? Is your script running through mod_perl or plain CGI? If it is running through CGI, you can't make persistent connection to MySQL. You should check: http://perl.apache.org/docs/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Do I need Innodb?
hi, Thanks for the response. I thought update is for existing records and insert is to add new records? My Scenario is if two users open an existing record with data already in the fields. They then add some information to the end of a field with data. Now when they click update the last user/browser gets written to the db, where the first users data is over written. I thought innodb would help this.. user a: user b: pulls up record 5 pulls up record 5 adds/appends line to field badds/appends line to field b clicks update first clicks update second user b's line is added/appended to record 5, user a's line is overwritten not even seen. Ron -Original Message- From: Batara Kesuma [mailto:[EMAIL PROTECTED] Sent: Saturday, January 17, 2004 4:20 AM To: [EMAIL PROTECTED] Subject: Re: Do I need Innodb? On Fri, 16 Jan 2004 13:43:55 -0800 Ron McKeever [EMAIL PROTECTED] wrote: Scenario 1: I have noticed that if two users open a record to edit it in two different browsers and they edit the same field and then click update, the last user/browser gets written to the db, where the first users data is over written. I would hope it would write user ones info then write user twos info, without over writing user ones updates Will INNODB table type fix Scenario 1? No. You should use INSERT instead of UPDATE if you don't want the data to be overwritten. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Server startup Problem
Hello Everyone, I downloaded and installed the mysql-standard-4.0.17-apple-darwin6.8-powerpc.dmg file from the mysql web site to my ibook running Mac OSX Version 10.1.5 on it. I read the documentation on the mysql site and it said to do the following next: shell cd /usr/local/mysql shell sudo ./bin/mysqld_safe (Enter your password, if necessary) The server started running at this point but less then one second later, the server killed itself. I looked at the localhost.err file in the /usr/local/mysql/data directory and it had the following text in it: 040117 10:35:09 mysqld started dyld: /usr/local/mysql/bin/mysqld Undefined symbols: /usr/local/mysql/bin/mysqld undefined reference to _localtime_r expected to be defined in /usr/lib/libSystem.B.dylib 040117 10:35:10 mysqld ended Has anyone else experienced this problem on their Mac? Does anyone know how I can correct this issue? I know that my version of OSX is a little old as far as the mysql web site documentation says but the installation process went smoothly without any errors at all coming up. Any help on this matter would be greatly appreciated. Thanks in advance. ~~Nick ___ Join Excite! - http://www.excite.com The most personalized portal on the Web! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Memory leaks using MySQL C Api
Hey wait a minute. Where did you get the my_free(), may be you are trying to say mysql_free(), but then that is used only if result set is used/called. But the code does not show any result set call. ie. mysql_use_result() or mysql_store_result(). So, the question now, how come there is a leak here. I dont see any, does anyone see any? Chris Nolan wrote: Hi! You're looking for the function my_free(). Enjoy! Regards, Chris John McCaskey wrote: I have the following code: //try the mysql connection mysql_init(mysql_connection); if(!mysql_real_connect(mysql_connection, db_host, db_user, db_pass, db_db, 0, NULL, 0)) { flockfile(stderr); fprintf(stderr, %s: Failed to connect to database: Error: %s\n, timestamp, mysql_error(mysql_connection)); funlockfile(stderr); mysql_close(mysql_connection); return(2); } mysql_close(mysql_connection); This code is creating a memory leak. Am I missing some cleanup calls? I'm under the impression all I should need to do is call mysql_close to clean up the connection? I'm testing this using mtrace, if I place a return directly above the code segment it reports no leaks, if I place it direcly below the fragment there are several variables reported as not being freed. Any ideas? John A. McCaskey -- Aftab Jahan Subedar CEO/Software Engineer Subedar Technologies Subedar Baag Bibir Bagicha #1 North Jatrabari Dhaka 1204 Bangladesh http://www.SubedarTechnologies.com http://www.DhakaStockExchangeGame.com/ http://www.CEOBangladesh.com/ http://www.NYSEGame.com tel://+88027519050 EMail://[EMAIL PROTECTED] - Directly to my notebook -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't Set SQL_MODE?!
Howdy all, I've tried to search for an answer to this on the lists (and on google), but I haven't been able to come up with anything, so I apologize in advance if this question is redundant. According to the docs (http://www.mysql.com/doc/en/SQL_mode.html): The MySQL server can operate in different SQL modes, and can apply these modes differentially for different clients You can set...the SQL_MODE variable with SET [SESSION|GLOBAL] SQL_MODE='modes' Setting the SESSION variable affects only the current client You can retrieve the current mode by issuing a SELECT @@sql_mode statement. Okay, fair enough. My app needs ANSI (or at least PIPES_AS_CONCAT). So here I go... mysql \s -- mysql Ver 12.22 Distrib 4.0.17, for pc-linux (i686) Connection id: 8 Current database: mysql Current user: [EMAIL PROTECTED] SSL: Not in use Current pager: stdout Using outfile: '' Server version: 4.0.17-standard Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: latin1 Server characterset: latin1 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 1 day 14 hours 32 min 19 sec Threads: 1 Questions: 708 Slow queries: 0 Opens: 419 Flush tables: 1 Open tables: 48 Queries per second avg: 0.005 -- mysql SET SESSION SQL_MODE='ANSI'; ERROR 1193: Unknown system variable 'SQL_MODE' mysql SET SESSION sql_mode='ANSI'; ERROR 1193: Unknown system variable 'sql_mode' mysql SELECT @@sql_mode; ERROR 1193: Unknown system variable 'sql_mode' mysql show variables like '%mode%'; +---+---+ | Variable_name | Value | +---+---+ | sql_mode | 0 | +---+---+ 1 row in set (0.00 sec) Huh? Was the documenation just plain lying to me? What gives? Any help would be extremely appreciated. --Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't Set SQL_MODE?!
By the way, I should point out that I *can* get it to work by adding: [mysqld] ansi Or: [mysqld] sql_mode=PIPES_AS_CONCAT But this is not what I want, since I'm going to be hosting this app where I won't have access to the server config. I need to be able to set it on a per session (or client) basis as the documentation indicates. Again, any help would be appreciated. --Matt On Sat, 17 Jan 2004 [EMAIL PROTECTED] wrote: ... Okay, fair enough. My app needs ANSI (or at least PIPES_AS_CONCAT). So here I go... ... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't Set SQL_MODE?!
Try this: mysql set @@session.sql_mode = 'ansi'; Query OK, 0 rows affected (0.00 sec) mysql select @@session.sql_mode; ++ | @@session.sql_mode | ++ | REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,ANSI | ++ 1 row in set (0.00 sec) _ Rethink your business approach for the new year with the helpful tips here. http://special.msn.com/bcentral/prep04.armx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th
I just install MYSQL on Linux (Red Hat 9) using this manual:http://www.mysql.com/doc/en/Installing_binary.html Have no idea what's wrong. I looked on the mysql.log file and the file is empty. ERROR MESSAGE: [EMAIL PROTECTED] bin]# ./mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [EMAIL PROTECTED] bin]# ./mysql status ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' _ Scope out the new MSN Plus Internet Software optimizes dial-up to the max! http://join.msn.com/?pgmarket=en-uspage=byoa/plusST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th
Hi Mike, You have to start the mysql server before you can run the client. Try running mysqld_safe --user=mysql from /usr/bin or /usr/local/bin, depending on where you installed it. To see if it is running currently on your machine, try this: ps -ef | grep mysqld Hope this helps... ~~Nick --- On Sat 01/17, Mike Mapsnac [EMAIL PROTECTED] wrote: From: Mike Mapsnac [mailto: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Sat, 17 Jan 2004 22:51:29 + Subject: Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th I just install MYSQL on Linux (Red Hat 9)brusing this manual:http://www.mysql.com/doc/en/Installing_binary.htmlbrHave no idea what's wrong. I looked on the mysql.log file and the file is brempty.brbrERROR MESSAGE:br[EMAIL PROTECTED] bin]# ./mysqlbrERROR 2002: Can't connect to local MySQL server through socket br'/tmp/mysql.sock' (2)br[EMAIL PROTECTED] bin]# ./mysql statusbrERROR 2002: Can't connect to local MySQL server through socket br'/tmp/mysql.sock'brbr_brScope out the new MSN Plus Internet Software optimizes dial-up to the max! br http://join.msn.com/?pgmarket=en-uspage=byoa/plusST=1brbrbr-- brMySQL General Mailing ListbrFor list archives: http://lists.mysql.com/mysqlbrTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]brbr ___ Join Excite! - http://www.excite.com The most personalized portal on the Web! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
server/client problem with 5.0.0-alpha
Description: when compiled and started, mysqld_safe and mysql work fine from console, but hen used with apache and php, i get the error Client does not support authentication protocol requested by server; consider upgrading MySQL client How-To-Repeat just compile it as i did, when is my problem? Fix: no idea yet Submitter-Id: submitter ID Originator:JanK Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: critical Priority: Category: mysql Class: support Release: mysql-5.0.0-alpha (Source distribution) C compiler:gcc (GCC) 3.2 (Mandrake Linux 9.0 3.2-1mdk) C++ compiler: g++ (GCC) 3.2 (Mandrake Linux 9.0 3.2-1mdk) Environment: System: Linux kernel.ulmasow.de 2.4.21-rc6 #1 Mon Dez 22 14:34:54 UTC 2003 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr//bin/perl /usr//bin/make /usr//bin/gmake /usr//bin/gcc /usr//bin/cc GCC: Reading specs from /usr//bin/../lib/gcc-lib/i586-mandrake-linux-gnu/3.2/specs Configured with: ../configure --prefix=/usr --libdir=/usr/lib --with-slibdir=/lib --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --enable-long-long --enable-__cxa_atexit --enable-languages=c,c++,ada,f77,objc,java --host=i586-mandrake-linux-gnu --with-system-zlib Thread model: posix gcc version 3.2 (Mandrake Linux 9.0 3.2-1mdk) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxr-xr-x1 root root 13 Feb 1 2003 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1147848 Aug 19 2002 /lib/libc-2.2.5.so -rw-r--r--1 root root 2163302 Aug 19 2002 /usr/lib/libc.a -rw-r--r--1 root root 178 Aug 19 2002 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr/local' '--with-mysqld-user=jank' '--with-openssl' '--with-pthread' '--with-charset=latin1' '--with-extra-charsets=all' '--with-php' '--with-mysqlfs' '--with-vio' '--with-ssl' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Authentication screw up
I'm running 3.23.58 on a Red Hat Fedora Core 1 box with the latest updates, (as of a couple days ago). I was using webmin to change the permissions on the database so I could access it from another box. Now, no matter who or what I log in as I can't access anything. If I try to go to the command prompt and use mysql or mysqladmin I get access deniged for user @localhost. No root or anything like that. I don't know where I screwed up, but I obviously screwed up something. Any ideas out there on how I can get back in control of this situation? Nick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Authentication screw up
Nicholas Fitzgerald wrote: go to the command prompt and use mysql or mysqladmin I get access deniged for user @localhost. No root or anything like that. I don't know where I screwed up, but I obviously screwed up something. Any ideas out there on how I can get back in control of this situation? Shutdown mysqld, and restart mysqld with the --skip-grant-tables option. Now you will be able to connect as root without specifying a password. Once you've connected, give the command flush privileges to make Mysql start using the grant tables. Then you can add or edit records in the mysql.user table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Validate date
Quote from MySQL documentation ... MySQL allows you to store some wrong date values into DATE and DATETIME columns (like 2000-02-31 or 2000-02-00). The idea is that it's not the SQL server job to validate date. If MySQL can store a date and retrieve exactly the same date, then MySQL will store the date. If the date is totally wrong (outside the server's ability to store it), then the special date value -00-00 will be stored in the column. IMHO, it is the database job to ensure that date/time is valid as it's stored. Hassan Shaikh