Plesk 12.x / Linux :: MySQL 5.6 On Ubuntu 12.04?
Jun 7, 2015I would like to Mysql 5.6 installed on Plesk 12. Is that possible? How does it work?
View 1 RepliesI would like to Mysql 5.6 installed on Plesk 12. Is that possible? How does it work?
View 1 RepliesI 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 ...
I have ubuntu 6 server version running.
I am trying to import a database I have however I cannot get it working for the last 2 hours!
I have tried various commands like logging into mysql entering the "use" command to use a database and then variations of the "source" command but my db.sql file doesn't run.
Also tried the full command
mysql -uroot -pMYPASS MYDBNAME < /var/www/site/db.sql
Neither seem to do anything.
PHPMYADMIN shows no database tables at all.
Running mySQL 5.
I have upgraded php 5.5 using below steps,
===
sudo add-apt-repository ppandrej/php5
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install php5
==
Its also upgrading Apache from 2.2 to 2.4 and after installation, it break my Apache configuration and getting configuration errors when adding domains from Plesk etc.
Is there any proper way to upgrade PHP 5.5 in Plesk 12.0(Ubuntu 12.04)...
I am trying to transfer Plesk 12.0.18#34 from an Ubuntu 12 server to an Ubuntu 14 server.
Using the transfer manager, I got these warnings:
The following Apache modules are not installed on the destination server: authz_default. Please install and enable these modules to prevent possible problems. The following Apache modules are disabled on the destination server: roxy_http,proxy_html,proxy,authz_groupfile,reqtimeout. Please enable these modules to prevent possible problems. The php_version 5.3 is not available on the destination server. Instead, Plesk will use the following version: 5.5. To use the same php_version as on the source server, you should turn on or install it on the destination server. 3 domain(s) will be affected.
I am a bit puzzled by the authz_default warning as it is not supported anymore on Apache 2.4.
If I override and launch the transfer, I get these errors:
PHP Notice: Trying to get property of non-object; File: /opt/psa/admin/plib/backup/Conflicts/PleskDataManager.php, Line: 173
PHP Notice: Undefined index: xx.xx.xxx.202 [IP of old server]; File: /opt/psa/admin/plib/backup/Conflicts/PleskDataManager.php, Line: 180
[Code]....
Installing Plesk Panel with Spamassassin on Ubuntu 14.04 LTS gives a significant error:
Restarting SpamAssassin Mail Filter Daemon: No /usr/bin/perl found running; none killed.
server socket setup failed, retry 1: spamd: could not create IO::Socket::INET6 socket on [::1]:783: Cannot assign requested address
server socket setup failed, retry 2: spamd: could not create IO::Socket::INET6 socket on [127.0.0.1]:783: Address already in use
server socket setup failed, retry 9: spamd: could not create IO::Socket::INET6 socket on [127.0.0.1]:783: Address already in use
spamd: could not create IO::Socket::INET6 socket on [127.0.0.1]:783: Address already in use
invoke-rc.d: initscript spamassassin, action "restart" failed.
dpkg: error processing package sa-compile (--configure):
even though spamassassin (i.e. spamd) is not running. The usual suspects for the before mentioned error, being
a) differences in the name of the PIDFILE variable in /etc/default/spamassassin and /etc/init.d/spamassassin
b) directory and/or file location are not readable/writable
are not causing this specific installation bug. The work-arounds:
1 - not installing spamassassin (not an option)
2 - installing spamassassin and (afterwards)
change /etc/default/spamassassin, add the option "-4" to the line OPTIONS, resulting in the line: OPTIONS="--nouser-config -4 --username=popuser --daemonize --helper-home-dir=/var/qmail --virtual-config-dir=/var/qmail/mailnames/%d/%l/.spamassassin --create-prefs --max-children=5"
run plesk-installer or autoinstaller again ..Work-around 2 works fine, after reinstallation the /etc/default/spamassassin is as it should be (note that the added "-4" is not present anymore).
The before mentioned work-around suggests some error in the installation process, very likely to be an issue with the chronological order of installation of the various components. In theory, it can be excluded that this bug/issue is caused by psa-spamassassin and/or spamassassin (version 3.3.x) packages, even though some current spamassassin bugs are known: URL....I sincerely hope that Parallels Team can investigate and patch both of the bugs/issues.
I have an old laptop with the following specification: Memory: 485 MiB, Processor: Genuine intel CPU T2300 @ 1.66 GHz ×2, OS Type: 32 bit, Disk: 78.1 GB,
I installed on it Ubuntu 12.04 LTS and I noticed that the overall system is very slow in responding. I tried to search about that in the internet and I found some articles talking about how to make Ubuntu 12.04 LTS run fast I applied all what they said including download LXDE desktop environment and then nothing different in the system response time.
Then I need to develop some android applications so, I download Android Studio (Beta) 0.8.6. The problem became worse than before whenever I tried to open the Android Studio the screen is frozen for some minutes then it took time to download the projects and initialize the work space also, when I tried to move the cursor he is move very slowly. When I tried to run my first application on the AVD it took three hours and still not run yet.
I delete the Android Studio and install it again several times, I was trying to solve the problem but still nothing change.
We've had an issue where some of our Plesk installation was trashed. It's on a server which runs multiple live sites.
Most of the psa package no longer exists.
Is there a way to re-install Plesk without making it "think" that it's a new installation, thereby preserving all data?
Would apt-get install -f psa do it?
I had a HDD crash recently on my Root Server. Replaced HDDs, installed Ubuntu 12.04 LTS, since Ubuntu 14.04 LTS is not supported by Plesk yet. Anyway...
I had 2 issues:
1) Could not create Customers, because IP Pool was empty. Changed IP Type from Dedicated to Shared. Fixed issue.
2) Cannot connect to the FTP Server using the Login Data from one of my Domains.
FlashFXP and FileZilla both show the same error, which is:
Code:
Response:220 ProFTPD 1.3.4c Server (ProFTPD) [*ip removed*]
Command:USER *user removed*
Response:331 Password required for *user removed*
Command:PASS **************
Response:530 Login incorrect.
Error:Critical error
Error:Could not connect to server
on a fresh installation of Ubuntu (at first 14.04 but on 12.04 the same problem occurs) I installed Plesk via the autoinstaller. It seems to be all fine except I cannot open Plesk in the browser.
The web browser shows "502 Bad Gateway", a look into the error_log at "/var/log/plesk/sw-cp-server" shows the following error:
Code:
2014/08/11 09:37:22 [crit] 4988#0: *4 connect() to unix:/var/run/sw-engine.sock failed (2: No such file or directory) while connecting to upstream, client: xxx.xxx.xxx.xxx, server: , request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "xxx.xxx.xxx.xxx:8443"
So the problem seems to be the sw-engine service that cannot be started.
If I try to start it manually with `/etc/init.d/sw-engine start` it just fails:
Code:
* Starting Plesk engine pool manager sw-engine-fpm [fail]
Where to find any startup error log for sw-engine, where I could find any further information.
I used the search function. Im USING UBUNTU NOT CENTOS!
I set up an virtual ubuntu Server on a Proxmox Root. I used the .iso from plesk.
Now when i tried to start installing magento, there is the message, that there is no mcrypt installed.
I installed it using php5-mcrypt its done and i can see the folders and also te mcrypt.so and so on.
When i tried to install atomic there is the message that redhead is not available at /etc/readhead...
We are unable to change the view to service provider in plesk12. Only power panel seems to show up.
Tried to do a bootstrap repair but that hasn't fixed it.
I am trying to create a database using the following method:./mysqladmin create db
But I get the following error:./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
I am new to configuring mysql. I have installed it etc but not sure how to start it. I tried the following to start the server:moe@moe-desktop:/usr/local/mysql$ sudo bin/mysqld_safe --user=mysql
I'm interested in having an unmanaged VPS with Ubuntu 7.1 or 8.04 installed (or available to Rebuild under the HyperVM) from the state of Missouri (should have at least some IPs already available from the region).
View 2 Replies View Relatedemail configuring problem.
I have a complete 512mb vps on slicehost.com All configuring went well.
But for some reason I can't get my email-server to work. I have followed all tutorials on articles.slicehost.com/email Also I have installed atmail(.org) on my subdomain for email.
I always get the error the password isn't correct. Also when I try with Outlook.
The password is encrypted.
I understand an email setup is a complicated thing, and you probably need more information. But do you guys have any suggestions on what it might be? I'm a newbie, so it surely can be a newbie issue.
way to create a VPN tunnel between two ubuntu servers?
Both will be in seperate datacentres but I'd like a secure tunnel so I can setup jobs to backup to one another.
This has to be done on the server level and cannot be done at the router/firewall as I do not have access to this kit.
Have been trying to get BFD and APF Antidos (not at same time) to work on Ubuntu 5.10 / Plesk and 6.06 (No Plesk yet) servers. APF appears to work fine after checking /sbin/iptables -L -n
Both cronjobs run but getting a lot of brute force attacks to ssh and Plesk but no offending IP's are being blocked and no e-mails reporting that they are being blocked. Log files for BFD and Antidos are always "0". Everything setup and configured the same as on my previous CentOS servers.
Can't find much on the net with this newer OS. Can anyone point me in the right direction to get one of these to work on the systems above? Thought it might be a path error referencing rc.d but put a symlink in for that and no change.
I just have started to setup a web-environment using Plesk 12 on Ubuntu 14.04LTS.
I have the following problem:
I have setup a service-plan that enables Apache ASP. When I try to create a webhosting using this service-plan I run into a message saying that the service-plan tries to ENABLE ASPs, but the available setting is DISABLED (only option) and the webhosting will be setup with ASP DISABLED (and the webhosting will be out of sync with the service-plan).
Trying to figure out the reason for this behaviour I checked the site_isolation_settings.ini (in /usr/local/psa/admin/conf/). In this file asp is set to on (no comment sign on start of the line).
Then I looked for the custom view settings for the power user view (which I am currently not using - I use the service provider view): In the hosting parameters ASP is ticked.
After that I checked the installed (and installable) features of Plesk; especially the Web-Hosting-Features. Surprisingly I noticed there is no option to install Apache ASP support!!!
Remark: I installed Ubuntu 14.04LTS Server in minimal configuration (SSH-Server configuration) directly after that I started the Plesk installation...(might this be the reason?)
How can I make Apache ASP work?
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.
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?
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?
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'?
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]....
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??
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 RelatedI 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 RelatedDid 12.0.18 comes with default maria DB instead of mysql ??
View 2 Replies View RelatedWe 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?
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 RelatedAfter 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.
I am using Parallels panel 11.5.30 Update #44 on CentOS 6.5 (64bit version) located on VPS. What is the easiest way to update:
- PHP 5.3.3 to PHP 5.5.12 (current stable version) and
- MySQL 5.1.73 to MySQL 5.6.18 (current stable version).
Is it possible to update these from Plesk's control panel?