Page 1 of 1

php-mssql

Posted: 2011/12/08 13:51:21
by PhDJ
I am having trouble installing php-mssql on my new CentOS server version 5.7

On my other servers ( version 5.4 ) I was able to just do : yum install php-mssql and that worked fine.

Now I find this is giving problems :

[code]Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.ate.info * extras: mirror.ate.info
* updates: mirror.ate.info
Setting up Install Process
Resolving ependencies
--> Running transaction check
---> Package php-mssql.i386 0:5.1.6-15.el5.centos.1 set to be updated
--> Processing Dependency: php-api = 20041225 for package: php-mssql
--> Processing Dependency: php >= 5.1.6 for package: php-mssql
--> Processing Dependency: libsybdb.so.5 for package: php-mssql
--> Running transaction check
---> Package freetds.i386 0:0.64-11.el5.centos set to be updated
---> Package php.i386 0:5.1.6-27.el5_5.3 set to be updated
--> Processing Dependency: php-cli = 5.1.6-27.el5_5.3 for package: php
---> Package php-common.i386 0:5.1.6-27.el5_5.3 set to be updated
--> Running transaction check
---> Package php-cli.i386 0:5.1.6-27.el5_5.3 set to be updated
--> Processing Conflict: php53-common conflicts php-common
--> Finished Dependency Resolution php53-common-5.3.3-1.el5_7.3.i386 from installed has depsolving problems
--> php53-common conflicts with php-common
You could try using --skip-broken to work around the problem
You could try running: package-cleanup --problems
package-cleanup --dupes
rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.[/code]

I had php53 on the other servers too.

Doing yum install php53-mssql does not work ( it did for php53-odbc )

What am I doing wrong ?

Re: php-mssql

Posted: 2011/12/08 20:35:55
by milosb
The package you're trying to install conflicts with the existing php53 installation. On the other hand, although CentOS-Base doesn't have [b]php53-mssql[/b], some [url=http://wiki.centos.org/AdditionalResources/Repositories]3rd party repositories[/url], such as EPEL, Remi and IUS do.

Now, the desired package from Remi or IUS most likely won't install along with CentOS 5 provided php53 - and you'll have to opt for PHP 5.3 from only one of those two repos. However, you can also try installing just [b]php53-mssql[/b] just from EPEL and see how it goes.

In addition, when configuring 3rd party repositories on your system, also make sure you configure [url=http://wiki.centos.org/PackageManagement/Yum/Priorities]Yum Priorities[/url] for installed repositories, so you don't accidentally break anything.

Re: php-mssql

Posted: 2011/12/09 09:12:15
by PhDJ
[quote]
milosb wrote:
The package you're trying to install conflicts with the existing php53 installation. On the other hand, although CentOS-Base doesn't have [b]php53-mssql[/b], some [url=http://wiki.centos.org/AdditionalResources/Repositories]3rd party repositories[/url], such as EPEL, Remi and IUS do.

Now, the desired package from Remi or IUS most likely won't install along with CentOS 5 provided php53 - and you'll have to opt for PHP 5.3 from only one of those two repos. However, you can also try installing just [b]php53-mssql[/b] just from EPEL and see how it goes.

In addition, when configuring 3rd party repositories on your system, also make sure you configure [url=http://wiki.centos.org/PackageManagement/Yum/Priorities]Yum Priorities[/url] for installed repositories, so you don't accidentally break anything.[/quote]

Thanks for the help Milos, could you help me how to install that from another repository ?

Re: php-mssql

Posted: 2011/12/10 16:09:36
by milosb
Performing the installation of those packages is simple as it is with the links I provided in my previous post... All you have to do is read those two links provided...

Re: php-mssql

Posted: 2011/12/12 08:12:31
by PhDJ
[quote]
milosb wrote:
Performing the installation of those packages is simple as it is with the links I provided in my previous post... All you have to do is read those two links provided...[/quote]

The links do not help me in any way.

Anyone else who can help me with this ?

What I do not get is that I did the same thing I did on our CentOS 5.4 servers, but they are probably set-up differently and that was not done by us.

Can I pull the config of where yum is getting the packages on our current 5.4 servers so I can configure our new 5.7 server in the same way ?

Sorry about my limited Linux and CentOS knowledge.

php-mssql

Posted: 2011/12/13 15:14:28
by pschaff
The 5.4 repo configuration will not help. You should not be running 5.4 in the first place as it is obsolete, insecure, buggy, and consequently unsupported. See the [url=http://wiki.centos.org/Manuals/ReleaseNotes/CentOS5.6]CentOS 5.6 Release Notes[/url] Section 4 for details on the recommended update procedure, and [url=http://wiki.centos.org/Manuals/ReleaseNotes/CentOS5.7]CentOS 5.7 Release Notes[/url] for other information. By not updating you are implicitly accepting that you will live with numerous bugs and security issues (and associated known exploits) that have subsequently been fixed.

The php53 packages only showed up with CentOS-5.6 so they would not have been in 5.4 anyway. If you want to try the EPEL package then download and install [url=http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noarch.rpm]epel-release-5-4.noarch.rpm[/url] as documented on the [url=http://wiki.centos.org/AdditionalResources/Repositories#line-60]repositories page[/url] previously recommended.

If more help is needed then please [url=http://www.centos.org/modules/newbb/viewtopic.php?topic_id=28723&forum=54]provide more information about your system[/url] by running "./getinfo.sh [b]package[/b]" and showing us the output file, along with the results of[code]rpm -qa php\* mysql\*[/code]

Re: php-mssql

Posted: 2011/12/13 20:48:53
by milosb
[quote]
pschaff wrote:
The 5.4 repo configuration will not help.

The php53 packages only showed up with CentOS-5.6 so they would not have been in 5.4 anyway.[/quote]
Wow, I definitely missed the part about CentOS minor version (5.4)... :oops:

Re: php-mssql

Posted: 2011/12/13 20:55:22
by pschaff
[quote]
milosb wrote:
...
Wow, I definitely missed the part about CentOS minor version (5.4)... :oops:[/quote]
That's why it's so nice to have a solid team playing with you. :-)