За последние 24 часа нас посетил 17141 программист и 1292 робота. Сейчас ищет 1671 программист ...

конект MsSQL и php

Тема в разделе "MSSQL", создана пользователем stanik, 10 апр 2007.

  1. stanik

    stanik Активный пользователь

    С нами с:
    10 апр 2007
    Сообщения:
    3
    Симпатии:
    0
    Добрый всем...

    Всегда использовал ASP недавно решил перйти на php так как нет достаточных знаний по написанию скриптов на asp.

    Установил апач и пхп.
    Настроил пхп.ини под коннект к мссклу, но при открытии страницы мне выводиться следующая ошибка:

    Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 127.0.0.1,1433 in D:\wwwroot\l2cp\function.php on line 46

    Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in D:\wwwroot\l2cp\function.php on line 47

    Fatal error: Call to undefined function mysql_error() in D:\wwwroot\l2cp\function.php on line 47


    Кто нибудь может мне помочь с этим и подсказать или даже по пунктам лучше описать как мне устранить это все чтобы скрипт нормально приконектился к МССКЛ серверу?
     
  2. Hight

    Hight Старожил
    Команда форума Модератор

    С нами с:
    5 мар 2006
    Сообщения:
    7.153
    Симпатии:
    0
    Адрес:
    из злой параллельной вселенной
    stanik
    код в студию
     
  3. 440Hz

    440Hz Старожил
    Команда форума Модератор

    С нами с:
    21 дек 2012
    Сообщения:
    8.003
    Симпатии:
    1
    Адрес:
    Оттуда
    а MySQL установить не пробовали?

    =)
     
  4. Anonymous

    Anonymous Guest

    но при этом
     
  5. gigalit

    gigalit Активный пользователь

    С нами с:
    22 сен 2007
    Сообщения:
    82
    Симпатии:
    0


    Вы не сказали, что используете библиотеку freetds
    При работе с данной библиотекой обычно возникает путаница.
    Одни пишут запятую 127.0.0.1,1433 другие пишут двоеточие 127.0.0.1:1433

    Если вы не используете freetds, то пишите без указания порта:
    @mssql_connect($dblocation, $dbuser, $dbpasswd); где
    $dblocation = '127.0.0.1';
     
  6. qwerty737

    qwerty737 Активный пользователь

    С нами с:
    2 апр 2007
    Сообщения:
    63
    Симпатии:
    0
    Доброго времени суток. Пытаюсь вызвать mssql_connect() получаю undefined function в чем проблема?

    Fatal error: Call to undefined function mssql_connect() in D:\Program Files\Apache Group\Apache2\htdocs\SITE\v13_10_07\test\2.php on line 7


    PHP:
    1.  
    2. <?
    3.   $dbhost = "q";                            
    4.   $dbuser = "q";
    5.   $dbpasswd = "q";
    6.   $db = 'q';
    7.  
    8.   $msconnect=mssql_connect($dbhost,$dbuser,$dbpasswd);
    9.   $msdb=mssql_select_db($db,$msconnect);
    10.   ?>
    p.s. с mysql все работает нормально
     
  7. Hight

    Hight Старожил
    Команда форума Модератор

    С нами с:
    5 мар 2006
    Сообщения:
    7.153
    Симпатии:
    0
    Адрес:
    из злой параллельной вселенной
    расширение не подгружается
     
  8. qwerty737

    qwerty737 Активный пользователь

    С нами с:
    2 апр 2007
    Сообщения:
    63
    Симпатии:
    0
    Какое и как подключить?

    В php.ini: ?


    extension=php_mime_magic.dll
    extension=php_ming.dll
    extension=php_mssql.dll
    extension=php_msql.dll
    extension=php_mysql.dll

    Или где?
     
  9. host

    host Активный пользователь

    С нами с:
    20 июн 2007
    Сообщения:
    733
    Симпатии:
    3
    ну а path прописан верно?
     
  10. qwerty737

    qwerty737 Активный пользователь

    С нами с:
    2 апр 2007
    Сообщения:
    63
    Симпатии:
    0
    Наврное нет. А где прописать???
     
  11. Hight

    Hight Старожил
    Команда форума Модератор

    С нами с:
    5 мар 2006
    Сообщения:
    7.153
    Симпатии:
    0
    Адрес:
    из злой параллельной вселенной
    qwerty737
    php.ru/install
     
  12. qwerty737

    qwerty737 Активный пользователь

    С нами с:
    2 апр 2007
    Сообщения:
    63
    Симпатии:
    0
    Да вроде правильно было, ведь mysql то работал и работает, да вроде я поправил все. Но не помогло. Правда в средах администратора PHPRC нету. А в path у меня вот что.

    Код (Text):
    1. %SystemRoot%\system32;
    2. %SystemRoot%;
    3. %SystemRoot%\System32\Wbem;
    4. c:\mysql\bin;
    5. D:\Program Files\Common Files\Teleca Shared;
    6. D:\Program Files\Microsoft SQL Server\80\Tools\Binn\;
    7. C:\MSSQL2005\90\Tools\binn\;
    8. C:\MSSQL2005\90\DTS\Binn\;
    9. C:\MSSQL2005\90\Tools\Binn\VSShell\Common7\IDE\;
    10. D:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\;
    11. D:\php5\;
    12. D:\php5\text\
     
  13. qwerty737

    qwerty737 Активный пользователь

    С нами с:
    2 апр 2007
    Сообщения:
    63
    Симпатии:
    0
    Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user 'qwerty'. The user is not associated with a trusted SQL Server connection. (severity 14) in D:\Program Files\Apache Group\Apache2\htdocs\SITE\v13_10_07\test\1.php on line 9

    Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 11-AE2EF4FE9F45 in D:\Program Files\Apache Group\Apache2\htdocs\SITE\v13_10_07\test\1.php on line 9

    Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in D:\Program Files\Apache Group\Apache2\htdocs\SITE\v13_10_07\test\1.php on line 11


    PHP:
    1. <?php /* Created on: 20.10.2007 */ ?>
    2. <html>
    3. <body>
    4.      <?
    5.  
    6. $servername="11-AE2EF4FE9F45";
    7. $username="qwerty";
    8. $password="qwertyqwerty";
    9. $msconnnect=mssql_connect($servername, $username, $password);
    10. $database_name="department";
    11. $msdb=mssql_select_db ($database_name, $msconnnect);
    12.   ?>
    13. </body>
    14. </html>
    Почему?
     
  14. Ufo

    Ufo Активный пользователь

    С нами с:
    28 окт 2007
    Сообщения:
    8
    Симпатии:
    0
    У меня сейчас та же проблема:
    Fatal error: Call to undefined function mysql_error()

    В пхп.ini все вроде бы прописал правильно. Файл mssql.lib копировал в папку PECL (туда же где лежит и Mysql.lib)..Все равно не работает.В чем проблема??



    У вас видимо библотека mssql.lib подгружается нормально, а вот соединения нету.
     
  15. Hight

    Hight Старожил
    Команда форума Модератор

    С нами с:
    5 мар 2006
    Сообщения:
    7.153
    Симпатии:
    0
    Адрес:
    из злой параллельной вселенной
    У вас другая проблема, MsSQL и MySQL далеко не одно и тоже.
     
  16. Ufo

    Ufo Активный пользователь

    С нами с:
    28 окт 2007
    Сообщения:
    8
    Симпатии:
    0
    Извините, не так сформулировал проблему. А точнее ошибся в функции( копировал ее из поста выше, не посмотрев внимательно). У меня:
    Fatal error: Call to undefined function mssql_connect()

    А не:
    Fatal error: Call to undefined function mysql_error()

    То есть не подключается MSSQL, хотя настройки в php.ini я сделал, и библиотеку поместил в нужную папку.
     
  17. Hight

    Hight Старожил
    Команда форума Модератор

    С нами с:
    5 мар 2006
    Сообщения:
    7.153
    Симпатии:
    0
    Адрес:
    из злой параллельной вселенной
    Не может функцию найти. Проблема в настройке.
     
  18. Anonymous

    Anonymous Guest

    Клиент MsSQL установлен то на компутере?
     
  19. Ufo

    Ufo Активный пользователь

    С нами с:
    28 окт 2007
    Сообщения:
    8
    Симпатии:
    0
    Из софта установлены сервер MSSQL 2005 и SQL Server Managment Studio. Еще что-то нужно??
     
  20. Shirker

    Shirker Активный пользователь

    С нами с:
    26 окт 2006
    Сообщения:
    2
    Симпатии:
    0
    <off>я оказываеццо здесь давно зареген))</off>
    (Полночи провозившись) - Стоит 2000 мсскул - пока не скопировал с пхп5 папки ntwdblib.dll в систем32 не хотело ни в какую, после - все ок (по крайней мере уже не неизвестная ф-ция). Так что софт скорее всего не нужен никакой
     
  21. Святой

    Святой Активный пользователь

    С нами с:
    24 июн 2008
    Сообщения:
    3
    Симпатии:
    0
    Здравствуйте! вот таким образом пытаюсь присоединится к базе данных mssql.

    Код (Text):
    1.  
    2.         $dbl    =   '127.0.0.1';
    3.     $dbu    =   'sa';
    4.     $dbp    =   '';
    5.     $dbn    =   'Econ';
    6.     $dbcon = mssql_connect($dbl, $dbu, $dbp);
    на последней строчке просто обламывается и любые строки идущие после нее вообще не выполняются. даже тупо print.
    я теряюсь, не знаю что делать. у нас iis 6.0 и php 5.2.1. вот php.ini

    Код (Text):
    1.  
    2. [PHP];;;;;;;;;;;;;;;;;;;
    3. ; About php.ini   ;
    4. ;;;;;;;;;;;;;;;;;;;
    5. ; This file controls many aspects of PHP's behavior.  In order for PHP to
    6. ; read it, it must be named 'php.ini'.  PHP looks for it in the current
    7. ; working directory, in the path designated by the environment variable
    8. ; PHPRC, and in the path that was defined in compile time (in that order).
    9. ; Under Windows, the compile-time path is the Windows directory.  The
    10. ; path in which the php.ini file is looked for can be overridden using
    11. ; the -c argument in command line mode.
    12. ;
    13. ; The syntax of the file is extremely simple.  Whitespace and Lines
    14. ; beginning with a semicolon are silently ignored (as you probably guessed).
    15. ; Section headers (e.g. [Foo]) are also silently ignored, even though
    16. ; they might mean something in the future.
    17. ;
    18. ; Directives are specified using the following syntax:
    19. ; directive = value
    20. ; Directive names are *case sensitive* - foo=bar is different from FOO=bar.
    21. ;
    22. ; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one
    23. ; of the INI constants (On, Off, True, False, Yes, No and None) or an expression
    24. ; (e.g. E_ALL & ~E_NOTICE), or a quoted string ("foo").
    25. ;
    26. ; Expressions in the INI file are limited to bitwise operators and parentheses:
    27. ; |        bitwise OR
    28. ; &        bitwise AND
    29. ; ~        bitwise NOT
    30. ; !        boolean NOT
    31. ;
    32. ; Boolean flags can be turned on using the values 1, On, True or Yes.
    33. ; They can be turned off using the values 0, Off, False or No.
    34. ;
    35. ; An empty string can be denoted by simply not writing anything after the equal
    36. ; sign, or by using the None keyword:
    37. ;
    38. ;  foo =         ; sets foo to an empty string
    39. ;  foo = none    ; sets foo to an empty string
    40. ;  foo = "none"  ; sets foo to the string 'none'
    41. ;
    42. ; If you use constants in your value, and these constants belong to a
    43. ; dynamically loaded extension (either a PHP extension or a Zend extension),
    44. ; you may only use these constants *after* the line that loads the extension.
    45. ;
    46. ;
    47. ;;;;;;;;;;;;;;;;;;;
    48. ; About this file ;
    49. ;;;;;;;;;;;;;;;;;;;
    50. ; This is the recommended, PHP 5-style version of the php.ini-dist file.  It
    51. ; sets some non standard settings, that make PHP more efficient, more secure,
    52. ; and encourage cleaner coding.
    53. ;
    54. ; The price is that with these settings, PHP may be incompatible with some
    55. ; applications, and sometimes, more difficult to develop with.  Using this
    56. ; file is warmly recommended for production sites.  As all of the changes from
    57. ; the standard settings are thoroughly documented, you can go over each one,
    58. ; and decide whether you want to use it or not.
    59. ;
    60. ; For general information about the php.ini file, please consult the php.ini-dist
    61. ; file, included in your PHP distribution.
    62. ;
    63. ; This file is different from the php.ini-dist file in the fact that it features
    64. ; different values for several directives, in order to improve performance, while
    65. ; possibly breaking compatibility with the standard out-of-the-box behavior of
    66. ; PHP.  Please make sure you read what's different, and modify your scripts
    67. ; accordingly, if you decide to use this file instead.
    68. ;
    69. ; - register_long_arrays = Off     [Performance]
    70. ;     Disables registration of the older (and deprecated) long predefined array
    71. ;     variables ($HTTP_*_VARS).  Instead, use the superglobals that were
    72. ;     introduced in PHP 4.1.0
    73. ; - display_errors = Off           [Security]
    74. ;     With this directive set to off, errors that occur during the execution of
    75. ;     scripts will no longer be displayed as a part of the script output, and thus,
    76. ;     will no longer be exposed to remote users.  With some errors, the error message
    77. ;     content may expose information about your script, web server, or database
    78. ;     server that may be exploitable for hacking.  Production sites should have this
    79. ;     directive set to off.
    80. ; - log_errors = On                [Security]
    81. ;     This directive complements the above one.  Any errors that occur during the
    82. ;     execution of your script will be logged (typically, to your server's error log,
    83. ;     but can be configured in several ways).  Along with setting display_errors to off,
    84. ;     this setup gives you the ability to fully understand what may have gone wrong,
    85. ;     without exposing any sensitive information to remote users.
    86. ; - output_buffering = 4096        [Performance]
    87. ;     Set a 4KB output buffer.  Enabling output buffering typically results in less
    88. ;     writes, and sometimes less packets sent on the wire, which can often lead to
    89. ;     better performance.  The gain this directive actually yields greatly depends
    90. ;     on which Web server you're working with, and what kind of scripts you're using.
    91. ; - register_argc_argv = Off       [Performance]
    92. ;     Disables registration of the somewhat redundant $argv and $argc global
    93. ;     variables.
    94. ; - magic_quotes_gpc = Off         [Performance]
    95. ;     Input data is no longer escaped with slashes so that it can be sent into
    96. ;     SQL databases without further manipulation.  Instead, you should use the
    97. ;     function addslashes() on each input element you wish to send to a database.
    98. ; - variables_order = "GPCS"       [Performance]
    99. ;     The environment variables are not hashed into the $_ENV.  To access
    100. ;     environment variables, you can use getenv() instead.
    101. ; - error_reporting = E_ALL        [Code Cleanliness, Security(?)]
    102. ;     By default, PHP suppresses errors of type E_NOTICE.  These error messages
    103. ;     are emitted for non-critical errors, but that could be a symptom of a bigger
    104. ;     problem.  Most notably, this will cause error messages about the use
    105. ;     of uninitialized variables to be displayed.
    106. ; - allow_call_time_pass_reference = Off     [Code cleanliness]
    107. ;     It's not possible to decide to force a variable to be passed by reference
    108. ;     when calling a function.  The PHP 4 style to do this is by making the
    109. ;     function require the relevant argument by reference.
    110.  
    111. ;;;;;;;;;;;;;;;;;;;;
    112. ; Language Options ;
    113. ;;;;;;;;;;;;;;;;;;;;
    114.  
    115. ; Enable the PHP scripting language engine under Apache.
    116. engine = On
    117.  
    118. ; Enable compatibility mode with Zend Engine 1 (PHP 4.x)
    119. zend.ze1_compatibility_mode = Off
    120.  
    121. ; Allow the <? tag.  Otherwise, only <?php and <script> tags are recognized.
    122. ; NOTE: Using short tags should be avoided when developing applications or
    123. ; libraries that are meant for redistribution, or deployment on PHP
    124. ; servers which are not under your control, because short tags may not
    125. ; be supported on the target server. For portable, redistributable code,
    126. ; be sure not to use short tags.
    127. short_open_tag = Off
    128.  
    129. ; Allow ASP-style <% %> tags.
    130. asp_tags = Off
    131.  
    132. ; The number of significant digits displayed in floating point numbers.
    133. precision    =  14
    134.  
    135. ; Enforce year 2000 compliance (will cause problems with non-compliant browsers)
    136. y2k_compliance = On
    137.  
    138. ; Output buffering allows you to send header lines (including cookies) even
    139. ; after you send body content, at the price of slowing PHP's output layer a
    140. ; bit.  You can enable output buffering during runtime by calling the output
    141. ; buffering functions.  You can also enable output buffering for all files by
    142. ; setting this directive to On.  If you wish to limit the size of the buffer
    143. ; to a certain size - you can use a maximum number of bytes instead of 'On', as
    144. ; a value for this directive (e.g., output_buffering=4096).
    145. output_buffering = 4096
    146.  
    147. ; You can redirect all of the output of your scripts to a function.  For
    148. ; example, if you set output_handler to "mb_output_handler", character
    149. ; encoding will be transparently converted to the specified encoding.
    150. ; Setting any output handler automatically turns on output buffering.
    151. ; Note: People who wrote portable scripts should not depend on this ini
    152. ;       directive. Instead, explicitly set the output handler using ob_start().
    153. ;       Using this ini directive may cause problems unless you know what script
    154. ;       is doing.
    155. ; Note: You cannot use both "mb_output_handler" with "ob_iconv_handler"
    156. ;       and you cannot use both "ob_gzhandler" and "zlib.output_compression".
    157. ; Note: output_handler must be empty if this is set 'On' !!!!
    158. ;       Instead you must use zlib.output_handler.
    159. ;output_handler =
    160.  
    161. ; Transparent output compression using the zlib library
    162. ; Valid values for this option are 'off', 'on', or a specific buffer size
    163. ; to be used for compression (default is 4KB)
    164. ; Note: Resulting chunk size may vary due to nature of compression. PHP
    165. ;       outputs chunks that are few hundreds bytes each as a result of
    166. ;       compression. If you prefer a larger chunk size for better
    167. ;       performance, enable output_buffering in addition.
    168. ; Note: You need to use zlib.output_handler instead of the standard
    169. ;       output_handler, or otherwise the output will be corrupted.
    170. zlib.output_compression = Off
    171. ;zlib.output_compression_level = -1
    172.  
    173. ; You cannot specify additional output handlers if zlib.output_compression
    174. ; is activated here. This setting does the same as output_handler but in
    175. ; a different order.
    176. ;zlib.output_handler =
    177.  
    178. ; Implicit flush tells PHP to tell the output layer to flush itself
    179. ; automatically after every output block.  This is equivalent to calling the
    180. ; PHP function flush() after each and every call to print() or echo() and each
    181. ; and every HTML block.  Turning this option on has serious performance
    182. ; implications and is generally recommended for debugging purposes only.
    183. implicit_flush = Off
    184.  
    185. ; The unserialize callback function will be called (with the undefined class'
    186. ; name as parameter), if the unserializer finds an undefined class
    187. ; which should be instantiated.
    188. ; A warning appears if the specified function is not defined, or if the
    189. ; function doesn't include/implement the missing class.
    190. ; So only set this entry, if you really want to implement such a
    191. ; callback-function.
    192. unserialize_callback_func=
    193.  
    194. ; When floats & doubles are serialized store serialize_precision significant
    195. ; digits after the floating point. The default value ensures that when floats
    196. ; are decoded with unserialize, the data will remain the same.
    197. serialize_precision = 100
    198.  
    199. ; Whether to enable the ability to force arguments to be passed by reference
    200. ; at function call time.  This method is deprecated and is likely to be
    201. ; unsupported in future versions of PHP/Zend.  The encouraged method of
    202. ; specifying which arguments should be passed by reference is in the function
    203. ; declaration.  You're encouraged to try and turn this option Off and make
    204. ; sure your scripts work properly with it in order to ensure they will work
    205. ; with future versions of the language (you will receive a warning each time
    206. ; you use this feature, and the argument will be passed by value instead of by
    207. ; reference).
    208. allow_call_time_pass_reference = Off
    209.  
    210. ;
    211. ; Safe Mode
    212. ;
    213. safe_mode = Off
    214.  
    215. ; By default, Safe Mode does a UID compare check when
    216. ; opening files. If you want to relax this to a GID compare,
    217. ; then turn on safe_mode_gid.
    218. safe_mode_gid = Off
    219.  
    220. ; When safe_mode is on, UID/GID checks are bypassed when
    221. ; including files from this directory and its subdirectories.
    222. ; (directory must also be in include_path or full path must
    223. ; be used when including)
    224. safe_mode_include_dir =
    225.  
    226. ; When safe_mode is on, only executables located in the safe_mode_exec_dir
    227. ; will be allowed to be executed via the exec family of functions.
    228. safe_mode_exec_dir =
    229.  
    230. ; Setting certain environment variables may be a potential security breach.
    231. ; This directive contains a comma-delimited list of prefixes.  In Safe Mode,
    232. ; the user may only alter environment variables whose names begin with the
    233. ; prefixes supplied here.  By default, users will only be able to set
    234. ; environment variables that begin with PHP_ (e.g. PHP_FOO=BAR).
    235. ;
    236. ; Note:  If this directive is empty, PHP will let the user modify ANY
    237. ; environment variable!
    238. safe_mode_allowed_env_vars = PHP_
    239.  
    240. ; This directive contains a comma-delimited list of environment variables that
    241. ; the end user won't be able to change using putenv().  These variables will be
    242. ; protected even if safe_mode_allowed_env_vars is set to allow to change them.
    243. safe_mode_protected_env_vars = LD_LIBRARY_PATH
    244.  
    245. ; open_basedir, if set, limits all file operations to the defined directory
    246. ; and below.  This directive makes most sense if used in a per-directory
    247. ; or per-virtualhost web server configuration file. This directive is
    248. ; *NOT* affected by whether Safe Mode is turned On or Off.
    249. ;open_basedir =
    250.  
    251. ; This directive allows you to disable certain functions for security reasons.
    252. ; It receives a comma-delimited list of function names. This directive is
    253. ; *NOT* affected by whether Safe Mode is turned On or Off.
    254. disable_functions =
    255.  
    256. ; This directive allows you to disable certain classes for security reasons.
    257. ; It receives a comma-delimited list of class names. This directive is
    258. ; *NOT* affected by whether Safe Mode is turned On or Off.
    259. disable_classes =
    260.  
    261. ; Colors for Syntax Highlighting mode.  Anything that's acceptable in
    262. ; <span style="color: ???????"> would work.
    263. ;highlight.string  = #DD0000
    264. ;highlight.comment = #FF9900
    265. ;highlight.keyword = #007700
    266. ;highlight.bg      = #FFFFFF
    267. ;highlight.default = #0000BB
    268. ;highlight.html    = #000000
    269.  
    270. ; If enabled, the request will be allowed to complete even if the user aborts
    271. ; the request. Consider enabling it if executing long request, which may end up
    272. ; being interrupted by the user or a browser timing out.
    273. ; ignore_user_abort = On
    274.  
    275. ; Determines the size of the realpath cache to be used by PHP. This value should
    276. ; be increased on systems where PHP opens many files to reflect the quantity of
    277. ; the file operations performed.
    278. ; realpath_cache_size=16k
    279.  
    280. ; Duration of time, in seconds for which to cache realpath information for a given
    281. ; file or directory. For systems with rarely changing files, consider increasing this
    282. ; value.
    283. ; realpath_cache_ttl=120
    284.  
    285. ;
    286. ; Misc
    287. ;
    288. ; Decides whether PHP may expose the fact that it is installed on the server
    289. ; (e.g. by adding its signature to the Web server header).  It is no security
    290. ; threat in any way, but it makes it possible to determine whether you use PHP
    291. ; on your server or not.
    292. expose_php = On
    293.  
    294.  
    295. ;;;;;;;;;;;;;;;;;;;
    296. ; Resource Limits ;
    297. ;;;;;;;;;;;;;;;;;;;
    298.  
    299. max_execution_time = 30     ; Maximum execution time of each script, in seconds
    300. max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
    301. memory_limit = 128M      ; Maximum amount of memory a script may consume (128MB)
    302.  
    303.  
    304. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
    305. ; Error handling and logging ;
    306. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
    307.  
    308. ; error_reporting is a bit-field.  Or each number up to get desired error
    309. ; reporting level
    310. ; E_ALL             - All errors and warnings (doesn't include E_STRICT)
    311. ; E_ERROR           - fatal run-time errors
    312. ; E_RECOVERABLE_ERROR  - almost fatal run-time errors
    313. ; E_WARNING         - run-time warnings (non-fatal errors)
    314. ; E_PARSE           - compile-time parse errors
    315. ; E_NOTICE          - run-time notices (these are warnings which often result
    316. ;                     from a bug in your code, but it's possible that it was
    317. ;                     intentional (e.g., using an uninitialized variable and
    318. ;                     relying on the fact it's automatically initialized to an
    319. ;                     empty string)
    320. ; E_STRICT          - run-time notices, enable to have PHP suggest changes
    321. ;                     to your code which will ensure the best interoperability
    322. ;                     and forward compatibility of your code
    323. ; E_CORE_ERROR      - fatal errors that occur during PHP's initial startup
    324. ; E_CORE_WARNING    - warnings (non-fatal errors) that occur during PHP's
    325. ;                     initial startup
    326. ; E_COMPILE_ERROR   - fatal compile-time errors
    327. ; E_COMPILE_WARNING - compile-time warnings (non-fatal errors)
    328. ; E_USER_ERROR      - user-generated error message
    329. ; E_USER_WARNING    - user-generated warning message
    330. ; E_USER_NOTICE     - user-generated notice message
    331. ;
    332. ; Examples:
    333. ;
    334. ;   - Show all errors, except for notices and coding standards warnings
    335. ;
    336. ;error_reporting = E_ALL & ~E_NOTICE
    337. ;
    338. ;   - Show all errors, except for notices
    339. ;
    340. ;error_reporting = E_ALL & ~E_NOTICE | E_STRICT
    341. ;
    342. ;   - Show only errors
    343. ;
    344. ;error_reporting = E_COMPILE_ERROR|E_RECOVERABLE_ERROR|E_ERROR|E_CORE_ERROR
    345. ;
    346. ;   - Show all errors, except coding standards warnings
    347. ;
    348. error_reporting  =  E_ALL
    349.  
    350. ; Print out errors (as a part of the output).  For production web sites,
    351. ; you're strongly encouraged to turn this feature off, and use error logging
    352. ; instead (see below).  Keeping display_errors enabled on a production web site
    353. ; may reveal security information to end users, such as file paths on your Web
    354. ; server, your database schema or other information.
    355. display_errors = Off
    356.  
    357. ; Even when display_errors is on, errors that occur during PHP's startup
    358. ; sequence are not displayed.  It's strongly recommended to keep
    359. ; display_startup_errors off, except for when debugging.
    360. display_startup_errors = Off
    361.  
    362. ; Log errors into a log file (server-specific log, stderr, or error_log (below))
    363. ; As stated above, you're strongly advised to use error logging in place of
    364. ; error displaying on production web sites.
    365. log_errors = On
    366.  
    367. ; Set maximum length of log_errors. In error_log information about the source is
    368. ; added. The default is 1024 and 0 allows to not apply any maximum length at all.
    369. log_errors_max_len = 1024
    370.  
    371. ; Do not log repeated messages. Repeated errors must occur in same file on same
    372. ; line until ignore_repeated_source is set true.
    373. ignore_repeated_errors = Off
    374.  
    375. ; Ignore source of message when ignoring repeated messages. When this setting
    376. ; is On you will not log errors with repeated messages from different files or
    377. ; source lines.
    378. ignore_repeated_source = Off
    379.  
    380. ; If this parameter is set to Off, then memory leaks will not be shown (on
    381. ; stdout or in the log). This has only effect in a debug compile, and if
    382. ; error reporting includes E_WARNING in the allowed list
    383. report_memleaks = On
    384.  
    385. ;report_zend_debug = 0
    386.  
    387. ; Store the last error/warning message in $php_errormsg (boolean).
    388. track_errors = Off
    389.  
    390. ; Disable the inclusion of HTML tags in error messages.
    391. ; Note: Never use this feature for production boxes.
    392. ;html_errors = Off
    393.  
    394. ; If html_errors is set On PHP produces clickable error messages that direct
    395. ; to a page describing the error or function causing the error in detail.
    396. ; You can download a copy of the PHP manual from http://www.php.net/docs.php
    397. ; and change docref_root to the base URL of your local copy including the
    398. ; leading '/'. You must also specify the file extension being used including
    399. ; the dot.
    400. ; Note: Never use this feature for production boxes.
    401. ;docref_root = "/phpmanual/"
    402. ;docref_ext = .html
    403.  
    404. ; String to output before an error message.
    405. ;error_prepend_string = "<font color=ff0000>"
    406.  
    407. ; String to output after an error message.
    408. ;error_append_string = "</font>"
    409.  
    410. ; Log errors to specified file.
    411. ;error_log = filename
    412.  
    413. ; Log errors to syslog (Event Log on NT, not valid in Windows 95).
    414. ;error_log = syslog
    415.  
    416.  
    417. ;;;;;;;;;;;;;;;;;
    418. ; Data Handling ;
    419. ;;;;;;;;;;;;;;;;;
    420. ;
    421. ; Note - track_vars is ALWAYS enabled as of PHP 4.0.3
    422.  
    423. ; The separator used in PHP generated URLs to separate arguments.
    424. ; Default is "&".
    425. ;arg_separator.output = "&amp;"
    426.  
    427. ; List of separator(s) used by PHP to parse input URLs into variables.
    428. ; Default is "&".
    429. ; NOTE: Every character in this directive is considered as separator!
    430. ;arg_separator.input = ";&"
    431.  
    432. ; This directive describes the order in which PHP registers GET, POST, Cookie,
    433. ; Environment and Built-in variables (G, P, C, E & S respectively, often
    434. ; referred to as EGPCS or GPC).  Registration is done from left to right, newer
    435. ; values override older values.
    436. variables_order = "GPCS"
    437.  
    438. ; Whether or not to register the EGPCS variables as global variables.  You may
    439. ; want to turn this off if you don't want to clutter your scripts' global scope
    440. ; with user data.  This makes most sense when coupled with track_vars - in which
    441. ; case you can access all of the GPC variables through the $HTTP_*_VARS[],
    442. ; variables.
    443. ;
    444. ; You should do your best to write your scripts so that they do not require
    445. ; register_globals to be on;  Using form variables as globals can easily lead
    446. ; to possible security problems, if the code is not very well thought of.
    447. register_globals = Off
    448.  
    449. ; Whether or not to register the old-style input arrays, HTTP_GET_VARS
    450. ; and friends.  If you're not using them, it's recommended to turn them off,
    451. ; for performance reasons.
    452. register_long_arrays = Off
    453.  
    454. ; This directive tells PHP whether to declare the argv&argc variables (that
    455. ; would contain the GET information).  If you don't use these variables, you
    456. ; should turn it off for increased performance.
    457. register_argc_argv = Off
    458.  
    459. ; When enabled, the SERVER and ENV variables are created when they're first
    460. ; used (Just In Time) instead of when the script starts. If these variables
    461. ; are not used within a script, having this directive on will result in a
    462. ; performance gain. The PHP directives register_globals, register_long_arrays,
    463. ; and register_argc_argv must be disabled for this directive to have any affect.
    464. auto_globals_jit = On
    465.  
    466. ; Maximum size of POST data that PHP will accept.
    467. post_max_size = 8M
    468.  
    469. ; Magic quotes
    470. ;
    471.  
    472. ; Magic quotes for incoming GET/POST/Cookie data.
    473. magic_quotes_gpc = Off
    474.  
    475. ; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc.
    476. magic_quotes_runtime = Off
    477.  
    478. ; Use Sybase-style magic quotes (escape ' with '' instead of \').
    479. magic_quotes_sybase = Off
    480.  
    481. ; Automatically add files before or after any PHP document.
    482. auto_prepend_file =
    483. auto_append_file =
    484.  
    485. ; As of 4.0b4, PHP always outputs a character encoding by default in
    486. ; the Content-type: header.  To disable sending of the charset, simply
    487. ; set it to be empty.
    488. ;
    489. ; PHP's built-in default is text/html
    490. default_mimetype = "text/html"
    491. ;default_charset = "iso-8859-1"
    492.  
    493. ; Always populate the $HTTP_RAW_POST_DATA variable.
    494. ;always_populate_raw_post_data = On
    495.  
    496.  
    497. ;;;;;;;;;;;;;;;;;;;;;;;;;
    498. ; Paths and Directories ;
    499. ;;;;;;;;;;;;;;;;;;;;;;;;;
    500.  
    501. ; UNIX: "/path1:/path2"
    502. ;include_path = ".:/php/includes"
    503. ;
    504. ; Windows: "\path1;\path2"
    505. ;include_path = ".;c:\php\includes"
    506.  
    507. ; The root of the PHP pages, used only if nonempty.
    508. ; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root
    509. ; if you are running php as a CGI under any web server (other than IIS)
    510. ; see documentation for security issues.  The alternate is to use the
    511. ; cgi.force_redirect configuration below
    512. doc_root = "d:\Inetpub\wwwroot";
    513.  
    514. ; The directory under which PHP opens the script using /~username used only
    515. ; if nonempty.
    516. user_dir =
    517.  
    518. ; Directory in which the loadable extensions (modules) reside.
    519. extension_dir = d:\php\extensions
    520.  
    521. ; Whether or not to enable the dl() function.  The dl() function does NOT work
    522. ; properly in multithreaded servers, such as IIS or Zeus, and is automatically
    523. ; disabled on them.
    524. enable_dl = On
    525.  
    526. ; cgi.force_redirect is necessary to provide security running PHP as a CGI under
    527. ; most web servers.  Left undefined, PHP turns this on by default.  You can
    528. ; turn it off here AT YOUR OWN RISK
    529. ; **You CAN safely turn this off for IIS, in fact, you MUST.**
    530. cgi.force_redirect = 0
    531.  
    532. ; if cgi.nph is enabled it will force cgi to always sent Status: 200 with
    533. ; every request.
    534. ; cgi.nph = 1
    535.  
    536. ; if cgi.force_redirect is turned on, and you are not running under Apache or Netscape
    537. ; (iPlanet) web servers, you MAY need to set an environment variable name that PHP
    538. ; will look for to know it is OK to continue execution.  Setting this variable MAY
    539. ; cause security issues, KNOW WHAT YOU ARE DOING FIRST.
    540. ; cgi.redirect_status_env = ;
    541.  
    542. ; FastCGI under IIS (on WINNT based OS) supports the ability to impersonate
    543. ; security tokens of the calling client.  This allows IIS to define the
    544. ; security context that the request runs under.  mod_fastcgi under Apache
    545. ; does not currently support this feature (03/17/2002)
    546. ; Set to 1 if running under IIS.  Default is zero.
    547. ; fastcgi.impersonate = 1;
    548.  
    549. ; Disable logging through FastCGI connection
    550. ; fastcgi.log = 0
    551.  
    552. ; cgi.rfc2616_headers configuration option tells PHP what type of headers to
    553. ; use when sending HTTP response code. If it's set 0 PHP sends Status: header that
    554. ; is supported by Apache. When this option is set to 1 PHP will send
    555. ; RFC2616 compliant header.
    556. ; Default is zero.
    557. ;cgi.rfc2616_headers = 0
    558.  
    559.  
    560. ;;;;;;;;;;;;;;;;
    561. ; File Uploads ;
    562. ;;;;;;;;;;;;;;;;
    563.  
    564. ; Whether to allow HTTP file uploads.
    565. file_uploads = On
    566.  
    567. ; Temporary directory for HTTP uploaded files (will use system default if not
    568. ; specified).
    569. ;upload_tmp_dir =
    570.  
    571. ; Maximum allowed size for uploaded files.
    572. upload_max_filesize = 2M
    573.  
    574.  
    575. ;;;;;;;;;;;;;;;;;;
    576. ; Fopen wrappers ;
    577. ;;;;;;;;;;;;;;;;;;
    578.  
    579. ; Whether to allow the treatment of URLs (like http:// or ftp://) as files.
    580. allow_url_fopen = On
    581.  
    582. ; Whether to allow include/require to open URLs (like http:// or ftp://) as files.
    583. allow_url_include = Off
    584.  
    585. ; Define the anonymous ftp password (your email address)
    586. ;from="john@doe.com"
    587.  
    588. ; Define the User-Agent string
    589. ; user_agent="PHP"
    590.  
    591. ; Default timeout for socket based streams (seconds)
    592. default_socket_timeout = 60
    593.  
    594. ; If your scripts have to deal with files from Macintosh systems,
    595. ; or you are running on a Mac and need to deal with files from
    596. ; unix or win32 systems, setting this flag will cause PHP to
    597. ; automatically detect the EOL character in those files so that
    598. ; fgets() and file() will work regardless of the source of the file.
    599. ; auto_detect_line_endings = Off
    600.  
    601.  
    602. ;;;;;;;;;;;;;;;;;;;;;;
    603. ; Dynamic Extensions ;
    604. ;;;;;;;;;;;;;;;;;;;;;;
    605. ;
    606. ; If you wish to have an extension loaded automatically, use the following
    607. ; syntax:
    608. ;
    609. ;   extension=modulename.extension
    610. ;
    611. ; For example, on Windows:
    612. ;
    613. ;   extension=msql.dll
    614. ;
    615. ; ... or under UNIX:
    616. ;
    617. ;   extension=msql.so
    618. ;
    619. ; Note that it should be the name of the module only; no directory information
    620. ; needs to go here.  Specify the location of the extension with the
    621. ; extension_dir directive above.
    622.  
    623.  
    624. ; Windows Extensions
    625. ; Note that ODBC support is built in, so no dll is needed for it.
    626. ; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
    627. ; extension folders as well as the separate PECL DLL download (PHP 5).
    628. ; Be sure to appropriately set the extension_dir directive.
    629.  
    630. ;extension=php_bz2.dll
    631. ;extension=php_curl.dll
    632. ;extension=php_dba.dll
    633. ;extension=php_dbase.dll
    634. ;extension=php_exif.dll
    635. ;extension=php_fdf.dll
    636. ;extension=php_gd2.dll
    637. ;extension=php_gettext.dll
    638. ;extension=php_gmp.dll
    639. ;extension=php_ifx.dll
    640. ;extension=php_imap.dll
    641. ;extension=php_interbase.dll
    642. ;extension=php_ldap.dll
    643. ;extension=php_mbstring.dll
    644. ;extension=php_mcrypt.dll
    645. ;extension=php_mhash.dll
    646. ;extension=php_mime_magic.dll
    647. ;extension=php_ming.dll
    648. ;extension=php_msql.dll
    649. extension=php_mssql.dll
    650. ;extension=php_mysql.dll
    651. ;extension=php_mysqli.dll
    652. ;extension=php_oci8.dll
    653. ;extension=php_openssl.dll
    654. ;extension=php_pdo.dll
    655. ;extension=php_pdo_firebird.dll
    656. ;extension=php_pdo_mssql.dll
    657. ;extension=php_pdo_mysql.dll
    658. ;extension=php_pdo_oci.dll
    659. ;extension=php_pdo_oci8.dll
    660. ;extension=php_pdo_odbc.dll
    661. ;extension=php_pdo_pgsql.dll
    662. ;extension=php_pdo_sqlite.dll
    663. ;extension=php_pgsql.dll
    664. ;extension=php_pspell.dll
    665. ;extension=php_shmop.dll
    666. ;extension=php_snmp.dll
    667. ;extension=php_soap.dll
    668. ;extension=php_sockets.dll
    669. ;extension=php_sqlite.dll
    670. ;extension=php_sybase_ct.dll
    671. ;extension=php_tidy.dll
    672. ;extension=php_xmlrpc.dll
    673. ;extension=php_xsl.dll
    674. ;extension=php_zip.dll
    675.  
    676. ;;;;;;;;;;;;;;;;;;;
    677. ; Module Settings ;
    678. ;;;;;;;;;;;;;;;;;;;
    679.  
    680. [Date]
    681. ; Defines the default timezone used by the date functions
    682. ;date.timezone =
    683.  
    684. ;date.default_latitude = 31.7667
    685. ;date.default_longitude = 35.2333
    686.  
    687. ;date.sunrise_zenith = 90.583333
    688. ;date.sunset_zenith = 90.583333
    689.  
    690. [filter]
    691. ;filter.default = unsafe_raw
    692. ;filter.default_flags =
    693.  
    694. [iconv]
    695. ;iconv.input_encoding = ISO-8859-1
    696. ;iconv.internal_encoding = ISO-8859-1
    697. ;iconv.output_encoding = ISO-8859-1
    698.  
    699. [sqlite]
    700. ;sqlite.assoc_case = 0
    701.  
    702. [xmlrpc]
    703. ;xmlrpc_error_number = 0
    704. ;xmlrpc_errors = 0
    705.  
    706. [Pcre]
    707. ;pcre.recursion_limit=100000
    708. ;pcre.backtrack_limit=100000
    709.  
    710. [Syslog]
    711. ; Whether or not to define the various syslog variables (e.g. $LOG_PID,
    712. ; $LOG_CRON, etc.).  Turning it off is a good idea performance-wise.  In
    713. ; runtime, you can define these variables by calling define_syslog_variables().
    714. define_syslog_variables  = Off
    715.  
    716. [mail function]
    717. ; For Win32 only.
    718. SMTP = localhost
    719. smtp_port = 25
    720.  
    721. ; For Win32 only.
    722. ;sendmail_from = me@example.com
    723.  
    724. ; For Unix only.  You may supply arguments as well (default: "sendmail -t -i").
    725. ;sendmail_path =
    726.  
    727. ; Force the addition of the specified parameters to be passed as extra parameters
    728. ; to the sendmail binary. These parameters will always replace the value of
    729. ; the 5th parameter to mail(), even in safe mode.
    730. ;mail.force_extra_parameters =
    731.  
    732. [SQL]
    733. sql.safe_mode = Off
    734.  
    735. [ODBC]
    736. ;odbc.default_db    =  Not yet implemented
    737. ;odbc.default_user  =  Not yet implemented
    738. ;odbc.default_pw    =  Not yet implemented
    739.  
    740. ; Allow or prevent persistent links.
    741. odbc.allow_persistent = On
    742.  
    743. ; Check that a connection is still valid before reuse.
    744. odbc.check_persistent = On
    745.  
    746. ; Maximum number of persistent links.  -1 means no limit.
    747. odbc.max_persistent = -1
    748.  
    749. ; Maximum number of links (persistent + non-persistent).  -1 means no limit.
    750. odbc.max_links = -1
    751.  
    752. ; Handling of LONG fields.  Returns number of bytes to variables.  0 means
    753. ; passthru.
    754. odbc.defaultlrl = 4096
    755.  
    756. ; Handling of binary data.  0 means passthru, 1 return as is, 2 convert to char.
    757. ; See the documentation on odbc_binmode and odbc_longreadlen for an explanation
    758. ; of uodbc.defaultlrl and uodbc.defaultbinmode
    759. odbc.defaultbinmode = 1
    760.  
    761. [MySQL]
    762. ; Allow or prevent persistent links.
    763. mysql.allow_persistent = On
    764.  
    765. ; Maximum number of persistent links.  -1 means no limit.
    766. mysql.max_persistent = -1
    767.  
    768. ; Maximum number of links (persistent + non-persistent).  -1 means no limit.
    769. mysql.max_links = -1
    770.  
    771. ; Default port number for mysql_connect().  If unset, mysql_connect() will use
    772. ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
    773. ; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
    774. ; at MYSQL_PORT.
    775. mysql.default_port =
    776.  
    777. ; Default socket name for local MySQL connects.  If empty, uses the built-in
    778. ; MySQL defaults.
    779. mysql.default_socket =
    780.  
    781. ; Default host for mysql_connect() (doesn't apply in safe mode).
    782. mysql.default_host =
    783.  
    784. ; Default user for mysql_connect() (doesn't apply in safe mode).
    785. mysql.default_user =
    786.  
    787. ; Default password for mysql_connect() (doesn't apply in safe mode).
    788. ; Note that this is generally a *bad* idea to store passwords in this file.
    789. ; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
    790. ; and reveal this password!  And of course, any users with read access to this
    791. ; file will be able to reveal the password as well.
    792. mysql.default_password =
    793.  
    794. ; Maximum time (in seconds) for connect timeout. -1 means no limit
    795. mysql.connect_timeout = 60
    796.  
    797. ; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
    798. ; SQL-Errors will be displayed.
    799. mysql.trace_mode = Off
    800.  
    801. [MySQLi]
    802.  
    803. ; Maximum number of links.  -1 means no limit.
    804. mysqli.max_links = -1
    805.  
    806. ; Default port number for mysqli_connect().  If unset, mysqli_connect() will use
    807. ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
    808. ; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
    809. ; at MYSQL_PORT.
    810. mysqli.default_port = 3306
    811.  
    812. ; Default socket name for local MySQL connects.  If empty, uses the built-in
    813. ; MySQL defaults.
    814. mysqli.default_socket =
    815.  
    816. ; Default host for mysql_connect() (doesn't apply in safe mode).
    817. mysqli.default_host =
    818.  
    819. ; Default user for mysql_connect() (doesn't apply in safe mode).
    820. mysqli.default_user =
    821.  
    822. ; Default password for mysqli_connect() (doesn't apply in safe mode).
    823. ; Note that this is generally a *bad* idea to store passwords in this file.
    824. ; *Any* user with PHP access can run 'echo get_cfg_var("mysqli.default_pw")
    825. ; and reveal this password!  And of course, any users with read access to this
    826. ; file will be able to reveal the password as well.
    827. mysqli.default_pw =
    828.  
    829. ; Allow or prevent reconnect
    830. mysqli.reconnect = Off
    831.  
    832. [mSQL]
    833. ; Allow or prevent persistent links.
    834. msql.allow_persistent = On
    835.  
    836. ; Maximum number of persistent links.  -1 means no limit.
    837. msql.max_persistent = -1
    838.  
    839. ; Maximum number of links (persistent+non persistent).  -1 means no limit.
    840. msql.max_links = -1
    841.  
    842. [OCI8]
    843. ; enables privileged connections using external credentials (OCI_SYSOPER, OCI_SYSDBA)
    844. ;oci8.privileged_connect = Off
    845.  
    846. ; Connection: The maximum number of persistent OCI8 connections per
    847. ; process. Using -1 means no limit.
    848. ;oci8.max_persistent = -1
    849.  
    850. ; Connection: The maximum number of seconds a process is allowed to
    851. ; maintain an idle persistent connection. Using -1 means idle
    852. ; persistent connections will be maintained forever.
    853. ;oci8.persistent_timeout = -1
    854.  
    855. ; Connection: The number of seconds that must pass before issuing a
    856. ; ping during oci_pconnect() to check the connection validity. When
    857. ; set to 0, each oci_pconnect() will cause a ping. Using -1 disables
    858. ; pings completely.
    859. ;oci8.ping_interval = 60
    860.  
    861. ; Tuning: This option enables statement caching, and specifies how
    862. ; many statements to cache. Using 0 disables statement caching.
    863. ;oci8.statement_cache_size = 20
    864.  
    865. ; Tuning: Enables statement prefetching and sets the default number of
    866. ; rows that will be fetched automatically after statement execution.
    867. ;oci8.default_prefetch = 10
    868.  
    869. ; Compatibility. Using On means oci_close() will not close
    870. ; oci_connect() and oci_new_connect() connections.
    871. ;oci8.old_oci_close_semantics = Off
    872.  
    873. [PostgresSQL]
    874. ; Allow or prevent persistent links.
    875. pgsql.allow_persistent = On
    876.  
    877. ; Detect broken persistent links always with pg_pconnect().
    878. ; Auto reset feature requires a little overheads.
    879. pgsql.auto_reset_persistent = Off
    880.  
    881. ; Maximum number of persistent links.  -1 means no limit.
    882. pgsql.max_persistent = -1
    883.  
    884. ; Maximum number of links (persistent+non persistent).  -1 means no limit.
    885. pgsql.max_links = -1
    886.  
    887. ; Ignore PostgreSQL backends Notice message or not.
    888. ; Notice message logging require a little overheads.
    889. pgsql.ignore_notice = 0
    890.  
    891. ; Log PostgreSQL backends Noitce message or not.
    892. ; Unless pgsql.ignore_notice=0, module cannot log notice message.
    893. pgsql.log_notice = 0
    894.  
    895. [Sybase]
    896. ; Allow or prevent persistent links.
    897. sybase.allow_persistent = On
    898.  
    899. ; Maximum number of persistent links.  -1 means no limit.
    900. sybase.max_persistent = -1
    901.  
    902. ; Maximum number of links (persistent + non-persistent).  -1 means no limit.
    903. sybase.max_links = -1
    904.  
    905. ;sybase.interface_file = "/usr/sybase/interfaces"
    906.  
    907. ; Minimum error severity to display.
    908. sybase.min_error_severity = 10
    909.  
    910. ; Minimum message severity to display.
    911. sybase.min_message_severity = 10
    912.  
    913. ; Compatibility mode with old versions of PHP 3.0.
    914. ; If on, this will cause PHP to automatically assign types to results according
    915. ; to their Sybase type, instead of treating them all as strings.  This
    916. ; compatibility mode will probably not stay around forever, so try applying
    917. ; whatever necessary changes to your code, and turn it off.
    918. sybase.compatability_mode = Off
    919.  
    920. [Sybase-CT]
    921. ; Allow or prevent persistent links.
    922. sybct.allow_persistent = On
    923.  
    924. ; Maximum number of persistent links.  -1 means no limit.
    925. sybct.max_persistent = -1
    926.  
    927. ; Maximum number of links (persistent + non-persistent).  -1 means no limit.
    928. sybct.max_links = -1
    929.  
    930. ; Minimum server message severity to display.
    931. sybct.min_server_severity = 10
    932.  
    933. ; Minimum client message severity to display.
    934. sybct.min_client_severity = 10
    935.  
    936. [bcmath]
    937. ; Number of decimal digits for all bcmath functions.
    938. bcmath.scale = 0
    939.  
    940. [browscap]
    941. ;browscap = extra/browscap.ini
    942.  
    943. [Informix]
    944. ; Default host for ifx_connect() (doesn't apply in safe mode).
    945. ifx.default_host =
    946.  
    947. ; Default user for ifx_connect() (doesn't apply in safe mode).
    948. ifx.default_user =
    949.  
    950. ; Default password for ifx_connect() (doesn't apply in safe mode).
    951. ifx.default_password =
    952.  
    953. ; Allow or prevent persistent links.
    954. ifx.allow_persistent = On
    955.  
    956. ; Maximum number of persistent links.  -1 means no limit.
    957. ifx.max_persistent = -1
    958.  
    959. ; Maximum number of links (persistent + non-persistent).  -1 means no limit.
    960. ifx.max_links = -1
    961.  
    962. ; If on, select statements return the contents of a text blob instead of its id.
    963. ifx.textasvarchar = 0
    964.  
    965. ; If on, select statements return the contents of a byte blob instead of its id.
    966. ifx.byteasvarchar = 0
    967.  
    968. ; Trailing blanks are stripped from fixed-length char columns.  May help the
    969. ; life of Informix SE users.
    970. ifx.charasvarchar = 0
    971.  
    972. ; If on, the contents of text and byte blobs are dumped to a file instead of
    973. ; keeping them in memory.
    974. ifx.blobinfile = 0
    975.  
    976. ; NULL's are returned as empty strings, unless this is set to 1.  In that case,
    977. ; NULL's are returned as string 'NULL'.
    978. ifx.nullformat = 0
    979.  
    980. [Session]
    981. ; Handler used to store/retrieve data.
    982. session.save_handler = files
    983.  
    984. ; Argument passed to save_handler.  In the case of files, this is the path
    985. ; where data files are stored. Note: Windows users have to change this
    986. ; variable in order to use PHP's session functions.
    987. ;
    988. ; As of PHP 4.0.1, you can define the path as:
    989. ;
    990. ;     session.save_path = "N;/path"
    991. ;
    992. ; where N is an integer.  Instead of storing all the session files in
    993. ; /path, what this will do is use subdirectories N-levels deep, and
    994. ; store the session data in those directories.  This is useful if you
    995. ; or your OS have problems with lots of files in one directory, and is
    996. ; a more efficient layout for servers that handle lots of sessions.
    997. ;
    998. ; NOTE 1: PHP will not create this directory structure automatically.
    999. ;         You can use the script in the ext/session dir for that purpose.
    1000. ; NOTE 2: See the section on garbage collection below if you choose to
    1001. ;         use subdirectories for session storage
    1002. ;
    1003. ; The file storage module creates files using mode 600 by default.
    1004. ; You can change that by using
    1005. ;
    1006. ;     session.save_path = "N;MODE;/path"
    1007. ;
    1008. ; where MODE is the octal representation of the mode. Note that this
    1009. ; does not overwrite the process's umask.
    1010. ;session.save_path = "/tmp"
    1011.  
    1012. ; Whether to use cookies.
    1013. session.use_cookies = 1
    1014.  
    1015. ;session.cookie_secure =
    1016.  
    1017. ; This option enables administrators to make their users invulnerable to
    1018. ; attacks which involve passing session ids in URLs; defaults to 0.
    1019. ; session.use_only_cookies = 1
    1020.  
    1021. ; Name of the session (used as cookie name).
    1022. session.name = PHPSESSID
    1023.  
    1024. ; Initialize session on request startup.
    1025. session.auto_start = 0
    1026.  
    1027. ; Lifetime in seconds of cookie or, if 0, until browser is restarted.
    1028. session.cookie_lifetime = 0
    1029.  
    1030. ; The path for which the cookie is valid.
    1031. session.cookie_path = /
    1032.  
    1033. ; The domain for which the cookie is valid.
    1034. session.cookie_domain =
    1035.  
    1036. ; Whether or not to add the httpOnly flag to the cookie, which makes it inaccessible to browser scripting languages such as JavaScript.
    1037. session.cookie_httponly =
    1038.  
    1039. ; Handler used to serialize data.  php is the standard serializer of PHP.
    1040. session.serialize_handler = php
    1041.  
    1042. ; Define the probability that the 'garbage collection' process is started
    1043. ; on every session initialization.
    1044. ; The probability is calculated by using gc_probability/gc_divisor,
    1045. ; e.g. 1/100 means there is a 1% chance that the GC process starts
    1046. ; on each request.
    1047.  
    1048. session.gc_probability = 1
    1049. session.gc_divisor     = 1000
    1050.  
    1051. ; After this number of seconds, stored data will be seen as 'garbage' and
    1052. ; cleaned up by the garbage collection process.
    1053. session.gc_maxlifetime = 1440
    1054.  
    1055. ; NOTE: If you are using the subdirectory option for storing session files
    1056. ;       (see session.save_path above), then garbage collection does *not*
    1057. ;       happen automatically.  You will need to do your own garbage
    1058. ;       collection through a shell script, cron entry, or some other method.
    1059. ;       For example, the following script would is the equivalent of
    1060. ;       setting session.gc_maxlifetime to 1440 (1440 seconds = 24 minutes):
    1061. ;          cd /path/to/sessions; find -cmin +24 | xargs rm
    1062.  
    1063. ; PHP 4.2 and less have an undocumented feature/bug that allows you to
    1064. ; to initialize a session variable in the global scope, albeit register_globals
    1065. ; is disabled.  PHP 4.3 and later will warn you, if this feature is used.
    1066. ; You can disable the feature and the warning separately. At this time,
    1067. ; the warning is only displayed, if bug_compat_42 is enabled.
    1068.  
    1069. session.bug_compat_42 = 0
    1070. session.bug_compat_warn = 1
    1071.  
    1072. ; Check HTTP Referer to invalidate externally stored URLs containing ids.
    1073. ; HTTP_REFERER has to contain this substring for the session to be
    1074. ; considered as valid.
    1075. session.referer_check =
    1076.  
    1077. ; How many bytes to read from the file.
    1078. session.entropy_length = 0
    1079.  
    1080. ; Specified here to create the session id.
    1081. session.entropy_file =
    1082.  
    1083. ;session.entropy_length = 16
    1084.  
    1085. ;session.entropy_file = /dev/urandom
    1086.  
    1087. ; Set to {nocache,private,public,} to determine HTTP caching aspects
    1088. ; or leave this empty to avoid sending anti-caching headers.
    1089. session.cache_limiter = nocache
    1090.  
    1091. ; Document expires after n minutes.
    1092. session.cache_expire = 180
    1093.  
    1094. ; trans sid support is disabled by default.
    1095. ; Use of trans sid may risk your users security.
    1096. ; Use this option with caution.
    1097. ; - User may send URL contains active session ID
    1098. ;   to other person via. email/irc/etc.
    1099. ; - URL that contains active session ID may be stored
    1100. ;   in publically accessible computer.
    1101. ; - User may access your site with the same session ID
    1102. ;   always using URL stored in browser's history or bookmarks.
    1103. session.use_trans_sid = 0
    1104.  
    1105. ; Select a hash function
    1106. ; 0: MD5   (128 bits)
    1107. ; 1: SHA-1 (160 bits)
    1108. session.hash_function = 0
    1109.  
    1110. ; Define how many bits are stored in each character when converting
    1111. ; the binary hash data to something readable.
    1112. ;
    1113. ; 4 bits: 0-9, a-f
    1114. ; 5 bits: 0-9, a-v
    1115. ; 6 bits: 0-9, a-z, A-Z, "-", ","
    1116. session.hash_bits_per_character = 5
    1117.  
    1118. ; The URL rewriter will look for URLs in a defined set of HTML tags.
    1119. ; form/fieldset are special; if you include them here, the rewriter will
    1120. ; add a hidden <input> field with the info which is otherwise appended
    1121. ; to URLs.  If you want XHTML conformity, remove the form entry.
    1122. ; Note that all valid entries require a "=", even if no value follows.
    1123. url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=fakeentry"
    1124.  
    1125. [MSSQL]
    1126. ; Allow or prevent persistent links.
    1127. mssql.allow_persistent = On
    1128.  
    1129. ; Maximum number of persistent links.  -1 means no limit.
    1130. mssql.max_persistent = -1
    1131.  
    1132. ; Maximum number of links (persistent+non persistent).  -1 means no limit.
    1133. mssql.max_links = -1
    1134.  
    1135. ; Minimum error severity to display.
    1136. mssql.min_error_severity = 10
    1137.  
    1138. ; Minimum message severity to display.
    1139. mssql.min_message_severity = 10
    1140.  
    1141. ; Compatibility mode with old versions of PHP 3.0.
    1142. mssql.compatability_mode = Off
    1143.  
    1144. ; Connect timeout
    1145. ;mssql.connect_timeout = 5
    1146.  
    1147. ; Query timeout
    1148. ;mssql.timeout = 60
    1149.  
    1150. ; Valid range 0 - 2147483647.  Default = 4096.
    1151. ;mssql.textlimit = 4096
    1152.  
    1153. ; Valid range 0 - 2147483647.  Default = 4096.
    1154. ;mssql.textsize = 4096
    1155.  
    1156. ; Limits the number of records in each batch.  0 = all records in one batch.
    1157. ;mssql.batchsize = 0
    1158.  
    1159. ; Specify how datetime and datetim4 columns are returned
    1160. ; On => Returns data converted to SQL server settings
    1161. ; Off => Returns values as YYYY-MM-DD hh:mm:ss
    1162. ;mssql.datetimeconvert = On
    1163.  
    1164. ; Use NT authentication when connecting to the server
    1165. mssql.secure_connection = Off
    1166.  
    1167. ; Specify max number of processes. -1 = library default
    1168. ; msdlib defaults to 25
    1169. ; FreeTDS defaults to 4096
    1170. ;mssql.max_procs = -1
    1171.  
    1172. ; Specify client character set.
    1173. ; If empty or not set the client charset from freetds.comf is used
    1174. ; This is only used when compiled with FreeTDS
    1175. ;mssql.charset = "ISO-8859-1"
    1176.  
    1177. [Assertion]
    1178. ; Assert(expr); active by default.
    1179. ;assert.active = On
    1180.  
    1181. ; Issue a PHP warning for each failed assertion.
    1182. ;assert.warning = On
    1183.  
    1184. ; Don't bail out by default.
    1185. ;assert.bail = Off
    1186.  
    1187. ; User-function to be called if an assertion fails.
    1188. ;assert.callback = 0
    1189.  
    1190. ; Eval the expression with current error_reporting().  Set to true if you want
    1191. ; error_reporting(0) around the eval().
    1192. ;assert.quiet_eval = 0
    1193.  
    1194. [COM]
    1195. ; path to a file containing GUIDs, IIDs or filenames of files with TypeLibs
    1196. ;com.typelib_file =
    1197. ; allow Distributed-COM calls
    1198. ;com.allow_dcom = true
    1199. ; autoregister constants of a components typlib on com_load()
    1200. ;com.autoregister_typelib = true
    1201. ; register constants casesensitive
    1202. ;com.autoregister_casesensitive = false
    1203. ; show warnings on duplicate constant registrations
    1204. ;com.autoregister_verbose = true
    1205.  
    1206. [mbstring]
    1207. ; language for internal character representation.
    1208. ;mbstring.language = Japanese
    1209.  
    1210. ; internal/script encoding.
    1211. ; Some encoding cannot work as internal encoding.
    1212. ; (e.g. SJIS, BIG5, ISO-2022-*)
    1213. ;mbstring.internal_encoding = EUC-JP
    1214.  
    1215. ; http input encoding.
    1216. ;mbstring.http_input = auto
    1217.  
    1218. ; http output encoding. mb_output_handler must be
    1219. ; registered as output buffer to function
    1220. ;mbstring.http_output = SJIS
    1221.  
    1222. ; enable automatic encoding translation according to
    1223. ; mbstring.internal_encoding setting. Input chars are
    1224. ; converted to internal encoding by setting this to On.
    1225. ; Note: Do _not_ use automatic encoding translation for
    1226. ;       portable libs/applications.
    1227. ;mbstring.encoding_translation = Off
    1228.  
    1229. ; automatic encoding detection order.
    1230. ; auto means
    1231. ;mbstring.detect_order = auto
    1232.  
    1233. ; substitute_character used when character cannot be converted
    1234. ; one from another
    1235. ;mbstring.substitute_character = none;
    1236.  
    1237. ; overload(replace) single byte functions by mbstring functions.
    1238. ; mail(), ereg(), etc are overloaded by mb_send_mail(), mb_ereg(),
    1239. ; etc. Possible values are 0,1,2,4 or combination of them.
    1240. ; For example, 7 for overload everything.
    1241. ; 0: No overload
    1242. ; 1: Overload mail() function
    1243. ; 2: Overload str*() functions
    1244. ; 4: Overload ereg*() functions
    1245. ;mbstring.func_overload = 0
    1246.  
    1247. ; enable strict encoding detection.
    1248. ;mbstring.strict_encoding = Off
    1249.  
    1250. [FrontBase]
    1251. ;fbsql.allow_persistent = On
    1252. ;fbsql.autocommit = On
    1253. ;fbsql.show_timestamp_decimals = Off
    1254. ;fbsql.default_database =
    1255. ;fbsql.default_database_password =
    1256. ;fbsql.default_host =
    1257. ;fbsql.default_password =
    1258. ;fbsql.default_user = "_SYSTEM"
    1259. ;fbsql.generate_warnings = Off
    1260. ;fbsql.max_connections = 128
    1261. ;fbsql.max_links = 128
    1262. ;fbsql.max_persistent = -1
    1263. ;fbsql.max_results = 128
    1264.  
    1265. [gd]
    1266. ; Tell the jpeg decode to libjpeg warnings and try to create
    1267. ; a gd image. The warning will then be displayed as notices
    1268. ; disabled by default
    1269. ;gd.jpeg_ignore_warning = 0
    1270.  
    1271. [exif]
    1272. ; Exif UNICODE user comments are handled as UCS-2BE/UCS-2LE and JIS as JIS.
    1273. ; With mbstring support this will automatically be converted into the encoding
    1274. ; given by corresponding encode setting. When empty mbstring.internal_encoding
    1275. ; is used. For the decode settings you can distinguish between motorola and
    1276. ; intel byte order. A decode setting cannot be empty.
    1277. ;exif.encode_unicode = ISO-8859-15
    1278. ;exif.decode_unicode_motorola = UCS-2BE
    1279. ;exif.decode_unicode_intel    = UCS-2LE
    1280. ;exif.encode_jis =
    1281. ;exif.decode_jis_motorola = JIS
    1282. ;exif.decode_jis_intel    = JIS
    1283.  
    1284. [Tidy]
    1285. ; The path to a default tidy configuration file to use when using tidy
    1286. ;tidy.default_config = /usr/local/lib/php/default.tcfg
    1287.  
    1288. ; Should tidy clean and repair output automatically?
    1289. ; WARNING: Do not use this option if you are generating non-html content
    1290. ; such as dynamic images
    1291. tidy.clean_output = Off
    1292.  
    1293. [soap]
    1294. ; Enables or disables WSDL caching feature.
    1295. soap.wsdl_cache_enabled=1
    1296. ; Sets the directory name where SOAP extension will put cache files.
    1297. soap.wsdl_cache_dir="/tmp"
    1298. ; (time to live) Sets the number of second while cached file will be used
    1299. ; instead of original one.
    1300. soap.wsdl_cache_ttl=86400
    1301.  
    1302. ; Local Variables:
    1303. ; tab-width: 4
    1304. ; End:
     
  22. Святой

    Святой Активный пользователь

    С нами с:
    24 июн 2008
    Сообщения:
    3
    Симпатии:
    0
    Народ! вопрошаю! помогите!
     
  23. Святой

    Святой Активный пользователь

    С нами с:
    24 июн 2008
    Сообщения:
    3
    Симпатии:
    0
    неимоверными усилиями я наконец получил сообщение об ошибке
    Код (Text):
    1. Fatal error: Call to undefined function mssql_connect() in D:\inetpub\wwwroot\denr.php on line 14
    но как ее исправить так и не знаю. все в ini файле прописано как в мануале было сказано. в переменных средах добавлены пути: d:\php\ и d:\php\ext\.
    имя сервера писал и так
    Код (Text):
    1. $dbl   =    '127.0.0.1';
    и так
    Код (Text):
    1. $dbl   =    'ORACLE';
    и так
    Код (Text):
    1. $dbl   =    'localhost';
    еще пробовал и такой вариант:
    Код (Text):
    1. $db = new COM("ADODB.Connection") or die("Cannot start ADO");
    2.     $dsn = "DRIVER={SQL Server}; SERVER={ORACLE}; DATABASE={Econ(так называется моя база)}";
    3.     $db->Open($dsn);
    но здесь сообщение об ошибки уже формулируется вот так:
    Код (Text):
    1. Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'MASTER\IUSR_ORACLE'.' in D:\inetpub\wwwroot\denr.php:18 Stack trace: #0 D:\inetpub\wwwroot\denr.php(18): com->Open('DRIVER={SQL Ser...') #1 {main} thrown in D:\inetpub\wwwroot\denr.php on line 18
    помогите кто-нибудь! уже третий день не могу решить проблему![/code][/quote]
     
  24. MaxXxam

    MaxXxam Активный пользователь

    С нами с:
    20 июл 2008
    Сообщения:
    9
    Симпатии:
    0
    Та же проблема... Fatal error: Call to undefined function mssql_connect()

    Имеется ли какое-нибудь решение ??? MSSQL 2005 и PHP ни как не хотят дружить... Перепробывал уже много вариантов ни чего не помогает... В php.ini снял комментарий с php_mssql.dll

    Давайте наконец найдем решение этой проблемы... оч нужно...
     
  25. kpn152

    kpn152 Активный пользователь

    С нами с:
    11 фев 2009
    Сообщения:
    1
    Симпатии:
    0
    используй функции sybase