gui client
Hi, i'm newbee in mysql and i want to ask you 2 questions i'm using mysql-max-3.23.47 for windows and mysqlgui-win32-static-1.7.5-2. 1) Is it possible to use more than one command in mysqlgui (the end of line charachter ; is not working) 2)Can i load and execute a text file which containing commands (eg create table ,insert value) If not can i do all of this with the dos client? Thanks in advance - 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: UNION
Walter D. Funk writes: Thanks for your answer, I´ve created a TEMPORARY table and it seems to work well for my purpose, the only doubt I still have is, if the table gets automatically deleted when the user closes the connection, or should I do something within my script to avoid a stack overflow? if there are too many simultaneous connections which create several temporary tables is it posible to knock down the server? thanks in advance No, server will not be knocked down by many tables opened, provided your OS has sufficient number of file descriptors to handle. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
about visual basic
Sir, I use visual basic 6.0 and MySQL database I developed native connection to database by Adodc tool but there is datareport tool in VB6.0. I can't connect database for my datareport. I can do it by odbc drivers.I dont want this way. My flowchart is under this text. DataEnvironment Connection1 Command1 I use MySQLOLEDBProvider for connection please help me. Thank you for interesting. _ Send and receive Hotmail on your mobile device: http://mobile.msn.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: further compile problems on Solaris 2.6
fil krohnengold writes: I wish it were as easy as a botched gcc install. But it's not. I just tried using the pre-compiled binary from ftp.ibiblio.org for 2.95.2 with identical reslts. -fil -- fil krohnengold network systems administrator american museum of natural history [EMAIL PROTECTED] Try building a small C program manually ... Also check free space in /tmp ... Make sure it is 2.95.2 for 2.6. Last but not least check that your patch level matches with the Sun recommended one. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Date formating
Jesse Shy writes: I am push a couple of date fields to mysql via the myODBC driver, however the fields are in there original format as JUN01/01 and the like. Right now these fields are type CHAR and I cant do any calculations on them. Is there a built in function to make this a legitimate date or am I stuck munging it with Perl and reinserting it into date fields? MySQL simply can not support any format as a legitimate one. Dump a table, shuffle the values , change a type to DATE and restore table. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.21.33b mysql_install_db
fil krohnengold writes: Am I crazy, or should there be some CREATE TABLE statements somewhere in the mysql_install_db script? It keeps dying on me with: Starting mysqld demon with databases from /usr/local/mysql/data ERROR 1017 at line 3: Can't find file: 'db.frm' (errno: 2) The grant tables was not installed. Line 3 being the HERE statement in the shell script: ./bin/mysql mysql END_OF_DATA 1 # Create tables from the .frm files 2 # 3 delete from db ; [...] This was a binary install for Solaris 2.6 (yes, I gave up on compiling for this platform). -fil -- fil krohnengold network systems administrator american museum of natural history [EMAIL PROTECTED] The above script does not look familiar to me. Try using one from the source distro that you tried to build. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql client exits with core dump segmentation fault
[EMAIL PROTECTED] writes: Description: ##After building mysql and installing the GRANT tables I start the daemon ##and then try to run the mysql client to alter the GRANT tables to a ##useful configuration. Subcommands like connect and use seem to work ##ok, but if I try entering anything else, even a single character, I get ##a core dump. Following is screen output from a session run via gdb: watts:/usr/local/mysql/bin $ gdb mysql GNU gdb 5.0 Copyright 2000 Free Software Foundation, Inc. ... (gdb) run -uroot -p mysql Starting program: /usr/local/mysql/bin/mysql -uroot -p mysql Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A [skip] Hi! Problems that you are experiencing are most likely a consequence of the bad build. First CXX should be gcc with 2.95.*. Second, your CPU type might be wrong. You could leave up to GCC to discover a proper CPU type that you have. You would be better if you could find a binary for your OS / CPU. Other possible cause is misconfiguration of AIX. Either due to TCP/IP, running of file descriptors, sockets etc ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: gui client
Marinos writes: Hi, i'm newbee in mysql and i want to ask you 2 questions i'm using mysql-max-3.23.47 for windows and mysqlgui-win32-static-1.7.5-2. 1) Is it possible to use more than one command in mysqlgui (the end of line charachter ; is not working) 2)Can i load and execute a text file which containing commands (eg create table ,insert value) If not can i do all of this with the dos client? Thanks in advance For batch execution of scripts use mysql monitor program. You can also directly execute commands from the history widget by right clicking on the command. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: 3.23.47 compile problems with sun's forte compiler
Hi! Quentin == Quentin Bennett [EMAIL PROTECTED] writes: Quentin Hi, From the cc(1) man page for Forte Developer 6.2 Quentin These predefinitions are valid in all modes: Quentin __sun Quentin __unix Quentin __SUNPRO_C=0x530 Quentin __`uname -s`_`uname -r` Quentin __sparc (SPARC) Quentin __sparcv9 (SPARC with -xarch=v9|v9a) Quentin __i386 (x86) Quentin __BUILTIN_VA_ARG_INCR Quentin __SVR4 Quentin __SUNPRO_C looks like it might be a good one to try for. Version 5.2 had Quentin __SUNPRO_C=0x500 ok, We will use this one. Thanks! Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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
Hardware Help.
We have been using mysql for some time to run and administer our dynamic content sites. During this time we have run mysql on low end intel hardware (dual PIII 900 with a gig of RAM) on linux and have discovered that a single mysql server in this configuration could not handle all the traffic from our websites. To this end we have been forced to run a single central DB that replicated to slaves running on each webserver. This however limits the ability of the webservers to serve content, as they have to use resources for running the DB. Right now I am exploring all our options to bring the DB back to one central location, and want to know what sort of Intel based hardware I would need to handle this. My requirements would be to handle a minimum of 5000 simultaneous connections/transactions (So my first assumption is that mysql is capable of that). Can anyone let me know what sort of hardware i need to be looking at to reach these levels of performance. Kris - 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: Hardware Help.
Kris Saw writes: We have been using mysql for some time to run and administer our dynamic content sites. During this time we have run mysql on low end intel hardware (dual PIII 900 with a gig of RAM) on linux and have discovered that a single mysql server in this configuration could not handle all the traffic from our websites. To this end we have been forced to run a single central DB that replicated to slaves running on each webserver. This however limits the ability of the webservers to serve content, as they have to use resources for running the DB. Right now I am exploring all our options to bring the DB back to one central location, and want to know what sort of Intel based hardware I would need to handle this. My requirements would be to handle a minimum of 5000 simultaneous connections/transactions (So my first assumption is that mysql is capable of that). Can anyone let me know what sort of hardware i need to be looking at to reach these levels of performance. Kris Hi! The above is a very complex issue. It truly depends on your schema, queries and even application. If you plan to have 5000 users simultaneously connected, you will have to tune up kernel and thread libs a bit. In any case, at least 4 fast CPU's, RAID 1+0 and as much memory as possible. -- Consider taking our support. Visit : https://order.mysql.com Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
facing problem with NOT NULL fields
I created table using following syntax, create table user (Login_Id varchar(16) NOT NULL, Location varchar(16) NOT NULL, PRIMARY KEY (Login_ID)); The above table should not take any null values. I tryed inserting some null values eg: INSERT INTO user (Login_Id,Location) values (,); According to me this statement should give error and not work. But still it inserts null values in to the table. When the same insert statement is run again, it gives error 1062. Plz... suggest how to see that my table does not have any NULL value and should i acheive this. Or is this a bug. Thanks Manjeet - 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: OK - Simple Timestamps problem getting the better of me!
David, My system (3.23.40-nt and MySQL-Front 1.18b as client) produces (what I think is) the desired result using both/either the NULL or NOW() alternatives - NOW (without function parentheses) is not recognised. However the INSERT statement below does not work without the addition of the VALUES keyword: 6.4.3 INSERT Syntax INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(col_name,...)] VALUES (expression,...),(...),... Hope you feel better for your sleep... Regards, =dn My response below is incorrect, with regard to the NULL behavior. MySQL will insert the current time and date for a TIMESTAMP only for the first column *if* you omit the columns from the INSERT statement. If you set the column to NULL explicitly, MySQL should set any TIMESTAMP to the current date and time. Dunno why that doesn't work for David, it works for me. Thanks to BD for pointing out my brain-lapse. :-) I have created a test table with: CREATE TABLE TimeTest ( Time1 TIMESTAMP(4), Time2 TIMESTAMP(8), Time3 TIMESTAMP(10), Time4 TIMESTAMP(12), Time5 TIMESTAMP(14)); This works fine! No problemo Now ALL I am trying to do is insert the current time and date into each field in the table!! That's all. I'm not new to MySQL or its operation but this has really got the better of me. Maybe its because its 11:40PM after a day of work but can someone please tell me how I can insert a row of current time and date into a table with different column definitions! I have tried: INSERT INTO TimeTest (NULL, NULL, NULL, NULL, NULL); I have tried NOW, 'NULL'. NOW() would work better than NOW. NULL will insert the current date and time only into the *first* TIMESTAMP column. http://www.mysql.com/doc/D/A/DATETIME.html Please Thanks DA - 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
Plz help w/ php/MySQL
The following php script successfully e-mails both messages but it doesn't update in the table scr_149 the column notified. Why? ?php // file: root/adm/e_mail.php, updated: 01/05/02 $connection=mysql_connect(localhost,wagner,123) or die (No connection!); // db $db=mysql_select_db(sbwresearch_com,$connection) or die (No database!); // done $message_1= Congratulations!\n\n You've qualified to take the online survey # 149.\n\n To take the survey, go to www.sbwresearch.com and click on Survey / Tests.\n\n ; $message_2= Sorry!\n\n You've not qualified to take the online survey # 149.\n\n We'll notify you by e-mail of upcoming screeners. ; $qry_1=select * from scr_149 where q05a!=\0\ notified=\n\; $qry_2=update scr_149 set notified='y' where username='$username'; $result_1=mysql_query($qry_1,$connection) or die (No query # 1!); while ($row_1=mysql_fetch_array($result_1, MYSQL_ASSOC)) { $username=$row_1[username]; $e_mail=$row_1[e_mail]; mail($e_mail, News from SBW Research, $message_1, From:SBW Research [EMAIL PROTECTED]\n); $result_2=mysql_query($qry_2,$connection) or die (No query # 2!); }; mysql_free_result($result_1); $qry_3=select * from scr_149 where q05a=\0\ notified=\n\; $qry_4=update scr_149 set notified=\y\ where username='$username'; $result_3=mysql_query($qry_3,$connection) or die (No query # 3!); while ($row_2=mysql_fetch_array($result_3, MYSQL_ASSOC)) { $username=$row_2[username]; $e_mail=$row_2[e_mail]; mail($e_mail, News from SBW Research, $message_2, From:SBW Research [EMAIL PROTECTED]\n); $result_4=mysql_query($qry_4,$connection) or die (No query # 4!); }; @mysql_free_result($result_3); @mysql_close($connection); header (location:done.htm); exit; ? Thanks! Anthony F. Rodriguez ([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: facing problem with NOT NULL fields
Manjeet writes: I created table using following syntax, create table user (Login_Id varchar(16) NOT NULL, Location varchar(16) NOT NULL, PRIMARY KEY (Login_ID)); The above table should not take any null values. I tryed inserting some null values eg: INSERT INTO user (Login_Id,Location) values (,); According to me this statement should give error and not work. But still it inserts null values in to the table. When the same insert statement is run again, it gives error 1062. Plz... suggest how to see that my table does not have any NULL value and should i acheive this. Or is this a bug. Thanks Manjeet This worked as expected. MySQL inserted the empty string in both columns. You can not insert it again as there is a primary key on one column. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: facing problem with NOT NULL fields
* Manjeet create table user (Login_Id varchar(16) NOT NULL, Location varchar(16) NOT NULL, PRIMARY KEY (Login_ID)); The above table should not take any null values. I tryed inserting some null values eg: INSERT INTO user (Login_Id,Location) values (,); According to me this statement should give error and not work. NULL is a special value, it is not the same as or 0. But still it inserts null values in to the table. When the same insert statement is run again, it gives error 1062. Login_Id is the primary key, you can not have two rows with the same value in this field. -- 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: Plz help w/ php/MySQL
* Anthony Rodriguez The following php script successfully e-mails both messages but it doesn't update in the table scr_149 the column notified. Why? Try moving this line: $qry_2=update scr_149 set notified='y' where username='$username'; ...after this line: $username=$row_1[username]; And the same with $qry_4. -- 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: further compile problems on Solaris 2.6
At Sat, 05 Jan 2002 15:15:15 +0200, [EMAIL PROTECTED] wrote... : fil krohnengold writes: : : I wish it were as easy as a botched gcc install. But it's not. : I just tried using the pre-compiled binary from ftp.ibiblio.org : for 2.95.2 with identical reslts. : : -fil : : Try building a small C program manually ... : : Also check free space in /tmp ... : : Make sure it is 2.95.2 for 2.6. : : Last but not least check that your patch level matches with the Sun : recommended one. I've been using this compiler for building other packages without a hitch. I really did download the right version from ibiblio. There's 890MB free in /tmp. The machine is running the recommended patch cluster from sun that was released the middle of last month. After 8 years behind the wheel, I try not to take stupid questions to mailing lists because I know we're all busy. Maybe you can shed some light on what is actually going on in the build at the point it's getting hung up. I can repost my original question if you like. -fil -- fil krohnengold network systems administrator american museum of natural history [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: 3.21.33b mysql_install_db
At Sat, 05 Jan 2002 15:34:10 +0200, [EMAIL PROTECTED] wrote... : fil krohnengold writes: : :Starting mysqld demon with databases from /usr/local/mysql/data :ERROR 1017 at line 3: Can't find file: 'db.frm' (errno: 2) :The grant tables was not installed. : : Line 3 being the HERE statement in the shell script: : :./bin/mysql mysql END_OF_DATA : 1 # Create tables from the .frm files : 2 # : 3 delete from db ; :[...] : : : The above script does not look familiar to me. Try using one from the : source distro that you tried to build. It's contained in ftp://ftp.mysql.com/MySQL-3.21/mysql-3.21.33b-sun-solaris2.6-sparc.tar.gz. And with some massaging I was able to get it to work. I realize it's old and is probably not being maintained. I just don't want you to think that I found some script labled mysql under my chair and expected it to work. It's actually identical to the one released with the source distro of the same version (minus the @var@ substitutions). -fil -- fil krohnengold network systems administrator american museum of natural history [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
How to select on two tables
Hello, all I am sure the answer to the following question is well documented in the manuals, but I just don't seem to recognize it. Please point me to the relevant documentation. I have two tables in the database. Some fields are common (Author, Date) other are specific. I know how to find the X most recent records in one table, and have them sorted by any column, but how do I do it on two tables at once? In other words, how do I find the X most recent records in both tables, and then sort them by Author name? And how do I know in the resulting list which table each item came from? Do I need a common index? Again, I realize that this is really a FAQ and certainly well documented issue, I just need to know what its correct title is. Examples are also welcome, of course TIA, mweb -- There is hopeful symbolism in the fact that flags do not wave in a vacuum. -- Arthur C. Clarke - 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
serious password problem
OK, I think I've read the docs and am doing everything right, but I simply cannot get the mysql program to accept a password for any user other than root. I'm on RedHat Linux 7.2, with MySQL version 3.23.46. I can get the root password set up fine, and I log in with it. I can even change it: mysql set password for root=password('newrootpw'); mysql \q shell$ mysql -p -u root Enter password: Welcome to the MySQL monitor. Commands end with ; or \g So far so good. Next I try to create another database and another user. mysql create database rknop; Query OK, 1 row affected (0.00 sec) mysql grant all on rknop.* to rknop identified by 'testpw'; Query OK, 0 rows affected (0.00 sec) mysql \q Here's the problem: shell$ mysql -p -u rknop rknop Enter password: ERROR 1045: Access denied for user: 'rknop@localhost' (Using password: YES) I've also tried (as root in mysql) mysql set password for rknop=password('testpw'); To no avail. For reference, the user table has: mysql select * from user where user='rknop'\G *** 1. row *** Host: % User: rknop Password: 12ab181d57a7f4be Select_priv: N Insert_priv: N Update_priv: N Delete_priv: N Create_priv: N Drop_priv: N Reload_priv: N Shutdown_priv: N Process_priv: N File_priv: N Grant_priv: N References_priv: N Index_priv: N Alter_priv: N 1 row in set (0.00 sec) The /var/log/mysqld.log file says nothing after the startup ready for connections message, and as such can shed no light on the situation. Can anybody offer me any suggestions as to how to get around this predicament? Thanks, -Rob - 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: serious password problem
I don't know if this is it, but -- 6.11 When Privilege Changes Take Effect When mysqld starts, all grant table contents are read into memory and become effective at that point. Modifications to the grant tables that you perform using GRANT, REVOKE, or SET PASSWORD are noticed by the server immediately. If you modify the grant tables manually (using INSERT, UPDATE, etc.), you should execute a FLUSH PRIVILEGES statement or run mysqladmin flush-privileges or mysqladmin reload to tell the server to reload the grant tables. Otherwise your changes will have no effect until you restart the server. If you change the grant tables manually but forget to reload the privileges, you will be wondering why your changes don't seem to make any difference! When the server notices that the grant tables have been changed, existing client connections are affected as follows: Table and column privilege changes take effect with the client's next request. Database privilege changes take effect at the next USE db_name command. Global privilege changes and password changes take effect the next time the client connects. --- Robert A. Knop Jr. wrote: OK, I think I've read the docs and am doing everything right, but I simply cannot get the mysql program to accept a password for any user other than root. I'm on RedHat Linux 7.2, with MySQL version 3.23.46. I can get the root password set up fine, and I log in with it. I can even change it: mysql set password for root=password('newrootpw'); mysql \q shell$ mysql -p -u root Enter password: Welcome to the MySQL monitor. Commands end with ; or \g So far so good. Next I try to create another database and another user. mysql create database rknop; Query OK, 1 row affected (0.00 sec) mysql grant all on rknop.* to rknop identified by 'testpw'; Query OK, 0 rows affected (0.00 sec) mysql \q Here's the problem: shell$ mysql -p -u rknop rknop Enter password: ERROR 1045: Access denied for user: 'rknop@localhost' (Using password: YES) I've also tried (as root in mysql) mysql set password for rknop=password('testpw'); To no avail. For reference, the user table has: mysql select * from user where user='rknop'\G *** 1. row *** Host: % User: rknop Password: 12ab181d57a7f4be Select_priv: N Insert_priv: N Update_priv: N Delete_priv: N Create_priv: N Drop_priv: N Reload_priv: N Shutdown_priv: N Process_priv: N File_priv: N Grant_priv: N References_priv: N Index_priv: N Alter_priv: N 1 row in set (0.00 sec) The /var/log/mysqld.log file says nothing after the startup ready for connections message, and as such can shed no light on the situation. Can anybody offer me any suggestions as to how to get around this predicament? Thanks, -Rob - 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: serious password problem
I don't know if this is it, but I don't think so; I've tried flush privileges, even though the docs don't state it's necessary for GRANT or SET PASSWORD. I've also tried stopping and restarting the mysqld process. -Rob - 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: serious password problem
Robert A. Knop Jr. writes: ERROR 1045: Access denied for user: 'rknop@localhost' (Using password: YES) mysql select * from user where user='rknop'\G *** 1. row *** Host: % User: rknop localhost is a special value (meaning connection over unix socket rather than TCP/IP), and it's not matched by % in this case. You need to grant access to user@localhost as well. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. mysql - 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: serious password problem
localhost is a special value (meaning connection over unix socket rather than TCP/IP), and it's not matched by % in this case. You need to grant access to user@localhost as well. Aha! That did the trick. Thank you very much. (Is this in the manual? If so, I didn't find it. It would probably be worth inserting prominently in the sections on Grant and Revoke and Set Password, unless it's there already and I'm at fault for failing to sufficiently RTFM.) -Rob (Food for SPAM filter: sql,database,table,query!!!) -- -=-=-= Rob Knop =-= [EMAIL PROTECTED] =-= http://www.pobox.com/~rknop =-=-=- Help the EFF protect basic freedoms online: http://www.eff.org Playwrights theatre types, see The Dramatic Exchange: http://www.dramex.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mySQL : 3 or 4?
Good afternoon. My first post to this list (and I am sure it won't be my last ;) ) In the process of biting the bullet and learning AMP, on OS X 10.1.2. Been messing with PHP for a week now, and I totally LOVE it. Coming off an 18-month project in W*/FM/Lasso... ready for a change ;) Anyhow, my main resources to date are the PHP and MySQL websites, a site by Marc Liyanage (http://www.entropy.ch/software/macosx/) and the book PHP and MySQL Web Development by Welling and Thomson. This book is written assuming MySQL 3.22.27 and PHP 4. I am ready to take a stab at installing MySQL at this point. My question: Do I install 3.23.42 or the alpha 4.0? -- Later... JS - 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
Data dictionary as a table
Does MySQL have anything functionally equivalent to the data dictionary views of Oracle? I am thinking particularly of retrieving, via a SQL SELECT statement, a list of all my tables, or a list of all the columns of a particular table along with the columns' attributes. TIA. --Erv - 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
SQL Server 2000
Hi.. Is there any painless way or good documentation on how to convert a database from Micro$soft $QL 2000 into MySql? Thanks in advance for any directions you can point me to. Stan - 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: Nested Inner Joins
I am having similar nested join problems with the following: SELECT tblThread.Message_date, tblAuthor.Username, tblAuthor.Author_ID, tblTopic.Forum_ID FROM (tblForum INNER JOIN tblTopic ON tblForum.Forum_ID = tblTopic.Forum_ID) INNER JOIN (tblAuthor INNER JOIN tblThread ON tblAuthor.Author_ID = tblThread.Author_ID) ON tblTopic.Topic_ID = tblThread.Topic_ID ORDER BY tblThread.Message_date DESC I looked at Bob Hall's posting back in Dec, but being new to SQL can't quite get my head around it. Could anybody be a real champ and translate the sql code above from an MS ACCESS based site in to MySQL? Many thanks Regards Martin Schmalenbach [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
Newbie Question: Data Type Choice
Whats the best data type to use for storing guest book comments in my database table. Always an Email Away Kevin Campbell Chief Executive Officer The Club Mix, Inc. http://www.theclubmix.com
Re: Newbie Question: Data Type Choice
From: Kevin Campbell [EMAIL PROTECTED] What's the best data type to use for storing guest book comments in my database table. The best data type would be the kevins_gb_comment data type, but I don't think that's implimented in MySQL yet. If all you are doing is storing and retrieving the data, then you'll probably want to use the text() type. If you will also want to do some searching, then you might want to use a text() column to hold the display data and set up a few processed varchars() to hold interesting strings to match searches against. But the whole searching thing can become a pretty big subject. --- Rodney Broom Programmer: Desert.Net Spam filter: sql database - 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: SQL Server 2000
Stan: I don't know as I would call anything involving MSSQL Server 'painless, but it can be done. Do a search of the list archive (http://lists.mysql.com/), looking for 'SQL7' or 'MSSQL'. There have been dozens of posts over the last couple of years describing different ways to approach the task. You should be able to use the same techniques port MSSQL Server 2000. Regardless of the technique you use, there will be some editing required on the table creation scripts. When you get to that, the MySQL Manual is your friend. Gerald Jensen - Original Message - From: Stan Lester [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 05, 2002 12:35 PM Subject: SQL Server 2000 Hi.. Is there any painless way or good documentation on how to convert a database from Micro$soft $QL 2000 into MySql? Thanks in advance for any directions you can point me to. Stan - 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: 3.21.33b mysql_install_db
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa fil krohnengold writes: Am I crazy, or should there be some CREATE TABLE statements somewhere in the mysql_install_db script? It keeps dying on me with: Starting mysqld demon with databases from /usr/local/mysql/data ERROR 1017 at line 3: Can't find file: 'db.frm' (errno: 2) The grant tables was not installed. Line 3 being the HERE statement in the shell script: ./bin/mysql mysql END_OF_DATA 1 # Create tables from the .frm files 2 # 3 delete from db ; [...] This was a binary install for Solaris 2.6 (yes, I gave up on compiling for this platform). 3.21.33b is an VERY old version of MySQL. Try to get a newer one. What was the problem you got with compiling MySQL on this platform? If you follow the instructions in the Solaris section in the MySQL manual, this should be very straightforward! Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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
mit-pthreads needs select(2) prototype on NetBSD
Hi! Another patch for mit-pthreads under NetBSD. The newer gcc that is now used on NetBSD-current needs a prototype for select(2) to compile mysqld.cc otherwise it aborts with: mysqld.cc: In function `void * handle_connections_sockets(void *)': mysqld.cc:2314: implicit declaration of function `int select(...)' The following patch from our pkgsrc collection should be incorporated: $NetBSD: patch-ah,v 1.7 2001/10/08 17:28:13 veego Exp $ --- mit-pthreads/include/unistd.h-orig Wed Oct 3 18:08:36 2001 +++ mit-pthreads/include/unistd.h Mon Oct 8 08:15:37 2001 @@ -177,6 +177,12 @@ voidusleep __P_((unsigned)); int vfork __P_((void)); +/* FIXME: this should go to sys/time.h! */ +#if __STDC__ +struct timeval;/* select(2) XXX */ +#endif +int select __P((int, fd_set *, fd_set *, fd_set *, struct timeval *)); + #endif /* !_POSIX_SOURCE */ __END_DECLS Thanks, --chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie Question: Float Type Range
Im using a field in a form to record money values: 0.00 9000.00 in my database table. Im planning on using float(4,2). Does the 4 mean the maximum number of digits before the decimal and the 2 the number of digits after the decimal. Always an Email Away Kevin Campbell Chief Executive Officer The Club Mix, Inc. http://www.theclubmix.com
Re: Newbie Question: Float Type Range
On Sat, 05 Jan 2002 11:28:54 -0800, Kevin Campbell [EMAIL PROTECTED] wrote: Im using a field in a form to record money values: 0.00 9000.00 in my database table. Im planning on using float(4,2). Does the 4 mean the maximum number of digits before the decimal and the 2 the number of digits after the decimal. I think you'll find using the DECIMAL(6,2) works better for dollar values. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql daemon monitoring
Hello , I am looking for a solution in order to monitoring mysql daemon to restart automatically the daemon when is down. I was thinking maybe there is a possibility like services watching in the cobalt interface thanks in advance @+ Fred mailto:[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: serious password problem
Robert A. Knop Jr. writes: localhost is a special value (meaning connection over unix socket rather than TCP/IP), and it's not matched by % in this case. You need to grant access to user@localhost as well. (Is this in the manual? If so, I didn't find it. Heh, it turns out that I was wrong about what happens. The real reason you need to add localhost is the interaction between host and user in the mysql privilege system, and the defaults. On http://www.mysql.com/doc/A/c/Access_denied.html I found it in the paragraph that starts If you can't figure out. The page which discusses how things work is http://www.mysql.com/doc/C/o/Connection_access.html It's probably a good idea to remove the entry for ''@'localhost'. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL : 3 or 4?
Hi If i were in your position i would use 3.23.x mainly because that's what the majority of hosting facilities use as their platform right now. It's a pain to develop something with all the latest and greatest features then realise you have to deploy your app on something not so upto date, if you see what i mean. Alternatively, you could just run both 3.x and 4.x servers simultaneously on different ports and connect to which ever one you feel like using at the time. Best Regards Girish - Original Message - From: John Snippe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 05, 2002 6:13 PM Subject: mySQL : 3 or 4? Good afternoon. My first post to this list (and I am sure it won't be my last ;) ) In the process of biting the bullet and learning AMP, on OS X 10.1.2. Been messing with PHP for a week now, and I totally LOVE it. Coming off an 18-month project in W*/FM/Lasso... ready for a change ;) Anyhow, my main resources to date are the PHP and MySQL websites, a site by Marc Liyanage (http://www.entropy.ch/software/macosx/) and the book PHP and MySQL Web Development by Welling and Thomson. This book is written assuming MySQL 3.22.27 and PHP 4. I am ready to take a stab at installing MySQL at this point. My question: Do I install 3.23.42 or the alpha 4.0? -- Later... JS - 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: serious password problem
It's probably a good idea to remove the entry for ''@'localhost'. For many reasons, yes. :) -Rob (SPAMblocker food: sql table query database) -- -=-=-= Rob Knop =-= [EMAIL PROTECTED] =-= http://www.pobox.com/~rknop =-=-=- Help the EFF protect basic freedoms online: http://www.eff.org Playwrights theatre types, see The Dramatic Exchange: http://www.dramex.org - 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
Niebie again
I have a txt file with sql commands eg: drop table name CREATE TABLE NAME (KD NUMERIC(3), OO CHAR(30)); insert into name values (1,John); insert into name values (2,George); insert into name values (3,Chris); insert into name values (4,Patrick); Using mysql-max-3.23.47 for win98 how can i run it (with mysql monitor or mysqlgui or sth else )? Thank you for your ansewrs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Innodb/Replication problems.
Hello mysql, I'm using mysql 3.23.47 with Innodb and trying to play around with replication. The replication options are default. I got one table content occasionally deleted on slave, and note what this did not stop the replication: The inserts are successfully passed, therefore the updates to nonexistent rows simply ignored. I remember then I tried this half a year ago with myisam, the behavior was to print an error and stop. SLAVE: mysql select count(*) from counter.quickstat; +--+ | count(*) | +--+ | 661 | +--+ 1 row in set (0.04 sec) MASTER: mysql select count(*) from counter.quickstat; +--+ | count(*) | +--+ | 294787 | +--+ 1 row in set (2.65 sec) -- Best regards, Peter mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL : 3 or 4?
On 1/5/02, regarding Re: mySQL : 3 or 4? , Girish Nath wrote: Hi If i were in your position i would use 3.23.x mainly because that's what the majority of hosting facilities use as their platform right now. It's a pain to develop something with all the latest and greatest features then realise you have to deploy your app on something not so upto date, if you see what i mean. If hosting is not an issue, would that change your decision at all? I am running my own servers here, and do my own hosting, so for me that is not a relevant part of the equation. OTOH, one of the reasons I am getting into AMP is to diversify so maybe the above is not fully correct. Thanks, Girish. A valid criterion. -- Later... JS - 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
repost - compilile problems on solaris 2.6
[gcc version 2.95.2; mysql 3.23.47] : What was the problem you got with compiling MySQL on this platform? : If you follow the instructions in the Solaris section in the MySQL : manual, this should be very straightforward! I'm not getting any errors. My compile is getting stuck at: /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -DHAVE_RWLOCK_T -o libmysqlclient.la -rpath /usr/local/lib/mysql -version-info 10:0:0 libmysql.lo net.lo violite.lo password.lo get_password.lo errmsg.lo my_init.lo my_static.lo my_malloc.lo my_realloc.lo my_create.lo my_delete.lo mf_tempfile.lo my_open.lo mf_casecnv.lo my_read.lo my_write.lo errors.lo my_error.lo my_getwd.lo my_div.lo mf_pack.lo my_messnc.lo mf_dirname.lo mf_fn_ext.lo mf_wcomp.lo typelib.lo safemalloc.lo my_alloc.lo mf_format.lo mf_path.lo mf_unixpath.lo my_fopen.lo my_symlink.lo my_fstream.lo mf_loadpath.lo my_pthread.lo my_thr_init.lo thr_mutex.lo mulalloc.lo string.lo default.lo my_compress.lo array.lo my_once.lo list.lo my_net.lo charset.lo hash.lo mf_iocache.lo my_seek.lomy_pread.lo mf_cache.lo getopt.lo getopt1.lo getvar.lo my_lib.lo strmov.lo strxmov.lo strnmov.lo strmake.lo strend.lo strnlen.lo strfill.lo is_prefix.lo int2str.lo str2int.lo strinstr.lo strcont.lo strcend.lo bchange.lo bmove.lo bmove_upp.lo longlong2str.lo strtoull.lo strtoll.lo llstr.lo ctype.lo dbug.lo -lz -lcrypt -lgen -lsocket -lnsl -lm rm -fr .libs/libmysqlclient.la .libs/libmysqlclient.* .libs/libmysqlclient.* ... then I'm stuck there for hours. Files called sh${PID} are being created and removed in /tmp with this as their contents: int main() { return 0; } Here's the last 200 lines from config.log, as requested by sinisa: #endif ; return 0; } configure:8910: checking for pthread_attr_setschedparam configure:8938: gcc -o conftest -O3 -DDBUG_OFF -DHAVE_RWLOCK_T conftest.c -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread 15 configure:8910: checking for pthread_attr_create configure:8938: gcc -o conftest -O3 -DDBUG_OFF -DHAVE_RWLOCK_T conftest.c -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread 15 /var/tmp/ccmJZcsV.o: In function `main': /var/tmp/ccmJZcsV.o(.text+0x4): undefined reference to `pthread_attr_create' collect2: ld returned 1 exit status configure: failed program was: #line 8915 configure #include confdefs.h /* System header to define __stub macros and hopefully few prototypes, which can conflict with char pthread_attr_create(); below. */ #include assert.h /* Override any gcc2 internal prototype to avoid an error. */ /* We use char because int might match the return type of a gcc2 builtin and then its argument prototype would still apply. */ char pthread_attr_create(); int main() { /* The GNU C library defines this for functions which it implements to always fail with ENOSYS. Some functions are actually named something starting with __ and the normal name is an alias. */ #if defined (__stub_pthread_attr_create) || defined (__stub___pthread_attr_create) choke me #else pthread_attr_create(); #endif ; return 0; } configure:8910: checking for pthread_getsequence_np configure:8938: gcc -o conftest -O3 -DDBUG_OFF -DHAVE_RWLOCK_T conftest.c -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread 15 /var/tmp/ccRXrxRp.o: In function `main': /var/tmp/ccRXrxRp.o(.text+0x4): undefined reference to `pthread_getsequence_np' collect2: ld returned 1 exit status configure: failed program was: #line 8915 configure #include confdefs.h /* System header to define __stub macros and hopefully few prototypes, which can conflict with char pthread_getsequence_np(); below. */ #include assert.h /* Override any gcc2 internal prototype to avoid an error. */ /* We use char because int might match the return type of a gcc2 builtin and then its argument prototype would still apply. */ char pthread_getsequence_np(); int main() { /* The GNU C library defines this for functions which it implements to always fail with ENOSYS. Some functions are actually named something starting with __ and the normal name is an alias. */ #if defined (__stub_pthread_getsequence_np) || defined (__stub___pthread_getsequence_np) choke me #else pthread_getsequence_np(); #endif ; return 0; } configure:8910: checking for pthread_attr_setstacksize configure:8938: gcc -o conftest -O3 -DDBUG_OFF -DHAVE_RWLOCK_T conftest.c -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread 15 configure:8910: checking for pthread_condattr_create configure:8938: gcc -o conftest -O3 -DDBUG_OFF -DHAVE_RWLOCK_T conftest.c -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread 15 /var/tmp/ccHLyfDp.o: In function `main':
help with innodb my.ini config
good day list, i'm running 3.23.46a win on win2k and had no trouble installing and using myISAM tables and using a access front end w/myodc - this was easy and fun. now i'm trying to config to use innodb tables i stopped the service and edited [mysqld] to [mysql-max-nt] in my.ini and added the innodb parameters below to my other parameters. ?i don't need to delete the old parameters basedir=C:/mysql #bind-address=24.26.165.120 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M when i add: # innodb_data_home_dir = c:\ibdata #Data files must be able to #hold your data and indexes innodb_data_file_path = ibdata1:2000M;ibdata2:2000M #Set buffer pool size to 50 - 80 % #of your computer's memory set-variable = innodb_buffer_pool_size=356M set-variable = innodb_additional_mem_pool_size=10M innodb_log_group_home_dir = c:\iblogs #.._log_arch_dir must be the same #as .._log_group_home_dir innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 #Set the log file size to about #15 % of the buffer pool size set-variable = innodb_log_file_size=10M set-variable = innodb_log_buffer_size=8M #Set ..flush_log_at_trx_commit to #0 if you can afford losing #a few last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 do i? i'm guessing together they form a complete set of parameter for mysqld-max-nt, if this is the case, can i use both myisam and innodb table types? AND how do i edit innodb_data_file_path to use absolute paths? would i use innodb_data_file_path = c:/ibdata/ibdata1:2000M;c:/ibdata/ibdata2:2000M ? i'm aware i have to create the innodb directories (c:/ibdata and c:/iblogs) i'm new to dos, and aren't all dos paths referred to with c:/blah/blah, not c:\blah\blah??? so would this be a valid my.ini edit? [mysqld-max-nt] basedir=C:/mysql #bind-address=24.26.165.120 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # #---innodb modifications begin here--- # innodb_data_home_dir = c:/ibdata #Data files must be able to #hold your data and indexes innodb_data_file_path = c:/ibdata/ibdata1:2000M;c:/ibdata/ibdata2:2000M #Set buffer pool size to 50 - 80 % #of your computer's memory set-variable = innodb_buffer_pool_size=356M set-variable = innodb_additional_mem_pool_size=10M innodb_log_group_home_dir = c:/iblogs #.._log_arch_dir must be the same #as .._log_group_home_dir innodb_log_arch_dir = c:/iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 #Set the log file size to about #15 % of the buffer pool size set-variable = innodb_log_file_size=50M set-variable = innodb_log_buffer_size=8M #Set ..flush_log_at_trx_commit to #0 if you can afford losing #a few last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 and could anyone give me any additional advice on configuring this - i'm running a 1.33amd w 512mb ram and a partition of 10G- thanks very much in advance - i've been trying and searching and i seem to be stuck on these questions. thanks very, very much in advance, jd - 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: Innodb/Replication problems.
Hi! -Original Message- From: Peter Zaitsev [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Saturday, January 05, 2002 10:35 PM Subject: Innodb/Replication problems. Hello mysql, I'm using mysql 3.23.47 with Innodb and trying to play around with replication. The replication options are default. I got one table content occasionally deleted on slave, and note what Who deleted the table contents? You? this did not stop the replication: The inserts are successfully passed, therefore the updates to nonexistent rows simply ignored. But MySQL passes complete SQL statements to the slave. It is no error if an update does not update any rows. I do not believe that MySQL checks that the master updated as many rows as the slave. I remember then I tried this half a year ago with myisam, the behavior was to print an error and stop. SLAVE: mysql select count(*) from counter.quickstat; +--+ | count(*) | +--+ | 661 | +--+ 1 row in set (0.04 sec) MASTER: mysql select count(*) from counter.quickstat; +--+ | count(*) | +--+ | 294787 | +--+ 1 row in set (2.65 sec) -- Best regards, Peter mailto:[EMAIL PROTECTED] Regards, Heikki Tuuri Innobase Oy --- MySQL/InnoDB - transactions, row level locking, 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
Re: serious password problem
I see 2 possible problems: 1) syntax: I had to experiment with the mysql line a bit before it worked. Try: mysql -urknop -p password (Note no space before username, password last) 2) Your user has no permissions at all: I've never tried that, but I wouldn't be surprised if it made login impossible. Try setting a few first. Good luck! Steve Robert A. Knop Jr. wrote: OK, I think I've read the docs and am doing everything right, but I simply cannot get the mysql program to accept a password for any user other than root. I'm on RedHat Linux 7.2, with MySQL version 3.23.46. I can get the root password set up fine, and I log in with it. I can even change it: mysql set password for root=password('newrootpw'); mysql \q shell$ mysql -p -u root Enter password: Welcome to the MySQL monitor. Commands end with ; or \g So far so good. Next I try to create another database and another user. mysql create database rknop; Query OK, 1 row affected (0.00 sec) mysql grant all on rknop.* to rknop identified by 'testpw'; Query OK, 0 rows affected (0.00 sec) mysql \q Here's the problem: shell$ mysql -p -u rknop rknop Enter password: ERROR 1045: Access denied for user: 'rknop@localhost' (Using password: YES) I've also tried (as root in mysql) mysql set password for rknop=password('testpw'); To no avail. For reference, the user table has: mysql select * from user where user='rknop'\G *** 1. row *** Host: % User: rknop Password: 12ab181d57a7f4be Select_priv: N Insert_priv: N Update_priv: N Delete_priv: N Create_priv: N Drop_priv: N Reload_priv: N Shutdown_priv: N Process_priv: N File_priv: N Grant_priv: N References_priv: N Index_priv: N Alter_priv: N 1 row in set (0.00 sec) The /var/log/mysqld.log file says nothing after the startup ready for connections message, and as such can shed no light on the situation. Can anybody offer me any suggestions as to how to get around this predicament? Thanks, -Rob - 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 -- Steve Rapaport World Citizen - 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: help with innodb my.ini config
Hi! Your my.ini looks ok, except that you should set innodb_data_home_dir equal to an empty string if you give absolute paths in innodb_data_file_path Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB . good day list, i'm running 3.23.46a win on win2k and had no trouble installing and using myISAM tables and using a access front end w/myodc - this was easy and fun. now i'm trying to config to use innodb tables i stopped the service and edited [mysqld] to [mysql-max-nt] in my.ini and added the innodb parameters below to my other parameters. ?i don't need to delete the old parameters basedir=C:/mysql #bind-address=24.26.165.120 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M when i add: # innodb_data_home_dir = c:\ibdata #Data files must be able to #hold your data and indexes innodb_data_file_path = ibdata1:2000M;ibdata2:2000M #Set buffer pool size to 50 - 80 % #of your computer's memory set-variable = innodb_buffer_pool_size=356M set-variable = innodb_additional_mem_pool_size=10M innodb_log_group_home_dir = c:\iblogs #.._log_arch_dir must be the same #as .._log_group_home_dir innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 #Set the log file size to about #15 % of the buffer pool size set-variable = innodb_log_file_size=10M set-variable = innodb_log_buffer_size=8M #Set ..flush_log_at_trx_commit to #0 if you can afford losing #a few last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 do i? i'm guessing together they form a complete set of parameter for mysqld-max-nt, if this is the case, can i use both myisam and innodb table types? AND how do i edit innodb_data_file_path to use absolute paths? would i use innodb_data_file_path = c:/ibdata/ibdata1:2000M;c:/ibdata/ibdata2:2000M ? i'm aware i have to create the innodb directories (c:/ibdata and c:/iblogs) i'm new to dos, and aren't all dos paths referred to with c:/blah/blah, not c:\blah\blah??? so would this be a valid my.ini edit? [mysqld-max-nt] basedir=C:/mysql #bind-address=24.26.165.120 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # #---innodb modifications begin here--- # innodb_data_home_dir = c:/ibdata #Data files must be able to #hold your data and indexes innodb_data_file_path = c:/ibdata/ibdata1:2000M;c:/ibdata/ibdata2:2000M #Set buffer pool size to 50 - 80 % #of your computer's memory set-variable = innodb_buffer_pool_size=356M set-variable = innodb_additional_mem_pool_size=10M innodb_log_group_home_dir = c:/iblogs #.._log_arch_dir must be the same #as .._log_group_home_dir innodb_log_arch_dir = c:/iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 #Set the log file size to about #15 % of the buffer pool size set-variable = innodb_log_file_size=50M set-variable = innodb_log_buffer_size=8M #Set ..flush_log_at_trx_commit to #0 if you can afford losing #a few last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 and could anyone give me any additional advice on configuring this - i'm running a 1.33amd w 512mb ram and a partition of 10G- thanks very much in advance - i've been trying and searching and i seem to be stuck on these questions. thanks very, very much in advance, jd - 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
Changing Ports
I am running MySQL (v 3.23.43) on a Win NT server and require an applet to communicate with the database. Unfortunately the ISP has blocked all access to port 3306 at the router, which I think is the cause for my not being able to load any data in the applet (Meanwhile, beans served up through Tomcat are processed with no problems.). My question is, how can I change the port MySQL listens on? Is there a way other than recompiling the source files? I have tried adding a startup parameter to the MySQL service (-P option), I have tried addressing a new port in the my.cnf file, I have even tried changing the port through MySQLAdmin, all with no luck. I have gone through the manual, but the information here doesn't really help much in this regards. Any help would be greatly appreciated. Many thanks, Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql client exits with core dump segmentation fault
Thanks for the reply. gcc and g++ are both version 2.95.3 I've tried installing three different binaries, one from the mysql site and two different versions from the Bull site. All failed with different problems on this machine so I tired them all on a different model machine, but running the same version of AIX. They failed with the same problems. So, I figured I'd try building it for the specific machine On Saturday, January 5, 2002, at 08:44 AM, Sinisa Milivojevic wrote: [EMAIL PROTECTED] writes: Description: ## After building mysql and installing the GRANT tables I start the daemon ## and then try to run the mysql client to alter the GRANT tables to a ## useful configuration. Subcommands like connect and use seem to work ## ok, but if I try entering anything else, even a single character, I get ## a core dump. Following is screen output from a session run via gdb: watts:/usr/local/mysql/bin $ gdb mysql GNU gdb 5.0 Copyright 2000 Free Software Foundation, Inc. ... (gdb) run -uroot -p mysql Starting program: /usr/local/mysql/bin/mysql -uroot -p mysql Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A [skip] Hi! Problems that you are experiencing are most likely a consequence of the bad build. First CXX should be gcc with 2.95.*. Second, your CPU type might be wrong. You could leave up to GCC to discover a proper CPU type that you have. You would be better if you could find a binary for your OS / CPU. Other possible cause is misconfiguration of AIX. Either due to TCP/IP, running of file descriptors, sockets etc ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com Bill Kurland Shakespeare Co. 138 Watts Street New York, NY 10013 212.965.9683 x814 212.965.9884 fax [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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Ackward problem...Need help!
I have a RedHat 7.2 machine going, and I'm getting the following error when I run mysqltest after starting the MySQL Daemon... Snip mysqltest: Failed in mysql_real_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Snip First of all, I've relocated the data directory to /OmegaNET/DataCore which is a seperate, larger hard drive in my system. Also, I've checked the permissions of the /var/lib/mysql/mysql.sock file AND it's directory, and they both have the correct user/group/permissions. I've tried the /tmp/mysql.sock symlink fix, and that hasn't yielded any results. I've consulted every article I could find in http://groups.google.com and have been unable to find a solution to this problem. I'm uncertain as to what is causing it, and if someone could help me out, I'd be ETERNALLY greatful! Send me an e-mail at [EMAIL PROTECTED] Thanks in advance! -Alexander Trauzzi
RE: help with innodb my.ini config
my.ini looks like this: #This File was made using the WinMySQLAdmin 1.3 Tool #12/21/2001 6:19:15 PM #innodb code added 1/5/2002 1550CST #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld-max-nt] basedir=C:/mysql #bind-address=24.26.165.120 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # # innodb_data_home_dir= #Data files must be able to #hold your data and indexes innodb_data_file_path = c:/ibdata1:2000M;c:/ibdata2:2000M #Set buffer pool size to 50 - 80 % #of your computer's memory set-variable = innodb_buffer_pool_size=356M set-variable = innodb_additional_mem_pool_size=10M innodb_log_group_home_dir = c:/iblogs #.._log_arch_dir must be the same #as .._log_group_home_dir innodb_log_arch_dir = c:/iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 #Set the log file size to about #15 % of the buffer pool size set-variable = innodb_log_file_size=50M set-variable = innodb_log_buffer_size=8M #Set ..flush_log_at_trx_commit to #0 if you can afford losing #a few last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [WinMySQLadmin] Server=C:/mysql/bin/mysqld-max-nt.exe user=u password=pw at the dos command, when i enter C:\mysql\binmysqld-max-nt --standalone i get cannot initialize InnoDB as 'innodb_data_file_path' is not set. if you do not want toclip if you want to use InnoDB tables, add, for example, innodb_data_file_path = /mysql/data/ibdata1:20M clip so do i need to create these directories before i start mysqld-max-nt? i thought it created them...the man page on this is confusing to me. thanks in advance, jd -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 05, 2002 3:18 PM To: [EMAIL PROTECTED] Subject: Re: help with innodb my.ini config Hi! Your my.ini looks ok, except that you should set innodb_data_home_dir equal to an empty string if you give absolute paths in innodb_data_file_path Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB . good day list, i'm running 3.23.46a win on win2k and had no trouble installing and using myISAM tables and using a access front end w/myodc - this was easy and fun. now i'm trying to config to use innodb tables i stopped the service and edited [mysqld] to [mysql-max-nt] in my.ini and added the innodb parameters below to my other parameters. ?i don't need to delete the old parameters basedir=C:/mysql #bind-address=24.26.165.120 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M when i add: # innodb_data_home_dir = c:\ibdata #Data files must be able to #hold your data and indexes innodb_data_file_path = ibdata1:2000M;ibdata2:2000M #Set buffer pool size to 50 - 80 % #of your computer's memory set-variable = innodb_buffer_pool_size=356M set-variable = innodb_additional_mem_pool_size=10M innodb_log_group_home_dir = c:\iblogs #.._log_arch_dir must be the same #as .._log_group_home_dir innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 #Set the log file size to about #15 % of the buffer pool size set-variable = innodb_log_file_size=10M set-variable = innodb_log_buffer_size=8M #Set ..flush_log_at_trx_commit to #0 if you can afford losing #a few last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 do i? i'm guessing together they form a complete set of parameter for mysqld-max-nt, if this is the case, can i use both myisam and innodb table types? AND how do i edit innodb_data_file_path to use absolute paths? would i use innodb_data_file_path =
RE: Mysql daemon monitoring
Fred, You could use something like daemontools (http://cr.yp.to/daemontools.html) or safetynet (http://www.unixpimps.org/software/safetynet/). All assuming you are using a UNIX-type platform, of course. Tom Haapanen [EMAIL PROTECTED] -Original Message- From: Fred Taurus [mailto:[EMAIL PROTECTED]] Sent: 05 January 2002 15:04 To: [EMAIL PROTECTED] Subject: Mysql daemon monitoring Hello , I am looking for a solution in order to monitoring mysql daemon to restart automatically the daemon when is down. I was thinking maybe there is a possibility like services watching in the cobalt interface thanks in advance @+ Fred mailto:[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 - 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
Unknown compiler errors (gcc 3.0.1 / 3.1)
Hello Everyone! This happens when i try to compile with gcc 3.1 (redhat) on my redhat 7.2 installation. (yes i have upgraded to 3.1 from the default 2.96 version). I get the same result with 3.0.1 also from Redhat. any ideas ? regards, Johan gcc -DUNDEF_THREADS_HACK -I./../include -I.. /include -I./.. -I..-I..-O3 -DDBUG_OFF - O3 -felide-constructors -fno-exceptions -fno-rtti -mcpu=athlon -march=athlon -fno-implicit-templates -fno-exceptions -fno-rtti -c mysqlbinlog.cc /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -mcpu =athlon -march=athlon -fno-implicit-templates -fno-exceptions -fno-rtti -rd ynamic -o mysqlbinlog mysqlbinlog.o ../libmysql/libmysqlclient.la -lcrypt -lnsl -lm gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -mcpu= athlon -march=athlon -fno-implicit-templates -fno-exceptions -fno-rtti -rdyn amic -o mysqlbinlog mysqlbinlog.o ../libmysql/.libs/libmysqlclient.a -lcrypt -lnsl -lm -lcrypt -lnsl -lm mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0xc): undefined reference to `__cxa_pure_virtual' mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x1c): undefined reference to `__cxa_pure_virtual' collect2: ld returned 1 exit status make[2]: *** [mysqlbinlog] Error 1 make[2]: Leaving directory `/root/mysql-3.23.47/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/root/mysql-3.23.47' make: *** [all-recursive-am] Error 2 [root@sql3 mysql-3.23.47]# gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -mcpu= athlon -march=athlon -fno-implicit-templates -fno-exceptions -fno-rtti -rdyn amic -o mysqlbinlog mysqlbinlog.o ../libmysql/.libs/libmysqlclient.a -lcrypt -lnsl -lm -lcrypt -lnsl -lm mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x14): undefined reference to `__cxa_pure_virtual' mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x18): undefined reference to `__cxa_pure_virtual' mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x30): undefined reference to `__cxa_pure_virtual' collect2: ld returned 1 exit status make[2]: *** [mysqlbinlog] Error 1 make[2]: Leaving directory `/root/mysql-4.0.1-alpha/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/root/mysql-4.0.1-alpha' make: *** [all-recursive-am] Error 2 [root@sql3 mysql-4.0.1-alpha]# [root@sql3 mysql-3.23.47]# gcc -v Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.1/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redha t-linux --with-system-zlib Thread model: posix gcc version 3.1 20020103 (Red Hat Linux Rawhide 3.1-0.14) - sql table database - 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
Descending indexes not working?
Hello all, I'm working on a photo album engine where a few MySQL queries find which thumbnails that should be around the image queried (in order of time). I ended up starting with a query to get the time, filename, etc., of the requested image, and then one query for images before and one query for images after, like so: select * from image_data where name = 'p0012345.jpg'; select name from image_data where time '2001-11-01 20:10:57' order by time desc limit 4; select name from image_data where time = '2001-11-01 20:10:57' order by time limit 4; This all works quite nicely, but the second query doesn't use my index on time, and ends up taking 0.52 seconds to execeute (~8500 rows in image_data). The first and last queries use the indexes and are fast. I tried creating another index on time desc (which appeared to be accepted as valid syntax), but it didn't make any difference. If I change to =, there is no difference. If I change to =, the index works, but I already know the result. If I change to or =, the index works, but this isn't what I want. If I remove desc from order by time desc to order by time, the index always works too, but again this isn't what I want. MySQL appears to be having problems walking backwards on the index. On the web documentation, it looks like this is supposed to work: * Sort or group a table if the sorting or grouping is done on a leftmost prefix of a usable key (for example, ORDER BY key_part_1,key_part_2 ). The key is read in reverse order if all key parts are followed by DESC. ...But this likely refers to grouping, not a range on the initial match. I don't understand why I can walk forward with the index but not the other way, though. Does anybody have any ideas? :) MySQL 3.23.46, by the way. Thanks, Simon- [ Stormix Technologies Inc. ][ NetNation Communications Inc. ] [ [EMAIL PROTECTED] ][ [EMAIL PROTECTED]] [ Opinions expressed are not necessarily those of my employers. ] - 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: Ackward problem...Need help!
This very cryptic error message is what you get when you try to connect to the mysql server and it's not running. It should probably read: mysql_real_connect(): Failed because there is no server running. Run a server and try again. Anyway, if your machine is properly set up to run mysql on boot, you can run: /etc/rc.d/init.d/mysql start if not, try reading the manual about how to run mysql for the first time. -steve mysqltest: Failed in mysql_real_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) -- Steve Rapaport World Citizen - 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: Quick Update
I noticed that your update says the server just stopped. Try looking in the server error logs under the mysql directory hostname.err, (replace hostname with your own), and it may help tell you what went wrong. -- Steve Rapaport World Citizen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql daemon monitoring
In the last episode (Jan 05), Fred Taurus said: I am looking for a solution in order to monitoring mysql daemon to restart automatically the daemon when is down. I was thinking maybe there is a possibility like services watching in the cobalt interface The mysqld_safe script already does this. -- Dan Nelson [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: Quick update...
Good try but under Red Hat 7.2 the scripts /usr/share/mysql/mysql.server and /etc/init.d/mysql differ in some respects. Try the latter script instead. Bye, Neil On Sat, 5 Jan 2002, Alexander Trauzzi wrote: Here's a quick update to the problem I posted (which I'll include just for convinience sake). I went into /usr/share and I ran mysql.server start and it returned just this: 020105 18:22:20 mysqld ended Any more thoughts? -=-=-=-Previous message-=-=-=- I have a RedHat 7.2 machine going, and I'm getting the following error when I run mysqltest after starting the MySQL Daemon... Snip mysqltest: Failed in mysql_real_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Snip First of all, I've relocated the data directory to /OmegaNET/DataCore which is a seperate, larger hard drive in my system. Also, I've checked the permissions of the /var/lib/mysql/mysql.sock file AND it's directory, and they both have the correct user/group/permissions. I've tried the /tmp/mysql.sock symlink fix, and that hasn't yielded any results. I've consulted every article I could find in http://groups.google.com and have been unable to find a solution to this problem. I'm uncertain as to what is causing it, and if someone could help me out, I'd be ETERNALLY greatful! Send me an e-mail at [EMAIL PROTECTED] Thanks in advance! -Alexander Trauzzi - 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: Quick update...
No dice. I'm not thinking like that's the problem. Those two directories are identical. If anyone feels inclined to, I'll make an account that people can SSH-login into...I'm going bonkers trying to figure out what this problem is... - Original Message - From: Neil Zanella [EMAIL PROTECTED] To: Alexander Trauzzi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, January 05, 2002 9:19 PM Subject: Re: Quick update... Good try but under Red Hat 7.2 the scripts /usr/share/mysql/mysql.server and /etc/init.d/mysql differ in some respects. Try the latter script instead. Bye, Neil On Sat, 5 Jan 2002, Alexander Trauzzi wrote: Here's a quick update to the problem I posted (which I'll include just for convinience sake). I went into /usr/share and I ran mysql.server start and it returned just this: 020105 18:22:20 mysqld ended Any more thoughts? -=-=-=-Previous message-=-=-=- I have a RedHat 7.2 machine going, and I'm getting the following error when I run mysqltest after starting the MySQL Daemon... Snip mysqltest: Failed in mysql_real_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Snip First of all, I've relocated the data directory to /OmegaNET/DataCore which is a seperate, larger hard drive in my system. Also, I've checked the permissions of the /var/lib/mysql/mysql.sock file AND it's directory, and they both have the correct user/group/permissions. I've tried the /tmp/mysql.sock symlink fix, and that hasn't yielded any results. I've consulted every article I could find in http://groups.google.com and have been unable to find a solution to this problem. I'm uncertain as to what is causing it, and if someone could help me out, I'd be ETERNALLY greatful! Send me an e-mail at [EMAIL PROTECTED] Thanks in advance! -Alexander Trauzzi - 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: help with innodb my.ini config
-Original Message- From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Sunday, January 06, 2002 7:54 AM Subject: Re: help with innodb my.ini config Hi! MySQL does not find your my.ini. Try renaming it to my.cnf and put it to the root directory of the C: drive (assuming your MySQL installation as well as the operating system is on the C: drive). Remove other my.ini or my.cnf files from your computer. If this does not help, use the defaults-file startup param: mysqld-max-nt --defaults-file=your_path_to_my_cnf --console --standalone Regards, Heikki -Original Message- From: jds [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Date: Sunday, January 06, 2002 12:41 AM Subject: RE: help with innodb my.ini config heikki- so i did just that - now my.ini looks like this: #This File was made using the WinMySQLAdmin 1.3 Tool #12/21/2001 6:19:15 PM #innodb code added 1/5/2002 1550CST #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld-max-nt] basedir=C:/mysql #bind-address=24.26.165.120 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # # innodb_data_home_dir= #Data files must be able to #hold your data and indexes innodb_data_file_path = c:/ibdata1:2000M;c:/ibdata2:2000M #Set buffer pool size to 50 - 80 % #of your computer's memory set-variable = innodb_buffer_pool_size=356M set-variable = innodb_additional_mem_pool_size=10M innodb_log_group_home_dir = c:/iblogs #.._log_arch_dir must be the same #as .._log_group_home_dir innodb_log_arch_dir = c:/iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 #Set the log file size to about #15 % of the buffer pool size set-variable = innodb_log_file_size=50M set-variable = innodb_log_buffer_size=8M #Set ..flush_log_at_trx_commit to #0 if you can afford losing #a few last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [WinMySQLadmin] Server=C:/mysql/bin/mysqld-max-nt.exe user=u password=pw at the dos command, when i enter C:\mysql\binmysqld-max-nt --standalone i get cannot initialize InnoDB as 'innodb_data_file_path' is not set. if you do not want toclip if you want to use InnoDB tables, add, for example, innodb_data_file_path = /mysql/data/ibdata1:20M clip so do i need to create these directories before i start mysqld-max-nt? i thought it created them- -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 05, 2002 3:54 PM To: [EMAIL PROTECTED] Subject: Re: help with innodb my.ini config Hi! Yes: innodb_data_home_dir= Heikki -Original Message- From: jds [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Date: Saturday, January 05, 2002 11:37 PM Subject: RE: help with innodb my.ini config by an empty string you mean innodb_data_home_dir = sorry, i'm still pretty new at this- thanks very much for your aid, jd -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 05, 2002 3:18 PM To: [EMAIL PROTECTED] Subject: Re: help with innodb my.ini config Hi! Your my.ini looks ok, except that you should set innodb_data_home_dir equal to an empty string if you give absolute paths in innodb_data_file_path Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB . good day list, i'm running 3.23.46a win on win2k and had no trouble installing and using myISAM tables and using a access front end w/myodc - this was easy and fun. now i'm trying to config to use innodb tables i stopped the service and edited [mysqld] to [mysql-max-nt] in my.ini and added the innodb parameters below to my other parameters. ?i don't need to delete the old parameters basedir=C:/mysql #bind-address=24.26.165.120 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M when i add: # innodb_data_home_dir = c:\ibdata #Data files must be able to #hold your data and indexes innodb_data_file_path = ibdata1:2000M;ibdata2:2000M #Set buffer pool size to 50 - 80 % #