[EMAIL PROTECTED] -u nfacctd -h 127.0.0.1 -P 3306 -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 to server version: 4.1.14
Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use nfacctd; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +-------------------+ | Tables_in_nfacctd | +-------------------+ | nfacctd | +-------------------+ 1 row in set (0.00 sec) mysql> [EMAIL PROTECTED] -P mysql -f /home/kan5300/cfg/nfacctd/nfacctd.cfg INFO ( dummy/mysql ): 107520 bytes are available to address shared memory segment; buffer size is 64 bytes. INFO ( dummy/mysql ): Trying to allocate a shared memory segment of 1720320 bytes. INFO ( default/core ): waiting for data on UDP port '2100' ALERT ( dummy/mysql ): primary MySQL server failed. ( dummy/mysql ) *** Purging cache - START *** ( dummy/mysql ) *** Purging cache - END (QN: 60, ET: 0) *** ( dummy/mysql ) *** Purging MySQL queries queue *** ALERT ( dummy/mysql ): primary MySQL server failed. ( dummy/mysql ) *** Purging cache - START *** ( dummy/mysql ) *** Purging cache - END (QN: 45, ET: 0) *** CFG: debug: true daemonize: false aggregate[dummy]: src_host, dst_host plugins: mysql[dummy] sql_host: 127.0.0.1 sql_db: nfacctd sql_table: acct sql_table_version: 1 sql_passwd: nfacctd sql_user: nfacctd sql_refresh_time: 90 sql_history: 10m sql_history_roundoff: mh What i did wrong =) On 12/4/05, Paolo Lucente <[EMAIL PROTECTED]> wrote: > Hello Ilya, > my first hint is to remove the 'sql_host: localhost' line; it avoids the > connection through the usual '/tmp/mysql.sock' pipe file and makes pmacct > to establish the TCP connection to 'localhost:3306'. If you really need > this, try rewriting it as 'sql_host: 127.0.0.1'. > > Next, check that the 'acct' table really exists and that the 'nfacctd' > user has the right priviledges on it. > > Let me know ! > > Cheers, > Paolo > > _______________________________________________ > pmacct-discussion mailing list > [email protected] > http://muffin.area.ba.cnr.it/mailman/listinfo/pmacct-discussion > -- ============================== === Molokanov kaN5300 Ilya === === ICQ: 190687526 === === www.iifrf.ru === ==============================
