[SOLVED] php-mssql

[lfields]

I am having trouble getting mssql_connect to work in mageia1. This is all code that worked in Mandriva, it's actually still running on my Mandriva server. I am wondering if it is because the i586 version installed and not the x86_64 version.

I am currently running Mageia1 64bit. Fully updated.
The current package installed is: php-mssql-5.3.15-1.mga1.i586


If I try to install the 64bit version I get.

Code: Select all

Sorry, the following package cannot be selected:

- php-mssql-5.3.15-1.mga1.x86_64


Any ideas? Thanks.

[tom_]

Any ideas? Thanks.

no idea, but we could clarify a bit

please show the output of both these commands

Code: Select all

uname -a

rpm -qa | grep php

[lfields]

Code: Select all

Linux lwplc1 2.6.38.8-desktop-10.mga #1 SMP Wed Jan 25 10:17:18 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux


Code: Select all

php-sqlite3-5.3.15-1.mga1
php-ctype-5.3.15-1.mga1
php-suhosin-0.9.33-1.mga1
php-pgsql-5.3.15-1.mga1
php-posix-5.3.15-1.mga1
php-gd-bundled-5.3.15-1.mga1
php-dom-5.3.15-1.mga1
php-xml-5.3.15-1.mga1
lib64php5_common5-5.3.15-1.mga1
libphp5_common5-5.3.15-1.mga1
php-sysvshm-5.3.15-1.mga1
php-tokenizer-5.3.15-1.mga1
php-filter-5.3.15-1.mga1
php-mysqli-5.3.15-1.mga1
php-gettext-5.3.15-1.mga1
php-ftp-5.3.15-1.mga1
php-mysql-5.3.15-1.mga1
php-mysqlnd-5.3.15-1.mga1
php-xmlreader-5.3.15-1.mga1
php-ini-5.3.15-1.mga1
php-cli-5.3.15-1.mga1
php-hash-5.3.15-1.mga1
php-json-5.3.15-1.mga1
apache-mod_php-5.3.15-1.mga1
php-pdo-5.3.15-1.mga1
php-mssql-5.3.15-1.mga1
php-sysvsem-5.3.15-1.mga1
php-pdo_mysql-5.3.15-1.mga1
php-zlib-5.3.15-1.mga1
php-xmlwriter-5.3.15-1.mga1
php-readline-5.3.15-1.mga1
php-gd-5.3.15-1.mga1
php-session-5.3.15-1.mga1
php-openssl-5.3.15-1.mga1
php-timezonedb-2012.4-1.mga1
php-odbc-5.3.15-1.mga1


[tom_]

ok,
you really have a 64bit kernel,
unlikely the command I gave you is not showing the package arch,
my fault

I need some other details:

Code: Select all

urpmf /usr/lib64/php/extensions/mssql.so
urpmf /usr/lib/php/extensions/mssql.so
cat /etc/urpmi/urpmi.cfg


one of the first two should say which arch has the mssql package you have,
the last report your repository configuration,
so we can see from where you are tring to update and if
you update repository is enabled
(eventually check it wtih drakrpm-edit-media)

[lfields]

Code: Select all

urpmf /usr/lib64/php/extensions/mssql.so
php-mssql:/usr/lib64/php/extensions/mssql.so
    $MIRRORLIST: media/core/updates/media_info/20120802-201345-files.xml.lzma
php-mssql:/usr/lib64/php/extensions/mssql.so                                   
php-mssql:/usr/lib64/php/extensions/mssql.so
php-mssql:/usr/lib64/php/extensions/mssql.so
php-mssql:/usr/lib64/php/extensions/mssql.so
php-mssql:/usr/lib64/php/extensions/mssql.so
php-mssql:/usr/lib64/php/extensions/mssql.so
    $MIRRORLIST: media/nonfree/release/media_info/20110529-211858-files.xml.lzma
    $MIRRORLIST: media/nonfree/updates/media_info/20120627-154251-files.xml.lzma
    $MIRRORLIST: media/../../i586/media/core/updates/media_info/20120802-201234-files.xml.lzma


Code: Select all

 urpmf /usr/lib/php/extensions/mssql.so                       
php-mssql:/usr/lib/php/extensions/mssql.so
php-mssql:/usr/lib/php/extensions/mssql.so
php-mssql:/usr/lib/php/extensions/mssql.so
php-mssql:/usr/lib/php/extensions/mssql.so
php-mssql:/usr/lib/php/extensions/mssql.so
php-mssql:/usr/lib/php/extensions/mssql.so
php-mssql:/usr/lib/php/extensions/mssql.so


Code: Select all

cat /etc/urpmi/urpmi.cfg
{
}

Mageia\ -\ 1\ -\ x86_64\ DVD cdrom://x86_64/media/core {
  ignore
  key-ids: 80420f66
}

Core\ Release\ (distrib1)  {
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/core/release
}

Core\ Release\ Debug\ (distrib2)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/debug/core/release
}

Core\ Updates\ (distrib3)  {
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  update
  with-dir: media/core/updates
}

Core\ Updates\ Debug\ (distrib4)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/debug/core/updates
}

Core\ Updates\ Testing\ (distrib5)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/core/updates_testing
}

Core\ Updates\ Testing\ Debug\ (distrib6)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/debug/core/updates_testing
}

Core\ Backports\ (distrib7)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/core/backports
}

Core\ Backports\ Debug\ (distrib8)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/debug/core/backports
}

Core\ Backports\ Testing\ (distrib9)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/core/backports_testing
}

Core\ Backports\ Testing\ Debug\ (distrib10)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/debug/core/backports_testing
}

Nonfree\ Release\ (distrib11)  {
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/nonfree/release
}

Nonfree\ Release\ Debug\ (distrib12)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/debug/nonfree/release
}

Nonfree\ Updates\ (distrib13)  {
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  update
  with-dir: media/nonfree/updates
}

Nonfree\ Updates\ Debug\ (distrib14)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/debug/nonfree/updates
}

Nonfree\ Updates\ Testing\ (distrib15)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/nonfree/updates_testing
}

Nonfree\ Updates\ Testing\ Debug\ (distrib16)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/debug/nonfree/updates_testing
}

Nonfree\ Backports\ (distrib17)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/nonfree/backports
}

Nonfree\ Backports\ Debug\ (distrib18)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/debug/nonfree/backports
}

Nonfree\ Backports\ Testing\ (distrib19)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/nonfree/backports_testing
}

Nonfree\ Backports\ Testing\ Debug\ (distrib20)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/debug/nonfree/backports_testing
}

Tainted\ Release\ (distrib21)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/tainted/release
}

Tainted\ Release\ Debug\ (distrib22)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/debug/tainted/release
}

Tainted\ Updates\ (distrib23)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  update
  with-dir: media/tainted/updates
}

Tainted\ Updates\ Debug\ (distrib24)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/debug/tainted/updates
}

Tainted\ Updates\ Testing\ (distrib25)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/tainted/updates_testing
}

Tainted\ Updates\ Testing\ Debug\ (distrib26)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/debug/tainted/updates_testing
}

Tainted\ Backports\ (distrib27)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/tainted/backports
}

Tainted\ Backports\ Debug\ (distrib28)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/debug/tainted/backports
}

Tainted\ Backports\ Testing\ (distrib29)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/tainted/backports_testing
}

Tainted\ Backports\ Testing\ Debug\ (distrib30)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/debug/tainted/backports_testing
}

Core\ 32bit\ Release\ (distrib31)  {
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/../../i586/media/core/release
}

Core\ 32bit\ Release\ Debug\ (distrib32)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/../../i586/media/debug/core/release
}

Core\ 32bit\ Updates\ (distrib33)  {
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  update
  with-dir: media/../../i586/media/core/updates
}

Core\ 32bit\ Updates\ Debug\ (distrib34)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/../../i586/media/debug/core/updates
}

Core\ 32bit\ Updates\ Testing\ (distrib35)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/../../i586/media/core/updates_testing
}

Core\ 32bit\ Updates\ Testing\ Debug\ (distrib36)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/../../i586/media/debug/core/updates_testing
}

Core\ 32bit\ Backports\ (distrib37)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/../../i586/media/core/backports
}

Core\ 32bit\ Backports\ Debug\ (distrib38)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/../../i586/media/debug/core/backports
}

Core\ 32bit\ Backports\ Testing\ (distrib39)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/../../i586/media/core/backports_testing
}

Core\ 32bit\ Backports\ Testing\ Debug\ (distrib40)  {
  ignore
  key-ids: 80420f66
  mirrorlist: $MIRRORLIST
  with-dir: media/../../i586/media/debug/core/backports_testing
}


[Ken-Bergen]

If I try to install the 64bit version I get.

Code: Select all

Sorry, the following package cannot be selected:

- php-mssql-5.3.15-1.mga1.x86_64


Any ideas? Thanks.

That sort of message is less than helpful.
After trying with urpmi I found the following packages must be removed before installing the 64bit version

php-mssql-3:5.3.15-1.mga1.i586
libfreetds0-0.82-12.mga1.i586
libphp5_common5-5.3.15-1.mga1.i586
libreadline6-6.2-1.mga1.i586
libunixODBC1-2.3.0-2.mga1.i586

Edit: It may not be necessary to remove all those packages so try with only removing
php-mssql-3:5.3.15-1.mga1.i586
and
libphp5_common5-5.3.15-1.mga1.i586

[lfields]

Just getting back to this issue, been a busy week.

I removed the packages (libphp5_common5-5.3.15-1.mga1.i586),(php-mssql-3:5.3.15-1.mga1.i586) and it made me remove the other ones as well. After uninstall of these packages I was able to install thier 64bit counterparts. All is working well.

Not sure why all the 32bit packages were installed. I insalled httpd and php by selecting them and letting software installer choose it's own dependancies. If there is a 64bit package available shouldn't it install that on a 64bit system before a 32bit?

Anyway, thanks for the help. Much appretiated. It is up and running. I now have a complete Mandriva replacement in full working order.