2010-12-20 08:00:29 PST
Bug? and Suggestion
When xbt_tracker is started, an error message is displayed: unknown config name: table_deny_from_clients
Is this a place holder for a future version of xbt_tracker?
The following information assumes that, for security reasons, one wants to use a different username than that configured for Joomla, when setting up xbt_tracker joomla component.
The following are one line sql statements that, when values identified in brackets [ ] are replaced with valid values, will grant the needed privileges.
grant update (torrent_pass_version,uploaded,downloaded), select(id,torrent_pass_version,uploaded,downloaded) on [joomla DB name].jos_users to [xbt database username]@localhost;
grant all on [joomla DB name].jos_tracker_files to [xbt database username]@localhost;
grant all on [joomla DB name].jos_tracker_files_users to [xbt database username]@localhost;
grant all on [joomla DB name].xbt_config to [xbt database username]@localhost;
grant all on [joomla DB name].jos_tracker_announce_log to [xbt database username]@localhost;
grant all on [joomla DB name].jos_tracker_deny_from_hosts to [xbt database username]@localhost;
Where [joomla DB name] is replaced with the name of the joomla DB.
Where [xbt database username] is replaced with the username configured in xbt's configuration file.
Where localhost is replaced with a valid hostname for a user/hostname combination in mysql's user list.