Plesk 12.x / Linux :: Batch MySql Script Stopped
Oct 2, 2014
I've this terrible problem: on my site I start a script that executes a batch process that imports into the Mysql database a lot of products (texts and images). I'm monitoring the query process from Phpmyadmin>Status and I notice that after some minutes the number of queries decreases from ~900 to ~30, that means that the script is stopped! Then I check the error_log and infact there's this error:
[Thu Oct 02 17:09:34 2014] [warn] [client xxx.xxx.xxx.xxx] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server
[Thu Oct 02 17:09:34 2014] [error] [client xxx.xxx.xxx.xxx] Premature end of script headers: insert_products.php
Some informations:
VPS server: 1 CPU; 40gb; RAM 1GB
OS: CentOS 6.5 (Final)
Plesk version: 12.0.18
What I tried via SSH console:
# /usr/local/psa/admin/bin/php_handlers_control --list
id: display name: version: type: cgi-bin: cli-bin: php.ini:
module 5.3.3 5.3.3 module /usr/bin/php-cgi /etc/php.ini
fastcgi 5.3.3 5.3.3 fastcgi /usr/bin/php-cgi /etc/php.ini
cgi 5.3.3 5.3.3 cgi /usr/bin/php-cgi /etc/php.ini
# /usr/bin/php-cgi -v
[code]....
View 2 Replies
ADVERTISEMENT
Oct 15, 2014
During the installation procedure, the script stopped unexpectedly
Errors were encountered while processing:
/var/cache/apt/archives/psa-proftpd_1.3.5-ubuntu14.04.build1200140604.16_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
View 1 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
Jul 12, 2015
Our partition become full and drop the vps, after that we are unable to start postifx, actually postfix start but master not.
So if I run :
/etc/init.d/postfix restart
Shutting down postfix: [FAILED]
Starting postfix: [ OK ]
/etc/init.d/postfix status
master is stopped
I already try to reconfigure all
/usr/local/psa/admin/bin/mailmng-service --start-service --mail-component=all
Into ToolsSettings i change between qmail and come back again to postfix (reinstalling)...
View 3 Replies
View Related
Sep 15, 2014
I have recently migrated my websites from Plesk 11.0.9 to a new server with Plesk 12.x and the webalizer is not working.
- Is there a chance to repair it and not loose the data? If yes, how do I do that?
- Or do I have to remove it and install Webalizer again? How do I do that?
OS Ubuntu
Uninstalling Webalizer with plesk updater is not possible.
After executing this:
Code:
# /usr/local/psa/admin/bin/statistics --calculate-all
I get:
Code:
WARNING during statistics_collector execution: : Executing logs preparation...
error: error creating output file /var/www/vhosts/system/domain.tld/logs/error_log.1: File exists
statistics[6845]: Unable to execute logrotate via: /opt/psa/logrotate/sbin/logrotate /opt/psa/etc/logrotate.conf -s /opt/psa/var/logrotate.status
View 8 Replies
View Related
Dec 16, 2014
I just installed Nginx. It seems it works well, but watchdog reports it as "stopped".I restarted watchdog several times, and it always says the service has stopped.What shall I do to make watchdog see Nginx as a working service?
Following this KB [URL] ...., I can confirm that command "/usr/local/psa/admin/sbin/nginxmng -s" return "Enabled".
View 2 Replies
View Related
Feb 12, 2015
on one of our Plesk-Servers (Plesk 12.0.18 Update 34 on Debian 7.6) the scheduled backup stopped working. Scheduled Backup is active in Backup-Manager, but it's not executed.
View 2 Replies
View Related
Jun 9, 2015
Automatic Parallels Plesk. 12.0.18 has stopped working but no solution from plesk yet? I think every user has the same problem. Many people asked the same question but no solution/answer from plesk.
View 13 Replies
View Related
Aug 19, 2014
I am running Plesk 12 . Centos 6.5
I have Plesk Firewall Installed.
After the Plesk Firewall was enabled the FTP Stopped working in passive Mode.
I searched the net and found the following :
Code:
/etc/sysconfig/iptables-config and change the line with IPTABLES_MODULES to: IPTABLES_MODULES="ip_conntrack_ftp"
It started working.
I changed the default FTP port from proftpd.conf
Code:
port 2392
and /etc/services
Code:
ftp 2392/tcp
ftp 2392/udp fsp fspd
I allowed the new port in Plesk Firewall in Incoming connection and disabled port 21
Now I am not able to connect to the ftp, I get the following error. Have I missed anything ?
Code:
Response:257 "/" is the current directory
Command:TYPE I
Response:200 Type set to I
Command:PASV
Response:227 Entering Passive Mode (85,25,51,34,216,46).
Command:MLSD
Error:Connection timed out
Error:Failed to retrieve directory listing
View 4 Replies
View Related
Jun 13, 2014
I am getting this error after installing the AfterLogic WebMail Pro_7 app on a domain.
I removed the app but AfterLogic still appears in the list of available Webmail options. I am getting the error even after changing all my domains to use Roundcube.
backup_info_1406131330.xml:
Line 423 error: Element 'external-webmail': This element is not expected.
My backups since the day I installed that app are no longer valid.
View 2 Replies
View Related
Apr 6, 2015
I'm not been able to start plesk although web and mail services are running.I'm getting the error unable to execute php_handlers_control.I've patched and updated plesk with command line and bootstrap repair and I'm getting this errors:
==> Checking for: mail_responder_restore... fail
/usr/lib64/plesk-9.0/mail_restore: line 820: 17063 Illegal instruction /usr/local/psa//admin/sbin/mailmng-service --restart-service
Errors occured in mail restore procedure
Some utilities have exited with errors:
/usr/lib64/plesk-9.0/mail_auth_dump
/usr/lib64/plesk-9.0/mail_responder_restore
I get Illegal Instruction When I run :
# /usr/local/psa/admin/sbin/mailmng-service --restart-service
Illegal instruction
Also I switched from postfix to qmail and back using the command line with no luck.
/usr/local/psa/admin/bin/mailmng --features
runs without problems.....
/usr/local/psa/admin/logs/panel.log:
[06-Apr-2015 12:47:25 America/New_York] PleskUtilException: '/usr/local/psa/admin/bin/php_handlers_control' '--list-json' failed with code 4.
[code]....
View 8 Replies
View Related
Nov 2, 2014
I am trying to change the cname through a batch.. It is successfully done for English language but I want to use Arabic language. When I am using Arabic it appear like this "????".
View 1 Replies
View Related
Jul 23, 2008
I had configured mysql replication for one of my client. Now the replication is stopped and slave server is not updating the data. How can I resolve this and start the replication again?
View 7 Replies
View Related
Jan 6, 2007
MySQL didn't work well on my server so I had a look at the err file. It indicates that MySQL is getting started and stopped all the time. After it has started it will stop and then start again etc:
070106 14:40:25 InnoDB: Started; log sequence number 5 959534492
/usr/sbin/mysqld: ready for connections.
Version: '4.1.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Communi$
A mysqld process already exists at Sat Jan 6 14:40:28 CST 2007
070106 14:40:38 [Note] /usr/sbin/mysqld: Normal shutdown
070106 14:40:38 [ERROR] /usr/sbin/mysqld: Sort aborted
070106 14:40:40 InnoDB: Starting shutdown...
070106 14:40:41 InnoDB: Shutdown completed; log sequence number 5 959534492
070106 14:40:41 [Note] /usr/sbin/mysqld: Shutdown complete
070106 14:40:42 mysqld ended
070106 14:40:42 mysqld started
070106 14:40:42 InnoDB: Started; log sequence number 5 959534492
View 4 Replies
View Related
Jun 23, 2014
After Plesk panel upgrade to 12.x webadmin stopped working . It's showing following error
Code:
Server Error in '/' Application.
The resource cannot be found.
Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. review the following URL and make sure that it is spelled correctly.
View 2 Replies
View Related
Jun 7, 2015
I would like to Mysql 5.6 installed on Plesk 12. Is that possible? How does it work?
View 1 Replies
View Related
Oct 12, 2014
How to upgrade mySQL from version 5.1 to version 5.5 on linux. We're running CentOS version 6.3 with Plesk 11.09.
The approach outlined here [URL] .... seems like the way to go. I want to be sure that I don't adversely affect our installation.
If it is at all relevant we're running a Joomla 2.5 site.
View 5 Replies
View Related
Mar 14, 2015
Few weeks ago I experienced storage issues on my VPS. I made webspace copies manually cos I know ovh's standard line means:
- copy is forbidden and vm umount impossible.
Reported machine came back to me but with few broken files. That's why I made a copy... Did know the risk. Their cloud line is acceptable - let's say... But I bought that cheap classic 3 for 12 months
Redundant != copy. But while runing production services, company webspace like I do, it's needed! So it would be fantastic feature from Plesk! Definitely needed! Is it possible?
View 6 Replies
View Related
Jul 3, 2015
I am migrating some clients between Plesk panels ...
After migrate 10 domains the Health monitoring growup from MSQL from 1gb to 4.5gb
All 10 websites are small, how can i see to identify which domain/subscription is consuming a lot of resources?
View 6 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
Oct 5, 2013
With one from another server. Now roundcube does not want to connect to mysql anymore, i tried to edit this :
line:$rcmail_config['db_dsnw'] = 'mysql://roundcube:randompassword@localhost/roundcubemail';
i then used a MD5 generator to input the hash in the password field of the roundcube user in mysql, with no luck...I even tried to delete roundcube user from mysql, then remove psa-roundcube, then go through the plesk update manager and install roundcube again, did not change nothing, it didn't even create the roundcube user.
Is there anyway i can reinstall roundcube from scratch?PPP 11.5 up to date on ubuntu 12.04
Code:
[05-Oct-2013 14:03:54 +0200]: DB Error: _doConnect: [Error message: Access denied for user 'roundcube'@'localhost' (using password: YES)]
[Native code: 1045]
[Native message: Access denied for user 'roundcube'@'localhost' (using password: YES)]
[code]....
View 7 Replies
View Related
Sep 22, 2014
I'm still using Plesk 11.5.30 and MySql 5.5.39. That was discribed here how to update. But i need to have a MySql 5.6.5 (minimum) for some software (This version is over 2 years old). I'm using CentOs 6.5. and PHP 5.4.33
how to do this, whitout breaking plesk 11.5.30??
View 4 Replies
View Related
May 18, 2014
i have installed phpMyAdmin becouse I don't like the limitation of db management of Plesk, but I can't find the root password to access in it. I read that Plesk rename "root" user in "admin", but I can't find the password. Where is it?
View 4 Replies
View Related
Aug 28, 2014
I need to upgrade mysql from 5.1.73 to 5.7 but I have applications like lms, cms, and websites that runs with that version with no problems, my question is: Some of you had problems upgrading mysql, because i kwon plesk runs over mysql y i don't want to mess up with plesk.
View 1 Replies
View Related
Nov 28, 2014
I see that Plesk 12 supports MySQL 5.6, but the server I am running is Ububtu 14.04 LTS and comes with 5.5.
I need to make 5.6 available but I can see no way of doing it without breaking Plesk (I already tried just installing it from command line with apt-get install and had to restore the whole server from backup!) - there is no option for MYSQL in Plesks updates & upgrades menu ...
View 14 Replies
View Related
Jul 13, 2015
Did 12.0.18 comes with default maria DB instead of mysql ??
View 2 Replies
View Related
May 20, 2009
how to convert this line of text
"Your server is now available at [url]
to
"67.202.30.141"
In other words, extract the IP address from that URL (replace dashes with dots etc)?
This needs to be inside a windows batch file.
View 2 Replies
View Related
Dec 31, 2007
i want to check in a batch if my client's domain changed name server or not. Are there are tools / script available for that?
View 5 Replies
View Related
Oct 13, 2014
We are running Plesk 12.0.18 with MySQL (Server Version: 5.5.33-MariaDB - openSUSE package) on OpenSuSE 13.1
MySQL is running in strict mode and its fine for the most of our customers. But some are trying to run Contenido, thats a CMS, which could work with this mode and we have to disable mysql strict mode.
So my question is: Is it possible to disable mysql strict mode just for choosen customers?
View 5 Replies
View Related
Dec 19, 2014
I've enabled one more php using this guide: [URL] .... but mysql is not working with the new php installation, how to get it working?
View 7 Replies
View Related
Jul 18, 2014
After changing my web hosting (same system : VPS, same version of linux : CentOS 6 , but passage from Plesk 11 to 12), i am now unable to connect remotely via TCP-IP to my mysql databases (with third-party tools like Mysql Workbench, Toad...) ! I never met this problem before.
The only way to connect is to use a "Standard TCP-IP over SSH" connection method ... but i don't want (i did'nt need this method before) !
Though, remote connections are allowed from any host in the settings.
View 3 Replies
View Related