Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Web Hosting


Advertisements:




SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Connect To MySQL DB Only On Certain User


I am using cPanel 11 (stable release) on a CentOS 5 server and would like to make it so that a certain database can only be connected to from the cPanel user that it is under (ie. user1_db can only be connected to from the user "user1" on the same server).


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
MySQL Can't Connect To Socket.....
I saw following error in some of my site in my server.

Coppermine critical error:
Unable to connect to database !

MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

or following error :

Invalid mysql server connection

Please help me how can I resolve this error !

/etc/my.cnf :

[mysqld]
datadir=/var/lib/mysql
skip-locking
skip-innodb
skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=16M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=64M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=1M ## 1MB for every 1GB of RAM
read_buffer_size=1M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_general_ci

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

My server details :
1 GB RAM
P4 3.00 HT

View Replies!   View Related
Users Cannot Connect To MySQL Via Phpmyadmin
It seems I am having issues with WHM/CPanel. I cannot connect to mysql via phpmyadmin through WHM as a root and get this error

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

All users get the same error when they try to access mysql from cpanel. The access seems to be only for valid for 192.168.1.%

Would allowing access to localhost will help and how can I do that for all users?

View Replies!   View Related
Mysql Connect Problem After Easyapache
I updated my php to 4.4.8 via easyapache. But after that my scripts couldn't connect the databases?

View Replies!   View Related
MySQL Cannot Connect To Database Via PHP
I got this weird problem with my VPS which has MySQL 4.1.22 running on it. Everything works fine for sometime and then out of a sudden, it stop recognizing the mysql users and refused to allow my PHP scripts to access the database.

It seems that I needed to restart mySQL server to resolve the issue. Then out of the blues, the same problem occurs.

I am running Cpanel on a VPS and there isn't any overloading as the database access is pretty light on my 512mb VPS.

I contacted my web host about the issue and it seems like all they do is to restart the mySQL. This cannot be a solution as it happens at least once or twice a day depending on how soon I could catch the problem.

All the time this problem occurs, the MYSQL Server is still active and working. I can even access it through PHPMyAdmin but not through the scripts.

I just added an hourly crontab so as to restart the MySQL server as a stop gap.

View Replies!   View Related
Users Cannot Connect To Remote MySQL Server
I have a few users that have a hosting account with me and are trying to connect to their own MySQL servers elsewhere. Both said that they are able to connect to the MySQL server with other hosting accounts but not the ones hosted with me. I asked if they had setup permissions to allow remote connections from my server and they confirmed that they did.

What am I missing? Do I need to configure my firewall somehow? I figured the connection is just using port 80 since it's from an PHP script right?

View Replies!   View Related
Can't Connect To MySQL Server On 'localhost' (10055)
Do you guys know anything about this?

My server works perfectly with INSERT, UPDATE, DELETE for mysql.
but after like 12 hours later, my application crashes and I get this
"Can't connect to MySQL server on 'localhost' (10055)" and I would have to restart my applications and everything will be working perfectly.

Do you guys have any idea why this happen?

I do have a lot of connections coming in and out of my server. Would that mean anything?

View Replies!   View Related
Can't Connect To Local MySQL Server Through Socket
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/thesymbi/public_html/includes/class_core.php on line 274

I get this around 50 times a day!
I am fed up!

View Replies!   View Related
Connect To Mysql From Many Remote Virtual Hosts
I have a set up where server 1 holds a mysql DB and a virtual host. server 2 holds many virtual hosts in apache (16) connecting to this DB.

The virtual hosts all hold the same script, but the single VH on server 1 receives about the same amount of visits as all the VHs of server 2.

server 1 is very busy at times, like 100% CPU and a load around 10 for long period of times.
server 2 is not very busy, around 30% CPU usage and 0.6 CPU load.

Yet, users on server 2 experience *much slower* response times than the ones on server 1.

The obvious reason could be the network between the two, but I'm not convinced (6 seconds for a query run from server 2 when it brings back 1 row and takes 0.01 second from server 1).

I was wondering what other reasons it could be.

The mysql processlist is weird:

Code:
mysql> show processlist;
+-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+
| 81817 | mysite | localhost | mysite | Sleep | 865 | | NULL |
| 94992 | mysite | server2:47927 | mysite | Sleep | 188 | | NULL |
| 96890 | mysite | server2:50881 | mysite | Sleep | 26 | | NULL |
| 97213 | mysite | server2:51010 | mysite | Sleep | 22 | | NULL |
| 97391 | mysite | server2:51085 | mysite | Sleep | 36 | | NULL |
| 97919 | mysite | server2:51300 | mysite | Sleep | 49 | | NULL |
| 97927 | mysite | server2:51306 | NULL | Sleep | 49 | | NULL |
| 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL
| 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL |
| 97958 | mysite | server2:51321 | mysite | Sleep | 26 | | NULL |
| 97961 | mysite | server2:51323 | mysite | Sleep | 46 | | NULL |
| 98104 | mysite | server2:51344 | mysite | Sleep | 39 | | NULL |
| 98169 | mysite | server2:51376 | NULL | Sleep | 36 | | NULL |
| 98177 | mysite | server2:51388 | mysite | Sleep | 9 | | NULL |
| 98365 | mysite | server2:51461 | mysite | Sleep | 26 | | NULL |
| 98377 | mysite | server2:51427 | mysite | Sleep | 26 | | NULL |
| 98380 | mysite | server2:51468 | mysite | Sleep | 6 | | NULL |
| 98394 | mysite | server2:51474 | mysite | Sleep | 26 | | NULL |
| 98404 | mysite | server2:51479 | mysite | Sleep | 26 | | NULL |
| 98418 | mysite | server2:51486 | mysite | Sleep | 26 | | NULL |
| 98419 | mysite | server2:51487 | mysite | Sleep | 26 | | NULL |
| 98429 | mysite | server2:51496 | mysite | Sleep | 2 | | NULL |
| 98503 | mysite | server2:51520 | mysite | Sleep | 22 | | NULL |
| 98512 | mysite | server2:51524 | mysite | Sleep | 22 | | NULL |
| 98514 | mysite | server2:51525 | mysite | Sleep | 20 | | NULL |
| 98519 | mysite | server2:51526 | mysite | Sleep | 22 | | NULL |
| 98557 | mysite | server2:51514 | mysite | Sleep | 21 | | NULL |
| 98568 | mysite | server2:51548 | mysite | Sleep | 20 | | NULL |
| 98581 | mysite | server2:51557 | mysite | Sleep | 5 | | NULL |
| 98617 | mysite | server2:51572 | mysite | Sleep | 18 | | NULL |
| 98620 | mysite | server2:51574 | NULL | Sleep | 18 | | NULL |
| 98630 | mysite | server2:51577 | mysite | Sleep | 17 | | NULL |
| 98644 | mysite | server2:51584 | mysite | Sleep | 17 | | NULL |
| 98681 | mysite | server2:51601 | mysite | Sleep | 15 | | NULL |
| 98698 | mysite | server2:51604 | mysite | Sleep | 14 | | NULL |
| 98704 | mysite | server2:51606 | mysite | Sleep | 14 | | NULL |
| 98714 | mysite | server2:51610 | NULL | Sleep | 14 | | NULL |
| 98736 | mysite | server2:51619 | NULL | Sleep | 13 | | NULL |
| 98748 | mysite | server2:51626 | NULL | Sleep | 12 | | NULL |
| 98753 | mysite | server2:51628 | mysite | Sleep | 12 | | NULL |
| 98785 | mysite | server2:51635 | mysite | Sleep | 11 | | NULL |
| 98820 | mysite | server2:51654 | mysite | Sleep | 10 | | NULL |
| 98821 | mysite | server2:51655 | mysite | Sleep | 10 | | NULL |
| 98822 | mysite | server2:51656 | mysite | Sleep | 10 | | NULL |
| 98823 | mysite | server2:51657 | mysite | Sleep | 10 | | NULL |
| 98836 | mysite | server2:51660 | mysite | Sleep | 9 | | NULL |
| 98840 | mysite | server2:51662 | NULL | Sleep | 9 | | NULL |
| 98841 | mysite | localhost | NULL | Query | 0 | NULL | show processlist |
| 98901 | mysite | server2:51680 | mysite | Sleep | 6 | | NULL |
| 98903 | mysite | server2:51651 | mysite | Sleep | 7 | | NULL |
| 98920 | mysite | server2:51684 | mysite | Sleep | 6 | | NULL |
| 98947 | mysite | localhost | mysite | Sleep | 1 | | NULL |
| 98954 | mysite | server2:51696 | mysite | Sleep | 5 | | NULL |
| 99024 | mysite | server2:51710 | mysite | Sleep | 1 | | NULL |
| 99031 | mysite | server2:51712 | mysite | Sleep | 2 | | NULL |
| 99032 | mysite | server2:51686 | mysite | Sleep | 2 | | NULL |
| 99041 | mysite | server2:51694 | mysite | Sleep | 2 | | NULL |
| 99049 | mysite | server2:51717 | mysite | Sleep | 2 | | NULL |
| 99058 | mysite | server2:51720 | mysite | Sleep | 1 | | NULL |
| 99063 | mysite | server2:51685 | mysite | Sleep | 1 | | NULL |
| 99064 | mysite | server2:51722 | mysite | Sleep | 2 | | NULL |
| 99073 | mysite | localhost | mysite | Sleep | 1 | | NULL |
| 99075 | mysite | server2:51724 | mysite | Sleep | 1 | | NULL |
| 99086 | mysite | localhost | mysite | Query | 1 | Creating tmp table | SELECT DISTINCT * |
| 99089 | mysite | localhost | mysite | Sleep | 1 | | NULL |
+-------+----------+---------------+----------+---------+------+-----------

Why so many sleeping processes from server 2, and none or almost none from server 1 ?
Is it normal that every query from server 2 is open on a different port ? Should they be grouped by virtual host, or is there one different port for each script running concurrently?

What could be a reason for server 2 having problems to open connections on server 1, and how to solve it?

Right now I'm about to deport more users from server 1 to new virtual hosts on server 2, hoping it will lower the load on the first machine and overall accelerate the response times. I just thought I'd post here first because this all seems very weird to me and i thought someone with an external look might tell me what I'm doing wrong. And also if network would be the problem maybe that's not the clever thing to do to make more users remote.

View Replies!   View Related
Error: Warning: Mysql_connect() [function.mysql-connect]
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/.../public_html/enhu.com/includes/connection.php on line 5

Database connection failed: Access denied for user 'root'@'localhost' (using password: YES)

i'm using wamp.

how must i fix this error?

View Replies!   View Related
Is It Possible To Make Joomla Connect To An External Mysql Database Server
Is it possible to make Joomla connect to an external mysql database server?

Meaning, the database for Joomla won't be local, but on another server.

Will it work by just entering the mysql hostname, user and password in Joomla's config?

What issues might arose by doing this?

View Replies!   View Related
Wich User Have More Mysql Process?
How can see wich user have more mysql process?

View Replies!   View Related
Allow User To Remote Mysql Connection
how 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

View Replies!   View Related
How To Find Which Mysql User Is Using All Cpu
31015 100 15 0 151m 35m 5156 S 28 0.4 379:34.10 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql

This is my top process, I have quad core server and because of this server load is over 10

I am using cPanel, is it possible to trace which user is using all this cpu?

View Replies!   View Related
MySQL Forgetting User Permissions
Does anyone know what could be the cause of this issue? I located a few others over at cpanel.net that have this problem, but no solution has been found.

[url]

I am running a VPS server with the following:

WHM 10.8.0 cPanel 10.9.1-S14304
RedHat 9 i686 - WHM X v3.1.0
phpMyAdmin - 2.9.0.2
MySQL client version: 4.1.10
mysql version: 5.0.27-standard

I have a database user that needs "Super Privileges" and so this was done. However, when Cpanel is updated the user permission is reset automatically from "ALL PRIVILEGES" to "USAGE".

Here's a look at the database permissions from phpMyAdmin.

Code:
User Host Password Global privileges Grant
hello localhost Yes ALL PRIVILEGES Yes
hello_ % No ALL PRIVILEGES Yes
hello_ localhost No ALL PRIVILEGES Yes

The user "hello" loses its "ALL PRIVILEGES" and switches over to "USAGE" if an update is triggered. Updates to cpanel, creating/removing a database/user, and updating the account password will cause the switch.

View Replies!   View Related
Mysql/user Is Marked As Crashed
I am trying to start mysql but i am getting the following error

MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL................................... [FAILED]

I checked my hostname.err file in /var/lib/mysql and this is the error message it shows.

070130 17:59:41 mysqld started
070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired
070130 17:59:42 mysqld ended

how I would repair that to get mysql to start again?

View Replies!   View Related
What Are Common MySQL User Permissions
I want to use something like PHPBB forums and using one MySQL user and database. Just wondering, what are common user permissions I should set for the user? I want to try to minimize any permissions that can cause big risk to the server security.

Here is a full list of permissions I can grant to the user (via Webmin):

-Select table data
-Insert table data
-Update table data
-Delete table data
-Create tables
-Drop tables
-Grant privileges
-Reference operations
-Manage indexes
-Alter tables
-Create temp tables
-Lock tables

View Replies!   View Related
Backup Mysql User Privileges
how do i backup mysql user privileges?

this will only backup the databases:
mysqldump --opt -u root -p --all-databases > data.sql

i would like to backup mysql user privileges too.

View Replies!   View Related
Default Host For Mysql User
By default, mysql will create user with host as 'localhost'. Now, if I want the host is '1.2.3.4' by default, how to configure it?

View Replies!   View Related
Change Mysql User Password Via Shell?
Anyone know the commands to change a MySQL user's password via ssh?

I found stuff for changing the root password, and tried to adapt it for the user, but it didn't work.

View Replies!   View Related
MySQL Replication For User On Shared Server
I never did replication and do not know much about it so I figured I would ask here if anyone knows or has done it before like this.

I have a user who wants me to enable replication on my server for his user. I dont like the sounds of it on a shared environment but if there is no risk to other users and its not a big resource hog I will do it. Anyway, from what I gather I have to:

1. execute:
GRANT REPLICATION SLAVE ON user_main.* TO 'repl'@'ip-here' IDENTIFIED BY '4T6WjUZa';
[url]

2. Stop mysql server and Add in my.cnf:
[mysqld]
log-bin=mysql-bin
server-id=1
slave-compressed=1
binlog-do-db=user_main
start server[url]

3. execute:
SHOW MASTER STATUS;
we need values of colomns File and Position from output of above command[url]

So my questions are:

Is there any security risk?
Is there significant extra resource usage?
Is this even done on shared environments?

View Replies!   View Related
Mysql User Privilege Changed By Cpanel Or What
I am using Cpanel. One Cpanel account is backup. I use it to backup my database.

Under mysql, I gave this account ( backup ) many priviledges. But when the backup script ran, error said that backup account can not 'lock table'.

I gave "lock table' priviledge again and run the script, it is ok.
But after a while, when the script ran autmatically on daily basis, it lost the 'lock table' priviledge again.

I wonder if Cpanel is messing me up? What can I do about it? anyone knows?

View Replies!   View Related
MySQL: Access Denied For Root User
When I deleted a database, the user apparently was orphaned because when I tried to recreate it, it returned "user already exists". I've never encountered that problem although from Googling, I see others have and they delete the user to get around it.

When I log into mysql using the da_admin@ account and attempt to remove the user with drop user <user_name>; I receive the following error message:

ERROR 1227 (42000): Access denied; you need the CREATE USER privilege for this operation

It seems I don't have rights even as the root user. How can I get remove the orphaned user?

View Replies!   View Related
MySQL Overload Server, Wich User
how check which database / user MySQL overload the server?

View Replies!   View Related
MySQL Anyway To Log Queries Of Specific User
I know about the general log but want to just log queries of a specific user. Our database does 400 queries/s on a slow day, so I think it would be a pain to grep though a huge log like that. And, im not sure if it would cause any preformance issues.

View Replies!   View Related
Weird MySQL: User/pass Stops Working After A While
I am having a very strange problem with 2 different cPanel accounts on a server with 500-600 accounts. For some reason after a day or two the mysql username/password stops working. We have tried changing the MySQL user and the password with no success. The log does not indicate that the MySQL password was changed in any way. Only these 2 accounts are affected and this problem occurred at least half dozen times each.

Again: these are two different accounts with 2 different MySQL users that after a while stop working (I am unable to determine if they stop working at the same time b/c they belong to different customers). When we reset the user (with the same pass) it works for a day or two. I have checked to connect not only from PHP but also from shell when it's down: it also doesn't work so this is a pure MySQL problem.

Also on the server we have Fantastico.

View Replies!   View Related
Granting MySQL Command Line Permissions To A User
Is there any safe way to grant command line permissions to a user/specific account? One that only allows them access to databases on their account.

The problem is that this user intermittently runs queries that cause their database to hang (including PHPMyAdmin, so they can't view the processlist through there), and I have to manually kill that process, because they can't.

Server is 2.4.21 with MySQL 4.0.27, admin is cPanel WHM.

View Replies!   View Related
Mysql Disable INSERT Access To Specific User/table
How can I disable INSERT access to specific table.

The user should have full access the the DB except insert to specific table.

The tables_priv allow to set what enable and not what disable.

I'm using mysql v5

View Replies!   View Related
Intermittent "Can't Connect To MySQL Server"
I started getting small periods of intermittent connection errors about once every hour, lasting for about 1 to 5 minutes each time:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'

I enabled the error log and did some other monitoring and established 2 things:
- the server doesn't crash/restart, it keeps running throughout the errors
- the errors do not match the load on the website, as sometimes when 500 users are online there are no errors, but when 300 are online they may by prolific

I checked many forums and then made 5 changes:
- changed the directory containing the mysql.sock file so only file owners or superusers can delete files from it
- I changed the default socket file setting in both my.cnf and php.ini
- I read about SELinux causing such a problem, so I disabled SELinux completely, rebooted the server and double-checked that it is indeed disabled.
- I changed the maximum amount of open files allowed by the operating system from 1024 to 30000.

Despite all these changes, I still get the errors. I then read that there is a workaround by using TCP/IP instead of the sock file. I tried that, but I still get the error intermittently in the form of:
Can't connect to MySQL server on 127.0.0.1

MySQL server 4.1.20, PHP 4.3.9, client API 4.1.20, CentOS 4.3, Intel P4 2.8GHz 1GB RAM

View Replies!   View Related
MYSQL Error "Could Not Connect To The Database"
Last night i went to install GD on my server(Linux RH) I went through the process /scripts/easyapache and at the end of it gave me this error

"...Unable to connect to host: 127.0.0.1......Failed......Unable to connect to
host: 127.0.0.1......Fail
ed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect
to host: 127.0.0.1.....
.Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to
connect to host: 127.0.0.1
......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable
to connect to host: 127.
0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed......Unable to connect to
host: 127.0.0.1......Failed......Unable to connect to host:
127.0.0.1......Failed...
The was no content, the test may be unable to connect to 8080 simply because
tomcat is still initila
izing.
You can try to go to
http://localhost:8080/
to manually check it.
-- End test 'Basic tomcat port running test' --
Post check of 'httpd' process Ok
-- End post apache restart tests --
Executing '/scripts/initfpsuexec'
Executing '/scripts/initsslhttpd'
Executing '/scripts/gentomcatlist2'
Compiling report...
Sending report (336 bytes)...
If you want to create a support ticket with cPanel regarding this please
reference 'BuildAP Report
Id': '528932'
Report processed.

You can change how PHP is configured.
As root, simply execute:
/usr/local/cpanel/bin/rebuild_phpconf --help
for more information.

Build Complete
Verbose logfile is at '/usr/local/cpanel/logs/easy/apache/build.1198389830'

Now I am unable to connect to MYSQL databases, MYSQL is still running from what I can see. I have base knowlage of Linux as well.

View Replies!   View Related
"Can't Connect To Local MySQL Server" + "IPS Driver Error"
During peak times (especially weekends) many of my site's users have been reporting intermittent 'IPS Driver Errors' in the forums and the following error in the coppermine gallery:

Quote:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)

(The forums and the gallery are the main parts of the site).

I'm assuming that the site is having problems handling the number of users trying to connect to SQL. I tried increasing the max_connections and max_user_connections settings in my.cnf but it doesn't seem to have made a significant difference.

What do I need to do to fix this? Would I need to upgrade my server specs or is it something to do with the server settings?

my server specs: AMD Dual/Dual Opteron 270 with 4GB RAM.

View Replies!   View Related
Redirect Domain/user To User.domain ONLY IF Folder 'user' Doesn't Exist
I thought I knew enough about my .htaccess stuff to do this, but I can't seem to work it out. What I want to do is if a user visits domain.com/folder, we check to see if the folder exists. If so, show as normal (IE domain.com/support)

If a user visits domain.com/dynamicusername (dynamicusername is not a physical folder), redirect to dynamicusername.domain.com

View Replies!   View Related
Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:

Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?

View Replies!   View Related
I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.

Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..

View Replies!   View Related
Connect Switch
This week connectswitch's service has not been that good. Basically first they restart the node without prior notice and our vps was down for 7 hours. and now we buy our cPanel license via them and they havent paid it so the license is now expired although we have paid them for it.

View Replies!   View Related
Can't Connect To Outside Websites
We can't resolve any outside websites, for example wget won't resolve any websites.

elvis:~# wget [url]
--2009-07-30 03:12:15-- [url]
Resolving g-ecx.images-amazon.com... failed: Temporary failure in name resolution.
wget: unable to resolve host address `g-ecx.images-amazon.com'
elvis:~#

How can we debug this? Its just started to do this, before it was fine for months.

We can resolve IP addresses fine.

elvis:~# wget [url]
--2009-07-30 03:18:08-- http://206.251.77.82/~proxy/images/b...ntent-view.png
Connecting to 206.251.77.82:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 241 [image/png]
Saving to: `background-content-view.png'

100%[======================================>] 241 --.-K/s in 0s

2009-07-30 03:18:08 (63.8 MB/s) - `background-content-view.png' saved [241/241]

elvis:~#

View Replies!   View Related
Cant Connect To IIS
is to use windows authentication, to connect to the site, and connect to MS SQL with the same user.

I read on the net (http://msdn.microsoft.com/en-us/library/ms998358.aspx), and it said I should go to my default sites properties, to to the "directory security" tab, and make sure "Integrated Windows authentication" is the only box that is checked.

I did that and now I cant connect to my site...

When I try to connect, it bring up a windows user name and password box. I put a user name and password in, but nothing...

Iv double checked the user exist, and still nothing...

View Replies!   View Related
What Is Cross Connect
I'm getting a cabinet colocation with a provider and on the sales order there is a setup and re-occurring fee for "cross connect". My rep explained it's for the connection from my cabinet to their switch. Is this a typical charge for colocation? I thought cross connect is for connecting from their facility to 3rd party providers.

View Replies!   View Related
How Do I Connect To Centos
I got my dedicated server on centos ... everything is running, how to remotly connect

I already tried putty but there are some problems. My hosting provider give me this details:

root / Admin Password: xxx
DRAC-ip-user-password
and APC IP.

So which program is the best for remote connect?

View Replies!   View Related
Connect To Iphone
how to setup an iPhone to access a mailbox hosted with VPS?

View Replies!   View Related
Can't Connect To CPanel
I can't connect to CPanel or any of my sites but I can connect to my virtuozzo control panel. When I try to connect to CPanel or any of my sites I get an error that says that the server is taking to long to respond.

If I go through a proxy I see the sites so I know CPanel is not down.

How is it possible to connect to my Virtuozzo control panel but not Cpanel?

View Replies!   View Related
Clients Can't Connect To IP
We're having a small problem with one of our Ventrilo boxes (Linux) that seems to be blocking users from connecting. The DC (The Planet) is reporting that the issue is likely with the user and my tech is also saying the same thing. I have reason to believe they're both wrong but wanted to see if anyone had any ideas.

Here are 3 tracert's that show normal activity until the user reaches the DC network and then they can't reach our server.

All 3 of these are from different users experiencing the exact same problem.

Tracing route to ca.13.1343.static.theplanet.com [67.19.19.202] over a maximum of 30 hops:
1 2 ms 1 ms <1 ms 192.168.1.1
2 * * * Request timed out.
3 70 ms 72 ms 24 ms 68.86.105.193
4 127 ms * 13 ms 10g-9-3-ur02.longmont.co.denver.comcast.net [68. 86.103.157]
5 103 ms 87 ms 66 ms 10g-9-1-ur01.longmont.co.denver.comcast.net [68. 86.103.161]
6 12 ms 11 ms 12 ms 10g-3-1-ar01.denver.co.denver.comcast.net [68.86 .103.154]
7 9 ms 9 ms 23 ms 68.86.103.150
8 11 ms 12 ms 11 ms 12.125.159.89
9 45 ms 42 ms 33 ms tbr2-p013702.dvmco.ip.att.net [12.123.207.150]
10 31 ms 34 ms 126 ms tbr2-cl33.dlstx.ip.att.net [12.122.12.125]
11 145 ms 32 ms 31 ms gar1-p3100.dlrtx.ip.att.net [12.123.16.165]
12 38 ms 32 ms 31 ms 12.119.136.14
13 30 ms 34 ms 32 ms te7-1.dsr02.dllstx3.theplanet.com [70.87.253.18]
14 34 ms 32 ms 30 ms vl41.dsr01.dllstx4.theplanet.com [70.85.127.83]
15 59 ms 142 ms 48 ms gi1-0-2.car02.dllstx4.theplanet.com [67.19.255.1 34]
16 * * * Request timed out.
17 * * * Request timed out.
18 * * * Request timed out.
19 * * * Request timed out.
20 * * * Request timed out.
21 * * * Request timed out.
22 * * * Request timed out.
23 * * * Request timed out.
24 * * * Request timed out.
25 * * * Request timed out.
26 * * * Request timed out.
27 * * * Request timed out.
28 * * * Request timed out.
29 * * * Request timed out.
30 * * * Request timed out.

Tracing route to ca.13.1343.static.theplanet.com [67.19.19.202] over a maximum of 30 hops:

1 <1 ms <1 ms <1 ms 192.168.1.1
2 8 ms 7 ms 10 ms 73.96.20.1
3 9 ms * 7 ms GE-2-37-ur01.aberdeen.wa.seattle.comcast.net [68 .86.98.9]
4 9 ms 13 ms * te-5-2-ur01.olympia.wa.seattle.comcast.net [68.8 6.96.6]
5 11 ms * 12 ms te-8-4-ar01.burien.wa.seattle.comcast.net [68.86 .96.10]
6 14 ms 19 ms 14 ms 12.116.25.13
7 69 ms 69 ms 70 ms tbr1011401.st6wa.ip.att.net [12.122.111.6]
8 72 ms 76 ms 74 ms tbr2-cl10.sffca.ip.att.net [12.122.12.113]
9 73 ms 66 ms 67 ms tbr1-cl30.sffca.ip.att.net [12.122.9.137]
10 67 ms 68 ms 69 ms tbr1-cl3.la2ca.ip.att.net [12.122.10.26]
11 70 ms 67 ms 67 ms tbr1-cl20.dlstx.ip.att.net [12.122.10.49]
12 67 ms 68 ms 67 ms gar1-p340.dlrtx.ip.att.net [12.123.16.161]
13 65 ms 66 ms 65 ms 12.119.136.14
14 66 ms 66 ms 65 ms te9-1.dsr02.dllstx3.theplanet.com [70.87.253.22]
15 68 ms 67 ms 68 ms vl42.dsr02.dllstx4.theplanet.com [70.85.127.91]
16 67 ms 66 ms 66 ms gi1-0-1.car02.dllstx4.theplanet.com [67.19.255.6 ]
17 * * * Request timed out.
18 * * * Request timed out.
19 * * * Request timed out.
20 * * * Request timed out.
21 * * * Request timed out.
22 * * * Request timed out.
23 * * * Request timed out.
24 * * * Request timed out.
25 * * * Request timed out.
26 * * * Request timed out.
27 * * * Request timed out.
28 * * * Request timed out.
29 * * * Request timed out.
30 * * * Request timed out.

1 9 ms 5 ms 7 ms 73.101.80.1
2 7 ms 7 ms * GE-2-37-ur01.gigharbor.wa.seattle.comcast.net [6 86.99.9]
3 * * * Request timed out.
4 13 ms 9 ms 11 ms 12.117.243.13
5 64 ms 66 ms 64 ms 12.127.6.50
6 67 ms 67 ms 273 ms tbr2-cl10.sffca.ip.att.net [12.122.12.113]
7 67 ms 73 ms 69 ms tbr1-cl30.sffca.ip.att.net [12.122.9.137]
8 66 ms 66 ms 65 ms tbr1-cl3.la2ca.ip.att.net [12.122.10.26]
9 68 ms 64 ms 63 ms tbr1-cl20.dlstx.ip.att.net [12.122.10.49]
0 67 ms 70 ms 66 ms gar1-p340.dlrtx.ip.att.net [12.123.16.161]
1 70 ms 68 ms 67 ms 12.119.136.14
2 72 ms 69 ms 66 ms te9-1.dsr02.dllstx3.theplanet.com [70.87.253.22]
3 63 ms 65 ms 65 ms vl42.dsr02.dllstx4.theplanet.com [70.85.127.91]
4 69 ms 75 ms 69 ms gi1-0-1.car02.dllstx4.theplanet.com [67.19.255.6
5 * * * Request timed out.
6 * * * Request timed out.
7 * * * Request timed out.
8 * * * Request timed out.
9 * * * Request timed out.
0 * * * Request timed out.

View Replies!   View Related
Could Not Connect To Database
I recently tried installing phpbb forum via fantastico and everytime I try I get the error "phpbb critical error" "could not connect to database"

I also get an error connecting to database when I try installing SMF.

I checked the configuration/information and the password and username is all correct.

View Replies!   View Related
Connect Two Servers
I'm trying to cross connect two linux servers' secondary NICs with a cross over cable. after I pluged in the both ends, I tried to set internal ips for eth1 with netconfig, 192.168.3.1 and the other one is 192.168.3.2, i don't know what to put on netmask and gateway so I left it with netconfig's default, after that I tried ifup ifcfg-eth1 but the server lost connection.

The tech at the datacenter checked and said I delete their network gateway from the list of routes.

what should I do? remove the gateway line in ifcfg-eth1?

View Replies!   View Related
CoreHoster :: Unable To Connect
I am unable to connect to corehoster at all again --

I have been having issues since I opened my alpha master reseller account

Any reseller account I create cant create cleints..

I am even unable to enter tickets or send email to them since they are unreachable

Nick S refuses to refund my account .

Any one else having issues with core hoster

View Replies!   View Related
Portal Connect But Don't Work
I install a Oracle Collaboration Suite portal on a Windows 2003 server.

I configure everithig to put it online. I cerate a dyndns hostname and I forwarded the 80 port on the router.

So, when I type the adress the portal appears but when I press on a link he redirects me on server.xxx.local.

View Replies!   View Related
Best VPS To Connect Thailand
i am searching a VPS to connect Thailand users

its need very fast link and good ping

its for real time multimedia ( i try to avoid LAG in sound)

windows as a preference but linux can do

I dont need a lots of CPU or RAM cpy of 233mhz and ram of 256m is enought

put the connectivity is crucial full dubplex 100mbps and 500G of bandwith as a minimal

any clue where i can find this litle jewel

now i am using one who use tiscali as the provider its works fine the VPS is ok but its dont connect well all my poeples

so i am looking to change it

View Replies!   View Related
Vsftpd Running, Can't Connect From Outside
I have been pulling my hair out all day trying to fix this issue, which should be simple in theory.

Basically in summary, vsftpd is running on the server, I can't connect to FTP from my own computer.

I have tried many things, but right now the way it stands is my vsftpd.conf file has listen=YES. I did a netstat -pan, with a return of:
tcp 0 0 0.0.0.0:21 0.0.0.0:* LISTEN 29984/vsftpd

I can telnet/FTP into port 21 locally, so vsftpd is indeed running properly, but I cannot connect from the outside at all. I have also commented out everything in /etc/hosts.allow.

At this point, I am out of ideas. And to top it all off, I'm on a tight deadline. Usually works out there way doesn't it?

View Replies!   View Related
Can't Connect To Remote Desktop
I signed up for a Win2k3 VPS account with 3dgwebhosting. I'm a newbie to Plesk and win2k3 so I spent the first day getting head around Plesk.

I then logged into Remote Desktop only to find someone else had beat me. They'd hacked in and downloaded a mass email client, email stripper and obviously sent out spam from a 2mb text file of email addresses.

I didn't spend long in Remote Desktop, but while there I switched on Windows Firewall, changed my admin login password and logged off.
Now, 24 hours later, I can't get back in. I get the error - This computer can't connect to the remote computer. Try again.....

I can still login through Plesk, FTP and ExpressionWeb.

Is FW keeping me out of RD or has the hacker returned?

View Replies!   View Related
How Can I Connect More Than Server With One Domain
i want to know how EXACTLY connect more than server with one domain

i will explain what i want [note : sites & ip all for example below]

i have a site name [company name] is www.comanyname.com

and i have two servers [client servers] with the following dns

server 1#
ns1.companyname.com pointed to ip 192.168.1.1
ns2.companyname.com pointed to ip 192.168.1.2

server 2#
ns3.companyname.com pointed to ip 10.0.0.1
ns4.companyname.com pointed to ip 10.0.0.2

now i want to make a NEW domain name like

www.companynamedns.com

and i want this domain hold all client's servers [want to spilt the company dns of the client dns], like

ns1.companynamedns.com
ns2.companynamedns.com
ns3.companynamedns.com
ns4.companynamedns.com
vip.companynamedns.com
s1.companynamedns.com

i can make any name server like i want,

so the first thing it must to be all server's ip that i want to connect to the domain companynamedns.com in www A record and mx record too

and if u ping to companynamedns.com every time it give you random ip [cuz i put www a record for more than server with same one domain name]

so this way not very cleard for me and i want to know

how can i add the www a record?

should i create a dns zone in any server but this entry in one server in whm [note i use cpanel/whm]?

and put the www A record with new domain name companynamedns.com for every time i get a new server like i add www A record this

companynamedns.com 1 A 192.168.1.1 14400s
companynamedns.com 1 A 10.0.0.1 14400s
companynamedns.com 1 A 10.10.10.1 14400s
companynamedns.com 1 A 11.11.11.1 14400s

and mx record like this

companynamedns.com 1 TXT v=spf1 a mx ip4:192.168.1.1 ip4:10.0.0.1 ip4:10.10.10.1 -all 14400s

but how about the ns record?

should i but all ns record in the dns zone in whm?

[note : there is another company make this trick and he have alot of name server NS but i didn't see all registred in dns records only 2 NS for the site And pointed to one server only]

so how can the client connect the the server with ns that the main domain name companynamedns.com already did't added the others NS in the dns zone

like A client make the nameserver for his site is

ns22.companynamedns.com
ns23.companynamedns.com

but the DNS Records for the companynamedns.com is ONLY

s1.companynamedns.com
s2.companynamedns.com

so how the ns22 and ns23 working and it didn't even added in the dns zone in the main domain companynamedns.com

maybe he add all the name server he want in the domain control panel in the child name server only not in the name server but i think it didn't work it must be add in the name server too

i really going to be CRAZY for this

this trick is the right way to connect more than server with one domain name

i colored the thread to read and get my idea easy and i really need expert help me with that issue

View Replies!   View Related
Can Not Connect To Whm Cpanel
i runnig backup, after runing backup, i can not connect to whm cpanel

show this error:

In order to access the interface, you will need to make sure that the software license on this server is active and installed.

Your license could not be activated because:

Cannot Read License File

View Replies!   View Related
How To Connect Virtual PC To Host PC
I've downloaded and installed the Microsoft Virtual PC image for testing IE6. The development copy of my website is on the host PC, running on Windows XP/Apache/PHP. I need to use IE6 on the virtual PC to view pages served up by Apache on the host PC.

I know this requires networking them together, but I've no idea how to do that. I've installed the Microsoft Loopback Adapter on the host PC, and told the virtual PC it can use that adapter in the Virtual PC settings dialogue, but on the host PC the loopback adapter says "limited or no connectivity".

(Before someone suggests it, I've been using MultipleIEs. Trouble is, you can't test printing with that - you need a proper copy of IE6.)

View Replies!   View Related
Shoutcast Customers Cannot Connect
i have problem with shoutcast accounts....i have some shoutcast servers in ports 8002,8004,8006,8008,8010,8012... every day some of the shoutcast server or all, goes down and the customers can connect by winamp...so as result i am always go to start the servers by myself...why these happening?why the servers are going down? is there an automatically way to start them when they stop?

View Replies!   View Related
Fail To Connect To Mailservers
I have this server with no control panel and dnsreport could not connect to mailservers on all my domains. But the server can send out emails because I'm receiving logwatch emails, etc. I'm also using dnsmadeeasy for my nameservers.

Quote:

ERROR: I could not complete a connection to any of your mailservers!

mail.mydomain.com: Timed out [Last data sent: [Did not connect]]

If this is a timeout problem, note that the DNS report only waits about 40 seconds for responses, so your mail *may* work fine in this case but you will need to use testing tools specifically designed for such situations to be certain.

I tried adding the domains on /etc/mail/local-host-names and restart sendmail but the error is still there.

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved