Re: Problem with mysql

2010-01-11 Thread Jørn Dahl-Stamnes
On Monday 11 January 2010 12:33, Mihamina Rakotomandimby wrote: > (Correction, seel below) > > > Jørn Dahl-Stamnes : > > > > I have checked the local DNS and 'r2-d2' and > > > > 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. > > > > What's wrong? > > > > > > Reverse resolution? > > > > I

Re: Problem with mysql

2010-01-11 Thread Mihamina Rakotomandimby
(Correction, seel below) > Jørn Dahl-Stamnes : > > > I have checked the local DNS and 'r2-d2' and > > > 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. > > > What's wrong? > > Reverse resolution? > I have checked that, and reverse DNS is OK - both resolve to > 192.18.2.22 I read you sol

Re: Problem with mysql

2010-01-11 Thread Mihamina Rakotomandimby
> Jørn Dahl-Stamnes : > > > I have checked the local DNS and 'r2-d2' and > > > 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse. > > > What's wrong? > > Reverse resolution? > I have checked that, and reverse DNS is OK - both resolve to > 192.18.2.22 I read you solved your problem, but by "

Re: Problem with mysql

2010-01-11 Thread Jørn Dahl-Stamnes
On Monday 11 January 2010 09:55, Ananda Kumar wrote: > use mysql; > select * from user; > > see if you able to see 'r2-d2' entry in this table. > > also you can try this > > grant all on . to 'root'@'%' idenfified by > 'secret-password'; I just found the cause of the problem... /etc/nsswitch.conf

Re: Problem with mysql

2010-01-11 Thread Ananda Kumar
use mysql; select * from user; see if you able to see 'r2-d2' entry in this table. also you can try this grant all on . to 'root'@'%' idenfified by 'secret-password'; regards anandkl On Mon, Jan 11, 2010 at 1:40 PM, Jørn Dahl-Stamnes wrote: > On Monday 11 January 2010 08:53, Mihamina Rakotoma

Re: Problem with mysql

2010-01-11 Thread Jørn Dahl-Stamnes
On Monday 11 January 2010 08:53, Mihamina Rakotomandimby wrote: > > Jørn Dahl-Stamnes : > > I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' > > resovl to the same IP-addresse. > > What's wrong? > > Reverse resolution? I have checked that, and reverse DNS is OK - both resolve

Re: Problem with mysql

2010-01-10 Thread Mihamina Rakotomandimby
> Jørn Dahl-Stamnes : > I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' > resovl to the same IP-addresse. > What's wrong? Reverse resolution? -- Architecte Informatique chez Blueline/Gulfsat: Administration Systeme, Recherche & Developpement +26

Re: Problem with mysql

2010-01-10 Thread Jørn Dahl-Stamnes
On Sunday 10 January 2010 12:34, sureshkumar...@gmail.com wrote: > Hi, > The grant stmt has to be as below. > Grant all on databasename.tablename to usern...@iporhostname identified by > 'password'; > > Use as above > Grant stmt doesn't require a flush stmt. Woops... Seems like the * in my first

Re: Problem with mysql

2010-01-10 Thread sureshkumarilu
Hi, The grant stmt has to be as below. Grant all on databasename.tablename to usern...@iporhostname identified by 'password'; Use as above Grant stmt doesn't require a flush stmt. Suresh Kuna MySQL DBA --Original Message-- From: Jørn Dahl-Stamnes To: mysql@lists.mysql.com ReplyTo: sq.

RE: Problem with MySQL user

2009-09-16 Thread Gavin Towey
Hi John, You can turn of name resolution by adding skip-name-resolve to the [mysqld] section of your my.cnf file. Regards, Gavin Towey -Original Message- From: John Oliver [mailto:joli...@john-oliver.net] Sent: Wednesday, September 16, 2009 4:24 PM To: mysql@lists.mysql.com Subject: Pro

Re: Problem with MySQL prompt

2008-12-23 Thread Stefano Elmopi
Hi Krishna, I use the script mysql_multi to stop and the start several, or all, instances. At the end, to work with more ease, I will create scripts to connect to each instance and in the script force the variable prompt at the connection seems easy Thanks for all !!! Il

Re: Problem with MySQL prompt

2008-12-23 Thread Krishna Chandra Prajapati
Hi Stefano, I believe that, different mysql configuration file for different mysql instance is a better idea. In your case, if any thing goes wrong with my.cnf Then, it is going to effect all mysql instance (either restart mysql server or any other way). It has a lots of disadvantages. You might

Re: Problem with MySQL prompt

2008-12-23 Thread Stefano Elmopi
Hi Krishna, the problem is that you use --default-file on the command line and in this mode it's working fine, I also tried, but I have the configuration of the variable "default-file" in the general my.cnf and I enter in MySQL in this way: mysql --socket=/tmp/mysql50_SIA_SVILUPPO.sock W

Re: Problem with MySQL prompt

2008-12-23 Thread Krishna Chandra Prajapati
Hi Stefano, I have tested. It's working fine without any issue. Open mysql configuration(.cnf) file referencing to 1st mysql instance. Add the below entires and restart the mysql server. [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates pro

Re: Problem with MySQL prompt

2008-12-23 Thread Stefano Elmopi
Hi Krishna, thanks for the your answer !!! I have three different my.cnf for my three instances but one general my.cnf to manage all instances, my general my.cnf is: [mysqld_multi] mysqld = /opt/local/mysql50/bin/mysqld_safe mysqladmin = /opt/local/mysql50/bin/mysqladmin user = root pas

Re: Problem with MySQL prompt

2008-12-22 Thread Simon J Mudd
prajapat...@gmail.com ("Krishna Chandra Prajapati") writes: > You are running three mysql instance on single server. You can have three > my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other > information in them. In this way you can set the prompt for different > instance.

Re: Problem with MySQL prompt

2008-12-22 Thread Stefano Elmopi
Thanks for the all answers !!! It's ok, even if I have three different my.cnf for my three instances, my general my.cnf is: [mysqld_multi] mysqld = /opt/local/mysql50/bin/mysqld_safe mysqladmin = /opt/local/mysql50/bin/mysqladmin user = root password = mysys2008srv log = /MYSQL/MYSQL_LOG/My

Re: Problem with MySQL prompt

2008-12-22 Thread Warren Young
Stefano Elmopi wrote: If I put the variable prompt in the general my.cnf, the prompt is changed but for all instances. If I put in the variable prompt in the my.cnf associated with the instance in the [mysql] section, the prompt does not change. This is because the client reads from my.cnf b

Re: Problem with MySQL prompt

2008-12-22 Thread Claudio Nanni
Ciao Stefano, how do you connect to the different instances? if you use different operating system users or different mysql home directories just put in the home directory of each user a .my.cnf file (or my.cnf in the mysql home) with just the prompt setting in the [mysql] section. NOTE: in the

Re: Problem with MySQL prompt

2008-12-22 Thread Krishna Chandra Prajapati
Hi Stefano, You are running three mysql instance on single server. You can have three my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other information in them. In this way you can set the prompt for different instance. On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi wrote:

Re: Problem with MySQL 5 on OS X Tiger

2005-12-01 Thread Gleb Paharenko
Hello. Some tips from the manual could be helpful. See: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html http://dev.mysql.com/doc/refman/5.0/en/starting-server.html untz wrote: > Hello there, > > I just downloaded the MySQL 5 Community Edition for OS X Tiger..

Re: Problem with MySQL 5 on OS X Tiger

2005-11-30 Thread Michael Stassen
Lachlan Mulcahy wrote: Hi Unnsse, Here's the problem at hand: Raven:~ untz$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Can anyone tell me what possibly I am doing wrong? The message you are getting is saying that there is no socket

Re: Problem with MySQL 5 on OS X Tiger

2005-11-30 Thread Lachlan Mulcahy
Hi Unnsse, Here's the problem at hand: Raven:~ untz$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Can anyone tell me what possibly I am doing wrong? The message you are getting is saying that there is no socket file at /tmp/mysql.soc

Re: Problem with mysql-administrator-1.1.5, s.o.

2005-11-24 Thread Gleb Paharenko
Hello. It doesn't run on Windows NT 4 and below. See: http://dev.mysql.com/doc/administrator/en/mysql-administrator-installation-windows.html Wolfgang Bogenrieder wrote: > Hallo, > > ich have a problem with > > mysql-administrator-1.1.5 and > mysql-query-browser-1.1.17 > > r

re: problem with mysql-max-5.0.3 for Solaris 8 32 bit

2005-03-29 Thread Matt Wagner
> It would appear that the package is for the 64-bit OS, even though it is > listed as being for the 32-bit one. > > I see directories, that failed to install, of: > /usr/local/mysql-max-5.0.3-beta-sun-solaris2.8-sparc-64bit/sql-bench > > I had gotten my file from > http://dev.mysql.com/get/Downl

re: problem with mysql-max-5.0.3 for Solaris 8 32 bit

2005-03-28 Thread James Black
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It would appear that the package is for the 64-bit OS, even though it is listed as being for the 32-bit one. I see directories, that failed to install, of: /usr/local/mysql-max-5.0.3-beta-sun-solaris2.8-sparc-64bit/sql-bench I had gotten my file from

RE: Problem with Mysql 4.1.3: Error #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

2004-08-18 Thread Donny Simonton
This is not a mysql problem, it is a phpmyadmin problem. You must be using 2.6.0 rc1, download 2.6.0 beta 2 and you won't have the problem any more. I have complained to them about it, but not exactly sure what they are going to do. Donny > -Original Message- > From: Martin Rytz [mail

Re: Problem with Mysql 4.0.18 + Debian

2004-08-03 Thread Jan Kirchhoff
Jocelyn Fournier wrote: Hi, A quick fix would be to set the wait_timeout variable in the my.cnf to a much smaller value than 28800 (default value). Try to add wait_timeout=60 in the my.cnf for example, the connections should be automatically closed after 60 secondes if there are not used anymore.

Re: Problem with Mysql 4.0.18 + Debian

2004-08-03 Thread Jocelyn Fournier
Fournier www.presence-pc.com - Original Message - From: "Jan Kirchhoff" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 03, 2004 7:43 PM Subject: Re: Problem with Mysql 4.0.18 + Debian > That sounds like a typical

Re: Problem with Mysql 4.0.18 + Debian

2004-08-03 Thread William R. Mussatto
> > > Thanks for the two responses. > > William Mussatto said: >> Are you running mod_perl? > > Yes I am, with Perl 5.8.3. > > Victor Pendleton said: >> What does mysql "show processlist" look like? > > Here is what it looks like currently, but the system is not in its > "unresponsive" phase right

Re: Problem with Mysql 4.0.18 + Debian

2004-08-03 Thread Jan Kirchhoff
That sounds like a typical mod_perl-problem. The script is making new connections and doesn't close the old ones. You should add debug-code to your script and add * * * * * root mysql -e 'show processlist' >/tmp/mysql_processlist_debug_`date +%s`.txt to your /etc/crontab in order to log the proce

Re: Problem with Mysql 4.0.18 + Debian

2004-08-02 Thread Batara Kesuma
Ryan, > Here's the problem. I had the site up several days, with everything > running perfectly. Ordinarily there would be about 11 mysql processes > running. However, after a few days of running smoothly, the number of > mysql processes increases to over 170, and the site crashes. Formerly >

RE: Problem with Mysql 4.0.18 + Debian

2004-08-02 Thread William R. Mussatto
Victor Pendleton said: > What does mysql "show processlist" look like? > > -Original Message- > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Sent: 8/2/04 9:16 AM > Subject: Problem with Mysql 4.0.18 + Debian > > Hello: > > I posted this before but I have not gotten a response. I hav

RE: Problem with Mysql 4.0.18 + Debian

2004-08-02 Thread Victor Pendleton
What does mysql "show processlist" look like? -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 8/2/04 9:16 AM Subject: Problem with Mysql 4.0.18 + Debian Hello: I posted this before but I have not gotten a response. I have a Debian (woody) server running a good s

Re: Problem with Mysql 4.0.18 + Apache

2004-07-21 Thread William R. Mussatto
> Hello: > > I posted this before but I have made some changes since then (not that > they helped much). I have a Debian (woody) server running a good sized > database (7.2GB of db files), Mysql 4.0.18. I am running Apache 1.3.29 > + perl and using mysql as the backend. In my.cnf, I set > max_

Re: Problem with mySQL and Mac OS X

2003-12-19 Thread Michael Stassen
I'm running mysql 4.0.17 on Mac OS X 10.2.8 without problems. My first guess would be that the upgrade reset the permissions on /tmp, so now the mysql user doesn't have permission to create mysql.sock. Try cd /tmp sudo chmod 1777 . then see if mysqld will start. (While you're in /tmp, mak

Re: problem with 'mysql' command on Mac OS X 1.3 (Panther)

2003-10-31 Thread Brent Baisley
What version of mysql are you using? I'm running 4.0.14 and I upgraded without a problem. On Friday, October 31, 2003, at 01:20 PM, Anderson, James H [IT] wrote: Ever since upgrading I haven't been able to use the 'mysql' command--it just hangs. Otherwise, the database seems to be working prope

RE: problem with MySQL and latest release of Mac OX X (Panther)

2003-10-29 Thread Anderson, James H [IT]
->-Original Message- -->From: Anderson, James H [IT] [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, October 28, 2003 2:03 PM -->To: 'Dathan Vance Pattishall'; [EMAIL PROTECTED] -->Subject: RE: problem with MySQL and latest release of Mac OX X (Panther) --> -->BTW,

RE: problem with MySQL and latest release of Mac OX X (Panther)

2003-10-28 Thread Dathan Vance Pattishall
mailto:[EMAIL PROTECTED] -->Sent: Tuesday, October 28, 2003 2:03 PM -->To: 'Dathan Vance Pattishall'; [EMAIL PROTECTED] -->Subject: RE: problem with MySQL and latest release of Mac OX X (Panther) --> -->BTW, nothing's changed in my.cnf... --> -->.my.cnf -->

RE: problem with MySQL and latest release of Mac OX X (Panther)

2003-10-28 Thread Anderson, James H [IT]
. -Original Message- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 4:42 PM To: Anderson, James H [IT]; [EMAIL PROTECTED] Subject: RE: problem with MySQL and latest release of Mac OX X (Panther) Can you post you're my.cnf options / your query in que

RE: problem with MySQL and latest release of Mac OX X (Panther)

2003-10-28 Thread Dathan Vance Pattishall
Can you post you’re my.cnf options / your query in question / how long have you seen it hang / what status it is in / and your show status vars. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message-

Re: Problem with MySQL 4.0.14 - Server Crash

2003-09-10 Thread joei
Victoria, Thanks. -- __ Sign-up for your own personalized E-mail at Mail.com http://www.mail.com/?sr=signup CareerBuilder.com has over 400,000 jobs. Be smarter about your job search http://corp.mail.com/careers -- MySQL General Mailing Li

Re: Problem with MySQL 4.0.14 - Server Crash

2003-09-10 Thread Sergei Golubchik
Hi! On Sep 10, Victoria Reznichenko wrote: > [EMAIL PROTECTED] wrote: > > I upgrade try to upgrade from MySQL 4.0.12 to 4.0.14 in Linux but it > > doesn't work. MySQL always crashs with error 11 Segmentation fault. > > > > I don't know why but I try to dump database (about 200,000 lines) > > and

Re: Problem with MySQL 4.0.14 - Server Crash

2003-09-10 Thread Victoria Reznichenko
[EMAIL PROTECTED] wrote: > I upgrade try to upgrade from MySQL 4.0.12 to 4.0.14 in Linux but it doesn't work. > MySQL always crashs with error 11 Segmentation fault. > > I don't know why but I try to dump database (about 200,000 lines) and install MySQL > 4.0.14 windows version and try to import

Re: problem with mysql-crashes

2003-07-23 Thread Thomas Seifert
Hi Lenz, thanks a lot for your reply! > Is that a self-compiled binary or one of ours? It are the MySQL-4.0.13-MAX-RPMs from your site. > Not very helpful. Does this occur under high load only? Yeah I know, otherwise I would have tried to generate a reproducible testcase with a given query or

Re: problem with mysql-crashes

2003-07-23 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 23 Jul 2003 [EMAIL PROTECTED] wrote: > before posting to the bugs-list I would like to try it here to get some > help :). Every now and then MySQL-4.0.13 crashes on my > Dual-Athlon-MP-machine. Is that a self-compiled binary or one of ou

Re: Problem with mysql replication

2003-06-05 Thread Victoria Reznichenko
"Dan Houtz" <[EMAIL PROTECTED]> wrote: > I'm currently trying to setup replication following the directions from the mysql > manual, however, once I configure the slave server with the server-id parameter, it > fails to load. If I remove server-id=2 from my.cnf then the server starts up fine. >

Re: Problem with MySQL, MyODBC, Access 2002 and Japanese.

2003-02-25 Thread Tore Bostrup
Don't know, but: Are you using the Japanese Access 2002? What locale is your OS configured for? HTH, Tore. - Original Message - From: "Juan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 25, 2003 6:12 AM Subject: Problem with MySQL, MyODBC, Access 2002 and Japanes

Re: Problem with MySQL-GUI

2002-11-10 Thread R. Hannes Niedner
On 11/10/02 9:42 PM, "daniel" <[EMAIL PROTECTED]> wrote: > i've made connections to a remote mysql from one server to our main one and > the main one is running socket connections ? I guess I lost you. All I wanted to say is this: If you run mysql (client) and mysqld (server) on the same compute

RE: Problem with MySQL-GUI

2002-11-10 Thread daniel
i've made connections to a remote mysql from one server to our main one and the main one is running socket connections ? >= Original Message From "R. Hannes Niedner" <[EMAIL PROTECTED]> = >On 11/10/02 9:14 PM, "daniel" <[EMAIL PROTECTED]> wrote: > >> running on localhost using the socket

Re: Problem with MySQL-GUI

2002-11-10 Thread R. Hannes Niedner
On 11/10/02 9:14 PM, "daniel" <[EMAIL PROTECTED]> wrote: > running on localhost using the socket connection (as supposed to > tcp/ip ). > > what are you saying that mysql can connect another way other than through > mysql.sock ? If I am not mistaken the socket works only for a connection between

RE: Problem with MySQL-GUI

2002-11-10 Thread daniel
running on localhost using the socket connection (as supposed to tcp/ip ). what are you saying that mysql can connect another way other than through mysql.sock ? >= Original Message From "R. Hannes Niedner" <[EMAIL PROTECTED]> = >On 11/10/02 1:50 PM, "Allan J Horwitz" <[EMAIL PROTECTED]

Re: Problem with MySQL-GUI

2002-11-10 Thread R. Hannes Niedner
On 11/10/02 1:50 PM, "Allan J Horwitz" <[EMAIL PROTECTED]> wrote: > Hi there -- I'm relatively new to LINUX (I have RedHat 8.0 on my system) > and I just downloaded MySQL-GUI and can't seem to get it working. It > keeps telling me that it cannot connect through the socket (111). Can > someone te

Re: problem with mysql on windows

2002-10-29 Thread Gelu Gogancea
Hi, It's possible, to have some software/scripts which run in out of environment space. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Origin

Re: Problem with mysql jdbc Connector

2002-10-13 Thread Mark Matthews
janesh wrote: > HI > I am accessing mysql through Websphere 5.0 through jsp file . it says > SQLException: Cannot connect to MySQL server on host:3306. Is there > a MySQL server running on the machine/port you are trying to connect to? > (java.security.AccessControlException) > SQLState: 08S01 >

Re: Problem with mysql.

2002-10-10 Thread gerald_clark
you need the ncurses libraries. Philippe Benchemoul wrote: >Hi, > >I try to install mysql 3.23.52 on a debian 2.2.8 with the sources. >./configure --prefix=/usr/local/progs/mysql > >For the configure level, I have the message : >checking for termcap functions library... configure: er

Re: Problem with mysql making my server extremly slow

2002-08-20 Thread Victoria Reznichenko
Magnet, Monday, August 19, 2002, 11:11:38 PM, you wrote: M> I manage a web server having a lot of http connections, using M> Apache/PHP/MySQL. When there are too many simultaneous connections (so, many M> MySQL requests), MySQL stops working efficiently and makes my load average M> increase a LOT

Re: problem with mysql threads on freebsd

2002-06-11 Thread Leo De Geer
On Tuesday 11 June 2002 16.30, Dan Nelson wrote: > In the last episode (Jun 11), Leo De Geer said: > > im not abel to get mysql to use more then one thread on my freebsd > > 4.5-stable any one having a klue that wrong? > > Do not assume that the way Linux manages threads is the only one. > Mys

Re: problem with mysql threads on freebsd

2002-06-11 Thread Patrick Hsieh
Hello, Out of curiosity--Is this the key reason that Yahoo finance switched from FreeBSD to Linux? :-) \\sql\\ -- Patrick Hsieh <[EMAIL PROTECTED]> GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - Before posting, pl

Re: problem with mysql threads on freebsd

2002-06-11 Thread Patrick Hsieh
Hello Leo De Geer <[EMAIL PROTECTED]>, > the problen nr 2 i dont have but the server we have dont handle the load on > one cpu. at the moment we are runing the sql on a linux instead (same > hardwere) but i sucks. alla auter servers is freebsd and they run mutch beter > Why MySQL on Linux suc

Re: problem with mysql threads on freebsd

2002-06-11 Thread Dan Nelson
In the last episode (Jun 11), Leo De Geer said: > im not abel to get mysql to use more then one thread on my freebsd > 4.5-stable any one having a klue that wrong? Do not assume that the way Linux manages threads is the only one. Mysql on FreeBSD does create threads; they are just not visibl

Re: problem with mysql threads on freebsd

2002-06-11 Thread Leo De Geer
[mailto:[EMAIL PROTECTED]] > Sent: 11 June 2002 09:35 > To: Alexander V Zubchenko > Cc: Dicky Wahyu Purnomo; [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Subject: Re: problem with mysql threads on freebsd > > On Tuesday 11 June 2002 09.57, Alexander V Zubchenko wrote: > > Greet

RE: problem with mysql threads on freebsd

2002-06-11 Thread Simon Green
ECTED]; [EMAIL PROTECTED] Subject: Re: problem with mysql threads on freebsd On Tuesday 11 June 2002 09.57, Alexander V Zubchenko wrote: > Greetings! > > On Tue, 11 Jun 2002, Leo De Geer wrote: > > but in my case its not good to have it that way im having one dedikated > > dual

Re: problem with mysql threads on freebsd

2002-06-11 Thread Erv Young
Leo, I believe there was a conversation about this subject several weeks ago, in which the conclusion was that a good reason to use Linux, in preference to FreeBSD, for database servers is that Linux multi-processor support works and FreeBSD doesn't. --Erv sql,query At 09:42 AM 6/11/2002 +0

Re: problem with mysql threads on freebsd

2002-06-11 Thread Leo De Geer
On Tuesday 11 June 2002 09.57, Alexander V Zubchenko wrote: > Greetings! > > On Tue, 11 Jun 2002, Leo De Geer wrote: > > but in my case its not good to have it that way im having one dedikated > > dual server for the sql and now im yust using one cpu for the sql > > questions. i nead it to start s

Re: problem with mysql threads on freebsd

2002-06-11 Thread Alexander V Zubchenko
Greetings! On Tue, 11 Jun 2002, Leo De Geer wrote: > but in my case its not good to have it that way im having one dedikated dual > server for the sql and now im yust using one cpu for the sql questions. i > nead it to start sub conections to the sql to serv all my conections good. In such case p

Re: problem with mysql threads on freebsd

2002-06-11 Thread Leo De Geer
On Tuesday 11 June 2002 09.26, Alexander V Zubchenko wrote: > Greetings! > > On Tue, 11 Jun 2002, Leo De Geer wrote: > > On Tuesday 11 June 2002 08.49, Dicky Wahyu Purnomo wrote: > > > On Tue, 11 Jun 2002 08:36:55 +0200 > > > > > > Leo De Geer <[EMAIL PROTECTED]> wrote: > > > > im not abel to get

Re: problem with mysql threads on freebsd

2002-06-11 Thread Leo De Geer
On Tuesday 11 June 2002 08.49, Dicky Wahyu Purnomo wrote: > On Tue, 11 Jun 2002 08:36:55 +0200 > > Leo De Geer <[EMAIL PROTECTED]> wrote: > > im not abel to get mysql to use more then one thread on my freebsd > > 4.5-stable any one having a klue that wrong? > > from what method / tools, you ge

Re: problem with mysql threads on freebsd

2002-06-11 Thread Alexander V Zubchenko
Greetings! On Tue, 11 Jun 2002, Leo De Geer wrote: > On Tuesday 11 June 2002 08.49, Dicky Wahyu Purnomo wrote: > > On Tue, 11 Jun 2002 08:36:55 +0200 > > > > Leo De Geer <[EMAIL PROTECTED]> wrote: > > > im not abel to get mysql to use more then one thread on my freebsd > > > 4.5-stable any one h

Re: problem with mysql threads on freebsd

2002-06-11 Thread Leo De Geer
On Tuesday 11 June 2002 08.49, Dicky Wahyu Purnomo wrote: > On Tue, 11 Jun 2002 08:36:55 +0200 > > Leo De Geer <[EMAIL PROTECTED]> wrote: > > im not abel to get mysql to use more then one thread on my freebsd > > 4.5-stable any one having a klue that wrong? > > from what method / tools, you ge

Re: problem with mysql threads on freebsd

2002-06-10 Thread Dicky Wahyu Purnomo
On Tue, 11 Jun 2002 08:36:55 +0200 Leo De Geer <[EMAIL PROTECTED]> wrote: > im not abel to get mysql to use more then one thread on my freebsd 4.5-stable > any one having a klue that wrong? > from what method / tools, you get this information ? try mysqladmin -p status -- > Linux is not

Antwort: RE: Re: Problem with MySQL, ODBC, MS Access

2002-03-13 Thread Penkert, Christine
12, 2002 11:19 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Re: Problem with MySQL, ODBC, MS Access > > > > > Hi, > > Can anyone help me please? I´m writing my diploma and this database is my > project. I´m running out of time and when this problem doesn´

Antwort: RE: Re: Problem with MySQL, ODBC, MS Access

2002-03-05 Thread Penkert, Christine
t; To: [EMAIL PROTECTED]; muyuan; [EMAIL PROTECTED] > Subject: Re: Re: Problem with MySQL, ODBC, MS Access > > > > > Sorry I´ve tried it but I didn´t succeed. When writing: update > tPruefBesch set fdatetime = fTimestamp, datetime and timestamp wont have > the same value. I don´t

Re: Problem with mysql++ under Tru64 Unix

2002-03-04 Thread Erminio Efisio Riezzo
Riezzo. - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, March 04, 2002 4:33 PM Subject: Re: Problem with mysql++ under Tru64 Unix > Erminio Efisio Riezzo writes: > > He

Re: Problem with mysql++ under Tru64 Unix

2002-03-04 Thread Sinisa Milivojevic
Erminio Efisio Riezzo writes: > Hello folks, > I have a large problem during the compilation of mysql under tru64 unix. > I have tried is the 1.7.9 that the 1.7.6a with compiler cxx. > The 1.7.9 jam when the following launch the gmake with message: > > gmake all-recursive > gmake[1]: Entering

Re: Re: Problem with MySQL, ODBC, MS Access

2002-03-04 Thread Penkert, Christine
Sorry I´ve tried it but I didn´t succeed. When writing: update tPruefBesch set fdatetime = fTimestamp, datetime and timestamp wont have the same value. I don´t know why, but there is the same fault. I´ve created a small database to show my problem. That´s my table in MySQL 3.23.41. create tabl

Re: Problem with mysql 3.23.49 rpm install

2002-02-18 Thread Trond Eivind Glomsrød
"Ireneusz Piasecki" <[EMAIL PROTECTED]> writes: > Hi. > I want upgrade mysql from 3.23.48 to 3.23.49 but i see that. > > first. shared > ># /usr/lib/mc/extfs/rpm run /home/httpd/MySQL-shared-3.23.49-1.i386.rpm > UPGRADE > Upgrading "/home/httpd/MySQL-shared-3.23.49-1.i386.rpm" > error: failed de

Re: Problem with MySQL DATE_FORMAT or is it a PEBKAC??

2002-01-31 Thread DL Neil
Neil, > I appear to be having an error with the following update that I am > submitting to my database. I am using mysql's DATE_FORMAT function to pull > the date out and insert in a user friendly form. Upon submission of the > modified data, I use the below SQL to update the table information. >

Re: Problem with MySQL and SMP?

2002-01-12 Thread Sinisa Milivojevic
Jeremy Zawodny writes: > On Fri, Jan 11, 2002 at 11:54:26AM -0500, [EMAIL PROTECTED] wrote: > > > > Any suggestions on loging tools I cna run to try to find out more > > information? The machine is coloced about 3 hours for me, so I would > > hate to have to drive there and install FreeBSD on it,

Re: Problem with MySQL and SMP?

2002-01-11 Thread Jeremy Zawodny
On Fri, Jan 11, 2002 at 11:54:26AM -0500, [EMAIL PROTECTED] wrote: > > Any suggestions on loging tools I cna run to try to find out more > information? The machine is coloced about 3 hours for me, so I would > hate to have to drive there and install FreeBSD on it, when it was > just something I co

Re: Problem with MySQL and SMP?

2002-01-11 Thread Ryan Fox
I'm running ok on my Dual PII machine, if this helps anyone. Redhat 7.1, 2.4.2-SGI_XFS kernel, MySQL 3.23.43. [root@willyjr /root]# uptime 1:07pm up 95 days, 4:08, 1 user, load average: 0.08, 0.04, 0.01 [root@willyjr /root]# cat /etc/redhat-release Red Hat Linux release 7.1 (Seawolf) [root@

Re: Problem with MySQL and SMP?

2002-01-11 Thread Joshua J . Kugler
Yes, this had occured to me. I am thinking about downgrading to kernel 2.4.8, or such. Not sure I really want to do that, but I'd rather do that than face system lock ups. j- k- On Friday 11 January 2002 08:55, Sinisa Milivojevic wrote: > If nothing works as you said, no ssh, no cons

RE: Problem with MySQL and SMP?

2002-01-11 Thread Johnny Withers
In my opinion, I have been wrong before. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Johnny Withers [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 11:40 AM To: 'MySQL' Subject: RE: Problem with MySQL and

Re: Problem with MySQL and SMP?

2002-01-11 Thread Sinisa Milivojevic
Joshua J.Kugler writes: > We are having the same problem. Mandrake 8.1, kernel 2.4.17, MySQL 3.23.47. > Dual PIII-500, 512MB of RAM, Mylex DAC960 RAID 5. > > After being up for a few days, the system completely froze. No ssh, no > console, nothing. Had to hard reset the server. > > Yes, we

Re: Problem with MySQL and SMP?

2002-01-11 Thread Thibaut Allender
i don't have any problem with this config : slackware 7.1, kernel 2.2.18, MySQL 3.23.41 Dual PIII-800, 256MB RAM, SCSI Ultra-160 maybe it's kernel 2.4 fault. HTH (sorry for the duplicated message Joshua, forgot to send to the ML) At 18:26 11/01/2002, you wrote: >We are having the same problem

RE: Problem with MySQL and SMP?

2002-01-11 Thread Johnny Withers
-- From: Joshua J.Kugler [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 11:26 AM To: MySQL Subject: Re: Problem with MySQL and SMP? We are having the same problem. Mandrake 8.1, kernel 2.4.17, MySQL 3.23.47. Dual PIII-500, 512MB of RAM, Mylex DAC960 RAID 5. After being up for a few d

Re: Problem with MySQL and SMP?

2002-01-11 Thread Joshua J . Kugler
We are having the same problem. Mandrake 8.1, kernel 2.4.17, MySQL 3.23.47. Dual PIII-500, 512MB of RAM, Mylex DAC960 RAID 5. After being up for a few days, the system completely froze. No ssh, no console, nothing. Had to hard reset the server. Yes, we compiled MySQL: we have to. Our appli

Re: Problem with MySQL and SMP?

2002-01-11 Thread gavin
Any suggestions on loging tools I cna run to try to find out more information? The machine is coloced about 3 hours for me, so I would hate to have to drive there and install FreeBSD on it, when it was just something I could have fixed. Gavin Blestan Tabakov wrote: >hi! >i'm running mysql on

Re: Problem with MySQL and SMP?

2002-01-10 Thread gavin
I am using the RPM's from ftp.mysql.com. I thought it was hardware as well until I created a 2nd machind (the 2nd server that was had 2 CPUs) and both of them had the same results. But I know its not a query thats hanging it, because as I ordered the 2nd server I had a server with 1 CPU doing

Re: Problem with MySQL and SMP?

2002-01-10 Thread Lionlike MySQL Email List
[EMAIL PROTECTED] wrote: > I am having a problem with MySQL that I believe is related to SMP. I > have a machine that is an exact copy of another machine, only > difference is that this one is Dual processor, and the other one is > single. The single one has had no problems for the last 6 mont

Re: Problem with MySQL and SMP?

2002-01-10 Thread Jeremy Zawodny
On Fri, Jan 11, 2002 at 01:11:11AM -0500, [EMAIL PROTECTED] wrote: > > I am having a problem with MySQL that I believe is related to SMP. I > have a machine that is an exact copy of another machine, only > difference is that this one is Dual processor, and the other one is > single. The single one

Re: problem with mysql connection

2002-01-04 Thread Carl Troein
naveed abdul writes: > Can't connect to local Mysql server through socket > '/var/run/mysql/mysql.sock' Along with that you get an error code which you should look up (using perror). Without knowing what the error is it's sort of hard to tell you what to do about it, but the most common proble

Re: Problem with MySQL 3.23.40 Install..Source Compiled

2001-09-17 Thread jim barchuk
Hi Bob! > I use Caldera Linux and have a 4 machine LAN. > The Lan includes 3 Linux and 1 WinNT install. > Now, no matter what I do safe_Mysqld continues to start > version: 3.22.32-log .. This is more of a *nix question than a mysql question but whatever. :) I use redhat but the concepts are

Re: Problem with MySQL over HP-UX 10.20

2001-08-07 Thread Jose Vilmar Estacio de Souza
Hi! We had the same problem. Apparently, this is caused by the missing of some patches. After we applied the patches listed below, the problem disappeared. phco-23684, phss-12727, phss-19739 phss-23672. If I am not mistaken, they are related to dce. {}S Jose Vilmar Estacio de Souza MailTO:

Re: Problem with mysql connections.

2001-05-22 Thread Colin Faber
see GRANT in the manual. Snehalata wrote: > > Dear Sir, > > We installed MySql server on one system. I have the test database, and My > own database named Gomoos. When i using to connect to the database using > java program with a jdbc driver i am not able to connect to my database > "Gomoos"

Re: Problem with mysql

2001-05-18 Thread Van
Andrew Wafula wrote: > > Hello, > > I have installed the mysql-max version 3.23.38 and I > now have a problem with mysql. Whenever I try to > access mysql I get an error when loading mysql.so that > mysql_init is an undefined symbol. > > Where could the problem be? > > Andrew > >

Re: Problem with mysql query

2001-04-24 Thread Peter Skipworth
Barry, I suspect you might have more luck sending your question to a PowerBuilder list (what is it anyway ? A Borland product ?), althought you might have some luck here... regards, P On Tue, 24 Apr 2001, Barry Reynolds wrote: > I am having a problem with setting up a query in using MySql. Th

Re: Problem with mysql++, Aborted (core dumped)

2001-04-16 Thread Sinisa Milivojevic
Luis E. Cruz Campos writes: > I am trying to prove a small program of test, but when trying to execute it > this always it throws "Aborted (core dumped)", this happens at the time of > making the connection: > > It is the program: > > #include > #include > #include "sqlplus.hh" > > cchar *u

Re: Problem with mysql++, Aborted (core dumped)

2001-04-16 Thread Sinisa Milivojevic
Hi! MySQL++ can not be used with g++ 2.96 as it is very unstable when it comes to high C++. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]

RE: Problem with mysql++, Aborted (core dumped)

2001-04-16 Thread Sander Pilon
"Aborted" in a C++ program usually means an exception was thrown that you didn’t catch. In this case, the connection constructor could have thrown something. try { Connection MySQL(db, host, user, pass); } catch(...) { cout << "Connection failed." << endl; } Check the e

  1   2   >