Guten Tag
Ich verwende Netobjects Fusion 11 und möchte mit der Website, die im Ordner „Web“ auf dem QNAP installiert wurde auf meinen MySQL Datenbank „Abex“ zugreifen. Der User „rrup“, der alle Rechte freigeschaltet wurde und alle Host mit „%“ im phpMyAdmin Zugriff erhält.
Was muss ich im folgenden Bild für Einstellungen dem Programm Netobject Fusion 11 einstellen, damit dieser Zugriff auf MySQL erhält?
Zusätzlich habe ich im Windows 7 32bit unter „Verwaltung“ -> „Datenquellen (ODBC)“ unter „Benutzer DSN“ und nicht im „System DSN“ den Zugriff auf die MySQL Abex-Datenbank eingerichtet. Dies funktioniert einwandfrei.
Jedoch, wenn ich die Website dann auf die Festplatte des QNAP im Ordner „Web“ publiziere kommt beim Aufruf der Website unter http://10.1.4.100/Web die Fehlermeldung Unable to Connect.
In den Einstellungen (der Javascript-Datei) entnehmen Sie folgende Werte:
<?php exit(); ?><?xml version="1.0"?>
<dbLinks><link id="715B76A6-878E-45BA-8C96-28E27DFFB6FB"><type>MySQL</type><DSNname>Abex</DSNname><user>rrup</user><password></password><PKList><PK table="Adressen" type=""></PK><PK table="GV_Termine" type=""></PK></PKList></link></dbLinks>
Was muss ich tun damit die Website korrekt auf die MySQL zugreifen kann?
Die PHP.Ini von QNAP zeigt folgende Werte:
[PHP]
engine = On
short_open_tag = On
asp_tags = Off
precision = 12
y2k_compliance = On
output_buffering = Off
zlib.output_compression = Off
implicit_flush = Off
unserialize_callback_func=
serialize_precision = 100
allow_call_time_pass_reference = On
safe_mode = Off
safe_mode_gid = Off
safe_mode_include_dir =
safe_mode_exec_dir =
safe_mode_allowed_env_vars = PHP_
safe_mode_protected_env_vars = LD_LIBRARY_PATH
disable_functions =
disable_classes =
expose_php = On
max_execution_time = 240 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
memory_limit = 256M
error_reporting = E_ALL & ~E_NOTICE
display_errors = Off
display_startup_errors = Off
log_errors = Off
log_errors_max_len = 1024
ignore_repeated_errors = Off
ignore_repeated_source = Off
report_memleaks = On
track_errors = Off
variables_order = "EGPCS"
register_globals = Off
register_argc_argv = On
post_max_size = 2047M
gpc_order = "GPC"
magic_quotes_gpc = On
magic_quotes_runtime = Off
magic_quotes_sybase = Off
auto_prepend_file =
auto_append_file =
default_mimetype = "text/html"
doc_root =
user_dir =
include_path = ".:/etc/config/php"
extension_dir = /usr/local/apache/modules
enable_dl = On
file_uploads = On
upload_max_filesize = 2047M
allow_url_fopen = On
default_socket_timeout = 300
upload_tmp_dir = /share/Web
extension = ffmpeg.so
[Syslog]
define_syslog_variables = Off
[mail function]
SMTP = localhost
smtp_port = 25
sendmail_path = /usr/sbin/sendmail -t -i
[Java]
[Date]
date.timezone = "Asia/Taipei"
[SQL]
sql.safe_mode = Off
[ODBC]
odbc.allow_persistent = On
odbc.check_persistent = On
odbc.max_persistent = -1
odbc.max_links = -1
odbc.defaultlrl = 4096
odbc.defaultbinmode = 1
[MySQL]
mysql.allow_persistent = On
mysql.max_persistent = -1
mysql.max_links = -1
mysql.default_port =
mysql.default_socket = "/tmp/mysql.sock"
mysql.default_host =
mysql.default_user =
mysql.default_password =
mysql.connect_timeout = 60
mysql.trace_mode = Off
[mSQL]
msql.allow_persistent = On
msql.max_persistent = -1
msql.max_links = -1
[PostgresSQL]
pgsql.allow_persistent = On
pgsql.auto_reset_persistent = Off
pgsql.max_persistent = -1
pgsql.max_links = -1
pgsql.ignore_notice = 0
pgsql.log_notice = 0
[Sybase]
sybase.allow_persistent = On
sybase.max_persistent = -1
sybase.max_links = -1
sybase.min_error_severity = 10
sybase.min_message_severity = 10
sybase.compatability_mode = Off
[Sybase-CT]
sybct.allow_persistent = On
sybct.max_persistent = -1
sybct.max_links = -1
sybct.min_server_severity = 10
sybct.min_client_severity = 10
[dbx]
dbx.colnames_case = "unchanged"
[bcmath]
bcmath.scale = 0
[browscap]
[Informix]
ifx.default_host =
ifx.default_user =
ifx.default_password =
ifx.allow_persistent = On
ifx.max_persistent = -1
ifx.max_links = -1
ifx.textasvarchar = 0
ifx.byteasvarchar = 0
ifx.charasvarchar = 0
ifx.blobinfile = 0
ifx.nullformat = 0
[Session]
session.save_handler = files
session.use_cookies = 1
session.name = PHPSESSID
session.auto_start = 0
session.cookie_lifetime = 0
session.cookie_path = /
session.cookie_domain =
session.serialize_handler = php
session.gc_probability = 1
session.gc_divisor = 100
session.gc_maxlifetime = 1440
session.bug_compat_42 = 1
session.bug_compat_warn = 1
session.referer_check =
session.entropy_length = 0
session.entropy_file =
session.cache_limiter = nocache
session.cache_expire = 180
session.use_trans_sid = 0
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=,fieldset="
session.save_path = /share/MD0_DATA/.php_session
[MSSQL]
mssql.allow_persistent = On
mssql.max_persistent = -1
mssql.max_links = -1
mssql.min_error_severity = 10
mssql.min_message_severity = 10
mssql.compatability_mode = Off
mssql.secure_connection = Off
[Assertion]
[Ingres II]
ingres.allow_persistent = On
ingres.max_persistent = -1
ingres.max_links = -1
ingres.default_database =
ingres.default_user =
ingres.default_password =
[Verisign Payflow Pro]
pfpro.defaulthost = "test-payflow.verisign.com"
pfpro.defaultport = 443
pfpro.defaulttimeout = 30
[com]
[Printer]
[mbstring]
[FrontBase]
[exif]
[eaccelerator]
eaccelerator.shm_size = 32
eaccelerator.cache_dir = /.eaccelerator.tmp
eaccelerator.enable = 1
eaccelerator.optimizer = 1
eaccelerator.check_mtime = 1
eaccelerator.debug = 0
eaccelerator.filter =
eaccelerator.shm_max = 1M
eaccelerator.shm_ttl = 0
eaccelerator.shm_prune_period = 3600
eaccelerator.shm_only = 0
eaccelerator.compress = 1
eaccelerator.compress_level = 9
[Crack]
; End:
[Zend]
zend_extension_manager.optimizer = /usr/local/apache/modules/Zend/lib/Optimizer-3.3.0
zend_extension_manager.optimizer_ts = /usr/local/apache/modules/Zend/lib/Optimizer_TS-3.3.0
zend_optimizer.version = 3.3.0a
zend_extension = /usr/local/apache/modules/Zend/lib/ZendExtensionManager.so
zend_extension_ts = /usr/local/apache/modules/Zend/lib/ZendExtensionManager_TS.so
[Imagick]
extension = imagick.so
Alles anzeigen