How to write query to select the Max(version) for each unique file_name record?
Hello All, I am a MySQL newbie trying to write a query that selects file_name records possessing the highest numbered version for that unique file_name. I show sample data and two trial queries below. Logically I want to use max(version) as a constraint in a Where Clause. However, the max() function is not allowed directly in a where clause. I have contemplated a second table to track the max version for each file name. I would like to structure the data in an efficient manner for query performance when the data set grows to many thousands of unique file_name records with many hundreds of versions each. Any guidance will be appreciated. David Oberlitner Sample data: mysql select * from test; ++---+-+ | id | file_name | version | ++---+-+ | 1 | fone | 1 | | 2 | ftwo | 1 | | 3 | fone | 2 | | 4 | fone | 3 | | 5 | fthree| 1 | | 6 | ffour | 1 | | 7 | ftwo | 2 | | 8 | ffour | 2 | ++---+-+ The query below gets close in that it returns each file name and its max(version), however it returns the ID field associated with the first record instance of file_name and not the ID associated with the max(version) instance of the file_name record. mysql select id, file_name, max(version) from test group by file_name; ++---+--+ | id | file_name | max(version) | ++---+--+ | 6 | ffour |2 | | 1 | fone |3 | | 5 | fthree|1 | | 2 | ftwo |2 | ++---+--+ 4 rows in set (0.02 sec) The query below returns the empty set. mysql select id, file_name, max(version) from test group by file_name having max(version); Empty set (0.00 sec) Additionally, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Version 5
After I downloaded the Ver 5 Dev tree how do I get it active. I tried the Windows stuff on the Mysql site with no luck. I run WIndows/ME and have Ver3.23 running. When I try to use the instructions for Compile it fails looking for .c pgms How do I get this to work... would like to use the SP functions to duplicate stuff in SQLServer for possible migration.
Re: Version 5
At 19:15 -0500 7/18/03, Andy Hartman wrote: After I downloaded the Ver 5 Dev tree how do I get it active. I tried the Windows stuff on the Mysql site with no luck. the Windows stuff? Please be more specific. The INSTALL-WIN-SOURCE file in the top-level directory of the source tree may be of some use. However, because MySQL 5 is available only from the BitKeeper repository, you'll need to use the approach that requires you to configure a distribution for Windows by using a Unix machine. I run WIndows/ME and have Ver3.23 running. When I try to use the instructions for Compile it fails looking for .c pgms How do I get this to work... would like to use the SP functions to duplicate stuff in SQLServer for possible migration. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Difference of MySQL Standard and Max Version
On Mon, Jul 07, 2003 at 10:57:52AM -0500, Dan Nelson wrote: In the last episode (Jul 07), Nils Valentin said: Thank you for the superfast reply. I actually was looking for other information. I understood the actual feature difference of the standard and f.e max version. Sorry if this didnt came out so clear. I will try to make it clearer. My question was more aiming at what advantages the dynamically linking or the statically linking have (except the memory usage of course). I was thinking when given 2 times the same versions once linked statically and once linked dynamically which one would have which advantages in regards to performance, reliability etc. ? You can't call dlopen() on a statically-linked binary, so you can't use UDFs. On the other hand, static binaries usually run ~20% faster. 20%?! That seems like a high number. Have you actually seed that much of a boost? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 7 days, processed 217,761,232 queries (348/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Difference of MySQL Standard and Max Version
In the last episode (Jul 16), Jeremy Zawodny said: On Mon, Jul 07, 2003 at 10:57:52AM -0500, Dan Nelson wrote: In the last episode (Jul 07), Nils Valentin said: Thank you for the superfast reply. I actually was looking for other information. I understood the actual feature difference of the standard and f.e max version. Sorry if this didnt came out so clear. I will try to make it clearer. My question was more aiming at what advantages the dynamically linking or the statically linking have (except the memory usage of course). I was thinking when given 2 times the same versions once linked statically and once linked dynamically which one would have which advantages in regards to performance, reliability etc. ? You can't call dlopen() on a statically-linked binary, so you can't use UDFs. On the other hand, static binaries usually run ~20% faster. 20%?! That seems like a high number. Have you actually seed that much of a boost? I have, but I haven't tested long-lived monolithic programs like mysql. The big penalties you pay for shared linking are much higher startup overhead, the requirement that your shared libraries be compiled with -fPIC (thus losing a register), and the possible cost of a lookup in a jump table whan calling functions from one library into another. Startup time isn't a problem for mysql, and the server code isn't built out of shared libraries, so a statically-linked mysql might not really buy you that much. http://groups.google.com/groups?selm=3E74E3FB.D08EB9AC%40doe.carleton.ca and http://groups.google.com/groups?threadm=k7clgvoqjur1f10mosue3os74vv7nd34hi%404ax.com talk a bit about the penalties of using shared libs, but they're really from the point of view of the library author and relative speeds of shared libs vs static libs. A dynamically-linked program that spends most of its time in its own code (as opposed to doing function calls to CPU-intensive routines in libraries) will probably not see much of a difference. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: dropping foreign key constraint (version 4.1.0-alpha-max-nt)
Hi! Starting from version 4.0.13, InnoDB supports ALTER TABLE ... DROP FOREIGN KEY internally_generated_foreign_key_id You have to use SHOW CREATE TABLE to look the internally generated foreign key id when you want to drop a foreign key. Version 4.0.13 came in May, but 4.1.0-alpha was released in April. That is why the feature is not yet in 4.1.0. Version 4.1.1 will have DROP FOREIGN KEY. My guess is that 4.1.1 will be released August 31st, 2003. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ - Original Message - From: dcp [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, July 10, 2003 3:35 AM Subject: dropping foreign key constraint (version 4.1.0-alpha-max-nt) I just installed the 4.1.0-alpha-max-nt version of MySql and have just started playing around with it. My first test was to try to create a couple of tables, one with a foreign key constraint. I can't seem to figure out how to drop the foreign key constraint, I read through the docs and it says I need to do a 'show create table table_name' to get the internally generated foreign key id, but this does not show up when I do the show create table table_name statement. I'm thinking this is something new with the 4.1.0-alpha version, in that maybe now it allows you to just type in the name of the foreign key, so I tried alter table child drop foreign key parent_id but got the following error: ERROR 1005: Can't create table '.\test\#sql-634_c.frm' (errno: 150) Here's the entire script output. Any ideas or solutions are greatly appreciated! C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 to server version: 4.1.0-alpha-max-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use test; Database changed mysql CREATE TABLE parent(id INT NOT NULL, - PRIMARY KEY (id)) TYPE=INNODB; Query OK, 0 rows affected (0.07 sec) mysql CREATE TABLE child(id INT, parent_id INT, - INDEX par_ind (parent_id), - FOREIGN KEY (parent_id) - REFERENCES parent(id) - ) TYPE=INNODB; Query OK, 0 rows affected (0.07 sec) mysql show create table child; +---+--- -- -- -+ | Table | Create Table | +---+--- -- -- -+ | child | CREATE TABLE `child` ( `id` int(11) default NULL, `parent_id` int(11) default NULL, KEY `par_ind` (`parent_id`), FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ) TYPE=InnoDB CHARSET=latin1 | +---+--- -- -- -+ 1 row in set (0.00 sec) mysql alter table child drop foreign key parent_id; ERROR 1005: Can't create table '.\test\#sql-634_c.frm' (errno: 150) mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Difference of MySQL Standard and Max Version
Hi MySQL Fans ;-); I know that the MySQL Max Server Version is app. 7MB big while the Standard Version is 10MB big. Having looked further into the downloaded files than I see that the max version is dynamically linked while the standard version is statically linked. What is the reason for the different approaches ? Is it possible to say that f.e given the same features for statically or dynamically linked MySQL versions, that the one or the other would have a advantage (f.e faster for requests, more reliable etc.). Best regards -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Difference of MySQL Standard and Max Version
http://www.mysql.com/downloads/mysql-4.0.html The Standard binaries are recommended for most users, and includes the InnoDB storage engine. The Max version includes additional features such as the Berkeley DB storage engine and other features that have not been exhaustively tested or are not required for general usage, such as user-defined functions (UDFs), and BIG_TABLE support. When these features have matured and proven to be stable, they will be incorporated into future releases of the Standard binaries. The Debug binaries have been compiled with extra debug information, and are not intended for production use, because the included debugging code may cause reduced performance. On Mon, 2003-07-07 at 10:11, Nils Valentin wrote: Hi MySQL Fans ;-); I know that the MySQL Max Server Version is app. 7MB big while the Standard Version is 10MB big. Having looked further into the downloaded files than I see that the max version is dynamically linked while the standard version is statically linked. What is the reason for the different approaches ? Is it possible to say that f.e given the same features for statically or dynamically linked MySQL versions, that the one or the other would have a advantage (f.e faster for requests, more reliable etc.). Best regards -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Difference of MySQL Standard and Max Version
Dear Delfim, Thank you for the superfast reply. I actually was looking for other information. I understood the actual feature difference of the standard and f.e max version. Sorry if this didnt came out so clear. I will try to make it clearer. My question was more aiming at what advantages the dynamically linking or the statically linking have (except the memory usage of course). I was thinking when given 2 times the same versions once linked statically and once linked dynamically which one would have which advantages in regards to performance, reliability etc. ? I hope that makes my question a bit clearer. Best regards Nils Valentin Tokyo/Japan 2003 7 7 18:18Delfim Machado : http://www.mysql.com/downloads/mysql-4.0.html The Standard binaries are recommended for most users, and includes the InnoDB storage engine. The Max version includes additional features such as the Berkeley DB storage engine and other features that have not been exhaustively tested or are not required for general usage, such as user-defined functions (UDFs), and BIG_TABLE support. When these features have matured and proven to be stable, they will be incorporated into future releases of the Standard binaries. The Debug binaries have been compiled with extra debug information, and are not intended for production use, because the included debugging code may cause reduced performance. On Mon, 2003-07-07 at 10:11, Nils Valentin wrote: Hi MySQL Fans ;-); I know that the MySQL Max Server Version is app. 7MB big while the Standard Version is 10MB big. Having looked further into the downloaded files than I see that the max version is dynamically linked while the standard version is statically linked. What is the reason for the different approaches ? Is it possible to say that f.e given the same features for statically or dynamically linked MySQL versions, that the one or the other would have a advantage (f.e faster for requests, more reliable etc.). Best regards -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Difference of MySQL Standard and Max Version
In the last episode (Jul 07), Nils Valentin said: Thank you for the superfast reply. I actually was looking for other information. I understood the actual feature difference of the standard and f.e max version. Sorry if this didnt came out so clear. I will try to make it clearer. My question was more aiming at what advantages the dynamically linking or the statically linking have (except the memory usage of course). I was thinking when given 2 times the same versions once linked statically and once linked dynamically which one would have which advantages in regards to performance, reliability etc. ? You can't call dlopen() on a statically-linked binary, so you can't use UDFs. On the other hand, static binaries usually run ~20% faster. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Difference of MySQL Standard and Max Version
Hi Dan, 2003 7 8 00:57Dan Nelson : In the last episode (Jul 07), Nils Valentin said: Thank you for the superfast reply. I actually was looking for other information. I understood the actual feature difference of the standard and f.e max version. Sorry if this didnt came out so clear. I will try to make it clearer. My question was more aiming at what advantages the dynamically linking or the statically linking have (except the memory usage of course). I was thinking when given 2 times the same versions once linked statically and once linked dynamically which one would have which advantages in regards to performance, reliability etc. ? You can't call dlopen() on a statically-linked binary, so you can't use UDFs. On the other hand, static binaries usually run ~20% faster. Good points, that was actually what I was looking for - practical values. Thank you very much. -- Dan Nelson [EMAIL PROTECTED] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lookup used Version of MySql MySql Foreign Keys and Referencial Integrity
# [EMAIL PROTECTED] / 2003-06-28 16:56:13 +0200: I use mySQL on HP/UX 11.i - unfortunateley I am unable to lookup the used version. What is the command to do that? (according to mysql.info it is Version 3.23.42. ) SELECT VERSION(); -- If you cc me or remove the list(s) completely I'll most likely ignore your message.see http://www.eyrie.org./~eagle/faqs/questions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lookup used Version of MySql MySql Foreign Keys and Referencial Integrity
Hello, I use mySQL on HP/UX 11.i - unfortunateley I am unable to lookup the used version. What is the command to do that? (according to mysql.info it is Version 3.23.42. ) Are foreign keys and referencial integrity supported by MySQL Version 3.23.42. ? If yes - why is the second insert into command allowed? (see below) -- Thanks in Advance and Best regards, Vince mailto:[EMAIL PROTECTED] drop table FremdeNLTB; drop table FNL_ErkennungTB; create table FremdeNLTB ( FN_ID int unsigned not null, Topic varchar(255), Name varchar(255), KatIK int unsigned, Primary Key (FN_ID), Index (FN_ID) ) Type=InnoDB ; create table FNL_ErkennungTB ( FNLE_ID int unsigned not null, FN_ID int unsigned not null, receivedFrom varchar(255), originFrom varchar(255), receivedBy varchar (255), originSentTo varchar (255), Primary Key (FNLE_ID), Index (FN_ID), Foreign Key (FN_ID) References FremdeNLTB(FN_ID) On Delete Cascade On Update Cascade ) Type=InnoDB ; insert into FremdeNLTB values (11,'lost+found','lost+found',999), (21,'MS/Windows','lost+found',999), (22,'MS/Windows','Cluster',999), (23,'MS/Windows','Plattform-Migration',999), (31,'MPE','lost+found',999), (41,'LINUX','lost+found',999), (51,'OpenView','lost+found',999), (52,'OpenView','SAM',999), (53,'OpenView','Omniback2',999), (61,'Storage/SAN','lost+found',999), (62,'Storage/SAN','XP',999), (63,'Storage/SAN','EMC',999), (64,'Storage/SAN','VA',999), (71,'Applications','lost+found',999), (72,'Applications','SAP',999), (73,'Applications','ORACLE',999) ; insert into FNL_ErkennungTB values (1,11,'','','','') ; insert into FNL_ErkennungTB values (123,123,'this','should','not be','possible!!!') ; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
New mtop/mkill version available
mtop (MySQL top) monitors a MySQL server showing the queries which are taking the most amount of time to complete. Features include 'zooming' in on a process to show the complete query, 'explaining' the query optimizer information for a query and 'killing' queries. In addition, server performance statistics, configuration information, and tuning tips are provided. mkill (MySQL kill) monitors a MySQL server for long running queries and kills them after a specified time interval. Queries can be selected based on regexes on the user, host, command, database, state and query. New in this version: mtop has new options to control how many seconds elapse before a slow query is highlighted. Available from: http://mtop.sourceforge.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Latest version of MySQL for windows
What's the latest version of MySQL for windows? Mysql.com says it's 4.1 alpha but the download that reads 4.1 alpha is actually 4.0.12. Is there no version 4.1 available for Windows? Many thanks, rajendra Unless expressly stated to the contrary, the views expressed in this email are not necessarily the views of National Grid Transco plc or any of its subsidiaries or affiliates (Group Companies), and the Group Companies, their directors, officers and employees make no representation and accept no liability for its accuracy or completeness. This e-mail, and any attachments are strictly confidential and intended for the addressee(s) only. The content may also contain legal, professional or other privileged information. If you are not the intended recipient, please notify the sender immediately and then delete the e-mail and any attachments. You should not disclose, copy or take any action in reliance on this transmission. You may report the matter by calling us on + 44(0) 1455 230999 Please ensure you have adequate virus protection before you open or detach any documents from this transmission. The Group Companies do not accept any liability for viruses. An e-mail reply to this address may be subject to monitoring for operational reasons or lawful business practices. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Latest version of MySQL for windows
Losing your mind, perhaps? http://www.mysql.com/downloads/download.php?file=Downloads%2FMySQL-4.1%2Fmysql-4 .1.0-alpha.zipmirror=http%3A%2F%2Fmysql.secsup.org%2F Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, 13 June, 2003 11:57 Subject: Latest version of MySQL for windows What's the latest version of MySQL for windows? Mysql.com says it's 4.1 alpha but the download that reads 4.1 alpha is actually 4.0.12. Is there no version 4.1 available for Windows? Many thanks, rajendra Unless expressly stated to the contrary, the views expressed in this email are not necessarily the views of National Grid Transco plc or any of its subsidiaries or affiliates (Group Companies), and the Group Companies, their directors, officers and employees make no representation and accept no liability for its accuracy or completeness. This e-mail, and any attachments are strictly confidential and intended for the addressee(s) only. The content may also contain legal, professional or other privileged information. If you are not the intended recipient, please notify the sender immediately and then delete the e-mail and any attachments. You should not disclose, copy or take any action in reliance on this transmission. You may report the matter by calling us on + 44(0) 1455 230999 Please ensure you have adequate virus protection before you open or detach any documents from this transmission. The Group Companies do not accept any liability for viruses. An e-mail reply to this address may be subject to monitoring for operational reasons or lawful business practices. -- 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]
Which version do I install?
I am used to using P3 and P4 machines with the x86 download. I just got myself a Dual Xeon 2.60 Ghz machine. Does this still use the x86 download, or is there a better binary to use (ie IA64)? Any other tips for someone new to the Xeon chip family with linux would be nice too. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Which version do I install?
I am used to using P3 and P4 machines with the x86 download. I just got myself a Dual Xeon 2.60 Ghz machine. Does this still use the x86 download, or is there a better binary to use (ie IA64)? Any other tips for someone new to the Xeon chip family with linux would be nice too. -- This is a x86 (32 bit) chip. It may or may not have 'hyperthreading' where it can act as two processors. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Which version do I install?
x86 IA64 is Itanium. Curtis On Thu, 12 Jun 2003, Jason wrote: I am used to using P3 and P4 machines with the x86 download. I just got myself a Dual Xeon 2.60 Ghz machine. Does this still use the x86 download, or is there a better binary to use (ie IA64)? Any other tips for someone new to the Xeon chip family with linux would be nice too. -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Find out what version I am using?
At 10:10 +0900 6/4/03, Nils Valentin wrote: offlist Hi Paul, did I get something wrong or did you actually mean mysql SELECT VERSION(); instead of mysql SHOW VERSION(); ??? You're right, I'm wrong. SELECT VERSION(); (In case I am right, I didnt post as I thought is not so polite to overwrite your statement) I was incorrect, so I'll cc: this back to the list as well. Thanks for pointing it out. Best regards Nils Valentin Tokyo/Japan 2003îN 6åé 2ì åéójì 09:54ÅAPaul DuBois ÇÇÒÇÕèëÇ´ÇÐǵÇ: At 22:52 -0400 5/31/03, Mehrdad Ziaei wrote: That will give you version of mysql client you're running, That seems to have been what the original question was. For version of mysql server, after successful connection to mysql, use status command. mysql status Or telnet to port 3306 of server running mysql C:\telnet 192.168.1.2 3306 you'll see few garbage and mysql version number in there too. Re: that latter suggestion, it's easier to simply issue this query from the mysql client: mysql SHOW VERSION(); Then you don't have to ignore all the garbage characters. :-) Me - Original Message - From: Steven Kreuzer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Mysql [EMAIL PROTECTED] Sent: Saturday, May 31, 2003 10:32 PM Subject: Re: Find out what version I am using? $ mysql --version On Sat, 2003-05-31 at 22:21, Robert Mark Bram wrote: Howdy all! How do I find out what version of mysql I am running from the command line? Is there a type of system select statement I can execute? Rob :) :- : :-} -- Paul DuBois http://www.kitebird.com/ sql, query -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Moving to version 4.1
Robert Mark Bram wrote: Howdy all! I now know that I was running 3.23.55 and that I need 4.1 for Unicode support. I am running Windows XP Pro and in my add or remove programs utility, I see MySQL ODBC 3.51 Driver and MySQL Servers and Clients 3.23.55. If I use Windows add or remove programs utility to remove MySQL Servers and Clients 3.23.55 and then in stall 4.1, how will my MySQL ODBC 3.51 Driver driver know to connect to 4.1 now? Is there anything else I need to do? Thanks for any advice! Rob :) :- :-} From what I gather, you can't use MySQL-4.1 with MyODBC-3.51. You get an error message telling you that the authentication method requested by the server is not available, and to upgrade your client libraries (or something like that). I too am hanging out for MySQL-4.1, but due to this, and a number of other problems (browse the list), I would suggest you wait at least until MySQL-4.1.1 and MyODBC-3.52 until trying it out. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Find out what version I am using?
At 22:52 -0400 5/31/03, Mehrdad Ziaei wrote: That will give you version of mysql client you're running, That seems to have been what the original question was. For version of mysql server, after successful connection to mysql, use status command. mysql status Or telnet to port 3306 of server running mysql C:\telnet 192.168.1.2 3306 you'll see few garbage and mysql version number in there too. Re: that latter suggestion, it's easier to simply issue this query from the mysql client: mysql SHOW VERSION(); Then you don't have to ignore all the garbage characters. :-) Me - Original Message - From: Steven Kreuzer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Mysql [EMAIL PROTECTED] Sent: Saturday, May 31, 2003 10:32 PM Subject: Re: Find out what version I am using? $ mysql --version On Sat, 2003-05-31 at 22:21, Robert Mark Bram wrote: Howdy all! How do I find out what version of mysql I am running from the command line? Is there a type of system select statement I can execute? Rob :) :- :-} -- Paul DuBois http://www.kitebird.com/ sql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Find out what version I am using?
Howdy all! How do I find out what version of mysql I am running from the command line? Is there a type of system select statement I can execute? Rob :) :- :-} -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Find out what version I am using?
$ mysql --version On Sat, 2003-05-31 at 22:21, Robert Mark Bram wrote: Howdy all! How do I find out what version of mysql I am running from the command line? Is there a type of system select statement I can execute? Rob :) :- :-} -- 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]
Re: Find out what version I am using?
That will give you version of mysql client you're running, For version of mysql server, after successful connection to mysql, use status command. mysql status Or telnet to port 3306 of server running mysql C:\telnet 192.168.1.2 3306 you'll see few garbage and mysql version number in there too. Me - Original Message - From: Steven Kreuzer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Mysql [EMAIL PROTECTED] Sent: Saturday, May 31, 2003 10:32 PM Subject: Re: Find out what version I am using? $ mysql --version On Sat, 2003-05-31 at 22:21, Robert Mark Bram wrote: Howdy all! How do I find out what version of mysql I am running from the command line? Is there a type of system select statement I can execute? Rob :) :- :-} -- 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Moving to version 4.1
Howdy all! I now know that I was running 3.23.55 and that I need 4.1 for Unicode support. I am running Windows XP Pro and in my add or remove programs utility, I see MySQL ODBC 3.51 Driver and MySQL Servers and Clients 3.23.55. If I use Windows add or remove programs utility to remove MySQL Servers and Clients 3.23.55 and then in stall 4.1, how will my MySQL ODBC 3.51 Driver driver know to connect to 4.1 now? Is there anything else I need to do? Thanks for any advice! Rob :) :- :-} -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version
I am trying to load a table from a test delimited file. This worked in the previous version. Any advice on how to accomplish this? D. H. Craig, CSM Have a grateful day! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version
I am trying to load a table from a test delimited file. This worked in the previous version. Any advice on how to accomplish this? D. H. Craig, CSM Have a grateful day! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] D. H. Craig, CSM Have a grateful day! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version
Try sqlimport (it is in the bin directory) Martin - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 4:33 PM Subject: MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version I am trying to load a table from a test delimited file. This worked in the previous version. Any advice on how to accomplish this? D. H. Craig, CSM Have a grateful day! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] D. H. Craig, CSM Have a grateful day! -- 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]
Linux kernel diferences between all kernel version -- differences between all soaps ...
TheBS Do you mean the stock kernel branches TheBS (2.0, 2.2, 2.4, 2.6)? yes, as you point I need to enumerate the changes between all Version Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrading from 3.23.5x to 4.0.12 version 4 show no tables in any database
Add your database directory to your my.cnf file. They were possibly compiled with diferent default database locations. [EMAIL PROTECTED] wrote: Description: I have upgraded from 3.23.5x versions to 4.0.12 on Linux Redhat operating system. On 3 machines I only upgraded the RPMs and everything worked. On only Linux Redhat 7.3 server RPM upgrade also worked fine. The problem is that mysql server report no tables in any database. When I run MySQL client show tables; return empty dataset in databases. 3.23.5x work fine. I am reporting this from the server where upgrade was successful. The server where error occured is almost identical it only is Redhat 7.3 instead of 7.2. How-To-Repeat: I have downgraded to 3.23.56 where tables are seen. Every time I upgrade I get the same error. Fix: No idea. Submitter-Id: submitter ID Originator: Organization: MySQL support: none Synopsis: Upgrade problem Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.12 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.40 Distrib 4.0.12, for pc-linux on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.12 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 3 days 15 hours 11 min 33 sec Threads: 1 Questions: 3114 Slow queries: 0 Opens: 151 Flush tables: 1 Open tables: 46 Queries per second avg: 0.010 C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux falcon 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown Architecture: i686 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.2 2.96-112.7.2) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='g++' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Mar 20 09:15 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285884 Mar 6 16:03 /lib/libc-2.2.4.so -rw-r--r--1 root root 27338566 Mar 6 15:05 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 6 15:05 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-embedded-server' '--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Upgrading from 3.23.5x to 4.0.12 version 4 show no tables in any database
That was my first thought too. Shouldn't then MySQL also report nonexisting databases? When I run client mysql database_name it runs only on existing databases. When I write wrong database name it won't run, so it look in the right directory. If the database directory was wrong it shouldn't work on other four computers which have all RedHat Linux installed. Regards Marko -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 4:26 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Upgrading from 3.23.5x to 4.0.12 version 4 show no tables in any database Add your database directory to your my.cnf file. They were possibly compiled with diferent default database locations. [EMAIL PROTECTED] wrote: Description: I have upgraded from 3.23.5x versions to 4.0.12 on Linux Redhat operating system. On 3 machines I only upgraded the RPMs and everything worked. On only Linux Redhat 7.3 server RPM upgrade also worked fine. The problem is that mysql server report no tables in any database. When I run MySQL client show tables; return empty dataset in databases. 3.23.5x work fine. I am reporting this from the server where upgrade was successful. The server where error occured is almost identical it only is Redhat 7.3 instead of 7.2. How-To-Repeat: I have downgraded to 3.23.56 where tables are seen. Every time I upgrade I get the same error. Fix: No idea. Submitter-Id: submitter ID Originator: Organization: MySQL support: none Synopsis: Upgrade problem Severity: serious Priority: medium Category: mysql Class: sw-bug Release:mysql-4.0.12 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.40 Distrib 4.0.12, for pc-linux on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.12 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 3 days 15 hours 11 min 33 sec Threads: 1 Questions: 3114 Slow queries: 0 Opens: 151 Flush tables: 1 Open tables: 46 Queries per second avg: 0.010 C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux falcon 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown Architecture: i686 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.2 2.96-112.7.2) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='g++' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Mar 20 09:15 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285884 Mar 6 16:03 /lib/libc-2.2.4.so -rw-r--r--1 root root 27338566 Mar 6 15:05 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 6 15:05 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-embedded-server' '--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upgrading from 3.23.5x to 4.0.12 version 4 show no tables in any database
Description: I have upgraded from 3.23.5x versions to 4.0.12 on Linux Redhat operating system. On 3 machines I only upgraded the RPMs and everything worked. On only Linux Redhat 7.3 server RPM upgrade also worked fine. The problem is that mysql server report no tables in any database. When I run MySQL client show tables; return empty dataset in databases. 3.23.5x work fine. I am reporting this from the server where upgrade was successful. The server where error occured is almost identical it only is Redhat 7.3 instead of 7.2. How-To-Repeat: I have downgraded to 3.23.56 where tables are seen. Every time I upgrade I get the same error. Fix: No idea. Submitter-Id: submitter ID Originator: Organization: MySQL support: none Synopsis: Upgrade problem Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.12 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.40 Distrib 4.0.12, for pc-linux on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.12 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 3 days 15 hours 11 min 33 sec Threads: 1 Questions: 3114 Slow queries: 0 Opens: 151 Flush tables: 1 Open tables: 46 Queries per second avg: 0.010 C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux falcon 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown Architecture: i686 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.2 2.96-112.7.2) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='g++' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Mar 20 09:15 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285884 Mar 6 16:03 /lib/libc-2.2.4.so -rw-r--r--1 root root 27338566 Mar 6 15:05 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 6 15:05 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-embedded-server' '--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
disabling version number
Hi, is there any configuration directive of disabling the output of the MySQL servers version number? Thanks Florian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: disabling version number
At 16:45 +0100 3/24/03, Florian Effenberger wrote: Hi, is there any configuration directive of disabling the output of the MySQL servers version number? Thanks Florian No, why? -- Paul DuBois http://www.kitebird.com/ sql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: disabling version number
No, why? Part of my security concept, I generally disable all version numbers. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: disabling version number
Florian Effenberger wrote: No, why? Part of my security concept, I generally disable all version numbers. You can patch mysql source and recompile ;) However, if someone has enough access rights on your system to run select version();, showing mysql version number should be the least important of your problems. Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: disabling version number
Authorized != trusted. If you're a hosting provider who allows access to MySQL for customers, your users have access to see the version number by way of simply connecting to their own database. Not that mysql --version from a shell doesn't give you the same thing... but paying for a low end account, finding the version number the host is running and finding an exploit for that version would probably be what the original poster had in mind of preventing. -Original Message- From: Joseph Bueno [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 10:39 AM To: Florian Effenberger Cc: [EMAIL PROTECTED] Subject: Re: disabling version number Florian Effenberger wrote: No, why? Part of my security concept, I generally disable all version numbers. You can patch mysql source and recompile ;) However, if someone has enough access rights on your system to run select version();, showing mysql version number should be the least important of your problems. Regards, Joseph Bueno -- 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]
Re: disabling version number
;-) - Original Message - From: Joseph Bueno [EMAIL PROTECTED] To: Florian Effenberger [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, March 24, 2003 5:39 PM Subject: Re: disabling version number You can patch mysql source and recompile ;) However, if someone has enough access rights on your system to run select version();, showing mysql version number should be the least important of your problems. Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: disabling version number
At 11:02 -0600 3/24/03, Jeremy Tinley wrote: Authorized != trusted. If you're a hosting provider who allows access to MySQL for customers, your users have access to see the version number by way of simply connecting to their own database. Not that mysql --version from a shell doesn't give you the same thing... In fact, it may not give you the same thing. There is no guarantee that any client program comes from the same distribution as the server. but paying for a low end account, finding the version number the host is running and finding an exploit for that version would probably be what the original poster had in mind of preventing. -Original Message- From: Joseph Bueno [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 10:39 AM To: Florian Effenberger Cc: [EMAIL PROTECTED] Subject: Re: disabling version number Florian Effenberger wrote: No, why? Part of my security concept, I generally disable all version numbers. You can patch mysql source and recompile ;) However, if someone has enough access rights on your system to run select version();, showing mysql version number should be the least important of your problems. Regards, Joseph Bueno -- Paul DuBois http://www.kitebird.com/ sql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: disabling version number
I would be wary of disabling version(). That's the kind of annoying thing that sys admins do when they don't understand the life of a developer. Some programs and modules require the version() function to work. Security to that extreme is only useful if you understand that it may cause more downtime than a breakin. If that is understood and the time/money spent is worth it, then that is fine. I can only see this kind of security necessary for medical or classified information. -Original Message- From: Joseph Bueno [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 11:39 AM To: Florian Effenberger Cc: [EMAIL PROTECTED] Subject: Re: disabling version number Florian Effenberger wrote: No, why? Part of my security concept, I generally disable all version numbers. You can patch mysql source and recompile ;) However, if someone has enough access rights on your system to run select version();, showing mysql version number should be the least important of your problems. Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: disabling version number
On 24 Mar 2003 at 11:02, Jeremy Tinley wrote: but paying for a low end account, finding the version number the host is running and finding an exploit for that version would probably be what the original poster had in mind of preventing. Suppose you prevented customers from seeing the version number. What would prevent them from just trying whatever exploits they want without knowing the version? If you have a vulnerability, you have a vulnerability, whether the version number is visible or not. Now hiding the version might make some sense if there were a way to automatically scan a range of IP addresses to look for MySQL servers of a particular version. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: disabling version number
At 13:35 -0500 3/24/03, Adam Nelson wrote: I would be wary of disabling version(). That's the kind of annoying thing that sys admins do when they don't understand the life of a developer. Some programs and modules require the version() function to work. Security to that extreme is only useful if you understand that it may cause more downtime than a breakin. If that is understood and the time/money spent is worth it, then that is fine. I can only see this kind of security necessary for medical or classified information. I agree that it's a bad idea to disable VERSION(). There are many features that are version-specific, and an application can tell whether or not they are available by checking the version number. -Original Message- From: Joseph Bueno [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 11:39 AM To: Florian Effenberger Cc: [EMAIL PROTECTED] Subject: Re: disabling version number Florian Effenberger wrote: No, why? Part of my security concept, I generally disable all version numbers. You can patch mysql source and recompile ;) However, if someone has enough access rights on your system to run select version();, showing mysql version number should be the least important of your problems. Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin processlist = weird in version 4.0.12
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 18 Mar 2003, Andrew Braithwaite wrote: Anyone know why mysqladmin processlist is not showing the host that is connected, but instead is showing the following in v4.0.12: truncated excerpt +-+-+--+--+ | Id | User| Host | db | Command +-+-+--+--+ | 530 | fcgi| 146.101.143.72:48753 | multimap | Sleep | 536 | fcgi| 146.101.143.72:48139 | multimap | Sleep | 545 | fcgi| 146.101.143.72:45618 | multimap | Sleep | 556 | fcgi| 146.101.143.72:49311 | multimap | Sleep | 570 | fcgi| 146.101.143.72:40745 | multimap | Sleep It used to show: +-+-+---+--+ | Id | User| Host | db | Command +-+-+---+--+ | 530 | fcgi| host1 | multimap | Sleep | 536 | fcgi| host2 | multimap | Sleep | 545 | fcgi| host3 | multimap | Sleep | 556 | fcgi| host2 | multimap | Sleep | 570 | fcgi| host3 | multimap | Sleep Any ideas anyone? It seems to be a bug - I've now entered it into our bug database: http://bugs.mysql.com/?id=164 Thanks for spotting this! It will be fixed for the next release. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE+eHtWSVDhKrJykfIRArHvAJ9WmjFwoNDOoLI6/Qi2CSOhUYniGgCfTzNI C8D5o3fmmpnjMMR13SxZ4HU= =gn2i -END PGP SIGNATURE- - 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
mysqladmin processlist = weird in version 4.0.12
Hi all, Anyone know why mysqladmin processlist is not showing the host that is connected, but instead is showing the following in v4.0.12: truncated excerpt +-+-+--+--+ | Id | User| Host | db | Command +-+-+--+--+ | 530 | fcgi| 146.101.143.72:48753 | multimap | Sleep | 536 | fcgi| 146.101.143.72:48139 | multimap | Sleep | 545 | fcgi| 146.101.143.72:45618 | multimap | Sleep | 556 | fcgi| 146.101.143.72:49311 | multimap | Sleep | 570 | fcgi| 146.101.143.72:40745 | multimap | Sleep It used to show: +-+-+---+--+ | Id | User| Host | db | Command +-+-+---+--+ | 530 | fcgi| host1 | multimap | Sleep | 536 | fcgi| host2 | multimap | Sleep | 545 | fcgi| host3 | multimap | Sleep | 556 | fcgi| host2 | multimap | Sleep | 570 | fcgi| host3 | multimap | Sleep Any ideas anyone? Cheers, Andrew mysql,query - 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: mysqladmin processlist = weird in version 4.0.12
The change log for 4.012 mentions (Lenz Grimmer just posted this a couple of messages ago): Functionality added or changed: * `SHOW PROCESSLIST' will now include the client TCP port after the hostname to make it easier to know from which client the request originated. I guess whenever the hostname lookup fails you just see the IP address. HTH/h On 3/18/03 2:36 PM, Andrew Braithwaite [EMAIL PROTECTED] wrote: Hi all, Anyone know why mysqladmin processlist is not showing the host that is connected, but instead is showing the following in v4.0.12: truncated excerpt +-+-+--+--+ | Id | User| Host | db | Command +-+-+--+--+ | 530 | fcgi| 146.101.143.72:48753 | multimap | Sleep | 536 | fcgi| 146.101.143.72:48139 | multimap | Sleep | 545 | fcgi| 146.101.143.72:45618 | multimap | Sleep | 556 | fcgi| 146.101.143.72:49311 | multimap | Sleep | 570 | fcgi| 146.101.143.72:40745 | multimap | Sleep It used to show: +-+-+---+--+ | Id | User| Host | db | Command +-+-+---+--+ | 530 | fcgi| host1 | multimap | Sleep | 536 | fcgi| host2 | multimap | Sleep | 545 | fcgi| host3 | multimap | Sleep | 556 | fcgi| host2 | multimap | Sleep | 570 | fcgi| host3 | multimap | Sleep Any ideas anyone? Cheers, Andrew mysql,query - 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: mysqladmin processlist = weird in version 4.0.12
It says in the change log that it added the port to make it easier to see where the connection is coming from. 146.101.143.72:48753 gives you a lot more information than host1 From the release announcement -- * `SHOW PROCESSLIST' will now include the client TCP port after the hostname to make it easier to know from which client the request originated. -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:36 PM To: [EMAIL PROTECTED] Subject: mysqladmin processlist = weird in version 4.0.12 Hi all, Anyone know why mysqladmin processlist is not showing the host that is connected, but instead is showing the following in v4.0.12: truncated excerpt +-+-+--+--+ | Id | User| Host | db | Command +-+-+--+--+ | 530 | fcgi| 146.101.143.72:48753 | multimap | Sleep | 536 | fcgi| 146.101.143.72:48139 | multimap | Sleep | 545 | fcgi| 146.101.143.72:45618 | multimap | Sleep | 556 | fcgi| 146.101.143.72:49311 | multimap | Sleep | 570 | fcgi| 146.101.143.72:40745 | multimap | Sleep It used to show: +-+-+---+--+ | Id | User| Host | db | Command +-+-+---+--+ | 530 | fcgi| host1 | multimap | Sleep | 536 | fcgi| host2 | multimap | Sleep | 545 | fcgi| host3 | multimap | Sleep | 556 | fcgi| host2 | multimap | Sleep | 570 | fcgi| host3 | multimap | Sleep Any ideas anyone? Cheers, Andrew mysql,query - 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: mysqladmin processlist = weird in version 4.0.12
Hi, I do understand what you're saying and I did read the 4.0.12 changelog and appreciate the addition of the TCP port in that display, but all the hostnames in the processlist are displaying as the localhost of the mysql server that they are connecting to instead of the hostnames of the server that is connecting. The /etc/hosts file is fine and is the same as it was before Bug or feature? Cheers, Andrew -Original Message- From: R. Hannes Niedner [mailto:[EMAIL PROTECTED] Sent: Tuesday 18 March 2003 22:48 To: Andrew Braithwaite; MySQL Mailinglist Subject: Re: mysqladmin processlist = weird in version 4.0.12 The change log for 4.012 mentions (Lenz Grimmer just posted this a couple of messages ago): Functionality added or changed: * `SHOW PROCESSLIST' will now include the client TCP port after the hostname to make it easier to know from which client the request originated. I guess whenever the hostname lookup fails you just see the IP address. HTH/h On 3/18/03 2:36 PM, Andrew Braithwaite [EMAIL PROTECTED] wrote: Hi all, Anyone know why mysqladmin processlist is not showing the host that is connected, but instead is showing the following in v4.0.12: truncated excerpt +-+-+--+--+ | Id | User| Host | db | Command +-+-+--+--+ | 530 | fcgi| 146.101.143.72:48753 | multimap | Sleep | 536 | fcgi| 146.101.143.72:48139 | multimap | Sleep | 545 | fcgi| 146.101.143.72:45618 | multimap | Sleep | 556 | fcgi| 146.101.143.72:49311 | multimap | Sleep | 570 | fcgi| 146.101.143.72:40745 | multimap | Sleep It used to show: +-+-+---+--+ | Id | User| Host | db | Command +-+-+---+--+ | 530 | fcgi| host1 | multimap | Sleep | 536 | fcgi| host2 | multimap | Sleep | 545 | fcgi| host3 | multimap | Sleep | 556 | fcgi| host2 | multimap | Sleep | 570 | fcgi| host3 | multimap | Sleep Any ideas anyone? Cheers, Andrew mysql,query - 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: mysqladmin processlist = weird in version 4.0.12
Anyone else notice this, or is it just me? Andrew -Original Message- From: Andrew Braithwaite Sent: Tuesday 18 March 2003 23:05 To: 'R. Hannes Niedner'; MySQL Mailinglist Subject: RE: mysqladmin processlist = weird in version 4.0.12 Hi, I do understand what you're saying and I did read the 4.0.12 changelog and appreciate the addition of the TCP port in that display, but all the hostnames in the processlist are displaying as the localhost of the mysql server that they are connecting to instead of the hostnames of the server that is connecting. The /etc/hosts file is fine and is the same as it was before Bug or feature? Cheers, Andrew -Original Message- From: R. Hannes Niedner [mailto:[EMAIL PROTECTED] Sent: Tuesday 18 March 2003 22:48 To: Andrew Braithwaite; MySQL Mailinglist Subject: Re: mysqladmin processlist = weird in version 4.0.12 The change log for 4.012 mentions (Lenz Grimmer just posted this a couple of messages ago): Functionality added or changed: * `SHOW PROCESSLIST' will now include the client TCP port after the hostname to make it easier to know from which client the request originated. I guess whenever the hostname lookup fails you just see the IP address. HTH/h On 3/18/03 2:36 PM, Andrew Braithwaite [EMAIL PROTECTED] wrote: Hi all, Anyone know why mysqladmin processlist is not showing the host that is connected, but instead is showing the following in v4.0.12: truncated excerpt +-+-+--+--+ | Id | User| Host | db | Command +-+-+--+--+ | 530 | fcgi| 146.101.143.72:48753 | multimap | Sleep | 536 | fcgi| 146.101.143.72:48139 | multimap | Sleep | 545 | fcgi| 146.101.143.72:45618 | multimap | Sleep | 556 | fcgi| 146.101.143.72:49311 | multimap | Sleep | 570 | fcgi| 146.101.143.72:40745 | multimap | Sleep It used to show: +-+-+---+--+ | Id | User| Host | db | Command +-+-+---+--+ | 530 | fcgi| host1 | multimap | Sleep | 536 | fcgi| host2 | multimap | Sleep | 545 | fcgi| host3 | multimap | Sleep | 556 | fcgi| host2 | multimap | Sleep | 570 | fcgi| host3 | multimap | Sleep Any ideas anyone? Cheers, Andrew mysql,query - 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
Problems with Berkeley DB support in version 3.23.55
Hallo, we have downloaded the new 3.23.55 mysql DB from you as Source Download Tarball (tar.gz) and want to build them in our environment for tests under SUN OS. We have tared the downloaded version in our Scource Directory environment. (for example directory/mysql/src/mysql-3.23.55) After that we want configure the downloaded version from our bulid and configure environment. (for example directory/mysql/obj/mysql-3.23.55). We take the ./configure from the obj-Directory: directory/mysql/src/mysql-3.23.55/configure --with-berkeley-db to have berkeley DB support. After we take the make command we become some errors at the make output. (Sorry, but I have cancelled the make error output and so I can't write the error output to you.) To fix the problem I look in the config.status file, and there I found entries for the bdb variables: s,@bdb_includes@, s,@bdb_libs@, s,@bdb_libs_with_path@, In the config.status file I found only entries for the src-path: s,@bdb_includes@,-I,directory/mysql/src/mysql-3.23.55/bdb/build_unix,;t t s,@bdb_libs@,-L,directory/mysql/src/mysql-3.23.55/bdb/build_unix,;t t s,@bdb_libs_with_path@,directory/mysql/src/mysql-3.23.55/bdb/build_unix/libdb.a,;t t And so I missed entries for the obj path. After that I take in the config.status file the new entries for the obj-path: s,@bdb_includes@ -Idirectory/mysql/obj/mysql-3.23.55/bdb/build_unix s,@bdb_libs@ -Ldirectory/mysql/obj/mysql-3.23.55/bdb/build_unix s,@bdb_libs_with_path@ directory/mysql/obj/mysql-3.23.55/bdb/build_unix/libdb.a Then I make a new ./configure call with the option --enable-maintainer-mode and after taken make the make output goes without errors an so I can fix the problem. Greetings, Carsten Thoene Carsten Thoene eMail: [EMAIL PROTECTED] Technische Fakultaet Universitaet Bielefeld D-33594 Bielefeld - 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
Problems with Innobase DB support in version 3.23.55
Hallo, we have downloaded the new 3.23.55 mysql DB from you as Source Download Tarball (tar.gz) and want to build them in our environment for tests under SUN OS. We have tared the downloaded version in our Scource Directory environment. (for example directory/mysql/src/mysql-3.23.55) After that we want configure the downloaded version from our bulid and configure environment. (for example directory/mysql/obj/mysql-3.23.55). We take the ./configure from the obj-Directory-Path: directory/mysql/src/mysql-3.23.55/configure --with-innodb (to have Innobase DB support). After we take the make command we become some errors at the make output. For example a little Extract from the make output: directory/mysql/src/mysql-3.23.55/innobase/os/os0proc.c:10:21: os0proc.h: No such file or directory directory/mysql/src/mysql/mysql-3.23.55/innobase/os/os0proc.c:19:20: ut0mem.h: No such file or directory directory/mysql/src/mysql-3.23.55/innobase/os/os0proc.c:28: parse error before n directory/mysql/src/mysql-3.23.55/innobase/os/os0proc.c: In function `os_mem_alloc_nocache': directory/mysql/src/mysql/mysql-3.23.55/innobase/os/os0proc.c:39: `n' undeclared (first use in this function) Then I begin to look in the mysql scources to fix the problem. (for example directory/mysql/src/mysql-3.23.55/innobase) And in the file for example: directory/mysql/src/mysql-3.23.55/innobase/usr/Makefile.in here I think I found the mistake: (extract from the Makefile.in): $(srcdir)/Makefile.in: @MAINTAINER_MODE_TRUE@ Makefile.am $(srcdir)/../include/Makefile.i $(top_srcdir)/configure.in $(ACLOCAL_M4) The same error I found under: directory/mysql/src/mysql-3.23.55/innobase/os/Makefile.in I looked to the whole Scource Code and there I can't find a directory with the name Makefile.i And so for our test's with the 3.23.55 mysql we decide to built the software only in the scource tree directory, and not in the obj tree directory, to expect the mysql version can build there with Innobase and Berkeley DB support without errors. Greetings, Carstn Thoene -- Carsten Thoene eMail: [EMAIL PROTECTED] Technische Fakultaet Universitaet Bielefeld D-33594 Bielefeld - 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
mysqlimport : not allowed with this MySQL version
I have installed MySQL version Release: mysql-3.23.38 (as found in the mysqlbug.txt). When I use mysqlimport, I get the following error code ERROR 1148 : the used command is not allowed with this MySQL version. I get the same message whenever I use LOAD DATA. WHich version should I install ? Gert Cuppens Ranst - Antwerp (Belgium) _ Hotmail: je gratis e-mail ! http://www.msn.be/hotmail - 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
The Solaris 2.7 version of the binaries
Hi All, is there a reason why there are no MySQL binaries for Solaris 2.7 any more. I have been downloading the binaries before for Solaris 2.7 from the Web Site and now trying to compile the source doesn't work. Is it possible to put a link on the download page to a Solaris 2.7 binaries if you have them? Thanks, Nesh Nenad Mijailovic - 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 Solaris 2.7 version of the binaries
- Original Message - From: Nesh Nenad Mijailovic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 5:23 PM Subject: The Solaris 2.7 version of the binaries Hi All, is there a reason why there are no MySQL binaries for Solaris 2.7 any more. I have been downloading the binaries before for Solaris 2.7 from the Web Site and now trying to compile the source doesn't work. Is it possible to put a link on the download page to a Solaris 2.7 binaries if you have them? Thanks, Nesh Nenad Mijailovic The crew noted a while back that their Solaris 7 machine died and has yet to be replaced. Until then, what kind of problems are you having compiling on Solaris 7? Alternately, check out SunFreeware http://sunfreeware.com as Steve has MySQL 3.23.53 ready to go for 7/SPARC. -- Alan W. Rateliff, II: RATELIFF.NET Independent Technology Consultant :[EMAIL PROTECTED] (Office) 850/350-0260: (Mobile) 850/559-0100 - [System Administration][IT Consulting][Computer Sales/Repair] - 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 Solaris 2.7 version of the binaries
Thanks for the reply, if I can get the compile to work on my Solaris 2.7 I am more than happy for you to send me the make options you want used and I will send you the binaries once compiled. Now back to my problem, I am using gcc 2.95.3 which could be a problem as the compile process stops at one of the C++ files - could be I need a newer version of the gcc. This is MySQL version 4.0.9 Gamma by the way. Problem is: make all-recursive Making all in include make all-am Making all in Docs make all-am Making all in readline Making all in pstack Making all in aout Making all in libmysql_r Making all in libmysql Making all in client Making all in strings Making all in dbug Making all in mysys Making all in extra Making all in regex Making all in isam Making all in merge Making all in myisam Making all in myisammrg Making all in heap Making all in vio Making all in sql make all-recursive Making all in share source='sql_lex.cc' object='sql_lex.o' libtool=no \ depfile='.deps/sql_lex.Po' tmpdepfile='.deps/sql_lex.TPo' \ depmode=gcc /bin/bash ../depcomp \ g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I./../regex -I. -I../include -I. -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/export/home/nesh/mysql-4.0.9-gamma/include -DHAVE_RWLOCK_T -c -o sql_lex.o `test -f sql_lex.cc || echo './'`sql_lex.cc sql_lex.cc: In function `void lex_init()': sql_lex.cc:85: `symbols' undeclared (first use this function) sql_lex.cc:85: (Each undeclared identifier is reported only once sql_lex.cc:85: for each function it appears in.) sql_lex.cc:87: `sql_functions' undeclared (first use this function) sql_lex.cc: In function `int find_keyword(LEX *, unsigned int, bool)': sql_lex.cc:171: implicit declaration of function `int get_hash_symbol(...)' sql_lex.cc:171: initialization to `SYMBOL *' from `int' lacks a cast *** Error code 1 make: Fatal error: Command failed for target `sql_lex.o' Current working directory /export/home/nesh/mysql-4.0.9-gamma/sql *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /export/home/nesh/mysql-4.0.9-gamma/sql *** Error code 1 make: Fatal error: Command failed for target `all' Current working directory /export/home/nesh/mysql-4.0.9-gamma/sql *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /export/home/nesh/mysql-4.0.9-gamma *** Error code 1 make: Fatal error: Command failed for target `all' gcc --version 2.95.3 Thanks, Nesh _ On Wed, 2003-02-19 at 09:39, Alan W. Rateliff, II wrote: - Original Message - From: Nesh Nenad Mijailovic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 5:23 PM Subject: The Solaris 2.7 version of the binaries Hi All, is there a reason why there are no MySQL binaries for Solaris 2.7 any more. I have been downloading the binaries before for Solaris 2.7 from the Web Site and now trying to compile the source doesn't work. Is it possible to put a link on the download page to a Solaris 2.7 binaries if you have them? Thanks, Nesh Nenad Mijailovic The crew noted a while back that their Solaris 7 machine died and has yet to be replaced. Until then, what kind of problems are you having compiling on Solaris 7? Alternately, check out SunFreeware http://sunfreeware.com as Steve has MySQL 3.23.53 ready to go for 7/SPARC. -- Alan W. Rateliff, II: RATELIFF.NET Independent Technology Consultant :[EMAIL PROTECTED] (Office) 850/350-0260: (Mobile) 850/559-0100 - [System Administration][IT Consulting][Computer Sales/Repair] - 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 and LOAD DATA LOCAL INFILE : The used command is not allowed with this MySQL version
Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \ + FIC_DB + \ REPLACE INTO TABLE news; It runs well with mysql-3.23.45 but not with mysql-3.23.55 The error message is : java.sql.SQLException: General error: The used command is not allowed with this MySQL version at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550) at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815) at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169) at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78) ... I compiled mysql-3.23.55 with the option --enable-local-infile and runs it with the argument! --local-i nfile=1. If I use the mysql client, it runs but not inside my Java servlet. Could you help me to find a solution ? Thank you Cédric. - 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 and LOAD DATA LOCAL INFILE : The used command is notallowed with this MySQL version
Hi all, please let me now if there is a solution to this. I am facing the same problem. Anis [EMAIL PROTECTED] [EMAIL PROTECTED] Wednesday, February 12, 2003 3:48:16 PM Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \ + FIC_DB + \ REPLACE INTO TABLE news; It runs well with mysql-3.23.45 but not with mysql-3.23.55 The error message is : java.sql.SQLException: General error: The used command is not allowed with this MySQL version at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550) at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815) at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169) at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78) ... I compiled mysql-3.23.55 with the option --enable-local-infile and runs it with the argument! --local-i nfile=1. If I use the mysql client, it runs but not inside my Java servlet. Could you help me to find a solution ? Thank you Cédric. - 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: JDBC and LOAD DATA LOCAL INFILE : The used command is not allowedwith this MySQL version
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed S K Anis wrote: Hi all, please let me now if there is a solution to this. I am facing the same problem. Anis [EMAIL PROTECTED] [EMAIL PROTECTED] Wednesday, February 12, 2003 3:48:16 PM Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \ + FIC_DB + \ REPLACE INTO TABLE news; It runs well with mysql-3.23.45 but not with mysql-3.23.55 The error message is : java.sql.SQLException: General error: The used command is not allowed with this MySQL version at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550) at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815) at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169) at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78) ... I compiled mysql-3.23.55 with the option --enable-local-infile and runs it with the argument! --local-i nfile=1. If I use the mysql client, it runs but not inside my Java servlet. Could you help me to find a solution ? You have to use the 3.0 Connector/J drivers for 'LOAD DATA LOCAL INFILE'. See http://www.mysql.com/products/connector-j/ The support for 'LOAD DATA LOCAL INFILE' appeared in 3.0, the latest version. It was never in MM.MySQL (which is what you're using, I assume something like 2.0.14), so I don't know how it was _ever_ working for you :) -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+Sk2MtvXNTca6JD8RAkjDAKDHfJR6jCsHRrGq3yxK+LTCPzRbWQCfc0Ld RUnZYHgbelXstPKvO2qOj8U= =IvB1 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[ANN] Beta version of Lasso Studio 6 for Dreamweaver MX
Greetings: If you use Dreamweaver MX and are looking for a very easy way to Web-enable your MySQL databases, please check out today's announcement of the immediate availability of the first beta release of Lasso Studio 6 for Dreamweaver MX. Details at: http://www.blueworld.com/blueworld/news/02.12.03-LS6DW-Beta.html Enjoy Bill -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve powerful data-driven Web sites with Lasso Studio and Lasso Professional. - 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: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)
Hi! On Feb 05, Tue Tønning wrote: Hey, I have discovered a strange error in the mysql versions mentioned in subj. Example. A table with 10 entries ...i want to draw 3 randomly = select fieldName from tableName order by RAND() limit 3 this have worked for the last year or so.but after upgrading our redhat 7.2 with mysql version 3.23.54 it stopped to work. It always chooses the same 3 entires. try simply mysql -BNe 'select rand(), rand(), rand(), rand()' mysql -BNe 'select rand(), rand(), rand(), rand()' mysql -BNe 'select rand(), rand(), rand(), rand()' to see the problem. RAND() initialization for new connection isn't very random, so first few rand() values differ only slightly. It was fixed in 4.0. I will backport the fix to 3.23. You can either upgrade to MySQL 4.0, or wait till next 3.23 release, or use a simple workaround: run do benchmark(10,rand()); just after establishing connection - before first SELECT. Ohh, yeah - we code in PHP..and i have talked today with 3 other webdevelopment companies that have been struggeling with the same error after upgrading. Easy - no need to struggling, just submit a bugreport - the bug will be fixed at once :) Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)
HINT: I have used PERL to generate random numbers and then do a SELECT on the auto_increment field in the mysql table, thus generating random picks from my tables; I'll be glad to bet informed of better ways around, though :) Thanks Aman Raheja AGF Inc. - Original Message - From: Tue Tønning [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 1:38 PM Subject: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux) Hey, I have discovered a strange error in the mysql versions mentioned in subj. Example. A table with 10 entries ...i want to draw 3 randomly = select fieldName from tableName order by RAND() limit 3 this have worked for the last year or so.but after upgrading our redhat 7.2 with mysql version 3.23.54 it stopped to work. It always chooses the same 3 entires. using a Seed doesnt make it perfect either (i know that the manual says that RAND() isnt perfect - but now it doesnt work at all). A quick search on google says me that im not the only one having the problem. I can also see on some Danish messageboards that other have the same problems with the new version. So my question is .What to do ? I cant imagine that you have removed the functionality of RAND from mysql again ? i know its only been in there since early ~3.23 I work professionally as a webdevolper (CEO of a firm) and we need to find a solution to this problem badly. I hope you can guide me to a solution. Cause i would hate to change all the sql calls in the projects we have coded the last 1½ year and it would be nice to know if we would be able to use RAND() in the future. Ohh, yeah - we code in PHP..and i have talked today with 3 other webdevelopment companies that have been struggeling with the same error after upgrading. Med venlig hilsen / Best regards Tue Tønning AT-Orbital I/S Helsingforsgade 27, 1 DK-8200 Aarhus N Denmark Phone +45 8942 5860 Web www.atorbital.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
LOG ERROR in windows with 4.0.10 version
The assertion in the manual referred to windows I think is not correct. In my XP version I found the log file as in Unix ie \mysql\data\hostname.err instead \mysql\data\mysql.err as in previous version. Note in my.ini file there is nothing about log-error option . Which is the correct interpretation ? Beginning with MySQL 4.0.10 you can specify where mysqld stores the error log file with the option --log-error[=filename]. If no file name is given mysqld will use mysql-data-dir/'hostname'.err on Unix and `\mysql\data\mysql.err' on windows - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 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
RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)
Hey, I have discovered a strange error in the mysql versions mentioned in subj. Example. A table with 10 entries ...i want to draw 3 randomly = select fieldName from tableName order by RAND() limit 3 this have worked for the last year or so.but after upgrading our redhat 7.2 with mysql version 3.23.54 it stopped to work. It always chooses the same 3 entires. using a Seed doesnt make it perfect either (i know that the manual says that RAND() isnt perfect - but now it doesnt work at all). A quick search on google says me that im not the only one having the problem. I can also see on some Danish messageboards that other have the same problems with the new version. So my question is .What to do ? I cant imagine that you have removed the functionality of RAND from mysql again ? i know its only been in there since early ~3.23 I work professionally as a webdevolper (CEO of a firm) and we need to find a solution to this problem badly. I hope you can guide me to a solution. Cause i would hate to change all the sql calls in the projects we have coded the last 1½ year and it would be nice to know if we would be able to use RAND() in the future. Ohh, yeah - we code in PHP..and i have talked today with 3 other webdevelopment companies that have been struggeling with the same error after upgrading. Med venlig hilsen / Best regards Tue Tønning AT-Orbital I/S Helsingforsgade 27, 1 DK-8200 Aarhus N Denmark Phone +45 8942 5860 Web www.atorbital.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
Problem with mysqlhotcopy version 1.17 when using --record_log_pos
Description: With mysqlhotcopy version 1.15 (from MySQL-3.23.49-1) I used to do like this: mysqlhotcopy --user=root --password=foo -q --allowold --record_log_pos backup.log_pos db1 db2 backup $TMPDIR After upgrading to MySQL-3.23.55-1 and thus mysqlhotcopy version 1.17 the same command gave this error: DBD::mysql::db do failed: Not unique table/alias: 'log_pos' at /usr/bin/mysqlhotcopy line 437. The problem is that line 311 now adds backticks around database and table names: my @hc_tables = map { `$db`.`$_` } @dbh_tables; This is not taken into account at line 422 where $table comes directly from $opt{checkpoint} or $opt{record_log_pos}: unless ( $hc_locks =~ s/$table\s+READ/$table WRITE/ ); The resulting lock-command becomes: LOCK TABLES `db1`.`table1` READ, `db2`.`table1` READ, `backup`.`log_pos` READ, backup.log_pos WRITE How-To-Repeat: Try issuing the command mysqlhotcopy --user=root --password=foo -q --allowold --record_log_pos backup.log_pos db1 db2 backup $TMPDIR where the database that the log_pos is recorded in is also in the list of databases to backup. Fix: Fix documentation so it doesn't say The name of the log-pos table should be supplied in database.table format. but ... supplied in \`database\`.\`table\` format. Or better, add this fix (sorry about my Perl - I know it is bad): --- mysqlhotcopy.orig Wed Jan 29 14:00:00 2003 +++ mysqlhotcopyWed Jan 29 14:00:14 2003 @@ -113,6 +113,14 @@ dryrun|n, ) or usage(Invalid option); +# Make sure that $opt{record_log_pos} is of form `db`.`table` +if (defined($opt{record_log_pos})) +{ +$opt{record_log_pos} =~ tr/\`//d; +$opt{record_log_pos} =~ s/\./\`\.\`/; +$opt{record_log_pos} = \`$opt{record_log_pos}\`; +} + # @db_desc # == # a list of hash-refs containing: The same should probably be done for $opt{checkpoint}. Submitter-Id:[EMAIL PROTECTED] Originator: Soeren Thing Andersen Organization: TDC MySQL support: none Synopsis:Backticks not added to $opt{record_log_pos} Severity:non-critical Priority:medium Category:mysql Class: sw-bug Release: mysql-3.23.55 (Official MySQL RPM) Environment: System: Linux alarmnetgw2.vpn.alarm-net.dk 2.4.9-31 #1 Tue Feb 26 07:11:02 EST 2002 i686 unknown Architecture: i686 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-85) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Oct 10 14:51 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285884 Sep 9 18:10 /lib/libc-2.2.4.so -rw-r--r--1 root root 27336078 Sep 9 17:48 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 9 17:48 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--without-innodb' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' 'CXX=gcc' - 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 (server crashes) with Version 3.23.54 on remoteconnections
MySQL support: none Synopsis: Server crashes on remote connection Severity: serious Priority: high Category: mysql Class: Bug / Local Problem? Release: mysql-3.23.54 (Source distribution) mysql-server-3.23.54a-4 mysql-3.23.54a-4 mysql-devel-3.23.54a-4 (used rpms from updates.redhatcom) RedHat 8.0, kernel 2.4.18-19.8.0 i686 i686 i386 GNU/Linux Architecture: i686 Pentium 4, 1.9 Ghz 512 Mb memory glibc-2.2.93-5 A second machine also has the same symptoms. It is similar, except the disk drive setup is completely different. SYMPTOM In the log (below) any line beginning Tcp port: 3306 is an attempt to connect remotely (using a GUI client, or using command line mysql, or using a perl program) that fails. That's the only evidence of the attempt. (Maybe a different logging option would give more info? We used --debug=d,general,query as suggested in manual.) Queries from localhost all seem to work. For example, with perl, Apache log (with specifics edited out) says: DBI-connect(databasename:hostname.domainname.net:3306) failed: Lost connection to MySQL server during query at /path/cat_show.pl line 22. And... and other open connections (localhost) were lost at the same time and had to reconnect on next query. Using mysql at command line gives basically the same complaint. The Uptime shows that mysqld has restarted mysql in each case. Connection attempts are as user martin. User table is: +---++--+-+ | Host | User | Password | All_priv| +---++--+-+ | localhost | root | | Y | | localhost | martin | | Y | | % | martin | | Y | +---++--+-+ (All users have all privileges and a password.) ipTables is disabled. I did a shutdown and ran ISAMCHK on MYI files as suggested in manual. Any feedback would be appreciated. Martin Abell SpeedSpan = LOG tail -50 sp31.log Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument 030122 22:51:47 1 Connect root@localhost on 1 Statistics 1 Quit /usr/libexec/mysqld, Version: 3.23.54-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument 030122 23:05:12 1 Connect root@localhost on 1 Query SHOW VARIABLES LIKE 'pid_file' 1 Shutdown /usr/libexec/mysqld, Version: 3.23.54-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument 030122 23:22:54 1 Connect Access denied for user: 'root@localhost' (Using password: YES) 030122 23:23:21 2 Connect root@localhost on 030123 9:15:57 3 Connect root@localhost on 030123 9:16:02 3 Init DB mysql 3 Query show databases 3 Query show tables 3 Field List columns_priv 3 Field List db 3 Field List func 3 Field List host 3 Field List tables_priv 3 Field List user 030123 9:16:12 3 Query select * from user 030123 9:17:23 4 Connect root@localhost on 4 Statistics 4 Quit 030123 9:17:51 5 Connect root@localhost on 5 Statistics 5 Quit /usr/libexec/mysqld, Version: 3.23.54-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument 030123 9:17:59 1 Connect root@localhost on 1 Statistics 1 Quit 030123 9:18:46 2 Connect root@localhost on mysql 2 Query show databases 2 Query show tables 2 Field List columns_priv 2 Field List db 2 Field List func 2 Field List host 2 Field List tables_priv 2 Field List user 2 Query show variables 030123 9:27:15 2 Query show variables = VARIABLES mysql show variables \G *** 1. row *** Variable_name: back_log Value: 50 *** 2. row *** Variable_name: basedir Value: /usr/ *** 3. row *** Variable_name: bdb_cache_size Value: 8388600 *** 4. row
Re: Problem (server crashes) with Version 3.23.54 on remoteconnections
Martin, Larry, Synopsis: Server crashes on remote connection I'm not a Unix guru but I experienced the same sympton on SuSE Linux 8.0/8.1, and I heard of people reporting the same of Red Hat Linux 7.x/8.x. MySQL runs stable, you can connect from localhost via socket and tcp/ip, but as soon as you try a connect from some other machine, mysqld segfaults. In all cases I heard of, the problem was some glibc version that caused all the trouble. You say you use glibc-2.2.93-5 This version # looks a bit strange to me, well ... In a SuSE Linux Newsgroup I heard that everything's okay if you use = 2.2.5-151. We use glibc-2.2.5-164 on SuSE Linux 8.1, and with our 3.23.54, we've had no problems at all. HTH, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Martin Abell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Larry Airaghi [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 6:10 PM Subject: Problem (server crashes) with Version 3.23.54 on remoteconnections MySQL support: none Synopsis: Server crashes on remote connection Severity: serious Priority: high Category: mysql Class: Bug / Local Problem? Release: mysql-3.23.54 (Source distribution) mysql-server-3.23.54a-4 mysql-3.23.54a-4 mysql-devel-3.23.54a-4 (used rpms from updates.redhatcom) RedHat 8.0, kernel 2.4.18-19.8.0 i686 i686 i386 GNU/Linux Architecture: i686 Pentium 4, 1.9 Ghz 512 Mb memory glibc-2.2.93-5 A second machine also has the same symptoms. It is similar, except the disk drive setup is completely different. SYMPTOM In the log (below) any line beginning Tcp port: 3306 is an attempt to connect remotely (using a GUI client, or using command line mysql, or using a perl program) that fails. That's the only evidence of the attempt. (Maybe a different logging option would give more info? We used --debug=d,general,query as suggested in manual.) Queries from localhost all seem to work. For example, with perl, Apache log (with specifics edited out) says: DBI-connect(databasename:hostname.domainname.net:3306) failed: Lost connection to MySQL server during query at /path/cat_show.pl line 22. And... and other open connections (localhost) were lost at the same time and had to reconnect on next query. Using mysql at command line gives basically the same complaint. The Uptime shows that mysqld has restarted mysql in each case. Connection attempts are as user martin. User table is: +---++--+-+ | Host | User | Password | All_priv| +---++--+-+ | localhost | root | | Y | | localhost | martin | | Y | | % | martin | | Y | +---++--+-+ (All users have all privileges and a password.) ipTables is disabled. I did a shutdown and ran ISAMCHK on MYI files as suggested in manual. Any feedback would be appreciated. Martin Abell SpeedSpan = LOG tail -50 sp31.log Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument 030122 22:51:47 1 Connect root@localhost on 1 Statistics 1 Quit /usr/libexec/mysqld, Version: 3.23.54-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument 030122 23:05:12 1 Connect root@localhost on 1 Query SHOW VARIABLES LIKE 'pid_file' 1 Shutdown /usr/libexec/mysqld, Version: 3.23.54-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument 030122 23:22:54 1 Connect Access denied for user: 'root@localhost' (Using password: YES) 030122 23:23:21 2 Connect root@localhost on 030123 9:15:57 3 Connect root@localhost on 030123 9:16:02 3 Init DB mysql 3 Query show databases 3 Query show tables 3 Field List columns_priv 3 Field List db 3 Field List func 3 Field List host 3 Field List tables_priv 3 Field List user 030123 9:16:12 3 Query select * from user 030123 9:17:23 4 Connect root@localhost on 4 Statistics 4 Quit 030123 9:17:51 5 Connect root@localhost on 5 Statistics 5 Quit /usr/libexec/mysqld, Version: 3.23.54-log, started with: Tcp port
Re: Version 4 safe to use?
On Fri, Jan 10, 2003 at 01:48:23PM -0300, Maximo Migliari wrote: Cool, you work for Yahoo? Yup. I do a lot of our internal MySQL advocacy and consulting. I used to post from my work address but decided it'd be easier to manage one on-line identity than two. Plus it might help to keep the lawyers happy in some strange way. Who knows. I'd love to know the extent to which Yahoo uses PHP and MySQL these days. MySQL is all over the place. PHP is spreading a bit slowly, but there's definitely momentum. Now that we have Rasmus here it's certain to only increase in speed. What is the average queries/sec that you are getting with MySQL - what server setup, etc? I've talked (in general) about out setup on the list many times in the past. The list archive may be helpful in that regard. I've also talked about MySQL @ Yahoo in several of my presentations. They're all available on-line: http://jeremy.zawodny.com/mysql/ As for how many queries per second, it depends. Most of our MySQL server's aren't really stressed. But we've seen peeks around 2,000/sec or more. Usually our busy servers are in the 200-500/sec range. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 30 days, processed 1,010,824,130 queries (381/sec. avg) - 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
Upgrading to version 4.
In the MySQL manual, under http://www.mysql.com/doc/en/Upgrading-from-3.23.html it says: --- The old C API functions mysql_drop_db, mysql_create_db, and mysql_connect are not supported anymore, unless you compile MySQL with CFLAGS=-DUSE_OLD_FUNCTIONS. Instead of doing this, it is preferable to change the client to use the new 4.0 API. - My company's website is running version 3.23.53a, and the main client that uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in PHP? Although this manual entry is talking about the C API functions, I assume PHP uses these to communicated with MySQL. Perhaps I might be wrong, but I would like to just double check. Thanks, Maximo. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading to version 4.
Maximo, My company's website is running version 3.23.53a, and the main client that uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in PHP? Although this manual entry is talking about the C API functions, I assume PHP uses these to communicated with MySQL. Perhaps I might be wrong, but I would like to just double check. PHP's mysql_connect() is just a wrapper around the C API mysql_connect. As the manual says: This function is deprecated. It is preferable to use mysql_real_connect() instead. I assume that PHP 4.2.3 is already using mysql_real_connect(). If this is not the case, I'm quite sure (if no one here disagrees ;) that PHP 5 will. And I'm really sure that it will always be called mysql_connect() in PHP, just to keep things easy. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Maximo Migliari [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 13, 2003 7:45 PM Subject: Upgrading to version 4. In the MySQL manual, under http://www.mysql.com/doc/en/Upgrading-from-3.23.html it says: --- The old C API functions mysql_drop_db, mysql_create_db, and mysql_connect are not supported anymore, unless you compile MySQL with CFLAGS=-DUSE_OLD_FUNCTIONS. Instead of doing this, it is preferable to change the client to use the new 4.0 API. - My company's website is running version 3.23.53a, and the main client that uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in PHP? Although this manual entry is talking about the C API functions, I assume PHP uses these to communicated with MySQL. Perhaps I might be wrong, but I would like to just double check. Thanks, Maximo. - 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: Upgrading to version 4.
At 23:45 +0100 1/13/03, Stefan Hinz, iConnect (Berlin) wrote: Maximo, My company's website is running version 3.23.53a, and the main client that uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in PHP? Although this manual entry is talking about the C API functions, I assume PHP uses these to communicated with MySQL. Perhaps I might be wrong, but I would like to just double check. PHP's mysql_connect() is just a wrapper around the C API mysql_connect. Huh? PHP's mysql_connect() has been using mysql_real_connect() for several years now. As the manual says: This function is deprecated. It is preferable to use mysql_real_connect() instead. I assume that PHP 4.2.3 is already using mysql_real_connect(). If this is not the case, I'm quite sure (if no one here disagrees ;) that PHP 5 will. And I'm really sure that it will always be called mysql_connect() in PHP, just to keep things easy. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading to version 4.
On Mon, Jan 13, 2003 at 03:45:59PM -0300, Maximo Migliari wrote: In the MySQL manual, under http://www.mysql.com/doc/en/Upgrading-from-3.23.html it says: --- The old C API functions mysql_drop_db, mysql_create_db, and mysql_connect are not supported anymore, unless you compile MySQL with CFLAGS=-DUSE_OLD_FUNCTIONS. Instead of doing this, it is preferable to change the client to use the new 4.0 API. - My company's website is running version 3.23.53a, and the main client that uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in PHP? Although this manual entry is talking about the C API functions, I assume PHP uses these to communicated with MySQL. Perhaps I might be wrong, but I would like to just double check. The PHP MySQL API will still work for you. Additionally, there is a new API that is currently in development that is intended to support the new features of MySQL like SSL connections, prepared statements, etc. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Find the highest score for a given name mysql SELECT name, max(score) FROM high_score GROUP BY name; Gosh, Batman. The nobility of the almost-human porpoise. --Robin, the Boy Wonder - 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
version 4 or 3
Hi, I would like to know what are the main differencies between the version 4 and and version 3 of mysql. I heard that sql changed in mysql 4. Is this true?? Must I change my existing programs to update the queries?? Thanking in advance, Nuno Lopes - 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: version 4 or 3
On Friday 10 January 2003 23:11, Nuno Lopes wrote: I would like to know what are the main differencies between the version 4 and and version 3 of mysql. Check the manual: http://www.mysql.com/doc/en/News-4.0.x.html http://www.mysql.com/doc/en/Nutshell_Other_features.html http://www.mysql.com/doc/en/Upgrading-from-3.23.html I heard that sql changed in mysql 4. Is this true?? Must I change my existing programs to update the queries?? There were add new features (you can read about them checking the links above), but you can use your old queries as well. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Version 4 safe to use?
Cool, you work for Yahoo? I'd love to know the extent to which Yahoo uses PHP and MySQL these days. What is the average queries/sec that you are getting with MySQL - what server setup, etc? Maximo. At 17:12 9/1/2003 -0800, you wrote: On Thu, Jan 09, 2003 at 01:51:20PM -0300, Maximo Migliari wrote: What were the main benefits that you noticed straight away before adapting your code to use the new features that MySQL 4 offers? Replication is faster in 4.0. That's a big win for us, as we use replication pretty heavily. Does the query cache make a big difference? Do you have any benchmarks, even off your head? The query cache helps a lot. I ran some stats a while back. We have some queries that are as optimized as they can get. Accessing this page: http://biz.yahoo.com/n/y/yhoo.html uses the quey to fetch headlines. Without the query cache, that query can take anywhere from 50ms to 200ms to return (depends on the specific ticker and a few other factors). With the query cache, it returns in 4ms-6ms when the data is cached. For frequently accessed tickers, it makes a big difference. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 25 days, processed 866,323,874 queries (388/sec. avg) - 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: Version 4 safe to use?
What were the main benefits that you noticed straight away before adapting your code to use the new features that MySQL 4 offers? Does the query cache make a big difference? Do you have any benchmarks, even off your head? Maximo. At 09:47 8/1/2003 -0800, you wrote: On Wed, Jan 08, 2003 at 09:00:51AM -0700, David Rock wrote: Are many people using MySQL version 4 yet? I'm interested in it because I want to use it's SSL capabilities but would like to hear that people are not having trouble with it first. I've had very good luck with MySQL 4 in several high-profile environments. We began using it in live envrionments back in August and have contintued to spread MySQL 4 since then. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 24 days, processed 830,915,772 queries (392/sec. avg) - 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: Version 4 safe to use?
At 13:51 -0300 1/9/03, Maximo Migliari wrote: What were the main benefits that you noticed straight away before adapting your code to use the new features that MySQL 4 offers? Does the query cache make a big difference? Oh, yes. It does. :-) Do you have any benchmarks, even off your head? Maximo. At 09:47 8/1/2003 -0800, you wrote: On Wed, Jan 08, 2003 at 09:00:51AM -0700, David Rock wrote: Are many people using MySQL version 4 yet? I'm interested in it because I want to use it's SSL capabilities but would like to hear that people are not having trouble with it first. I've had very good luck with MySQL 4 in several high-profile environments. We began using it in live envrionments back in August and have contintued to spread MySQL 4 since then. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 24 days, processed 830,915,772 queries (392/sec. avg) - 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: Version 4 safe to use?
On Thu, 9 Jan 2003, Paul DuBois wrote: Date: Thu, 9 Jan 2003 11:29:03 -0600 From: Paul DuBois [EMAIL PROTECTED] To: Maximo Migliari [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Version 4 safe to use? At 13:51 -0300 1/9/03, Maximo Migliari wrote: What were the main benefits that you noticed straight away before adapting your code to use the new features that MySQL 4 offers? Does the query cache make a big difference? Oh, yes. It does. :-) Do you have any benchmarks, even off your head? PC mag a few months back did one and looked at it with and without. You might google for that. Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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: Version 4 safe to use?
On Thu, Jan 09, 2003 at 01:51:20PM -0300, Maximo Migliari wrote: What were the main benefits that you noticed straight away before adapting your code to use the new features that MySQL 4 offers? Replication is faster in 4.0. That's a big win for us, as we use replication pretty heavily. Does the query cache make a big difference? Do you have any benchmarks, even off your head? The query cache helps a lot. I ran some stats a while back. We have some queries that are as optimized as they can get. Accessing this page: http://biz.yahoo.com/n/y/yhoo.html uses the quey to fetch headlines. Without the query cache, that query can take anywhere from 50ms to 200ms to return (depends on the specific ticker and a few other factors). With the query cache, it returns in 4ms-6ms when the data is cached. For frequently accessed tickers, it makes a big difference. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 25 days, processed 866,323,874 queries (388/sec. avg) - 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
Version 4 safe to use?
Are many people using MySQL version 4 yet? I'm interested in it because I want to use it's SSL capabilities but would like to hear that people are not having trouble with it first. Thanks, David Rock - 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: Version 4 safe to use?
Are many people using MySQL version 4 yet? I'm interested in it because I want to use it's SSL capabilities but would like to hear that people are not having trouble with it first. We have been using 4.0.x for about five months now on a production system and have had no problems. Scott Pippin [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: Version 4 safe to use?
On Wed, Jan 08, 2003 at 09:00:51AM -0700, David Rock wrote: Are many people using MySQL version 4 yet? I'm interested in it because I want to use it's SSL capabilities but would like to hear that people are not having trouble with it first. I've had very good luck with MySQL 4 in several high-profile environments. We began using it in live envrionments back in August and have contintued to spread MySQL 4 since then. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 24 days, processed 830,915,772 queries (392/sec. avg) - 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
Which version of MySql compile with gcc 3.0.3 on Solaris ?
Hi, Happy holiday ! I'm not happy right now. I can't compile src distribution of mysql-3.23.54a on Sun Solaris 8 with gcc version 3.0.3. Does anyone has luck with Mysql using gcc 3.0.3 ? Is a version of Mysql other than mysql-3.23.54a that can be compiled with gcc version 3.0.3 ? I've search goole and found this http://www.sunhelp.org/pipermail/geeks/2002-January/011003.html. But I'm not the Unix admin on the Solaris server and I'm stuck with gcc version 3.0.3 for now. Can someone has good hint for this problem ? Thanks in advance. Ketung Hsiao 310-363-6771 - 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
English version of EasyPHP ??
I want to install EasyPHP with Apache-MySQL-PHP on a Windows laptop for use over the holidays... I am a newbie at all this. I installed EasyPHP on an extra Windows Desktop here to try it and all the doc's are in French. (It also installed phpmyadmin... doc's for this also in French) 1 - Is there a version of EasyPHP in English? 2 - Is there an EasyPHP mail list or other online user to user support(in English) ? Thanks in advance for any help. tmb __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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: Bug report: Embedded MySQL version 4.05a
Hi Paul! Thank you for the quick response. Indeed, we expect it to work otherwise. In our application, users are authenticated by the operating system, but we were hoping to use the built-in authorization of MySql instead of developing our own. Our strategy is to automatically add users to MySql as they are given to us by the OS and assign permissions to tables using these users. Does that seem reasonable? Thank you! Henry. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 9:09 PM To: Matt Solnit; Heikki Tuuri; [EMAIL PROTECTED] Cc: Henry Bequet Subject: Re: Bug report: Embedded MySQL version 4.05a At 15:39 -0800 12/10/02, Matt Solnit wrote: === Bug report -- MySQL v4.05a, binary distribution === -- Machine specs: -- Compaq Presario desktop Windows XP Professional SP1 .NET Framework SP2 Problem description: The security features of MySQL do not seem to work with Embedded MySQL. Instead, every user is given full permissions. Would you expect otherwise? If you have the embedded server linked into an application, it's expected that the application will have full control over the server and can do anything with any of its databases. - 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: Embedded MySQL version 4.05a
=== Bug report -- MySQL v4.05a, binary distribution === -- Machine specs: -- Compaq Presario desktop Windows XP Professional SP1 .NET Framework SP2 Problem description: The security features of MySQL do not seem to work with Embedded MySQL. Instead, every user is given full permissions. - Setup script: - USE mysql DELETE FROM user WHERE user=''; DELETE FROM user WHERE user='root' AND host!='localhost'; USE test CREATE TABLE mytable (a int); GRANT SELECT ON mytable TO joe@localhost; GRANT USAGE ON mytable TO jay@localhost; FLUSH PRIVILEGES; -- Observed behavior: -- Running the mysql.exe client, anonymous users cannot connect to the database, user 'joe' has read-only access to the table test.mytable, and user 'jay' as no privileges. Running the mysql-server.exe host, all users have full privileges. Additionally, the GRANT statement in mysql-server.exe returns error 1047 (Unknown command). --- Possible cause: --- The function acl_init() which loads the ACL's for each user on startup, includes a parameter, dont_read_acl_tables, that can be set to true to skip this step. The purpose of this parameter according to the comments is to support the --skip-grant command-line option. However, the mysql_server_init() function hard-codes this parameter value to 1, so the ACL's never get loaded and every access succeeds. --- My contact information: --- Matt Solnit [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: Bug report: Embedded MySQL version 4.05a
At 15:39 -0800 12/10/02, Matt Solnit wrote: === Bug report -- MySQL v4.05a, binary distribution === -- Machine specs: -- Compaq Presario desktop Windows XP Professional SP1 .NET Framework SP2 Problem description: The security features of MySQL do not seem to work with Embedded MySQL. Instead, every user is given full permissions. Would you expect otherwise? If you have the embedded server linked into an application, it's expected that the application will have full control over the server and can do anything with any of its databases. - 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
The 4.0.6 version
Starting from 4.0.6 mysql is declared as gamma ? sql,query - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into my eyes Phone : +55 041 296-2311 r.112 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [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 4.0.6 version
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dyego -- ...and then Dyego Souza do Carmo said... % % Starting from 4.0.6 mysql is declared as gamma ? That's what the manual and the release announcement say. [15 lines of obnoxious signature and 8 lines of ridiculous mail list footer deleted.] HTH HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE962B6Gb7uCXufRwARAlfBAKCj6ATEOgIK+JD0hfRaaGBZmCM3IQCg2mdv 4YMiaQGwXj5U/bqWArGVhg8= =bHEM -END PGP SIGNATURE- - 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 4.0.6 version
Dyego, Monday, December 02, 2002, 2:54:16 PM, you wrote: DSdC Starting from 4.0.6 mysql is declared as gamma ? Yes. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
info about an old version (v. 3.22.32)
Hi. One of my friend, with MySQL v. 3.22.32 and with this commands : CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name varchar(10) NOT NULL, title char(50) NOT NULL, UNIQUE(con)) have this error: MySQL complains: Column 'con' is used with UNIQUE or INDEX but is not defined as NOT NULL I have v. 3.23.53-log and with the same statment I have no error; I guess because the new version add 'not null' automagically. Is it right? Can someone tell me from which version is it true? thank you in advance! bye bye! MAS! -- Marco Andriolo-Stagno (MAS!) [EMAIL PROTECTED] PROSA - free software - http://www.prosa.it FreeGO! - free software news - http://www.freego.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
Re: info about an old version (v. 3.22.32)
* Marco Andriolo-Stagno One of my friend, with MySQL v. 3.22.32 and with this commands : CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name varchar(10) NOT NULL, title char(50) NOT NULL, UNIQUE(con)) have this error: MySQL complains: Column 'con' is used with UNIQUE or INDEX but is not defined as NOT NULL I have v. 3.23.53-log and with the same statment I have no error; I guess because the new version add 'not null' automagically. Is it right? Yes. Can someone tell me from which version is it true? From 3.23.0: URL: http://www.mysql.com/doc/en/News-3.23.0.html -- Roger - 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: info about an old version (v. 3.22.32)
Marco, Thursday, November 28, 2002, 3:36:22 PM, you wrote: MAS One of my friend, with MySQL v. 3.22.32 and with this commands : MAS CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name MAS varchar(10) NOT NULL, title char(50) NOT NULL, UNIQUE(con)) MAS have this error: MAS MySQL complains: MAS Column 'con' is used with UNIQUE or INDEX but is not defined as NOT MAS NULL MAS I have v. 3.23.53-log and with the same statment I have no error; I MAS guess because the new version add 'not null' automagically. MAS Is it right? Yes, exactly. MAS Can someone tell me from which version is it true? From the change logs: Using AUTO_INCREMENT will now automatically make the column NOT NULL. http://www.mysql.com/doc/en/News-3.23.0.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Fw: Client API version is wrong or am I?
I have installed the MySQL database 4.0.4 client, but when I look at phpinfo() I see that it says: Client API version: 4.0.2-alpha Why? Regards, Jacob - 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: WinMySQLAdmin.exe in mySQL-build 3.23.53 (Windows version)
Guenter, Nice piece of analysis! As it happens WinMySQLadmin v1.4 under Win2000 fares little better, apparently gobbling up VM until... (Bug Report posted 20Nov2002 shortly after midnight UTC - as yet unacknowledged) [won't attach here (not correct list procedure), so will forward private copy separately] WinMySQLadmin used to work well in its previous incarnation. On behalf of your less-capable Win32 brethren, is there any chance that you could Zip the set of requisite files (for only) that WinMySQLadmin (previous version/v-1) and make them available so that we could load them 'over the top' of the faulty files delivered with recent (both 3.23.n and 4.n branches) versions of MySQL? Please advise, =dn When you try to run WinMySQLAdmin.exe on a system running WinNT4.0 Sp6a, you get an alertbox telling you a missing reference to CreateToolhelp32Snapshot in kernel32.dll. Using the MS-Tool DEPENDS.EXE on a system running WinNT4.0 SP6a it can be seen that at least the latest mySQL-build 3.23.53 contains a version of WinMySqlAdmin.exe which has external references to - CreateToolhelp32Snapshot - Process32First - Process32Next in kernel32.dll, which cannot be resolved on WinNT4.0 SP6a! Testing the same with my currently installed mySQL-version 3.23.47, these external references are missing. So that older version runs fine on WinNT4.0! On the Microsoft support page http://support.microsoft.com/default.aspx?scid=KB;en-us;q175030 one can read in section Using the ToolHelp32 Library to Enumerate Processes that these API-calls are *not* supported on Windows NT 4.0! Best wishes. Guenter Kukkukk - 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: Version 4.1
Daniel, - Original Message - From: Daniel Kiss [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, November 21, 2002 7:18 AM Subject: Version 4.1 Hi all, I would like to know when MySQL version 4.1 will be available for windows as compiled install kit? my guess is around December 31th, 2002. But I would encourage people to grab and compile the public 4.1 source tree and test 4.1, especially the SQL subqueries in it. If you look at the bugs mailing list, Jocelyn Fournier is doing an excellent job in alpha-testing 4.1. Thanks, Daniel Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://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
WinMySQLAdmin.exe in mySQL-build 3.23.53 (Windows version)
When you try to run WinMySQLAdmin.exe on a system running WinNT4.0 Sp6a, you get an alertbox telling you a missing reference to CreateToolhelp32Snapshot in kernel32.dll. Using the MS-Tool DEPENDS.EXE on a system running WinNT4.0 SP6a it can be seen that at least the latest mySQL-build 3.23.53 contains a version of WinMySqlAdmin.exe which has external references to - CreateToolhelp32Snapshot - Process32First - Process32Next in kernel32.dll, which cannot be resolved on WinNT4.0 SP6a! Testing the same with my currently installed mySQL-version 3.23.47, these external references are missing. So that older version runs fine on WinNT4.0! On the Microsoft support page http://support.microsoft.com/default.aspx?scid=KB;en-us;q175030 one can read in section Using the ToolHelp32 Library to Enumerate Processes that these API-calls are *not* supported on Windows NT 4.0! Best wishes. Guenter Kukkukk - 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
Error 1148 The error used Command is not allowed with this MySQL-Version
Hello, I downloded MySQL-Version 3.23 for Windows XP from MySQL-webpage. If I try to load a Database from a textfile I got message Error 1148 The error used Command is not allowed with this MySQL-Version. I used following Command: LOAD DATA LOCAL INFILE verlagdaten.txt INTO TABLE verlag; Any ideas for help? Best regards, Klaus Wagner - 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 1148 The error used Command is not allowed with this MySQL-Version
Greetings I think the path for the file is not correct. Try giving the complete path with (\) in the directory name changed to (/). Also specify the escaping characters properly. For more information you can check out the MySQL docs on LOAD LOCAL INFILE. Rgds Insane SQLyog - The Definitive Windows GUI for MySQL http://www.webyog.com/sqlyog/download.html - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 5:57 PM Subject: Error 1148 The error used Command is not allowed with this MySQL-Version Hello, I downloded MySQL-Version 3.23 for Windows XP from MySQL-webpage. If I try to load a Database from a textfile I got message Error 1148 The error used Command is not allowed with this MySQL-Version. I used following Command: LOAD DATA LOCAL INFILE verlagdaten.txt INTO TABLE verlag; Any ideas for help? Best regards, Klaus Wagner - 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: Error 1148 The error used Command is not allowed with this MySQL -Version
Use the mysqlc.exe client instead of mysql.exe -- Geoff Morris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 7:28 AM To: [EMAIL PROTECTED] Subject: Error 1148 The error used Command is not allowed with this MySQL -Version Hello, I downloded MySQL-Version 3.23 for Windows XP from MySQL-webpage. If I try to load a Database from a textfile I got message Error 1148 The error used Command is not allowed with this MySQL-Version. I used following Command: LOAD DATA LOCAL INFILE verlagdaten.txt INTO TABLE verlag; Any ideas for help? Best regards, Klaus Wagner - 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
Version 4.1
Hi all, I would like to know when MySQL version 4.1 will be available for windows as compiled install kit? Thanks, Daniel - 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