Upgrading CPanel's MySQL

Upgrading Mysql From 4 To 5

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

Upgrading Mysql

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

Upgrading Mysql From 4.1 To 5.0

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

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 View Related

Impact Of Upgrading PHP And MySQL Versions

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

Upgrading The Php Client API Version To MySQL

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

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 View Related

Plesk 12.x / Linux :: Upgrading Form Mysql 5.1.73 To 5.7

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

Lighthttpd On What Cpanels?

Apr 15, 2009

I want to know lighthttpd works on what different kind of control panels

I am aware it works on lxAdmin, I want to maximize the options for more control panels which would be flawless

View 1 Replies View Related

Running A Site With On Db From Two Cpanels

Apr 16, 2009

I am having a site developed that will have a "front end" - ie the actual website with a login members area etc. The "back end" will be a set of scripts that work behind the scenes, including a bot that visits other sites and passes info to those sites.

The concern I have is, if I put the whole lot on one Cpanel, and then it gets whacked by a surge of traffic etc, the "back end" will crash as well.

My question is, would it be better to host the site itself on one cpanel account, but store the Db and the back end scripts on another cpanel, both on the same server. Then even if the site cpanel maxes out or crashes, the processes will continue to run? The site itself would also need to access the Db stored on the second cpanel.

View 2 Replies View Related

Want To Setup SSL For IMAP Email And Their Cpanels

Feb 8, 2008

I have a couple questions maybe some of you can help me with -

I have a dedicated server and many hosted customers, I want to setup SSL for IMAP email and their cpanels.

Instead of purchasing individual SSL certificates for each domain. I was thinking to just use my hostanme (eg host.myhostname.net) and direct them to that as I have seen the option in WHM.

My question is can I use an SSL cert for email that will act as a "fleetwide" SSL cert?

For example instead of using mail.theirdomain.com could I just use mail.myhostname.com and would it give them SSL without warnings? Of course they would set their email client to mail.myhostname.com..

Is it safe or recommend to use your hostname? I read somewhere to never use your hostname as a domain.. so not sure.

View 1 Replies View Related

Migration From Cpanel Add On Domains To Own WHM And Cpanels With Individual Accounts

Mar 29, 2008

I have a dedicated server, and I need to migrate a client who has with me an account with Cpanel and add on domains, and now is upgrading his account to one of my resellers accounts plans.

It has now assigned 2 dns:
ns1.maindomain.com.mx IP--> xxx.xx.x.65
ns2.maindomain.com.mx IP--> xxx.xx.x.66

and he does not want to use this dns's anymore, so, he registered a new domain otherdomain.com to have new dns's
I already create the dns zones for that domain and assigned 2 more IP's:
ns1.otherdomain.com --> xxx.xx.xx.17
ns2.otherdomain.com --> xxx.xx.xx.18
(both different from the first ones)

The problem I have is how to separate accounts from the Cpanel add on domains and assigned them individually to a WHM, for my client to create packages and manage his own reseller accounts, without loosing any information at all.

I know that he already has a WHM with the maindomain.com.mx as his main account, but when he signs in to the actual WHM, he see just one account maindomain.com.mx

So, can you tell me how to migrate all the Cpanel add on domains to the new otherdomain.com reseller account (is already created also) with its own Cpanel each one of the 15 domains he has.

Details of my dedicated server:

WHM 11.15.0 cPanel 11.18.3-R21703
CENTOS Enterprise 5 i686 on standard - WHM X v3.1.0
Apache 2.0.63
PHP Version: 5.2.5

View 1 Replies View Related

What's An Alternative To Using CPanels Backup Wizard To Stop High Server Usage

Mar 14, 2008

What is an alternative to help reduce the massive amounts of cpu resources a CPanel Backup Wizard causes when doing generating a full backup?

View 9 Replies View Related

Upgrading To .NET 3.5

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

Upgrading Php From 5.0.4 To 5.1.4

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

Upgrading PHP On A VPS

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

Upgrading PHP

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

What Happens To You/someone Else When Upgrading

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

Upgrading PHP

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

Upgrading Gcc On Mac OS X

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

Upgrading To A VPS

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

Upgrading From Dual 285's

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

Upgrading Apache ..

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

Upgrading Centos 5.1 To 5.2

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

Upgrading Servers - PHP 4 -> 5

Jan 19, 2008

How many people have upgraded existing servers from PHP4 to PHP5?

Or are you not bothering at all?

We tried it on one server and 90% of PHP scripts stopped working! Some needed only minor changes; many needed more serious changes.

View 6 Replies View Related

Upgrading PhpMyAdmin

May 27, 2007

Has anyone seen any docs on upgrading phpMyAdmin? And does it need to be done via SSH?

I'm on a MediaTemple (gs)...

View 1 Replies View Related

Upgrading My VPS To CPanel 11

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?