Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 20 Jun 2005 13:23:22 +0200
From:      Oliver Dumat <odumat@netkom-sachsen.de>
To:        freebsd-questions@freebsd.org
Subject:   strange behavior when libnss-mysql is querying a server with tcp
Message-ID:  <20050620112322.GA17521@exim>

next in thread | raw e-mail | index | archive | help
hi folks
iam using freebsd 5.4 with libnss-mysql 1.4 and mysql-client40.
libnss-mysql querys on localhost through a socket with no problems.
if i want libnss-mysql querys a database host i get errors:
- the connection defintivly works to the other server (veryfied with
  the mysql client)
- the connection will be opened and after that reseted from my server
- no data is exchanged (no authentication against mysqld and all)
- i also verifyed it with the same libnss-mysql-1.4 on my linux system -
  it works perfectly (same configs (some querys are adapted))

i hope you can give me a hint where i have to search to fix this
problem.
write if you want me to provide any more informations.
thanx a lot for your help 
Oliver Dumat


ome of the debug log:

s_mysql_next_key: Found: username -> hosting                                
[1596]: _nss_mysql_next_key: EXIT (TRUE)
[1596]: _nss_mysql_next_key: ENTER
[1596]: _nss_mysql_next_key: Found: password -> password
[1596]: _nss_mysql_next_key: EXIT (TRUE)
[1596]: _nss_mysql_next_key: ENTER
[1596]: _nss_mysql_next_key: Found: port -> 3306
[1596]: _nss_mysql_next_key: EXIT (TRUE)
[1596]: _nss_mysql_next_key: ENTER
[1596]: _nss_mysql_next_key: EXIT (FALSE)
[1596]: _nss_mysql_load_config_file: EXIT
[1596]: _nss_mysql_validate_config: ENTER
[1596]: _nss_mysql_validate_config: EXIT (TRUE)
[1596]: _nss_mysql_load_config: EXIT (NSS_SUCCESS)
[1596]: _nss_mysql_init: EXIT (NSS_SUCCESS)
[1596]: _nss_mysql_load_config: ENTER
[1596]: _nss_mysql_load_config: EXIT (NSS_SUCCESS)
[1596]: _nss_mysql_build_query: ENTER
[1596]: _nss_mysql_build_query: BYNONE creating initial query
[1596]: _nss_mysql_build_query: EXIT (NSS_SUCCESS)
[1596]: _nss_mysql_run_query: ENTER
[1596]: _nss_mysql_run_query: Executing query: SELECT domain,pass,webspace FROM access
[1596]: _nss_mysql_connect_sql: ENTER
[1596]: _nss_mysql_check_existing_connection: ENTER
[1596]: _nss_mysql_check_existing_connection: EXIT (FALSE)
[1596]: _nss_mysql_load_config: ENTER
[1596]: _nss_mysql_load_config: EXIT (NSS_SUCCESS)
[1596]: _nss_mysql_set_options: ENTER
[1596]: _nss_mysql_set_options: EXIT
[1596]: _nss_mysql_connect_sql: Connecting to db.mynetwork.local
[1596]: _nss_mysql_connect_sql: EXIT (NSS_UNAVAIL)
[1596]: _nss_mysql_run_query: EXIT (NSS_UNAVAIL)
[1596]: _nss_mysql_lookup: EXIT (NSS_UNAVAIL)
[1596]: _nss_mysql_getgrent_r: EXIT (NSS_UNAVAIL)
[1596]: _nss_mysql_setgrent: ENTER
[1596]: _nss_mysql_reset_ent: ENTER
[1596]: _nss_mysql_close_result: ENTER
[1596]: _nss_mysql_close_result: EXIT
[1596]: _nss_mysql_reset_ent: EXIT
[1596]: _nss_mysql_setgrent: EXIT (NSS_SUCCESS)


-- 
Oliver Dumat            | NetKom GmbH - Netze & Kommunikationssysteme
PGP-Key: 0x5159507F     | Gewerbepark Mockritz
Tel: 03431/589-0        | 04720 Großweitzschen
Fax: 03431/589-399      | www.netkom-sachsen.de




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050620112322.GA17521>