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 RepliesI have a Win2003 dedicated server (with The Planet) that i use to host a large IPB forum site.
I got it about 3yrs ago and as I was a complete newbie to server management I got Plesk CP installed so that it would take care of all the SQL, PHP and mail installation and setup in one easy go.
I've since found Plesk for Windows to be a complete waste of space.. but it's still on there and has never been upgraded. I don't actually use it as a CP.
Similarly PHP and mySQL have never been upgraded.
Now I've got to the stage where, to upgrade the IPB forum software, I need to upgrade PHP and mySQL.. but looking at the installation, they seem to be embedded in the Plesk installation. They're inside the SWSoft/Plesk/ folders and none of the ini or config files appear to be in the places you'd expect them to be.
My question -
Would these upgrades be simple?? A case of just running an update package?? Or is the fact that PHP/mySQL are embedded in Plesk mean that it'll all mess up?
I'm worried that a failed upgrade will knacker the forum, which is why I've delayed for so long.
I'm running Plesk for Linux 11.5 and I'd like to allow autocomplete of the userid field from the Roundcube login screen, but when i make the changes to the config file, they are not applied. It looks like Plesk is overriding them.
I edited the /usr/share/psa-roundcube/config/main.inc.php file and set "$rcmail_config['login_autocomplete'] = 1;"
When I check (using Firebug) the source code of the login page, I notice that autocomplete is indeed first set to "on", but it changes to "off" nearly instantly. I suspect that some .js script (inserted by Plesk?) overrides this setting.
This behavior seems to be backed by a statement in Plesk 11.5's release notes:
"Autocompletion is turned off on the login dialog for security reasons"
Is there any way I can undo the override and still keep autocomplete="on" ?
I'm using a 1blu.de vServer. On my VPS is Plesk 11.5 with centOS 6 installed. I created my Webspace [URL] .... and removed the Mail Services and activated the MSMTP plugin because I'm using the webserver from the hoster 1blu.de.
I activated the Firewall with the "allow any connection" rule.
In Plesk Tools & Settings > External SMTP Server I filled in the server informations smtp.1blu.de password & username. I checked all three boxes -> SMTP needs auth, allow user scripts ...
I installed Wordpress 3.9.2 with a Theme that uses PHP Mail function. The contact form is not sending any messages out. So I tried other php mail scripts but it doesn't work.
[URL] ....
Code:
<html>
<head><title>PHP Mail() test</title></head>
<body>
This form will attempt to send a test email. Please enter where this test should be sent to
<br><p>
<form action = "sendmail.php" method = "post" name="sendmail">
Enter an email address: <input type = "text" name = "to"><br>
<input type="submit" value="Send" name="submit"><input type="reset" value="Reset" name="reset"><br><p>
[URL] ....
Where can I find the log file that could give me information?
I just want to use php mail for my wordpress contact form and for a project application.
Anyone know of a good tutorial for upgrading php on a linux plesk 8.3.0?
View 4 Replies View RelatedMy Plesk installation (on Debian Wheezy) has PHP5.4.4 and I need to upgrade it to 5.4.9 or above.
How can I do this (It's a self managed Plesk server)?
OS: CentOS 6.4 (Final)
After upgrading components as suggested by "Tools&Settings->Plesk->Updates and Upgrades" item, components remained the previous version (PHP 5.3.3 and MySQL 5.1.73) as stated by phpinfo() result and by "Tools&Settings->Server Management->Server Components" list, though "Update Components" is no more permitted as if there is nothing more to update.
I need both PHP and MySQL servers updated in order to run Joomla 3.3.6.
Yesterday we upgraded V.11 to V.11.5.30. And now we are not able to restore our backups anymore from our main server on our failover server by CLI (we have automated this with cronjobs and need the CLI backup/restore). We have a failover sulotion with two servers and restore the backups of our main server on our failover server!
If we try to create the map file on our failover server, we get the error:
The dump specification '/home/backups/plesk_partnerserver/dumps/backup_info_1308030132.xml' should be inside of dump directory '/home/backups/plesk/dumps'.
/home/backups/plesk_partnerserver/dumps is the path on our failoverserver where we store the backups of our main server and /home/backups/plesk/dumps ist the regular dump path of the failover server.
And if we try to restore the file without creating a map file on our failover server with /usr/local/psa/bin/pleskrestore --restore backup_info_1308030132.xml -level server: Unable to resolve all conflicts
What happend? Now after upgrading to 11.5 our backup- and failover-solutions are in big trouble!
Our OS is Debian Squeeze
PP is 11.5.30
Yesterday I've upgraded the server to Plesk 12.0.18. After the upgrade, a WHMCS install has stopped working.
The only error logs where I found errors is the proxy_error_log. It contains this kind of lines (for the 502 error):
2014/08/13 08:13:45 [error] 2918#0: *400 upstream prematurely closed connection while reading response header from upstream, client: XX.XX.XX.XX, server: XXXXXXX.COM, request: "GET /knowledgebase.php HTTP/1.1", upstream: "http://XX.XX.XX.XX:7080/knowledgebase.php", host: "xxxxxxxxx.com"
We have a plesk server running on a Ubuntu 14.04.2 LTS machine. We check the state of the mailqueue with nagios, executing the "mailq" command. After the AutoInstaller upgraded our installation from 12.0.18 update 38 to 39, we noticed, that the nagios check failed.
After investigating a little bit, it seems that we found the problem:
When I enter "mailq" in the shell, the command is executed and gives me an proper output. But when I try to execute the command with its full path "/usr/bin/mailq" nothing happens, and I have to cancel with [ctrl]+[c]. The which-command delivers exactly the same path as written above...
I am running phpbb 3.0.12 installed from Plesk. In Plesk it is showing me that there is an upgrade available to version 3.1.2-15 however when I Re-Check the version in phpbb it says that I already have the latest version 3.0.12. That's a little weird.
The problem is when I upgrade to 3.1.2-15 in Plesk, it will mess with the whole installation. The forum page will redirect in circles to /install/index.php which doesn't even exist and I can't do anything except revert to before the upgrade.
So my questions are: Why does Plesk show a version 3.1.2-15 but phpbb says the latest one is 3.0.12? How does the upgrade process from Plesk work? I expect it to automatically do everything, or why else would I want to let Plesk upgrade?
i am not sure if this is the right sub-forum to post the question.
it is that i my a forum running with php and mysql,
the version of it is 4.1 now,
i wnat to move the forum to another server,
but the mysql version of the server is 4.0,
i try to backup the .sql form phpmyadmin and import form phpmyadmin,too.
but it failed,
some article tell me that i should change some setting in the .sql file,
but i try and failed,
can anyone teach me how can i process it?
I upgraded from 10.4.4 to 11.0.9 and saw no errors in the process, everything was fine. However when I checked the sites after, all of them (including sub-domains) were showing the default domain page. All the files are still there no problem, and as a test I deleted a subdomain a recreated it and it worked fine.
I have a feeling it's something to do with IP addresses (I currently have two set up - most sites use one and about only 5 use the other) as going to the subscription and changing the IP address over to the other one then back to the original seems to make the site show up for most sites. I can't do this on all sites though - any commands to reconfigure everything and get it all back in to place?
sw-engine fails to start with the following message:
system is debian 7.0.7 with Plesk 12.0.18 I have the problem on two servers, it started after upgrading debian
/usr/bin/sw-engine: error while loading shared libraries: libruntime.so.1: cannot open shared object file: No such file or directory
I had Plesk 10 installed on my openSUSE system (was a low version, maybe 11 or less) and then decided to upgrade to 11.5. So I did distribution upgrades to openSUSE 12.3 and everything went smoothly, except for some services like mysql and php. So I used Plesk autoinstaller to fix the php error and edited an outdated line in mysql configuration and both services ran smoothly!
Then I downloaded Plesk autoinstaller and ran the autoinstaller, but was surprised by this error message:
===> Checking for previous installation ... found.
ERR (3) [panel]: Error during product key mode determination, details: Unable to connect to database: ; trace: #0 /usr/local/psa/admin/plib/functions.php(2821): isPpaKeyRequired()
#1 /usr/local/psa/admin/plib/common_func.php3(11): require_once('/usr/local/psa/...')
#2 /usr/local/psa/admin/plib/api-common/cu.php(5): require_once('/usr/local/psa/...')
#3 /usr/local/psa/admin/sbin/httpdmng(8): include_once('/usr/local/psa/...')
#4 (main)
Unable to connect to database:
- My MySQL version is: 5.5.33 openSUSE package
- I did run mysql_upgrade with my admin username and password (password from: /etc/psa/.psa.shadow) and it worked successfully and fixed all of the errors, I did so after running the auto installer first, but then ran the installer again and the problem was still there
- I can access my web page, but it still doesn't connect to MySQL either.
I believe this is a problem with MySQL, but how can I make sure or detect what exactly the problem is
After upgrading from V11 to V12 : file not found in the central Frame
After upgrading from V11 to V12 version, I enter my credentials to login and when I get the main page, I have in the main frame : "File not found". : See screenshot
Today I upgraded to Plesk 12 and during the day I got several customers that had problems with their mailbox size. According to Plesk they were exceeding the size, but they've been doing that for years. The setting that these limits don't have any real meaning is ignored after the upgrade...
View 1 Replies View RelatedAfter the vBulletin's latest version i had to upgrade my mysql server from 4 to 5
searched a little bit found out that it can be done through tweak settings ,, select 5 and click save then do the server software update link .
i did that
after that i checked one of the websites that uses vB
found this database error:
<!--
Database error in vBulletin :
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/xxx/public_html/vb/includes/class_core.php on line 274
MySQL Error :
Error Number :
Date : Sunday, May 4th 2008 @ 01:05:15 PM
Script : [url]
Referrer :
IP Address : 212.102.30.3
Username :
Classname : vB_
i went to the shell and wrote (mysql) i received this error:
[root@server tmp]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
googled alot searching for a solution but i found millions of problems with different specifications so i didn't want to mess it up more!
most of them talked about the file (/var/lib/mysql/mysql.sock) and the configurations in the file (my.cnf)
i've been through my.cnf and couldn't find anything about /var/lib/mysql/mysql.sock
my server is centOs 5 32 bit intel xeon
my php version is 5.2.5
i've reset the root password to mysql to blank again through WHM
i really hope that you can provide me with a solution ASAP as my clients are starting to warm up to beat me
if anyone of you needs to know anything else about my server just shoot and i'll be here to answer
By the way
the file mysql.sock doesn't seem to be there on the server.
I've been trying to move this one website to a VPS for a few days now. Everything was easy enough until it comes to restoring the wordpress blog. The problem is that the VPS that I'm transferring to has mysql 3.23. Since wordpress requires 4.0+ mysql I've been trying to upgrade but I keep running into problems.
The OS is centos 3.8 and I've been using RPMs to install mysql. First I uninstalled the old mysql using "rpm -qa | grep mysql" and then moving the packs. Then I find mysql 4.1.22 centos. I installed them using rpm -ivh blahblah.
After that I restart mysql and apache. When I start apache I get this error "Cannot load /etc/httpd/modules/mod_auth_mysql.so into server: libmysqlclient.so.10: cannot open shared object file: No such file or directory"
Well I commented that part from httpd.conf and was able to restart apache no problem.
The problem is after I restart apache, php is unable to connect to mysql. In other words, wordpress isn't working (got the "Your PHP installation appears to be missing the MySQL which is required for WordPress" error). Now I don't think its that line since I'm not requiring any authencation. It seems to be what comes with the old mysql 3.23
My problem is how do I get pass this error? I've even tried compiling php from source with --mysql switch and it still doesn't connect.
I've noticed that if I just installed the new mysql, wordpress actually works but obviously when apache restarts, it wouldn't work.
Could it be that apache is somehow requiring the authencation? but since I've disabled that line, I don't know why it needs that.
I'm currently running mysql 4.1 and want to upgrade to 5.0, has anyone had any issues in upgrading, this is a production box so I want to make sure that it goes smoothly.
View 10 Replies View RelatedI'm trying to upgrade to MySQL 5 from MySQL 4.1, did the change on WHM Tweak Settings and then run /scripts/mysqlup but i get this error:
the installer version: cPPkgs::MySQL 5.0.45 installer for Linux
Fetching http://httpupdate.cpanel.net/mysqlinstall/5.0.45-0/centos/5/MySQL-server-5.0.45-0.glibc23.i386.rpm (0)....@69.72.164.152......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
Preparing... ########################################### [100%]
error: install: %pre scriptlet failed (2), skipping MySQL-server-5.0.45-0.glibc23
running:
rpm -ivh MySQL-server-5.0.45-0.glibc23.i386.rpm
give error:
error: Failed dependencies:
perl(DBI) is needed by MySQL-server-5.0.45-0.glibc23.i386
i did run /scripts/perlinstaller --force Bundle::DBD::mysql too, but it doesn't fix it
I would like to start offering MySQL 5 on all my shared hosting accounts, seeing how it's an increasingly requested feature. However, by my understanding most applications still require MySQL 4 to operate (am particularly concerned with those bundled with Fantastico). I would like my current clients to be able to continue working with these older apps using MySQL 4 while allowing new clients to make use of the latest features available with MySQL 5.
I would like to get people's opinions as to what the best approach would be here. Should I upgrade directly to MySQL 5, offer both versions 4 and 5 simultaneously, or just stick to version 4 until version 5 is better supported? If I choose to install both versions in parallel, is this an easily supported option with CPanel/WHM? Will the configuration change break anything for clients already using applications with MySQL 4?
to upgrade the PHP and MySql versions our shared hosting ocmpany is offering. We are now at PHP 4.3 and MySQL 4.014 I need to bring it up to PHP and MySQL 5.xx versions.
Has anyone done this and if so what gotchas should I look for? what is the suggestes upgrade path not to affect clients using the older versions?
I can't for the life of me figure out how to upgrade the Client API version authencation method in php for MySQL.
The server had MySQL 3.23.58 before and doing a phpinfo() reflects that. The problem is even after I install a newer version of MySQL 4.1.22 (using RPMs), it still doesn't see it.
I've ran privilege table fix but I am unable to use any mysql accounts unless I use the old password method.
I can have MySQL be up and running using the old password method but I prefer that it works with the newer authentication method since things could go wrong if I do the other way.
Is there a way I can resolve this? or do I just have to stick with the old password hashing method?
I would like to Mysql 5.6 installed on Plesk 12. Is that possible? How does it work?
View 1 Replies View RelatedHow 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 have just got a virtuzzo vps it have 512 mb ram, its comes with, centos 4.4, plesk 8.2
php 4.4, apache 2.05, so i want to upgrade, to, php5, apache 2.57
I just obtained a root server which is running plesk 8.0.1. At present the server runs:
php 5.0
mysql 4
apache 2
FC2
I want to upgrade to at least php 5.2, and MySQL 5. However I'm affraid this may break Plesk? I heard MySQL 5 is only supported by Pleask 8.1 or above?
If I go ahead with this decision, is there anything I should be aware of? Can anyone advise of any procedure I should follow to make things simple and minimise conflicts such as Plesk integration etc.
Also a slightly different note I have come accross atomicrocketturtle. Can anyone explain what this is about?