Re: MySQL client not connecting to management server?

I just figured out the problem. I guess the mysql rpms' from the site don't come built with NDB support anymore so you have to build it yourself now. I built MySQL with --prefix=/usr/local and took me forever to figure out MySQL would then look for its my.cnf file in /usr/local/etc. This was very confusing because ndbd looks for it in /etc so I had to create a symbolic link from /etc to /usr/local/etc. Is the ndbd binary hard coded to look for your configuration in /etc? If it wasn't then I could have solved my problems earlier by having mysqld reading the right configuration file.

Thanks,
- Jake

On 9/25/07, Jake Conk <jake.conk@gmail.com> wrote:
> Hello,
>
> I downloaded and installed the following rpms from the downloads page:
>
>
> MySQL-server-5.0.45-0.glibc23.x86_64
> maxdb-ind-7.6.0.37-1.x86_64
> maxdb-srv76-7.6.0.37-1.x86_64
> MySQL-client-5.0.45-0.glibc23.x86_64
> MySQL-ndb-storage-5.0.45-0.glibc23.x86_64
> MySQL-ndb-management-5.0.45-0.glibc23.x86_64
> MySQL-ndb-tools-5.0.45-0.glibc23.x86_64
> MySQL-ndb-extra-5.0.45-0.glibc23.x86_64
>
>
> I have my management node setup to allow connections from
> 192.168.10.20 and when I run ndb_mgm -e show I see it expecting them:
>
>
> # ndb_mgm -e show
> Connected to Management Server at: localhost:1186
> Cluster Configuration
> ---------------------
> [ndbd(NDB)] 2 node(s)
> id=2 @192.168.20.30 (Version: 5.0.45, starting, Nodegroup: 0)
> id=3 (not connected, accepting connect from 192.168.20.40)
>
> [ndb_mgmd(MGM)] 1 node(s)
> id=1 @192.168.20.1 (Version: 5.0.45)
>
> [mysqld(API)] 4 node(s)
> id=4 (not connected, accepting connect from 192.168.20.10)
> id=5 (not connected, accepting connect from 192.168.20.20)
> id=6 (not connected, accepting connect from 192.168.20.30)
> id=7 (not connected, accepting connect from 192.168.20.40)
>
>
> I have the following added in my my.cnf on the client nodes:
>
>
> [mysqld]
> ndbcluster # run NDB engine
> ndb-connectstring=192.168.20.1 # locataion of MGM node
> [mysql_cluster]
> ndb-connectstring=192.168.20.1 # location of MGM node
>
>
> I started my data nodes with ndbd.
>
> I'll then just try to start up mysqld with rcmysql and the client node
> won't show that its connected with the management node. What am I
> missing to get my mysql client to connect to the management node?
>
> Thanks,
> - Jake
>

-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com