Plesk 12.x / Windows :: PHP Connecting Over Localhost To MySQL Very Slow
Jan 27, 2015
I have windows server 2012 and Plesk v12.0.18 #30 - I noticed speed problem.
When I try to connect to mySQL with:
$conn = new mysqli('localhost', 'joomla_***', '*****', 'joomla_test');
Connection takes 1 second!!!When I try to connect with '127.0.0.1' instead of 'localhost' connection takes 0,009 seconds.
1. I tried solution to add line '127.0.0.1 localhost' to c:windowssystem32driversetshosts - but no luck.
2. I tried to edit C:Program Files (x86)ParallelsPleskMySQLDatamy.ini - adding lines
bind-address=127.0.0.1
skip-name-resolve
then restarted mySql but 1 second lag time on connection was still there.
3. I even tried to disable IPv6 but still no luck
I guess all users windows windows server 2012 has the same problem??!?!...
View 3 Replies
ADVERTISEMENT
Dec 29, 2008
i'm on Linux dedicated box -DirectAdmin panel
I use Squirrelmail to se my e-mail. When i try to log inn and read mail i get this message: Error connecting to IMAP server: localhost. Where can i change this......
Squirrelmail
SquirrelMail version 1.4.17
By the SquirrelMail Project Team
ERROR
Error connecting to IMAP server: localhost.
111 : Connection refused
webmail
ERROR (2): fsockopen() [function.fsockopen]: unable to connect to localhost:110 (Connection refused) (/var/www/html/webmail/inc/class.uebimiau_mail.php:80)
RoundCube Webmail
Connection to Imap server failed
Read on another forum, that this can solve the problem
/etc/rc.d/init.d/imaps restart
/etc/rc.d/init.d/imap restart
-bash: /etc/rc.d/init.d/imaps: No such file or directory
-bash: /etc/rc.d/init.d/imap: No such file or directory
telnet localhost 143 for imap or 993 for imap over ssl
Usage: telnet [-8] [-E] [-K] [-L] [-X atype] [-a] [-d] [-e char] [-k realm]
[-l user] [-f/-F] [-n tracefile] [-r] [-x] [host-name [port]]
Also Xinetd restart don't help
[root@server etc]# /etc/rc.d/init.d/xinetd restart
Stopping xinetd: [ OK ]
Starting xinetd: [ OK ]
Looks like that Imap isn't installed ?
Correct me if i'm wrong ..............
View 3 Replies
View Related
Nov 11, 2008
I've got 25 domains on a Virtuozzo/Plesk8.6/CentOS5 VPS. Each domain has one up-to-date install of WordPress, most have very little traffic (average 200mb per month), maybe 2 domains get 5-7gb traffic per month.
I monitor port 80 connections and rarely see more than 10 at a time.
That should in my opinion be no problem at all for a VPS with 768mb guaranteed ram and 2.4ghz cpu. I've got 30gb hard drive spare too.
But.... about 8 or 10 times a day it grinds to a complete halt: server load at 500-1000%, sites timing out, plesk takes 3mins to load, often I can't even connect with SSH, and the plesk web server, apache
INSERT INTO module_watchdog_sys_stat (time, type, value, service_id) VALUES(FROM_UNIXTIME(1226404705), 'MAINMEM_USAGE', 17472, 11);
80 seconds sounds like a huge amount of time for a MySQL insert to me! Does anyone know if this is likely to be the cause of my trouble? Some problem with Plesk and the database? Or could it be something else?
View 3 Replies
View Related
Feb 6, 2015
I have a problem with connection to MySQL database over PHP.
If I define host address '127.0.0.1' works well. Problem occurs if host address is 'localhost'.
How to allow both 'localhost' and '127.0.0.1'?
View 1 Replies
View Related
Sep 28, 2014
I setup FTP access on Plesk, then when i try connect to the server it seems to be trying to access through a old installation on FileZilla Beta server manager, that was obviously installed on the server a while back. I can only think it is not using which ever FTP manager Plesk uses.
View 2 Replies
View Related
Apr 2, 2014
In horde how we can configure that it will send email using the logged in user login to authenticate and send the email, currently it using localhost to send the emails.
View 1 Replies
View Related
Jul 11, 2014
After the upgrade of our Plesk installation from 9.5x to 11.5.30Everything works ok (sites,sites with databases, Plesk etc)but when I go to Home>Tools & Settings> Backup Manager.I see errors on every daily backup I have on schedule:
The backup Plesk_Daily_Full_Backup_1407060112.tar has completed with warnings. (View the details) Close this message
Error:mysql "myuser_drupal"
Unable to define superuser password for mysql server on localhost
Error:mysql "myuser_drupal"
Unable to get list of db servers (ErrorCode: 1, STDOUT.
Error:mysql "myuser_wp_eng"
Unable to define superuser password for mysql server on localhost
View 1 Replies
View Related
Aug 4, 2013
I've very slow response (from 1-2 seconds to tens of seconds) from http://localhost using Apache 2.4.3/Win32 service on Windows 8/32bit (6.2 build 9200). It doesn't depend on the browser used. Responses from all other sites are much faster.
Because it seemed to me to be a DNS issue, I tried to uncomment "127.0.0.1 localhost" and/or "::1 localhost" line in the hosts file, put "http://127.0.0.1" or "http://[::1]" instead of "http://localhost" into the browser, flushing dns by ipconfig /flushdns, stopping DNS Client by "net stop dnscache", disabling IPV6, etc. but nothing worked.
It seems that hosts file is ignored and "localhost" is passed to external DNS. Ping localhost yields to "Reply from ::1: time<1ms" response, ping 127.0.0.1 yields to expected "Reply from 127.0.0.1: bytes=32 time<1ms TTL=128" response.
Finally, "unplugging the network cable" is the only solution I've found: then the connection to localhost is much faster.
How to get instant response when connected?
View 6 Replies
View Related
May 15, 2008
i have a windows shared hosting with Go-daddy, created the database and all is fine, but not sure about the DB name.
the name of the Database Host? is it local host?
shall i add any suffix to the DB name?
View 3 Replies
View Related
Feb 10, 2007
i have a mysql databse on 1 server hosted by a company and i want to connect to that databse from a website hosted on another server by another company.
i have chnaged my php connect script from 'localhost' to the ip of the name server on port 3306, i know this isnt right..
how do i find the ip of my website and port of the db?
View 10 Replies
View Related
Oct 30, 2008
I have Mysql installed on my Home server with Java server, and I have php WEB site hosted with Let's say Godaddy or whatever. I need to connect this WEB to my MYSQL. How can i do that?
View 6 Replies
View Related
Aug 3, 2008
I'm facing some odd issues with 2 servers located in the same datacenter.
One server is the HTTP server, and every 5 minutes it works, then for 5 minutes Server One and Server Two (MySQL) hate each other and refuse to talk to each other. Not only can neither not connect to each others MySQL, but also neither can ping each other.
The odd thing is, Server Three can however connect to the Server Two MySQL with no problems during this period. It seems to be just the communication between Server One and Server Two that keeps getting halted.
I've tried "service iptables stop" to disable the firewall, and changing SELinux to disabled, but neither have fixed it.
View 4 Replies
View Related
Jan 3, 2015
I noticed that all my client websites were as slow as a snail snot before uninstalling perl and Python.
Is it normal that perl and python components slowing down IIS?
I search online, it is a common scenerio for those two to slow down IIS.
After I uninstalled perl and python as well as awstat, the site are working as fast as before.
View 2 Replies
View Related
Jul 4, 2007
I have this problem with MySQL
Quote:
Error while connecting to MySQL. Failover enacted.
MySQL is Running and Working, how i can fix this problem?
View 9 Replies
View Related
Jun 26, 2014
We have more than 10 domains on the same webspace, sharing the same document root. When we try to add a new domain on the same web space (sharing the same document root) Plesk takes a long time to create it (about 10 minutes). While domain creation, all the other domains sharing the same document root and web space get an authentication error. When Plesk finishes, all domains work again.
View 1 Replies
View Related
Aug 2, 2008
I've been using Dreamhost for years and they're very good, but their MySql databases are quite slow. Then I moved to ServInt with a VPS, and my MySql is on localhost instead of on a different server. WOW! It's so fast!
However, now I'm trying to find a shared hosting package that has fast MySQL service.
I'm not sure if the requirement is that it's on localhost but it sure doesn't hurt.
Is there anyone who is familiar of a good solid shared hosting package with fast MySQL service?
View 11 Replies
View Related
Jun 29, 2007
I am using localhost as mysql server name on my config file. then, when I enter [url], the address will automatically change to[url]that obviously getting error. when I change the mysql server name from localhost to the server public IP, everything seems ok.
My sql is 4.1.x with php 4.4.7, is that any way I may use localhost instead of IP?
or is there any potential danger using IP?
View 2 Replies
View Related
Jun 24, 2009
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 9 Replies
View Related
Apr 1, 2007
I have had great difficulty in setting up OpenVPN, so I thought, when I finally do get it to work, I will write a HOWTO, so other can hopefully benefit…
This guide was done using a FC4 VPS, running on Xen, it will work on OpenVZ, all you need to do is ask your VPS provider to install “tun support”.
1.First of all get a few additional repos, If you already have your repos setup, skip this step
If you have Fedora 3, follow these steps,
[url]
If you have Fedora 4, follow these steps,
[url]
If you have Fedora 5, follow these steps,
[url]
If you have CentOS, follow the “additional third party CentOS repos”
[url]
Then issue these commands, each line is a new command, anything beginning with "#" are comments so dont try to execute those.
Code:
yum update
yum install openssl openssl-devel
# openssl and openssl-devel may be installed already… so don’t worry
2. Right, now you want to install OpenVPN, here are the commands,
Code:
yum install openvpn -y
#Now check that it works
service openvpn start
service openvpn stop
3. A few things to setup before you can make certificates, issue these commands,
Code:
find / -name "easy-rsa"
#you should get an output like this…
/usr/share/doc/openvpn-2.0.7/easy-rsa
#Now, make a copy of the easy-rsa directory, to /etc/openvpn/ ( make sure you #have put the right version number in i.e. mine was -2.0.7, change if needed)
cp -R /usr/share/doc/openvpn-2.0.7/easy-rsa /etc/openvpn/
cd /etc/openvpn/easy-rsa
chmod 777 *
mkdir /etc/openvpn/keys
4. You need to edit the vars file, located in /etc/openvpn/easy-rsa
You can use any editor you like, I used vi.
Change the line
Code:
export KEY_DIR=$D/keys
to
Code:
export KEY_DIR=/etc/openvpn/keys
Also at the bottom of this file you will see something similar to this,
Code:
export KEY_COUNTRY=US
export KEY_PROVINCE=CA
export KEY_CITY=SOMEWHERE
export KEY_ORG="My Org"
export KEY_EMAIL=me@mydomain.com
Change this to your own values.
5. Now its time to make the certificates, enter these commands
Code:
. ./vars
Code:
./clean-all
Code:
./build-ca
# just hit enter to the defaults apart from Common Name, this must be unique
# call it something like mydomain-ca
Code:
./build-key-server server
Code:
./build-key client1
# remember that common name must be unique e.g. use mydomain-client1
# and YES you want to sign the keys
Code:
./build-key client2
# do this step for as many clients as you need.
Code:
./build-dh
6. We are almost done now… right we need to create a few config files, you can download my template from here,
Code:
cd /etc/openvpn
Code:
wget www.designpc.co.uk/downloads/server.conf
# make sure you change a few things in the server.conf file, like DNS
# servers
Code:
touch server-tcp.log
~ this makes the log file..
Code:
touch ipp.txt
this makes the IP reservation list.
7. You need to make a few changes to OpenVPN itself. Go to..
Code:
cd /etc/init.d/
edit the openvpn file
#Uncomment this line (line 119)
Code:
echo 1 > /proc/sys/net/ipv4/ip_forward
Add these lines below it, changing 123.123.123.123 to your public IP address,
Code:
iptables -t nat -A POSTROUTING -s 192.168.2.3 -j SNAT --to 123.123.123.123
iptables -t nat -A POSTROUTING -s 192.168.2.4 -j SNAT --to 123.123.123.123
iptables -t nat -A POSTROUTING -s 192.168.2.5 -j SNAT --to 123.123.123.123
iptables -t nat -A POSTROUTING -s 192.168.2.6 -j SNAT --to 123.123.123.123
iptables -t nat -A POSTROUTING -s 192.168.2.7 -j SNAT --to 123.123.123.123
iptables -t nat -A POSTROUTING -s 192.168.2.8 -j SNAT --to 123.123.123.123
iptables -t nat -A POSTROUTING -s 192.168.2.9 -j SNAT --to 123.123.123.123
iptables -t nat -A POSTROUTING -s 192.168.2.10 -j SNAT --to 123.123.123.123
Now install iptables if you don’t have it already,
Code:
yum install iptables
#test it
service iptables start
service iptables stop
8. Now for the client config files. If your client is a Windows machine, make sure you have installed OpenVPN, use the gui version, downloadable from here;
[url]
You need to copy a few files from the server to your client machine, here is the list, located in /etc/openvpn/keys/
## WARNING ## Use a secure way of transferring these files off the server, something like WinSCP.
ca.crt
client1.csr
client1.key
client1.crt
Put these files in this directory C:Program FilesOpenVPNconfig
Now you need to make a client config, here is an example..
PHP Code:
clientdev tunproto tcp#Change my.publicdomain.com to your public domain or IP addressremote my.publicdomain.com 1194resolv-retry infinitenobindpersist-keypersist-tunca ca.crtcert client1.crtkey client1.keyns-cert-type server#DNS Options here, CHANGE THESE !!push "dhcp-option DNS 123.123.123.123"push "dhcp-option DNS 123.123.123.124"comp-lzoverb 3
Make sure you edit any of the lines with comments above them.
Call this file client1.opvn and put it in C:Program FilesOpenVPNconfig
Make sure the file extension is .opvn not .txt
To connect right click on OpenVPN in the taskbar >> Connect
To test ping 192.168.2.1
View 14 Replies
View Related
Apr 30, 2015
The FTP on my VPs running centos 6.6 and plesk 12.0.18 Update #44 has stopped allowing FTP conections via filezilla or dreamweaver. My tech knowledge with server management outside of the gui is minimal but i have done the following. Checked that the firwall is allowing ftp traffic through the GUI in plesk.
restarted xinetd and checked status
[root@367549 ~]# service xinetd status
xinetd (pid 11707) is running...
[root@367549 ~]# lsof -i tcp:21
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
xinetd 11707 root 5u IPv6 682472 0t0 TCP *:ftp (LISTEN)
Then tried the following
[root@367549 ~]# ftp localhost
-bash: ftp: command not found
But i can connect via telnet on port 21
when trying to use +dreamweaver or filezilla i get the following. This may be due to one or more of the following reasons: - The network cable is unplugged or the network is down. Please verify that the network cable is connected and that the network is up. - The FTP server is down. Please verify that you can connect to the FTP server using another FTP program. - The FTP host name is incorrect. Please verify that the host name is correct in the Site definition dialog box. - Accessing the server requires proxy settings that aren't properly set. Please verify that the proxy settings in the Site category of the Preferences dialog box are properly set, and that the Use Proxy option in the Site definition dialog box is selected. - You may need to connect to the server using a different port than the one provided. Please specify the correct port in the box provided.
Error: The data connection could not be established: ETIMEDOUT - Connection attempt timed out
Error: Connection timed out after 20 seconds of inactivity
Error: Failed to retrieve directory listin.
What to do and why after no change this just stopped working when ive been using ftp on this server previous.. the company that i brought the vps from have no intrest and tell me its unmanaged.
View 6 Replies
View Related
Nov 17, 2014
For one of my dedicated server I have the follwoing scenario:
Microsoft Windows Server 2012 X64
Plesk 11.5.30 Update #48
Plesk Panel - Tools and Settings -> Database Server -> Add Database Server
Type: MySql - host: localhost - Port 3307
Actual Result: error unable to connect to host
Expected result: New instance and service of MySql Server
Port 3307 is no firewalled and I have added a rule to allow connection on 3307
View 2 Replies
View Related
May 21, 2014
In order to install moodle, I need to upgrade MySQL from 5.1 to 5.5. I have gone through one of the KB articles [URL], but it's not very clear.
Can I upgrade it through Add/remove Components from Install and update products just like it can be done for PHP?? I see MySQL Server 2005, 2008 and 2012,
View 2 Replies
View Related
Mar 23, 2014
I can't start MYSQL. How can i fix this?
View 3 Replies
View Related
Oct 14, 2014
After some recents updates (currently running on: 12.0.18 Update #19) appeared a problem with connecting to FTP for passive mode users:
Connect ok!
"/" is the current directory
Get directory
227 Entering Passive Mode
550 Access is denied.
Server logs:
/var/log/messages
Oct 14 12:11:26 host xinetd[3692]: START: ftp pid=2709 from=::ffff:xxx.xxx.xxx.xxx
Oct 14 12:11:26 host proftpd[2709]: processing configuration directory '/etc/proftpd.d'
Oct 14 12:11:26 host proftpd[2709]: yyy.yyy.yyy.yyy (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]) - FTP session opened.
But:
/var/log/secure:
Oct 14 12:11:26 host proftpd: PAM unable to dlopen(/lib64/security/pam_stack.so): /lib64/security/pam_stack.so: cannot open shared object file: No such file or directory
Oct 14 12:11:26 host proftpd: PAM adding faulty module: /lib64/security/pam_stack.so
Oct 14 12:11:26 host proftpd: pam_listfile(proftpd:auth): Couldn't open /etc/ftpusers
Oct 14 12:11:26 host proftpd[2709]: yyy.yyy.yyy.yyy (xxx.xxx.xxx.xxx[xxx.xxx.xxx.xxx]) - USER client: Login successful.
ad1: yes, i do have passive ports configured in /etc/proftpd.conf and FW is properly configured
ad2: everything was fine until recent updates
ad3: this is happening only for passive users only
ad4: we are experiencing this issues across all Plesk instances [6x] on CentOS 6.5 with 12.0.18 Update #19Â
View 6 Replies
View Related
Sep 12, 2014
I have a dedicated server and I am about to get a few high traffic sites that will be Joomla based and MySQL served. What I am thinking a about is to create another MySQL instance, leave the current websites on the "old" instance and get the new ones onto a separate instance.
I am on PPP 11.0.9 on windows and the current mysql version is 5.1.56 on port 3306 (I can get other ports for other instances).
What I did was the following:
In the Database Servers page, I hit "Add Database Server"
In the next page I add the following:
MySQL (from the dropdown)
localhost
3307
(leave blank the default check box)
I then add the Administrator's username and passwords and hit OK.
The next page, reports an error message (in between asterisks below):
************************
Error: Test connection to the database server has failed because of network problems:
No connection could be made because the target machine actively refused it.
************************
The primary (eg. current) mysql instance is working fine, it's just I cannot add a second server...
View 3 Replies
View Related
Jul 29, 2012
Plesk has mysql installed with it to run properly and I need to upgrade that version to the latest. Now I am not talking about the mysql server that it provides for me to create databases on. I am talking about the version it uses to run.
View 3 Replies
View Related
Jul 17, 2012
I've upgraded to 11, but when I try and apply updates, I'm getting
WARNING: Unable to connect to local default MySQL server. Read carefully article [URL] ..... for details.
I've followed the directions in the KB mentioned, but haven't had any luck yet.
View 8 Replies
View Related
Sep 29, 2014
We have a special application that works on 3 servers, 1 of them is main server and others are mysql replicate servers basically used for generating reports or backups...
Server 1 - Centos 6.5/Mysql 5.5/Plesk 12
Server 2 - Centos 6.5/Mysql 5.5/Plesk 11
Server 3 - Server 2008 R2/Mysql 5.5/Plesk 12
Server 1->Server 2 replication works perfectly
Server 1->Server 3 replication sometimes fails with character issues (our database and tables use utf8_turkish_ci), when I tried to investigate this issue by logging in to mysql on Server 3 right after connection i saw "Unknown OS Character Set 'cp857' Switching to default character set latin1" and i am guessing that my replication issues are also related to this issue. I tried adding below settings to my.ini at "C:Program Files (x86)ParallelsPleskDatabasesMySQLdata"
[mysqld]
init_connect='SET collation_connection = utf8_turkish_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_turkish_ci
skip-character-set-client-handshake
[mysql]
default-character-set=utf8
default-collation=utf8_turkish_ci
[client]
default-character-set=utf8
default-collation=utf8_turkish_ci
but didnt change anything, i was wondering if these settings were wrong so i tried them at my local wamp installation which i was having same error, but error was gone after adding them to my.ini so i think settings are alright...
View 3 Replies
View Related
