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'm desperately trying to find a hosting service that offers Linux hosting with latest versions of php (5.2.x), mySQL (5.1) and maybe CVS or SVN?
Space or bandwidth are not an issue (500mb space will be more than I'll ever need)
This will mainly will be a development/testing place.
I really need a host that actually updates to latest versions of php/mysql/apache.
(not the next day the upgrade is out but some time soon at least >_<)
Things like CVS / SVN, SSH access and access to change your own php.ini settings are more than welcome but I could live without.
I've a small reseller account with cPanel with 5 sites. After transfering to other host (full cPanel backup of old sites, restoring on new host) cPanel of 2 sites still displays the version number of the old host, the other 3 sites are correct.
CP1: correct - CP2: wrong
Are there particular version of mysql or apache that are best suited when you want to utilize a multi-core/multi-cpu system? For example, we are currently using apache 1.3 and am not sure if it has the inherent ability to use multiple cpus to its benefit.
Or would the fact that it spawns child processes take advantage as the processes will be spawned on the different CPUs?
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.
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?
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 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 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 Relatedso spammers arbitrarily send spam to coomon names on my server... that's nothing new.
But I was just wondering what happens when a spammers sends spam to email addresses that don't exist... does it just go to /dev/null immediately or just bounce back with no real buildup on the server (ie log, record, temp placement) or should I be concerned with a high volume of spam.
Want to order a VPS. Not sure whether to include the option of Fantastico/Xcontroller which can be installed along the cPanel. My question is will Fantastico/Xcontroller option by itself use up some of my valuable RAM and if yes how much?
View 3 Replies View RelatedI've read that all ethernet switches in a MST Region need the same Name, Revision number, and list of member vlans for each Instance. So what happens when you need to change the range of VLANs in a MSTI ? Let's say that you need to add a range of vlans to an instance that spans 20 switches? How would you do that?
View 1 Replies View RelatedOn a webserver (apache, mysql, php), which values comes to your mind can have bigges impact on a website load time?
we talking about webserver which host like 100 websites, mostly a classic wordpress blog.
I have keep alive turned on. Now i want to do some test playing with various values of apache, php...
Windows 2003
IIS6
PHP 5.0.3 and PHP 5.2.1 running with the ISAPI dll
MySQL 5.1.11
I kind of have 2 problems, the first being the one in the thread title and the second is while running any version of php my main site experiences slowdowns and hangs.
For some reason whenever I try to install a new version of PHP I have major problems. I have tried several times when new versions come out. I just recently tried the newest, 5.2.1, which I want to try and use, I think there are performance improvements for IIS and windows platform in the new 5.x versions?
Anyway I can install 5.2.1 and get it running, and my sites load, but soon after my main site starts to hang, stops loading or loads extremely slow. I can't figure it out. I even tried using the exact same PHP.ini settings from my old working php install.
So everytime I am forced to go back to the latest version that I know works with my server/sites, 5.0.3 [url]
If I restart IIS the pages start loading fast again right after, even recycling the worker process that the site uses usualy makes the pages load normal again.
I tried setting the worker process to recycle every 60min and to use 2 web gardens. These changes havn't really had any affect for better or worse.
Downgrading back to PHP 5.0.3 seems to run a bit more stable, but even with this version I get these slowdowns now. I have been running my site(s) on this server for 3 years now and most of the time they have ran stable.
--------------------------------------------------------
I was sleeping this morning and recieved a text-message saying the site wasn't loading. So I wake up and the site indeed was pretty much not loading at all. I look at permon that I left running to see this: [url]
I give IIS a restart, which you can see above, then the levels go back to normal, here is a screen shot a couple minites later to what the "Current Connections" graph usualy looks like when the site loads fine. [url]
During this slowdown the CPU usage was not maxing out, was maybe averaging 60% and ram was 50%. I am getting a 2nd server soon to off-load the MySQL to it and have it dedicated for that. But i don't think that will help this current issue. Here is the system resources when the site is loading fine: [url]
I have around 40 or so other sites hosted on IIS and my main site "canadaka.net" which is purple on the top graph, is the only one that hangs or slowsdown. When this slowdown happens to this site, all the other sites on IIS, which are on a seperate worker process, continue to load fine.
I can't figure out why these slowdowns are happening.
Different problem than my earlier thread:
[url]
I freely admit this is something that is self inflicted as I made the mistake of trying to install OpenSSH from source on my own despite me knowing that OpenSSL was kinda goofy (as in I had 0.9.8g and 0.9.8i libraries all over the place).
I know that I have OpenSSL 0.9.8k installed and working. PHP and Apache are both reporting that they are using the k release. I'm good there. However cURL and proftpd are still linking to the g release libraries and for the life of me, I cannot find where these buggers are. ld.so.conf is pointed at the newer libraries in /usr/local/lib and /usr/local/ssl/lib and I re-ran ldconfig to make sure.
Is there a way to verify a version of the library/so files because this is killing me. I'm kinda like Monk (USA TV) only instead of germs, I'm freaked out by lame libraries and includes.
edit: what I *think* is happening, based on the timestamps, is that cURL and proftpd are using the libraries in the /usr/lib64 directory instead of /usr/lib. What I don't get is when I make;make install, why things are only going into /usr/lib and /usr/local/lib and not into the /usr/lib64 directory despite my ./config stating that the libraries are being built for x86_64. Is it as simple as copying things over?
I am using Plesk 10 on a Windows dedicated server.I read on Parallels website that version 11 will upgrade PHP to 5.3.Is it possible to keep PHP 5.2 together with PHP 5.3?
View 1 Replies View RelatedI tried to install an additional version of PHP followuing this guide [URL] .....
But when i launch this command (the same of the guide but I substitute "php540" with "php55") I retrive the following error:
./configure '--with-libdir=lib64' '--cache-file=../config.cache' '--prefix=/usr/local/php55-cgi' '--with-config-file-path=/usr/local/php55-cgi/etc' '--disable-debug' '--with-pic' '--disable-rpath' '--enable-fastcgi' '--with-bz2' '--with-curl' '--with-freetype-dir=/usr/local/php55-cgi' '--with-png-dir=/usr/local/php55-cgi' '--enable-
[Code]....
I know it's not specifically a plesk issue, but as I use plesk to resell webs and many users install (manually) wordpress, I thought I'll ask around.I would like to know if this can be done with a single sql select or if I would have to use a script to do this:
- track all mysql databases on my server
- find the proper table in each database (as the prefix can be customized, the start of the table name will probably never be the same in two WP installations)
- find the proper field in that table and check the WP version and administrator email
and then what I will do is send an email to those adresses advising them to update WP
I'm trying to make use of the multiple PHP versions in Plesk 12, however the newer versions are missing some packages my websites require.
When yum installing them it just tries to install to the default PHP5.3 version so says it is already installed.
As I didn't compile these php versions how can I install additional PHP packages to the supplied additional versions in Plesk?
