php-mssql

General support questions including new installations
Post Reply
PhDJ
Posts: 20
Joined: 2010/12/24 10:26:38

php-mssql

Post by PhDJ » 2011/12/08 13:51:21

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 ?

milosb
Posts: 661
Joined: 2009/01/18 00:39:15
Location: 44 49′14″N 20 27′44″E

Re: php-mssql

Post by milosb » 2011/12/08 20:35:55

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.

PhDJ
Posts: 20
Joined: 2010/12/24 10:26:38

Re: php-mssql

Post by PhDJ » 2011/12/09 09:12:15

[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 ?

milosb
Posts: 661
Joined: 2009/01/18 00:39:15
Location: 44 49′14″N 20 27′44″E

Re: php-mssql

Post by milosb » 2011/12/10 16:09:36

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...

PhDJ
Posts: 20
Joined: 2010/12/24 10:26:38

Re: php-mssql

Post by PhDJ » 2011/12/12 08:12:31

[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.

pschaff
Retired Moderator
Posts: 18276
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America
Contact:

php-mssql

Post by pschaff » 2011/12/13 15:14:28

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]

milosb
Posts: 661
Joined: 2009/01/18 00:39:15
Location: 44 49′14″N 20 27′44″E

Re: php-mssql

Post by milosb » 2011/12/13 20:48:53

[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:

pschaff
Retired Moderator
Posts: 18276
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America
Contact:

Re: php-mssql

Post by pschaff » 2011/12/13 20:55:22

[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. :-)

Post Reply