Server :: Mysql In Redhat Two Machine Cluster Not Opening 3306 Port?
Jul 18, 2011
Im having a frustrating issue with my two machine cluster I setup using Conga. Everything was working great except now when lucci starts mysql the port (3306) is never opened to outside machines. I can do a "ps -ef | grep mysql" and see it running as well as login to mysql on the node it is running on - but an nmap of the machine does not show the 3306 port and I cannot login to mysql remotely and yes I turned off all iptables(iptables,ip6tables) and SElinux is disabled.What am I missing here? If I start mysql on my own (and it is using the same my.cnf as lucci is) it does show the port open and works perfect,t for some reason when lucci starts it, no dice
View 1 Replies
ADVERTISEMENT
Feb 2, 2009
I want to change my MySQL default port(3306) as 80 how can i do this on centOS 5.2? I tired to add
[client]
port=80
to /etc/my.cnf and different command in this file. But mysql didn't start. How can do this? I'll use server only as mysql and ftp server.
View 13 Replies
View Related
Apr 12, 2011
when i am enabling mysql in server (port 3306) it does'nt work. but when i execute iptables -F it works what may be the reson?
View 6 Replies
View Related
Sep 3, 2010
Everything default.Everything works nicely with one exception. I can't connect to MySQL from the network.nmapping localhost tells me 3306 is open but nmap from the outside shows only ports 22 and 111 open. To my knowledge I have no firewall, iptables -L gives an empty set.I have several similar installations on the same network without any problems of this nature.
View 2 Replies
View Related
Jan 14, 2010
How do I get mysql 3306 port to be seen on my network?
Here is my setup:
---Desttop - WIndows Vista Ultimate (192.168.0.101)
--------VBox
------------Guest - Ubuntu 9.10 (Joomla CMS Development) (192.168.56.106)
---Server - Ubuntu 9.10 (192.168.0.100)
--------VBox
------------Guest - Ubuntu 9.10 (Joomla Production) (192.168.56.104)
------------Guest - Ubuntu 9.10 (MySql Database) (192.168.56.105)
I can ping all OS from any OS, I can connect to a shares, I can connect to the web server. I can do a netscan and display the open ports and the services for those ports except for MySql. How do get MySql to showup, so I can connect to it from my Joomla CMS? I came from openSuse and I like how they have modules to do this automatically. What do I use with Ubuntu to get the same results?
View 9 Replies
View Related
Jul 18, 2010
I've been working and researching this for about a week now and I still haven't had any luck. Basically, I have been trying to open port 3306 to allow connections to my MySql server.
i've added the rule into iptables, saved and restarted that i've added the rule into my router. and I have removed "skip-networking" from the my.cnf file and added the blind address in, I'm trying to get this all to work on my LAN, but it doesn't seem to work, I've also restarted the entire server and then port scanned it from outside and inside the networking and it still tells me that 3306 is closed.
I did however i had some luck when I entered the Ip of the machine that would be sending data to the server but then PROFTPD stopped working and the port was open :/ im not really sure what ip should be in there but another thread from another forum said to enter the ip of the machine that mysql is installed on.
so currently its 192.168.0.2 which is the static internal address of the server.
every machine on the network has a static ip and all the rules have been added to each firewall, i.e. server and router firewalls.
ill pop my "my.cnf" under this to see if anyone can find a mistake,
Code:
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[Code].....
View 2 Replies
View Related
Jul 23, 2011
I'm new to linux, and setting up the mysql database server.
Here are my situation:
OS: CentOS 6
mysql version: 5.5
I tried to use MySQL Administrator to connect to my database on the host 192.168.1.120
and my computer is under the same network with ip: 192.168.1.105
But it shows the error msg: Could not connect to MySQL instance at 192.168.1.120
Error: Can't connect to MySQL server on '192.168.1.120'(61)(code 2003)
On the server side I've tried:
Code:
skip_networking is off and I've set the port for it.
When I check the process in OS:
Code:
When I try netstat:
Code:
I thought it's the problem of firewall, so I have check it also:
Code:
View 3 Replies
View Related
Mar 22, 2010
I'd love a hint or two on the following problem. I've set up iptables rules to forward all connections to port 3306 to a non-standard mysql port on a remote server. This works, except that I need to deal with the loopback interface in a special way and I'm stuck.
Code:
iptables -t nat -A PREROUTING -p tcp --dport 3306 -j DNAT --to 128.XXX.XXX.XXX:3197
iptables -A FORWARD -p tcp -d 128.XXX.XXX.XXX --dport 3197 -j ACCEPT
iptables -t nat -A POSTROUTING -j MASQUERADE
Since locally-generated packets will never hit the PREROUTING rule, you'll need to setup a near identical rule using OUTPUT to make it work. Here is what I've tried:
[Code]...
View 4 Replies
View Related
Jul 19, 2011
I'm trying to build cluster computer system using redhat linux enterprise 5.5. And I'm on the step to set up the NFS mounting. (step 3 of part VI on this paper: However, I kept getting "permission denied" when I used the command "mount -t" to mount the slave node onto the hard drive of the master node. Even when I edited /etc/fstab file to make it automatically set up during booting, I still receive the same result. By the way, I've already logged in as a root user on both slave and master nodes.
View 1 Replies
View Related
Jun 14, 2009
what rpms should I need install for setting up redhat cluster on RHEL 5.0 I want to create two RHEL 5.0 nodes as one cluster having oracle database server installed. And please note I have created these two nodes on VMware server for testing purpose. is it possible for creating cluster of two virtual guests.
View 3 Replies
View Related
Mar 20, 2011
I am planning to configure RedHat cluster on vmware, i dont know how to configure, i googled a lot but couldn't find satisfactory docs for configuring, can any one provide me step-by-step or good docs to go ahead.
View 1 Replies
View Related
Oct 25, 2010
I have two node redhat cluster for mysql database.The problem is that after updating the packages on both of the nodes after and previously the sevices was not able to relocated on second one , even rebooting the server the problem occurs.While starting the service on second node it started on the first one.Other services are running fine on both nodes.I have checked the /etc/hosts, bonding and many more files and seems to good.find the log for reference.
<notice> Starting stopped service service:hell
Oct 22 14:35:51 indls0040 kernel: kjournald starting. Commit interval 5 seconds
Oct 22 14:35:51 indls0040 kernel: EXT3-fs warning: maximal mount count reached, running
[code]...
View 1 Replies
View Related
Sep 17, 2009
I am trying to create a 2nd node from last couple of days but no luck.do this.I have gone through these article again and again:Here is my setup
node1 ( ricci + luci) : which is working fine
node2 (ricci only) : this is giving me problem
node1
[code]...
View 1 Replies
View Related
Dec 22, 2010
I have added apache application into redhat cluster. If the apache process failed, it will cause the service group fail over. I want to disable the application monitoring. I search throung Internet and it depends on the apache init script. If I change /etc/init.d/httpd status always return 0(success). THe service group will not fail over even apache failed.
However, I want to remain the application monitoring but stop failover. If the application like apache failed, I want Redhat cluster to try restart the application like 3 or 4 times. If restart failed, it will not failover.
View 1 Replies
View Related
Dec 22, 2010
I want to create redhat cluster on(vmware) OS Redhat Enterprise Server 5.5
Install Luci on node1
Install ricci on node2
Install ricci on node3
All the computer name records in all system host file. When I try to create new cluster( luci_install init) then showing error...
Status messages:
* Host stationx.example.com is already authenticated
* Host stationy.example.com is already authenticated
[dismiss]
The following errors occurred:
* Unable to create the cluster Luci database objects
***No any cluster.conf file created on any node
I have reinstall the node, but getting same error.
View 1 Replies
View Related
Dec 26, 2010
I have setup a MySQL High Availability Cluster with two nodes using DRBD & Heartbeat. I have successfully installed the cluster but one question which is still not solved is that Heartbeat monitors failover of network or server failure, etc.
What will happen if MySQL service gets stopped or do not start. This heartbeat-DRBD cluster does not take any action on that part. Now I want to enable this feature too which also monitors MySQL service. I have gone through MON help on web but could not find out any good step by step tutorial.
View 11 Replies
View Related
Mar 10, 2010
How do I check port 3306 to see if it is being used? I am unable to get MySQL to run with a LAMPP 1.7.3a installedon Ubuntu 9.10. The Apache server and ProFTPD start fine.
View 2 Replies
View Related
May 21, 2010
With the new realease of Ubuntu 10.04 LTS, I was wondering if there was going to be a package for installing Mysql Cluster Server 7.1
If not does anyone know of a good walkthrough for compiling and installing it in Ubuntu 10.04 LTS?
View 8 Replies
View Related
Feb 16, 2009
I'm probably dreaming, but I have a hobby project in mind that I would like feed I have an opportunity to purchase a 3 year old fully populated (14 x 3Ghz dual Xeon nodes) IBM bladecenter relatively inexpensively.I thought it would be fun to set it up as a beowulf cluster with open source xen and test the market to see what people would pay for Private virtual machines.
My thoughts are to use 64 bit Centos 5 as a base to get the beowulf cluster up and then load xen.I haven't really looked at the market but I figure I should be able to run 50 private virtual machines charging say $50 per month. I figure I can use rsync to backup the virtual machines to a different location. I plan to connect to linux based Network Storage running 3 x sata 1TB drives, probably via iSCSI. Along with the drive capacity currently on the blades I should get 2-3Tb online capacity over a Gbit network. (Cisco 14 + 4 network switch module)
I realise I have a bit of setup work to do and before I go investing a lot of time and a little money I'd appreciate some pragmatic advice as to why this may be a stupid venture.
View 2 Replies
View Related
Jan 28, 2011
I am trying to run a minecraft server from my slackware machine, but i am having an issue.The port for minecraft (25565) is open on my router, but it is reported as closed by all the open port check tools. I noticed that the same was happening for my VNC server. the port reports itself as closed until i actually open the vnc server software. for examplei check the vnc port (5900) when the vnc software is not running, and it is reported as closed. nmap localhost gives the following:
Code:
Not shown: 993 closed ports
PORT STATE SERVICE
[code]....
View 14 Replies
View Related
Oct 25, 2010
Yesterday, when I was installing Redhat Enterprise 5.4 on a HP server, I asked myself "how can I regain my access to the server if I happen to forget the root password?" I knew there must be a way. I consulted with my friend "Google". I'd like to share it here as my 1st post (too bad that I'm not allowed to paste screenshots)
1) Boot up the server, when you are at the "Red Hat Enterprise Linux Server..." entry, press "e".
2) Highlight the "kernel /vmlinuz...." line then press "e" again.
3) Type the word "single" to the end of the line (with an empty space before the word single). Press Enter.
4) Press "b"
5) System will boot. When you get the prompt "#", type "passwd" to enter in new password for root.
6) Reboot the system. Done
View 1 Replies
View Related
Apr 27, 2011
I'm trying to open up some ports to connect via vnc to a server running Centos 5.5. I've edited /etc/sysconfig/iptables everything *looks* fine, but I still can't seem to get access to the port I've opened (I added some newlines for clarity between commands):
[Code]....
View 4 Replies
View Related
Dec 2, 2010
Trying to build a RAC server. I have 5 ips that the Network Team has provided with. They are like this:
LAN IP (IP & Cable, which means physical card is present)
TSM IP (Tivoli Storage Manager-Backup) (IP & Cable)
ISO1 (Heartbeat 1) (IP & Cable)
[code]....
View 2 Replies
View Related
Mar 16, 2011
I would like to connect via SSH or similar to my servers located in a remote DC from a laptop running centos5. I normally do this on a puter running dows, and using secureCRT. Just wondering if centos has something built in for this, or if there is some preferably free software I can get.
View 7 Replies
View Related
Apr 14, 2010
I am trying to configure redhat cluster first time but no idea how to do it. I am using rhel 5.2. I have copied cluster rpms from redhat media and tried to install them but facing alot of dependencies problem. Can some one please guide how can i do redhat clustering from start. I am doing this for configuring single node clustering for zimbra suite but it is the requirement to configure redhat cluster first. One more thing i am using two virtual machines installed by using virtual box.
View 3 Replies
View Related
Mar 15, 2011
I'm having a very strange problem with red hat cluster. After testing it in the lab, I tried to install a new cluster and received the following error: cman not started: Cannot start, cluster name is too long or other CCS error /usr/sbin/cman_tool: aisexec daemon didn't start I've checked the internet for that error, but nothing. I decided to to take the example from cluster.conf man, which looks like that :
[Code]...
And still I get the same error. I can find my servers both from DNS (FQDN and short name) and they also appear in /etc/hosts.
View 3 Replies
View Related
Mar 18, 2011
I was given task to install redhat linux os on one of the compute node on server which doesn't have cd/dvd drive or usb port.I have installation media as well ISO image. This server is on network, so I can access it via my PC which is running window 7.I think, I have 2 choice to install:1. Copy iso image to head node on server and then install linux os on compute node via nfs.r2. Use my PC dvd drive to install linux on compute node via network.But I don't know how to do it.
View 2 Replies
View Related
May 6, 2009
i am using the redhat cluster suite (luci and ricci) on my centos 5.3. i have 2 nodes in a cluster. when i poweroff the first node on wich a vm service is running, the service switchtes to node2. so far, so good :) but when i restart node1 the service is not failback to node1! i have created a failover domain with both nodes and priorized whre node1 has prio1 and node2 has prio2.
View 4 Replies
View Related
Apr 9, 2010
I have a 2 node RH 5u4 64-bit. I have installed and configured the latest Veritas CFS (Cluster File System) which also uses Veritas Cluster Server. File system if VxFS. Storage is on EMC Symmetrix arrays with Veritas Mirroring between the arrays.We have noticed that running 'du -hs' on the shared directory/filesystem where it takes about 3 minutes on one node and 30 - 45 minutes on the other node.I've been running strace on 'du'.'du' runs an 'lstat' on each file (66,000+ files). On the slower node, the ave time spent in 'du' is about .001 seconds longer, which accounts for the 30-45 minutes. Also, the standard deviation is much larger, which means to me that the lstat times are all over the place!Another interesting thing is that iozone profiling shows that the i/o rates from both nodes are darn near identical, with no anomalies at various buffer & file sizes! And, iostat looks really good as does 'vxdmpadm iostat show
View 3 Replies
View Related
Apr 5, 2010
If I have 2 MySQL server and I want to replicate their database to only 1 server, is it possible? I cannot afford to have master-to-master only because I still need to replicate one more machine but I do not have anymore more machine for replication so I'm thinking if these 2 MySQL server can be replicate to only 1 machine. If this is not possible, I guess I've no choice but to have two mysql daemon on that machine
View 5 Replies
View Related
