You are not logged in.
- Topics: Active | Unanswered
#1 2010-06-04 18:59:38
- dinsdale
- Member
- From: Riviere-du-loup
- Registered: 2010-06-04
- Posts: 15
php curl connection & mysql connection from netbeans (jdbc) problem
I set up a LAMP stack on my laptop for development of TYPO3 a cms. Everything is cushty but two issues remain where I'm at my wits end.
In netbeans I cannot connect to the mysql database using the jdbc driver and specifying the localhost. My php application can using the same credentials.
I realized that I cannot connect to the mysql from the command line either if I use the loopback dress.
this works: mysql -u root -p -h localhost
this doesn't: mysql -u root -p -h 127.0.0.1
> ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
In my php application I have the problem that I cannot fetch a file via curl and fopen. I have tried both and curl/allow_fopen are enabled in the php.ini but no luck.
since both problems are permission related it's only the /etc/hosts.allow which comes to mind which could cause a problem but I already allowed everything the hosts.allow
# /etc/hosts.allow
rpcbind: 192.168.1.0/255.255.255.0
mysqld: ALL : allow
ALL: 127.0.0.1 : allow
httpd: ALL : allow
ALL : ALL : allow
#/etc/hosts
127.0.0.1 localhost localhost.localdomain lt-tom-arch
Any idea what I'm missing? What can I use to debug the issue further
#php.ini
[PHP]
engine = On
short_open_tag = Off
asp_tags = Off
precision = 14
y2k_compliance = On
output_buffering = 4096
zlib.output_compression = Off
implicit_flush = Off
unserialize_callback_func =
serialize_precision = 100
allow_call_time_pass_reference = Off
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
error_reporting = E_COMPILE_ERROR|E_RECOVERABLE_ERROR|E_ERROR|E_CORE_ERROR
disable_functions =
disable_classes =
expose_php = On
max_execution_time = 300
max_input_time = 60
memory_limit = 128M
error_reporting = E_ALL & ~E_DEPRECATED
display_errors = Off
display_startup_errors = Off
log_errors = On
log_errors_max_len = 1024
ignore_repeated_errors = Off
ignore_repeated_source = Off
report_memleaks = On
track_errors = Off
html_errors = Off
error_log = /var/log/php.log
variables_order = "GPCS"
request_order = "GP"
register_globals = Off
register_long_arrays = Off
register_argc_argv = Off
auto_globals_jit = On
post_max_size = 8M
magic_quotes_gpc = Off
magic_quotes_runtime = Off
magic_quotes_sybase = Off
auto_prepend_file =
auto_append_file =
default_mimetype = "text/html"
include_path = ".:/usr/share/pear"
doc_root =
user_dir =
extension_dir = "/usr/lib/php/modules/"
enable_dl = Off
file_uploads = On
upload_max_filesize = 12M
max_file_uploads = 20
allow_url_fopen = On
allow_url_include = On
default_socket_timeout = 60
extension=gettext.so
extension=json.so
extension=mcrypt.so
extension=curl.so
extension=gd.so
extension=mysql.so
extension=openssl.so
[Date]
date.timezone = America/Montreal
[filter]
[iconv]
[intl]
[sqlite]
[sqlite3]
[Pcre]
[Pdo]
[Pdo_mysql]
pdo_mysql.cache_size = 2000
pdo_mysql.default_socket=
[Phar]
[Syslog]
define_syslog_variables = Off
[mail function]
SMTP = localhost
smtp_port = 25
mail.add_x_header = On
[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
[Interbase]
ibase.allow_persistent = 1
ibase.max_persistent = -1
ibase.max_links = -1
ibase.timestampformat = "%Y-%m-%d %H:%M:%S"
ibase.dateformat = "%Y-%m-%d"
ibase.timeformat = "%H:%M:%S"
[MySQL]
mysql.allow_local_infile = On
mysql.allow_persistent = On
mysql.cache_size = 2000
mysql.max_persistent = -1
mysql.max_links = -1
mysql.default_port =
mysql.default_socket =
mysql.default_host =
mysql.default_user =
mysql.default_password =
mysql.connect_timeout = 60
mysql.trace_mode = Off
[MySQLi]
mysqli.max_persistent = -1
mysqli.allow_persistent = On
mysqli.max_links = -1
mysqli.cache_size = 2000
mysqli.default_port = 3306
mysqli.default_socket =
mysqli.default_host =
mysqli.default_user =
mysqli.default_pw =
mysqli.reconnect = Off
[mysqlnd]
mysqlnd.collect_statistics = On
mysqlnd.collect_memory_statistics = Off
[Session]
session.save_handler = files
session.use_cookies = 1
session.use_only_cookies = 1
session.name = PHPSESSID
session.auto_start = 0
session.cookie_lifetime = 0
session.cookie_path = /
session.cookie_domain =
session.cookie_httponly =
session.serialize_handler = php
session.gc_probability = 1
session.gc_divisor = 1000
session.gc_maxlifetime = 1440
session.bug_compat_42 = Off
session.bug_compat_warn = Off
session.referer_check =
session.entropy_length = 0
session.entropy_file =
session.cache_limiter = nocache
session.cache_expire = 180
session.use_trans_sid = 0
session.hash_function = 0
session.hash_bits_per_character = 5
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=fakeentry"
[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]
[COM]
[mbstring]
[gd]
[exif]
[Tidy]
tidy.clean_output = Off
[soap]
soap.wsdl_cache_enabled=1
soap.wsdl_cache_dir="/tmp"
soap.wsdl_cache_ttl=86400
soap.wsdl_cache_limit = 5
[sysvshm]
[ldap]
ldap.max_links = -1
[mcrypt]
[dba]#my.cnf
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld]
port = 3306
socket = /var/run/mysqld/mysqld.sock
datadir = /var/lib/mysql
skip-external-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 16K
myisam_sort_buffer_size = 8M
skip-networking
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeoutOffline
#2 2010-06-04 19:34:13
- brisbin33
- Member
- From: boston, ma
- Registered: 2008-07-24
- Posts: 1,799
- Website
Re: php curl connection & mysql connection from netbeans (jdbc) problem
your syntax may be fine but i'll post this just in case:
cat /etc/hosts.allow
#
# /etc/hosts.allow
#
#vsftpd: ALL
sshd: ALL
httpd: ALL
ALL: 192.168.0.
ALL: localhost 127.0.0.1
# End of file//github/
Offline
#3 2010-06-04 23:29:15
- dinsdale
- Member
- From: Riviere-du-loup
- Registered: 2010-06-04
- Posts: 15
Re: php curl connection & mysql connection from netbeans (jdbc) problem
Thank you very much - Indeed this looks much cleaner.
It still doesn't work though - is there something else apart from the hosts.allow which could prevent access? I don't have any iptables (iptables -L is empty)
Offline
#4 2010-06-23 01:18:19
- dinsdale
- Member
- From: Riviere-du-loup
- Registered: 2010-06-04
- Posts: 15
Re: php curl connection & mysql connection from netbeans (jdbc) problem
Regarding Curl/fopen I'm one step further. PHP cannot resolve hostnames and can connect only if an IP is specified. I resolved the domain I needed manually in the hosts file and it works. it appears it cannot use the systems DNS or the system doesn't allow it to use DNS. I have other ubuntu servers in the network who can resolve just fine.
any idea what could be causing this?
Could it have something to do with my nsswitch.conf? Should there be another dns somewhere?
# Begin /etc/nsswitch.conf
passwd: files
group: files
shadow: files
publickey: files
hosts: files dns
networks: files
protocols: files
services: files
ethers: files
rpc: files
netgroup: files
# End /etc/nsswitch.confOffline