Précédent   Forum du club des développeurs et IT Pro > Bases de données > Oracle > Connexions aux bases de données
Connexions aux bases de données Forum d'entraide sur les problèmes de connectivité Oracle
Partagez cette discussion sur d'autres réseaux sociaux : Viadeo Twitter Google Facebook Digg Delicious MySpace Yahoo
Réponse
 
Outils de la discussion
Publicité
'
Vieux 21/08/2012, 14h07   #1
Feldunost
Invité régulier
 
Fabien
Inscription : avril 2010
Messages : 73
Détails du profil
Informations personnelles :
Nom : Fabien

Informations forums :
Inscription : avril 2010
Messages : 73
Points : 8
Points : 8
Par défaut [11G R2] Connexions Simultanées OCI8/Instantclient

Bonjour,


Je suis actuellement avec cette configuration fonctionnelle :

- Debian 6 Squeeze
- Nginx 1.2.3
- PHP5
- PHP-FPM
- Xcache
- Mysql
- Oracle OCI8.so
- Instant Client 11 Basic & SDK



Tout cela a été installé, et fonctionne à merveille comme le laisse suggérer phpinfo:
- Je n'ai pas encore installé PDO_OCI, même s'il ne semble pas être réellement nécessaire pour initialiser une connexion sur une base de données Oracle -

Code :
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
 
PHP Logo
PHP Version 5.3.16
 
System 	Linux arch5454165 2.6.32-5-amd64 #1 SMP Sun May 6 04:00:17 UTC 2012 x86_64
Build Date 	Aug 17 2012 22:08:11
Server API 	FPM/FastCGI
Virtual Directory Support 	disabled
Configuration File (php.ini) Path 	/etc/php5/fpm
Loaded Configuration File 	/etc/php5/fpm/php.ini
Scan this dir FOR additional .ini files 	/etc/php5/fpm/conf.d
Additional .ini files parsed 	/etc/php5/fpm/conf.d/curl.ini, /etc/php5/fpm/conf.d/gd.ini, /etc/php5/fpm/conf.d/mcrypt.ini, /etc/php5/fpm/conf.d/mysql.ini, /etc/php5/fpm/conf.d/mysqli.ini, /etc/php5/fpm/conf.d/oci8.ini, /etc/php5/fpm/conf.d/pdo.ini, /etc/php5/fpm/conf.d/pdo_mysql.ini, /etc/php5/fpm/conf.d/redis.ini, /etc/php5/fpm/conf.d/suhosin.ini, /etc/php5/fpm/conf.d/xcache.ini
PHP API 	20090626
PHP Extension 	20090626
Zend Extension 	220090626
Zend Extension Build 	API220090626,NTS
PHP Extension Build 	API20090626,NTS
Debug Build 	no
Thread Safety 	disabled
Zend Memory Manager 	enabled
Zend Multibyte Support 	disabled
IPv6 Support 	enabled
Registered PHP Streams 	https, ftps, compress.zlib, compress.bzip2, php, file, glob, DATA, http, ftp, phar, zip
Registered Stream Socket Transports 	tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
Registered Stream Filters 	zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, mcrypt.*, mdecrypt.*
 
Suhosin logo This server IS protected WITH the Suhosin Patch 0.9.10
Copyright (c) 2006-2007 Hardened-PHP Project Copyright (c) 2007-2012 SektionEins GmbH
 
Zend logo This program makes USE of the Zend Scripting LANGUAGE Engine:
Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies
    WITH Suhosin v0.9.33, Copyright (c) 2007-2012, BY SektionEins GmbH
 
PHP Credits
Configuration
bcmath
BCMath support 	enabled
 
Directive	LOCAL Value	Master Value
bcmath.scale	0	0
 
bz2
BZip2 Support 	Enabled
Stream Wrapper support 	compress.bzip2://
Stream Filter support 	bzip2.decompress, bzip2.compress
BZip2 Version 	1.0.5, 10-Dec-2007
 
calendar
Calendar support 	enabled
 
cgi-fcgi
php-fpm 	active
 
Directive	LOCAL Value	Master Value
cgi.discard_path	0	0
cgi.fix_pathinfo	0	0
cgi.force_redirect	1	1
cgi.nph	0	0
cgi.redirect_status_env	no value	no value
cgi.rfc2616_headers	0	0
fastcgi.error_header	no value	no value
fastcgi.logging	1	1
fpm.config	no value	no value
 
Core
PHP Version 	5.3.16-1~dotdeb.0
 
Directive	LOCAL Value	Master Value
allow_call_time_pass_reference	Off	Off
allow_url_fopen	ON	ON
allow_url_include	Off	Off
always_populate_raw_post_data	Off	Off
arg_separator.input	&	&
arg_separator.output	&	&
asp_tags	Off	Off
auto_append_file	no value	no value
auto_globals_jit	ON	ON
auto_prepend_file	no value	no value
browscap	no value	no value
default_charset	utf-8	utf-8
default_mimetype	text/html	text/html
define_syslog_variables	Off	Off
disable_classes	no value	no value
disable_functions	no value	no value
display_errors	Off	Off
display_startup_errors	Off	Off
doc_root	no value	no value
docref_ext	no value	no value
docref_root	no value	no value
enable_dl	Off	Off
error_append_string	no value	no value
error_log	no value	no value
error_prepend_string	no value	no value
error_reporting	22527	22527
exit_on_timeout	Off	Off
expose_php	ON	ON
extension_dir	/usr/lib/php5/20090626	/usr/lib/php5/20090626
file_uploads	ON	ON
highlight.bg	#FFFFFF	#FFFFFF
highlight.comment	#FF8000	#FF8000
highlight.DEFAULT	#0000BB	#0000BB
highlight.html	#000000	#000000
highlight.keyword	#007700	#007700
highlight.string	#DD0000	#DD0000
html_errors	Off	Off
ignore_repeated_errors	Off	Off
ignore_repeated_source	Off	Off
ignore_user_abort	Off	Off
implicit_flush	Off	Off
include_path	.:/usr/share/php:/usr/share/pear	.:/usr/share/php:/usr/share/pear
log_errors	ON	ON
log_errors_max_len	1024	1024
magic_quotes_gpc	Off	Off
magic_quotes_runtime	Off	Off
magic_quotes_sybase	Off	Off
mail.add_x_header	ON	ON
mail.force_extra_parameters	no value	no value
mail.log	no value	no value
max_execution_time	30	30
max_file_uploads	20	20
max_input_nesting_level	64	64
max_input_time	60	60
max_input_vars	1000	1000
memory_limit	128M	128M
open_basedir	no value	no value
output_buffering	4096	4096
output_handler	no value	no value
post_max_size	8M	8M
precision	14	14
realpath_cache_size	16K	16K
realpath_cache_ttl	120	120
register_argc_argv	Off	Off
register_globals	Off	Off
register_long_arrays	Off	Off
report_memleaks	ON	ON
report_zend_debug	ON	ON
request_order	GP	GP
safe_mode	Off	Off
safe_mode_exec_dir	no value	no value
safe_mode_gid	Off	Off
safe_mode_include_dir	no value	no value
sendmail_from	no value	no value
sendmail_path	/usr/sbin/sendmail -t -i 	/usr/sbin/sendmail -t -i 
serialize_precision	17	17
short_open_tag	Off	Off
SMTP	localhost	localhost
smtp_port	25	25
sql.safe_mode	Off	Off
track_errors	Off	Off
unserialize_callback_func	no value	no value
upload_max_filesize	2M	2M
upload_tmp_dir	no value	no value
user_dir	no value	no value
user_ini.cache_ttl	300	300
user_ini.filename	.user.ini	.user.ini
variables_order	GPCS	GPCS
xmlrpc_error_number	0	0
xmlrpc_errors	Off	Off
y2k_compliance	ON	ON
zend.enable_gc	ON	ON
 
ctype
ctype functions 	enabled
 
curl
cURL support 	enabled
cURL Information 	7.21.0
Age 	3
Features
AsynchDNS 	No
Debug 	No
GSS-Negotiate 	Yes
IDN 	Yes
IPv6 	Yes
Largefile 	Yes
NTLM 	Yes
SPNEGO 	No
SSL 	Yes
SSPI 	No
krb4 	No
libz 	Yes
CharConv 	No
Protocols 	dict, file, ftp, ftps, http, https, imap, imaps, ldap, ldaps, pop3, pop3s, rtsp, scp, sftp, smtp, smtps, telnet, tftp
Host 	x86_64-pc-linux-gnu
SSL Version 	OpenSSL/0.9.8o
ZLib Version 	1.2.3.4
libSSH Version 	libssh2/1.2.6
 
date
date/time support 	enabled
"Olson" Timezone DATABASE Version 	2012.3
Timezone DATABASE 	internal
DEFAULT timezone 	Europe/Paris
 
Directive	LOCAL Value	Master Value
date.default_latitude	31.7667	31.7667
date.default_longitude	35.2333	35.2333
date.sunrise_zenith	90.583333	90.583333
date.sunset_zenith	90.583333	90.583333
date.timezone	Europe/Paris	Europe/Paris
 
dba
DBA support 	enabled
Supported handlers 	cdb cdb_make db4 inifile flatfile qdbm
 
Directive	LOCAL Value	Master Value
dba.default_handler	flatfile	flatfile
 
dom
DOM/XML 	enabled
DOM/XML API Version 	20031129
libxml Version 	2.7.8
HTML Support 	enabled
XPath Support 	enabled
XPointer Support 	enabled
Schema Support 	enabled
RelaxNG Support 	enabled
 
ereg
Regex Library 	Bundled library enabled
 
exif
EXIF Support 	enabled
EXIF Version 	1.4 $Id$
Supported EXIF Version 	0220
Supported filetypes 	JPEG,TIFF
 
Directive	LOCAL Value	Master Value
exif.decode_jis_intel	JIS	JIS
exif.decode_jis_motorola	JIS	JIS
exif.decode_unicode_intel	UCS-2LE	UCS-2LE
exif.decode_unicode_motorola	UCS-2BE	UCS-2BE
exif.encode_jis	no value	no value
exif.encode_unicode	ISO-8859-15	ISO-8859-15
 
fileinfo
fileinfo support 	enabled
version 	1.0.5-dev
 
filter
Input Validation AND Filtering 	enabled
Revision 	$Id: 2b8c730d7dfaa8485d07cd792f0c82852ffe4113 $
 
Directive	LOCAL Value	Master Value
filter.DEFAULT	unsafe_raw	unsafe_raw
filter.default_flags	no value	no value
 
ftp
FTP support 	enabled
 
gd
GD Support 	enabled
GD Version 	bundled (2.0.34 compatible)
FreeType Support 	enabled
FreeType Linkage 	WITH freetype
FreeType Version 	2.4.2
T1Lib Support 	enabled
GIF READ Support 	enabled
GIF CREATE Support 	enabled
JPEG Support 	enabled
libJPEG Version 	6b
PNG Support 	enabled
libPNG Version 	1.2.44
WBMP Support 	enabled
XPM Support 	enabled
XBM Support 	enabled
 
Directive	LOCAL Value	Master Value
gd.jpeg_ignore_warning	0	0
 
gettext
GetText Support 	enabled
 
hash
hash support 	enabled
Hashing Engines 	md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost adler32 crc32 crc32b salsa10 salsa20 haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5
 
iconv
iconv support 	enabled
iconv implementation 	glibc
iconv library version 	2.11.3
 
Directive	LOCAL Value	Master Value
iconv.input_encoding	ISO-8859-1	ISO-8859-1
iconv.internal_encoding	ISO-8859-1	ISO-8859-1
iconv.output_encoding	ISO-8859-1	ISO-8859-1
 
json
json support 	enabled
json version 	1.2.1
 
libxml
libXML support 	active
libXML Compiled Version 	2.7.8
libXML Loaded Version 	20708
libXML streams 	enabled
 
mbstring
Multibyte Support 	enabled
Multibyte string engine 	libmbfl
HTTP input encoding translation 	disabled
 
mbstring extension makes USE of "streamable kanji code filter and converter", which IS distributed under the GNU Lesser General Public License version 2.1.
 
Multibyte (japanese) regex support 	enabled
Multibyte regex (oniguruma) version 	5.9.1
 
Directive	LOCAL Value	Master Value
mbstring.detect_order	no value	no value
mbstring.encoding_translation	Off	Off
mbstring.func_overload	0	0
mbstring.http_input	pass	pass
mbstring.http_output	pass	pass
mbstring.http_output_conv_mimetypes	^(text/|application/xhtml\+xml)	^(text/|application/xhtml\+xml)
mbstring.internal_encoding	no value	no value
mbstring.LANGUAGE	neutral	neutral
mbstring.strict_detection	Off	Off
mbstring.substitute_character	no value	no value
 
mcrypt
mcrypt support	enabled
mcrypt_filter support	enabled
Version 	2.5.8
Api No 	20021217
Supported ciphers 	cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes
Supported modes 	cbc cfb ctr ecb ncfb nofb ofb stream
 
Directive	LOCAL Value	Master Value
mcrypt.algorithms_dir	no value	no value
mcrypt.modes_dir	no value	no value
 
mhash
MHASH support 	Enabled
MHASH API Version 	Emulated Support
 
mysql
MySQL Support	enabled
Active Persistent Links 	0
Active Links 	0
Client API version 	mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $
 
Directive	LOCAL Value	Master Value
mysql.allow_local_infile	ON	ON
mysql.allow_persistent	ON	ON
mysql.connect_timeout	60	60
mysql.default_host	no value	no value
mysql.default_password	no value	no value
mysql.default_port	no value	no value
mysql.default_socket	/var/run/mysqld/mysqld.sock	/var/run/mysqld/mysqld.sock
mysql.default_user	no value	no value
mysql.max_links	Unlimited	Unlimited
mysql.max_persistent	Unlimited	Unlimited
mysql.trace_mode	Off	Off
 
mysqli
MysqlI Support	enabled
Client API library version 	mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $
Active Persistent Links 	0
Inactive Persistent Links 	0
Active Links 	0
 
Directive	LOCAL Value	Master Value
mysqli.allow_local_infile	ON	ON
mysqli.allow_persistent	ON	ON
mysqli.default_host	no value	no value
mysqli.default_port	3306	3306
mysqli.default_pw	no value	no value
mysqli.default_socket	/var/run/mysqld/mysqld.sock	/var/run/mysqld/mysqld.sock
mysqli.default_user	no value	no value
mysqli.max_links	Unlimited	Unlimited
mysqli.max_persistent	Unlimited	Unlimited
mysqli.reconnect	Off	Off
 
mysqlnd
mysqlnd	enabled
Version 	mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $
Compression 	supported
SSL 	supported
Command buffer size 	4096
READ buffer size 	32768
READ timeout 	31536000
Collecting statistics 	Yes
Collecting memory statistics 	No
Tracing 	n/a
 
Client statistics	
bytes_sent 	0
bytes_received 	0
packets_sent 	0
packets_received 	0
protocol_overhead_in 	0
protocol_overhead_out 	0
bytes_received_ok_packet 	0
bytes_received_eof_packet 	0
bytes_received_rset_header_packet 	0
bytes_received_rset_field_meta_packet 	0
bytes_received_rset_row_packet 	0
bytes_received_prepare_response_packet 	0
bytes_received_change_user_packet 	0
packets_sent_command 	0
packets_received_ok 	0
packets_received_eof 	0
packets_received_rset_header 	0
packets_received_rset_field_meta 	0
packets_received_rset_row 	0
packets_received_prepare_response 	0
packets_received_change_user 	0
result_set_queries 	0
non_result_set_queries 	0
no_index_used 	0
bad_index_used 	0
slow_queries 	0
buffered_sets 	0
unbuffered_sets 	0
ps_buffered_sets 	0
ps_unbuffered_sets 	0
flushed_normal_sets 	0
flushed_ps_sets 	0
ps_prepared_never_executed 	0
ps_prepared_once_executed 	0
rows_fetched_from_server_normal 	0
rows_fetched_from_server_ps 	0
rows_buffered_from_client_normal 	0
rows_buffered_from_client_ps 	0
rows_fetched_from_client_normal_buffered 	0
rows_fetched_from_client_normal_unbuffered 	0
rows_fetched_from_client_ps_buffered 	0
rows_fetched_from_client_ps_unbuffered 	0
rows_fetched_from_client_ps_cursor 	0
rows_affected_normal 	0
rows_affected_ps 	0
rows_skipped_normal 	0
rows_skipped_ps 	0
copy_on_write_saved 	0
copy_on_write_performed 	0
command_buffer_too_small 	0
connect_success 	0
connect_failure 	0
connection_reused 	0
reconnect 	0
pconnect_success 	0
active_connections 	0
active_persistent_connections 	0
explicit_close 	0
implicit_close 	0
disconnect_close 	0
in_middle_of_command_close 	0
explicit_free_result 	0
implicit_free_result 	0
explicit_stmt_close 	0
implicit_stmt_close 	0
mem_emalloc_count 	0
mem_emalloc_amount 	0
mem_ecalloc_count 	0
mem_ecalloc_amount 	0
mem_erealloc_count 	0
mem_erealloc_amount 	0
mem_efree_count 	0
mem_efree_amount 	0
mem_malloc_count 	0
mem_malloc_amount 	0
mem_calloc_count 	0
mem_calloc_amount 	0
mem_realloc_count 	0
mem_realloc_amount 	0
mem_free_count 	0
mem_free_amount 	0
mem_estrndup_count 	0
mem_strndup_count 	0
mem_estndup_count 	0
mem_strdup_count 	0
proto_text_fetched_null 	0
proto_text_fetched_bit 	0
proto_text_fetched_tinyint 	0
proto_text_fetched_short 	0
proto_text_fetched_int24 	0
proto_text_fetched_int 	0
proto_text_fetched_bigint 	0
proto_text_fetched_decimal 	0
proto_text_fetched_float 	0
proto_text_fetched_double 	0
proto_text_fetched_date 	0
proto_text_fetched_year 	0
proto_text_fetched_time 	0
proto_text_fetched_datetime 	0
proto_text_fetched_timestamp 	0
proto_text_fetched_string 	0
proto_text_fetched_blob 	0
proto_text_fetched_enum 	0
proto_text_fetched_set 	0
proto_text_fetched_geometry 	0
proto_text_fetched_other 	0
proto_binary_fetched_null 	0
proto_binary_fetched_bit 	0
proto_binary_fetched_tinyint 	0
proto_binary_fetched_short 	0
proto_binary_fetched_int24 	0
proto_binary_fetched_int 	0
proto_binary_fetched_bigint 	0
proto_binary_fetched_decimal 	0
proto_binary_fetched_float 	0
proto_binary_fetched_double 	0
proto_binary_fetched_date 	0
proto_binary_fetched_year 	0
proto_binary_fetched_time 	0
proto_binary_fetched_datetime 	0
proto_binary_fetched_timestamp 	0
proto_binary_fetched_string 	0
proto_binary_fetched_blob 	0
proto_binary_fetched_enum 	0
proto_binary_fetched_set 	0
proto_binary_fetched_geometry 	0
proto_binary_fetched_other 	0
init_command_executed_count 	0
init_command_failed_count 	0
com_quit 	0
com_init_db 	0
com_query 	0
com_field_list 	0
com_create_db 	0
com_drop_db 	0
com_refresh 	0
com_shutdown 	0
com_statistics 	0
com_process_info 	0
com_connect 	0
com_process_kill 	0
com_debug 	0
com_ping 	0
com_time 	0
com_delayed_insert 	0
com_change_user 	0
com_binlog_dump 	0
com_table_dump 	0
com_connect_out 	0
com_register_slave 	0
com_stmt_prepare 	0
com_stmt_execute 	0
com_stmt_send_long_data 	0
com_stmt_close 	0
com_stmt_reset 	0
com_stmt_set_option 	0
com_stmt_fetch 	0
com_deamon 	0
bytes_received_real_data_normal 	0
bytes_received_real_data_ps 	0
 
oci8
OCI8 Support 	enabled
Version 	1.4.7
Revision 	$Revision: 321634 $
Active Persistent Connections 	0
Active Connections 	0
Oracle Run-time Client Library Version 	11.2.0.3.0
Oracle Instant Client Version 	11.2
TEMPORARY Lob support 	enabled
Collections support 	enabled
 
Directive	LOCAL Value	Master Value
oci8.connection_class	no value	no value
oci8.default_prefetch	100	100
oci8.events	Off	Off
oci8.max_persistent	-1	-1
oci8.old_oci_close_semantics	Off	Off
oci8.persistent_timeout	-1	-1
oci8.ping_interval	60	60
oci8.privileged_connect	Off	Off
oci8.statement_cache_size	20	20
 
openssl
OpenSSL support 	enabled
OpenSSL Library Version 	OpenSSL 0.9.8o 01 Jun 2010
OpenSSL Header Version 	OpenSSL 0.9.8o 01 Jun 2010
 
pcre
PCRE (Perl Compatible Regular Expressions) Support 	enabled
PCRE Library Version 	8.12 2011-01-15
 
Directive	LOCAL Value	Master Value
pcre.backtrack_limit	1000000	1000000
pcre.recursion_limit	100000	100000
 
PDO
PDO support	enabled
PDO drivers 	mysql
 
pdo_mysql
PDO Driver FOR MySQL	enabled
Client API version 	mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $
 
Directive	LOCAL Value	Master Value
pdo_mysql.default_socket	/var/run/mysqld/mysqld.sock	/var/run/mysqld/mysqld.sock
 
Phar
Phar: PHP Archive support	enabled
Phar EXT version 	2.0.1
Phar API version 	1.1.1
SVN revision 	$Id: f7d08da4ab9e515975840c28b830edc9437c3026 $
Phar-based phar archives 	enabled
Tar-based phar archives 	enabled
ZIP-based phar archives 	enabled
gzip compression 	enabled
bzip2 compression 	enabled
OpenSSL support 	enabled
 
Phar based ON pear/PHP_Archive, original concept BY Davey Shafik.
Phar fully realized BY Gregory Beaver AND Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
 
Directive	LOCAL Value	Master Value
phar.cache_list	no value	no value
phar.readonly	ON	ON
phar.require_hash	ON	ON
 
posix
Revision 	$Id: c00b7465003bf16b27764ccaea3c159ca2e4419d $
 
redis
Redis Support	enabled
Redis Version 	2.2.1
 
Reflection
Reflection	enabled
Version 	$Id: 23c90449811cd1a9c860b115456b64946c2823a9 $
 
session
Session Support 	enabled
Registered save handlers 	files user redis
Registered serializer handlers 	php php_binary wddx
 
Directive	LOCAL Value	Master Value
session.auto_start	Off	Off
session.bug_compat_42	Off	Off
session.bug_compat_warn	Off	Off
session.cache_expire	180	180
session.cache_limiter	nocache	nocache
session.cookie_domain	no value	no value
session.cookie_httponly	Off	Off
session.cookie_lifetime	0	0
session.cookie_path	/	/
session.cookie_secure	Off	Off
session.entropy_file	no value	no value
session.entropy_length	0	0
session.gc_divisor	1000	1000
session.gc_maxlifetime	1440	1440
session.gc_probability	1	1
session.hash_bits_per_character	5	5
session.hash_function	0	0
session.name	PHPSESSID	PHPSESSID
session.referer_check	no value	no value
session.save_handler	redis	redis
session.save_path	tcp://127.0.0.1:6379?weight=1	tcp://127.0.0.1:6379?weight=1
session.serialize_handler	php	php
session.use_cookies	ON	ON
session.use_only_cookies	ON	ON
session.use_trans_sid	0	0
 
shmop
shmop support 	enabled
 
SimpleXML
Simplexml support	enabled
Revision 	$Id: a379111021e24ef020a2eefd8ca830cb1ab5b280 $
Schema support 	enabled
 
soap
Soap Client 	enabled
Soap Server 	enabled
 
Directive	LOCAL Value	Master Value
soap.wsdl_cache	1	1
soap.wsdl_cache_dir	/tmp	/tmp
soap.wsdl_cache_enabled	1	1
soap.wsdl_cache_limit	5	5
soap.wsdl_cache_ttl	86400	86400
 
sockets
Sockets Support 	enabled
 
SPL
SPL support	enabled
Interfaces 	Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes 	AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException
 
standard
Dynamic Library Support 	enabled
Path TO sendmail 	/usr/sbin/sendmail -t -i
 
Directive	LOCAL Value	Master Value
assert.active	1	1
assert.bail	0	0
assert.callback	no value	no value
assert.quiet_eval	0	0
assert.warning	1	1
auto_detect_line_endings	0	0
default_socket_timeout	60	60
FROM	no value	no value
safe_mode_allowed_env_vars	PHP_	PHP_
safe_mode_protected_env_vars	LD_LIBRARY_PATH	LD_LIBRARY_PATH
url_rewriter.tags	a=href,area=href,frame=src,input=src,form=fakeentry	a=href,area=href,frame=src,input=src,form=fakeentry
user_agent	no value	no value
 
suhosin
Suhosin logo This server IS protected WITH the Suhosin Extension 0.9.33
 
Copyright (c) 2006-2007 Hardened-PHP Project
Copyright (c) 2007-2012 SektionEins GmbH
 
Directive	LOCAL Value	Master Value
suhosin.apc_bug_workaround	Off	Off
suhosin.cookie.checkraddr	0	0
suhosin.cookie.cryptdocroot	ON	ON
suhosin.cookie.cryptkey	[ protected ]	[ protected ]
suhosin.cookie.cryptlist	no value	no value
suhosin.cookie.cryptraddr	0	0
suhosin.cookie.cryptua	ON	ON
suhosin.cookie.disallow_nul	1	1
suhosin.cookie.disallow_ws	1	1
suhosin.cookie.encrypt	Off	Off
suhosin.cookie.max_array_depth	50	50
suhosin.cookie.max_array_index_length	64	64
suhosin.cookie.max_name_length	64	64
suhosin.cookie.max_totalname_length	256	256
suhosin.cookie.max_value_length	10000	10000
suhosin.cookie.max_vars	100	100
suhosin.cookie.plainlist	no value	no value
suhosin.coredump	Off	Off
suhosin.disable.display_errors	Off	Off
suhosin.executor.allow_symlink	Off	Off
suhosin.executor.disable_emodifier	Off	Off
suhosin.executor.disable_eval	Off	Off
suhosin.executor.eval.blacklist	no value	no value
suhosin.executor.eval.whitelist	no value	no value
suhosin.executor.func.blacklist	no value	no value
suhosin.executor.func.whitelist	no value	no value
suhosin.executor.include.allow_writable_files	ON	ON
suhosin.executor.include.blacklist	no value	no value
suhosin.executor.include.max_traversal	0	0
suhosin.executor.include.whitelist	phar	phar
suhosin.executor.max_depth	0	0
suhosin.filter.action	no value	no value
suhosin.get.disallow_nul	1	1
suhosin.get.disallow_ws	0	0
suhosin.get.max_array_depth	50	50
suhosin.get.max_array_index_length	64	64
suhosin.get.max_name_length	64	64
suhosin.get.max_totalname_length	256	256
suhosin.get.max_value_length	512	512
suhosin.get.max_vars	100	100
suhosin.log.file	0	0
suhosin.log.file.name	no value	no value
suhosin.log.phpscript	0	0
suhosin.log.phpscript.is_safe	Off	Off
suhosin.log.phpscript.name	no value	no value
suhosin.log.sapi	0	0
suhosin.log.script	0	0
suhosin.log.script.name	no value	no value
suhosin.log.syslog	no value	no value
suhosin.log.syslog.facility	no value	no value
suhosin.log.syslog.priority	no value	no value
suhosin.log.use-x-forwarded-FOR	Off	Off
suhosin.mail.protect	0	0
suhosin.memory_limit	0	0
suhosin.mt_srand.IGNORE	ON	ON
suhosin.multiheader	Off	Off
suhosin.perdir	0	0
suhosin.post.disallow_nul	1	1
suhosin.post.disallow_ws	0	0
suhosin.post.max_array_depth	50	50
suhosin.post.max_array_index_length	64	64
suhosin.post.max_name_length	64	64
suhosin.post.max_totalname_length	256	256
suhosin.post.max_value_length	1000000	1000000
suhosin.post.max_vars	1000	1000
suhosin.protectkey	ON	ON
suhosin.request.disallow_nul	1	1
suhosin.request.disallow_ws	0	0
suhosin.request.max_array_depth	50	50
suhosin.request.max_array_index_length	64	64
suhosin.request.max_totalname_length	256	256
suhosin.request.max_value_length	1000000	1000000
suhosin.request.max_varname_length	64	64
suhosin.request.max_vars	1000	1000
suhosin.server.encode	ON	ON
suhosin.server.strip	ON	ON
suhosin.session.checkraddr	0	0
suhosin.session.cryptdocroot	ON	ON
suhosin.session.cryptkey	[ protected ]	[ protected ]
suhosin.session.cryptraddr	0	0
suhosin.session.cryptua	Off	Off
suhosin.session.encrypt	ON	ON
suhosin.session.max_id_length	128	128
suhosin.simulation	Off	Off
suhosin.sql.bailout_on_error	Off	Off
suhosin.sql.comment	0	0
suhosin.sql.multiselect	0	0
suhosin.sql.opencomment	0	0
suhosin.sql.union	0	0
suhosin.sql.user_postfix	no value	no value
suhosin.sql.user_prefix	no value	no value
suhosin.srand.IGNORE	ON	ON
suhosin.stealth	ON	ON
suhosin.upload.disallow_binary	0	0
suhosin.upload.disallow_elf	1	1
suhosin.upload.max_uploads	25	25
suhosin.upload.remove_binary	0	0
suhosin.upload.verification_script	no value	no value
 
sysvmsg
sysvmsg support 	enabled
Revision 	$Id: bf99fb053e35d98fb01c414dda6d4813a55e6647 $
 
tokenizer
Tokenizer Support 	enabled
 
wddx
WDDX Support	enabled
WDDX Session Serializer 	enabled
 
XCache
XCache Support	enabled
Version 	2.0.1
Modules Built 	cacher
Readonly Protection 	N/A
Cache Init Time 	2012-08-21 13:35:36
Cache Instance Id 	1541
Opcode Cache 	enabled, 536,870,912 bytes, 4 split(s), WITH 4096 slots each
Variable Cache 	enabled, 134,217,728 bytes, 4 split(s), WITH 4096 slots each
Shared Memory Schemes 	mmap
 
Directive	LOCAL Value	Master Value
xcache.admin.enable_auth	ON	ON
xcache.cacher	ON	ON
xcache.coredump_directory	no value	no value
xcache.count	3	3
xcache.experimental	Off	Off
xcache.gc_interval	900	900
xcache.mmap_path	/tmp/xcache	/tmp/xcache
xcache.readonly_protection	0	0
xcache.shm_scheme	mmap	mmap
xcache.size	512M	512M
xcache.slots	4K	4K
xcache.stat	ON	ON
xcache.test	0	0
xcache.ttl	3600	3600
xcache.var_count	3	3
xcache.var_gc_interval	900	900
xcache.var_maxttl	7200	7200
xcache.var_size	128M	128M
xcache.var_slots	4K	4K
xcache.var_ttl	3600	3600
 
xml
XML Support 	active
XML Namespace Support 	active
libxml2 Version 	2.7.8
 
xmlreader
XMLReader 	enabled
 
xmlwriter
XMLWriter 	enabled
 
zip
Zip 	enabled
Extension Version 	$Id$
Zip version 	1.11.0
Libzip version 	0.10.1
 
zlib
ZLib Support 	enabled
Stream Wrapper support 	compress.zlib://
Stream Filter support 	zlib.inflate, zlib.deflate
Compiled Version 	1.2.1.1
Linked Version 	1.2.3.4
 
Directive	LOCAL Value	Master Value
zlib.output_compression	Off	Off
zlib.output_compression_level	-1	-1
zlib.output_handler	no value	no value
 
Additional Modules
Module Name
sysvsem
sysvshm
 
Environment
Variable	Value
USER 	www-DATA
HOME 	/var/www
 
PHP VARIABLES
Variable	Value
_SERVER["USER"]	www-DATA
_SERVER["HOME"]	/var/www
_SERVER["FCGI_ROLE"]	RESPONDER
_SERVER["QUERY_STRING"]	no value
_SERVER["REQUEST_METHOD"]	GET
_SERVER["CONTENT_TYPE"]	no value
_SERVER["CONTENT_LENGTH"]	no value
_SERVER["SCRIPT_FILENAME"]	/usr/share/nginx/www/INDEX.php
_SERVER["SCRIPT_NAME"]	/INDEX.php
_SERVER["REQUEST_URI"]	/
_SERVER["DOCUMENT_URI"]	/INDEX.php
_SERVER["DOCUMENT_ROOT"]	/usr/share/nginx/www
_SERVER["SERVER_PROTOCOL"]	HTTP/1.1
_SERVER["GATEWAY_INTERFACE"]	CGI/1.1
_SERVER["SERVER_SOFTWARE"]	nginx/1.2.3
_SERVER["REMOTE_ADDR"]	213.174.126.27
_SERVER["REMOTE_PORT"]	17798
_SERVER["SERVER_ADDR"]	188.165.50.64
_SERVER["SERVER_PORT"]	80
_SERVER["SERVER_NAME"]	*******
_SERVER["HTTPS"]	no value
_SERVER["REDIRECT_STATUS"]	200
_SERVER["HTTP_HOST"]	******
_SERVER["HTTP_USER_AGENT"]	Mozilla/5.0 (Windows NT 6.1; rv:14.0) Gecko/20100101 Firefox/14.0.1
_SERVER["HTTP_ACCEPT"]	text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
_SERVER["HTTP_ACCEPT_LANGUAGE"]	fr,fr-fr;q=0.8,en-us;q=0.5,en;q=0.3
_SERVER["HTTP_ACCEPT_ENCODING"]	gzip, deflate
_SERVER["HTTP_CONNECTION"]	keep-alive
_SERVER["HTTP_IF_MODIFIED_SINCE"]	Mon, 09 Apr 2012 13:16:10 GMT
_SERVER["HTTP_IF_NONE_MATCH"]	"200000000ae8c-aee-4bd3ecf50fdfa"
_SERVER["PHP_SELF"]	/index.php
_SERVER["REQUEST_TIME"]	1345549713


Le problème que j'ai:


Impossible de se connecter sur une base de données oracle 11G R2 qui est hébergée sur un Windows 2008 R2 Server, l'erreur renvoyée est :

oci_connect(): ORA-12154: TNS:could not resolve the connect identifier specified in /usr/share/nginx/www/script.php on line 3



Je précise que cela fait d'ailleurs planter la connexion de l'application (made by me) qui est sur le serveur d'oracle 11G qui travaille sur la base de données.

Je me demande donc si à priori il n'y aurait pas une interaction lorsque qu'on utilise le même id / password de l'utilisateur oracle utilisé par l'application ?

En local le navicat se connecte très bien en tant que system, mais sur mon poste à distance c'est niet, même via ssh en tunneling.



Enfin, dernier point pour la connexion à Oracle, j'ai bizarrement lu de part et d'autre que le TNSNAMES.ora devait être configuré, donc je me demande si je devrais pas mettre l'ip publique du serveur dans le TNSNAMES.ora de la database à laquelle j'essaie de me connecter depuis l'extérieur et en local ?

Je devrais copier le même fichier dans l'instant client du serveur web (j'ai installé basic et sdk avec les chemins par défaut du rpm) ?


D'après le tuto ici (page 103 - 104) : http://www.oracle.com/technetwork/topics/php/026973.pdf
Il semblerait que je sois obligé de déclarer $TNS_ADMIN comme je l'ai fait sur les variables d'environnement Windows ?




Pas mal de questions sachant que l'architecture est critique actuellement.
Merci pour l'aide qui serait apportée.

Je suis actuellement en train de rédiger un tuto complet pour les prochaines personnes qui souhaitent un tel serveur web.


Merci
Feldunost est déconnecté   Envoyer un message privé Réponse avec citation 10
Vieux 22/08/2012, 23h22   #2
Feldunost
Invité régulier
 
Fabien
Inscription : avril 2010
Messages : 73
Détails du profil
Informations personnelles :
Nom : Fabien

Informations forums :
Inscription : avril 2010
Messages : 73
Points : 8
Points : 8
Je viens de régler le problème du:

oci_connect(): ORA-12154: TNS:could not resolve the connect identifier specified in /usr/share/nginx/www/script.php on line 3


Qui était dû simplement au fait qu'il fallait configurer le fichier hosts à la fois sur le linux et windows pour que les deux machines puissent se ping l'une et l'autre.

J'ai par ailleurs copié TNSNAMES.ora sur debian pour l'instantclient, je n'ai pas les options tnsping ni sqlplus pourtant j'ai installé les rpm de instantclient, mais y'a rien dedans, je pense que c'est inclus directement depuis les clients complets qui font 700 mo.



L'erreur actuelle est :

ORA-12170: TNS:Connect timeout occurred


Nginx me sort:

504 Gateway Time-out
nginx/1.2.3



Je pense que le problème est côté client puisque le code de connexion marche très bien sur le wamp du serveur où est installé la database.

L'objectif que j'ai est de virer Wamp qui est pas super, du tout.



Donc à partir de là, je vous donne les fichiers de config:





Serveur DB:



C:\Windows\System32\drivers\etc\hosts

127.0.0.1 localhost
188.***.**.** arch117





C:\app\Administrateur\product\11.2.0\dbhome_1\NETWORK\ADMIN\TNSNAMES.ora


# tnsnames.ora Network Configuration File: C:\app\Administrateur\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ARCH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = arch117)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = arch)
(INSTANCE_NAME = arch)
(GLOBAL_NAME = arch)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)




C:\app\Administrateur\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (HOSTNAME, TNSNAMES)

ADR_BASE = C:\app\Administrateur\product\11.2.0\dbhome_1\log





C:\app\Administrateur\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = arch)
(SID_NAME = arch)
)
)

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = arch117)(PORT = 1521))
)

ADR_BASE_LISTENER = C:\app\Administrateur\product\11.2.0\dbhome_1\log





C:\Users\Administrateur>tnsping arch117
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 22-AO█T-2012 23:09:21

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Fichiers de paramÞtres utilisÚs :
C:\app\Administrateur\product\11.2.0\client_1\instantclient\sqlnet.ora

Adaptateur HOSTNAME utilisÚ pour la rÚsolution de l'alias
Tentative de contact de (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=188.***.**.**)(PORT=1521)))
OK (0 msec)





C:\Users\Administrateur>C:\app\Administrateur\product\11.2.0\dbhome_1\BIN\LSNRCTL.EXE status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 22-AO█T -2012 23:11:51

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connexion Ó (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=arch117)(PORT=1521)))
STATUT du PROCESSUS D'ECOUTE
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
Date de dÚpart 22-AO█T -2012 14:35:00
DurÚe d'activitÚ 0 jours 8 heures 37 min. 6 sec
Niveau de trace off
SÚcuritÚ ON: Local OS Authentication
SNMP OFF
Fichier de paramÞtres du processus d'Úcoute C:\app\Administrateur\product\11.2.0\dbhome_1\network\admin\listener.ora
Fichier journal du processus d'Úcoute c:\app\administrateur\diag\tnslsnr\arch117\listener\alert\log.xml
RÚcapitulatif d'Úcoute des points d'extrÚmitÚ...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=188.***.**.**)(PORT=1521)))
RÚcapitulatif services...
Le service "CLRExtProc" comporte 1 instance(s).
L'instance "CLRExtProc", statut UNKNOWN, comporte 1 gestionnaire(s) pour ce service...
Le service "arch" comporte 1 instance(s).
L'instance "arch", statut READY, comporte 1 gestionnaire(s) pour ce service...
Le service "archXDB" comporte 1 instance(s).
L'instance "arch", statut READY, comporte 1 gestionnaire(s) pour ce service...
La commande a rÚussi







Chez le client la variable TNSADMIN.ora a été déclarée dans /etc/environment:
TNS_ADMIN=/etc/oracle



Et dans /etc/oracle/tnsnames.ora:

ARCH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = arch117)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = arch)
(INSTANCE_NAME = arch)
(GLOBAL_NAME = arch)
)
)




/etc/hosts

127.0.0.1 localhost
188.***.**.** arch116
188.***.**.** arch117




Bref, je cherche toujours ... mais ça a bien avancé déjà !



EDIT: Vous allez rire ... Le pare-feu ...
Tout est désormais fonctionnel ! Uniquement lorsque le Firewall est Off ...

Je viens de voir ici: http://www.dbasupport.com/forums/arc...p/t-19188.html

- Your listener is set up to listen on port 1521
- Firewall is configured to accept calls from your client's IP on port 1521
1) Your clients tries to established connection with the database by sending request to port 1521 of the database server
2) Firewall let the call through (it is configured to do so) and listener intercepts the call
3) Listener transfers the request to the database
4) After database checks you are authorised to connect to the database it sends the responce back directly to your client. But database chooses some new port on which the session will be established, let's say it is port 2020. So your client gets the message from your database, saying: You are welcome to connect to the database, we will communicate on port 2020.
5.) Your client obeys the instructions from the database and sends a message to the database server, but this time on port 2020.
6.) This message gets rejected by the firewall, because it can accept only messages through port 1521, not through 2020.
7.) As a result, the database connection is not established.


Donc que faire dans mon cas, sachant que l'ip des deux machines (serveur et client) sont connues de tous par un simple ping et que je ne souhaite pas autoriser des connexions entrantes / sortantes pour une ip à tous les ports.

Risque de sécu majeur.




EDIT 2:

Bon j'ai ouvert le port 1521 uniquement à l'ip du client, et j'ai appliqué un mot de passe fort, mais si vous avez des suggestions à ce propos, faites en part !

Tout fonctionne actuellement.
Feldunost est déconnecté   Envoyer un message privé Réponse avec citation 10
Vieux 24/12/2012, 16h10   #3
ben_ammar
Invité de passage
 
Inscription : septembre 2008
Messages : 1
Détails du profil
Informations forums :
Inscription : septembre 2008
Messages : 1
Points : 1
Points : 1
Par défaut Connexions aux bases de données

Bonjour,

Je suis actuellement avec cette configuration fonctionnelle :
wamp server 2.0
instant client_11_2.

Tout cela a été installé, et fonctionne à merveille comme le laisse suggérer phpinfo:.
j'ai résolu le problème de connections php oracle sur une base distant.

mais mon problème je ne peut pas connecter sur une autre base de données oracle distant de même même serveur.
voici le fichier tnsname.ora:
str =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = @srv1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = @srv2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dbcomp)
)
)

testdb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = @srv2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dbper)
)
)


pour les deux premiers instance( str ,test)je peut le connecter avec php et sql plus..
mais avec la troisième instance(testdb) je peut connecter avec sqlplus mais avec php je ne peut pas .voici la chaine de connection avec php:
$dba = "(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = @srv2)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME =dbper)))";
//$conn = oci_connect("user","pwd",$dba);
voici le message d'erreur.
ORA-28547: échec de connexion au serveur ; erreur probable de l'administration Oracle Net ,
avec cette connections php:
$conn = oci_connect("user","pwd","@srv2:1521/dbper");
voici le msg d'erreur
ORA-12514: TNS : le processus d'écoute ne conna�t pas actuellement le service demandé

(les deux instance test,tesdb sur le même serveur @srv2).
je suis besoin la solution .
merci de ton aide .
je suis bloqué.
ben_ammar est déconnecté   Envoyer un message privé Réponse avec citation 00
Réponse Cette discussion est résolue.
Outils de la discussion

Navigation rapide


Fuseau horaire GMT +2. Il est actuellement 06h53.


 
 
 
 
Partenaires

Hébergement Web