General :: "Lost Connection To MySQL Server" When Using Different Port?

Apr 28, 2011

I'm getting the following error on my webpage :Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /var/www/vhosts/...When I use the default MySQL port 3306, then I have no error.But when I use port 33060, then I get the error !My /etc/my.cnf :

Code:
[mysqld]
datadir = /var/lib/mysql

[code]...

View 1 Replies


ADVERTISEMENT

General :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)

Jun 2, 2010

i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error

[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.

[code]....

i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.

View 9 Replies View Related

CentOS 5 Server :: Changing Default Mysql Port As 80 From 3306

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

Red Hat / Fedora :: Enabling Mysql In Server (port 3306) It Doesn't Work?

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

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 View Related

Server :: Remote MySQL Server Connection Dies After Wget Large File

Feb 3, 2011

We have 2 servers, 1 is the webserver and the other is the Mysql server.

When transfering a 2GB file from the webserver to the Mysql server.

The webserver's connection to the mysql DB server dies completely.

Need to restart the MYSQL process in order for it to come back online.

During this connection downtime, when using phpmyadmin on the mysql server shows no problem running queries etc.

View 2 Replies View Related

Ubuntu Servers :: SSH Server - Connect To Server Via Port 443 I Get A Connection Refused Error?

Jan 7, 2011

I am merely trying to change the port for my ssh server.However it isn't changing.I edited my ssh_config file to:

Code:

# This is the ssh client system-wide configuration file. See
# ssh_config(5) for more information. This file provides defaults for[code]...

When i try to connect to my server via port 443 i get a connection refused error. However when i try to connect via port 22 it connects. Since that didn't work, i tried restarting the entire server.To restate, i changed the config file and restarted ssh then the computer, however the port didn't change.Ohh and yes my router is set to port forwarding on port 443, though it doesn't matter since I'm inside the network.

View 2 Replies View Related

Server :: LAN Connection Between Mysql And Apache?

Jul 29, 2010

Running slackware13.1 with mysql on box2 and apache on box1 both in same lan. How do i configure mysql for apache connection? I have looked at many mysql config. howto which i can follow but i'm confused about whether the connection type is considered remote connection because the 2 services are on seperate boxes but are in same lan? Apache will be serving public webpages not just to the lan.

View 1 Replies View Related

General :: Changing Mysql Default Port?

Jul 19, 2011

I'm trying to change the default mysql port with no success. I looked at my.cnf file and there's no reference to port. I also looked at the iptables and mysql is running on 3306 (default).I've changed the iptable file but mysql fails to restart.If I add port = [my port number] to the my.cnf file, mysql fails to start.

View 4 Replies View Related

Server :: Mysql Command To Allow A Remote Connection?

Jun 8, 2010

what is the correct command on a mysql command line to alllow mysql to alllow remote connection on a server

View 1 Replies View Related

Server :: MySQL Query Browser Connection Help

Jan 28, 2010

i have MySQL on my CentOS server and have installed it and got it up and running through the command line.

I have changed root's username and password so there is no user called 'root' anymore. I also created a database called pancakes.Now when i try to log in using Query Browser, i put the server's IP in 'hostname', my new roots username and password in 'username' and 'password'.When i try to log in it gives me error 1130 and says connection from myhostname not allowed.

View 6 Replies View Related

Server :: Postfix And Amavist - Lost Connection While Sending End Of Data

May 24, 2010

Since today morning we are getting this error, could not track down the cause

We are running :
Postfix
Amavist and Clam

70A6C45A1CE: to=<actualemailid@yahoo.com>, relay=none, delay=0, status=deferred (delivery temporarily suspended: lost connection with 127.0.0.1[127.0.0.1] while sending end of data -- message may be sent more than once).

View 6 Replies View Related

Server :: Postfix Connection Refused (port 25)

Aug 7, 2010

I have just built a new postifx open relay server to allow my ISP clients to send emails. During testing of the SMPT protocol, I can managed to send emails to my localhost however, I can't send emails to other external mail server. Below is a test to a yahoo account. Aug 7 15:03:55 mx2 postfix/smtp[4050]: connect to g.mx.mail.yahoo.com[98.137.54.238]: Connection refused (port 25) Aug 7 15:03:55 mx2 postfix/smtp[4050]: F084EC8D76: to=<ellyu4@yahoo.com>, relay=none, delay=8.5, delays=1.2/0.05/7.3/0, dsn=4.4.1, status=deferred (connect to g.mx.mail.yahoo.com[98.137.54.238]: Connection refused)

[Code]....

View 16 Replies View Related

Server :: MySQL Connection Via Auxiliary Network Card

Dec 18, 2010

I'm dealing with two dedicated servers hosted at liquidweb. The basic idea is that one machine might not be enough to handle the traffic at launch so we have a second machine to shoulder the MySQL duties -- it seemed a natural way to divy up computation burdens.

The support staff at LW tells me that each machine has three network cards

1) Public-facing NIC through which all public visitors are served

2) NIC on LAN so that liquidweb can access the machine locally for maintenance and support

3) Third NIC so that the two machines can speak to each other rapidly on their own private network. Apparently the two machines are connected via crossover cable.

It's my understanding that machine 1 has IP of 192.168.0.1 on this third card and machine 2 has IP of 192.168.0.2 on its third card. For some reason, these machines cannot speak to each other using ping, telnet, ssh, http, or MySQL.

I've contacted tech support about this issue but was wondering how I might be sure that the MySQL traffic transits the third network card on each machine. I'm guessing that it's just a matter of using the third card's IP addresses but want to be sure. Is there any way to specify a NIC when connecting via MySQL?

View 1 Replies View Related

Server :: MySQL Odbc Connection Remote Client?

Jul 27, 2010

I wish to connect to MySQL using an ODBC connection and I'm using isql to test. On the server connection using isql to local host is sweet however the problem is the client.Okay my set up looks like thisOn the server /etc/odbc.ini is[MySQL-scopus2008]Description = MySQL citation databaseDriver = MySQLServer = localhostDatabase = scopus2008Por

View 4 Replies View Related

Ubuntu Networking :: Connection Lost On Opening Webpages - Server Not Found

May 10, 2011

On a school network the Windows and Mac computers connect to the internet with no problem. The Ubuntu(10.04) computers are connected and work on the internal network but have major issues going out of the building. I can get to one or two webpages to open and the connection dies...Server not found. Ping within the network and there are no lost packages, if I ping outside many lost packages.

We are using SonicWall and think it could be blocking...but why only Ubuntu? This is the same behavior for Firefox and Seamonkey. It's also the same for the thin/fat clients and standalone units. I did try a fresh install with no effect. The internet actually works on the one machine with ubuntu 9.10. I brought a machine home and it connected to the internet with no problem.

Two things I can think of that would of caused this are:
1- we keep getting windows about missing applets, someone may have clicked delete
2- I connected a server to run fat clients w/ LTSP and discovered my server and the schools were handing out the same ip's.

View 2 Replies View Related

General :: Connecting To Mysql Database Remotely Via Port 3306 ?

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

Server :: Restrict Remote Telnet Connection + Port 80?

May 5, 2011

Is it possible to restrict telnet connection from remote to my server(linux -centos5)?

=================
Ex : [root@localhost]# telnet 10.0.0.33 80
Trying 10.0.0.33...

[code]...

View 2 Replies View Related

Server :: Setup A Database Using Mysql - Always Get A Connection Refused Error

Mar 2, 2010

I'm try to setup a database server using mysql, the server starts fine, and I can access it using the built in mysql client via console (adding databases and tables works fine), but the problem is... I always get a connection refused error whenever I access the database outside the built in mysql client (example, if I write a code that connects to mysql). So, I tried execute an nmap command and the only ports open are these ports:

[Code]....

there's no 3306 for mysql... I'm thinking that the firewall is just blocking the port that mysql is using, but my question is, how could the built in client connect to the server if there's no open port for mysql server? Don't clients usually access a servers through ports?

View 4 Replies View Related

General :: SFTP Server Port Blocked On Uni Network / Need To Change Listening Port

Oct 21, 2010

VERY new to linux, erm but I have an issue that needs solving!I recently moved to university, where their network blocks sftp port 22, this means that I cannot connect to my FTP server which is running a version of linux.Now I've got this ftp server connected to a seedbox and it was created using the following walk through..Code:I have written this guide for a friend, but I though it would be useful for others as well.

There are several guides floating around, but I found that most always cock up in some way. This one is tried and tested to work on Debian Etch (on an OVH rps, but should apply to most servers).If there is a new stable release of rtorrent/libtorrent then I will update this guide to show you how to update it (without reinstalling the whole server).

At the bottom there are also instructions to install ftp access & some network monitoring software.Basically, I would really like someone to be able to construct the commands on how to change the listen port for sftp connection on linux or add another port to the list that Linux would use so that I could put in through putty.

View 2 Replies View Related

Server :: Cannot Send Outbound Mails Connection Timed Out (port 25)?

Feb 4, 2011

I've ben punding myhead on this issue. I've setup a new postifx server on rhel5. After editing the needed entries, i can't seem to send any outbound mails to yahoo or any other domains.My postconf -n is as follows:

alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
command_directory = /usr/sbin

[code]...

View 2 Replies View Related

CentOS 5 Server :: Port Configuration - Being Blocked - Iptables And Connection

Jul 4, 2009

I have a fresh installation of CentOS 5 I'm using for a server, and I'm having issues with port configuration. I have iptables running, and it started with no /etc/sysconfig/iptables file. I added a few basic rules (port 53, port 10000 for webmin), saved the file, and restarted the service. I tried connecting to webmin, scanned ports, and traffic was blocked. I set iptables to allow all traffic and restarted the service, and it still showed basically every port as being blocked. It seems port 80 and port 22 work for some reason, even when I tell iptables to block all ports.

I'm not sure what's going on here. Iptables is reading the /etc/sysconfig/iptables file, and if I use lynx localhost:someport it responds as it should according to the file. However, if I try connecting by IP, it's like there's some other firewall or something running that does whatever it's configured to do.....

View 2 Replies View Related

General :: Lost Connection While Yum'ing / Can't Do Now - Fix It?

Dec 3, 2010

I was using yum to update a server, then my putty session to the server dropped.

I reconnected, and now when i try to do a yum list updates, i get the following message:

Another app is currently holding the yum lock; waiting for it to exit...
The other application is: yum
Memory : 42 M RSS ( 53 MB VSZ)
Started: Fri Dec 3 12:05:30 2010 - 06:55 ago
State : Sleeping, pid: 21762

Does that mean its still installing the updates i asked it to, and i just need to wait for that to finish so i can see what updates are left? or am i really in a bad spot now?

View 4 Replies View Related

Ubuntu Networking :: Lost Internet Connection - Firefox Displays Server Not Found Page

Apr 6, 2011

I have been using ubuntu netbook 10.10 on my Dell Mini 9 for the past few month without any problem; it connects wirelessly to the internet via a wireless router. Yesterday in the middle of web surfing, suddently firefox cannot see any website outside of my home network (Firefox displays Server not found page). No help when I rebooted a few times and connect to my home network via wireless or even wire cable; it can access files in my network file server (DNS-321) but not the internet. My desktop computer running Windows Vista and ASUS media player has no problem accessing the internet.

View 1 Replies View Related

Server :: IPtables - SSH Running On Port 2298 (Host Connection Refused)

Aug 1, 2011

I have 2 servers..
let say server A and server B
On server A open ssh is configured and is running on port 2298. So from my machine I can login there using ssh on port 2298
But when I login to server B and from there I try to connect to server A I cannot.
ssh: connect to host <ipaddress here> port 2298: Connection refused

View 2 Replies View Related

OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock

Jun 7, 2011

I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:

Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory

[Code]...

View 6 Replies View Related

Server :: Ssh: Connect To Host Sage.math.washington.edu Port 22: Connection Timed Out

May 26, 2010

I've been trying to ssh out of my home network to school computers and I keep getting:

ssh: connect to host sage.math.washington.edu port 22: Connection timed out

I've tried this on my machine (running Ubuntu 10.04) and on a windows 7 machine (using putty). I have been successful ssh'ing to this machine using either of the laptops from every other network I've tried, so I'm pretty sure it's something about my home network.

View 3 Replies View Related

General :: Lost Browser Connection To Internet

Jan 29, 2011

Using acer aspire one (ZG5) and have lost connection to Firefox browser after changing setting to make google my home default web page. I have no experience with linux so any help would be appreciated. There's no problem with my internet connection it shows connected.

View 10 Replies View Related

Debian Configuration :: Port (exp. 1001) Have 20 Connections That The Next New Connection Forword To An Other Port (exp.1002)?

Jul 15, 2011

i want if a port (exp. 1001) have 20 connections that the next new connection forword to an other port (exp. 1002).

View 2 Replies View Related

Server :: Getting Webserver Blocked By Mysql Server Because Of "to Many Connection Errors"?

Jan 17, 2011

I sometimes get my webserver blocked by my mysql server because of "to many connection errors" and have to use flush hosts to solve it, i now wonder if there is any way to increese that connection error value so the webserver wont get blocked ?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved