Lia happens to work in my building. She'll have to confirm this for you, but when I left, it was working. ;-)
Brandon On 7/24/06, Garrett P. Taylor <[EMAIL PROTECTED]> wrote:
Did you ever get any resolution with this? I've successfully connected from PHP to MS SQL on several different servers and I would happy to go over it with you. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Horalia Rodriguez Sent: Friday, July 07, 2006 4:48 PM To: [EMAIL PROTECTED] Cc: [email protected] Subject: Re: [RLUG] Help with Linux Well, I got fed up with Fedora Core 5 and since your suggestion Kyle, of using rpms involves having Fedora Core 4, I installed this version. I downloaded both rpms but had problems installing these packages. I got the following error messages: [EMAIL PROTECTED] /]# rpm -ivh freetds-0.63-2.i386.rpm error: Failed dependencies: libreadline.so.4 is needed by freetds-0.63-2.i386 [EMAIL PROTECTED] /]# rpm -ivh php-mssql-5.0.4-10.1.i386.rpm error: Failed dependencies: libsybdb.so.5 is needed by php-mssql-5.0.4-10.1.i386 [EMAIL PROTECTED] /]# Do you know the correct command line to install these? From: Kyle T. Smith <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Horalia Rodriguez <[EMAIL PROTECTED]> CC: [email protected] Subject: Re: [RLUG] Help with Linux Date: Fri, 7 Jul 2006 12:10:00 -0800 Hi Horalia, Ok, the error messages logged are just telling us what we already know unfortunately. MSSQL support is correctly installed so we can eliminate that as a source of errors. The connection strings you are using look fine however you might want to try a couple of differant things. Currently you have: connect = mssql_connect("10.7.122.28,1433","user","pwd"); try chaing the server to "10.7.122.28:1433" or "10.7.122.28/1433" It is unlikely that will make a differance. Another thing to look into is this. Are the user and password for an SQL user account or an Windows system account? If it is a system account you may need to change the following option in the php.ini file from off to on. ; Use NT authentication when connecting to the server mssql.secure_connection = Off If none of these things solve the problem what I would recommend is opening the event viewer on the windows server and then trying to make your connection. If it is having authentication or connection issues on the windows side of things due to a php misconfiguration it should be logged in the event viewer. Kyle On Fri, 07 Jul 2006 10:47:16 -0700, "Horalia Rodriguez" <[EMAIL PROTECTED]> wrote: > > One more thing Kyle, I checked the phpinfo page as you suggested, and the > exact same information you presented is on the phpinfo page under the > MSSQL > section. > > > > > > > From: Kyle T. Smith <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: Horalia Rodriguez <[EMAIL PROTECTED]>, [email protected] > Subject: Re: [RLUG] Help with Linux > Date: Fri, 7 Jul 2006 2:13:43 -0800 > > Rpms with it pre-built, should have thought of that... > > http://phprpms.sourceforge.net/mssql > > Also, Anna is correct in mentioning you'll want to use mssql_ functions > and > not > the odbc_ functions. While ODBC should work in theory I've never actually > seen > it work between php and mssql. > > Kyle > > On Fri, 7 Jul 2006 01:21:04 -0700, Anna <[EMAIL PROTECTED]> > wrote: > > You gave a lot of good info, though without a look at your actual > > phpinfo() output it's hard to tell. > > > > But, one weird thing is it seems you're attempting to use the odbc_* > > functions? I think what you would want to use are the mssql_* > > functions. have you read this?: > > > > http://us3.php.net/mssql > > > > > > the php.net manual is a very good reference. it's the first place I > > look whenever I have a question. so... do you get an error when you > try > > to use a function like: > > > > <? > > $res = mssql_connect ( 'myserver', 'usrme', 'doublesecret' ); > > ?> > > > > I'm guessing you get an error telling you the function mssql_connect > > isn't defined. like this: > > > > "Fatal error: Call to undefined function: mssql_connect() in > > /var/www/virthosts/internaltesting.net/phpinfo.php on line 5" > > > > If so, that means you do not have the mssql stuff available to your php > > apache module (it's not built in and there is no separate module > > present). It's been a while since I've messed with building any php > > software because I use mysql and everything just works. It's sort of > > hard to believe but, I think you may need to build a php module from > > scratch. Nothing pre-built-with-mssql comes with Debian. who knows > > why? If that's true of Debian, it's probably true of Fedora as well. > > You might have luck at searching for an rpm. > > > > - Anna > > > > > > > > On Thu, Jul 06, 2006 at 04:09:33PM -0700, Horalia Rodriguez wrote: > >> Hi Anna, thank you for responsing so soon. Here are the details of my > >> latest attempts in getting this to work: > >> > >> 1. I reloaded Fedora Core 5 as a web server on the PC. > >> 2. I installed freetds by following these steps: > >> # rpm --import http://dries.studentenweb.org/rpm/RPM-GPG-KEY.dries.txt > >> -Created a file in /etc/yum.repos.d/dries.repo with the following > > contents: > >> [dries] > >> name=Extra Fedora rpms dries - $releasever - $basearch > >> > > > baseurl=http://ftp.belnet.be/packages/dries.ulyssis.org/fedora/linux/$re leasever/$basearch/dries/RPMS/ > >> enabled=1 > >> gpgcheck=1 > >> -I then issued the following command: > >> # yum install freetds > >> -After this, I tested freetds using tsql. A prompt 1> came up. > >> 3. After installing freetds, I created the DSN to connect to the MSSQL > >> server. Here's how I did this: > >> -Created a file under root named tds.driver.template with the > following > >> lines: > >> [FreeTDS] > >> Description = v0.63 with protocol v8.0 > >> Driver = /usr/lib/libtdsodbc.so.0 > >> -Executed the following command, which registers the ODBC driver: > >> #odbcinst -i -d -f tds.driver.template > >> -Created a second file also under root named tds.datasource.template > > with > >> the following lines: > >> [MSSQLTestServer] > >> Driver = FreeTDS > >> Description = <DB Description> > >> Trace = No > >> Server = <MSSQL ip address> > >> Port = 1433 > >> Database = <DB name> > >> -Executed the following command: > >> # odbcinst -i -s -f tds.datasource.template -l > >> -Tested the connection: > >> (Copied directly from terminal window) > >> [EMAIL PROTECTED] /]# isql MSSQLTestServer rsm rsm > >> +---------------------------------------+ > >> | Connected! | > >> | | > >> | sql-statement | > >> | help [tablename] | > >> | quit | > >> | | > >> +---------------------------------------+ > >> SQL> > >> -I was able to successfully run a query at this point. > >> 4. I then followed these steps that were given to me by another person > > that > >> is trying to help me: > >> # wget > >> > > > http://remi.collet.free.fr/rpms/fc5.i386/remi-release-1-1.fc5.remi.noarc h.rpm > >> # rpm -Uvh remi-release-1-1.fc5.remi.noarch.rpm > >> # yum --enablerepo=remi install php-mssql php > >> 5. At this point, I restarted the http service, tried to connect to > the > >> MSSQL server which I did. > >> 6. I created a phpinfo page, which came up successfully. I then > checked > > the > >> configuration, and mssql is not included. I did however find this > line: > >> /etc/php.d/ldap.ini, /etc/php.d/mssql.ini > >> under the additional .ini files parsed section. > >> 7. Hoping that this was going to work, I attempted to load the > following > >> php page, but only a blank page came up: > >> <?php > >> $connect = odbc_connect("MSSQLTestServer","user","pwd"); > >> if (!$connect) die ("Invalid connection"); > >> ?> > >> I purposly used a bogus username but the error message did not come > up. > > I > >> then tried to use this code: > >> <?php > >> connect = mssql_connect("10.7.122.28,1433","user","pwd"); > >> if (!$connect) die ("Invalid connection");*/ > >> ?> > >> > >> I also added the following lines to freetds.conf: > >> > >> [TDS] > >> host = <ip address of the server with sql> > >> port = 1433 > >> tds version = 8.0 > >> > >> I have done these steps so many times, that I already know them by > > heart. I > >> have also reloaded Fedora many times, so if you need me to start > fresh, > > I > >> will do so. Any help will be appreciated, my supervisor has been very > >> patient with me, but I know that its only a matter of time before he > > starts > >> asking for results. The first time I installed Fedora Core was on June > > 6th, > >> so you can see that I've struggling with this for quite some time now. > >> > >> Thanks! > >> > >> > >> > >> From: Anna <[EMAIL PROTECTED]> > >> To: [email protected] > >> CC: Horalia Rodriguez <[EMAIL PROTECTED]> > >> Subject: Re: [RLUG] Help with Linux > >> Date: Thu, 6 Jul 2006 15:37:32 -0700 > >> > >> Hi Horalia. > >> > >> Have you run the phpinfo() function to see what you have installed and > >> how it's configured? if not, make a php file containing only this > line: > >> > >> <? phpinfo(); ?> > >> > >> then study the result in a web browser. if you need help deciphering > > it, > >> post (pieces of the) the result here... or post a url to your > phpinfo() > >> page so we can take a look. > >> > >> You want to start with debugging the basics. questions: is the php > >> program you have even trying to connect to the server? is it giving > any > >> error messages on the page or in the logs? if the web server and db > >> server on different machines can you see any db traffic at all moving > >> between them with packet sniffer? are their any interesting logs on > the > >> db server? > >> > >> - Anna > >> > >> > >> On Thu, Jul 06, 2006 at 03:24:37PM -0700, Horalia Rodriguez wrote: > >> > > >> > Hi, > >> > > >> > Sebastian Smith suggested that I send an e-mail here to see if I > could > >> get some > >> > help to resolve my issue. I ll be very brief. > >> > > >> > I am trying to connect to a MSSQL server from a Fedora Core box > > through > >> php. I > >> > have already successfully installed freetds, but I can t get php to > > work. > >> I > >> > have installed freetds several different ways to no avail. I believe > > that > >> it is > >> > installed correctly because I can connect to the MSSQL server from > the > >> terminal > >> > window and run a query successfully. I have also tried installing > php > >> using ./ > >> > configure with-mssql= freetds-path with no success. Could someone > > send > >> me > >> > detailed instructions on how to do this? I m very new to Linux and > > have > >> been > >> > struggling to get this working for the past month. I ve been > dreaming > >> about > >> > rpms, unixODBC, php code, you name it. I have reloaded Fedora more > > times > >> that I > >> > care to remember, so any suggestions will be appreciated. > >> > > >> > Thanks, > >> > > >> > > >> > Horalia Rodriguez > >> > [EMAIL PROTECTED] > >> > >> _________________________________________________________________ > >> Don?t just search. Find. Check out the new MSN Search! > >> http://search.msn.click-url.com/go/onm00200636ave/direct/01/ > >> > > > > _______________________________________________ > > RLUG mailing list > > [email protected] > > http://lists.rlug.org/mailman/listinfo/rlug > > _________________________________________________________________ > Express yourself instantly with MSN Messenger! Download today - it's FREE! > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ _________________________________________________________________ Don't just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ _______________________________________________ RLUG mailing list [email protected] http://lists.rlug.org/mailman/listinfo/rlug CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient (s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender via reply email and destroy all copies of the original message. _______________________________________________ RLUG mailing list [email protected] http://lists.rlug.org/mailman/listinfo/rlug
-- If UNIX doesn't have the solution you have the wrong problem. UNIX is simple, but it takes a genius to understand it's simplicity. _______________________________________________ RLUG mailing list [email protected] http://lists.rlug.org/mailman/listinfo/rlug
