Create Tables
Dear Sir, The Create Table function is not working. Any steps that I need to take besides creating a database first. Yew Peng Singapore - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Compilation problems.
Nicu Popovici writes: Hello Sinisa, I managed to get a connection to a database but now when I want to try to make a query on that database I have to use strmov() function defined in m_string.h but at compilation time I get the following errors. JUST BECAUSE I INCLUDED m_string.h into my file gcc -g Bug_Report.c -o first.o -L/usr/lib/mysql -I/usr/include/mysql/ -lmysqlclient In file included from Bug_Report.c:3: /usr/include/mysql/m_string.h:93: parse error before `_dig_vec' /usr/include/mysql/m_string.h:93: warning: data definition has no type or storage class /usr/include/mysql/m_string.h:149: parse error before `pchar' /usr/include/mysql/m_string.h:151: parse error before `pchar' /usr/include/mysql/m_string.h:154: parse error before `s' /usr/include/mysql/m_string.h:156: parse error before `my_string' /usr/include/mysql/m_string.h:169: parse error before `_VARARGS' /usr/include/mysql/m_string.h:170: parse error before `_VARARGS' /usr/include/mysql/m_string.h:171: parse error before `_VARARGS' /usr/include/mysql/m_string.h:172: parse error before `_VARARGS' /usr/include/mysql/m_string.h:173: parse error before `_VARARGS' /usr/include/mysql/m_string.h:174: parse error before `_VARARGS' /usr/include/mysql/m_string.h:209: parse error before `value' /usr/include/mysql/m_string.h:93: warning: array `_dig_vec' assumed to have one element Maybe you have some ideeas . Thank you Nicu Don't include m_string.h. Include only mysql.h and you will have all functions you need. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and PHP4
On Fri, 25 May 2001, Andrey Kotrekhov wrote: I don't agree. If mysql install in other directory then /usr/local you need use --with-mysql=mysqldir and sometimes --with-mysql-include and --with-mysql-lib options. Do you need to specify a directory? I just did --with-mysql At 01:14 PM 5/24/2001 -0400, Bill Tangren wrote: When I compile PHP4 (4.04pl1) with the option --with-mysql=mysqldir... I get the error 'cannot find mysqlclient library under mysqldir' I did a search through the mysqsl (3.23.38) source code after I compiled it, and I don't find that library anywhere? What am I doing wrong? bonjour, I compiled mysql with --prefix=/usr/local/mysql and then php: CPPFLAGS=-I/usr/local/mysql/include/mysql ./configure --with-mysql=/usr/local/mysql -- jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql/php problem.
On Fri, 25 May 2001, Stephanie Deville wrote: I'm running FreeBSD 3.4, Apache 1.3.9 w/ php4 and mysql 3.22.32. The problem I'm having is that my php scripts work fine, mysql works fine. When I run a php script, everthing in the script works up to the point were I try mysql_connect. I get no error, but the script just hangs. It never connects to the database. I've looked through all my logs, and there are no errors listed anywhere. Any ideas? Stephanie DeVille bonjour, Can you give us an idea of your script? -- jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: installing mysql(password??)
On Sun, 27 May 2001, David Loszewski wrote: when you first install mysql server does it assign a default password becuase it tells me to enter these in to make a password for my server, but I don't know what the heck to do with them, but when I try them it says access denied /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h Precious -p password 'new-password' Dave Bonjour, You can set a root-password starting the server with safe_mysqld --skip-grant-tables then connect to mysql:mysql -u root then: mysql update user set password=password(the-password-I-want) where user = 'root'; You use the password() function to set a new password. -- jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Left Join Not Right
Hi, Move the conditions b.tag = 1 and b.day = 11323 into the ON clause of the outer join. In your present query, the result of the outer join gets filtered with the two conditions, and those are not true for the records in T1 that have no matching rows in b. Jan Roger Karnouk wrote: I am trying to do a left join query to retrieve all the rows in Table T1 and a value from server01_history. There are 100 rows in T1 and I expect some NULL values for b.total returned from server01_history. Does anyone have any Idea why I only get back 93 rows with no nulls when I should get 100 rows due to the nature of a left join? I'm using MySQL version 3.23.34 SELECT a.* ,b.total FROM T1 a USE INDEX(PRIMARY) LEFT JOIN server01_history b USE INDEX(PRIMARY) ON (a.crcid = b.crcid) WHERE b.tag=1 AND b.day=11323; CREATE TABLE `server01_history` ( `crcid` int(10) unsigned NOT NULL default '0', `tag` smallint(5) unsigned NOT NULL default '0', `day` int(10) unsigned NOT NULL default '0', `total` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`crcid`,`tag`,`day`), ) TYPE=MyISAM CREATE TABLE `T1` ( `crcid` int(10) unsigned NOT NULL default '0', `sum` int(10) unsigned NOT NULL default '0', `item` mediumtext NOT NULL, PRIMARY KEY (`crcid`) ) TYPE=MyISAM Roger Karnouk MediaHouse Software Inc. [EMAIL PROTECTED] http://www.mediahouse.com MediaHouse Software Inc., leading developers of LiveStats - Nonstop Web Reporting ipMonitor - 99.99% Uptime for your Networks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 2002:
I had the same error - but the socket didn't appear to exist.. (I'm using RH7 with the defualt setup) Moax Tech List [EMAIL PROTECTED] 5/26 6:08a You most likely don't have your permissions set right on your socket, make sure it is readable / writeable by the php user (nobody?) and apache i had that same prob. -derick - Original Message - From: Jeff Pace [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 25, 2001 5:39 PM Subject: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' Can anyone tell me what to do about this error. I installed mysql on Redhat 7.0 with the RPM on the Redhat Cd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Simple C++ question
Its been a while since i've last touched c++ and i'm trying to include two files stdio.h and mysql.h I know that to include stdio.h I enclose it in but mysql.h is in the same folder as the project I know I can't use but what do I use instead? Thanks lots David Ayliffe ([EMAIL PROTECTED])
Setting -up MySql
Hi, I need some help. I downloaded mysql and when I tried to work , C:\c:\mysql\bin\mysqld the foll message appears. Can't initialize InnoDB as 'innodb_data_file_path' is not set Pl help to get going. I need advise right from the stage where I have got the Windows version of mysql downloaded and would like to proceed further. Thanks, Devarajan. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 MYSQL.H 107 Too many types in declaration
Welcome and thanks for the time in reading this. I have a simple proggie below. When I try and compile it I get the error above (subject) the error points to this part of mysql.h - the part specifically is highlighted in red. I am compiling it on Win2K SP2 with Borland C++ v4.52 I can't see any reason why this wouldn't work. Can you?? I also get 5 warnings: WARNING MYSQL.CPP LineNo: Temporary used for parameter 1 in call to 'istream::operator (int )' in function main() - Well seeing as I have a problem anyway it seems silly not to mention it! extract from mysql.h #if defined(NO_CLIENT_LONG_LONG) typedef unsigned long my_ulonglong; #elif defined (__WIN__) typedef unsigned __int64 my_ulonglong; #else typedef unsigned long long my_ulonglong; #endif end of extract CODE // Program: Client proggie to connect to mysql server. Server options are // specified by the user // Aim: To retrieve data from table specified by user in Microsoft access format // and insert the table into a Microsoft access database of the users choice // // Command line version of the program currently being investigated // I.e. c:\this_proggie -h host -u user -p pass -po port // // Start of development: 24th May 2001 // Date modified: 27th May 2001 // Author: David Ayliffe // Version: 0.1 #include stdio.h #include iostream.h // libraries included in the linked (object) file #include conio.h #include mysql.h // include the mysql libraries copied from the win // source download #define def_host_name NULL /*host to connecto to (default localhost) */ #define def_user_name NULL /*user name for the database (default login name) */ #define def_password NULL /*password for the database (default is null) */ #define def_db_name NULL /*default database (default database default none) */ #define def_svr_port NULL /*port to connect to (default 3306) */ MYSQL *conn; /*pointer to the connection handle */ int main () { clrscr(); cout Enter the host name (default localhost): ; cin def_host_name; cout Enter the user name (default root): ; cin def_user_name; cout Enter the password (default blank): ; cin def_password; cout Enter the database name (default none): ; cin def_db_name; cout Enter the port (default 3306): ; cin def_db_name; // the real work starts here conn = mysql_init (NULL); mysql_real_connect ( conn, // pointer to connection handle def_host_name, // host to connect to def_user_name, // user name to connect as def_password, // password to use def_db_name, // database to use def_svr_port, // port to connect through NULL, // socket 0);// flags mysql_close (conn); return 0; } \CODE Thanks lots RDucky ([EMAIL PROTECTED])
Re: Simple C++ question
Hi David, #include something.h #include somethingelse.h as you see, and are used. Use when the file you want to include is not in the same directory your project is in AND is available thought the compilers include path configuration. Use when the file you want to include is in the same directory as your project or when you define at compile time a path where some include files will be gotten from. This is a very basic C/C++ question and it is likable you'll run into many other problems, so I suggest to go to http://www.mysql.com/portal/books/html/ and get yourself a good C/ C++ book ! Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: David Ayliffe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 27, 2001 9:17 AM Subject: Simple C++ question Its been a while since i've last touched c++ and i'm trying to include two files stdio.h and mysql.h I know that to include stdio.h I enclose it in but mysql.h is in the same folder as the project I know I can't use but what do I use instead? Thanks lots David Ayliffe ([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
Do I need special libraries to write C++ client programs
I'm following the exmple in the book MySQL by Paul DeBous (chapter 6 The MySQl C API page 225). I am getting an error about Too many types in declaration Do I need to download any special libraries - currently I am using the ones in the mysql-3.23.38a-win-src.zip file (mysql.h, mysql_com.h, mysql_version.h) // Program: Client proggie to connect to mysql server. Server options are // specified by the user // Aim: To retrieve data from table specified by user in microsoft access format // and insert the table into a microsoft access database of the users choice // // Command line version of the program currently being investigated // i.e. c:\this_proggie -h host -u user -p pass -po port // // Start of development: 24th May 2001 // Date modified: 27th May 2001 // Author: David Ayliffe // Version: 0.1 #include stdio.h #include iostream.h // libraries included in the linked (object) file #include conio.h #include mysql.h // include the mysql libraries copied from the win // source download #define def_host_name NULL /*host to connect to (default localhost) */ #define def_user_name NULL /*user name for the database (default login name) */ #define def_password NULL /*password for the database (default is null) */ #define def_db_name NULL /*default database (default database default none) */ #define def_svr_port NULL /*port to connect to (defualt 3306) */ MYSQL *conn; /*pointer to the connection handle */ int main () { /* clrscr(); cout Enter the host name (default localhost): ; cin def_host_name; cout Enter the user name (default root): ; cin def_user_name; cout Enter the password (default blank): ; cin def_password; cout Enter the database name (default none): ; cin def_db_name; cout Enter the port (default 3306): ; cin def_db_name; */ // the real work starts here conn = mysql_init (NULL); mysql_real_connect ( conn, // pointer to connection handle def_host_name, // host to connect to def_user_name, // user name to connect as def_password, // password to use def_db_name, // database to use def_svr_port, // port to connect through NULL, // socket 0);// flags mysql_close (conn); return 0; } Thanks lots David Ayliffe ([EMAIL PROTECTED])
Re: Create Tables
On 27 May 2001 18:10:11 +0800, Wong Yew Peng wrote: Dear Sir, The Create Table function is not working. Any steps that I need to take besides creating a database first. No. Give the error messages to get help. -- MySQL Security Administrator __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Aborted connections
Hi, We've recently upgraded our 2 mysql servers from 3.22 to 3.23.36, and since then we occasionally get errors like the following in the servers' error logs: 010527 21:01:26 Aborted connection 461457 to db: 'clantsf' user: 'tsf' host: `pride.gamepoint.net' (Got an error reading communication packets) We've upgraded the client machines from 3.22 to 3.23.32 (the version that comes with PHP 4.0.5) assuming it was a version conflict, but this doesn't seem to make any difference. This only happens once in every 1000 connects or so. It happens to connections from all client machines. The server machines run FreeBSD 3.5-STABLE and 4.2-STABLE on Intels. Both the mysqlds were compiled from source. The client machines are one Sparc running SunOS, and a few Intels running RedHat 6.2, with kernels 2.2.19 and 2.4.3. The connections are made by PHP scripts running on Apache 1.3.19 with PHP 4.0.5, using persistent connections. Does anyone know what the problem might be, or how I can find out? Thanks a lot, Jaap de Heer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: pas
[EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: hey, once I change the password for root, is there a way to check to see if it was actually changed? DAve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Recommedations
Hello All, I hoping someone on the list maybe able to offer some recommendations on a good MySQL backend database shopping cart with advance search features. One of our client's has out-grown their current cart, which using DBM data files. And it would cost too much to port it MySQL. They prefer a Perl written program but are open to PHP if it meets there needs. This would be on UN*X system, a Sun/Solaris server. With MySQL 3.23.32 currently installed. Thanks, 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
Problem with symbolic links and merge tables on NT4
I am testing mysql for merge tables and symbolic links on NT4. But it seems not working. First I tried doing exactly what is there in the manual, then searched mailing list and added use-symbolic-link in my.cnf file in C:\ directory. Mysql recognise that there is a database but can't read contents. On merging two tables with same parameters and contraints as specified in manual gives me null value when querying from merge table. BTW I am using mysql client only no PHP perl. Any help? Cheers Tito __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Recommedations
Mike - if you are familiar try Fishcart - http://fishcart.org/ - here's what I like about it: ease of implementation documentation mailing list support for a very robust PERL shopping cart program go to http://akopia.com/ - this is what minivend finally morphed to - after being purchased by RedHat. Both of these carts work with several dbs including mysql. HTH, Nicole MikeBlezien wrote: Hello All, I hoping someone on the list maybe able to offer some recommendations on a good MySQL backend database shopping cart with advance search features. One of our client's has out-grown their current cart, which using DBM data files. And it would cost too much to port it MySQL. They prefer a Perl written program but are open to PHP if it meets there needs. This would be on UN*X system, a Sun/Solaris server. With MySQL 3.23.32 currently installed. Thanks, 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 -- Nicole Lallande [EMAIL PROTECTED] 760.753.6766 - Before posting, please check: http://www.mysql.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: mysql/php problem.
Besides providing us with samples of your code, did you try viewing the source code? Error messages aren't always displayed on the web page itself and you'll have to view the source code to find the error. - Original Message - From: Stephanie Deville [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 25, 2001 21:37 Subject: mysql/php problem. I'm running FreeBSD 3.4, Apache 1.3.9 w/ php4 and mysql 3.22.32. The problem I'm having is that my php scripts work fine, mysql works fine. When I run a php script, everthing in the script works up to the point were I try mysql_connect. I get no error, but the script just hangs. It never connects to the database. I've looked through all my logs, and there are no errors listed anywhere. Any ideas? Stephanie DeVille - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
[cannot load program ./bin/my_print_defaults]
Description: Upon installation of mysql on aix-rs6000 we are getting the following errors: exec(): 0509-036 Cannot load program ./bin/mysql because of the following errors : 0509-150 Dependent module libz.a(shr.o) could not be loaded. 0509-022 Cannot load module libz.a(shr.o). 0509-026 System error: A file or directory in the path name does not exist. How-To-Repeat: In order to reproduce the problem all I have to do is try and run the mysql executable. Fix: I don't know how to correct the problem, however I know that we're running aix4.3.3.0 and this should not be occurring Submitter-Id: submitter ID Originator: jack garivaldis Organization: FTID Australia Share Trading information database MySQL support: [none | licence | email support | extended email support ] Synopsis: Unable to find libc libraries Severity: Priority: Category: mysql Class: Release: mysql-3.23.38 (Official MySQL binary) Environment: rs6000, aix, target, libraries (multiple lines) System: AIX iex2 3 4 000D05DD4C00 Some paths: /usr/local/bin/perl /usr/bin/make /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/powerpc-ibm-aix4.3.2.0/2.95.2.1/specs gcc version 2.95.2.1 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O3 -mcpu=powerpc -Wa,-many ' CXX='c++' CXXFLAGS='-O3 -mcpu=powerpc -Wa,-many -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 bin bin 19 Oct 02 2000 /lib/libc.a - /usr/ccs/lib/libc.a lrwxrwxrwx 1 bin bin 19 Oct 02 2000 /usr/lib/libc.a - /usr/ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --disable-shared - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Recommedations
On Sun, 27 May 2001 16:27:00 -0700, Nicole Lallande [EMAIL PROTECTED] wrote: Appreciate all the responses, thanks to all :) Mike - if you are familiar try Fishcart - http://fishcart.org/ - here's what I like about it: ease of implementation documentation mailing list support for a very robust PERL shopping cart program go to http://akopia.com/ - this is what minivend finally morphed to - after being purchased by RedHat. Both of these carts work with several dbs including mysql. HTH, Nicole MikeBlezien wrote: Hello All, I hoping someone on the list maybe able to offer some recommendations on a good MySQL backend database shopping cart with advance search features. One of our client's has out-grown their current cart, which using DBM data files. And it would cost too much to port it MySQL. They prefer a Perl written program but are open to PHP if it meets there needs. This would be on UN*X system, a Sun/Solaris server. With MySQL 3.23.32 currently installed. Thanks, 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 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
Re: User privs in mysql
And how did you create the user? What was you command? - Original Message - From: Gordon Stewart [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 27, 2001 7:55 Subject: User privs in mysql hi List I have a database in mysql that has to be used as root user. When I try and use it as normal user (gordon) it complains. I have inserted the user gordon into the mysql database and it has all privs but it still has the problem. I can not even create a database as the user gordon. I have started the safe_mysql as the unix user gordon but this does not seam to help Can someone please help me? Thanks Gordon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Please How can I password protect my database?
By setting the correct file permissions. Usually mysql for both user group and chmod 660. Also, RTFM, especially the security sections. - Original Message - From: Sofiane Sakhri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, May 26, 2001 19:11 Subject: Please How can I password protect my database? Hello, I use telnet to manage my mysql database, Please How can I password protect my database, or the database directory. Thanx ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.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 privs in mysql
At 12:55 AM +0100 5/27/01, Gordon Stewart wrote: hi List I have a database in mysql that has to be used as root user. When I try and use it as normal user (gordon) it complains. I have inserted the user gordon into the mysql database and it has all privs but it still has the problem. What did the GRANT statement look like that you used for this? I can not even create a database as the user gordon. I have started the safe_mysql as the unix user gordon but this does not seam to help The UNIX user gordon and the MySQL user gordon are distinct and have nothing to do with each other, so this won't help. Can someone please help me? We'd have to see the GRANT statement. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting -up MySql
At 8:26 PM +0530 5/27/01, T.E.Devarajan wrote: Hi, I need some help. I downloaded mysql and when I tried to work , C:\c:\mysql\bin\mysqld the foll message appears. Can't initialize InnoDB as 'innodb_data_file_path' is not set Pl help to get going. I need advise right from the stage where I have got the Windows version of mysql downloaded and would like to proceed further. Thanks, Devarajan. http://www.mysql.com/doc/W/i/Windows_installation.html says: NOTE: If you want to use InnoDB tables, there are certain startup options that must be specified in your `my.ini' file! See section 8.7.2 InnoDB startup options. Section 8.7.2 is http://www.mysql.com/doc/I/n/InnoDB_start.html - have a look at it. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Do I need special libraries to write C++ client programs
At 8:04 PM +0100 5/27/01, David Ayliffe wrote: I'm following the exmple in the book MySQL by Paul DeBous (chapter 6 The MySQl C API page 225). I am getting an error about Too many types in declaration You show your program below, but it would probably be good to give us some idea where this error occurs. Do I need to download any special libraries - currently I am using the ones in the mysql-3.23.38a-win-src.zip file (mysql.h, mysql_com.h, mysql_version.h) // Program: Client proggie to connect to mysql server. Server options are // specified by the user // Aim: To retrieve data from table specified by user in microsoft access format // and insert the table into a microsoft access database of the users choice // // Command line version of the program currently being investigated // i.e. c:\this_proggie -h host -u user -p pass -po port // // Start of development: 24th May 2001 // Date modified: 27th May 2001 // Author: David Ayliffe // Version: 0.1 #include stdio.h #include iostream.h // libraries included in the linked (object) file #include conio.h #include mysql.h // include the mysql libraries copied from the win // source download #define def_host_name NULL /*host to connect to (default localhost) */ #define def_user_name NULL /*user name for the database (default login name) */ #define def_password NULL /*password for the database (default is null) */ #define def_db_name NULL /*default database (default database default none) */ #define def_svr_port NULL /*port to connect to (defualt 3306) */ MYSQL *conn; /*pointer to the connection handle */ int main () { /* clrscr(); cout Enter the host name (default localhost): ; cin def_host_name; cout Enter the user name (default root): ; cin def_user_name; cout Enter the password (default blank): ; cin def_password; cout Enter the database name (default none): ; cin def_db_name; cout Enter the port (default 3306): ; cin def_db_name; */ // the real work starts here conn = mysql_init (NULL); mysql_real_connect ( conn, // pointer to connection handle def_host_name, // host to connect to def_user_name, // user name to connect as def_password, // password to use def_db_name, // database to use def_svr_port, // port to connect through NULL, // socket 0);// flags mysql_close (conn); return 0; } Thanks lots David Ayliffe ([EMAIL PROTECTED]) -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL network interface
At 9:44 AM +0200 5/26/01, [EMAIL PROTECTED] wrote: hi list, I have mysql installed on SuSE 7.0 box with 2 network interfaces and I want port 3306 to be opened only on one of them (internal). Is there any options in mysql configuration to achieve this? Run mysqld --help to see mysqld's options. The one you want is --bind-address. thank you, -- [EMAIL PROTECTED] -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compilation problems.
At 8:46 PM -0400 5/26/01, Nicu Popovici wrote: Hello Sinisa, I managed to get a connection to a database but now when I want to try to make a query on that database I have to use strmov() function defined in m_string.h but at compilation time I get the following errors. JUST BECAUSE I INCLUDED m_string.h into my file Did you also include any other include files on which m_string.h might depend? For instance, line 93 uses the NEAR symbol, which is defined in global.h. If you didn't include global.h before m_string.h, you will of course have problems. gcc -g Bug_Report.c -o first.o -L/usr/lib/mysql -I/usr/include/mysql/ -lmysqlclient In file included from Bug_Report.c:3: /usr/include/mysql/m_string.h:93: parse error before `_dig_vec' /usr/include/mysql/m_string.h:93: warning: data definition has no type or storage class /usr/include/mysql/m_string.h:149: parse error before `pchar' /usr/include/mysql/m_string.h:151: parse error before `pchar' /usr/include/mysql/m_string.h:154: parse error before `s' /usr/include/mysql/m_string.h:156: parse error before `my_string' /usr/include/mysql/m_string.h:169: parse error before `_VARARGS' /usr/include/mysql/m_string.h:170: parse error before `_VARARGS' /usr/include/mysql/m_string.h:171: parse error before `_VARARGS' /usr/include/mysql/m_string.h:172: parse error before `_VARARGS' /usr/include/mysql/m_string.h:173: parse error before `_VARARGS' /usr/include/mysql/m_string.h:174: parse error before `_VARARGS' /usr/include/mysql/m_string.h:209: parse error before `value' /usr/include/mysql/m_string.h:93: warning: array `_dig_vec' assumed to have one element Maybe you have some ideeas . Thank you Nicu Sinisa Milivojevic wrote: Nicu Popovici writes: Hi Sinisa, I get another error now. It seems that I managed to pass by that error. Here it is what I get now: -- Failed to connect to database! Error Protocol mismatch. Server Version = 10 Client Version = 9 ; -- What shall I do ? Regards, Nicu Get a newer libmysqlclient version. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: $dbh-tables, SHOW tables, etc.
I am using mysql 3.23.xx on linux 6.2. I have been use gcc 2.91. I can use show database and show table in mysql prompt. I wonder that why did you cannot use these function and must upgrade gcc. Sommai Fongnamthip. At 11:10 26/5/2001 +, Greg Cope wrote: Daniel wrote: Scratch that, normally egcs and gcc are the same, at least on older redhat distros. Redhat 7.0 gives you compat-egcs package which isn't the same as your gcc. I symlinked (on a 7.1 redhat box) egcs to gcc (2.96-69) and --rebuild 3.23.38 from the .src.rpm. Both show tables, show databases now work. I come across this problem - and its complier / optimisations related. gcc 2.92.3 + pgcc patches works OK for me. 2.92.3 plus optimisations is can fail. YMMY - but ditch 2.96 until its safe ! Greg Thanks for the heads up Colin. Daniel wrote: I'm up to 3.23.37-1 (compiled with gcc 2.96-69). Haven't had one work properly starting with 3.23.32. Gulp...It's been months now. Thanks for the reply though, -- Daniel Bohling NewsFactor Network - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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