From owner-freebsd-questions@FreeBSD.ORG Mon Jun 20 11:23:04 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id BE55316A41C for ; Mon, 20 Jun 2005 11:23:04 +0000 (GMT) (envelope-from odumat@netkom-sachsen.de) Received: from mail01.netkom-sachsen.de (mail01.netkom-sachsen.de [145.253.229.131]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6DAB243D55 for ; Mon, 20 Jun 2005 11:23:04 +0000 (GMT) (envelope-from odumat@netkom-sachsen.de) Received: from [192.168.2.50] (helo=localhost) by mail01.netkom-sachsen.de with esmtpsa (TLS encrypted) for freebsd-questions@freebsd.org; Mon, 20 Jun 2005 13:23:02 +0200 Received: from oli by localhost with local (Exim 4.51) id 1DkKN8-0004Zr-Aj for freebsd-questions@freebsd.org; Mon, 20 Jun 2005 13:23:22 +0200 Date: Mon, 20 Jun 2005 13:23:22 +0200 From: Oliver Dumat To: freebsd-questions@freebsd.org Message-ID: <20050620112322.GA17521@exim> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit Sender: Received-SPF: mail01.netkom-sachsen.de: 192.168.2.50 is neither permitted nor denied by domain of odumat@netkom-sachsen.de X-NetKom-Signature: 3ea3e9a28599f3c3605e663884cc620a Organization: NetKom GmbH X-NetKom-GmbH-Security: scanned for dangerous contents and viruses X-NetKom-GmbH-Security: some headers removed for security reasons X-Sender-Id: odumat Subject: strange behavior when libnss-mysql is querying a server with tcp X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 20 Jun 2005 11:23:04 -0000 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