CentOS 5 :: Update PHP To 5.3.8 But Stay On MySQL 5.1?
Aug 31, 2011
I wish to update a CentOS 5.6 system to PHP 5.3.8, but keep the MySQL version at 5.1.
I am using these repos (in addition to the stock CentOS repos):
epel
rpmforge
remi
At present, the system has php-5.3.5-1.el5.remi.1 and mysql-5.1.53-1.el5.remi.
When I attempt to 'yum update php' it automatically wants to update mysql to v5.5. If I explicitly exclude mysql either on the yum command line or in the remi repo config file, it produces depsolving errors.
Where may I find a set of PHP 5.3.8 RPMs which are NOT dependency bound to an upgrade of MySQL from v5.1?
After updating and installing Mysql's TOP, yum broke. When trying to clean, update, or install, the following error occurs:
dingle@its:/home/dingle# yum update There was a problem importing one of the Python modules required to run yum. The error leading to this problem was: No module named cElementTree Please install a package which provides this module, or verify that the module is installed correctly. It's possible that the above module doesn't match the current version of Python, which is: 2.4.3 (#1, Sep 3 2009, 15:37:12) [GCC 4.1.2 20080704 (Red Hat 4.1.2-46)] If you cannot solve this problem yourself, please go to the yum faq at: [URL]
I tried to resolve by reinstalling the dependency, didn't work either: dingle@its:/home/dingle# rpm - [URL] Retrieving [URL] Preparing... ########################################### [100%] package python-elementtree-1.2.6-7.el4.rf.i386 (which is newer than python-elementtree-1.2.6-5.i386) is already installed
How can I rebuild YUM appropriately so it will operate correctly?
I want to upgrade existing MySQL 5.0.77 version on CentOS 5 Red Hat Linux to MySQL 5.1.x. Is anybody have list of patches or upgrades to upgrade to MySQL 5.1.x?
I can't get mysql to update from lenny (mysql-5.0) to squeeze (5.1). apt tries to start the server but comes up with some kind of configuration script error.
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems -- > mysql conflicts with mysql-server-community error: mysql conflicts with mysql-server-community
I just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -
[mysqld] datadir=/var/lib/mysql socket = /var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package).
and I can not seem to find a php-mysql that works with MySQL 5.1
I followed the below thread and added the CentOS-Testing.repo and did a yum update php and it updated 30 packages, but when I try to install php-mysql I get :
[URL]
yum install php-mysql Setting up Install Process Parsing package install arguments Resolving Dependencies
[Code].....
Where can I find a php-mysql that works with MySQL 5.1? I checked the mysql website and can not seem to find any matches.
This is my first post, I hope I'm the the right place. I installed mysql mysql-server php-mysql perl-DBD-mysql libdbi-dbd-mysql via "yum install -y" on a server running CentOS 5.3 X86_64 The install completes successful with no errors, but once I start mysqld via "chkconfig --level 35 mysqld on" ; "service mysqld start" There are no errors in /var/log/mysqld.log netstat shows mysqld listening on 3306 and localhost is in /etc/hosts
I have two Centos 5 servers one running Asterisk with PHP installed and another sever running as a MySql Database server, at the moment when I try run simple script to see if I can connect to the remote server I get the following error.Quote:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code: the-matrix:~ # mysql start ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or Code: the-matrix:~ # rcmysql start Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[ [root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp [root@localhost ~]# /etc/init.d/mysqld start Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
I'm running OpenSuse 11.3 which comes with MySQL Workbench V 5.12.16-8.2. This version hangs on connections and has several other behavior problems that others have reported. For several reasons, I need 5.2+ . As a relatively new regular user of OpenSuse, I've learned that it's much better for me if I work within the package environment (read: I've made mistakes and am willing to learn) so I'm reluctant to try to just load the Suse rpm off the MySQL.org site. So:is there a more recent release of Workbench in a repository I've not found yet? if not, what's the safest way to install this as an rpm that will not impact the rest of the package management system?
i need to update my mysql database from 5.0 for 5.1, i have several java application and php application running on that server, without disturbing the setup i need to upgrade the server can someone suggest a method of doing this
I cant start mysql of my server after the update. my operating system is centos. I get this error. MySQL Daemon failed to start. Starting MySQL: [FAILED]
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
I just ran some system updates today. MySQL was among them. after rebooting. I got a message I haven't seen since I was first installing several months ago. I couldn't connect to the database.
At first, I freaked out because I didn't know what to do. I tried checking my passwords, but I still don't understand all the configuration for MySQL. I tried reconfiguring the myth packages, but couldn't get through the setup. It would just bounce me out after a few attempts because of incorrect password sets.
I finally figured out, from the logs, that MySQL hadn't logged anything since it's 'successful shutdown' after the updates. It hadn't even tried to come on. I started it manually and everything seems to be fine, but how do I get it to start at startup again?
I'm having problems with my coding. Here is the problem: I have a database with a list of products. I can list all the products OK At the side of each product I have an EDIT and DELETE button. The delete button works fine and deletes the item. The EDIT button displays a form with all the details from the database. I can then edit this form and click on UPDATE. This is the code that I have to update the database:
I cannot see anything wrong with this code. But when I click on UPDATE (in the form), I get Error in executing UPDATE exhausts SET group = 'Alloy Silencers', description = 'RS 125 Aprilia', quantity = '1', price = '57.00', type = 'alloy', type2 = 'all', order = '', status = '1' WHERE id = '3' query
error:1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group = 'Alloy Silencers', description = 'RS 125 Aprilia', quantity = '1', price' at line 1I have used this code many time before in other projects without problems.
Code: The following packages will be upgraded: apache2 apache2-doc apache2-mpm-prefork apache2-utils apache2.2-common libcupsys2 libmysqlclient15-dev linux-libc-dev mysql-server mysql-server-5.0 php5-imap sudo 12 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 5 not fully installed or removed.
I'am using ubuntu lucid, after today's system updates, mysql stop working at all. Log file at /var/log/mysql/error.log does not say anything about today, and whe I try to start it the terminal hang also in verbose mode.
I have a csv file that has a upc code and a qty (inventory). I need to insert it into my mysql table, but the table has several columns including upc, qty, price, etc. point me in the right direction to getting this done? Hopefully I can have a handy script when I'm done and all I do is run that script. I just want to make sure we don't delete the description, price, etc stuff and only update qty, using the upc code as the identifier so that the right qty get's input into the table.
I'd like to use a perl script to update a fields in mysql database when pianobar (command line pandora radio player) starts a new song. Pianobar has the ability to run a script based on events, I'd like to take advantage of and use perl toparse the artist,song,album and update the corresponding fields. Then later retrieve them and display them with php/html. I am by no means proficient with perl. I started to use bash, but it looks like perl will be much more efficient and and less time consuming.
On two Centos5 servers, yum gives a segmentation fault error when trying 'yum update' or 'yum check-update' after running 'yum clean' :
[Code]....
The error is the same for the other computer except while attempting to update the rpmforge repository. Nothing has really changed on the servers in some time and 'yum update' worked fine on each yesterday and I have no idea why they would both suddenly fail!
I have mysql installed successfully. I can insert rows into my table using phpMyAdmin. I can successful retrieve those rows in PHP with a select statement. However, I cannot insert or update rows from PHP. I get no error messages and everything appears to be working okay, just no results in mysql table.
For some reason, when I do a yum check-update I get a list of no changed packages to install. If I follow this immediately with a yum update then it tries to install drbd83. I've tried a yum clean all and repeated the commands and get the same thing. This happens on both the machines that are set up to use DRBD. Just seems weird and I don't understand. Anyone got an explanation?
I have a error when i want to update my system via YUMI execute the next command.sh@ yum -y updateYou could try using --skip-broken to work around the problemYou could try running:package-cleanup --problems package-cleanup --dupes rpm -Va --nofiles --nodigestThe program package-cleanup is found in the yum-utils package.
Does anyone know where we can get the rpms (x86_64) for MySQL v4.0.26 or 27?
We are in the process of upgrading a very old server to CentOS 5 and need to retain this version. We still have a lot of clients that utilize this version.