Mageia forum

share the magic
http://forums.mageia.org/en/

[SOLVED] php-mssql

http://forums.mageia.org/en/viewtopic.php?f=8&t=3176

Page 1 of 1

[SOLVED] php-mssql

PostPosted: Aug 2nd, '12, 16:54
by 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.

Re: php-mssql

PostPosted: Aug 2nd, '12, 20:24
by tom_
lfields wrote: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

Re: php-mssql

PostPosted: Aug 2nd, '12, 22:00
by 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

Re: php-mssql

PostPosted: Aug 2nd, '12, 22:24
by tom_
ok,
you really have a 64bit kernel,
unlikely the command I gave you is not showing the package arch,
my fault :oops:

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)

Re: php-mssql

PostPosted: Aug 2nd, '12, 23:03
by 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
}

Re: php-mssql

PostPosted: Aug 3rd, '12, 00:21
by Ken-Bergen
lfields wrote: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. :shock:
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

Re: php-mssql

PostPosted: Aug 23rd, '12, 04:08
by 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.
All times are UTC + 1 hour [ DST ]
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/