Upgrading To MySQL 5 On CPanel
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
ADVERTISEMENT
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 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
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
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
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
Jun 16, 2007
When I asked my hosting company to upgrade my cPanel version they replied with the following:
"This is not recommended. A lot of problems have been reported and I'm suggesting you hold on with this upgrade until cPanel Tech Support has ironed out all the bugs. Please request this again in 1-2 months.
should I upgrade now or wait?
View 14 Replies
View Related
Apr 5, 2009
Is there a correct way to do it?
View 2 Replies
View Related
Jul 10, 2008
My .NET software requires version 3.5 of the framework. But the ISAPI module is 2.0 and I'm wondering how I can upgrade it to 3.5. Windows hosting is not my field so I am a bit lost here.
Anyone have pointers? So far I've been looking for an ISAPI module but haven't found any. The 3.5 framework is installed but I don't know where the .dll file is (if there is any for IIS).
View 4 Replies
View Related
Jul 22, 2008
Is there a way to update php from 5.0.4 to 5.1.4 quickly without using yum or up2date?
Can this be done with RPM? Or where can I find instructions on doing this?
View 5 Replies
View Related
May 12, 2008
I am currently upgrading my PHP on my unmanaged VPS. From PHP4 to PHP 5. I have been following the following website tutorial at nix101.com/2007/09/22/setting-up-a-secure-and-fast-php-build-for-litespeed/ on how to do it for the litespeed server of which I have got installed.
But now I have come to the stage where it says Make, Make Install. And I keep on getting the following error messages coming up
Make: *** No targets specified and no makefile found. Stop.
Make Install: *** No rule to make target `install'. Stop.
I have got running on it Centos 4 and I have just installed Yum to see if that sorts out the problem. But it don't.
So any suggestions on how to sort out the make, and make install so that I can finish configing PHP.
View 6 Replies
View Related
Jun 8, 2008
to upgrade my server to PHP 5 from PHP 4.3.9
My server specs are;
Centos 4.2
Plesk 8.3.0
PHP 4.3.9-3.12.1.swsoft
Apache 2.0.52-28.ent.centos4.1.swsoft
MySQL 4.1.20-3.RHEL4.1.el4_6.1
I also have access to root SSH.
will "yum update php" do the trick? If so will I also keep the GD Library support?
View 0 Replies
View Related
Sep 28, 2007
this may seem like a strange question but what happens to your and other VPS accounts when someone upgrades part of their account? This doesn't make much sense so I'll give you an example...
Your VPS host has a nice big server with 8Gb of RAM. Currently there are 16 users on the server each with 512Mb RAM (for simplicity) therefore all RAM is currently used. Now, say I decide to upgrade my RAM to 1Gb, what happens? Do they move me to a new server? Do they move someone else to a new server? Is there any down time during this move? Would I be notified of this move?
This question is more out of curiosity than anything else and I know that the above example is somewhat unrealistic as most servers which were hosting VPS would probably have some spare RAM but eventually it has to run out.
View 2 Replies
View Related
Feb 17, 2007
I'm debating whether I should try upgrading php myself or if I should just pay someone to do it.
I know very little about server stuff. I'm more of an SEO guy who can write a few php scripts.
Currently we are running Plesk 7.5.4 on our server with PHP version 4.3.2. I want to install the latest version of vBulletin on the server, but it requires at least 4.3.3.
Unless there are some unforseen issues, I'd be happy to upgrade to the latest version, PHP 5.2.1.
Is this a super easy type of deal that even a server retard (myself) could handle or is it something that only an experienced server dude / chick should mess with.
If it is a good idea to pay someone, what is a fair rate?
View 0 Replies
View Related
Jun 12, 2007
Is there a guide available on how to upgrade to gcc 4.2.0 on Mac OS X 10.4.9?
View 8 Replies
View Related
Sep 1, 2007
I've traditionally used shared hosting to cover all my needs however as my sites have grown in popularity my host has suggested I should really upgrade to a VPS before he pulls the plug.
However as I've always been within a shared environment, I've absolutely no idea what sort of resources I will require. Bandwidth and disk space I can manage, but how does one work out the RAM requirements of a piece of software without prior access to a Dedicated or VP server?
Basically I need to run a Joomla install (with a forum integrated), two more standalone forums, a MediaWiki site, the Roundcube mail system and a few static websites. Can anyone point me to a resource that would allow me to work out a rough requirements estimate for that?
Luckily the host I'm considering offers an off-server Control Panel (HSPcomplete, never heard of it mind) but would I be right in thinking I'd still require a fairly sizeable machine?
View 8 Replies
View Related
Nov 27, 2008
We have 2 servers with old Dual Opteron 285's and would like preform an upgrade. I'm not sure where to start, these servers are for webhosting and load is pretty much around 3~5 during peak times.
We have the following choices:
Single Q9550 (Will it preform better than my current CPUs? Are they suitable for server use?)
Dual E5405's (Slowest Harpertown, is it worth it?)
View 2 Replies
View Related
Jan 12, 2008
I currently have a basic level VPS and was wondering if it is wise to upgrade apache from 1.3 to 2.2 and php to 5?
I am not quite sure why do I want to upgrade when everything is already running smoothly but it's just if something better exist then why not take advantage of that?
Anyone who can advise if this is going to a be a wise move? I have quite a few sites running on php so might have issues with newer version.
View 4 Replies
View Related
Jun 24, 2008
Has anyone tried it yet?
Yum update =
=============================================================================
Install 11 Package(s)
Update 285 Package(s)
Remove 2 Package(s)
Total download size: 659 M
I have done a clean install but a local upgrade hosed grub. I am hesitant
to try it remotely.
View 14 Replies
View Related
