Upgrading Php & MySQL On A Plesk Win2K3 Server
Jul 14, 2008
I 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.
View 2 Replies
ADVERTISEMENT
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
May 4, 2008
After 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.
View 7 Replies
View Related
Apr 22, 2007
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.
View 4 Replies
View Related
Apr 10, 2007
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 Related
Feb 3, 2008
I'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
View 14 Replies
View Related
May 7, 2008
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?
View 3 Replies
View Related
Jun 19, 2008
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?
View 7 Replies
View Related
Jun 14, 2007
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?
View 3 Replies
View Related
Aug 3, 2007
i have about 8 different domains i'd like to point to a nameserver (ns1./ns2.mydomain.com) on Win2k3 server, but i can't get them resolved through my nameserver without creating a manual forward lookup entry for each *parked* domain separatly..
Does anyone know how to resolve "parked" domains automatically on Win2k3 DNS??
I just can't find any answer for this, everything i've found required manual creation of lookup entries..
anyone?
View 8 Replies
View Related
Apr 7, 2007
I'm running Apache 2.2 on Win2k3, and my domains resolve fine.. but i'm not satisfied with the whole process hosting a new domain:
Quote:
DNS
-> New Zone
-> next
-> next
-> writing domain name
-> A-record
-> typing in my IP
-> Ok
Apache
-> httpd.conf
-> copy paste, change domain, folder
-> restart apache
how to make DNS-assignment easier? I just want all my domains
pointing to
/htdocs/{{domainname here}}
View 3 Replies
View Related
Mar 19, 2007
Our IT guy at our company is on vacation in HK and now im the temp..
AND iv brought down our website.. its cold fusion.
I was trying to add pictures to it in the windows enviroment when I would get access denyed when adding a picture (or any file) to the folder, so I right clicked that folder when I was logged in as an ADMIN, and added myself to access that folder, IN DOING SO, i think a few users were removed.. dont know how, down know why,
Now, when i access the website i get:
Code:
The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.
The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request
File not found: /booking/gallery.cfm
Resources:
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
Remote Address 207.194.0.129
Referrer [url]
Date/Time 19-Mar-07 10:01 AM
What the hell have I done, im ripping my hair out trying to figure this one out, What user am I missing? or is it soething else?
I have Administrator,
Creator Owner
System and
Users (with read only access),
everything else has full controll..
PLEASE give me something to go on befor somone notices i Killed the site,
View 1 Replies
View Related
Jan 24, 2007
HI have an urgent need to get this server up. I am trying to install 2x147gb U320 drives on a Tyan S5372 board with the Adaptec AIC-7901x SCSI controller module. I have setup RAID 1 so far and updated the Bios to latest version as well. For some reason when I specify the additional device drivers for the adaptec card for scsi win2k3 still doesn't recognize the drives.
I don't know what to do now and time is running out. I have tried over and over again with different disks thinking it could be a bad disk however that is not the case. I hooked up a sata drive to this server and win2k3 installed fine.
View 2 Replies
View Related
Feb 25, 2008
Anyone know of a good tutorial for upgrading php on a linux plesk 8.3.0?
View 4 Replies
View Related
May 5, 2008
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
View 2 Replies
View Related
Mar 25, 2007
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?
View 1 Replies
View Related
Sep 1, 2014
My 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)?
View 3 Replies
View Related
Sep 12, 2009
trying to get my Win2k3 Standard R2 server to work.
Problem:
I did some Windows update around 3am this morning but during the update process. I lost Remote desktop connection as my machine is do several attempts to connect with the remote server. I cancel the attempt after several try. I figure i can remote desktop back in again if i wait for a bit but I couldn't re-establish the connection with my remote server. So, I drove to the Datacenter to check it out and it turn out the machine have rebooted and I'm stuck with "NTDetect failed" error message. After some googling, I was trying to fix this error by copying NTLDR and NTDetect.COM into C: but when i tried to use the Win2k3 CD to go into Windows Setup and repair. I got an error message telling me that "Setup did not find any hard disk drives installed in your computer...".
After some googling, I found the two Maxtor SATA hard disks might be the problem and one soultion that i found was to disable the SATA or set it to IDE since the motherboard have nvida RAID controller onboard. I check the BIOS and the RAID is set to disabled and then i tried to disable SATA and only enable IDE. It still give me the same error message about not able to find any hard disk.
I'm on my last rope here. I'm short of reformatting the hard disk and do a fresh reinstall but I will like to avoid this.
Does anyone know if cancel Remote desktop connection attempt during Windows update process cause this NTdetect failed problem or something else that might related to my hardware. I can assure you that two SATA hard disks shown on BIOS.
The soultion to NTDecte failed problem seem to be just copying NTLDR and NTdectect.com into C: but since i can't even get to Repair mode during Windows setup with no disk install error. Can someone recommand how to solve this problem?
The motherboard that i use is ASUS M2N-MX SE AM2 NVIDIA GeForce6100 / nForce430 and the BIOS is American Megatrends Inc.
View 1 Replies
View Related
Dec 1, 2007
I just ran a simple yum update php on the server, because I need to be running 5.2 instead of 5.1.6
The update went smoothly, so I restarted httpd, and all hell broke loose. Apache can't start because of a whole lot of missing modules. So I commented out every single LoadModule line to see if that would get it to start, and it started complaining about the configuration file of some other software being incorrect (because that configuration file pointed to some module that no longer exists)
At one point I was able to get apache to start, I believe by copying my old configuration file to httpd.conf and then commenting out some lines that it was complaining about. Apache started, but no pages were loading.
So right now, basically, I've got no web service running at all on the server. I really didn't expect all of these problems for a simple PHP update, but obviously I was mistaken.
Is it worth trying to fix this myself (intermediate linux user here) or would it just be easier to hire someone to come in and do it for me?
View 4 Replies
View Related
Oct 12, 2014
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.
View 5 Replies
View Related
Aug 3, 2013
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
View 6 Replies
View Related
Aug 13, 2014
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"
View 9 Replies
View Related
Apr 2, 2015
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...
View 4 Replies
View Related
Jan 12, 2015
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?
View 3 Replies
View Related
Jul 14, 2012
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?
View 19 Replies
View Related
Jan 13, 2015
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
View 2 Replies
View Related
Aug 11, 2014
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
View 3 Replies
View Related
Jul 1, 2014
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
View 2 Replies
View Related
Dec 8, 2008
Site is currently running on a single code single cpu p4 server. Am thinking of upgrading to a quad core Xeon server.
My site is pretty dynamic with lots of hits to php / mysql, and has trouble keeping up with the requests sometimes. Would a quadcore Xeon significantly help?
Server Software:
Windows 2003 Server
php 5.2.6
apache 2
mysql 4.1
Current Setup:
P4 2.8 single core/cpu.
Proposed setup
Xeon 3210 quadcore
I guess my confusion lies in the following:
1. Can win2003 server make use of the quadcores?
2. Does php / apache / mysql make use of the quadcores?
3. Will i see a significant increase in the amount of pages i can serve?
View 5 Replies
View Related
