Allow User To Remote Mysql Connection
Aug 15, 2008how to allow user to remote mysql connection from his localhost ( in linux server with WHM )
my user wants to connect to the mysql from his localhost
ADVERTISEMENT
Allow User Remote Connection
Aug 13, 2008how to allow users to remote mysql from localhost ( in linux server with WHM )
my user wants to connect to mysql from his localhost
Host For Remote MySQL Connection
Feb 21, 2008I have developed a desktop system that uses MySQL data.
I want to use a host to access the data but my current provider only allows access to MySQL data via a web server.
Can anyone suggest a host that would provide direct connection to a MySQL database?
Cpanel Mysql Remote Connection USE EXIST DB
Jun 29, 2009A have set up a cpanel with remote mysql server.
My demo config:
cpanel:
centos VPS with cpanel WHM (demo)
mysql:
debian VPS
the configuration is OK, it works.
We have got 200 customers, and we will to change to cpanel.
The MYSQL server is on a solaris zone. It is possible to make the remote connecting with it. I will import the 200 users MYSQL databases to cpanel, with privileges (user settings). The mail/web dir a will import manuali to cpanel server(copy-paste-setuser:group).
MySQL Remote Connection Problem After A Heavy Usage
Aug 8, 2008I have 2 identical Fedora8 boxes with Apache 2.2.8, MySQL 5.0.45 and PhP 5.2.4. I use one as the Web+DB server (say box A), and the other (box B) just as the Web server connecting to the DB server on box A. I use this 2 machine configuration to test a LAMP based-Web application. I have a client program on other machines that can emulate a massive web workload to these 2 servers; it can emulate hundreds to thousands of users using the application simultaneously.
Before running the test, the connection to the DB server from both boxes seem fine. Using the mysql client program on either box A or B trying to connect to the DB, the connection goes through instantly. In the /etc/my.cnf file, I have max_connections=4096 and max_user_connections=4096. Note that the web app uses one single db user to connect to the db. To allow remote connection, I inserted one record into the user table of the mysql db whose the host field's value is '%' (allow connection from all remote hosts).
After running the test (which I found out that many requests sent to box B failed), mysql client program on box A is still able to connect to the db instantly; but the one on box B has a problem: it takes extremely long (5 - 10 minutes or even more) to establish the connection, it doesn't time out, just takes that long. I believe that's the cause for the failure of requests to box B.
Remote Desktop Connection
Oct 27, 2009I signed up for a windows VPS.
The directions I recieved were "Please use remote desktop to connect to your server."
So I entered the ip address into the remote desktop connection window and it doesn't connect. Where do I go from here? I searched and can't find any relevant info.
Remote Connection To Domain Fails
Jun 17, 2009I have an Ubuntu 8.04 server with 2 nerwork cards eth0 and eth1. I am using only eth0. The server is behind a 2-wire router. I have setup the router with the public IP addresses.
On the server I have setup an IP alias on eth0 as eth0:0. I have 3 domains which i will call foo1.com foo2.com and foo3.com. The server pc is assigned to a static public address on the router as 217.xx.xx.100 this same ip also used to setup the virtual host for foo1.com
Quote:
<VirtualHost 217.xx.xx.100:80>
ServerName foo1.com
ServerAlias www.foo1.com
ServerAdmin me@foo1.com
DocumentRoot /var/www/foo1/
</VirtualHost>
I have also setup and applied an ssl certificate to 217.xx.xx.100:443.
Now eth0:0 is assigned to 217.xx.xx.101 and used as below
Quote:
<VirtualHost 217.xx.xx.101:80>
ServerName foo2.com
ServerAlias www.foo2.com
ServerAdmin me@foo2.com
DocumentRoot /var/www/foo2/
</VirtualHost>
<VirtualHost 217.xx.xx.101:80>
ServerName foo3.com
ServerAlias www.foo3.com
ServerAdmin me@foo3.com
DocumentRoot /var/www/foo3/
</VirtualHost>
When I am on the router I can access all the domains via the browser and can also get FTP, and ssh connection to the server. However when I leave the range of the server and connect to the net via another router, I loose ftp and ssh access to the server as well as not able to browse www.foo1.com. However www.foo2.com and www.foo3.com I can browse.
Remote Desktop Connection For Linux
Apr 25, 2008My hoster told me to use PuTTY, a terminal, to install something called a vnc. I tried to install it ,but gets rejected everytime I connect.(I was using realvnc and connecting through a tunnel) Is there another way to get to the GUI or something like that?
I am using Vista and trying to connect to Linux (Debian)
ISP User Authentication - After Connection
Feb 21, 2008I'm starting a community ISP.
The users will connect by wireless signal and I want anybody in the neighborhood to be able to access it, free of charge.
Only issue is I want they to register and login before they can start visiting websites. To avoid liability issues I think identifying each user is a good idea.
So I want to create a login mechanism, like the user connects to the wireless network. Then he tries to open any website but it will actually open the authentication page instead.
My first obstacle is how to redirect every web request of non-authenticated users to my web server? Should I do it in the DNS level pointing every domain to my internal IP or should I do it in IP level somehow?
I have seen other ISPs using this authentication method, but unfortunately I didn't bother looking at how they accomplished it...
I think they used the DNS method. But how to setup a dns daemon (be it bind, djbdns or even maradns) to resolve all requests to a certain IP?
Windows And Linux Remote Desktop Connection
May 25, 2009I know we can get remote Desktop connection only on those servers based on Windows 2003 OS or Windows 2008 OS.
But what about Linux? Can I have such remote desktop connection on CentOS 5?
Another question is, what is nxclient?
[url]
Im bit confused. Can I get remote desktop connection of Linux OS ( CentOS ) on my Windows XP by using this software?
[url]
Spam/phishing Emails By Remote Connection (hacked)
Apr 23, 2009One day, you noticed that someone remotely connectted your computer and an application sends spam/phishing emails bu using your IP. What do you do?
Of course, I stopped the program and blocked remote connection for a while and changed my password... I any way, i have to connect my computer remotely... What do you advice?
By the way, i have more than 1000 email accounts on my computer. Hacker left me a gift, but I don't need them))
Failcnt Error #422: Cannot Initialize Connection To Remote Host
Dec 23, 2008my site is working fine for somedays and suddenly its stoped and hanged and also my PPP is not working , and file manager in PPP its give me this error
VZAgent returns error #422: "Cannot initialize connection to remote host"
and the suppord admin said I have problem in failcnt
[root@server ~]# cat /proc/user_beancounters
Version: 2.5
uid resource held maxheld barrier limit failcnt
1592: kmemsize 18353610 18355203 65536000 65536000 0
lockedpages 0 0 256 256 0
privvmpages 166455 171964 262144 262144 119810
shmpages 4885 4885 131072 131072 0
dummy 0 0 2147483647 2147483647 0
numproc 150 150 600 600 0
physpages 101554 108439 0 2147483647 0
vmguarpages 0 0 196608 196608 0
oomguarpages 101554 108439 196608 196608 0
numtcpsock 141 141 600 600 0
numflock 7 8 300 330 0
numpty 1 1 16 16 0
numsiginfo 0 1 384 384 0
tcpsndbuf 2350036 2625064 32768000 36864000 0
tcprcvbuf 2310144 2129920 32768000 36864000 0
othersockbuf 32976 573000 32768000 36864000 0
dgramrcvbuf 0 4284 1024000 1024000 0
numothersock 32 32 600 600 0
dcachesize 642510 653661 8192000 8192000 0
numfile 2636 2663 20000 20000 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
numiptent 228 228 700 700 0
I want to know what is my ram site and why that all errors?
My Screen Is Too Wide For "Remote Desktop Connection
Dec 17, 2007I am trying to access my server remotely using Windows' Remote Desktop Connection. It functions perfectly, but it does not go full screen because my local screen res is 1680x1050 ...
Does anyone know any other remote desktop applications which work better in this way?
I know I could just change the local res settings but it is a bit of a nuisance and looks really weird if I set it to something non-wide-screen...
Ping Doesnt Work Until Remote Desktop Connection Is Made
Nov 14, 2007I have a remote XP PC: 172.16.1.5 OpenVPN connection with route added for 192.168.2.0/24 to go via the VPN
Now on the other end the network consists of:
I have a OpenVPN server inside the lan on 192.168.2.245
Its default gateway is 192.168.2.1
I have 3 Windows Servers, 192.168.2.246, 247 and 248. All gateways are set to 192.168.2.1.
I have a ethernet router on the network, 192.168.2.1, it has a route added for 192.168.0.0/16 to go via 192.168.2.245, and route added for 172.16.0.0/24 to go via 192.168.2.245 also). the 192.168.0.0/16 is incase any other LANs are connected at a later date, if computers saw any packets not on the the 192.168.2.x subnet they would be routed to the default gateway which would then pass them to the OpenVPN router.
The trouble is, i can remotely connect and ping to the OpenVPN router fine and also the ethernet router, however when i ping any of the Windows boxes it times out. But i can open up Remote Desktop and connect to the windows box without problem, infact if i am running 'ping 192.168.2.246 -t' it will suddenly come alive but only after the RDP connection is made.
Is this something funny with the routing? I want to keep the OpenVPN server internal to the network and i appreciate it is hitting the ethernet router then being passed to the OpenVPN but something is weird as it fires up RDP fine but not ping. No firewalls are enabled on any of the boxes. If i log into ssh on the OpenVPN router or ethernet router i can ping from that to the windows boxes fine.
Its as if a ICMP redirect is issued, and all is well after the 1st connection. Not too sure but could anyone be kind enough to enlighten me?
Apache :: Remote User Reverse Proxy And Authentication
Dec 17, 2013I have several applications that use authentication and expect REMOTE_USER to be set by Apache for authentication/authorization.
I am putting a reverse proxy, with shibboleth in front of these applications, on a separate server.
Currently, REMOTE_USER is not sent. I have tried a few things, and I am currently sending it inside another header, but I have some applications that are closed sources and this will not work.
Is this possible to do? I am running this with Apache 2.4.7, I believe, on the Windows platform.
MySQL Connection
Jun 8, 2007I have a database server – mysql.xx.com which is the main MySQL server in H-Sphere.
I've created a database from mysqladmin interface.
I can use the database without a problem but when I’m trying to access the database from another server that I’ve just installed, the PHP application says that it can not connect to the database.
Another thing is that if I move the php app with the same configuration file under a shared account under another H-Sphere server, it's working perfectly.
I’ve read the H-Sphere documentation about an option to enable remote access to the mysql server which I can’t find anymore under our H-Sphere 2.5 Patch 8.
I’ve done a lot of searching to see how can I make that PHP application to connect to mysql.xx.com but it seems that although I’ve run the command grant all …. Command for that database, it still doesn’t work.
One final thing – from that new server if I run "mysql –h mysql.xx.com –u user –p" I can connect to the database and do a use database, show tables etc.
From iptables on mysql.xx.com I see that it accepts connections from outside.
This issue of not getting that PHP application to connect to mysql.xx.com can be related to the fact that H-Sphere is using the server or what should I try further?
MySQL Connection Fluctuates
Oct 1, 2009I'm trying to diagnose where my problem is coming from.
I have a site hosted with Integra Telecom. The site is connecting remotely to a MySQL database hosted on Media Temple.
My problem is that the site's connection to the MySQL database seems to be fluctuating throughout the day. Sometimes the site is up, sometimes it's down.
When it was down, I got the error: "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
So is the problem with Integra Telecom or is my problem with Media Temple?
Mysql Persistent Connection
Nov 3, 2009Currently mysql.max_persistent and mysql.max_links are set to -1 which means unlimited
to optimize mysql, should i keep this unlimited or is it good to limit this? If i have to limit it, what is the best value that I can put there?
Windows - MySQL Too Many Connection..
Jul 15, 2008I have win2003 server and running plesk 8.4, there is a website on it and it gives me error with mysql max_connection even I set the limit 1 million or 10000 no matters.
View 3 Replies View RelatedZymic.com MySQL Connection
Mar 18, 2008We have a front end server for the website Zymic.com (a free web hosting community), a mysql server and a main server for hosted websites. The problem lies between establishing a connection from the Zymic.com server to the database server - to sum it up, the connection just "hangs". We have never had this problem before, never edited anything which would cause a problem, its completely spontaneous.
My administrator has spent endless hours trying to debug the problem, here are some notes he gave me:
1. Ping to the mysql machine works fine.
2. Telnet to port 3306 of the mysql machine works great too – meaning NOT a network issue.
3. Strace on the connection shows it hangs when it calls the server and waits endlessly for response.
4. The mysql machine listens to the IP and port 3306 and connects great to the hosting server via SSH.
5. It's NOT a max connection issue but something to do with the mysql socket itself.
Here is a test from another site on the server to the mysql server:
[url]
Code:
<?php
mysql_connect('75.126.138.74', 'wkscript', 'PASSWORD') or die(mysql_error());
mysql_select_db('domains_data') or die('SELECT ERROR : ' . mysql_error());
?>
LiteSpeed - Connection To Mysql
Dec 21, 2008I have setup LiteSpeed and I have got a problem with php and mysql.
It seems php can't connect to mysql. At every script which use mysql(like phpbb3, phpbb2 etc) I getting errors
SQL ERROR [ mysql4 ] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [2002]
phpBB : Critical Error
Could not connect to the database
Lost Connection To MySQL
Dec 7, 2007MySQL Error : Lost connection to MySQL server during query
I get this error around 10 times a day and the MySQL server goes down
Here are my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 650
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
Max MySQL Connection On Shared Host
May 31, 2009What is the standard number on maximum mysql connection on most shared host providers and which one give the highest number.
View 11 Replies View Related