Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Boon Chee on May 29, 2003, 10:16:15 AM

Title: Connecting Navicat to MySQL server Problem.
Post by: Boon Chee on May 29, 2003, 10:16:15 AM

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!

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: guestHH on May 29, 2003, 12:09:40 PM

what error do you get?

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: Boon Chee on May 29, 2003, 12:18:00 PM

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!

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: IDar on May 29, 2003, 04:42:44 PM

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

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: guestHH on May 29, 2003, 05:30:35 PM

who is boon? it should be root.

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: IDar on May 29, 2003, 09:36:52 PM

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?

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: Boon Chee on May 29, 2003, 09:37:03 PM

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!

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: Boon Chee on May 29, 2003, 09:40:33 PM

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?

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: IDar on May 30, 2003, 12:49:40 AM

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

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: Jochen Hoegerl on May 30, 2003, 01:23:20 AM

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

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: Boon Chee on May 30, 2003, 03:09:51 AM

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!

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: Luk Vermeylen on May 30, 2003, 12:43:07 PM

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

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: Orion on May 30, 2003, 12:47:12 PM

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!

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: Luk Vermeylen on May 30, 2003, 01:08:25 PM

I solved the problem without installing the rpms

Luk

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: Orion on May 30, 2003, 01:11:57 PM

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!

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: Luk Vermeylen on May 30, 2003, 01:31:31 PM

I've installed phpmyadmin, added a user with rights to access from every client

then i tried to connect via navicat, saw the error, searched, found the bug description and tried. I wanted a solution without changing e-smith 5.6 (rpms)
Then I found the solution I described before and it works for me (after restarting mysql)

Luk

Title: Re: Connecting Navicat to MySQL server Problem.
Post by: IDar on May 30, 2003, 04:34:43 PM

Luk Your suggestion doesn't work for me...
I'm downloading the RPM's to try,
thanks

Title: Yesssss
Post by: IDar on May 30, 2003, 04:48:32 PM

It works, i updated the RPM's and works :D
thanks to everybody

Title: not so good....
Post by: IDar on June 02, 2003, 04:11:26 PM

I've updated both glibc-common and glibc to solve an MySql connection error and naw i can't log with my user neither by ssh nor by mail...
That's the error i get:
Error del servidor. Cuenta: 'admin@gaf.ruizlizondo.com', Servidor: 'gaf.ruizlizondo.com', Protocolo: POP3, Respuesta del servidor: 'Incorrectly built binary which accesses errno, h_errno or _res directly. Needs to be fixed.', Puerto: 995, Seguridad (SSL): Sí, Error de servidor: 0x800CCC90, Número de error: 0x800CCC90

I've been looking the logs and i've seen this error in the server startup:

May 30 14:25:35 idar rc: Starting autofs: succeeded
May 30 14:25:35 idar cvm-unix: Starting cvm-unix:
May 30 14:25:35 idar cvm-unix: Incorrectly built binary which accesses errno, h_errno or _res directly. Needs to be fixed.
May 30 14:25:37 idar cvm-unix: Starting cvm-unix succeeded


Anybody knows what to do?
Thanks in advance