Free webinar about MySQL problem diagnosis
I'll present a free webinar today about troubleshooting intermittent MySQL problems. These are often hard to pin down because they happen when you're not looking, so you can't reliably determine the symptoms or the cause. I've created some free tools (part of Percona Toolkit) to make this process much more efficient, and I'll explain how to use the tools to help gather the information needed for a good diagnosis. I'll show some real case studies from the hundreds of customer problems solved with this process and toolset. http://oreillynet.com/pub/e/2216 Friday, May 4, 2012 10AM PT, San Francisco 6pm - London | 1pm - New York | Sat, May 5th at 3am - Sydney | Sat, May 5th at 2am - Tokyo | Sat, May 5th at 1am - Beijing | 10:30pm - Mumbai -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Free webinar about MySQL problem diagnosis
Thanks Baron! Very much valuable! Looking forward for it! Claudio 2012/5/4 Baron Schwartz ba...@xaprb.com I'll present a free webinar today about troubleshooting intermittent MySQL problems. These are often hard to pin down because they happen when you're not looking, so you can't reliably determine the symptoms or the cause. I've created some free tools (part of Percona Toolkit) to make this process much more efficient, and I'll explain how to use the tools to help gather the information needed for a good diagnosis. I'll show some real case studies from the hundreds of customer problems solved with this process and toolset. http://oreillynet.com/pub/e/2216 Friday, May 4, 2012 10AM PT, San Francisco 6pm - London | 1pm - New York | Sat, May 5th at 3am - Sydney | Sat, May 5th at 2am - Tokyo | Sat, May 5th at 1am - Beijing | 10:30pm - Mumbai -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Claudio
mysql problem
Hello people,
I do not know if this the right listI am migrating a very basic application
from an older mysql version 4.1.9-standard to a new mysql version 5.0.45
{RedHat default package}. I have migrated DB data from one to the other and all
data seems to be there including the structureMy problem is that I run a
query like this :
SELECT x.application_name, y.role_name FROM application x, role y JOIN
logical_app_role_link l ON x.application_id = l.application_id AND y.role_id =
l.role_id WHERE l.logical_id = 15;
It works for the old mysql version but for the new mysql version I receive the
following error :
ERROR 1054 (42S22): Unknown column 'x.application_id' in 'on clause'
and I am sure that application_id exists in table application.
Thanks
konrad
Les informations contenues dans ce message et/ou ses annexes sont
reservees a l'attention et a l'utilisation de leur destinataire et peuvent etre
confidentielles. Si vous n'etes pas destinataire de ce message, vous etes
informes que vous l'avez recu par erreur et que toute utilisation en est
interdite. Dans ce cas, vous etes pries de le detruire et d'en informer la
Banque Europeenne d'Investissement.
The information in this message and/or attachments is intended solely for
the attention and use of the named addressee and may be confidential. If
you are not the intended recipient, you are hereby notified that you have
received this transmittal in error and that any use of it is prohibited. In
such a case please delete this message and kindly notify the European
Investment Bank accordingly.
Re: mysql problem
AZZOPARDI Konrad wrote:
Hello people,
I do not know if this the right listI am migrating a very basic application from an older mysql version 4.1.9-standard to a new mysql version 5.0.45 {RedHat default package}. I have migrated DB data from one to the other and all data seems to be there including the structureMy problem is that I run a query like this :
SELECT x.application_name, y.role_name FROM application x, role y JOIN logical_app_role_link l ON x.application_id = l.application_id AND y.role_id = l.role_id WHERE l.logical_id = 15;
It works for the old mysql version but for the new mysql version I receive the
following error :
ERROR 1054 (42S22): Unknown column 'x.application_id' in 'on clause'
and I am sure that application_id exists in table application.
Thanks
konrad
Don't mix implicit and explicit joins.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql problem
Konrad,
AZZOPARDI Konrad schrieb:
Hello people,
I do not know if this the right listI am migrating a very basic application from an older mysql version 4.1.9-standard to a new mysql version 5.0.45 {RedHat default package}. I have migrated DB data from one to the other and all data seems to be there including the structureMy problem is that I run a query like this :
SELECT x.application_name, y.role_name FROM application x, role y JOIN logical_app_role_link l ON x.application_id = l.application_id AND y.role_id = l.role_id WHERE l.logical_id = 15;
It works for the old mysql version but for the new mysql version I receive the
following error :
ERROR 1054 (42S22): Unknown column 'x.application_id' in 'on clause'
and I am sure that application_id exists in table application.
read the upgrading instructions and pay special attention
to http://dev.mysql.com/doc/refman/5.0/en/join.html,
Join Processing Changes in MySQL 5.0.12.
Best to avoid this issue is to not mix implicit and
explicit joins, as Gerald pointed out.
Ciao,
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: zabbix mysql problem
You might need to backup a few chapters. Thanks a lot man atleast now I know what to look into. On 12/06/07, Gerald L. Clark [EMAIL PROTECTED] wrote: sizo nsibande wrote: I am trying to install zabbix, and at the third step I get this error: [EMAIL PROTECTED] etc]# mysql -u zabbix -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 5.0.27 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database zabbix; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'zabbix' mysql I am reading the mysql in 21 days book and hope to become more knowledgeable on this subject, please point me in the right direction? You are not looged in to mysql as a user with create privileges. You might need to backup a few chapters. -- Gerald L. Clark Supplier Systems Corporation -- Communication is not just english grammaer and literature, but a well established database between people that have come to know each other! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
zabbix mysql problem
I am trying to install zabbix, and at the third step I get this error: [EMAIL PROTECTED] etc]# mysql -u zabbix -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 5.0.27 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database zabbix; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'zabbix' mysql I am reading the mysql in 21 days book and hope to become more knowledgeable on this subject, please point me in the right direction? -- Communication is not just english grammaer and literature, but a well established database between people that have come to know each other! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: zabbix mysql problem
sizo nsibande wrote: I am trying to install zabbix, and at the third step I get this error: [EMAIL PROTECTED] etc]# mysql -u zabbix -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 5.0.27 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database zabbix; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'zabbix' mysql I am reading the mysql in 21 days book and hope to become more knowledgeable on this subject, please point me in the right direction? You are not looged in to mysql as a user with create privileges. You might need to backup a few chapters. -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql problem
I have a database online and have a strange mysql problem. When I connect remotely from my desktop (same browse_database.php page) I get over 1000 results with the query below but when I run the same page on the remoted server this value is almost halved to 520. any ideas what is hapening? $total_rows = mysql_num_rows(mysql_query(SELECT * FROM $table_name)); It just seems to ignore them on the remote one as I am in under ross and ross2 and only one when I search for me. R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql++ problem(undefined symbol to)
hello. i want to connect to mysql from c++ . i examine any version or platform. i use mysql5 and 4 in suse10 with gcc.then examine mingw and mysql5 and 4 and 3 for severeal times but i can't solve this problem.when i want to compile examples of mysql++ following error appeared: ** custom1.o(.text+0x180):custom1.cpp: undefined reference to `_imp___ZN7mysqlpp10C onnectionC1Eb' custom1.o(.text+0x1ba):custom1.cpp: undefined reference to `connect_to_db(int, c har**, mysqlpp::Connection, char const*)' custom1.o(.text+0x1d6):custom1.cpp: undefined reference to `mysqlpp::Connection: :~Connection()' custom1.o(.text+0x1fd):custom1.cpp: undefined reference to `_imp___ZN7mysqlpp10C onnection5queryEv' custom1.o(.text+0x2ef):custom1.cpp: undefined reference to `print_stock_header(i nt)' custom1.o(.text+0x3fe):custom1.cpp: undefined reference to `print_stock_row(std: :string const, long long, double, double, mysqlpp::Date const)' custom1.o(.text+0x509):custom1.cpp: undefined reference to `mysqlpp::Connection: :~Connection()' custom1.o(.text+0x53b):custom1.cpp: undefined reference to `mysqlpp::Connection: :~Connection()' custom1.o(.text$_ZN7mysqlpp5QueryD1Ev[mysqlpp::Query::~Query()]+0x39):custom1.cp p: undefined reference to `vtable for mysqlpp::Query' custom1.o(.text$_ZN7mysqlpp5QueryD1Ev[mysqlpp::Query::~Query()]+0x48):custom1.cp p: undefined reference to `vtable for mysqlpp::Query' custom1.o(.text$_ZN7mysqlpp5QueryD1Ev[mysqlpp::Query::~Query()]+0x57):custom1.cp p: undefined reference to `vtable for mysqlpp::Query' custom1.o(.text$_ZN7mysqlpp5QueryD1Ev[mysqlpp::Query::~Query()]+0x63):custom1.cp p: undefined reference to `vtable for mysqlpp::Query' custom1.o(.text$_ZN7mysqlpp5QueryD1Ev[mysqlpp::Query::~Query()]+0x21a):custom1.c pp: undefined reference to `VTT for mysqlpp::Query' custom1.o(.text$_ZN7mysqlpp5QueryD1Ev[mysqlpp::Query::~Query()]+0x240):custom1.c pp: undefined reference to `VTT for mysqlpp::Query' custom1.o(.text$_ZN7mysqlpp5Query7storeinISt6vectorI5stockSaIS3_vRT_RNS_13SQ LQueryParmsENS_11query_resetE[void mysqlpp::Query::storeinstd::vectorstock, st d::allocatorstock (std::vectorstock, std::allocatorstock , mysqlpp::SQ LQueryParms, mysqlpp::query_reset)]+0x71):custom1.cpp: undefined reference to ` _imp___ZN7mysqlpp5Query3strERNS_13SQLQueryParmsENS_11query_resetE' custom1.o(.text$_ZN7mysqlpp4DateD1Ev[mysqlpp::Date::~Date()]+0xb):custom1.cpp: u ndefined reference to `vtable for mysqlpp::Date' custom1.o(.text$_ZN7mysqlpp5Query16storein_sequenceISt6vectorI5stockSaIS3_vR T_PKc[void mysqlpp::Query::storein_sequencestd::vectorstock, std::allocatorst ock (std::vectorstock, std::allocatorstock , char const*)]+0x59):custom 1.cpp: undefined reference to `_imp___ZN7mysqlpp5Query3useEPKc' custom1.o(.text$_ZN7mysqlpp5Query16storein_sequenceISt6vectorI5stockSaIS3_vR T_PKc[void mysqlpp::Query::storein_sequencestd::vectorstock, std::allocatorst ock (std::vectorstock, std::allocatorstock , char const*)]+0x85):custom 1.cpp: undefined reference to [EMAIL PROTECTED]' custom1.o(.text$_ZN7mysqlpp5Query16storein_sequenceISt6vectorI5stockSaIS3_vR T_PKc[void mysqlpp::Query::storein_sequencestd::vectorstock, std::allocatorst ock (std::vectorstock, std::allocatorstock , char const*)]+0xb3):custom 1.cpp: undefined reference to [EMAIL PROTECTED]' custom1.o(.text$_ZN7mysqlpp5Query16storein_sequenceISt6vectorI5stockSaIS3_vR T_PKc[void mysqlpp::Query::storein_sequencestd::vectorstock, std::allocatorst ock (std::vectorstock, std::allocatorstock , char const*)]+0xde):custom 1.cpp: undefined reference to `_imp___ZN7mysqlpp3RowC1ERKPPcPKNS_6ResUseEPmb' custom1.o(.text$_ZN7mysqlpp5Query16storein_sequenceISt6vectorI5stockSaIS3_vR T_PKc[void mysqlpp::Query::storein_sequencestd::vectorstock, std::allocatorst ock (std::vectorstock, std::allocatorstock , char const*)]+0x114):custo m1.cpp: undefined reference to `mysqlpp::Row::~Row()' custom1.o(.text$_ZN7mysqlpp5Query16storein_sequenceISt6vectorI5stockSaIS3_vR T_PKc[void mysqlpp::Query::storein_sequencestd::vectorstock, std::allocatorst ock (std::vectorstock, std::allocatorstock , char const*)]+0x1fd):custo m1.cpp: undefined reference to `mysqlpp::Row::~Row()' custom1.o(.text$_ZN7mysqlpp5Query16storein_sequenceISt6vectorI5stockSaIS3_vR T_PKc[void mysqlpp::Query::storein_sequencestd::vectorstock, std::allocatorst ock (std::vectorstock, std::allocatorstock , char const*)]+0x223):custo m1.cpp: undefined reference to `mysqlpp::Row::~Row()' custom1.o(.text$_ZN7mysqlpp5Query16storein_sequenceISt6vectorI5stockSaIS3_vR T_PKc[void mysqlpp::Query::storein_sequencestd::vectorstock, std::allocatorst ock (std::vectorstock, std::allocatorstock , char const*)]+0x249):custo m1.cpp: undefined reference to `mysqlpp::ResUse::~ResUse()'
Re: mysql++ problem(undefined symbol to)
ali asghar torabi parizy wrote: hello. i want to connect to mysql from c++ . i examine any version or platform. i use mysql5 and 4 in suse10 with gcc.then examine mingw and mysql5 and 4 and 3 for severeal times but i can't solve this problem.when i want to compile examples of mysql++ following error appeared: It would be better to ask on the mysql++ list. http://lists.mysql.com/plusplus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bugzilla Installation Mysql problem
Dear All
While installing Bugzilla I am getting following mysql error. In my pc mysql
is running and user 'bugs' is having full privilege for bugs database.
DBI connect(';localhost;3306','bugs',...) failed: Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (111) at checksetup.pl line
1460
Can't connect to the mysql database. Is the database installed and
up and running? Do you have the correct username and password selected in
localconfig?
Pleasae help me out to solve this problem
Regards
Harish Shetty
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bugzilla Installation Mysql problem
Hello.
Maybe it is a Bugzilla specific issue, but have a look here:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
harish [EMAIL PROTECTED] wrote:
Dear All
While installing Bugzilla I am getting following mysql error. In my pc mysql
is running and user 'bugs' is having full privilege for bugs database.
DBI connect(';localhost;3306','bugs',...) failed: Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (111) at checksetup.pl line
1460
Can't connect to the mysql database. Is the database installed and
up and running? Do you have the correct username and password selected in
localconfig?
Pleasae help me out to solve this problem
Regards
Harish Shetty
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Php/Mysql problem - undiefined method mysql_connect()
Hello everyone, I've installed mysql server on my fedora box and it works great when i use the console =) But, i want my php sources to work with these bases but it doesn't work =( In fact it seems that the function mysql_connect() cannot be called, here is the error on the web page : Fatal error: Call to undefined function: mysql_connect() in /var/www/html/TechUnix/include/connexion.php on line 10 So i checked google and found out that a special rpm was needed .. so i've looked for it and when i try to install it, it tells me that : [EMAIL PROTECTED] dl]# rpm -ivh php-mysql-4.3.12-alt0.cvs20050406.i586.rpm warning: php-mysql-4.3.12-alt0.cvs20050406.i586.rpm: V3 DSA signature: NOKEY, key ID 68e31e54 error: Failed dependencies: libMySQL is needed by php-mysql-4.3.12-alt0.cvs20050406.i586 php-libs = 1:4.3.12-alt0.cvs20050406 is needed by php-mysql-4.3.12-alt0.cvs20050406.i586 libmysqlclient.so.12 is needed by php-mysql-4.3.12-alt0.cvs20050406.i586 So i tried : [EMAIL PROTECTED] dl]# rpm -ivh libMySQL-3.23.55-alt1.i586.rpm warning: libMySQL-3.23.55-alt1.i586.rpm: V3 DSA signature: NOKEY, key ID eac91ca0 error: Failed dependencies: /sbin/postun_ldconfig is needed by libMySQL-3.23.55-alt1.i586 :( the only thing i know is [EMAIL PROTECTED] dl]# rpm -qa |grep mysql mysql-3.23.58-13 libdbi-dbd-mysql-0.6.5-9 mysql-devel-3.23.58-13 mysql-server-3.23.58-16.FC3.1 [EMAIL PROTECTED] dl]# I'm quite a newby and do not really understand how i can install this pakage if someone could help ...^^ (I run a fedora Core 3)
Re: PHP/MySQL Problem
Are you running the 2 queries at the same time? they should be run 1 at
a time. What does mysql_error() say? use it when you are checking the
result set (if (!$result) { echo Error: . mysql_error();}Are the
result sets being sent to 2 different identifiers? Just a few
possibilities.
Respectfully,
Ligaya Turmelle
Yahoo Default User wrote:
Hi Guys,
I have a problem with MySQL in conjunction with PHP so
I also decided to post here:
I have a PHP script that contains two consecutive
MySQL queries, something like this:
Query 1: Delete some rows from Table A
Query 2: Insert some rows into Table A
The problem is, only Query 2 seems to be executed.
Query 1 is not executed at all.
I tried running the script with only Query 1 and it
worked. However, when I put back Query 2, then the
problem comes back.
What can be causing this problem? How do I solve this
problem? Any help would be appreciated. Thanks!
__
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP/MySQL Problem
Hi Guys, I have a problem with MySQL in conjunction with PHP so I also decided to post here: I have a PHP script that contains two consecutive MySQL queries, something like this: Query 1: Delete some rows from Table A Query 2: Insert some rows into Table A The problem is, only Query 2 seems to be executed. Query 1 is not executed at all. I tried running the script with only Query 1 and it worked. However, when I put back Query 2, then the problem comes back. What can be causing this problem? How do I solve this problem? Any help would be appreciated. Thanks! __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: PHP/MySQL Problem
when asking a question, it always helpful to post you code/queries so we can see what is happening. but tbh, this sounds like it's a php code problem. you have established that both queries work, on there own I'm don't know anything about php, but it sounds like you are not executing the first query you might have more luck if you post your php code to a php group chris -Original Message- From: Yahoo Default User [mailto:[EMAIL PROTECTED] Sent: 05 November 2004 08:52 To: [EMAIL PROTECTED] Subject: PHP/MySQL Problem Hi Guys, I have a problem with MySQL in conjunction with PHP so I also decided to post here: I have a PHP script that contains two consecutive MySQL queries, something like this: Query 1: Delete some rows from Table A Query 2: Insert some rows into Table A The problem is, only Query 2 seems to be executed. Query 1 is not executed at all. I tried running the script with only Query 1 and it worked. However, when I put back Query 2, then the problem comes back. What can be causing this problem? How do I solve this problem? Any help would be appreciated. Thanks! __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP/MySQL Problem
Hi. How did you check that Query 2 has been executed? You may add to your php.ini file mysql.trace_mode = On to see some warnings and errors. Yahoo Default User [EMAIL PROTECTED] wrote: Hi Guys, I have a problem with MySQL in conjunction with PHP so I also decided to post here: I have a PHP script that contains two consecutive MySQL queries, something like this: Query 1: Delete some rows from Table A Query 2: Insert some rows into Table A The problem is, only Query 2 seems to be executed. Query 1 is not executed at all. I tried running the script with only Query 1 and it worked. However, when I put back Query 2, then the problem comes back. What can be causing this problem? How do I solve this problem? Any help would be appreciated. Thanks! __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ask for help on a mysql problem
Egor, others, It's really clear what you want. Please specify. If what you basicaly want is just a tree structure, then it's done like that: CREATE TABLE something ( id INT AUTO_INCREMENT PRIMARY KEY NOT NULL, parent INT NOT NULL, data1 CHAR(255), data2 CHAR(255), ... ); Then you can specify the parent node id for each record in database. This is how tree-like structures are stored in SQL. Hope that helps. That is ONE way to store a tree structure :-) Another would be: ITEMS (ItemID INT AUTO_INCREMENT PRIMARY KEY NOT NULL, other stuff) ITEM_PARENT (ItemID int, ParentID int primary key (ItemID, ParentID) ) I prefer the latter. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ask for help on a mysql problem
Hello, The only difference is that you have moved parent outside main table. No benefits at all. You have to create two records I two tables instead of one. You have to make joins to see what is the parent of particular child. I am strongly against this. Why? 1) relational theory clearly states you should store what is TRUE (this means: no NULLs). Obviously, people are used to NULLs, but this doesn't make them right. 2) there's nothing wrong with joins 3) there's nothing wrong with multiple inserts 4) you avoid self-joins, which can be tedious to write. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com It's really clear what you want. Please specify. If what you basicaly want is just a tree structure, then it's done like that: CREATE TABLE something ( id INT AUTO_INCREMENT PRIMARY KEY NOT NULL, parent INT NOT NULL, data1 CHAR(255), data2 CHAR(255), ... ); Then you can specify the parent node id for each record in database. This is how tree-like structures are stored in SQL. Hope that helps. That is ONE way to store a tree structure :-) Another would be: ITEMS (ItemID INT AUTO_INCREMENT PRIMARY KEY NOT NULL, other stuff) ITEM_PARENT (ItemID int, ParentID int primary key (ItemID, ParentID) ) I prefer the latter. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ask for help on a mysql problem
In article [EMAIL PROTECTED], Martijn Tonies [EMAIL PROTECTED] writes: That is ONE way to store a tree structure :-) Another would be: ITEMS (ItemID INT AUTO_INCREMENT PRIMARY KEY NOT NULL, other stuff) ITEM_PARENT (ItemID int, ParentID int primary key (ItemID, ParentID) ) I prefer the latter. The latter is not a tree, but a directed graph. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ask for help on a mysql problem
That is ONE way to store a tree structure :-) Another would be: ITEMS (ItemID INT AUTO_INCREMENT PRIMARY KEY NOT NULL, other stuff) ITEM_PARENT (ItemID int, ParentID int primary key (ItemID, ParentID) ) I prefer the latter. The latter is not a tree, but a directed graph. A rooted tree is a special kind of directed graph. Besides, I wonder if you can fully store a graph in these tables (with the PK and all) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ask for help on a mysql problem
Teng, how is this different than a foreign key? On Oct 14, 2004, at 11:27 PM, Teng Wang wrote: I wanna setup a tree structure. Each node in this tree is a table. Each table has a link field. For each record, the data in this field is a pointer to another table or null. I read mysql manual but don't find any clues that SQL supports such a link field. Does anyone has an idea about that? Thanks a lot! eruisi 10/14/2004 23:26:58 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ask for help on a mysql problem
I wanna setup a tree structure. Each node in this tree is a table. Each table has a link field. For each record, the data in this field is a pointer to another table or null. I read mysql manual but don't find any clues that SQL supports such a link field. Does anyone has an idea about that? Thanks a lot! eruisi 10/14/2004 23:26:58 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DBD::mysql problem
I am unable to install DBD::mysql in my environment shown below RedHat Linux 9 perl v5.8.0 DBI-1.42 mysqld Ver 4.0.18-standard After unzipping and untarring the DBD-mysql-2.9003.tar.gz ( obtained from CPAN ), in the DBD-mysql-2.9003 directory I tried the following mkdir /tmp/mysql-static cp /usr/lib/mysql/*.a /tmp/mysql-static perl Makefile.PL --libs=-L/tmp/mysql-static -lmysqlclient make It fails. When I looked at the Makefile created by 'perl Makefile.PL ..' command, I find there are lines that cause make to fail Mostly they are constants that are not properly quoted. Is there a proper tar.gz file that I can use in my ( RH Linux 9) environment stated above that someone was able to successfully install? Is it possible I am trying to use a version of DBD with wrong versions of Linux, perl and MySql individually or when used together as above ? Any advice or help will be very much appreciated. Thanks Raj Kairam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DBD::mysql problem
I am unable to install DBD::mysql in my environment shown below RedHat Linux 9 perl v5.8.0 DBI-1.42 mysqld Ver 4.0.18-standard After unzipping and untarring the DBD-mysql-2.9003.tar.gz ( obtained from CPAN ), in the DBD-mysql-2.9003 directory I tried the following mkdir /tmp/mysql-static cp /usr/lib/mysql/*.a /tmp/mysql-static perl Makefile.PL --libs=-L/tmp/mysql-static -lmysqlclient make It fails. When I looked at the Makefile created by 'perl Makefile.PL ..' command, I find there are lines that cause make to fail Mostly they are constants that are not properly quoted. Is there a proper tar.gz file that I can use in my ( RH Linux 9) environment stated above that someone was able to successfully install? Any advice or help will be very much appreciated. Thanks Raj Kairam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DBD::mysql problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 03:00 pm, Kairam, Raj wrote: After unzipping and untarring the DBD-mysql-2.9003.tar.gz ( obtained from CPAN ), in the DBD-mysql-2.9003 directory I tried the following mkdir /tmp/mysql-static cp /usr/lib/mysql/*.a /tmp/mysql-static perl Makefile.PL --libs=-L/tmp/mysql-static -lmysqlclient make Some reason your not using the DBD rpm? You probably don't have all the header files. You didn't send the error message or I would tell you what header files to install. - -- Sorry if I looked interested. I'm not. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFA06GZld4MRA3gEwYRAgK1AJ4txXzJw0Kb57OgQM7YLXWXjlA0XwCfQQud FxUBSbovN99ZYiJxaOC2pMk= =Onoz -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
php mysql problem
I have redhat 9.0 and Server version: Apache/2.0.40. i have installed rpms php-4.2.2-17.2.i386.rpm php-mysql-4.2.2-17.2.i386.rpm After i create a database called mydb and serveral tables in mysql, I tried to run following testdb.php script -- html body ?php $db = mysql_connect(localhost, root,xx); mysql_select_db(mydb,$db); $result = mysql_query(SELECT * FROM employees,$db); printf(First Name: %sbr\n, mysql_result($result,0,first)); printf(Last Name: %sbr\n, mysql_result($result,0,last)); printf(Address: %sbr\n, mysql_result($result,0,address)); printf(Position: %sbr\n, mysql_result($result,0,position)); ? /body /html --- but i got error message with: http://coopunit.forestry.uga.edu:8080/testdb.php the error is: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/testdb.php on line 13 How can Fix this problem? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: php mysql problem
From: Jianping Zhu [mailto:[EMAIL PROTECTED] but i got error message with: http://coopunit.forestry.uga.edu:8080/testdb.php the error is: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/testdb.php on line 13 How can Fix this problem? Thanks Sounds as though PHP was installed without the MySQL library. I haven't done it myself in a while, but I believe it requires the --with-mysql flag. HTH -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access to MySQL problem
I'm coverting an Access database to MySQL 4.1.1 and I need help with a near impossible query. In the Access DB I used a stored procedure; I think I should be able to solve this problem with a subselect in MySQL but so far I'm not having any luck. Here's the problem; In my stored precedure query I get results that look like this Item OpUser 2751 2 Dude 2751 3 Aguy 4785 1 Dude 4785 2 Gus 5623 1 Dude 5623 2 Gus 5654 1 Gus 5654 2 Aguy I then query these results to get only the Items for a user when the specified user is the first person for that Item ID, for example. If I query the results for Dude Items 2751, 4785 5623 are returned. If I query the results for Gus Item 5654 are return but not Items 4785 or 5623. If I query the results for Aguy no Items are returned. Does anyone have any thoughts on this? Thanks
Mysql problem + Problem in loading data SOLVED
Well pals, Today I am not writing this message to bother you with my problems but to pass my warmest thanx to you guys all. Duncan, Peter , Mike, Cory ... I appreciate your time and energy in solving the problems I faced on the above subject. Special thanx to Duncan for his precise and priceless comments, think he knows what he is doing. Thank again all, Cheers, Aron Bereket __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL problem
Hi there, I have recently installed mysql and php on my mechine and both work fine. But when i wrote an HTML/Php to access my databse I got the following error message: Fatal error: Call to undefined function: mysql_pconnect() in /var/www/html/employee.php on line 48 I tried also with mysql_real_connect() and mysql_connect() functions bud didn't solve the problem. Does it mean that the mysql_pconnect() doesn't exitst or is some configuration problem? Your help is appriciated. cheers, Bereket L __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MYSQL problem
From: Aron Bereket [mailto:[EMAIL PROTECTED] Hi there, I have recently installed mysql and php on my mechine and both work fine. But when i wrote an HTML/Php to access my databse I got the following error message: Fatal error: Call to undefined function: mysql_pconnect() in /var/www/html/employee.php on line 48 I tried also with mysql_real_connect() and mysql_connect() functions bud didn't solve the problem. Does it mean that the mysql_pconnect() doesn't exitst or is some configuration problem? Your help is appriciated. Are you sure the MySQL API was compiled with your install of PHP? Create a test script and just put the following in it: ? phpinfo() ? Then view that in your web browser. Near the top should be a header Configure Command -- does it include an appropriate --with-mysql=xxx argument? If that checks out, scroll further down to view information about PHP's planned interactions with MySQL. HTH! -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MYSQL problem
Thanx for the quick reply peter. That of one of the things I did when I had the problem. It was not enabled. But when I enable it it gave me mysql.so doesn't exits. I checked it on the path there is not mysql.so. cheers, Bereket --- Peter Lovatt [EMAIL PROTECTED] wrote: check your php.ini to make sure the mysql extensions are enabled. Peter -Original Message- From: Aron Bereket [mailto:[EMAIL PROTECTED] Sent: 13 January 2004 23:36 To: [EMAIL PROTECTED] Subject: MYSQL problem Hi there, I have recently installed mysql and php on my mechine and both work fine. But when i wrote an HTML/Php to access my databse I got the following error message: Fatal error: Call to undefined function: mysql_pconnect() in /var/www/html/employee.php on line 48 I tried also with mysql_real_connect() and mysql_connect() functions bud didn't solve the problem. Does it mean that the mysql_pconnect() doesn't exitst or is some configuration problem? Your help is appriciated. cheers, Bereket L __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Peter Lovatt [EMAIL PROTECTED] wrote: check your php.ini to make sure the mysql extensions are enabled. Peter -Original Message- From: Aron Bereket [mailto:[EMAIL PROTECTED] Sent: 13 January 2004 23:36 To: [EMAIL PROTECTED] Subject: MYSQL problem __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MYSQL problem
Dear Mike, Thanx for the quick reply. I did what you specified on your rely. There is --with-mysql argument but is not set it is just '--with-mysql' does it mean I have to recompile it again? cheers, Bereket --- Mike Johnson [EMAIL PROTECTED] wrote: From: Aron Bereket [mailto:[EMAIL PROTECTED] Hi there, I have recently installed mysql and php on my mechine and both work fine. But when i wrote an HTML/Php to access my databse I got the following error message: Fatal error: Call to undefined function: mysql_pconnect() in /var/www/html/employee.php on line 48 I tried also with mysql_real_connect() and mysql_connect() functions bud didn't solve the problem. Does it mean that the mysql_pconnect() doesn't exitst or is some configuration problem? Your help is appriciated. Are you sure the MySQL API was compiled with your install of PHP? Create a test script and just put the following in it: ? phpinfo() ? Then view that in your web browser. Near the top should be a header Configure Command -- does it include an appropriate --with-mysql=xxx argument? If that checks out, scroll further down to view information about PHP's planned interactions with MySQL. HTH! -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql Problem...
Hello All, When I try to execute query on mysql prompt I get following error before the query is been executed. MySql is running. mysql select * from temp where username='tom' and ondate='2002-02-03'; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id: 515854 Current database: tom_tomy Any suggestions would be appreciated. Thank you, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Problem...
Did you stop and restart the server while you had the client up? This will break the client's connection and force it to try and re-establish it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Zeos, MySQL problem
Hi David, for Zeos questions check: http://www.zeoslib.net/modules.php?name=Forums regards Michael Daheim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Zeos, MySQL problem
Good Afternoon! We're building an application with Delphi 7.0, the Zeos controls and MySQL v.4.0.15 which runs on a Red Hat 7.3 server. We are experiencing a problem where when a person lets the application sit for a while, we're losing dataset connectivity that doesn't restore itself. I've been studying the documentation and I'm not finding any settings that would stop the timeout from happening. If anyone is aware of what to change, or has experienced the same problem, please let me know. BTW, I wasn't sure that this would be the place to post this sort of question and would appreciate some guidance where I should go instead if necessary. Thanks! David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
RE: Zeos, MySQL problem
You can disable connection timeouts at the MySQL server level. You should check the docs to be sure, but I think the relevant variable is wait_timeout -- setting it to 0 should disable connection timeouts. -JF -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 12:28 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Zeos, MySQL problem Good Afternoon! We're building an application with Delphi 7.0, the Zeos controls and MySQL v.4.0.15 which runs on a Red Hat 7.3 server. We are experiencing a problem where when a person lets the application sit for a while, we're losing dataset connectivity that doesn't restore itself. I've been studying the documentation and I'm not finding any settings that would stop the timeout from happening. If anyone is aware of what to change, or has experienced the same problem, please let me know. BTW, I wasn't sure that this would be the place to post this sort of question and would appreciate some guidance where I should go instead if necessary. Thanks! David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Zeos, MySQL problem
Thanks, Jon. I'll try that and report back. -Original Message- From: Jon Frisby [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 3:06 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Zeos, MySQL problem You can disable connection timeouts at the MySQL server level. You should check the docs to be sure, but I think the relevant variable is wait_timeout -- setting it to 0 should disable connection timeouts. -JF -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 12:28 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Zeos, MySQL problem Good Afternoon! We're building an application with Delphi 7.0, the Zeos controls and MySQL v.4.0.15 which runs on a Red Hat 7.3 server. We are experiencing a problem where when a person lets the application sit for a while, we're losing dataset connectivity that doesn't restore itself. I've been studying the documentation and I'm not finding any settings that would stop the timeout from happening. If anyone is aware of what to change, or has experienced the same problem, please let me know. BTW, I wasn't sure that this would be the place to post this sort of question and would appreciate some guidance where I should go instead if necessary. Thanks! David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Re: Mysql Problem in Windows 2000 advanced server
At 12:33 25/9/2003 +0900, Ganbold wrote: Hi, I installed mysql-4.0.15 in Windows 2000 Advanced server. Mysql-max-nt is working fine, except some problems. Sometimes when I try to use access web pages through php pages, mysql says Connection to server lost or Can't connect to mysql server or sometimes query error. Query is tested and works fine most of the time. And when I refresh web page again everything works fine. Mysql log says nothing. Is it problem related to mysql in Windows? Also I tested small C program to query mysql tables and it sometimes hangs. Is there any solution for this kind of problem? From the mysql.exe client: (C) Copyright 1985-2000 Microsoft Corp. c:\c:\mysql\bin\mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.15-max-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show variables like %timeout%; +--+---+ | Variable_name| Value | +--+---+ | connect_timeout | 5 | | delayed_insert_timeout | 300 | | innodb_lock_wait_timeout | 50| | interactive_timeout | 28800 | | net_read_timeout | 30| | net_write_timeout| 60| | slave_net_timeout| 3600 | | wait_timeout | 28800 | +--+---+ 8 rows in set (0.01 sec) You can see above the net_read_timeout and net_write_timeout, if you are having queries that takes more than 30 seconds the server disconnect the client because the client remains passive and that time exceeds the net_read_timeout. From 4.0.15 was introduced for socket time outs that before on Windows didn't worked. So try to configure your server starting it with a more high value than the default according with the necessities. However, when retrieved with a client 4.0.15 the above don't works, please read: http://bugs.mysql.com/bug.php?id=1370 for further details and follow up. -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Problem in Windows 2000 advanced server
Thanks Miguel. I increased net_read_timeout and net_write_timout up to 300 sec, but problem still exists. My queries are executing only in few seconds, but sometimes mysql shows Can't connect to server, or Connection lost etc. I used mysql-4.0.14 server and client, but problem was same and I upgraded to mysql-4.0.15. Probably running mysql in Windows is not great as in Lunux/FreeBSD. It seems like it is better to switch into Linux/FreeBSD. Ganbold At 07:44 PM 9/25/2003 -0300, you wrote: At 12:33 25/9/2003 +0900, Ganbold wrote: Hi, I installed mysql-4.0.15 in Windows 2000 Advanced server. Mysql-max-nt is working fine, except some problems. Sometimes when I try to use access web pages through php pages, mysql says Connection to server lost or Can't connect to mysql server or sometimes query error. Query is tested and works fine most of the time. And when I refresh web page again everything works fine. Mysql log says nothing. Is it problem related to mysql in Windows? Also I tested small C program to query mysql tables and it sometimes hangs. Is there any solution for this kind of problem? From the mysql.exe client: (C) Copyright 1985-2000 Microsoft Corp. c:\c:\mysql\bin\mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.15-max-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show variables like %timeout%; +--+---+ | Variable_name| Value | +--+---+ | connect_timeout | 5 | | delayed_insert_timeout | 300 | | innodb_lock_wait_timeout | 50| | interactive_timeout | 28800 | | net_read_timeout | 30| | net_write_timeout| 60| | slave_net_timeout| 3600 | | wait_timeout | 28800 | +--+---+ 8 rows in set (0.01 sec) You can see above the net_read_timeout and net_write_timeout, if you are having queries that takes more than 30 seconds the server disconnect the client because the client remains passive and that time exceeds the net_read_timeout. From 4.0.15 was introduced for socket time outs that before on Windows didn't worked. So try to configure your server starting it with a more high value than the default according with the necessities. However, when retrieved with a client 4.0.15 the above don't works, please read: http://bugs.mysql.com/bug.php?id=1370 for further details and follow up. -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql Problem in Windows 2000 advanced server
Hi, I installed mysql-4.0.15 in Windows 2000 Advanced server. Mysql-max-nt is working fine, except some problems. Sometimes when I try to use access web pages through php pages, mysql says Connection to server lost or Can't connect to mysql server or sometimes query error. Query is tested and works fine most of the time. And when I refresh web page again everything works fine. Mysql log says nothing. Is it problem related to mysql in Windows? Also I tested small C program to query mysql tables and it sometimes hangs. Is there any solution for this kind of problem? The following is the my.ini file: - [mysqld] skip-locking set-variable = connect_timeout=30 set-variable = net_retry_count=100 set-variable= key_buffer=384M set-variable= max_allowed_packet=1M set-variable= table_cache=3M set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=8 set-variable= thread_concurrency=8 set-variable= myisam_sort_buffer_size=64M server-id = 1 set-variable= max_connections=5000 set-variable= query_cache_size=8M set-variable= query_cache_limit=8M set-variable= thread_cache_size=2M basedir=D:/mysql datadir=D:/mysql/data log=general.log log-update=update.log myisam-recover=FORCE [WinMySQLadmin] Server=D:/mysql/bin/mysqld-max-nt.exe user=root password=xxx - thanks in advance, Ganbold -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ODBC connection to MySQL problem
Hi, nbsp; nbsp; nbsp; nbsp; nbsp; nbsp; nbsp; nbsp; nbsp; nbsp; nbsp; nbsp; Problems: [MYSQL][ODBC 3.51 driver] Client does not support authentication protocol requested by server. Consider upgrading MySQL client. I am facing this problem when i try to add Data Source in User DSN in ODBC. It is fine if i don't put the password setting in MySQL database. But error occurs when i set the password. I am using MySQL4.1-alpha windows. How to solve this problem? Thanks for any help. Yahoo! Games - Who Wants to Be A Millionaire? Play now!
ODBC connection to MySQL problem
Hi, nbsp; nbsp; nbsp; nbsp; nbsp; nbsp; nbsp; nbsp; nbsp; nbsp; nbsp; nbsp; Problems: [MYSQL][ODBC 3.51 driver] Client does not support authentication protocol requested by server. Consider upgrading MySQL client. I am facing this problem when i try to add Data Source in User DSN in ODBC. It is fine if i don't put the password setting in MySQL database. But error occurs when i set the password. I am using MySQL4.1-alpha windows. How to solve this problem? Thanks for any help. Yahoo! Games - Who Wants to Be A Millionaire? Play now!
Very strange MySQL problem !
Hi, I am having a very weird problem with one of my database servers. Let's take the following setup: 10 load-balanced servers (I'll call them ServerA) 1 admin server (ServerB) 1 database server (DB1) Now ServerA has a function to insert a row into a table on DB1 whenever someone hits certain pages (for stats collection). There are probably about 1000 inserts being done per second. ServerB has a script that runs every 20 minutes, which does a very quick/simple select from DB1, then loops though the results and does updates/deletes on a different database server. Everytime the script on ServerB runs, all attempts to connect to DB1 from ServerA fail. This causes major problems like causing server load on ServerA to rise dramatically. I have checked when the script runs, everything on DB1 is normal. Server load, mysql processes, no locks, etc... I also have it logging the connection failures with mysql_error but mysql_error turns up blank. Can anyone try and help me figure out what's going on here!? Why won't it connect during the period the script runs and why is mysql_error blank? Webservers are FreeBSD 4.8-Stable, DB1 is Redhat 7.3 running MySQL-standard 4.0.13 Thanks!! -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Very strange MySQL problem !
Possible? Are you sure all connection attempts fail? not just insert attempts? Server B does some updates/deletes... Chances are this causes some table locks, which makes Server A unable to perform it's inserts until Server B releases the lock. On Wed, 13 Aug 2003, Keith Bussey wrote: Hi, I am having a very weird problem with one of my database servers. Let's take the following setup: 10 load-balanced servers (I'll call them ServerA) 1 admin server (ServerB) 1 database server (DB1) Now ServerA has a function to insert a row into a table on DB1 whenever someone hits certain pages (for stats collection). There are probably about 1000 inserts being done per second. ServerB has a script that runs every 20 minutes, which does a very quick/simple select from DB1, then loops though the results and does updates/deletes on a different database server. Everytime the script on ServerB runs, all attempts to connect to DB1 from ServerA fail. This causes major problems like causing server load on ServerA to rise dramatically. I have checked when the script runs, everything on DB1 is normal. Server load, mysql processes, no locks, etc... I also have it logging the connection failures with mysql_error but mysql_error turns up blank. Can anyone try and help me figure out what's going on here!? Why won't it connect during the period the script runs and why is mysql_error blank? Webservers are FreeBSD 4.8-Stable, DB1 is Redhat 7.3 running MySQL-standard 4.0.13 Thanks!! -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Very strange MySQL problem !
Quoting [EMAIL PROTECTED]: Are you sure all connection attempts fail? not just insert attempts? Yes, i have it write to my log if the sock is empty (mysql_connect fails)...before it gets to the insert Server B does some updates/deletes... Chances are this causes some table locks, which makes Server A unable to perform it's inserts until Server B releases the lock. ServerB's updates/deletes are on a different database server though (as stated below ;p)...so it shouldn't factor in here at all. On Wed, 13 Aug 2003, Keith Bussey wrote: Hi, I am having a very weird problem with one of my database servers. Let's take the following setup: 10 load-balanced servers (I'll call them ServerA) 1 admin server (ServerB) 1 database server (DB1) Now ServerA has a function to insert a row into a table on DB1 whenever someone hits certain pages (for stats collection). There are probably about 1000 inserts being done per second. ServerB has a script that runs every 20 minutes, which does a very quick/simple select from DB1, then loops though the results and does updates/deletes on a different database server. Everytime the script on ServerB runs, all attempts to connect to DB1 from ServerA fail. This causes major problems like causing server load on ServerA to rise dramatically. I have checked when the script runs, everything on DB1 is normal. Server load, mysql processes, no locks, etc... I also have it logging the connection failures with mysql_error but mysql_error turns up blank. Can anyone try and help me figure out what's going on here!? Why won't it connect during the period the script runs and why is mysql_error blank? Webservers are FreeBSD 4.8-Stable, DB1 is Redhat 7.3 running MySQL-standard 4.0.13 Thanks!! -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Very strange MySQL problem !
That's the problem, when the script runs, I can connect from serverA fine!...but seems the webpages can't ;/ -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting [EMAIL PROTECTED]: On Wed, 13 Aug 2003, Keith Bussey wrote: Are you sure all connection attempts fail? not just insert attempts? Yes, i have it write to my log if the sock is empty (mysql_connect fails)...before it gets to the insert But you mention mysql reports no connection errors... perhaps wait for an update, and from ServerA, use mysql client: mysql --user=asdf --password=asdf --host=DB1 see if you can get online.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Very strange MySQL problem !
On Wed, 13 Aug 2003, Keith Bussey wrote: Are you sure all connection attempts fail? not just insert attempts? Yes, i have it write to my log if the sock is empty (mysql_connect fails)...before it gets to the insert But you mention mysql reports no connection errors... perhaps wait for an update, and from ServerA, use mysql client: mysql --user=asdf --password=asdf --host=DB1 see if you can get online.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Very strange MySQL problem !
I'd double check this cronjob script... possible scenario.. kaibash idea if you can prove it's invalid. ServerB has a script that runs every 20 minutes, which does a very quick/simple select from DB1, then loops though the results and does updates/deletes on a different database server. running a select on a server with 1000 inserts a second will take alot longer than if the query had a table lock. Also if the query has anything to do with stats, etc, not having a read lock and inserts going on could affect results and result speed. Perhaps it aquires a read lock before running the query? I'd dig thru the code/sql / use show processlist to disprove this theory. On Wed, 13 Aug 2003, Keith Bussey wrote: That's the problem, when the script runs, I can connect from serverA fine!...but seems the webpages can't ;/ -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting [EMAIL PROTECTED]: On Wed, 13 Aug 2003, Keith Bussey wrote: Are you sure all connection attempts fail? not just insert attempts? Yes, i have it write to my log if the sock is empty (mysql_connect fails)...before it gets to the insert But you mention mysql reports no connection errors... perhaps wait for an update, and from ServerA, use mysql client: mysql --user=asdf --password=asdf --host=DB1 see if you can get online.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL problem
Hello Sir, I have problem connecting to mysql in dos-prompt.. Error is : can't connect to mysql on localhost 10061).. What does it mean? I also try another method to solve this problem by typing mysqld-nt --install error prompts saying that the service already exists. The current server installed is : c:\Apache\mysql\bin\mysqld-nt.exe i am puzzled because i m using IIS and already uninstalled Apache program... can u please tell me how to solve this problem? thanks waiting for your reply. Regards Ellen - 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 problem
At 23:47 +0800 2/13/03, [EMAIL PROTECTED] wrote: Hello Sir, I have problem connecting to mysql in dos-prompt.. Error is : can't connect to mysql on localhost 10061).. What does it mean? I also try another method to solve this problem by typing mysqld-nt --install error prompts saying that the service already exists. The current server installed is : c:\Apache\mysql\bin\mysqld-nt.exe The --install option installs the server as a service but does not actually _start_ the service. Try either net start mysql from the DOS prompt, or use the Services Manager to start the service. i am puzzled because i m using IIS and already uninstalled Apache program... can u please tell me how to solve this problem? thanks waiting for your reply. Regards Ellen - 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 problem
Ellen, Error is : can't connect to mysql on localhost 10061).. I also try another method to solve this problem by typing mysqld-nt --install error prompts saying that the service already exists. The current server installed is : c:\Apache\mysql\bin\mysqld-nt.exe Start c:\Apache\mysql\bin\winmysqladmin.exe and try again! Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Problem
030116 14:28:01 MySql: Table 'mysql.host' doesn't exist http://www.innodb.com/ibman.html the InnoDB startup options listed in section 2 at But to get good performance you should adjust for your hardware innodb_data_file_path = ibdata1:10M:autoextend section, for example, or my.ini. If you want to use InnoDB tables, add to the [mysqld] to the [mysqld] section of init parameters in your my.cnf skip-innodb If you do not want to use transactional InnoDB tables, add a line Cannot initialize InnoDB as 'innodb_data_file_path' is not set. 030116 14:26:51 MySql: Shutdown Complete 030116 14:26:51 MySql: Normal shutdown I get the above error when starting mySQL and i have reinstalled it plenty of times now and i have run out of ideas. I dont know wehat to do nor do i know what the error means. If you could please help me out on this I am running a windows xp machine with php 4.3.0 and apache 2.x Thanks much Steven Pignataro __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BDB and mysql problem
Using the sql: alter table foo add index dex( keycol1, keycol2, keycol3 ); causes a Error 1030 with the annotation table handler error 12. The particular table involved has about 15 entries, contains 10 or so varchar() fields with a record size of O(500) bytes. The table is declared to be a BDB table. If I dump the table with mysqldump, modify the declaration to include the index, and then attept to reload, all goes well for a while, then everything dies with multiple Error 2002 reports. If I use the normal default table type (ISAM), I can load the respcified version of the table with the indexes without problem. I found no documentation on the reported errors and their potential cause. I did find find one posting the cited these errors and suggested setting SQL_BIG_TABLES, but it had no apparent impact. - 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 problem
Hello, I tried to execute the following query: SELECT studenti.* FROM studenti,valutazioni LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid WHERE valutazioni.sid IS NULL; and give me the following error message: ERROR 1066: Not unique table/alias: 'valutazioni' I have the Mysql 4.0.1 alpha version. I want to know what is the problem. - 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 problem
On Wed, 20 Nov 2002, Francesco wrote: Hello, I tried to execute the following query: SELECT studenti.* FROM studenti,valutazioni LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid WHERE valutazioni.sid IS NULL; Hi! I think you don't have to specify valutazioni in the FROM subclause (is it the correct term?). SELECT studenti.* FROM studenti LEFT JOIN valutazioni ... Iikka and give me the following error message: ERROR 1066: Not unique table/alias: 'valutazioni' I have the Mysql 4.0.1 alpha version. I want to know what is the problem. ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 problem
Syntax errors. Try: SELECT studenti.* FROM studenti LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid WHERE ISNULL( valutazioni.sid ) Ignatius - Original Message - From: Francesco [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 4:55 PM Subject: mysql problem Hello, I tried to execute the following query: SELECT studenti.* FROM studenti,valutazioni LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid WHERE valutazioni.sid IS NULL; and give me the following error message: ERROR 1066: Not unique table/alias: 'valutazioni' I have the Mysql 4.0.1 alpha version. I want to know what is the problem. - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - 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
ado/mysql problem
Hi After uppgrade mdac from 2.5 to 2.7 I get wrong types. An unsigned integer column was previously reported to be of type 3 (Integer) now it is returned as type 5(double). This atleast happens when im using getrows() in the recordset object. Can anybody tell what is going on here ? Im using mysql-3.23.52 and myodbc 2.50.39 on WinME thanks /Dan - 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: ado/mysql problem
Yep, I had issues too... I've dropped back to MDAC2.5 and all is well. .b -Original Message- From: Dan Johansson [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 15:03 To: [EMAIL PROTECTED] Subject: ado/mysql problem Hi After uppgrade mdac from 2.5 to 2.7 I get wrong types. An unsigned integer column was previously reported to be of type 3 (Integer) now it is returned as type 5(double). This atleast happens when im using getrows() in the recordset object. Can anybody tell what is going on here ? Im using mysql-3.23.52 and myodbc 2.50.39 on WinME thanks /Dan - 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: ado/mysql problem
I know the same issus exist on XP. One can't downgrade mdac on XP ?? So I really would like an other solution. /Dan Ben Joyce wrote: Yep, I had issues too... I've dropped back to MDAC2.5 and all is well. .b -Original Message- From: Dan Johansson [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 15:03 To: [EMAIL PROTECTED] Subject: ado/mysql problem Hi After uppgrade mdac from 2.5 to 2.7 I get wrong types. An unsigned integer column was previously reported to be of type 3 (Integer) now it is returned as type 5(double). This atleast happens when im using getrows() in the recordset object. Can anybody tell what is going on here ? Im using mysql-3.23.52 and myodbc 2.50.39 on WinME thanks /Dan - 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: ado/mysql problem
ahhh, hmm, erk... have you checked the MDAC site and MSKB for known bugs? -Original Message- From: Dan Johansson [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 15:19 To: Ben Joyce Cc: [EMAIL PROTECTED] Subject: Re: ado/mysql problem I know the same issus exist on XP. One can't downgrade mdac on XP ?? So I really would like an other solution. /Dan Ben Joyce wrote: Yep, I had issues too... I've dropped back to MDAC2.5 and all is well. .b -Original Message- From: Dan Johansson [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 15:03 To: [EMAIL PROTECTED] Subject: ado/mysql problem Hi After uppgrade mdac from 2.5 to 2.7 I get wrong types. An unsigned integer column was previously reported to be of type 3 (Integer) now it is returned as type 5(double). This atleast happens when im using getrows() in the recordset object. Can anybody tell what is going on here ? Im using mysql-3.23.52 and myodbc 2.50.39 on WinME thanks /Dan - 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: ado/mysql problem
Yes, I have now. Do not find anything :( Ben Joyce wrote: ahhh, hmm, erk... have you checked the MDAC site and MSKB for known bugs? -Original Message- From: Dan Johansson [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 15:19 To: Ben Joyce Cc: [EMAIL PROTECTED] Subject: Re: ado/mysql problem I know the same issus exist on XP. One can't downgrade mdac on XP ?? So I really would like an other solution. /Dan Ben Joyce wrote: Yep, I had issues too... I've dropped back to MDAC2.5 and all is well. .b -Original Message- From: Dan Johansson [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 15:03 To: [EMAIL PROTECTED] Subject: ado/mysql problem Hi After uppgrade mdac from 2.5 to 2.7 I get wrong types. An unsigned integer column was previously reported to be of type 3 (Integer) now it is returned as type 5(double). This atleast happens when im using getrows() in the recordset object. Can anybody tell what is going on here ? Im using mysql-3.23.52 and myodbc 2.50.39 on WinME thanks /Dan - 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: ado/mysql problem
Hmm. I'm not sure what to suggest... sorry! :( -Original Message- From: Dan Johansson [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 18:30 To: Ben Joyce Cc: [EMAIL PROTECTED] Subject: Re: ado/mysql problem Yes, I have now. Do not find anything :( Ben Joyce wrote: ahhh, hmm, erk... have you checked the MDAC site and MSKB for known bugs? -Original Message- From: Dan Johansson [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 15:19 To: Ben Joyce Cc: [EMAIL PROTECTED] Subject: Re: ado/mysql problem I know the same issus exist on XP. One can't downgrade mdac on XP ?? So I really would like an other solution. /Dan Ben Joyce wrote: Yep, I had issues too... I've dropped back to MDAC2.5 and all is well. .b -Original Message- From: Dan Johansson [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 15:03 To: [EMAIL PROTECTED] Subject: ado/mysql problem Hi After uppgrade mdac from 2.5 to 2.7 I get wrong types. An unsigned integer column was previously reported to be of type 3 (Integer) now it is returned as type 5(double). This atleast happens when im using getrows() in the recordset object. Can anybody tell what is going on here ? Im using mysql-3.23.52 and myodbc 2.50.39 on WinME thanks /Dan - 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 - 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
Java and Mysql, problem with String encoding
Hello, I have an applet that uses mysql. I have added support for greek and for data that are already in mysql, it works fine. When I add other from my applet it prints . Another thing is that I construct a table from the resultSet using two (String) vectors. The table headers come out unreadable. Is there any procedure that I need to add in order to work? Thank you John -- -- Quoting smart things, written by others is like writing stupid things and putting a smart name under it. Albert Einstein -- - 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
Java and Mysql, problem with String encoding
Thank you for your answer. I have to apologise for my bad post(I work 1 week on this problem and it was a desperite try). I have done what you suggested, but it partly works. Without useUnicode=true I didn't get anything right. With useUnicode=true I did get the data that were already in my table right, but not the table headers. Also (With useUnicode=true), when I inserted data from my form they did not appear correct. I read previous posts about new String(,ENCODING) I , but a. this does not solve the header problem b. when I run my applet from a greek locale PC it shows the table headers. Thanx and sorry for my 'lame' post, John 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: Java and Mysql, problem with String encoding
John Deligiannis wrote: Hello, I have an applet that uses mysql. I have added support for greek and for data that are already in mysql, it works fine. When I add other from my applet it prints . Another thing is that I construct a table from the resultSet using two (String) vectors. The table headers come out unreadable. Is there any procedure that I need to add in order to work? Thank you John The secret is in the README file (as usual) :) Add useUnicode=truecharacterEncoding=BLAH where BLAH is whatever character encoding you are using (ISO8859-1, UTF-8, etc). -Mark - 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 problem...maybe...?
dane, Friday, August 09, 2002, 10:53:30 PM, you wrote: dr My phpBB forums, say if i make a post, then it goes to the post, but dr nothings there, so i have to go to index.php for it to show (and it will log dr me out) is this a bug in 4.0.1 im pretty sure its mysql..usually it dr would show the posta nd if i chnaged something (ex. colors) i would have to dr TOTALY reload the page, not just refresh like its supposed to do...what do i dr do? Can you be more detailed? What is exactly wrong with MySQL 4.0.1? -- 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
Mysql Problem Query
From Anish MAthew India Dear sir i am using Linux 7.2 as my OS and having mysql version 3.36. i am a novice learner of mysql though i am familiar with Oracle and sybase. when i got to no the GNU publice license and open source technology i thought of learning mysql. but i have a problem to start with and i decided to share with u to get some technical help. problem my sqlserver is not running when i issue the command mysql the response i got was cant connect to local mysql server through socket /var/lib/mysql.sock (111) when i issued the command mysql.server start i got starting mysql daemon with databases from /var/lib/mysql mysqld ended and the daemon ended abruptly without starting the server. what would be the problem if you can give a technical workaround to this problem i would be grateful. awaiting your reply bye anish mathew __ Give your Company an email address like ravi @ ravi-exports.com. Sign up for Rediffmail Pro today! Know more. http://www.rediffmailpro.com/signup/ - 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 Problem Query
did you also install the databases that are part of the mysql installation? -Ll on 8/11/02 5:59 AM, Anish Mathew, typed: my sqlserver is not running when i issue the command mysql the response i got was cant connect to local mysql server through socket /var/lib/mysql.sock (111) when i issued the command mysql.server start i got starting mysql daemon with databases from /var/lib/mysql mysqld ended and the daemon ended abruptly without starting the server. - 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 Problem Query
Also, see what errors you are getting in mysql hostname.err file Regards, Bhavin. - Original Message - From: [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Sunday, August 11, 2002 3:30 AM Subject: Re: Mysql Problem Query did you also install the databases that are part of the mysql installation? -Ll on 8/11/02 5:59 AM, Anish Mathew, typed: my sqlserver is not running when i issue the command mysql the response i got was cant connect to local mysql server through socket /var/lib/mysql.sock (111) when i issued the command mysql.server start i got starting mysql daemon with databases from /var/lib/mysql mysqld ended and the daemon ended abruptly without starting the server. - 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
mysql problem...maybe...?
My phpBB forums, say if i make a post, then it goes to the post, but nothings there, so i have to go to index.php for it to show (and it will log me out) is this a bug in 4.0.1 im pretty sure its mysql..usually it would show the posta nd if i chnaged something (ex. colors) i would have to TOTALY reload the page, not just refresh like its supposed to do...what do i do? _ 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: MySQL: Problem Installing on RH 7.3
Philip Molter [EMAIL PROTECTED] writes: On Thu, Jul 18, 2002 at 11:44:14AM -0400, Richard Fox wrote: : The mysqld.log file says: : : 020717 13:05:05 mysqld started : 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file: : './mysql/host.frm' (errno: 13) : 020717 13:05:05 mysqld ended : : But I do see the host.frm file: : : -rw-rw1 root root 8958 Jul 17 13:04 : /var/lib/mysql/mysql/host.frm : : How did you fix this problem? Permissions are wrong. MySQL typically runs as mysql:mysql, not root:root. If I remember correctly, there may have been a problem with the setup scripts that handled this. Check the RH bug reports. The fix is simply to change owner/groups on the necessary files/directories. But Trond can give you specifics. It still may be user error. :) If memory serves... There were some permission problems in RHL 7, fixed in an errata a couple of days after release. The most common problem for a while was people running mysql_install_db as root - the dbs will be created, but owned by root. The database doesn't run as root, and can't write to it. There has been a workaround for that in the initscripts as well. -- Trond Eivind Glomsrød Red Hat, Inc. - 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: Problem Installing on RH 7.3
En réponse à Philip Molter [EMAIL PROTECTED]: Hi I am sure that tehre is a bug in RH 7.3 I've said it several times in this mailing list, but nobody wants to belive me! It's true that this information is difficult to find, but I've learned it on the documentation of www.mysql.org, the one with user comments. Regards Julien Sobrier On Thu, Jul 18, 2002 at 11:44:14AM -0400, Richard Fox wrote: : The mysqld.log file says: : : 020717 13:05:05 mysqld started : 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file: : './mysql/host.frm' (errno: 13) : 020717 13:05:05 mysqld ended : : But I do see the host.frm file: : : -rw-rw1 root root 8958 Jul 17 13:04 : /var/lib/mysql/mysql/host.frm : : How did you fix this problem? Permissions are wrong. MySQL typically runs as mysql:mysql, not root:root. If I remember correctly, there may have been a problem with the setup scripts that handled this. Check the RH bug reports. The fix is simply to change owner/groups on the necessary files/directories. But Trond can give you specifics. It still may be user error. :) : I do have the /var/lib/mysql/mysql.sock file... * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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
Re: MySQL: Problem Installing on RH 7.3
The mysqld.log file says: 020717 13:05:05 mysqld started 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020717 13:05:05 mysqld ended But I do see the host.frm file: -rw-rw1 root root 8958 Jul 17 13:04 /var/lib/mysql/mysql/host.frm How did you fix this problem? I do have the /var/lib/mysql/mysql.sock file... Thanks Rich I'm near enough in the same position as you are. Check the file /var/log/mysqld.log to see what the problem is. I had a problem accessing the file './mysql/host.frm', but I think that I've fixed this now. What happens when you try the 'mysql' command? I get the response can't connect to local MySQL server through socket '/var/usr/mysql/mysql.sock' And indeed there is no such file. Do you have this file? -Original Message- From: Richard Fox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 10:41 PM To: [EMAIL PROTECTED] Subject: MySQL: Problem Installing on RH 7.3 The MySQL daemon does not run. I installed the binary RPM's from the RH cd, MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to execute correctly. The I run safe_mysqld , and I get: [root@thor rfox]# /usr/bin/safe_mysqld [1] 2212 [root@thor rfox]# Starting mysqld daemon with databases from /var/lib/mysql 020717 15:21:28 mysqld ended That's it! I tried both the rpm and compiling it myself from source with BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior I just need a little hint, please! How do I troubleshoot this? Thanks, Rich 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 - 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: Problem Installing on RH 7.3
I am not sure, but are you sure that mysqld is running as a root? Or as a mysql (user) and mysql (group). Try to check rights of the mysqld user. Jan - Original Message - From: Richard Fox [EMAIL PROTECTED] To: Noamn [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 5:44 PM Subject: Re: MySQL: Problem Installing on RH 7.3 The mysqld.log file says: 020717 13:05:05 mysqld started 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020717 13:05:05 mysqld ended But I do see the host.frm file: -rw-rw1 root root 8958 Jul 17 13:04 /var/lib/mysql/mysql/host.frm How did you fix this problem? I do have the /var/lib/mysql/mysql.sock file... Thanks Rich I'm near enough in the same position as you are. Check the file /var/log/mysqld.log to see what the problem is. I had a problem accessing the file './mysql/host.frm', but I think that I've fixed this now. What happens when you try the 'mysql' command? I get the response can't connect to local MySQL server through socket '/var/usr/mysql/mysql.sock' And indeed there is no such file. Do you have this file? -Original Message- From: Richard Fox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 10:41 PM To: [EMAIL PROTECTED] Subject: MySQL: Problem Installing on RH 7.3 The MySQL daemon does not run. I installed the binary RPM's from the RH cd, MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to execute correctly. The I run safe_mysqld , and I get: [root@thor rfox]# /usr/bin/safe_mysqld [1] 2212 [root@thor rfox]# Starting mysqld daemon with databases from /var/lib/mysql 020717 15:21:28 mysqld ended That's it! I tried both the rpm and compiling it myself from source with BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior I just need a little hint, please! How do I troubleshoot this? Thanks, Rich 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 - 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: MySQL: Problem Installing on RH 7.3
At first blush it looks like it's a rights problem. Need to have the /var/lib/mysql owned by mysql.mysql... If you're starting mysql as the user mysql... HTH .mark -Original Message- From: Richard Fox [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 8:44 AM To: Noamn; [EMAIL PROTECTED] Subject: Re: MySQL: Problem Installing on RH 7.3 The mysqld.log file says: 020717 13:05:05 mysqld started 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020717 13:05:05 mysqld ended But I do see the host.frm file: -rw-rw1 root root 8958 Jul 17 13:04 /var/lib/mysql/mysql/host.frm How did you fix this problem? I do have the /var/lib/mysql/mysql.sock file... Thanks Rich I'm near enough in the same position as you are. Check the file /var/log/mysqld.log to see what the problem is. I had a problem accessing the file './mysql/host.frm', but I think that I've fixed this now. What happens when you try the 'mysql' command? I get the response can't connect to local MySQL server through socket '/var/usr/mysql/mysql.sock' And indeed there is no such file. Do you have this file? -Original Message- From: Richard Fox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 10:41 PM To: [EMAIL PROTECTED] Subject: MySQL: Problem Installing on RH 7.3 The MySQL daemon does not run. I installed the binary RPM's from the RH cd, MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to execute correctly. The I run safe_mysqld , and I get: [root@thor rfox]# /usr/bin/safe_mysqld [1] 2212 [root@thor rfox]# Starting mysqld daemon with databases from /var/lib/mysql 020717 15:21:28 mysqld ended That's it! I tried both the rpm and compiling it myself from source with BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior I just need a little hint, please! How do I troubleshoot this? Thanks, Rich 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 - 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: MySQL: Problem Installing on RH 7.3
First, nice username :) Anyhow, use the /etc/init.d/mysqld script as root to start/stop mysql, not the safe_mysqld binary. The init.d script really calls the safe_mysqld binary, but ti also makes a couple sanity checks like ensuring that the initial database files exist and are owned by the proper user. Example: # /etc/init.d/mysqld start This should get you past the problem you are currently having, which is that mysqld can't find it's database files. This is mostly due to redhat's mysql rpm installing the database files in a different location than mysql's distibution does. Hope this helps, Ryan Fox [EMAIL PROTECTED] On Thu, 2002-07-18 at 11:44, Richard Fox wrote: The mysqld.log file says: 020717 13:05:05 mysqld started 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020717 13:05:05 mysqld ended But I do see the host.frm file: -rw-rw1 root root 8958 Jul 17 13:04 /var/lib/mysql/mysql/host.frm How did you fix this problem? I do have the /var/lib/mysql/mysql.sock file... Thanks Rich I'm near enough in the same position as you are. Check the file /var/log/mysqld.log to see what the problem is. I had a problem accessing the file './mysql/host.frm', but I think that I've fixed this now. What happens when you try the 'mysql' command? I get the response can't connect to local MySQL server through socket '/var/usr/mysql/mysql.sock' And indeed there is no such file. Do you have this file? -Original Message- From: Richard Fox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 10:41 PM To: [EMAIL PROTECTED] Subject: MySQL: Problem Installing on RH 7.3 The MySQL daemon does not run. I installed the binary RPM's from the RH cd, MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to execute correctly. The I run safe_mysqld , and I get: [root@thor rfox]# /usr/bin/safe_mysqld [1] 2212 [root@thor rfox]# Starting mysqld daemon with databases from /var/lib/mysql 020717 15:21:28 mysqld ended That's it! I tried both the rpm and compiling it myself from source with BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior I just need a little hint, please! How do I troubleshoot this? Thanks, Rich 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 - 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: MySQL: Problem Installing on RH 7.3
You can see them because you are root, and you own them. Mysql can't see them because it is mysql. chown -R mysql /var/lib/mysql Richard Fox wrote: The mysqld.log file says: 020717 13:05:05 mysqld started 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020717 13:05:05 mysqld ended But I do see the host.frm file: -rw-rw1 root root 8958 Jul 17 13:04 /var/lib/mysql/mysql/host.frm How did you fix this problem? I do have the /var/lib/mysql/mysql.sock file... Thanks Rich I'm near enough in the same position as you are. Check the file /var/log/mysqld.log to see what the problem is. I had a problem accessing the file './mysql/host.frm', but I think that I've fixed this now. What happens when you try the 'mysql' command? I get the response can't connect to local MySQL server through socket '/var/usr/mysql/mysql.sock' And indeed there is no such file. Do you have this file? -Original Message- From: Richard Fox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 10:41 PM To: [EMAIL PROTECTED] Subject: MySQL: Problem Installing on RH 7.3 The MySQL daemon does not run. I installed the binary RPM's from the RH cd, MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to execute correctly. The I run safe_mysqld , and I get: [root@thor rfox]# /usr/bin/safe_mysqld [1] 2212 [root@thor rfox]# Starting mysqld daemon with databases from /var/lib/mysql 020717 15:21:28 mysqld ended That's it! I tried both the rpm and compiling it myself from source with BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior I just need a little hint, please! How do I troubleshoot this? Thanks, Rich 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 - 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: MySQL: Problem Installing on RH 7.3
On Thu, Jul 18, 2002 at 11:44:14AM -0400, Richard Fox wrote: : The mysqld.log file says: : : 020717 13:05:05 mysqld started : 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file: : './mysql/host.frm' (errno: 13) : 020717 13:05:05 mysqld ended : : But I do see the host.frm file: : : -rw-rw1 root root 8958 Jul 17 13:04 : /var/lib/mysql/mysql/host.frm : : How did you fix this problem? Permissions are wrong. MySQL typically runs as mysql:mysql, not root:root. If I remember correctly, there may have been a problem with the setup scripts that handled this. Check the RH bug reports. The fix is simply to change owner/groups on the necessary files/directories. But Trond can give you specifics. It still may be user error. :) : I do have the /var/lib/mysql/mysql.sock file... * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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
MYSQL Problem (Will not write to but will read)
Hi, All of a sudden it seems that my MYSQL is incapable of being written to. I can still read from it, but cannot write to it. When I looked at the processes, all the processes that tried to write to the database are in a state of 'Locked'. Any ideas what to do? - Dan Relihan - 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 Problem (Will not write to but will read)
I guess your harddisk ran out of space. Delete some stuffwithout restarting the database. Relihan, Daniel wrote: Hi, All of a sudden it seems that my MYSQL is incapable of being written to. I can still read from it, but cannot write to it. When I looked at the processes, all the processes that tried to write to the database are in a state of 'Locked'. Any ideas what to do? - Dan Relihan - 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 -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - 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: Problem Installing on RH 7.3
The MySQL daemon does not run. I installed the binary RPM's from the RH cd, MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to execute correctly. The I run safe_mysqld , and I get: [root@thor rfox]# /usr/bin/safe_mysqld [1] 2212 [root@thor rfox]# Starting mysqld daemon with databases from /var/lib/mysql 020717 15:21:28 mysqld ended That's it! I tried both the rpm and compiling it myself from source with BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior I just need a little hint, please! How do I troubleshoot this? Thanks, Rich 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
RE: MySQL: Problem Installing on RH 7.3
Dig around for a log file or an error file. Whenever it won't start it tells you why (or gives you a hint) in the error file. tail it and post if you still need help. =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Richard Fox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 3:41 PM To: [EMAIL PROTECTED] Subject: MySQL: Problem Installing on RH 7.3 The MySQL daemon does not run. I installed the binary RPM's from the RH cd, MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to execute correctly. The I run safe_mysqld , and I get: [root@thor rfox]# /usr/bin/safe_mysqld [1] 2212 [root@thor rfox]# Starting mysqld daemon with databases from /var/lib/mysql 020717 15:21:28 mysqld ended That's it! I tried both the rpm and compiling it myself from source with BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior I just need a little hint, please! How do I troubleshoot this? Thanks, Rich 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 - 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: Problem Installing on RH 7.3
On Wed, Jul 17, 2002 at 04:40:50PM -0400, Richard Fox wrote: : : The MySQL daemon does not run. I installed the binary RPM's from the RH cd, : MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to : execute correctly. The I run safe_mysqld , and I get: : : [root@thor rfox]# /usr/bin/safe_mysqld : [1] 2212 : [root@thor rfox]# Starting mysqld daemon with databases from /var/lib/mysql : 020717 15:21:28 mysqld ended : : That's it! I tried both the rpm and compiling it myself from source with : BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior If it's the RPMs from RH, have you tried /etc/init.d/mysqld start? That's the standard way of starting services on RH. Have you looked in /var/log/mysqld.log for any errors? * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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
mysql problem
Hi! I am new to mysql and this is my problem. The daemon runs well but I can start it only with --skip-grant-tables option, otherwise nothing will work. I set the password for the root user but when I exit the Mysql monitor and try to get in again, no password is request. When I set the password I entered flush privileges, but it returns 0 rows affected, if I try with mysqladmin it returns You have no privileges. Please, help me... I am almost out of mind for this! Simona - 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 problem
What happend when you ran scripts/mysql_install_db ? Also when you run the databases with --skip-grant-tables as soon as you grant a user acess and flush privileges it will then use the grant tables (I think).. Simon -Original Message- From: Simona D'Ambrosio [mailto:[EMAIL PROTECTED]] Sent: 10 June 2002 14:32 To: [EMAIL PROTECTED] Subject: mysql problem Hi! I am new to mysql and this is my problem. The daemon runs well but I can start it only with --skip-grant-tables option, otherwise nothing will work. I set the password for the root user but when I exit the Mysql monitor and try to get in again, no password is request. When I set the password I entered flush privileges, but it returns 0 rows affected, if I try with mysqladmin it returns You have no privileges. Please, help me... I am almost out of mind for this! Simona - 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: mysql problem
Simona, Monday, June 10, 2002, 4:31:33 PM, you wrote: SDA Hi! I am new to mysql and this is my problem. SDA The daemon runs well but I can start it only with --skip-grant-tables SDA option, otherwise nothing will work. SDA I set the password for the root user but when I exit the Mysql monitor and SDA try to get in again, no password is request. SDA When I set the password I entered flush privileges, but it returns 0 rows SDA affected, if I try with mysqladmin it returns You have no SDA privileges. SDA Please, help me... I am almost out of mind for this! Simona, you provided incomplete info! Please, show full error messages, full connection string and commands. SDA Simona -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql problem
Now it works!!! My problem was that I didn't know that if I set up passwords for users I had to tell it to the web pages where I connect to the database (postgres doesn't work like that). I know this is stupid, but I began my message with I am new to mysql :-) Anyway thank you for your replies. Simona What happend when you ran scripts/mysql_install_db ? Also when you run the databases with --skip-grant-tables as soon as you grant a user acess and flush privileges it will then use the grant tables (I think).. Simon -Original Message- From: Simona D'Ambrosio [mailto:[EMAIL PROTECTED]] Sent: 10 June 2002 14:32 To: [EMAIL PROTECTED] Subject: mysql problem Hi! I am new to mysql and this is my problem. The daemon runs well but I can start it only with --skip-grant-tables option, otherwise nothing will work. I set the password for the root user but when I exit the Mysql monitor and try to get in again, no password is request. When I set the password I entered flush privileges, but it returns 0 rows affected, if I try with mysqladmin it returns You have no privileges. Please, help me... I am almost out of mind for this! Simona - 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: MySQL Problem
On 3 May 2002 05:06:12 - Jagadeesh Suryadevara [EMAIL PROTECTED] wrote: When i check in the folder where it is loaded MySQL there are some applications with names MySQLManager,WinMysqladmin in bin directory. When click on these applications it showing some screens but we are unable to do anything on these screen i can only create new database but unable to create any tables. So send me all the details asap you should find in bin directory, a file called mysql, you can run it from ms-dos prompt it's text based ;-) -- Let's call it an accidental feature. -- Larry Wall - 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 Problem
Jagadeesh, Friday, May 03, 2002, 8:06:12 AM, you wrote: JS We want to use MYSQl as a back end for one of our projects. JS We download following 4 zip to install MySQL. JS mysql-4.0.0a-alpha-win-src.zip JS mysql-4.0.0a-alpha-win.zip JS mysql-4.0.1a-alpha-win-src.zip JS mysql-4.0.1a-alpha-win.zip *.win.src.zip is a source distribution. *.win.zip is a binary package. Read installation notes at: http://www.mysql.com/doc/W/i/Windows_installation.html JS After unzipping the file and MySQL is loaded successfully. JS But in programs it is not showing any shortcut or program name JS for JS mysql. JS There are any other files to be downloaded to install MySQL JS properly. JS When i check in the folder where it is loaded MySQL there are some JS applications JS with names MySQLManager,WinMysqladmin in bin directory. JS When click on these applications it showing some screens but we JS are unable to JS do anything on these screen i can only create new database but JS unable to create JS any tables. JS So send me all the details asap You should use client program mysql.exe or any graphical client. You can download two different GUI clients: MyCC and MySQLGUI from MySQL site. http://www.mysql.com/downloads/index.html Any other info about working with MySQL software is also in the manual. Please, check it: http://www.mysql.com/doc/ JS Thanks -- For technical support contracts, goto https://order.mysql.com/ 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
mysql - problem with timeout
hello ... first excuse my bad english ;-( we have a problem . one of our servers is working with the following components and configuration: linux suse 7.1 mysql 3.23.33 phpadmin 2.2.5 webmin 0,90 our problem . we work with a few databases in mysql ... often when we start more than (perhaps) hundred search-queries with a perlscript, whitch will show an output of the mysql-database, there is the problem, that mysql dont close the query-connection. many people said to us, there must be a chance to configure mysql so, that mysql will close a search-connection after ** seconds our question: whe will we configure mysql, that we will set a timeout for queries and connections? must it be in the perl-scripts or can we do this on the server with our webmin-tool? please . help us with a good documentation from youreself . maybe in german language?! thanks a lot . guenter m. schmitt koeln - deutschland - 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 Problem
Hello Sir/Madam, We want to use MYSQl as a back end for one of our projects. We download following 4 zip to install MySQL. mysql-4.0.0a-alpha-win-src.zip mysql-4.0.0a-alpha-win.zip mysql-4.0.1a-alpha-win-src.zip mysql-4.0.1a-alpha-win.zip After unzipping the file and MySQL is loaded successfully. But in programs it is not showing any shortcut or program name for mysql. There are any other files to be downloaded to install MySQL properly. When i check in the folder where it is loaded MySQL there are some applications with names MySQLManager,WinMysqladmin in bin directory. When click on these applications it showing some screens but we are unable to do anything on these screen i can only create new database but unable to create any tables. So send me all the details asap Thanks _ Click below to visit monsterindia.com and review jobs in India or Abroad http://monsterindia.rediff.com/jobs - 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 Problem
am having some trouble with MySQL. Seems I cannot add users. Well, I can add them (through phpMyAdmin, but they are still not able to get into the datasbases. I flushed the tables, too. Current users are not affected. This started, rather suddenly, the day after I was able to do this. Anyone have any ideas? Thanks, -Mike - 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
RH 7.2 - mysql Problem !
Ian, Thursday, March 28, 2002, 6:20:29 PM, you wrote: IL - Redhat 7.2 (Enigma) pre-build installation. IL - Mysql with the following rpms installed: IL MySQL-3.23.49a-1.i386.rpm IL MySQL-client-3.23.49a-1.i386.rpm Are you sure you are really running MySQL built binary and not the Red Hat's one? If you have installed Red Hat 7.2 blindly, you could install Red Hat's mysql rpms. Then it's possible that you have overwritten the RedHat's binary release with MySQL one and that could be a source of conflict, it is because MySQL and Red Hat are building MySQL in different ways... Please show us the output of the following: rpm -qa | grep -i mysql You can do something like rpm --erase `rpm -qa | grep -i mysql` (which will erase any occurances of MySQL), then erase /var/lib/mysql just to be sure nothing is left (warning: save all data before doing that!). After that you can install a binary release from MySQL (MySQL-3.23.49a.i386.rpm and others), and check if everything works fine. IL Segmentation fault This error mostly happens because of bad hardware or wrong-compilled MySQL, but something tells me that's not that case... IL /Ian -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RH 7.2 - mysql Problem !
More like he installed the rpm's from MySQL.com over the top of the one's from redhat. The scripts from the MySQL rpm's don't recognize the redhat rpms and the sripts from the redhat rpm's don't recognize the MySQL.com rpm's. The rpms from redhat are out of date (they were out of date when 7.2 hit the streets, but I understand manufacturing cycles a bit and that couldn't be helped.). rpm -e all of the mysql rpms that you have installed. to get a list of them rpm -q mysql mysql-client mysql-devel, etc. then rpm -q MySQL MySQL-client to figure out which one's you have. then rpm -e the whole lot of them. then rpm -ivh MySQL-3.23.49a-1.i386.rpm and MySQL-client-3.23.49a-1.i386.rpm. I've installed the 3.23.49a rpms on several machines and they work fine. I've never had any trouble with them. Curtis Trond Eivind Glomsrød said: Ian Linekrans [EMAIL PROTECTED] writes: Hi All ! The configuration: - Redhat 7.2 (Enigma) pre-build installation. - Mysql with the following rpms installed: MySQL-3.23.49a-1.i386.rpm MySQL-client-3.23.49a-1.i386.rpm The installation and connection as root to the database server works fine but when changing the root password according to all the different ways as described by mysql manuals and then trying to reconnect results in the following error : ERROR 1045: Access denied for user: 'root@localhost' (Using password YES) Segmentation fault The same error message appears when changing the password for an another user in the database. Note if no password is set everything works fine ! Soo whats is the deal !!! Anyone who has the same problem - feel free to contact me if you have a solution. You're using mysql rpms from MySQL - use the ones from Red Hat, they are known to work well. You should also be able to copy over the ones from the Skipjack beta and use them - they are the latest version (49a doesn't seem to be a tarball release, it was made because the binaries were bad AFAIK. Wasn't a problem for us). -- Trond Eivind Glomsrød Red Hat, Inc. - 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: RH 7.2 - mysql Problem !
Ian Linekrans [EMAIL PROTECTED] writes: Hi All ! The configuration: - Redhat 7.2 (Enigma) pre-build installation. - Mysql with the following rpms installed: MySQL-3.23.49a-1.i386.rpm MySQL-client-3.23.49a-1.i386.rpm The installation and connection as root to the database server works fine but when changing the root password according to all the different ways as described by mysql manuals and then trying to reconnect results in the following error : ERROR 1045: Access denied for user: 'root@localhost' (Using password YES) Segmentation fault The same error message appears when changing the password for an another user in the database. Note if no password is set everything works fine ! Soo whats is the deal !!! Anyone who has the same problem - feel free to contact me if you have a solution. You're using mysql rpms from MySQL - use the ones from Red Hat, they are known to work well. You should also be able to copy over the ones from the Skipjack beta and use them - they are the latest version (49a doesn't seem to be a tarball release, it was made because the binaries were bad AFAIK. Wasn't a problem for us). -- Trond Eivind Glomsrød Red Hat, Inc. - 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 problem ( innodb server startup)
hi, When I am starting the mysqld-max daemon there appears two errors !! I have intalled it on the another machine !! At this machine only, i am facing this problem, previously it was running O.K. anybody who can tell me how to resolve this problem...?? [root@dev1 sbin]# ./mysqld-max --user=root ./mysqld-max: File '/path-to-dedicated-directory/hostname.1' not found (Errcode: 2) 020315 9:39:23 Could not use /path-to-dedicated-directory/hostname for logging (error 2) 020315 9:39:24 InnoDB: Started ./mysqld-max: ready for connections Thanks and regards, Chetan Lavti - 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
