Topic: Connecting Navicat to MySQL server Problem.

[Boon Chee]

Hi guys,

I have SME 5.6 installed to run as the Web and MySQL server in my LAN.

I am using a MySQL GUI administration program called Navicat (www.mysqlstudio.com) on my Windows 2000 laptop to connect to the SME 5.6 box within the LAN, on the same subnet.

I have been trying for 3 days using all sorts of methods, but it seems the MySQL server in SME 5.6 rejects all connection from this GUI program.

Can somebody help me to solve this problem? I really appreciate your help.

Thanks!

[guestHH]

what error do you get?

[Boon Chee]

The error message generated by Navicat is "could not connect using boon@192.168.1.7"

192.168.1.7 is where MySQL server located.

Thanks for helping!

[IDar]

I also can't connect... navicat is unable to connect...
Any idea?

[guestHH]

who is boon? it should be root.

[IDar]

Let's assume the user is an authorized user... as example admin and that he can access from localhost with password pass...

Even by changing the domain in the user table i can't connect... but i can do to a RH9 server with the same mysql config....


what's wrong?

[Boon Chee]

I have tried using root to connect, I have tried granting user privileges in the User and Values Table of MySQL database, none worked.

I have a friend who is using a full-fledge Redhat 8 with MySQL installed, he has no problem connecting the Navicat from his Windows desktop to the Linux box.

I suspect that there must be some configurational problems in the MySQL server that comes with SME 5.6

Can someone enlighten me with this problem?  Thanks heaps!

[Boon Chee]

I ever tried and stumble across error messages that MySQL generated after trying to connect using Navicat, it says there is an error on line 273 of something and the server is automatically shutdown and restarted with a new process id.

Anyone has the similiar experience?

[IDar]

That's my error:

Number of processes running now: 1
mysqld process hanging, pid 23401 - killed
030527 11:44:15  mysqld restarted
/usr/libexec/mysqld: ready for connections
Number of processes running now: 1
mysqld process hanging, pid 11578 - killed
030527 11:44:23  mysqld restarted
/usr/libexec/mysqld: ready for connections

I think it's the same that your's, but i have no idea about what's wrong

[Jochen Hoegerl]

Have a look at this thread.

http://www.e-smith.org/bboard//read.php?f=1&i=23210&t=23210

it should do the trick.....


jochen

[Boon Chee]

Thanks Jochen, I am trying this out, will inform you the outcome of this solution.

Perhaps IDar should also try this out to see whether the result can be repeated by another party.

Thanks in advance!

[Luk Vermeylen]

It appears to be a bug and I solved it by adding following into my.cnf
under [mysqld] i've put

set-variable= tread_stack=256K

this rule solved the problem for me (found this somewhere in bugzilla archives)


http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75616


Luk

[Orion]

I tried to run the command to install the rpms that I downloaded, but there is an error message, is there anyone who can help to solve this? I still can't connect the Navicat in Windows to the SME 5.6 MySQL server.

[root@NEO files]# rpm -Uvh *.rpm
error: failed dependencies:
        glibc = 2.2.5-43 is needed by glibc-debug-2.2.5-43
        glibc-devel = 2.2.5-43 is needed by glibc-debug-2.2.5-43
        glibc-common = 2.2.5-40 is needed by glibc-2.2.5-40

Thanks!

[Luk Vermeylen]

I solved the problem without installing the rpms

Luk

[Orion]

are you using SME 5.6 and trying to connect from a windows box running Navicat?

Please give me some steps to follow as I am new to this thingy...

Thanks!