The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Module php-mssql

Discussion in 'General Discussion' started by Alejandro P, Apr 17, 2008.

  1. Alejandro P

    Alejandro P Well-Known Member

    Joined:
    Apr 6, 2007
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello, I need to connect my cpanel box to a mssql server.

    I have checked the information about it and I need to install freetds and php-mssql

    I have installed freetds without any problem but I don't know how to install php-mssql

    my server is running

    root@s1 [~]# cat /etc/redhat-release
    CentOS release 4.6 (Final)

    root@s1 [~]# php -v
    PHP 5.2.5 (cli) (built: Apr 14 2008 13:18:10)

    I have found a rpm but they fail with this message

    root@s1 [~]# rpm -i php-mssql-5.2.5-1.i386.rpm
    warning: php-mssql-5.2.5-1.i386.rpm: V3 DSA signature: NOKEY, key ID 2155f4cb
    error: Failed dependencies:
    libsybdb.so.5 is needed by php-mssql-5.2.5-1.i386
    php-common = 5.2.5-1 is needed by php-mssql-5.2.5-1.i386

    Seems´there is a version problem but I am unable to find wich rpm should I try.

    Any ideas?
     
  2. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Have you considered using PDO (which, granted, has a big scary warning that should be heeded) as a means of MSSQL support?
     
  3. Alejandro P

    Alejandro P Well-Known Member

    Joined:
    Apr 6, 2007
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    I'll try PDO as per your suggestion, thanks.

    BTW, any comments on the way I was doing it?
     
  4. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    I've been so spoiled by EasyApache, I'm really out of touch with manually compiling PHP nowadays.

    I'm not saying your way was in any way incorrect. I was just presenting an alternative.
     
  5. nickp666

    nickp666 Well-Known Member

    Joined:
    Jan 28, 2005
    Messages:
    770
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    /dev/null
    You cant install php modules to a manually compiled PHP instance via RPM's, you'll need to grab the source for the module and compile it manually, "libsybdb.so.5" i think is a sybase library (you should be able to install this via yum or an rpm)
     
  6. nocbr.com

    nocbr.com Member

    Joined:
    May 1, 2006
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    And how can I do it? I have enable PDO, but i did not find in easyapache and any anyway some pdo-mssql. I would apreciate to know how can I do it.

    thanks.
     
  7. Alejandro P

    Alejandro P Well-Known Member

    Joined:
    Apr 6, 2007
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    I had to recompile apache to privide PDO support and then compile the .so module from the sources to get it working.
     
Loading...

Share This Page