MySQL connection failed with NIS

2003-05-30 Thread Zengfa Gao
Hi,

I installed MySQL 3.23.54 on HPUX system with NIS.

If I run /opt/mysql/bin/mysql -hlocalhost -uroot
mysql, everything looks fine.

But if I run 
$ /opt/mysql/bin/mysql -hhostname.domain -uroot mysql
ERROR 2013: Lost connection to MySQL server during
query

And I can't connect to MySQL with JDBC Driver. I tried
root user with both
jdbc:mysql://hostname.domain:3306/mysql
and 
jdbc:mysql://localhost:3306/mysql

This is the entries of mysql.user table:
localhost   rootY Y Y .
host.domain rootY Y Y 
host 

Do anyone have some idears?

Thanks very much!

Zengfa



__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



sendsig: useracc failed. 0x200000007ee99a00 0x00000000005000

2003-05-30 Thread Zengfa Gao
Hi,

I tried to run MySQL on HPUX, got this error:

$ /opt/mysql/bin/mysql -hhostname.domain -uroot mysql 
 

sendsig: useracc failed. 0x20007ee99a00
0x005000

Pid 18403 was killed due to failure in writing the
signal context - possible stack overflow.
ERROR 2013: Lost connection to MySQL server during
query

--- [EMAIL PROTECTED]:/sbin/init.d ---
$ /opt/mysql/bin/safe_mysqld[240]: 18403 Illegal
instruction(coredump)
030529 07:35:19  mysqld restarted

Do anyone have some ideas?

Thanks a lot!

Zengfa


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



sendsig: useracc failed. 0x200000007ee8ba00 0x00000000005000

2003-05-30 Thread Zengfa Gao
Hi,

I got an error when I tried to access MySQL on HPUX
system. Does anyone have ideas what's wrong here?

Thanks!

Zengfa


sendsig: useracc failed. 0x20007ee8ba00
0x005000

Pid 21045 was killed due to failure in writing the
signal context - possible stack overflow.
/opt/iexpress/mysql/bin/safe_mysqld[240]: 21045
Illegal instruction(coredump)
030529 14:01:31  mysqld restarted



__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Name Collision between 9826 9836

2003-01-16 Thread Zengfa Gao
Hi,

I compiled MySQL 3.23.54a on HPUX system, everything
runs fine.

But when I run mysql CLI, I got:

Welcome to the MySQL monitor.  Commands end with ; or
\g.
Your MySQL connection id is 7 to server version:
3.23.54-log

Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.

Name collision between 9826 9836
Name collision between gsi dtc300s
Name collision between dm1521 dm1520
Name collision between c108 c108
Name collision between ovt100 vt100
Name collision between 300 dtc300s
Name collision between t1061 t3700


What's this problem?


Thanks!

Zengfa

__
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




java.sql.SQLException: Communication link failure: java.io.IOException

2003-01-13 Thread Zengfa Gao
Hi,

I compiled MySQL 3.23.54, try MySQL CLI. Everything
looks fine. But when I tried to connection MySQL
through mm.mysql JDBC Driver, I got:

08:25:09SQLDataManager: Connecting...
jdbc:mysql://localhost:3306/mysql
08:25:09SQLDataManager: EXCEPTION:
java.sql.SQLException: Communication link failure:
java.io.IOException
08:25:09SQLDataManager: LEAVING:
openRepository(boolean)


What this mean? MySQL Java code and JDBC Driver works
fine when I download old MySQL binary to my HPUX
system.

Thanks a lot!

Zengfa

__
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




java.sql.SQLException: Communication link failure: java.io.IOException

2003-01-13 Thread Zengfa Gao
Hi,

I compiled MySQL 3.23.54, try MySQL CLI. Everything
looks fine. But when I tried to connection MySQL
through mm.mysql JDBC Driver, I got:

08:25:09SQLDataManager: Connecting...
jdbc:mysql://localhost:3306/mysql
08:25:09SQLDataManager: EXCEPTION:
java.sql.SQLException: Communication link failure:
java.io.IOException
08:25:09SQLDataManager: LEAVING:
openRepository(boolean)


What this mean? MySQL Java code and JDBC Driver works
fine when I download old MySQL binary to my HPUX
system.

Thanks a lot!

Zengfa

__
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




Re: java.sql.SQLException: Communication link failure: java.io.IOException

2003-01-13 Thread Zengfa Gao
I also got error from terminal:

sendsig: useracc failed. 0x8003bf6dbe00
0x005020

Pid 3093 was killed due to failure in writing the
signal context - possible static overflow.

I tried to logon on as mysql user. I didn't set
mysql user password.


I looked at hostname-bin.err:

MySQL is restarted.

Thanks for your help!

Zengfa

--- Zengfa Gao [EMAIL PROTECTED] wrote:
 Hi,
 
 I compiled MySQL 3.23.54, try MySQL CLI. Everything
 looks fine. But when I tried to connection MySQL
 through mm.mysql JDBC Driver, I got:
 
 08:25:09SQLDataManager:
 Connecting...
 jdbc:mysql://localhost:3306/mysql
 08:25:09SQLDataManager: EXCEPTION:
 java.sql.SQLException: Communication link failure:
 java.io.IOException
 08:25:09SQLDataManager: LEAVING:
 openRepository(boolean)
 
 
 What this mean? MySQL Java code and JDBC Driver
 works
 fine when I download old MySQL binary to my HPUX
 system.
 
 Thanks a lot!
 
 Zengfa
 
 __
 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
 


__
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




MySQL 3.23 compile error on HPUX IPF

2002-12-30 Thread Zengfa Gao
Hi,

I am trying to compile MySQL 3.23 on HPUX 11.23 IPF.

I am using gcc 3.0. gcc 2.95 is not available on HPUX
11.23.


CC=gcc \
CXX=g++ \
CFLAGS=-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT \
CXXFLAGS=-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT \
CPPFLAGS=-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT \
LDFLAGS=-L/usr/local/lib \
./configure  \
 --prefix=/usr/local/mysql \
 --exec-prefix=/usr/local/mysql \
 --with-libwrap=/usr/local \
 --with-low-memory


gmake

gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include
-I../include  -D_POSIX_C_SOURCE=199506L -D_HPUX_SOURCE
-D__hpux__ -D_REENTRANT  -O3 -DDBUG_OFF
-D_POSIX_C_SOURCE=199506L -D_HPUX_SOURCE -D__hpux__
-D_REENTRANT  -DHAVE_BROKEN_PREAD -DDONT_USE_FINITE
-DHAVE_BROKEN_GETPASS -DNO_FCNTL_NONBLOCK
-DDO_NOT_REMOVE_THREAD_WRAPPERS
-DHAVE_BROKEN_PTHREAD_COND_TIMEDWAIT -c strxmov.c
In file included from /usr/include/pthread.h:7,
 from ../include/global.h:97,
 from strxmov.c:33:
/usr/include/sys/pthread.h:1039: parse error before
'*' token
gmake[2]: *** [strxmov.o] Error 1
gmake[2]: Leaving directory
`/var/mysql-3.23.52/strings'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/var/mysql-3.23.52'
gmake: *** [all-recursive-am] Error 2


Does any one have some ideas?

Thanks!

Zengfa


__
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




pthread error on HPUX 11.23 IPF

2002-12-18 Thread Zengfa Gao
Hi,

I am trying to compile MySQL 3.23 on HPUX 11.23 IPF.

I am using gcc 3.0. gcc 2.95 is not available on HPUX
11.23.


CC=gcc \
CXX=g++ \
CFLAGS=-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT \
CXXFLAGS=-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT \
CPPFLAGS=-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT \
LDFLAGS=-L/usr/local/lib \
./configure  \
 --prefix=/usr/local/mysql \
 --exec-prefix=/usr/local/mysql \
 --with-libwrap=/usr/local \
 --with-low-memory


gmake

gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include
-I../include  -D_POSIX_C_SOURCE=199506L -D_HPUX_SOURCE
-D__hpux__ -D_REENTRANT  -O3 -DDBUG_OFF
-D_POSIX_C_SOURCE=199506L -D_HPUX_SOURCE -D__hpux__
-D_REENTRANT  -DHAVE_BROKEN_PREAD -DDONT_USE_FINITE
-DHAVE_BROKEN_GETPASS -DNO_FCNTL_NONBLOCK
-DDO_NOT_REMOVE_THREAD_WRAPPERS
-DHAVE_BROKEN_PTHREAD_COND_TIMEDWAIT -c strxmov.c
In file included from /usr/include/pthread.h:7,
 from ../include/global.h:97,
 from strxmov.c:33:
/usr/include/sys/pthread.h:1039: parse error before
'*' token
gmake[2]: *** [strxmov.o] Error 1
gmake[2]: Leaving directory
`/var/mysql-3.23.52/strings'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/var/mysql-3.23.52'
gmake: *** [all-recursive-am] Error 2


Does any one have some ideas?

Thanks!

Zengfa


__
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




Compile 3.23.53 error on HPUX 11.11

2002-12-16 Thread Zengfa Gao
Hi,

I just send the one again, hope to find someone to
help me out with MySQL compile.

I am using HPUX 11.11, gcc 3.1.

Thanks!

Zengfa

1. CFLAGS=-fomit-frame-pointer -O3 -fpic CXX=gcc
CXXFLAGS=-felid-constructors -fno-exceptions 
-fno-exceptions -fno-rtti -O3 ./configure
--disable-shared

Thank you for choosing MySQL!

2. make 

Making all in sql
Making all in share
No suffix list.
../../extra/comp_err  czech/errmsg.sys
Usage: ../../extra/comp_err [-?] [-I] [-V] fromfile[s]
tofile
*** Error exit code 255

Stop.
*** Error exit code 1

Stop.
*** Error exit code 1

Stop.
*** Error exit code 1


Some config.log: The file is too big, I can see all.

configure:2216: gcc -c -fomit-frame-pointer -O3 -fpic 
 conftest.c 5
conftest.c:2: parse error before me
configure:2219: $? = 1
configure: failed program was:
#ifndef __cplusplus
  choke me
#endif
configure:2404: checking for C++ compiler version
configure:2407: gcc --version /dev/null 5
gcc (GCC) 3.1



configure:5494: gcc -o conftest -fomit-frame-pointer
-O3 -fpic  -D__STDC_EXT__
conftest.c -ldir   5
command line:1:1: warning: __STDC_EXT__ redefined
command line:1:1: warning: this is the location of
the previous definition
/usr/ccs/bin/ld: Can't find library for -ldir
collect2: ld returned 1 exit status
configure:5497: $? = 1
configure: failed program was:
#line 5475 configure
#include confdefs.h

/* Override any gcc2 internal prototype to avoid an
error.  */
#ifdef __cplusplus
extern C
#endif
/* We use char because int might match the return type
of a gcc2
   builtin and then its argument prototype would still
apply.  */
char opendir ();



command line:1:1: warning: __STDC_EXT__ redefined
command line:1:1: warning: this is the location of
the previous definition
configure:6818: parse error before ')' token
configure: In function `main':
configure:6822: parse error before ')' token
configure:6832: $? = 1
configure: failed program was:
#line 6810 configure
#include confdefs.h


configure: In function `main':
configure:7291: `int8' undeclared (first use in this
function)
configure:7291: (Each undeclared identifier is
reported only once
configure:7291: for each function it appears in.)
configure:7291: parse error before i
configure:7301: $? = 1
configure: program exited with status 1


configure: In function `main':
configure:10120: `bogus' undeclared (first use in this
function)
configure:10120: (Each undeclared identifier is
reported only once
configure:10120: for each function it appears in.)
configure:10120: parse error before endian
configure:10132: $? = 1



__
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




Re: Compile error on HPUX

2002-12-09 Thread Zengfa Gao
Benjamin,

Thanks for you information, now I tried to use gcc
compile:
 CC=gcc CXX=gcc CXXFLAGS=-O3 ./configure 

Configure has no problem. But When I run make, I
got:


gcc -O3 -DDBUG_OFF -DHAVE_BROKEN_PREAD
-DDONT_USE_FINITE -DHAVE_BROKEN_GETPASS
-DNO_FCNTL_NONBLOCK -DDO_NOT_REMOVE_THREAD_WRAPPERS
-DHAVE_BROKEN_PTHREAD_COND_TIMEDWAIT -o hp_test2
hp_test2.o libheap.a ../mysys/libmysys.a
../dbug/libdbug.a ../strings/libmystrings.a -lpthread
-lcrypt -lnsl -lm -lpthread
Making all in sql
Making all in share
No suffix list.
../../extra/comp_err  czech/errmsg.sys
Usage: ../../extra/comp_err [-?] [-I] [-V] fromfile[s]
tofile
*** Error exit code 255

Stop.
*** Error exit code 1

Stop.
*** Error exit code 1

Stop.
*** Error exit code 1
--- Benjamin Pflugmann [EMAIL PROTECTED]
wrote:
 Hello.
 
 On Fri 2002-12-06 at 09:59:25 -0800, [EMAIL PROTECTED]
 wrote:
  Hi,
  
  I just send this email again. Does anyone care
 about
  HPUX build?
 
 You need to be more specific in the future. That
 will enhance the
 chance for someone seing the problem.
 
 I have never used HP-UX. That said, some comments.
 
  --- Zengfa Gao [EMAIL PROTECTED] wrote:
   Hi,
   
   I tried to compile mysql-3.23.49 on HPUX 11.11
   system.
 
 Please include complete info from mysqlbug.
 
   When I run:
   
   CC=cc CXX=aCC CFLAGS=+DD64 CXXFLAGS=+DD64
   ./configure
   
   Everything is fine, no errors.
   
   But when I run: make
   
   I got:
   
   cc: password.c, line 95: error 1000:
 Unexpected
   symbol: char_val.
 
 Which password.c? There are 3 in the source. Please
 include some of
 the make output next time.
 
 [...]
   Do anyone have some ideas?
 
 Presumed this is about sql/password.c, this seems to
 be about
 
   inline uint char_val(char X)
 
 The error you cited is typical, if the compiler does
 not know uint
 as type and therefore considered it a label and now
 bails out because
 there is another label following.
 
 That would mean, uint is not defined.
 include/globals.h defines it if
 the system does not provide it:
 
   #if defined(__EMX__) || !defined(HAVE_UINT)
   typedef unsigned int uint;
   typedef unsigned short ushort;
   #endif
 
 So it seems, configure set HAVE_UINT, but
 sys/types.h either does
 not set it or HAVE_SYS_TYPES_H is unset.
 
 No idea, why configure did not the right thing here,
 but it could be
 that it got confused from several runs. Be sure to
 try with a clean
 tarball again.
 
 HTH,
 
   Benjamin.
 
 -- 
 [EMAIL PROTECTED]
 

-
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list
 archive)
 
 To request this thread, e-mail
 [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try:
 http://lists.mysql.com/php/unsubscribe.php
 


__
Do 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




Re: Compile error on HPUX

2002-12-06 Thread Zengfa Gao
Hi,

I just send this email again. Does anyone care about
HPUX build?

Zengfa

--- Zengfa Gao [EMAIL PROTECTED] wrote:
 Hi,
 
 I tried to compile mysql-3.23.49 on HPUX 11.11
 system.
 
 When I run:
 
 CC=cc CXX=aCC CFLAGS=+DD64 CXXFLAGS=+DD64
 ./configure
 
 Everything is fine, no errors.
 
 But when I run: make
 
 I got:
 
 cc: password.c, line 95: error 1000: Unexpected
 symbol: char_val.
 cc: panic 2017: Cannot recover from earlier errors,
 terminating.
 *** Error exit code 1
 
 Stop.
 *** Error exit code 1
 
 Stop.
 *** Error exit code 1
 
 
 Do anyone have some ideas?
 
 Thanks a lot!
 
 Zengfa
 
 
 
 
 
 __
 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
 


__
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




MySQL Depot on HPUX

2002-12-06 Thread Zengfa Gao
I got a MySQL depot file, but I have some suggestions:

1. On HPUX system, we should not put executable under
/usr/local/mysql, we should be it under /opt/mysql
2. The Data directory for MySQL should be
/var/opt/mysql, not /var/lib/mysql.

Just a thought!

Zengfa

__
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




Compile error on HPUX

2002-12-05 Thread Zengfa Gao
Hi,

I tried to compile mysql-3.23.49 on HPUX 11.11 system.

When I run:

CC=cc CXX=aCC CFLAGS=+DD64 CXXFLAGS=+DD64 ./configure

Everything is fine, no errors.

But when I run: make

I got:

cc: password.c, line 95: error 1000: Unexpected
symbol: char_val.
cc: panic 2017: Cannot recover from earlier errors,
terminating.
*** Error exit code 1

Stop.
*** Error exit code 1

Stop.
*** Error exit code 1


Do anyone have some ideas?

Thanks a lot!

Zengfa





__
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




JDBC on HPUX

2002-05-02 Thread Zengfa Gao

Hi, all:

I meet a problem on HPUX. When I try to connect to
MySQL with JDBC on HPUX. I connect to
jdbc:mysql://localhost:3306/mysql with root, it
failed.

But it works before. Someone told me that it is
becuase of some changes of DNS. When I connect to
MySQL, MySQL translate root to
[EMAIL PROTECTED], but MySQL don't have this
user. Same thing happens if I connect to MySQL with
hostname or full qualified-name. If I change the user
table root@hostname to root@full-qualified-name,
then connect with either hostname or
full-qualified-name, everything is fine.

But I want my application to be easy to install by
customer. Do anyone have any suggestion how to fix
this problem?

thanks!

Zengfa

__
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.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




MySQL using Cygwin DLL on Windows?

2002-04-24 Thread Zengfa Gao

Hi, all:

I read the document, it says MySQL Server runs as a
native Windows application and You will need VC++
6.0 compiler for MySQL Windows source distribution.

But we I try to download Windows binary package, it
says Since mysqlc contains Cygwin runtime DLLs, we
also offer you the Cygwin sourcecode for compliance
with GPL. 

What does this mean? If I install MySQL as native
application, Do I still need to use Cygwin DLL?

Thanks!

Zengfa

__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.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




Binary package for HPUX 11.00

2002-04-12 Thread Zengfa Gao

Hi, all:

Can anyone tell me where can I download formal MySQL
binary package for HPUX 11.00?

On MySQL website, it is still HPUX 10.20.

Thanks!

Zengfa

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.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




MySQL package on HPUX, REDHAT and Windows

2002-04-11 Thread Zengfa Gao

Hi, 

I am looking for MySQL package on HPUX, REDHAT and
Windows. Can anyone tell me where I should look for
standard package for MySQL?

For HPUX, I found one at:
http://hpux.cs.utah.edu/hppd/hpux/Development/Languages/mysql-3.23.42/

Thanks a lot!

Zengfa


__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.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




Use JDBC on Redhat, localhost.localdomain?

2002-04-05 Thread Zengfa Gao

Hi, all:

I am trying to use JDBC to connect MySQL, and use JDBC
to config the MySQL. As default root@default has the
privilege to do everything. So I use JDBC to connect
with root. I got error. [EMAIL PROTECTED]
failed.

I read a note said that this only happen to Redhat.
Any suggestion how to do this?

I am try to not use any thing with COMMAND LINE if
possible.

Thanks!

Zengfa

__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Selecting across servers, JDBC

2002-03-13 Thread Zengfa Gao

Hi, all:

I tried with JDBC, it seem that this is not working.
mm.mysql JDBC will ignore the database name.

Do anyone have the some issues?

Zengfa

--- David Buerer [EMAIL PROTECTED] wrote:
 Gee guys, thanks for the quick answers.  Juding by
 the number of 
 responses you'd think that I asked a simple
 question!
 
 I'm on a 48hr development spree using MySQL for the
 firts time so I 
 haven't gotten knee deep in the documentation yet. 
 It's a great program 
 though...fast...not bloated..simple...feature
 rich...no buffer 
 overruns...What more can I say?
 
 Thanks again,
 David
 
 
 -Original Message-
 From: Gurhan Ozen [EMAIL PROTECTED]
 To: David Buerer [EMAIL PROTECTED],
 [EMAIL PROTECTED]
 Date: Wed, 13 Mar 2002 18:29:34 -0500
 Subject: RE: Selecting across servers
 
  SELECT databasename.tablename.column,
 databasename.tablename.column
  FROM
  databasename.tablename, databasename.tablename;
  
  
  Gurhan
  
  
  -Original Message-
  From: David Buerer [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, March 13, 2002 6:14 PM
  To: [EMAIL PROTECTED]
  Subject: RE: Selecting across servers
  
  
  How do you do it from different databases on the
 same server?
  
  David Buerer
  Senior Designer
  PLA Designs, Inc.
  
  
  -Original Message-
  From: Ken Menzel [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, March 13, 2002 1:21 PM
  To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
  Subject: Re: Selecting across servers
  
  Nope;   two databases on the same server OK,  but
 not different
  servers.
  Ken
  - Original Message -
  From: Cal Evans [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Wednesday, March 13, 2002 4:00 PM
  Subject: Selecting across servers
  
  
  
   Is it possible to issue 1 select that gathers
 data from databases on
  2
   separate servers?
  
   =C=
   *
   * Cal Evans
   * Journeyman Programmer
   * Techno-Mage
   * http://www.calevans.com
   *
   sql, query
  
  
  


  -
   Before posting, please check:
  http://www.mysql.com/manual.php   (the
 manual)
  http://lists.mysql.com/   (the list
 archive)
  
   To request this thread, e-mail
 [EMAIL PROTECTED]
   To unsubscribe, e-mail
  [EMAIL PROTECTED]
   Trouble unsubscribing? Try:
  http://lists.mysql.com/php/unsubscribe.php
  
  
  
  
 

-
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list
 archive)
  
  To request this thread, e-mail
 [EMAIL PROTECTED]
  To unsubscribe, e-mail mysql-unsubscribe-
  [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
 


__
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.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




Connect two SQL database with one connection

2002-03-07 Thread Zengfa Gao

Hi,

I am trying to connection two SQL database with one
connection, such as: 

select name from db1.table1;

select name from db2.table2;

Is this working for JDBD driver? 


Zengfa

__
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.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




MySQL license problem on Windows

2002-03-06 Thread Zengfa Gao

Hi,:

I heard that when we use MySQL on windows, we need to
pay fees. But I can't find anything on MySQL document
to talk about this.

Do you know this problem?

Thanks a lot!


Zengfa


__
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.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




Save object into MySQL

2001-08-07 Thread Zengfa Gao

Hi, 

I want to save object into MySQL database. Since MySQL
in not object relational database, is any problem to
save object into it? Which attribute I should select
to save object? Varchar BINARAY?

Thanks for your help!

Zengfa

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.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