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,
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 RelatedSince 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.
I am planning on upgrading to php 5. I really don't need to upgrade to mysql 5 but do you guys think I will face problems with PHP 5.2.9 and Mysql 4.1.20 working together...
I am planning on doing the upgrade like this (if I decide to upgrade PHP and MYSQL all together)
1. STEP
nano /etc/yum.repos.d/CentOS-Base.repo
2. STEP
change the enabled=0 to 1 as follows
[centosplus]
name=CentOS-$releasever - Plus
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=centosplus
#baseurl=http://mirror.centos.org/centos/$releasever/centosplus/$basearch/
gpgcheck=1
enabled=1
gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-centos4
priority=2
protect=1
4.STEP
yum install php-xml
5.STEP
yum update httpd* php* mysql*
and restart the server do you guys think I will face any problems.
If I am only upgrading the php to latest I am planning on doing
1.STEP
I will do the 2.STEP above
2.STEP
wget -q -O - http://www.atomicorp.com/installers/atomic.sh |sh
yum install php-xml php-pdo
yum install php-pear
mv /etc/php.ini.rpmnew /etc/php.ini
and reboot
I am planning on upgrading to php 5. I really don't need to upgrade to mysql 5 but do you guys think I will face problems with PHP 5.2.9 and Mysql 4.1.20 working together...
I am planning on doing the upgrade like this (if I decide to upgrade PHP and MYSQL all together)
1. STEP
nano /etc/yum.repos.d/CentOS-Base.repo
2. STEP
change the enabled=0 to 1 as follows
[centosplus]
name=CentOS-$releasever - Plus
mirrorlist=[url]
release=$releasever&arch=$basearch&repo=centosplus
#baseurl=[url]
gpgcheck=1
enabled=1
gpgkey=[url]
priority=2
protect=1
4.STEP
yum install php-xml
5.STEP
yum update httpd* php* mysql*
and restart the server do you guys think I will face any problems.
If I am only upgrading the php to latest I am planning on doing
1.STEP
I will do the 2.STEP above
2.STEP
wget -q -O - [url]
yum install php-xml php-pdo
yum install php-pear
mv /etc/php.ini.rpmnew /etc/php.ini
and reboot
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.
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 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 a plesk server with me, would like to check how should I upgrade my .net framework to 4.5?
Do I need to update the framework by using the control panel or manually download and install?
The plesk is a Parallels Plesk Panel 11.x for Windows.
connected to my other question regarding hMailserver and Plesk 11.5 for Windows I still need to transfer/upgrade two other servers to Plesk 11.5 - and these two are using hMailserver. During the upgrade to Plesk 11.5.x hMailserver is kicked out and Mail Enable SE is installed (and luckily configured). The users will have their old mails stored with hMailserver and a "blank" new mailbox with Mail Enable. Somehow I need to transfer or migrate these mails from hMailserver to Mail Enable.
My solution last time was "easy but annoying": I set new passwords for all mailboxes and used IMAPcopy to copy all messages, one by one. This took like forever!There was just no other solution as I already upgraded my installation. As of now, the "Upgrade Notes" published by Parallels suggest to "upgrade by migrate". How to do this, without IMAPcopy and all this trouble? Maybe if I get a backup of the mails and restore this backup? Is there a way to only backup the mails instead of the whole configuration and stuff?
During downloading the files for the upgrade, it is hanging at downloading the following file:
plesk.msi
When I look at the C:ParallelsInstallerparallelsPANEL-WIN_11.0.9dist-msi-Microsoft-2003-i386 I see that the file is .tmp and cannot be deleted.
I do not know how to stop the upgrade, delete the .tmp file and download the files again.
Problem with FTP Users on Plesk 11 after updating from Plesk 10.
SO: Windows Server 2008 R2 Standard Edition
Panel: Plesk for Windows 11.0.4
I noticed that users cannot FTP, when trying to connect they receive an error: 530 User cannot log in, home directory inaccessible.
Doing further investigation, I confirmed that only users created after upgrade have this issue, that created before upgrade works fine.
I already discovered that home directory is missing on IIS 7.5 FTP. Creating a symbolic link on NTFS using MKLINK command pointing to home folder and configuring permissions to user solved the problem.I think its a bug on Plesk Panel 11.0.4 as I can see same the same problem on two distinct servers after upgrading from Plesk 10 to 11.
I tried to run Plesk Reconfigurator utility with all options, without success.I can fix home directory by myself manually but it will be great if Plesk Panel handle this again.
I need to upgrade from smartermail 5.5 to latest smatermail 9 . Let me know any option via plesk panel
Plesk 10.4.4 is currently installed my server. Going to upgrade plesk 11
I have Parallels Plesk Control Panel installed on Windows Server 2008 with PHP 5.2.17. In order to install moodle, it requires PHP 5.4.4 installed. How do I upgrade to the latest PHP or to version 5.4.4, are there any standard instructions?
View 4 Replies View RelatedSince I upgraded to Plesk 12, when I create a new subscription, an IUSR account is no longer created for that website so I can grant the appropriate permissions to folders, etc.
View 2 Replies View Relatedi want to uprage my plesk panel to 12. But i have this problem
"Parallels Panel pre-upgrade checking... 'wmic.exe' is not recognized as an internal or external command,
operable program or batch file.
FATAL_ERROR: Unable to get IP address"
I see that, when subscriptions is suspended, backup manager continuous working.
View 2 Replies View RelatedAfter upgrade plesk 11 to 11.5 there is a new feature in domain hosting settings which is called "Preferred domain"
We can not change the state of Preferred domain. It always remain domain.tld When we try to change it to "none" panel says "Information: The settings were successfully updated."
When we check hosting settings again Preferred domain section is domain.tld . due to that reason we r having lots of diffuculties. Lots web page down due to web.config file has redirection.
After Plesk Panel upgrade to 12.x I found a warning showing at Home>Tools & Settings> Database Servers
Warning: Unable to determine the TCP port number used by Microsoft SQL server '.SQLEXPRESS': TCP/IP protocol is not enabled in the server network configuration or the server is configured to use dynamic TCP ports.
To allow your customers to automatically configure firewall for remote database access, manually configure the SQL server to listen on a specific fixed TCP port.Click to expand...
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.
After upgrading from 11.5.30 to 12.0.18, when make backup see next message:
<?xml version="1.0" encoding="utf-8"?>
<execution-result status="error">
<object name="example.com" type="domain">
<message severity="error" id="167b9714-3e33-4863-861d-69c4f559afe6" code="InformationalException">
<description>Unable to dump IP addresses for mail service</description>
[Code] ....
I have upgrade plesk to 12 version and after upgrade all the domains that have more than 2048 MB on the server are shown as 2048 MB.
If i go on the domain statistic the tab the total disk usage is 2048.1 MB but on the graph the services disk usage are shown correctly.
I have 2 print screen.
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
I can't start MYSQL. How can i fix this?
View 3 Replies View RelatedI 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...
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.
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...
I have a number of web sites on a dedicated server. Some of these web sites are a few years old. Are there any issues upgrading from MySQL 4.1 to 5.x? Are there web sites that may have compatibility issues?
View 6 Replies View RelatedI 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 RelatedI 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.
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,
