Ubuntu Servers :: Accessing MySQL Via IP Address
Jul 9, 2010
I need to Install MySql Server somewhere that I can access. Instead on installing it in a Windows box like I have for years, I'm thinking of putting it on a Ubuntu Server box (or virtual machine) instead. Should I do it on a Ubuntu Server or a Ubunto desktop box? I have never installed Ubuntu as a server, is it more or less the same as installing the desktop version? Lastly, is there multiple versions of Ubuntu where one might be more appropriate than another? All I want is a machine that I can access MySql via an IP address. Don't need DHCP, dns, Mail server or anything.
View 4 Replies
ADVERTISEMENT
Jun 1, 2010
I am running a server with Ubuntu 10.04 and mysql v.5.4.41-3ubuntu12.1.I am unable to connect to my mysql server remotely, (error 111). I have added the port 3306 to iptables. It is able to connect to the loopback address (127.0.0.1) but not through its external address.
View 2 Replies
View Related
Jul 16, 2010
i have two machines at home running ubuntu linux and windows connected by lan. on ubuntu machine i have mysql installed, how do i go about accessing ubuntu mysql database on my windows machine.
View 2 Replies
View Related
May 29, 2010
I am not able to move original thread so I am linking to it: [URL]
View 2 Replies
View Related
Jul 9, 2010
I have set up two identical websites and want them to access the same mysql database. I've entered the username/password/db name in the website database.inc file. However, one database works fine and displays correctly, the other just gives a blank page. I've tested apache and it can display a different site (one that does not access any db). So is there a configuration that i'm missing. Do i have identify the two different websites that access the db?
View 7 Replies
View Related
Mar 10, 2011
I have an application running on a centOS machine that needs to access a database on a CentOS server. I granted access to all users with a certain user name and password.i opened up port 3306 as well with the following command: /sbin/iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPTbut whenever i try to connect from my machine i get an error:ERROR 2003 (HY000): Can't connect to MySQL server on '172.16.102.129' (113)I am using mysql version 5.0.77 on centOS 5.5.
View 1 Replies
View Related
May 7, 2010
I have developed a website. Now i would like to monitor the IP address of machines who are accessing the server. The simplest possible solution to this that comes first into my mind is to use jsp inbuilt tags.
Code:
<%
out.print( request.getRemoteAddr() );
out.print( request.getRemoteHost() );
%>
but it has given me some other IP address(May be a proxy server's ip address)
So i was left with one choice is to run netstat on host server . Here is what i have done.
Code:
netstat -an | grep 8080 (As tomcat runs on port 8080).
Should i modify the command or there is any other way around to monitor the IP address?
View 5 Replies
View Related
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
Jan 14, 2011
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
View 4 Replies
View Related
May 12, 2010
I have 17 system (sys1,sys2,sys3.....sys17) in my office, and i am willing to setup a dedicated system to act as a firewall for that i have selected sys1 with two NIC(eth0 for local network and eth1 for internet) and i have configured to access internet in my office for that i have opened a wellknown port 80.but my clients are not accessing the internet..
and please check my sample IP configuration !!!
interface : eth1 (ISP IP)just for example
IP :192.168.0.2
gateway:192.168.0.1
dns:202.56.230.5
dns:202.56.230.6
Interface : eth0 (my local lan )
192.168.1.1
255.255.255.0
IP address of xp clients ranges form 192.168.1.2 to 192.168.1.16 with default 255.255.255.0
my question is that which gateway address and dns i have to give to my clients for accessing internet ?...
View 1 Replies
View Related
Jul 20, 2011
what is Production IP address and Management IP address in Linux servers? What is the significance of these two? When to use what?
View 3 Replies
View Related
Jun 17, 2010
I have MySQL installed on my Kubuntu 10.04 desktop machine which I use for developing web applications.First, all worked fine. But then I wanted to synchronize the database with the MySQL database on my laptop, so I had to allow connections from the LAN interface. So I addedCode:bind-address =192.168.0.100to /etc/mysql/my.cnf. This worked and the synchronization was performed. I want to do this on a regular basis so I would like to keep that line in there.The problem now is that MySQL does not start on system boot. When I start up, mysql simply is not started. There are no errors in /var/log/mysql/mysql.err or /var/log/mysql.err; these files remain empty.When I try to start it using 'sudo start mysql' I get the same result. The 'start mysql' shows up in 'ps aux', but the mysql process itself does not.Now, I found out that when I run
Code:
sudo -u mysql mysqld
The mysqld daemon does start, and the server works fine. To make matters even more strange, if I kill this
[code]....
View 2 Replies
View Related
Jun 24, 2010
When i set up a samba server, with no users in it, i can access from any pc, except the W7 ones.
I go to start, execute, type "\servershared" and a window pop ups asking for credentials... but i hava none!!!
i found out that user anonymous / no password works out, but its annoying
is there any way to overpass this autenthication??
View 2 Replies
View Related
Jul 21, 2010
So i run a ubuntu 8.10 server setup for webhosting. I have my router portforwarding to my servers LAN IP, and i have DNS setup and pointing to my WAN IP.
My host entries are all setup on ubuntu also.
The problem : I can access my server from typing WAN IP address or any of the URLS with webpages hosted on the server, all seems to be working. BUT, i can only access these from OUTSIDE my network. If i try access them within my LAN, i get sent to my routers login page.
I really cant find anything that could be causing this..
View 5 Replies
View Related
Oct 20, 2010
I posted this question a while ago but haven't had any luck getting it answered so I reworded everything to make it more clear. I started an Ubuntu web server on an old work laptop. The purpose of this server is to host a small file-sharing site, a forum, and a wiki. I have no prior experience with command line Ubuntu but am trying to figure this all out.
So far Ive setup the LAMP server, so apache, mysql, and php are installed. Ive also installed phpBB3 and Mediawiki. Both phpBB3 and Mediawiki are able to open from inside my LAN. I also have SSH setup and am able to use putty to manage the server from inside my LAN. Mediawiki runs slow internally but this is a secondary concern.
Externally to the LAN I can access the webserver using SSH(but sometimes it is too slow for anything that opens up such as nano or the SQL password prompt to display and the connection drops). I can also browse to the site and see the default apache welcome message. But I cannot open the mediawiki or phpbb site. Both will sit indefinitely and not open. The access log on the server shows that the request is being passed through though.
View 9 Replies
View Related
May 14, 2011
I am on Ubuntu 10.04.2 on Amazon EC2.I want to use the Cherokee web server and have it (and php) running under www-data then have the files also owned by www-data. I am only able to ssh and scp into my server using the user ubuntu. This means that I am unable to edit the files.I want to be able to edit the files owned by www-data through ssh/scp.Could you assist me in setting my server to allow me to edit the web files through scp?
View 9 Replies
View Related
Oct 3, 2010
So the problem is that phpMyAdmin does not want to connect to host name (at remote server) but connects to that same server fine if it's ip address is used. Command line "mysql -h hostname ..." works fine and connects to host name. Mysqladmin also works.
it's giving error:
*****
Error
MySQL said:
#2005 - Unknown MySQL server host 'host.name' (2)
******
I've disabled SElinux and temporarily disabled Iptables but no luck.
Somehow I feel MySQL is not doing DNS lookup when used by Apache/PHP. So it just understands ip addresses.
I found that on MySQL startup you can disable DNS lookup. [URL]
Not sure if it's disabled and how to enable it at startup. Could not find anything at "System" -> "Administration" -> "Services".
Here is similar case with no solution [URL]
View 1 Replies
View Related
Feb 9, 2011
I have installed debian on my laptop and included during the installation the webserver version. Now I want to develop a page locally to test it before I put it on the web. I first had an old reflex, jumping straight away and installing xampp. But then I thought that I already all that it takes as I installed the webserver feature of debian. I installed phpmyadmin ( with the command #apt-get install phpmyadmin) as to be able to create and attribute databases but when I try to log in I have the following message:
"Error
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)"
I googled but I cannot find the mysql.conf (I searched using "find") but with no result. It is all very blury what is going on with this webserver option running on my laptop...
View 9 Replies
View Related
Apr 18, 2010
I am a complete newbie at web servers, so I installed Ubuntu Server and have a LAMP set up. I have gotten dynamic DNS to link to my domain, and that seems to be working. My domain is 6py7.com. If I try to access my domain from within my home network it links me to my router's main page (192.168.2.1). I have my server set up with a static ip at 192.168.2.100 and have port forwarding set up.
Is there something I missed with the setup of this? I can only access my domain if I use a network outside of my home network, but if I am within my home network the domain name links to the router.
View 5 Replies
View Related
May 5, 2010
I have a computer which has a public IP.My ISP has allowed only port 22 for my machine to be accessed outside from internet.I want rest of my computers which are connected to this machine be accessible via SSH on internet.I can configure IPTABLES to route different ports to internal machines but since ISP has given only one port for the gateway how can I go for it any guesses.I came across some thing reverse SSH tunneling but that has to keep the connection alive all the time at gateway I want my trusted people to be directly able to access the machines on LAN to which they have account to login in this scenario.
View 9 Replies
View Related
Apr 28, 2011
i try to access my webmin but it give me "This webpage is not available." now, webmin is useless for me if i want to uninstall webmin, is some other application will affected (like apache, mysql, etc) ?
View 9 Replies
View Related
Nov 22, 2009
I am writing an application that wants to access periphals registers outside the standard (allowed) memory area.
Doing so gets me "segmentation fault".
I know, this is natural behaviour.
One way of getting around this is writing the module which has to be loaded by linux. I will consider this some time later.
For now, I want to come to some quick result and allow linux or gcc compiler to write to those memory areas of periphals. Is there a direct way to do so?
View 3 Replies
View Related
Apr 17, 2010
I have downloaded the Mediawiki demo appliance from UEC store. I have installed it and also it is running. I would like to know how to access the mediawiki demo appliance. I tried accessing it as [URL] but is not accessible.
View 2 Replies
View Related
May 27, 2010
provide support for a small business that uses Windows machines to access files stored on an Ubuntu server which has just been upgraded from 8.04 to 10.04 (32 bit version). Before the upgrade the users accessed their share by this batch file:
Code:
net use x: \servernamesharename /user:username
This would then prompt the user for his or her password which they would enter to allow them access to the share.Since upgrading to 10.04, the user gets a "system error 58" stating "The specified server cannot perform the requested operation"If the batch file command is changed to:
Code:
net use x: \servernamesharename
The same error message is given. The only work around I have found is to modify the file to read:
Code:
net use x: \servernamesharename /user:username password
This is not ideal at all as it makes the password protection useless.When I performed the upgrade I left the smb.conf unchanged. The smb.conf file is:
Code:
#
# Sample configuration file for the Samba suite for Debian GNU/Linux.
#
#
# This is the main Samba configuration file. You should read the
[code]...
View 7 Replies
View Related
Sep 12, 2010
I'm running Apache2 and PHP5, hosting multiple virtual domains on my server. The directories of the domains (/var/www/<domain>) aren't publicly readable, so the websites can't access each others content as the scripts are run using different user accounts. They can, however, access other folders on the system that have public access for any user. I tried using the following PHP code, which listed the filesystem root:
Quote:
<?php
$handle=opendir("../../../..");
while($file=readdir($handle)){
echo $file . "<br/>";
}
?>
I will be hosting sites for other people so I don't want them to be able to access my entire server with PHP. Is there any way i can do this?
View 2 Replies
View Related
Jul 28, 2009
I am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
View 2 Replies
View Related
Jan 30, 2011
Is it possible to run two servers through one ip address? And I don't mean through apache to run virtual servers. Right now my set up is: Cable modem>router>server.
View 9 Replies
View Related
Apr 16, 2010
I currently have samba setup and connecting. What I am trying to do is have multiple users with access to different directories. For example , let's say there are folders A B C on my Linux machine. I want one guy to see A and C and another guy to see B and C and a third guy to see them all. But I want each user to have access to change delete or execute the files within these directories that they have access to
View 4 Replies
View Related
Jun 29, 2010
i have php5 and mysql on ubuntu server which is hosting a WordPress blog. i activated it remotely over the internet and it works fine still over the internet. now im home and using my local network again and now when i try to go into it with its local IP, it just shows some text (blog title, posts and so on) with NO pictures.
View 2 Replies
View Related
May 22, 2011
I would like to read and write to a folder in an Ubuntu VPS remotely via a Windows Explorer (Windows 7 Ultimate). Considering that my VPS has very little resources (128MB RAM), what program should I use?
View 2 Replies
View Related
