Plesk 11.x / Windows :: MySQL Stopping With No Apparent Reason
Apr 2, 2014
PRODUCT, Plesk for Windows VERSION 11.5 latest update VERSION OF MICROUPDATE 11.5.30 Actualizar #39, OPERATING SYSTEM Windows 2008 Server Suddently with no apparent reason, MYSQL stops and Ihave to go to the panel and restart it.
Every Morning I have to restart MySQL thru the control panel in remote console of windows..Works all day long, and then stops at night..Should work as always did, for several months I did not even reboot the server, no I have to reboot the server to see if that fixes the problem. Latest windows update, latest Plesk for windows update, but I have the feeling that with the latest microupdate something has broken,
View 3 Replies
ADVERTISEMENT
Jan 22, 2008
I have a dual processor, dual core server with 12GB memory.. It uses less than 4% CPU utilization and less than 5% memory utilization, but for some reason It's really slow to load sites...
I know this isn't much information, but would any have any ideas as to what could cause the slow speed?
If is anyone is available to look at it, I'll pay you (obviously).
View 7 Replies
View Related
Jun 27, 2009
I have a dedicated machine collocated at some hosting provider and after a while (14 days or so, but timeframe is not constant) it hangs for no apparent reason. It happened 2 times already. Nothing in the logs (it logs everything), nothing at all.
Before the commission the machine was running for a month without any problems.
The first time it happened the tech guy plugged in monitor and keyboard and could not see anything on the display. Before that machine was not loaded with any traffic, nobody should have actually known it is there (except for some DNS traffic). It took some 20 days of uptime.
The second time it happened was yesterday, after some 15 days of uptime.
I suspect hardware malfunction because I have 2 "identical" (OS & progs, not the hardware) systems running without any problems. It is an HP DL380 G5 machine, the problematic one.
View 3 Replies
View Related
Jan 10, 2007
I've got a problem with an SQL query that is behaving badly. Its probably really obvious, but I can't see the problem!
I have a table with 3 fields:
Code:
money bigint(20)
income int(12)
userID mediumint(7)
I have a row that has a negative money and a value of 0 for income. When I update the money value to add "0" to it, nothing happens (as expected). When I update the money field to add the income field (which is equal to 0) to it, MySQL flips the sign to make the money field positive.
The following queries show the problem:
Code:
mysql> SELECT money, income from users where userID=327961;
+----------------------+--------+
| money | income |
+----------------------+--------+
| -9223372036854775807 | 0 |
+----------------------+--------+
1 row in set (0.00 sec)
mysql> UPDATE `users` SET money = money + 0 WHERE userID =327961;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
mysql> SELECT money, income from users where userID=327961;
+----------------------+--------+
| money | income |
+----------------------+--------+
| -9223372036854775807 | 0 |
+----------------------+--------+
1 row in set (0.00 sec)
mysql> UPDATE `users` SET money = money + income WHERE userID =327961;
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql> SELECT money, income from users where userID=327961;
+---------------------+--------+
| money | income |
+---------------------+--------+
| 9223372036854775807 | 0 |
+---------------------+--------+
1 row in set (0.00 sec)
mysql>
Notice that there is no negative sign after the third select!!
So, we are saying that executing an update where 0 is specified in the query results in the correct action but if you take the 0 from another field it takes the negative sign away...
This for various reasons is a rather urgent problem. This problem has only appeared after upgrading from MySQL 4.0 to MySQl 5.1. This problem does not occur in MySQL 4.1.
View 1 Replies
View Related
Jul 15, 2015
I am trying to run backups to an off site location, however, I have noticed that even if I try on the server side, it will only backup 2gb, which when I check the backup, the file structure is there, but there arent any files in the backups.
View 8 Replies
View Related
Nov 27, 2014
Plesk 11.5 Lunix
Centos 5.6
I am having problem sending email. Email from others came in but when sent from the server it does not arrived.
SMTP Server (Postfix) keep stopping...
View 11 Replies
View Related
Dec 3, 2014
we use CentOS Linux 7.0.1406 (Core) Plesk Version 12.0.18 Update #26 I got reports of several users on my system, and i can confirm this myself, that fail2ban is blocking courier imap and postfix connections when i try to connect to the Plesk Server with Outlook 2013 and theBat and the Apple Mac Mail Client.
I used the correct login information but fail2ban blocked the IPs for no obvious reason:
Code:
2014-12-03 12:46:57,908 fail2ban.actions[920]: WARNING [plesk-postfix] Ban 82.134.94.102
2014-12-03 12:46:58,049 fail2ban.actions[920]: WARNING [plesk-courierimap] Ban 82.134.94.102
I disabled the two jails now and it works perfectly. But why is fail2ban blocking valid requests ? I tried it myself and i did not enter a wrong password or something. MaxRetry is 5 so this should not be a problem. The problem is not affecting all users but just a few. However all of them are using correct credentials so i dont understand why they are being blocked at all.
View 1 Replies
View Related
Aug 24, 2014
I thought this problem was fixed in Plesk 11.5 but I'm still getting the following backup warnings in Plesk 12..."For security reason backup is performed on behalf of subscription system user...."
My phpbb forum creates cache files which have apache ownership and Plesk backup manager gives warnings that it cannot backup the files due to ownership errors.
I have searched for days for a solution without success. If I change the permissions to owner instead of apache the forums don't function correctly.
Is this a Plesk bug that is still evident in Plesk 12?
View 10 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
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
Feb 19, 2007
My site is being attacked by what appears to be a dictionary attack on my mail account. They are sending e-mails to random accounts at my domain from random e-mail accounts from somewhere else. Each of their messages is coming from a unique e-mail address and a unique IP address.
Now, we have some dictionary ACL installed that basically blocks any IP address that is caught doing this. So we are blocking tons of IP addresses, but they keep coming at us with new ones. We also have it setup so that the mail is rejected right away for any accounts that aren’t actual e-mail accounts of yours. However, they are hitting the server so hard that it doesn’t seem to be making any difference.
View 17 Replies
View Related
Apr 22, 2013
I have read about people wanting to change their database from MSSQL to MySQL. I however am wanting to change from MySQL to Microsoft SQL in our Plesk panel.
View 7 Replies
View Related
May 27, 2014
I need to get a list of suspend domains from mysql. The domains are suspend because they exceeded quota.So far I have done this query:
#############
select domains.id,
domains.name as domena,
Round(((sum(domains.real_size))/1048576),2) realMB,
(select Round((limits.value/1048576),2) from limits left join (domains, subscriptions, subscriptionproperties) on (domains.id=subscriptions.object_id and subscriptions.id=subscriptionproperties.subscription_id and subscriptionproperties.value=limits.id) where subscriptionproperties.name='limitsId' and limits.limit_name='disk_space' and domains.name=domena) quotaMB
from domains
where domains.status='2' and
(select (sum(domains.real_size)))>0
group by domains.cl_id;
but I didnt managed to get only those that exceed the quota.
View 3 Replies
View Related
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
View Related
Aug 29, 2013
After an unexpected server shutdown. We cant start mysql anymore.
Error: Could not complete the operation: defpackagemng failed: The process terminated unexpectedly. (Error code 1067) at Start service MySQL
View 4 Replies
View Related
Aug 13, 2013
Since we upgraded to Plesk 11.5 or (I'm not shure) the last Update 12, user can not import MySQL-Databases anymore.
If the user open phpMyAdmin for import and select the database and click on Ok, phpMyAdmin does nothing.
I heard that could be a problem with JQUERY and I checked the files in ParallelsadminhtdocsdomainsdatabasesphpMyAdminjsjquery and all files seems to be there.
Only if I check the source of the phpMyAdmin Import-Website it seems, there is a problem with jquery-1.6.2+fix-9521.js.
But how I can fix this problem for all Windows-Servers.
View 19 Replies
View Related
Feb 9, 2015
Running Plesk 12.0.18 on Windows 2012
I create a new domain then use Plesk Applications tab to install Wordpress. It shows the message:
Code:
Error: Unable to install the app because its installation requirements are not met. Contact your hosting provider to resolve this problem.
Requirements
PHP extension
The 'mysql' extension was not found.
However, php is installed and phpinfo shows that the mysql extension is installed. I try different versions of php, cgi/fastcgi but ll fail with the same error. I install Wordpress via FTP and it works fine.
There are knowledge-base articles relating to this error but they are for Linux and the solutions don't work in this case:
[URL] ...
[URL] ...
Maybe the Wordpress database has to be created before using Plesk to install Wordpress? If so, what should the database name be? How does Plesk know what the name of the database is that it should use? Why doesn't Plesk just create a database to use?
View 6 Replies
View Related
Apr 21, 2015
After installing Plesk 12.0.18 Update 43 on windows when I try to connect to Plesk Panel (https://myurl.com:8443/) I get error:
ERROR: PleskMainDBException: Host '127.0.0.1' is not allowed to connect to this MySQL server (db.php:435)
I tried to reset mysql admin password as described in article - with no luck : [URL] .....
I even tried to reset password:
%plesk_bin%plesksrvclient -set "newpassword" true
Again I get "Faild to connect to database: Host '127.0.01' is not allowed to connect to this mySQL server
All websites that uses mySql works but Plesk Panel is dead?
View 3 Replies
View Related
Mar 20, 2014
I have Plesk Windows version, when I want import my backup mysql, i see below error:
Error: dbbackup failed: Unable to restore database 'admin_IranDnn'
ERROR 2006 (HY000) at line 1: MySQL server has gone awayClick to expand...
View 7 Replies
View Related
May 7, 2013
when im trying to enable spam filter for a particular email account i get this mysql error:
Error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'xxxx@domain.com' for key 3 (mail id i hid it for security reasons xxxx@domain.com)..
i searchd in the psa database but could not find any duplication...
View 2 Replies
View Related
May 13, 2007
I have WHM 11.1.0 cPanel 11.2.1-C11635
FEDORA 4 i686 - WHM X v3.1.0
PHP Version 4.4.4
I'm not sure what my apache version is.
I want to try this:
http://www.webhostgear.com/232_print.html
It says it's for Apache 1.3x, PHP 4.3x
Will that work on my server? Will it be safe to try?
View 8 Replies
View Related
Jul 6, 2007
Currently my site is having a extreme surge in traffic (in and out). My webhost just sent me a warning, saying that my site is generating abusive traffic to the host's network.
Code:
Please be aware that abusive traffic is being generated from your IP, xx.xxx.xx.xxx, directed to our network as seen in the logs below. We have added a Nullroute for this IP on our network for a period up to 24-hours. Please take action to remove and prevent this abusive traffic from being generated. Repeated offenses will result in a permanent Nullroute of your entire network block.
2007-07-05 09:59:51 - sensor-ds04.tpa.sagonet.net - sshd[13496]: Did not receive identification string from ::ffff:xx.xxx.xx.xxx
2007-07-05 09:59:51 - unknown.sagonet.net - sshd: refused connect from ::ffff:xx.xxx.xx.xxx (::ffff:xx.xxx.xx.xxx)
2007-07-05 09:59:51 - spamassassin-lbb.tpa.sagonet.net - sshd[24910]: Did not receive identification string from xx.xxx.xx.xxx
2007-07-05 09:59:51 - spamassassin-lba.tpa.sagonet.net - sshd[32041]: Did not receive identification string from xx.xxx.xx.xxx
2007-07-05 09:59:51 - spamassassin-lbb.tpa.sagonet.net - sshd[24911]: Did not receive identification string from xx.xxx.xx.xxx
2007-07-05 09:59:51 - spamassassin06.cust.sagonet.com - sshd[12792]: refused connect from ::ffff:xx.xxx.xx.xxx (::ffff:xx.xxx.xx.xxx)
2007-07-05 09:59:49 - sensor-ds06.tpa.sagonet.net - sshd[99600]: warning: /etc/hosts.allow, line 1: host name/address mismatch: xx.xxx.xx.xxx != thtdomains.com
2007-07-05 09:59:49 - sensor-ds06.tpa.sagonet.net - sshd[99600]: warning: /etc/hosts.allow, line 1: host name/address mismatch: xx.xxx.xx.xxx != thtdomains.com
2007-07-05 09:59:49 - sensor-ds06.tpa.sagonet.net - kernel: Jul 5 09:59:49 sensor-ds06 sshd[99600]: warning: /etc/hosts.allow, line 1: host name/address mismatch: xx.xxx.xx.xxx != thtdomains.com
2007-07-05 09:59:49 - sensor-ds06.tpa.sagonet.net - kernel: Jul 5 09:59:49 sensor-ds06 sshd[99600]: warning: /etc/hosts.allow, line 1: host name/address mismatch: xx.xxx.xx.xxx != thtdomains.com
2007-07-05 09:59:49 - sensor-ds06.tpa.sagonet.net - sshd[99600]: refused connect from xx.xxx.xx.xxx (xx.xxx.xx.xxx)
2007-07-05 09:59:49 - sensor-ds06.tpa.sagonet.net - sshd[99600]: refused connect from xx.xxx.xx.xxx (xx.xxx.xx.xxx)
2007-07-05 09:59:49 - sensor-ds06.tpa.sagonet.net - kernel: Jul 5 09:59:49 sensor-ds06 sshd[99600]: refused connect from xx.xxx.xx.xxx (xx.xxx.xx.xxx)
2007-07-05 09:59:49 - sensor-ds06.tpa.sagonet.net - kernel: Jul 5 09:59:49 sensor-ds06 sshd[99600]: refused connect from xx.xxx.xx.xxx (xx.xxx.xx.xxx)
2007-07-05 09:59:52 - sensor-ar01.tpa.sagonet.net - sshd[12730]: warning: /etc/hosts.allow, line 1: host name/address mismatch: xx.xxx.xx.xxx != thtdomains.com
My VPS is using Plesk v8.01 as the control panel. I have purchased my own 3 IPs so I'm sure this is not the case of sharing the same IP with another account.
I've checked the cgi-bin directory but there is nothing there except the usual default file (test.cgi). And I never have the right to alter the cgi-bin directory (can't remove, can't add files).
The traffic surge costs me 10 GB (in) and 5 GB (out) bandwidth a day as opposed to the normal 100~200 MB a day. I haven't ask them the exact form of the abuse. So far, I think my IP has becoming the source of abusive traffic that burdens THEIR server.
I've checked the latest access.log and everything looks normal.
But when I checked using menu Virtuozzo/Traffic Statistics, I can see that the incoming and outgoing traffic are surging up unnaturally (this is the third day).
Hour/Incoming/Outgoing (in MB):
Code:
01 5.61 26.31
02 4.94 25.11
03 6.77 33.48
04 10.42 47.17
05 91.43 94.06
06 289.51 196.99
07 309.13 200.02
08 51.78 33.33
View 2 Replies
View Related
Jan 15, 2008
Has anyone had any good results using spamassasin? If so, how did you go about setting it up? I was hoping someone would share some real world settings that work.
View 10 Replies
View Related
Nov 5, 2009
Can you control SPAM on a server ? I've got this email account that all receives is SPAM, nothing else. I'd like to eliminate this so it doesn't get any more SPAM.
View 13 Replies
View Related
Sep 4, 2008
I have ffmpeg installed on a webserver. If I enter the command to begin a conversion process, or the command is sent through PHP via exec(), it keeps going until it finishes or runs into an error.
Is there a way to cancel a conversion process after it's been started either through the command line or via PHP exec()?
View 4 Replies
View Related
