Question

Trouble Using FreeTDS Driver for Remote MSSQL Connection

Asked by: EMB01

I am trying to use this tutorial (http://kb.mediatemple.net/questions/233/Using+%28remote%29+MS-SQL+databases+with+PHP+on+a+%28dv%29) to install FreeTDS on my server to be able to connect to a remote MSSQL server via ODBC. I seem to have installed FreeTDS with Yum and not by the means of the tutorial and I get the following error when trying to connect:
Warning: odbc_connect() [function.odbc-connect]: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect

I removed FreeTDS by running '[root@deep] /#rpm -e freetds-0.63-1.1.el3.rf.i386.rpm' and reinstalled it with 'rpm -Uhv freetds-0.63-1.1.el3.rf.i386.rpm' but I still receive the error.

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. odbc problem (sqlexec, sqlconnect)
    i want to insert information in my odbc table. What's wrong with this code? STORE SQLCONNECT('MSSQL_VAM') TO MyConnection SQLSETPROP(MyConnection, 'Transactions', 2) STORE SQLEXEC(MyConnection, "INSERT INTO reception (transport) VALUES (v_transport)") to test SQL...
  2. SQLConnect question...
    I am writing a C++ front end for an SQL database ass a school assignment. (Cal State Hayward in California - A Database Architecture class...) I am having trouble connectuing to the school's SQL database with the SQLConnect function. Where I supply the database name, I have...
  3. MSSQL connection for PHP via ODBC
    Ok I've created a file called Varinclude.php which stores my connection information to my MSSQL DB. <?php $ODBCSOURCE="mysource"; $ODBCUSERNAME="username"; $ODBCPASSWORD="password"; ?> I then include this into a buildpage.php which looks ...
  4. Installing php with odbc on a Linux box
    I'm a complete Windows junkie, and I think I'm making this process harder than it really is... Anyways, here goes: I need to connect to a MSSQL server from a Linux box (Fedora Core 5) using PHP. I already installed freeTDS and configured a DSN, at least that's what I think I ...

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: gheistPosted on 2008-05-10 at 13:21:13ID: 21540386

http://www.freetds.org/userguide/prepodbc.htm

Its unixODBC misconfiguration - you did not set up datasource at all. Installing/uninstalling drivers is of no help (same on windows)

 

by: EMB01Posted on 2008-05-10 at 17:54:59ID: 21541138

So what does this mean? The tutorial (http://kb.mediatemple.net/questions/233/Using+%28remote%29+MS-SQL+databases+with+PHP+on+a+%28dv%29) describes how to acquire this functionality on this server.

 

by: gheistPosted on 2008-05-11 at 02:01:17ID: 21541894

You took wrong path. Correct is here:
http://php.net/mssql

 

by: EMB01Posted on 2008-05-11 at 06:19:31ID: 21542390

But the tutorial describes exactly what I am trying to do. But something seems to be wrong with the way I've done things. Perhaps, I could send you my Yum list or something else that could help you assess where I went wrong?

 

by: gheistPosted on 2008-05-11 at 08:03:09ID: 21542608

Is Mediatemple your hosting provider?

 

by: EMB01Posted on 2008-05-11 at 15:59:13ID: 21543835

Yes. I tried talking with them about this, but they won't offer me any further support.

 

by: gheistPosted on 2008-05-12 at 00:23:15ID: 21545106

Error signifies mistake like mistyping in Step #3 or earlier.
Please run "script" command before re-installing and if still no luck let us check your typing by posting typescript file here.

 

by: EMB01Posted on 2008-05-12 at 04:43:33ID: 21545999

I tried it and it still does not work. During the installation, the only part where I don't receive any confirmation as to the command being successful is when I type 'odbcinst -i -s -f /opt/tds.datasource.DBNAME.template'. The following is my error log - I hope this is what you meant by my transcript. Thank you.

[Sun May 11 04:14:11 2008] [notice] mod_python: Creating 4 session mutexes based on 50 max processes and 0 max threads.
[Sun May 11 04:14:11 2008] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Sun May 11 04:14:11 2008] [warn] RSA server certificate CommonName (CN) `plesk' does NOT match server name!?
[Sun May 11 04:14:11 2008] [warn] Init: SSL server IP/port conflict: default-72-47-216-93:443 (/etc/httpd/conf.d/zz010_psa_httpd.conf:78) vs. webmail:443 (/etc/httpd/conf.d/zz010_psa_httpd.conf:133)
[Sun May 11 04:14:11 2008] [warn] Init: SSL server IP/port conflict: relogistechs.com:443 (/var/www/vhosts/relogistechs.com/conf/httpd.include:12) vs. webmail:443 (/etc/httpd/conf.d/zz010_psa_httpd.conf:133)
[Sun May 11 04:14:11 2008] [warn] Init: You should not use name-based virtual hosts in conjunction with SSL!!
[Sun May 11 04:14:11 2008] [notice] Apache/2.2.3 (CentOS) configured -- resuming normal operations
[Mon May 12 01:16:26 2008] [error] [client 127.0.0.1] Directory index forbidden by Options directive: /var/www/html/
[Mon May 12 01:28:30 2008] [error] [client 127.0.0.1] Directory index forbidden by Options directive: /var/www/html/
[Mon May 12 02:33:14 2008] [error] [client 127.0.0.1] Directory index forbidden by Options directive: /var/www/html/

 

by: gheistPosted on 2008-05-13 at 00:25:29ID: 21552904

Apache errors are irreleavant to question.
TDS ODBC driver relates to php - including command line version.
Can you post output of phpinfo(8+1)

 

by: EMB01Posted on 2008-05-13 at 05:23:58ID: 21554267

Yes, it is available here: http://relogistechs.com/contest4.php. Notice: The very bottom of the page displays the error that I receive when trying to connect. Sorry for any confusion, I'm very new to this. Thank you.

 

by: gheistPosted on 2008-05-13 at 11:53:16ID: 21558107

Install php-mssql
I guess tds and odbc versions do not match and tds driver is never loaded.

 

by: EMB01Posted on 2008-05-13 at 13:23:03ID: 21558925

What do you mean by "install php-mssql?" Do you mean to do something like this: http://www.howtoforge.com/installing_php_mssql_centos5.0? You see, I am just trying to connect to a remote MSSQL database...

 

by: gheistPosted on 2008-05-14 at 03:42:26ID: 21562680

Let me suggest yum search and yum install

 

by: EMB01Posted on 2008-05-14 at 12:36:50ID: 21567905

Do you mean to install a php-mssql .RPM such as this one, http://rpm.pbone.net/index.php3?stat=3&limit=2&srodzaj=3&dl=40&search=php-mssql, via Yum and that should solve the problem?

 

by: gheistPosted on 2008-05-15 at 00:21:27ID: 21571244

I suggest using builtin package manager.
Fetching random rpms will not help

 

by: EMB01Posted on 2008-05-15 at 12:27:43ID: 21577168

Can you share an example of a builtin package manager that will solve this problem?

 

by: gheistPosted on 2008-05-15 at 12:34:05ID: 21577215

 

by: EMB01Posted on 2008-05-15 at 12:38:51ID: 21577258

I have already installed Yum and have used it to install FreeTDS; however, the problem persists. What should I do so I don't get the error: odbc_connect() [function.odbc-connect]: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect

 

by: gheistPosted on 2008-05-16 at 01:37:12ID: 21580891

Maybe ODBC configuration must be run as apache user... Or root user....

 

by: EMB01Posted on 2008-05-16 at 05:05:36ID: 21581931

I am using the root user. I am really new to this, and I would love to solve this problem. You've told me that the "...tds and odbc versions do not match and tds driver is never loaded." Is there anything I can do to solve this so that they match and hopefully load? Thank you.

 

by: gheistPosted on 2008-05-16 at 06:21:20ID: 21582408

Normally you should be using ldd and nm utilities to find library mismatches etc. Thats complicated.

Are you sure freetds file is in place specified by odbc configuration?
For example Mandriva installs driver named /usr/lib/libtdsodbc.so.0

 

by: EMB01Posted on 2008-05-16 at 07:04:50ID: 21582747

Yes, it is installed at that location. I have attached a screenshot so you can see.

 

by: gheistPosted on 2008-05-16 at 07:45:20ID: 21583182

Then follow instructions, but use correct tdsodbc library name.

 

by: EMB01Posted on 2008-05-16 at 07:53:12ID: 21583249

Which instructions - I have already completed the tutorial but only afterwards do I receive the error. Am I not already using the correct library name?

 

by: EMB01Posted on 2008-05-16 at 15:25:12ID: 21586934

P.S. As this issue is somewhat urgent; it may be beneficial for both of us to respond to eachother as quickly as possible. Thank you.

 

by: gheistPosted on 2008-05-17 at 00:35:08ID: 21588289

Instructions on providers help page, but using existing, versioned library name.
Otherwise it is logical that odbc does not load nonexistent library.

 

by: EMB01Posted on 2008-05-17 at 05:40:46ID: 21589070

If by the providers help page, you mean this: http://kb.mediatemple.net/questions/233/Using+%28remote%29+MS-SQL+databases+with+PHP+on+a+%28dv%29, then you must know that I have followed these instructions precisely and the error persists. How can I use the existing, versioned library name?

 

by: gheistPosted on 2008-05-17 at 12:44:16ID: 21590537

You should not follow precisely in two places
1) you did it right - installed using yum
2) you have to use .so.0 file since .so file does not exist and thus is unloadable by ODBC manager.

 

by: EMB01Posted on 2008-05-17 at 12:53:43ID: 21590562

I am already using the .so.0 file - doesn't the tutorial say to use that one anyway?
(From Step 2: "Driver = /usr/lib/libtdsodbc.so.0")

 

by: gheistPosted on 2008-05-17 at 13:19:05ID: 21590626

Phew - when I looked there when you asked there was no .0
Try running test DB connection from standalone PHP - it may give more interesting diagnostic output.

 

by: gheistPosted on 2008-05-17 at 13:20:43ID: 21590631

And do not fear php-mssql - that is extra module that does not fall under recompiling php as in providers guide.

 

by: EMB01Posted on 2008-05-17 at 13:33:45ID: 21590670

Could you please elaborate (perhaps, with instructions) on how to "... test DB connection from standalone PHP" as I don't seem to understand. Are you also suggesting that I don't use this tutorial (http://kb.mediatemple.net/questions/233/Using+%28remote%29+MS-SQL+databases+with+PHP+on+a+%28dv%29) but instead use this one (http://www.howtoforge.com/installing_php_mssql_centos5.0)?

 

by: gheistPosted on 2008-05-17 at 14:22:27ID: 21590787

Enough is enough.
#yum install php-mssql
No more questions about extra indirection calles ODBC.

 

by: EMB01Posted on 2008-05-17 at 14:28:52ID: 21590806

I installed it - now what? Can I use these functions (on a remote DB): http://us.php.net/mssql_connect

 

by: gheistPosted on 2008-05-18 at 00:02:57ID: 21591793

Extension loads in CentOS php on next server reload.
Check phpinfo() and if you see mssql extension loaded then all described mssql functions are available.

 

by: gheistPosted on 2008-05-18 at 00:03:39ID: 21591795

"server reload" == apache restart

 

by: EMB01Posted on 2008-05-18 at 05:05:37ID: 21592392

I restarted apache with '/etc/init.d/httpd graceful' but when I look at my phpinfo() there is no listing of mssql functions. Thank you.

 

by: gheistPosted on 2008-05-18 at 22:58:22ID: 21595441

Not functions - only module name is enough.

 

by: EMB01Posted on 2008-05-19 at 12:32:27ID: 21600794

There is not listing of mssql modules. Don't I still need to do something in my php.ini file?

 

by: EMB01Posted on 2008-05-19 at 15:04:33ID: 21602018

This is what my php.ini file looks like; and oddly enough - I have another php.ini file that is titled "php.ini.saved_by_psa" (attached):
error severity to display.
mssql.min_error_severity = 10

; Minimum message severity to display.
mssql.min_message_severity = 10

; Compatibility mode with old versions of PHP 3.0.
mssql.compatability_mode = Off

; Connect timeout
;mssql.connect_timeout = 5

; Query timeout
;mssql.timeout = 60

; Valid range 0 - 2147483647.  Default = 4096.
;mssql.textlimit = 4096

; Valid range 0 - 2147483647.  Default = 4096.
;mssql.textsize = 4096

; Limits the number of records in each batch.  0 = all records in one batch.
;mssql.batchsize = 0

; Specify how datetime and datetim4 columns are returned
; On => Returns data converted to SQL server settings
; Off => Returns values as YYYY-MM-DD hh:mm:ss
;mssql.datetimeconvert = On

; Use NT authentication when connecting to the server
mssql.secure_connection = Off

; Specify max number of processes. -1 = library default
; msdlib defaults to 25
; FreeTDS defaults to 4096
;mssql.max_procs = -1

; Specify client character set.
; If empty or not set the client charset from freetds.comf is used
; This is only used when compiled with FreeTDS
;mssql.charset = "ISO-8859-1"

[Assertion]
; Assert(expr); active by default.
;assert.active = On

; Issue a PHP warning for each failed assertion.
;assert.warning = On

; Don't bail out by default.
;assert.bail = Off

; User-function to be called if an assertion fails.
;assert.callback = 0

; Eval the expression with current error_reporting().  Set to true if you want
; error_reporting(0) around the eval().
;assert.quiet_eval = 0

[COM]
; path to a file containing GUIDs, IIDs or filenames of files with TypeLibs
;com.typelib_file =
; allow Distributed-COM calls
;com.allow_dcom = true
; autoregister constants of a components typlib on com_load()
;com.autoregister_typelib = true
; register constants casesensitive
;com.autoregister_casesensitive = false
; show warnings on duplicate constant registrations
;com.autoregister_verbose = true

[mbstring]
; language for internal character representation.
;mbstring.language = Japanese

; internal/script encoding.
; Some encoding cannot work as internal encoding.
; (e.g. SJIS, BIG5, ISO-2022-*)
;mbstring.internal_encoding = EUC-JP

; http input encoding.
;mbstring.http_input = auto

; http output encoding. mb_output_handler must be
; registered as output buffer to function
;mbstring.http_output = SJIS

; enable automatic encoding translation according to
; mbstring.internal_encoding setting. Input chars are
; converted to internal encoding by setting this to On.
; Note: Do _not_ use automatic encoding translation for
;       portable libs/applications.
;mbstring.encoding_translation = Off

; automatic encoding detection order.
; auto means
;mbstring.detect_order = auto

; substitute_character used when character cannot be converted
; one from another
;mbstring.substitute_character = none;

; overload(replace) single byte functions by mbstring functions.
; mail(), ereg(), etc are overloaded by mb_send_mail(), mb_ereg(),
; etc. Possible values are 0,1,2,4 or combination of them.
; For example, 7 for overload everything.
; 0: No overload
; 1: Overload mail() function
; 2: Overload str*() functions
; 4: Overload ereg*() functions
;mbstring.func_overload = 0

; enable strict encoding detection.
;mbstring.strict_encoding = Off

[FrontBase]
;fbsql.allow_persistent = On
;fbsql.autocommit = On
;fbsql.show_timestamp_decimals = Off
;fbsql.default_database =
;fbsql.default_database_password =
;fbsql.default_host =
;fbsql.default_password =
;fbsql.default_user = "_SYSTEM"
;fbsql.generate_warnings = Off
;fbsql.max_connections = 128
;fbsql.max_links = 128
;fbsql.max_persistent = -1
;fbsql.max_results = 128

[gd]
; Tell the jpeg decode to libjpeg warnings and try to create
; a gd image. The warning will then be displayed as notices
; disabled by default
;gd.jpeg_ignore_warning = 0

[exif]
; Exif UNICODE user comments are handled as UCS-2BE/UCS-2LE and JIS as JIS.
; With mbstring support this will automatically be converted into the encoding
; given by corresponding encode setting. When empty mbstring.internal_encoding
; is used. For the decode settings you can distinguish between motorola and
; intel byte order. A decode setting cannot be empty.
;exif.encode_unicode = ISO-8859-15
;exif.decode_unicode_motorola = UCS-2BE
;exif.decode_unicode_intel    = UCS-2LE
;exif.encode_jis =
;exif.decode_jis_motorola = JIS
;exif.decode_jis_intel    = JIS

[Tidy]
; The path to a default tidy configuration file to use when using tidy
;tidy.default_config = /usr/local/lib/php/default.tcfg

; Should tidy clean and repair output automatically?
; WARNING: Do not use this option if you are generating non-html content
; such as dynamic images
tidy.clean_output = Off

[soap]
; Enables or disables WSDL caching feature.
soap.wsdl_cache_enabled=1
; Sets the directory name where SOAP extension will put cache files.
soap.wsdl_cache_dir="/tmp"
; (time to live) Sets the number of second while cached file will be used
; instead of original one.
soap.wsdl_cache_ttl=86400

; Local Variables:
; tab-width: 4
; End:

; ImageMagick
extension=magickwand.so

[PHP]
 
;;;;;;;;;;;;;;;;;;;
; About php.ini   ;
;;;;;;;;;;;;;;;;;;;
; This file controls many aspects of PHP's behavior.  In order for PHP to
; read it, it must be named 'php.ini'.  PHP looks for it in the current
; working directory, in the path designated by the environment variable
; PHPRC, and in the path that was defined in compile time (in that order).
; Under Windows, the compile-time path is the Windows directory.  The
; path in which the php.ini file is looked for can be overridden using
; the -c argument in command line mode.
;
; The syntax of the file is extremely simple.  Whitespace and Lines
; beginning with a semicolon are silently ignored (as you probably guessed).
; Section headers (e.g. [Foo]) are also silently ignored, even though
; they might mean something in the future.
;
; Directives are specified using the following syntax:
; directive = value
; Directive names are *case sensitive* - foo=bar is different from FOO=bar.
;
; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one
; of the INI constants (On, Off, True, False, Yes, No and None) or an expression
; (e.g. E_ALL & ~E_NOTICE), or a quoted string ("foo").
;
; Expressions in the INI file are limited to bitwise operators and parentheses:
; |        bitwise OR
; &        bitwise AND
; ~        bitwise NOT
; !        boolean NOT
;
; Boolean flags can be turned on using the values 1, On, True or Yes.
; They can be turned off using the values 0, Off, False or No.
;
; An empty string can be denoted by simply not writing anything after the equal
; sign, or by using the None keyword:
;
;  foo =         ; sets foo to an empty string
;  foo = none    ; sets foo to an empty string
;  foo = "none"  ; sets foo to the string 'none'
;
; If you use constants in your value, and these constants belong to a
; dynamically loaded extension (either a PHP extension or a Zend extension),
; you may only use these constants *after* the line that loads the extension.
; 
;
;;;;;;;;;;;;;;;;;;;
; About this file ;
;;;;;;;;;;;;;;;;;;;
; This is the recommended, PHP 5-style version of the php.ini-dist file.  It
; sets some non standard settings, that make PHP more efficient, more secure,
; and encourage cleaner coding.
;
; The price is that with these settings, PHP may be incompatible with some
; applications, and sometimes, more difficult to develop with.  Using this
; file is warmly recommended for production sites.  As all of the changes from
; the standard settings are thoroughly documented, you can go over each one,
; and decide whether you want to use it or not.
;
; For general information about the php.ini file, please consult the php.ini-dist
; file, included in your PHP distribution.
;
; This file is different from the php.ini-dist file in the fact that it features
; different values for several directives, in order to improve performance, while
; possibly breaking compatibility with the standard out-of-the-box behavior of
; PHP.  Please make sure you read what's different, and modify your scripts
; accordingly, if you decide to use this file instead.
;
; - register_long_arrays = Off     [Performance]
;     Disables registration of the older (and deprecated) long predefined array
;     variables ($HTTP_*_VARS).  Instead, use the superglobals that were
;     introduced in PHP 4.1.0
; - display_errors = Off           [Security]
;     With this directive set to off, errors that occur during the execution of
;     scripts will no longer be displayed as a part of the script output, and thus,
;     will no longer be exposed to remote users.  With some errors, the error message
;     content may expose information about your script, web server, or database
;     server that may be exploitable for hacking.  Production sites should have this
;     directive set to off.
; - log_errors = On                [Security]
;     This directive complements the above one.  Any errors that occur during the
;     execution of your script will be logged (typically, to your server's error log,
;     but can be configured in several ways).  Along with setting display_errors to off,
;     this setup gives you the ability to fully understand what may have gone wrong,
;     without exposing any sensitive information to remote users.
; - output_buffering = 4096        [Performance]
;     Set a 4KB output buffer.  Enabling output buffering typically results in less
;     writes, and sometimes less packets sent on the wire, which can often lead to
;     better performance.  The gain this directive actually yields greatly depends
;     on which Web server you're working with, and what kind of scripts you're using.
; - register_argc_argv = Off       [Performance]
;     Disables registration of the somewhat redundant $argv and $argc global
;     variables.
; - magic_quotes_gpc = Off         [Performance]
;     Input data is no longer escaped with slashes so that it can be sent into
;     SQL databases without further manipulation.  Instead, you should use the
;     function addslashes() on each input element you wish to send to a database.
; - variables_order = "GPCS"       [Performance]
;     The environment variables are not hashed into the $_ENV.  To access
;     environment variables, you can use getenv() instead.
; - error_reporting = E_ALL        [Code Cleanliness, Security(?)]
;     By default, PHP suppresses errors of type E_NOTICE.  These error messages
;     are emitted for non-critical errors, but that could be a symptom of a bigger
;     problem.  Most notably, this will cause error messages about the use
;     of uninitialized variables to be displayed.
; - allow_call_time_pass_reference = Off     [Code cleanliness]
;     It's not possible to decide to force a variable to be passed by reference
;     when calling a function.  The PHP 4 style to do this is by making the
;     function require the relevant argument by reference.
 
;;;;;;;;;;;;;;;;;;;;
; Language Options ;
;;;;;;;;;;;;;;;;;;;;
 
; Enable the PHP scripting language engine under Apache.
engine = On
 
; Enable compatibility mode with Zend Engine 1 (PHP 4.x)
zend.ze1_compatibility_mode = Off
 
; Allow the <? tag.  Otherwise, only <?php and <script> tags are recognized.
; NOTE: Using short tags should be avoided when developing applications or
; libraries that are meant for redistribution, or deployment on PHP
; servers which are not under your control, because short tags may not
; be supported on the target server. For portable, redistributable code,
; be sure not to use short tags.
short_open_tag = On
 
; Allow ASP-style <% %> tags.
asp_tags = Off
 
; The number of significant digits displayed in floating point numbers.
precision    =  14
 
; Enforce year 2000 compliance (will cause problems with non-compliant browsers)
y2k_compliance = On
 
; Output buffering allows you to send header lines (including cookies) even
; after you send body content, at the price of slowing PHP's output layer a
; bit.  You can enable output buffering during runtime by calling the output
; buffering functions.  You can also enable output buffering for all files by
; setting this directive to On.  If you wish to limit the size of the buffer
; to a certain size - you can use a maximum number of bytes instead of 'On', as
; a value for this directive (e.g., output_buffering=4096).
output_buffering = 4096
 
; You can redirect all of the output of your scripts to a function.  For
; example, if you set output_handler to "mb_output_handler", character
; encoding will be transparently converted to the specified encoding.
; Setting any output handler automatically turns on output buffering.
; Note: People who wrote portable scripts should not depend on this ini
;       directive. Instead, explicitly set the output handler using ob_start().
;       Using this ini directive may cause problems unless you know what script
;       is doing.
; Note: You cannot use both "mb_output_handler" with "ob_iconv_handler"
;       and you cannot use both "ob_gzhandler" and "zlib.output_compression".
; Note: output_handler must be empty if this is set 'On' !!!!
;       Instead you must use zlib.output_handler.
;output_handler =
 
; Transparent output compression using the zlib library
; Valid values for this option are 'off', 'on', or a specific buffer size
; to be used for compression (default is 4KB)
; Note: Resulting chunk size may vary due to nature of compression. PHP
;       outputs chunks that are few hundreds bytes each as a result of
;       compression. If you prefer a larger chunk size for better
;       performance, enable output_buffering in addition.
; Note: You need to use zlib.output_handler instead of the standard
;       output_handler, or otherwise the output will be corrupted.
zlib.output_compression = Off
;zlib.output_compression_level = -1
 
; You cannot specify additional output handlers if zlib.output_compression
; is activated here. This setting does the same as output_handler but in
; a different order.
;zlib.output_handler =
 
; Implicit flush tells PHP to tell the output layer to flush itself
; automatically after every output block.  This is equivalent to calling the
; PHP function flush() after each and every call to print() or echo() and each
; and every HTML block.  Turning this option on has serious performance
; implications and is generally recommended for debugging purposes only.
implicit_flush = Off
 
; The unserialize callback function will be called (with the undefined class'
; name as parameter), if the unserializer finds an undefined class
; which should be instantiated.
; A warning appears if the specified function is not defined, or if the
; function doesn't include/implement the missing class.
; So only set this entry, if you really want to implement such a
; callback-function.
unserialize_callback_func=
 
; When floats & doubles are serialized store serialize_precision significant
; digits after the floating point. The default value ensures that when floats
; are decoded with unserialize, the data will remain the same.
serialize_precision = 100
 
; Whether to enable the ability to force arguments to be passed by reference
; at function call time.  This method is deprecated and is likely to be
; unsupported in future versions of PHP/Zend.  The encouraged method of
; specifying which arguments should be passed by reference is in the function
; declaration.  You're encouraged to try and turn this option Off and make
; sure your scripts work properly with it in order to ensure they will work
; with future versions of the language (you will receive a warning each time
; you use this feature, and the argument will be passed by value instead of by
; reference).
allow_call_time_pass_reference = Off
 
;
; Safe Mode
;
safe_mode = Off
 
; By default, Safe Mode does a UID compare check when
; opening files. If you want to relax this to a GID compare,
; then turn on safe_mode_gid.
safe_mode_gid = Off
 
; When safe_mode is on, UID/GID checks are bypassed when
; including files from this directory and its subdirectories.
; (directory must also be in include_path or full path must
; be used when including)
safe_mode_include_dir =
 
; When safe_mode is on, only executables located in the safe_mode_exec_dir
; will be allowed to be executed via the exec family of functions.
safe_mode_exec_dir =
 
; Setting certain environment variables may be a potential security breach.
; This directive contains a comma-delimited list of prefixes.  In Safe Mode,
; the user may only alter environment variables whose names begin with the
; prefixes supplied here.  By default, users will only be able to set
; environment variables that begin with PHP_ (e.g. PHP_FOO=BAR).
;
; Note:  If this directive is empty, PHP will let the user modify ANY
; environment variable!
safe_mode_allowed_env_vars = PHP_
 
; This directive contains a comma-delimited list of environment variables that
; the end user won't be able to change using putenv().  These variables will be
; protected even if safe_mode_allowed_env_vars is set to allow to change them.
safe_mode_protected_env_vars = LD_LIBRARY_PATH
 
; open_basedir, if set, limits all file operations to the defined directory
; and below.  This directive makes most sense if used in a per-directory
; or per-virtualhost web server configuration file. This directive is
; *NOT* affected by whether Safe Mode is turned On or Off.
;open_basedir =
 
; This directive allows you to disable certain functions for security reasons.
; It receives a comma-delimited list of function names. This directive is
; *NOT* affected by whether Safe Mode is turned On or Off.
disable_functions =
 
; This directive allows you to disable certain classes for security reasons.
; It receives a comma-delimited list of class names. This directive is
; *NOT* affected by whether Safe Mode is turned On or Off.
disable_classes =
 
; Colors for Syntax Highlighting mode.  Anything that's acceptable in
; <span style="color: ???????"> would work.
;highlight.string  = #DD0000
;highlight.comment = #FF9900
;highlight.keyword = #007700
;highlight.bg      = #FFFFFF
;highlight.default = #0000BB
;highlight.html    = #000000
 
; If enabled, the request will be allowed to complete even if the user aborts
; the request. Consider enabling it if executing long request, which may end up
; being interrupted by the user or a browser timing out.
; ignore_user_abort = On
 
; Determines the size of the realpath cache to be used by PHP. This value should
; be increased on systems where PHP opens many files to reflect the quantity of
; the file operations performed.
; realpath_cache_size=16k
 
; Duration of time, in seconds for which to cache realpath information for a given
; file or directory. For systems with rarely changing files, consider increasing this
; value.
; realpath_cache_ttl=120
 
;
; Misc
;
; Decides whether PHP may expose the fact that it is installed on the server
; (e.g. by adding its signature to the Web server header).  It is no security
; threat in any way, but it makes it possible to determine whether you use PHP
; on your server or not.
expose_php = On
 
 
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;
 
max_execution_time = 30     ; Maximum execution time of each script, in seconds
max_input_time = 60	; Maximum amount of time each script may spend parsing request data
memory_limit = 32M      ; Maximum amount of memory a script may consume (16MB)
 
 
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; Error handling and logging ;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
 
; error_reporting is a bit-field.  Or each number up to get desired error
; reporting level
; E_ALL             - All errors and warnings (doesn't include E_STRICT)
; E_ERROR           - fatal run-time errors
; E_RECOVERABLE_ERROR  - almost fatal run-time errors
; E_WARNING         - run-time warnings (non-fatal errors)
; E_PARSE           - compile-time parse errors
; E_NOTICE          - run-time notices (these are warnings which often result
;                     from a bug in your code, but it's possible that it was
;                     intentional (e.g., using an uninitialized variable and
;                     relying on the fact it's automatically initialized to an
;                     empty string)
; E_STRICT          - run-time notices, enable to have PHP suggest changes
;                     to your code which will ensure the best interoperability
;                     and forward compatibility of your code
; E_CORE_ERROR      - fatal errors that occur during PHP's initial startup
; E_CORE_WARNING    - warnings (non-fatal errors) that occur during PHP's
;                     initial startup
; E_COMPILE_ERROR   - fatal compile-time errors
; E_COMPILE_WARNING - compile-time warnings (non-fatal errors)
; E_USER_ERROR      - user-generated error message
; E_USER_WARNING    - user-generated warning message
; E_USER_NOTICE     - user-generated notice message
;
; Examples:
;
;   - Show all errors, except for notices and coding standards warnings
;
;error_reporting = E_ALL & ~E_NOTICE
;
;   - Show all errors, except for notices
;
;error_reporting = E_ALL & ~E_NOTICE | E_STRICT
;
;   - Show only errors
;
;error_reporting = E_COMPILE_ERROR|E_RECOVERABLE_ERROR|E_ERROR|E_CORE_ERROR
;
;   - Show all errors, except coding standards warnings
;
error_reporting  =  E_ALL
 
; Print out errors (as a part of the output).  For production web sites,
; you're strongly encouraged to turn this feature off, and use error logging
; instead (see below).  Keeping display_errors enabled on a production web site
; may reveal security information to end users, such as file paths on your Web
; server, your database schema or other information.
display_errors = Off
 
; Even when display_errors is on, errors that occur during PHP's startup
; sequence are not displayed.  It's strongly recommended to keep
; display_startup_errors off, except for when debugging.
display_startup_errors = Off
 
; Log errors into a log file (server-specific log, stderr, or error_log (below))
; As stated above, you're strongly advised to use error logging in place of
; error displaying on production web sites.
log_errors = On
 
; Set maximum length of log_errors. In error_log information about the source is
; added. The default is 1024 and 0 allows to not apply any maximum length at all.
log_errors_max_len = 1024
 
; Do not log repeated messages. Repeated errors must occur in same file on same
; line until ignore_repeated_source is set true.
ignore_repeated_errors = Off
 
; Ignore source of message when ignoring repeated messages. When this setting
; is On you will not log errors with repeated messages from different files or
; source lines.
ignore_repeated_source = Off
 
; If this parameter is set to Off, then memory leaks will not be shown (on
; stdout or in the log). This has only effect in a debug compile, and if
; error reporting includes E_WARNING in the allowed list
report_memleaks = On
 
;report_zend_debug = 0
 
; Store the last error/warning message in $php_errormsg (boolean).
track_errors = Off
 
; Disable the inclusion of HTML tags in error messages.
; Note: Never use this feature for production boxes.
;html_errors = Off
 
; If html_errors is set On PHP produces clickable error messages that direct
; to a page describing the error or function causing the error in detail.
; You can download a copy of the PHP manual from http://www.php.net/docs.php
; and change docref_root to the base URL of your local copy including the
; leading '/'. You must also specify the file extension being used including
; the dot.
; Note: Never use this feature for production boxes.
;docref_root = "/phpmanual/"
;docref_ext = .html
 
; String to output before an error message.
;error_prepend_string = "<font color=ff0000>"
 
; String to output after an error message.
;error_append_string = "</font>"
 
; Log errors to specified file.
;error_log = filename
 
; Log errors to syslog (Event Log on NT, not valid in Windows 95).
;error_log = syslog
 
 
;;;;;;;;;;;;;;;;;
; Data Handling ;
;;;;;;;;;;;;;;;;;
;
; Note - track_vars is ALWAYS enabled as of PHP 4.0.3
 
; The separator used in PHP generated URLs to separate arguments.
; Default is "&".
;arg_separator.output = "&amp;"
 
; List of separator(s) used by PHP to parse input URLs into variables.
; Default is "&".
; NOTE: Every character in this directive is considered as separator!
;arg_separator.input = ";&"
 
; This directive describes the order in which PHP registers GET, POST, Cookie,
; Environment and Built-in variables (G, P, C, E & S respectively, often
; referred to as EGPCS or GPC).  Registration is done from left to right, newer
; values override older values.
variables_order = "EGPCS"
 
; Whether or not to register the EGPCS variables as global variables.  You may
; want to turn this off if you don't want to clutter your scripts' global scope
; with user data.  This makes most sense when coupled with track_vars - in which
; case you can access all of the GPC variables through the $HTTP_*_VARS[],
; variables.
;
; You should do your best to write your scripts so that they do not require
; register_globals to be on;  Using form variables as globals can easily lead
; to possible security problems, if the code is not very well thought of.
register_globals = Off
 
; Whether or not to register the old-style input arrays, HTTP_GET_VARS
; and friends.  If you're not using them, it's recommended to turn them off,
; for performance reasons.
register_long_arrays = Off
 
; This directive tells PHP whether to declare the argv&argc variables (that
; would contain the GET information).  If you don't use these variables, you
; should turn it off for increased performance.
register_argc_argv = Off
 
; When enabled, the SERVER and ENV variables are created when they're first
; used (Just In Time) instead of when the script starts. If these variables
; are not used within a script, having this directive on will result in a
; performance gain. The PHP directives register_globals, register_long_arrays,
; and register_argc_argv must be disabled for this directive to have any affect.
auto_globals_jit = On
 
; Maximum size of POST data that PHP will accept.
post_max_size = 8M
 
; Magic quotes
;
 
; Magic quotes for incoming GET/POST/Cookie data.
magic_quotes_gpc = Off
 
; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc.
magic_quotes_runtime = Off
 
; Use Sybase-style magic quotes (escape ' with '' instead of \').
magic_quotes_sybase = Off
 
; Automatically add files before or after any PHP document.
auto_prepend_file =
auto_append_file =
 
; As of 4.0b4, PHP always outputs a character encoding by default in
; the Content-type: header.  To disable sending of the charset, simply
; set it to be empty.
;
; PHP's built-in default is text/html
default_mimetype = "text/html"
;default_charset = "iso-8859-1"
 
; Always populate the $HTTP_RAW_POST_DATA variable.
;always_populate_raw_post_data = On
 
 
;;;;;;;;;;;;;;;;;;;;;;;;;
; Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;
 
; UNIX: "/path1:/path2"
;include_path = ".:/php/includes"
;
; Windows: "\path1;\path2"
;include_path = ".;c:\php\includes"
 
; The root of the PHP pages, used only if nonempty.
; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root
; if you are running php as a CGI under any web server (other than IIS)
; see documentation for security issues.  The alternate is to use the
; cgi.force_redirect configuration below
doc_root =
 
; The directory under which PHP opens the script using /~username used only
; if nonempty.
user_dir =
 
; Directory in which the loadable extensions (modules) reside.
extension_dir = "/usr/lib/php/modules"
 
; Whether or not to enable the dl() function.  The dl() function does NOT work
; properly in multithreaded servers, such as IIS or Zeus, and is automatically
; disabled on them.
enable_dl = On
 
; cgi.force_redirect is necessary to provide security running PHP as a CGI under
; most web servers.  Left undefined, PHP turns this on by default.  You can
; turn it off here AT YOUR OWN RISK
; **You CAN safely turn this off for IIS, in fact, you MUST.**
; cgi.force_redirect = 1
 
; if cgi.nph is enabled it will force cgi to always sent Status: 200 with
; every request.
; cgi.nph = 1
 
; if cgi.force_redirect is turned on, and you are not running under Apache or Netscape
; (iPlanet) web servers, you MAY need to set an environment variable name that PHP
; will look for to know it is OK to continue execution.  Setting this variable MAY
; cause security issues, KNOW WHAT YOU ARE DOING FIRST.
; cgi.redirect_status_env = ;
 
; FastCGI under IIS (on WINNT based OS) supports the ability to impersonate
; security tokens of the calling client.  This allows IIS to define the
; security context that the request runs under.  mod_fastcgi under Apache
; does not currently support this feature (03/17/2002)
; Set to 1 if running under IIS.  Default is zero.
; fastcgi.impersonate = 1;
 
; Disable logging through FastCGI connection
; fastcgi.log = 0
 
; cgi.rfc2616_headers configuration option tells PHP what type of headers to
; use when sending HTTP response code. If it's set 0 PHP sends Status: header that
; is supported by Apache. When this option is set to 1 PHP will send
; RFC2616 compliant header.
; Default is zero.
;cgi.rfc2616_headers = 0
 
 
;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;
 
; Whether to allow HTTP file uploads.
file_uploads = On
 
; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
;upload_tmp_dir =
 
; Maximum allowed size for uploaded files.
upload_max_filesize = 2M
 
 
;;;;;;;;;;;;;;;;;;
; Fopen wrappers ;
;;;;;;;;;;;;;;;;;;
 
; Whether to allow the treatment of URLs (like http:// or ftp://) as files.
allow_url_fopen = On
 
; Whether to allow include/require to open URLs (like http:// or ftp://) as files.
allow_url_include = Off
 
; Define the anonymous ftp password (your email address)
;from="john@doe.com"
 
; Define the User-Agent string
; user_agent="PHP"
 
; Default timeout for socket based streams (seconds)
default_socket_timeout = 60
 
; If your scripts have to deal with files from Macintosh systems,
; or you are running on a Mac and need to deal with files from
; unix or win32 systems, setting this flag will cause PHP to
; automatically detect the EOL character in those files so that
; fgets() and file() will work regardless of the source of the file.
; auto_detect_line_endings = Off
 
 
;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
;
; If you wish to have an extension loaded automatically, use the following
; syntax:
;
;   extension=modulename.extension
;
; For example:
;
;   extension=msql.so
;
; Note that it should be the name of the module only; no directory information
; needs to go here.  Specify the location of the extension with the
; extension_dir directive above.
 
  
;;;;
; Note: packaged extension modules are now loaded via the .ini files
; found in the directory /etc/php.d; these are loaded by default.
;;;;
 
 
;;;;;;;;;;;;;;;;;;;
; Module Settings ;
;;;;;;;;;;;;;;;;;;;
 
[Date]
; Defines the default timezone used by the date functions
;date.timezone =
 
;date.default_latitude = 31.7667
;date.default_longitude = 35.2333
 
;date.sunrise_zenith = 90.583333
;date.sunset_zenith = 90.583333
 
[filter]
;filter.default = unsafe_raw
;filter.default_flags =
 
[iconv]
;iconv.input_encoding = ISO-8859-1
;iconv.internal_encoding = ISO-8859-1
;iconv.output_encoding = ISO-8859-1
 
[sqlite]
;sqlite.assoc_case = 0
 
[xmlrpc]
;xmlrpc_error_number = 0
;xmlrpc_errors = 0
 
[Pcre]
;pcre.recursion_limit=100000
;pcre.backtrack_limit=100000
 
[Syslog]
; Whether or not to define the various syslog variables (e.g. $LOG_PID,
; $LOG_CRON, etc.).  Turning it off is a good idea performance-wise.  In
; runtime, you can define these variables by calling define_syslog_variables().
define_syslog_variables  = Off
 
[mail function]
; For Win32 only.
SMTP = localhost
smtp_port = 25
 
; For Win32 only.
;sendmail_from = me@example.com
 
; For Unix only.  You may supply arguments as well (default: "sendmail -t -i").
sendmail_path = /usr/sbin/sendmail -t -i
 
; Force the addition of the specified parameters to be passed as extra parameters
; to the sendmail binary. These parameters will always replace the value of
; the 5th parameter to mail(), even in safe mode.
;mail.force_extra_parameters =
 
[SQL]
sql.safe_mode = Off
 
[ODBC]
;odbc.default_db    =  Not yet implemented
;odbc.default_user  =  Not yet implemented
;odbc.default_pw    =  Not yet implemented
 
; Allow or prevent persistent links.
odbc.allow_persistent = On
 
; Check that a connection is still valid before reuse.
odbc.check_persistent = On
 
; Maximum number of persistent links.  -1 means no limit.
odbc.max_persistent = -1
 
; Maximum number of links (persistent + non-persistent).  -1 means no limit.
odbc.max_links = -1
 
; Handling of LONG fields.  Returns number of bytes to variables.  0 means
; passthru.
odbc.defaultlrl = 4096
 
; Handling of binary data.  0 means passthru, 1 return as is, 2 convert to char.
; See the documentation on odbc_binmode and odbc_longreadlen for an explanation
; of uodbc.defaultlrl and uodbc.defaultbinmode
odbc.defaultbinmode = 1
 
[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On
 
; Maximum number of persistent links.  -1 means no limit.
mysql.max_persistent = -1
 
; Maximum number of links (persistent + non-persistent).  -1 means no limit.
mysql.max_links = -1
 
; Default port number for mysql_connect().  If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
mysql.default_port =
 
; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =
 
; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =
 
; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =
 
; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password =
 
; Maximum time (in seconds) for connect timeout. -1 means no limit
mysql.connect_timeout = 60
 
; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Errors will be displayed.
mysql.trace_mode = Off
 
[MySQLi]
 
; Maximum number of links.  -1 means no limit.
mysqli.max_links = -1
 
; Default port number for mysqli_connect().  If unset, mysqli_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
mysqli.default_port = 3306
 
; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysqli.default_socket =
 
; Default host for mysql_connect() (doesn't apply in safe mode).
mysqli.default_host =
 
; Default user for mysql_connect() (doesn't apply in safe mode).
mysqli.default_user =
 
; Default password for mysqli_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysqli.default_pw")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysqli.default_pw =
 
; Allow or prevent reconnect
mysqli.reconnect = Off
 
[mSQL]
; Allow or prevent persistent links.
msql.allow_persistent = On
 
; Maximum number of persistent links.  -1 means no limit.
msql.max_persistent = -1
 
; Maximum number of links (persistent+non persistent).  -1 means no limit.
msql.max_links = -1
 
[PostgresSQL]
; Allow or prevent persistent links.
pgsql.allow_persistent = On
 
; Detect broken persistent links always with pg_pconnect().
; Auto reset feature requires a little overheads.
pgsql.auto_reset_persistent = Off
 
; Maximum number of persistent links.  -1 means no limit.
pgsql.max_persistent = -1
 
; Maximum number of links (persistent+non persistent).  -1 means no limit.
pgsql.max_links = -1
 
; Ignore PostgreSQL backends Notice message or not.
; Notice message logging require a little overheads.
pgsql.ignore_notice = 0
 
; Log PostgreSQL backends Noitce message or not.
; Unless pgsql.ignore_notice=0, module cannot log notice message.
pgsql.log_notice = 0
 
[Sybase]
; Allow or prevent persistent links.
sybase.allow_persistent = On
 
; Maximum number of persistent links.  -1 means no limit.
sybase.max_persistent = -1
 
; Maximum number of links (persistent + non-persistent).  -1 means no limit.
sybase.max_links = -1
 
;sybase.interface_file = "/usr/sybase/interfaces"
 
; Minimum error severity to display.
sybase.min_error_severity = 10
 
; Minimum message severity to display.
sybase.min_message_severity = 10
 
; Compatibility mode with old versions of PHP 3.0.
; If on, this will cause PHP to automatically assign types to results according
; to their Sybase type, instead of treating them all as strings.  This
; compatibility mode will probably not stay around forever, so try applying
; whatever necessary changes to your code, and turn it off.
sybase.compatability_mode = Off
 
[Sybase-CT]
; Allow or prevent persistent links.
sybct.allow_persistent = On
 
; Maximum number of persistent links.  -1 means no limit.
sybct.max_persistent = -1
 
; Maximum number of links (persistent + non-persistent).  -1 means no limit.
sybct.max_links = -1
 
; Minimum server message severity to display.
sybct.min_server_severity = 10
 
; Minimum client message severity to display.
sybct.min_client_severity = 10
 
[bcmath]
; Number of decimal digits for all bcmath functions.
bcmath.scale = 0
 
[browscap]
;browscap = extra/browscap.ini
 
[Informix]
; Default host for ifx_connect() (doesn't apply in safe mode).
ifx.default_host =
 
; Default user for ifx_connect() (doesn't apply in safe mode).
ifx.default_user =
 
; Default password for ifx_connect() (doesn't apply in safe mode).
ifx.default_password =
 
; Allow or prevent persistent links.
ifx.allow_persistent = On
 
; Maximum number of persistent links.  -1 means no limit.
ifx.max_persistent = -1
 
; Maximum number of links (persistent + non-persistent).  -1 means no limit.
ifx.max_links = -1
 
; If on, select statements return the contents of a text blob instead of its id.
ifx.textasvarchar = 0
 
; If on, select statements return the contents of a byte blob instead of its id.
ifx.byteasvarchar = 0
 
; Trailing blanks are stripped from fixed-length char columns.  May help the
; life of Informix SE users.
ifx.charasvarchar = 0
 
; If on, the contents of text and byte blobs are dumped to a file instead of
; keeping them in memory.
ifx.blobinfile = 0
 
; NULL's are returned as empty strings, unless this is set to 1.  In that case,
; NULL's are returned as string 'NULL'.
ifx.nullformat = 0
 
[Session]
; Handler used to store/retrieve data.
session.save_handler = files
 
; Argument passed to save_handler.  In the case of files, this is the path
; where data files are stored. Note: Windows users have to change this
; variable in order to use PHP's session functions.
;
; As of PHP 4.0.1, you can define the path as:
;
;     session.save_path = "N;/path"
;
; where N is an integer.  Instead of storing all the session files in
; /path, what this will do is use subdirectories N-levels deep, and
; store the session data in those directories.  This is useful if you
; or your OS have problems with lots of files in one directory, and is
; a more efficient layout for servers that handle lots of sessions.
;
; NOTE 1: PHP will not create this directory structure automatically.
;         You can use the script in the ext/session dir for that purpose.
; NOTE 2: See the section on garbage collection below if you choose to
;         use subdirectories for session storage
;
; The file storage module creates files using mode 600 by default.
; You can change that by using
;
;     session.save_path = "N;MODE;/path"
;
; where MODE is the octal representation of the mode. Note that this
; does not overwrite the process's umask.
session.save_path = "/var/lib/php/session"
 
; Whether to use cookies.
session.use_cookies = 1
 
; This option enables administrators to make their users invulnerable to
; attacks which involve passing session ids in URLs; defaults to 0.
; session.use_only_cookies = 1
 
; Name of the session (used as cookie name).
session.name = PHPSESSID
 
; Initialize session on request startup.
session.auto_start = 0
 
; Lifetime in seconds of cookie or, if 0, until browser is restarted.
session.cookie_lifetime = 0
 
; The path for which the cookie is valid.
session.cookie_path = /
 
; The domain for which the cookie is valid.
session.cookie_domain =
 
; Whether or not to add the httpOnly flag to the cookie, which makes it inaccessible to browser scripting languages such as JavaScript.
session.cookie_httponly = 
 
; Handler used to serialize data.  php is the standard serializer of PHP.
session.serialize_handler = php
 
; Define the probability that the 'garbage collection' process is started
; on every session initialization.
; The probability is calculated by using gc_probability/gc_divisor,
; e.g. 1/100 means there is a 1% chance that the GC process starts
; on each request.
 
session.gc_probability = 1
session.gc_divisor     = 1000
 
; After this number of seconds, stored data will be seen as 'garbage' and
; cleaned up by the garbage collection process.
session.gc_maxlifetime = 1440
 
; NOTE: If you are using the subdirectory option for storing session files
;       (see session.save_path above), then garbage collection does *not*
;       happen automatically.  You will need to do your own garbage
;       collection through a shell script, cron entry, or some other method.
;       For example, the following script would is the equivalent of
;       setting session.gc_maxlifetime to 1440 (1440 seconds = 24 minutes):
;          cd /path/to/sessions; find -cmin +24 | xargs rm
 
; PHP 4.2 and less have an undocumented feature/bug that allows you to
; to initialize a session variable in the global scope, albeit register_globals
; is disabled.  PHP 4.3 and later will warn you, if this feature is used.
; You can disable the feature and the warning separately. At this time,
; the warning is only displayed, if bug_compat_42 is enabled.
 
session.bug_compat_42 = 0
session.bug_compat_warn = 1
 
; Check HTTP Referer to invalidate externally stored URLs containing ids.
; HTTP_REFERER has to contain this substring for the session to be
; considered as valid.
session.referer_check =
 
; How many bytes to read from the file.
session.entropy_length = 0
 
; Specified here to create the session id.
session.entropy_file =
 
;session.entropy_length = 16
 
;session.entropy_file = /dev/urandom
 
; Set to {nocache,private,public,} to determine HTTP caching aspects
; or leave this empty to avoid sending anti-caching headers.
session.cache_limiter = nocache
 
; Document expires after n minutes.
session.cache_expire = 180
 
; trans sid support is disabled by default.
; Use of trans sid may risk your users security.
; Use this option with caution.
; - User may send URL contains active session ID
;   to other person via. email/irc/etc.
; - URL that contains active session ID may be stored
;   in publically accessible computer.
; - User may access your site with the same session ID
;   always using URL stored in browser's history or bookmarks.
session.use_trans_sid = 0
 
; Select a hash function
; 0: MD5   (128 bits)
; 1: SHA-1 (160 bits)
session.hash_function = 0
 
; Define how many bits are stored in each character when converting
; the binary hash data to something readable.
;
; 4 bits: 0-9, a-f
; 5 bits: 0-9, a-v
; 6 bits: 0-9, a-z, A-Z, "-", ","
session.hash_bits_per_character = 5
 
; The URL rewriter will look for URLs in a defined set of HTML tags.
; form/fieldset are special; if you include them here, the rewriter will
; add a hidden <input> field with the info which is otherwise appended
; to URLs.  If you want XHTML conformity, remove the form entry.
; Note that all valid entries require a "=", even if no value follows.
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=fakeentry"
 
[MSSQL]
; Allow or prevent persistent links.
mssql.allow_persistent = On
 
; Maximum number of persistent links.  -1 means no limit.
mssql.max_persistent = -1
 
; Maximum number of links (persistent+non persistent).  -1 means no limit.
mssql.max_links = -1
 
; Minimum error severity to display.
mssql.min_error_severity = 10
 
; Minimum message severity to display.
mssql.min_message_severity = 10
 
; Compatibility mode with old versions of PHP 3.0.
mssql.compatability_mode = Off
 
; Connect timeout
;mssql.connect_timeout = 5
 
; Query timeout
;mssql.timeout = 60
 
; Valid range 0 - 2147483647.  Default = 4096.
;mssql.textlimit = 4096
 
; Valid range 0 - 2147483647.  Default = 4096.
;mssql.textsize = 4096
 
; Limits the number of records in each batch.  0 = all records in one batch.
;mssql.batchsize = 0
 
; Specify how datetime and datetim4 columns are returned
; On => Returns data converted to SQL server settings
; Off => Returns values as YYYY-MM-DD hh:mm:ss
;mssql.datetimeconvert = On
 
; Use NT authentication when connecting to the server
mssql.secure_connection = Off
 
; Specify max number of processes. -1 = library default
; msdlib defaults to 25
; FreeTDS defaults to 4096
;mssql.max_procs = -1
 
; Specify client character set. 
; If empty or not set the client charset from freetds.comf is used
; This is only used when compiled with FreeTDS
;mssql.charset = "ISO-8859-1"
 
[Assertion]
; Assert(expr); active by default.
;assert.active = On
 
; Issue a PHP warning for each failed assertion.
;assert.warning = On
 
; Don't bail out by default.
;assert.bail = Off
 
; User-function to be called if an assertion fails.
;assert.callback = 0
 
; Eval the expression with current error_reporting().  Set to true if you want
; error_reporting(0) around the eval().
;assert.quiet_eval = 0
 
[COM]
; path to a file containing GUIDs, IIDs or filenames of files with TypeLibs
;com.typelib_file =
; allow Distributed-COM calls
;com.allow_dcom = true
; autoregister constants of a components typlib on com_load()
;com.autoregister_typelib = true
; register constants casesensitive
;com.autoregister_casesensitive = false
; show warnings on duplicate constant registrations
;com.autoregister_verbose = true
 
[mbstring]
; language for internal character representation.
;mbstring.language = Japanese
 
; internal/script encoding.
; Some encoding cannot work as internal encoding.
; (e.g. SJIS, BIG5, ISO-2022-*)
;mbstring.internal_encoding = EUC-JP
 
; http input encoding.
;mbstring.http_input = auto
 
; http output encoding. mb_output_handler must be
; registered as output buffer to function
;mbstring.http_output = SJIS
 
; enable automatic encoding translation according to
; mbstring.internal_encoding setting. Input chars are
; converted to internal encoding by setting this to On.
; Note: Do _not_ use automatic encoding translation for
;       portable libs/applications.
;mbstring.encoding_translation = Off
 
; automatic encoding detection order.
; auto means
;mbstring.detect_order = auto
 
; substitute_character used when character cannot be converted
; one from another
;mbstring.substitute_character = none;
 
; overload(replace) single byte functions by mbstring functions.
; mail(), ereg(), etc are overloaded by mb_send_mail(), mb_ereg(),
; etc. Possible values are 0,1,2,4 or combination of them.
; For example, 7 for overload everything.
; 0: No overload
; 1: Overload mail() function
; 2: Overload str*() functions
; 4: Overload ereg*() functions
;mbstring.func_overload = 0
 
; enable strict encoding detection.
;mbstring.strict_encoding = Off
 
[FrontBase]
;fbsql.allow_persistent = On
;fbsql.autocommit = On
;fbsql.show_timestamp_decimals = Off
;fbsql.default_database =
;fbsql.default_database_password =
;fbsql.default_host =
;fbsql.default_password =
;fbsql.default_user = "_SYSTEM"
;fbsql.generate_warnings = Off
;fbsql.max_connections = 128
;fbsql.max_links = 128
;fbsql.max_persistent = -1
;fbsql.max_results = 128
 
[gd]
; Tell the jpeg decode to libjpeg warnings and try to create
; a gd image. The warning will then be displayed as notices
; disabled by default
;gd.jpeg_ignore_warning = 0
 
[exif]
; Exif UNICODE user comments are handled as UCS-2BE/UCS-2LE and JIS as JIS.
; With mbstring support this will automatically be converted into the encoding
; given by corresponding encode setting. When empty mbstring.internal_encoding
; is used. For the decode settings you can distinguish between motorola and
; intel byte order. A decode setting cannot be empty.
;exif.encode_unicode = ISO-8859-15
;exif.decode_unicode_motorola = UCS-2BE
;exif.decode_unicode_intel    = UCS-2LE
;exif.encode_jis =
;exif.decode_jis_motorola = JIS
;exif.decode_jis_intel    = JIS
 
[Tidy]
; The path to a default tidy configuration file to use when using tidy
;tidy.default_config = /usr/local/lib/php/default.tcfg
 
; Should tidy clean and repair output automatically?
; WARNING: Do not use this option if you are generating non-html content
; such as dynamic images
tidy.clean_output = Off
 
[soap]
; Enables or disables WSDL caching feature.
soap.wsdl_cache_enabled=1
; Sets the directory name where SOAP extension will put cache files.
soap.wsdl_cache_dir="/tmp"
; (time to live) Sets the number of second while cached file will be used 
; instead of original one.
soap.wsdl_cache_ttl=86400
 
; Local Variables:
; tab-width: 4
; End:

                                              
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:
370:
371:
372:
373:
374:
375:
376:
377:
378:
379:
380:
381:
382:
383:
384:
385:
386:
387:
388:
389:
390:
391:
392:
393:
394:
395:
396:
397:
398:
399:
400:
401:
402:
403:
404:
405:
406:
407:
408:
409:
410:
411:
412:
413:
414:
415:
416:
417:
418:
419:
420:
421:
422:
423:
424:
425:
426:
427:
428:
429:
430:
431:
432:
433:
434:
435:
436:
437:
438:
439:
440:
441:
442:
443:
444:
445:
446:
447:
448:
449:
450:
451:
452:
453:
454:
455:
456:
457:
458:
459:
460:
461:
462:
463:
464:
465:
466:
467:
468:
469:
470:
471:
472:
473:
474:
475:
476:
477:
478:
479:
480:
481:
482:
483:
484:
485:
486:
487:
488:
489:
490:
491:
492:
493:
494:
495:
496:
497:
498:
499:
500:
501:
502:
503:
504:
505:
506:
507:
508:
509:
510:
511:
512:
513:
514:
515:
516:
517:
518:
519:
520:
521:
522:
523:
524:
525:
526:
527:
528:
529:
530:
531:
532:
533:
534:
535:
536:
537:
538:
539:
540:
541:
542:
543:
544:
545:
546:
547:
548:
549:
550:
551:
552:
553:
554:
555:
556:
557:
558:
559:
560:
561:
562:
563:
564:
565:
566:
567:
568:
569:
570:
571:
572:
573:
574:
575:
576:
577:
578:
579:
580:
581:
582:
583:
584:
585:
586:
587:
588:
589:
590:
591:
592:
593:
594:
595:
596:
597:
598:
599:
600:
601:
602:
603:
604:
605:
606:
607:
608:
609:
610:
611:
612:
613:
614:
615:
616:
617:
618:
619:
620:
621:
622:
623:
624:
625:
626:
627:
628:
629:
630:
631:
632:
633:
634:
635:
636:
637:
638:
639:
640:
641:
642:
643:
644:
645:
646:
647:
648:
649:
650:
651:
652:
653:
654:
655:
656:
657:
658:
659:
660:
661:
662:
663:
664:
665:
666:
667:
668:
669:
670:
671:
672:
673:
674:
675:
676:
677:
678:
679:
680:
681:
682:
683:
684:
685:
686:
687:
688:
689:
690:
691:
692:
693:
694:
695:
696:
697:
698:
699:
700:
701:
702:
703:
704:
705:
706:
707:
708:
709:
710:
711:
712:
713:
714:
715:
716:
717:
718:
719:
720:
721:
722:
723:
724:
725:
726:
727:
728:
729:
730:
731:
732:
733:
734:
735:
736:
737:
738:
739:
740:
741:
742:
743:
744:
745:
746:
747:
748:
749:
750:
751:
752:
753:
754:
755:
756:
757:
758:
759:
760:
761:
762:
763:
764:
765:
766:
767:
768:
769:
770:
771:
772:
773:
774:
775:
776:
777:
778:
779:
780:
781:
782:
783:
784:
785:
786:
787:
788:
789:
790:
791:
792:
793:
794:
795:
796:
797:
798:
799:
800:
801:
802:
803:
804:
805:
806:
807:
808:
809:
810:
811:
812:
813:
814:
815:
816:
817:
818:
819:
820:
821:
822:
823:
824:
825:
826:
827:
828:
829:
830:
831:
832:
833:
834:
835:
836:
837:
838:
839:
840:
841:
842:
843:
844:
845:
846:
847:
848:
849:
850:
851:
852:
853:
854:
855:
856:
857:
858:
859:
860:
861:
862:
863:
864:
865:
866:
867:
868:
869:
870:
871:
872:
873:
874:
875:
876:
877:
878:
879:
880:
881:
882:
883:
884:
885:
886:
887:
888:
889:
890:
891:
892:
893:
894:
895:
896:
897:
898:
899:
900:
901:
902:
903:
904:
905:
906:
907:
908:
909:
910:
911:
912:
913:
914:
915:
916:
917:
918:
919:
920:
921:
922:
923:
924:
925:
926:
927:
928:
929:
930:
931:
932:
933:
934:
935:
936:
937:
938:
939:
940:
941:
942:
943:
944:
945:
946:
947:
948:
949:
950:
951:
952:
953:
954:
955:
956:
957:
958:
959:
960:
961:
962:
963:
964:
965:
966:
967:
968:
969:
970:
971:
972:
973:
974:
975:
976:
977:
978:
979:
980:
981:
982:
983:
984:
985:
986:
987:
988:
989:
990:
991:
992:
993:
994:
995:
996:
997:
998:
999:
1000:
1001:
1002:
1003:
1004:
1005:
1006:
1007:
1008:
1009:
1010:
1011:
1012:
1013:
1014:
1015:
1016:
1017:
1018:
1019:
1020:
1021:
1022:
1023:
1024:
1025:
1026:
1027:
1028:
1029:
1030:
1031:
1032:
1033:
1034:
1035:
1036:
1037:
1038:
1039:
1040:
1041:
1042:
1043:
1044:
1045:
1046:
1047:
1048:
1049:
1050:
1051:
1052:
1053:
1054:
1055:
1056:
1057:
1058:
1059:
1060:
1061:
1062:
1063:
1064:
1065:
1066:
1067:
1068:
1069:
1070:
1071:
1072:
1073:
1074:
1075:
1076:
1077:
1078:
1079:
1080:
1081:
1082:
1083:
1084:
1085:
1086:
1087:
1088:
1089:
1090:
1091:
1092:
1093:
1094:
1095:
1096:
1097:
1098:
1099:
1100:
1101:
1102:
1103:
1104:
1105:
1106:
1107:
1108:
1109:
1110:
1111:
1112:
1113:
1114:
1115:
1116:
1117:
1118:
1119:
1120:
1121:
1122:
1123:
1124:
1125:
1126:
1127:
1128:
1129:
1130:
1131:
1132:
1133:
1134:
1135:
1136:
1137:
1138:
1139:
1140:
1141:
1142:
1143:
1144:
1145:
1146:
1147:
1148:
1149:
1150:
1151:
1152:
1153:
1154:
1155:
1156:
1157:
1158:
1159:
1160:
1161:
1162:
1163:
1164:
1165:
1166:
1167:
1168:
1169:
1170:
1171:
1172:
1173:
1174:
1175:
1176:
1177:
1178:
1179:
1180:
1181:
1182:
1183:
1184:
1185:
1186:
1187:
1188:
1189:
1190:
1191:
1192:
1193:
1194:
1195:
1196:
1197:
1198:
1199:
1200:
1201:
1202:
1203:
1204:
1205:
1206:
1207:
1208:
1209:
1210:
1211:
1212:
1213:
1214:
1215:
1216:
1217:
1218:
1219:
1220:
1221:
1222:

Select allOpen in new window

 

by: gheistPosted on 2008-05-19 at 18:28:59ID: 21602925

It is usually something called modules.ini or files in /etc/php.d that contains module=php_mssql.so (look where some other module is loaded to do it correctly)

 

by: EMB01Posted on 2008-05-20 at 12:41:45ID: 21609628

I don't have any modules.ini file or any php_mssql modules in my /etc/php.d folder. The following is a list of all of the files in the folder:
 dbase.ini
 dom.ini
 gd.ini
 imap.ini
 ioncube-loader.ini
 json.ini
 ldap.ini
 mbstring.ini
 mcrypt.ini
 mssql.ini
 mysql.ini
 mysqli.ini
 ncurses.ini    
 odbc.ini
 pdo.ini
 pdo_mysql.ini  
 pdo_odbc.ini
 pdo_sqlite.ini
 snmp.ini
 xmlreader.ini
 xmlrpc.ini  
 xmlwriter.ini      
 xsl.ini
 zip.ini

 

by: gheistPosted on 2008-05-21 at 23:35:09ID: 21621411

Is it that hard - examine suspect file if module is loaded.

 

by: EMB01Posted on 2008-05-22 at 03:33:01ID: 21622496

Well, I suppose it shouldn't be so hard; but then again I am extremely new to all of this. So, when you say something like "examine suspect file if module is loaded" I have very little idea what you are talking about. You'll have to dumb it down for me as I am very new to this. Sorry for the misunderstanding.

 

by: gheistPosted on 2008-05-22 at 05:15:13ID: 21623003

Ask google...

 

by: EMB01Posted on 2008-05-23 at 11:12:21ID: 21634375

... Thanks for your help.

 

by: gheistPosted on 2008-05-23 at 11:14:19ID: 21634388

extension=php_mssql.so ;)

 

by: EMB01Posted on 2008-05-23 at 14:45:26ID: 21636047

See, I added that to my php.ini file; but still I get this "Call to undefined function" error. It seems even after I installed the php_mssql extension via Yum, the php_mssql file is no where to be found...

 

by: EMB01Posted on 2008-05-25 at 15:04:30ID: 21643774

After I installed it; shouldn't it be in my /etc/php.d folder? I sent you the list of all the files there and it's not on that list.

 

by: gheistPosted on 2008-05-26 at 01:21:15ID: 21645257

i see mssql.ini right there. examine that file, it must contain commented out extension line or smth like that.

 

by: EMB01Posted on 2008-05-26 at 08:04:16ID: 21646734

In my mssql.ini file, it reads:
; Enable mssql extension module
extension=mssql.so

Thank you.

 

by: gheistPosted on 2008-05-26 at 12:16:03ID: 21647685

Then it loads or says something in error log... I dont know. If there is a problem it is hidden from www admin gui

 

by: EMB01Posted on 2008-05-26 at 13:49:56ID: 21648045

If you could tell me how to retrieve the error log where the error may be found, it would really be a great help as I could give it to MediaTemple and they would take it from there (if there were a problem with the server).

 

by: gheistPosted on 2008-05-26 at 13:53:40ID: 21648060

Examine httpd.conf for ErrorLog directives.
Usually [httpd-|apache-]error.log under /var/log[/|/apache|/httpd]
php complains loudly about unloadable modules

Under normal circumstances you would run php from command line (php-cli package) and it will show all errors encountered.

 

by: EMB01Posted on 2008-05-26 at 14:47:21ID: 21648235

I'll check the error log and see what's up. Does it matter that my PHP is in Safe Mode?

 

by: gheistPosted on 2008-05-27 at 01:03:37ID: 21650140

There is no problem with connecting databases in safe mode.
Safe mode isolates different php pages better inside same interpreter like dnies setting global variables etc.

 

by: EMB01Posted on 2008-05-29 at 06:56:37ID: 21669120

When I use PHP-CLI to perform the command "php -e" the receive the following response:
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/magickwand.so' - /usr/lib/php/modules/magickwand.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/php_mssql.so' - /usr/lib/php/modules/php_mssql.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: mssql: Unable to initialize module
Module compiled with module API=20050922, debug=0, thread-safety=0
PHP    compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
 in Unknown on line 0

Thanks again for your help.

 

by: gheistPosted on 2008-05-29 at 07:02:21ID: 21669168

PHP Warning:  PHP Startup: mssql: Unable to initialize module
Module compiled with module API=20050922, debug=0, thread-safety=0
PHP    compiled with module API=20060613, debug=0, thread-safety=0

these are different revisons of PHP and extension. they are doomed to fail. Either update PHP or ger mssql module for running PHP.

 

by: EMB01Posted on 2008-05-29 at 07:34:55ID: 21669477

I would assume it is easier to get an MSSQL module for the running PHP. Could please instruct me how to find it?

 

by: gheistPosted on 2008-05-30 at 00:14:11ID: 21675787

I am not expert with rpm installations. You should use yum to list previous versions in repository or upgrade everything php-related to latest patched.

 

by: EMB01Posted on 2008-05-30 at 12:43:48ID: 21680832

Okay, could you please clarify that a little further? The goal here is to get the two, PHP and the Module, of the same API - correct? What's the easiest thing for me to do? Thank you.

 

by: gheistPosted on 2008-05-30 at 13:21:55ID: 21681139

yum check-update
yum update php
(found on google)

 

by: EMB01Posted on 2008-05-30 at 14:07:53ID: 21681442

Thanks, I'll give that a try. I don't even know the basics of this stuff! You see, I seem to have just jumped right into it... Would you recommend any books or materials that may help me learn these matters?

 

by: EMB01Posted on 2008-06-01 at 13:58:23ID: 21688400

I tried the commands; then it returned "Could not find update match for php. No Packages marked for Update/Obsoletion." Apparantly, the default Yum repositories on CentOS don't include php-mssql. So, I'm going to try following this tutorial (http://www.howtoforge.com/installing_php_mssql_centos5.0) and I'll post the result.

 

by: gheistPosted on 2008-06-02 at 00:08:31ID: 21690067

What stuff??? Just type "man ld.so"

 

by: EMB01Posted on 2008-06-02 at 04:04:02ID: 21690918

Stuff, meaning anything concerning linux/ unix/ shell commands/ etc. I'll give that a shot this afternoon. In the mean time if you get a chance, could you explain what that will do for me (man ld.so)?

 

by: gheistPosted on 2008-06-02 at 05:27:08ID: 21691327

Shared library loader, versioning and other dynamic linker features - like NOT loading outdated modules into apache and NOT loading newer mssql.so into php.
"help" or "man intro" commands introduce you to system

 

by: EMB01Posted on 2008-06-02 at 15:40:54ID: 21696305

How can I use ld.so functions to download the php-mssql extension?

 

by: gheistPosted on 2008-06-03 at 06:20:37ID: 21700066

I am no expert in YUM or RPM. ODBC suffered from same versioning problem.
There should be documentation on centos site. Upgrade usually gets consistent package versions, at least one can complain if it does not.

 

by: EMB01Posted on 2008-06-03 at 12:46:06ID: 21703857

Which upgrade gets consistent package versions?

 

by: gheistPosted on 2008-06-04 at 08:18:15ID: 21710970

fsckin system upgrade as described on centos site.

 

by: EMB01Posted on 2008-06-05 at 07:04:34ID: 21719503

I looked at centos.org and fsckin.com and I can't find any instructions to upgrade the system. Can you help with this?

 

by: gheistPosted on 2008-06-05 at 07:58:46ID: 21720266

Type in browsers address bar (white rectangular area on top of topmost window in your internet program)

http://www.google.si/search?q=yum+site%3A.centos.org

 

by: EMB01Posted on 2008-06-05 at 08:54:25ID: 21720957

I don't know if this is what you meant (although, you were very clear with how to copy and paste...) but I ran 'yum update' to update my system with Yum. What's next - try to install php-mssql - again?

 

by: gheistPosted on 2008-06-05 at 11:53:03ID: 21722740

your php and apache now are up to date as CentOS sees it.
check if php prints mssql-related errors - if so then php-mssql package is from different build and needs to be removed

rpm -e php-mssql

then use yum to install centos built version which should be consitent with your installed php.

now verify again - maybe some base tds libraries are non-centos and need to be reinstalled same way.

 

by: EMB01Posted on 2008-06-05 at 12:15:00ID: 21722958

I tried connecting using my script and it was unsuccessful. Then, I checked the PHP error log (php -e) and it still says:
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/magickwand.so' - /usr/lib/php/modules/magickwand.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/php_mssql.so' - /usr/lib/php/modules/php_mssql.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning:  PHP Startup: mssql: Unable to initialize module
Module compiled with module API=20050922, debug=0, thread-safety=0
PHP    compiled with module API=20060613, debug=0, thread-safety=0
These options need to match

So, I reinstalled php-mssql with Yum (after removing it with RPM) and tried testing the connection - it didn't work, then I checked the error log (above). This is the same error as before; however, I downloaded the new module so this shouldn't happen, right? Do you want me to try reinstalling FreeTDS? If so, do I just type 'yum install freetds'?

 

by: gheistPosted on 2008-06-05 at 12:53:28ID: 21723288

I suggest you run ldd /usr/lib/php/modules/mssql.so (i guess it is called so based on similarity to RHEL)

 

by: EMB01Posted on 2008-06-06 at 11:51:24ID: 21731767

"ldd /usr/lib/php/modules/mssql.so" returns:
        libsybdb.so.5 => /usr/lib/libsybdb.so.5 (0xb7f7e000)
        libc.so.6 => /lib/libc.so.6 (0xb7e3e000)
        /lib/ld-linux.so.2 (0xb7fe7000)

You might find this interesting... I don't really know what it means but you may find a relation: http://www.electrictoolbox.com/install-php-mssql-centos-5/

 

by: gheistPosted on 2008-06-07 at 00:13:52ID: 21734521

Web link provides build instructions. Basically rpmbuild does as described, and people at redhat and centos are quite aware of solution once they encounter problems.

Your PHP module dependencies are perfectly fine

http://php.net/manual/en/function.mssql-connect.php
Please use tcp port for connection string, sometimes port is not present in /etc/services and shared sybase/mssql code called tds cannot guess

 

by: EMB01Posted on 2008-06-07 at 04:50:59ID: 21735117

We are using TCP Port 1433. The script below is what I am using to connect which doesn't work:
$conn = mssql_connect($dsn, $user, $password);

if ($conn != FALSE)
{
print "The connection to the server was made.";
}
else
{
print "The connection to the server failed.";
}

 

by: gheistPosted on 2008-06-07 at 13:03:27ID: 21736639

What is the content of $dsn ???
coud you make it is '1.2.3.4,1443'

 

by: EMB01Posted on 2008-06-07 at 14:25:54ID: 21736830

Yes, that is the DSN. Still the error "Call to undefined function: MSSQL_CONNECT" persists. The only other thing I can think of doing is following one of the posted tutorials for installing MSSQL on CentOS - but then I have to install php.spec... Can I install that with Yum?

 

by: gheistPosted on 2008-06-07 at 23:25:01ID: 21737702

*.spec is file that describes how to build rpm on rpm systems. it is usually part of source rpm package, ir sometimes of source tarball...

Are you able to connect SQL database using telnet or nc? Maybe there is some network barrier in the middle to prevent slammer worms?

 

by: gheistPosted on 2008-06-07 at 23:28:14ID: 21737707

There is detailed description on how to set up sql server auth mechanisms when connecting using PHP - there might me something in sql servers logs relating to authentication problems.

 

by: EMB01Posted on 2008-06-08 at 04:21:37ID: 21738112

I havn't tried Telnet or Netcat - doesn't Telnet require there be something installed on the MSSQL server? Do you mean to look at the SQL logs on my server or on the MSSQL server? I would really like to figure out why I can't simply install this php-mssql extension on my server. Could you tell me why I don't have a file under /usr/src/redhat/SPECS/php.spec - because that's the only thing holding me up from completing the tutorial that claims to install php-mssql on CentOS 5. I would atleast like to try completing this tutorial as nothing else seems to work. Thanks for your help.

 

by: gheistPosted on 2008-06-08 at 08:14:50ID: 21738604

I want you to check basic network connectivity - whether you can connect using tcp protocol to SQL server.

Yes there is SQL server setup required - you have to enable Mixed Mode authentication, TCP/IP and Pipes network protocols.

 

by: EMB01Posted on 2008-06-08 at 09:06:19ID: 21738750

I tried connecting using "tsql" and failed receiving "The server does not exist..." or something to that effect. If there is additional setup to be done on the MSSQL server, I will have to instruct the administrator to do so. He said he has already granted access for my IP.

 

by: gheistPosted on 2008-06-08 at 10:32:02ID: 21738969

This confirms network problem, which is unsolvable using your linux system.

 

by: EMB01Posted on 2008-06-08 at 10:56:02ID: 21739033

Could you tell me (more precisely so that I may explain to the MSSQL administrator) what needs to be done to the MSSQL server - Mixed Mode authentication, TCP/IP and Pipes network protocols, etc...

 

by: gheistPosted on 2008-06-08 at 11:53:39ID: 21739180

http;//php.net/mssql

 

by: EMB01Posted on 2008-06-09 at 03:29:29ID: 21742059

One last question: My host recently updated the thread concerning issues with the MSSQL connectivity. The post:
"I was able to successfully install the FreeTDS RPM on a (dv) 3.5 after installing a backwards-compatibility package for readline, that will allow readline 4 to be accessed while readline 5 is installed.

The package I found (by searching rpmfind.net for libreadline.so.4) is located here:

ftp://rpmfind.net/linux/sourceforge/m/m & 7.i586.rpm

root@dv35 ~]# rpm -ihv readline-compat-4.3-307.i586.rpm
Preparing...                ########################################### [100%]
   1:readline-compat        ########################################### [100%]
[root@dv35 ~]# rpm -Uhv freetds-0.63-1.1.el3.rf.i386.rpm
warning: freetds-0.63-1.1.el3.rf.i386.rpm: Header V3 DSA signature: NOKEY, key ID 6b8d79e6
Preparing...                ########################################### [100%]
   1:freetds                ########################################### [100%]

Hope this helps."

When I try to do this (rpm -Uhv freetds-0.63-1.1.el3.rf.i386.rpm), I get the following error:
error: Failed dependencies:
        libct.so.4 is needed by (installed) freetds-devel-0.64-11.el5.centos.i386
        libtds.so.5 is needed by (installed) freetds-devel-0.64-11.el5.centos.i386
        freetds = 0.64-11.el5.centos is needed by (installed) freetds-devel-0.64-11.el5.centos.i386

Do I need to solve these dependencies and can't I just use Yum for this? Also, when I install "libct.so.4" I get an error depending on the install of "freetds = 0.64-11.el5.centos is needed by (installed) freetds-devel-0.64-11.el5.centos.i386" - how do I install that one?

 

by: gheistPosted on 2008-06-09 at 03:49:01ID: 21742138

Are you knowingly intermixing packages from Centos3 and5 ?

 

by: EMB01Posted on 2008-06-09 at 04:59:34ID: 21742460

Other than the backwords-compatibility file (libreadline.so.4) from the post? He said when he did it, he didn't get any errors at all. Does the error mean I have freetds-devel-0.64-11.el5.centos.i386 installed, so I must have to uninstall that first?

 

by: gheistPosted on 2008-06-09 at 05:03:57ID: 21742488

freetds is installed and correct version. do not install old version.

 

by: EMB01Posted on 2008-06-09 at 05:44:22ID: 21742705

Right now, if I run odbc_connect, I get an error reading "SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect." What if the new version of the driver doesn't support the actions of the old version from the tutorial (http://kb.mediatemple.net/questions/233/Using+%28remote%29+MS-SQL+databases+with+PHP+on+a+%28dv%29)?

 

by: gheistPosted on 2008-06-09 at 05:48:54ID: 21742732

I get mssql_connect working always.
You have network issue firsthand
And ODBC misconfiguration.

 

by: EMB01Posted on 2008-06-09 at 06:11:30ID: 21742852

Any ideas how to fix it: The ODBC misconfig?

 

by: gheistPosted on 2008-06-10 at 05:57:42ID: 21750738

It will just give different error message....
As the first effort go troubleshoot network connectiviety issue - ping, telnet, traceroute etc.

 

by: EMB01Posted on 2008-09-09 at 09:21:11ID: 31456704

Thanks for your help.

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...