RE: WG: ABUSE? , myisampack , sql , admin [T2002091901XL]
whenever I post any mail to mysql list, I too received these mails -Original Message- From: Paul DuBois [SMTP:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 6:59 AM To: Joel Rees; Franz, Fa. PostDirekt MA Cc: [EMAIL PROTECTED] Subject: Re: WG: ABUSE? , myisampack , sql , admin [T2002091901XL] At 10:07 +0900 9/20/02, Joel Rees wrote: ... i received this message , after sending a request to mysql-mailing-list: Thank you for bringing this matter to our attention. We are sorry for any inconvenience it has caused you. ... It wasn't my intention to abuse , offend or spam anyone or anything and i think i didn't do something like that at all. You didn't. No need to worry. They were thanking you (us? the list?) for reporting someone who was. If i did , i am very sorry about it , but I'd like to know : What went wrong? Good question. I also received that response, but hadn't recalled submitting any abuse reports to them in the past month, so I was wondering what was going on, too. I think maybe the automatic machinery they use to filter the abuse complaints thought someone's abuse report was coming from the list for some reason. (You should look at the headers you get from some people. It's easy to understand how a machine could get confused.) [EMAIL PROTECTED] got subscribed to the mailing list. It's been taken care of, you shouldn't get any more of these. -- Joel Rees [EMAIL PROTECTED] mysql, sql, 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: Server shutdown
Have you specified any password for the users--- root or shravan ? -Original Message- From: Shravan Durvasula [SMTP:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 12:47 AM To: MySQL HELP Subject: Server shutdown Hi all, I am completely new to MySQL. I installed the source version of MySQL on Solaris 2.8. I did mysql_install_db. I started the server by saying bin/safe_mysqld --user=mysql . The server started my creating mysql.sock file in the /tmp directory. Now i want to stop the server. How should i do it? I did bin/mysqladmin -u mysql shutdown The error message that came up was: ** /home/shravan/extra/mysql/bin/mysqladmin: shutdown failed; error: 'Access denied for user: '@localhost' (Using password: NO)' ** I also tried bin/mysqladmin -u root shutdown and also bin/mysqladmin -u shravan shutdown. But i could not get the server down. Could anyone please help? Best Regards and thanks in advance, skd __ Do you Yahoo!? Yahoo! News - Today's headlines http://news.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: user defined functions under windows
I made UDFs in vC++ and loaded them on windows binary version of mysql.. They are working perfectly fine .I think you should specify these following arguments while defining a function e.g. double func_test(UDF_INIT *initid, UDF_ARGS *args, char *is_null, char *error) { return 1.0; } now try this.. Rgds -Original Message- From: Paul Grimwood [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:45 PM To: [EMAIL PROTECTED] Subject: user defined functions under windows I am trying to create a user-defined function for mysql. I am using a windows binary version of mysql and visual c++ to compile the code. I have created a dummy function call func_test that just returns 1.0. I compile this within a win32 dll project and get a file called funcdll.dll. This is basically the contents of the file: double func_test() { return 1.0; } I have placed the dll the bin dir and call mysql create function func_test returns real soname funcdll.dll; ERROR 1127: Can't find function 'func_test' in library' I assume it can find the dll but cannot find the function. Any clues, examples for windows using visual c++. The examples in the manual all refer to linux and i presume versions of mysql compiled from source as they describe folders that i dont have in my version, and i am not making any progess. thanks Paul Paul Grimwood IT Innovation Centre 2 Venture Road Chilworth Science Park Southampton SO16 7NP Tel: +44 23 8076 0834 Fax: +44 23 8076 0833 mailto:[EMAIL PROTECTED] http://www.it-innovation.soton.ac.uk - 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: Problem with installation of mysql 3.23.52 on solaris 9
Which C compiler version are you using? -Original Message- From: Bhanu Prasad Rekapalli [SMTP:[EMAIL PROTECTED]] Sent: Friday, September 13, 2002 2:23 AM To: [EMAIL PROTECTED] Subject: Problem with installation of mysql 3.23.52 on solaris 9 Hi, The error is as follows sql_lex.cc: In function `void lex_init()': sql_lex.cc:84: `symbols' undeclared (first use this function) sql_lex.cc:84: (Each undeclared identifier is reported only once for each function it appears in.) sql_lex.cc:86: `sql_functions' undeclared (first use this function) sql_lex.cc: In function `int find_keyword(LEX*, unsigned int, bool)': sql_lex.cc:167: `get_hash_symbol' undeclared (first use this function) *** Error code 1 make: Fatal error: Command failed for target `sql_lex.o' Current working directory /mysql-3.23.52/sql *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /mysql-3.23.52/sql *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /mysql-3.23.52 *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' -- Can you help me. Thanks, Bhanu - 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
error while make of 3.23.52
Hi All! mysql, sql, query I am trying to install mysql-3.23.52 . I configured with following command and then had run make. Make gives the following errors. Please help ./configure --with-low-memory --with-innodb --with-mysqld-ldflags=-rdynamic errors during make 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 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:168: `get_hash_symbol' undeclared (first use this function) *** Error code 1 make: Fatal error: Command failed for target `sql_lex.o' Current working directory /usr/local/mysql-3.23.52/sql *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem while configuring innodb option
Hi! I am trying to install mysql 3.23.52 from source distribution. I have given this command shell ./configure --prefix=/usr/local/mysql --with-innodb after sometimes it gives the following error CONFIGURING FOR INNODB NOTICE: I have to make the Innobase directory: /opt/siemobile/shrish/mysql-3.23.52/innobase .././innobase/configure: .././innobase/configure: cannot open configure: error: could not configure INNODB Please help... Regards mysql,sql,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: User defined functions
By binary menas.. I have downloaded the mysqlmax binary version 3.23.52 on solaris 2.8. I have created a user defined function and when I try to create that function in the mysql databse I get the following error ERROR 1126: Can't open shared library 'PosMax4SubsDll.so' (errno: 0 ld.so.1: /us r/local/mysql-max-3.23.51-sun-solaris2.8-sparc/bin/m) does that mean that I will not be allowed to create the my own UDF in the database, as I have the installed the binary distribution of mysql and as the libraries are linked statically in this ??? Do I need to install the mysql again from the source distributed version and configure mysqld with -rdynamic ?? -Original Message- From: Lenz Grimmer [SMTP:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 12:11 PM To: Chugh Shalini Cc: [EMAIL PROTECTED] Subject: Re: User defined functions -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 06 September 2002 06:22, Chugh Shalini wrote: Can my user defined functions work well if I have installed mysql from the binary source?? It depends on which binary you mean. We try to link our binaries statically on platforms that support it to have a minimum of external library dependencies. At least on Linux this unfortunately means that UDFs are not supported, since static binaries do not have a dynamic symbol table and therefore do not export the required symbols for using UDFs via dlopen()... Bye, LenZ (sql, query, mysql) - -- 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.0.7 (GNU/Linux) iD8DBQE9eE3tSVDhKrJykfIRAkG6AJ0W5YK4Hu3lE5LEJQ937SGgMP2rkgCfTkDs ZX1bK0n02V6fsPoFu1FKvkw= =kzHT -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: link under Win32 for udf
here instructions how to use udf_example.cc on VC++. Assuming that the user has VC++ 6.0, the Windows MySQL source and running a MySQL server with the same version. - Open the mysqld.dsw workspace. - Add New project to the workspace - Project name: udf_example - Select Win32 Dynamic-Link Library - Click OK - Select An Empty DLL project - Click Finish - Click OK - Right click over the new project and select Add Files to Project - Add \sql\udf_example.cpp - Type Ctrl+N for to create a new file. - Select text type - File name: udf_example.def - Edit the above file with the below contents: LIBRARY UDF_EXAMPLE DESCRIPTION 'Example Using UDF with VC++' VERSION 1.0 EXPORTS metaphon myfunc_double myfunc_int avgcost - Right Click the udf_example project and select Settings - Click the C/C++ tab - Select General in the Category Combo - Add the macro HAVE_DLOPEN to the PreProcessor definition - Select Preprocessor in the Category Combo - Add the include path to the text box: Additional Include directories e.g: ../include - Click Menu Project/Dependencies and add the strings library - Press F7 for to build the DLL. Note: the above instructions should be made for both release/debug version -Configuration: udf_example - Win32 Debug- Linking... Creating library Debug/udf_example.lib and object Debug/udf_example.exp udf_example.dll - 0 error(s), 0 warning(s) - Copy the udf_example.dll to the environment path directory: \winnt\system32 for example. - Start the mysql client and issue: C:\mysql\binmysql mysql CREATE FUNCTION metaphon RETURNS STRING SONAME udf_example.dll; Query OK, 0 rows affected (0.01 sec) mysql CREATE FUNCTION myfunc_double RETURNS REAL SONAME udf_example.dll; Query OK, 0 rows affected (0.00 sec) mysql CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME udf_example.dll; Query OK, 0 rows affected (0.00 sec) mysql CREATE AGGREGATE FUNCTION avgcost RETURNS REAL SONAME udf_example.dll; Query OK, 0 rows affected (0.00 sec) -Original Message- From: Nick Kostirya [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 4:37 PM To: [EMAIL PROTECTED] Subject: link under Win32 for udf Hello. It's anew me. And how linking under Win32 with --with-mysqld-ldflags=-rdynamic? I need UDF. Thanks in advance. Nick. 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 - 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
downloadable source distribution package of Mysql for solaris
query, mysql, sql A very basic question as I have no other options left but to ask. I need to download source distribution package of mysqlmax version 3.23.52 for solaris 2.8 but on the www.mysql.com site I always find the binary package version for mysqlmax for solaris. Please let me know the links where I can download the source distribution package of the same Rgds, - 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
Probem creating User Defined Functions
Hi All! I have created a user defined function exampleFun.c and have complied it to exampleFunc.so code for compiling exampleFunc.c to exampleFunc.so is gcc -I/usr/local/mysql/include -L/usr/local/mysql/lib/ \ -c -fpic exampleFunc..c ld -b -dy -G -lmysqlclient -lc exampleFunc.o -o exampleFunc..so cp exampleFunc.so /usr/lib I have kept the exampleFunc.so in my /usr/lib and have specified the same in the PATH. now while I try to create the function saying mysql CREATE FUNCTION EXAMPLE RETURNS REAL SONAME exampleFunc.so; I get the error as ERROR 1126: Can't open shared library 'PosMax4SubsDll.so' (errno: 0 ld.so.1: /us r/local/mysql-max-3.23.51-sun-solaris2.8-sparc/bin/m) Can anyone please help me in solving it. PS. I have installed MySQL database from the binary source. Thankx in advance filter MySQL, query, sql - 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
User defined functions
Can my user defined functions work well if I have installed mysql from the binary source?? Filter sql, query, 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
sysdate or curdate as default date in mysql
Dear All! Can we define sysdate or curdate as default date for a column of datatype 'date' while creating a table? Regards Sql, 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: sysdate or curdate as default date in mysql
Thankx for the reply Egorov,Hillyer and Neil. Timestamp has solved my purpose. Actually we are porting an application from oracle to mysql. In Oracle there were some tables which were using sysdate as default date, therefore we wanted something similar functionality, as it was very difficult to make changes in code of such a large application According to Neil my question was little ambiguous, but inspite of that the answers replied by all of you had helped me in solving my query. -Original Message- From: Egor Egorov [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 9:31 PM To: [EMAIL PROTECTED] Subject:Re: sysdate or curdate as default date in mysql Chugh, Monday, September 02, 2002, 3:41:27 PM, you wrote: CS Can we define sysdate or curdate as default date for a column of CS datatype 'date' while creating a table? You can't define result of function as a default value. Take a look at TIMESTAMP column type: http://www.mysql.com/doc/en/DATETIME.html -Original Message- From: Mike Hillyer [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 6:54 PM To: Chugh Shalini; [EMAIL PROTECTED] Subject: RE: sysdate or curdate as default date in mysql If what you are looking for is the current date to be used as date of creation, then remain unchanged, you will have to specify sysdate as a value during an insert. You may benefit from the timestamp datatype, which sets itself to the current date when any DML statements (insert, update) are performed. Mike -Original Message- From: DL Neil [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 7:15 PM To: Chugh Shalini; [EMAIL PROTECTED] Subject:Re: sysdate or curdate as default date in mysql Dear Chugh, Can we define sysdate or curdate as default date for a column of datatype 'date' while creating a table? The question is ambiguous: - if a table is created with a column defined to be a TIMESTAMP data type, then every time a row is INSERTed or UPDATEd, the current date will be entered into the field (a two-edged sword!). - if you want to define the date/time under which MySQL is running, eg run it as if the server was in London instead of India, then the way to do that is to run the whole serverPC with such a system clock setting. - if you want the table's creation date/time to be the default value for a particular column, then I think you will have to hard-code that as a literal value into the column definition within CREATE TABLE (I don't think it is possible to ask MySQL to evaluate and plug in the time value for you) Have you studied the manual? Regards, =dn -Original Message- From: Chugh Shalini [mailto:[EMAIL PROTECTED]] Sent: Monday, September 02, 2002 6:41 AM To: [EMAIL PROTECTED] Subject: sysdate or curdate as default date in mysql Dear All! Can we define sysdate or curdate as default date for a column of datatype 'date' while creating a table? Regards Sql, 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
RE: delete rules in mysql
Thankx Victoria, Now the things are working perfectly fine.. query, mysql -Original Message- From: Victoria Reznichenko [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 7:08 PM To: [EMAIL PROTECTED] Subject: Re: delete rules in mysql Chugh, Thursday, August 29, 2002, 2:18:26 PM, you wrote: CS Can we use delete rules such as delete on cascade in MySQL CS or I will have ti handle this on the client side? Yes, you can use ON DELETE CASCADE and ON DELETE SET NULL with InnoDB tables: http://www.mysql.com/doc/en/InnoDB_overview.html ON DELETE CASCADE and ON DELETE SET NULL are supported since 3.23.50: http://www.mysql.com/doc/en/SEC447.html -- 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 - 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
delete rules in mysql
Dear All! Can we use delete rules such as delete on cascade in MySQL or I will have ti handle this on the client side? Regards sql, 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
Can we invoke user defined function made in java in MySQL
Greetings! MySql documents specifies user defined function made in .dll/.so to be invoked in MySQL. Is there a way in which a function made in java be invoked in MySQL. Regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
transferring the data from Oracle to MySQL
We are in the process of transferring our databse from Oracle to MYSQL. Oracle has some triggers to insert into the table on some events. How can we handle this dynamic insertion of triggers in MYSQL. Also what is the alternative for check constraint of Oracle in 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