Re: ubh 3.x questions

--- feretio <[email protected]> wrote:
> o In the servers table, what does the T and F values for the active 
> field mean?

An 'F' means that ubh will not communicate with that server.  It is
a way to remove a server from processing, without having to delete
it from the server table.

 
> o How can I tie certain newsgroups to specific servers?  In other 
> words, if a newsgroup I'm connecting to is available on both servers 
> but I only want to download the headers from one of the servers (e.g. 
> on giganews, because of the massive retention rate, a newsgroup may 
> have over a million headers but my ISP news server only has a few 
> thousand and I don't want to wait for the headers to download from 
> giganews).

You can't.
 
> o Is there an easy way (other than learning mysql commands) to clear 
> out the downloaded headers?  In the above example, say I downloaded a 
> million headers from a newsgroup from giganews but haven't used it in 
> a while (dated) but don't need/want to download the latest headers.  A 
> million headers can tend to take up a LOT of disk space.  :-)

Method #1 - re-run the installer.

Method #2 - use mysql commands

DELETE FROM assemble;
DELETE FROM headers;
DELETE FROM metainfo;
DELETE FROM xref_headers;

> o When I try running ubhcatalog -g <newsgroup>, I get the following 
> error:
> 
>     DBD::mysql::db do failed: Access denied for user: 
> 'ubhcache@localhost' to database 'ubhcache' at ./ubhcatalog line 141.
>     DBD::mysql::db do failed: Access denied for user: 
> 'ubhcache@localhost' to database 'ubhcache' at ./ubhcatalog line 141.
> 
>   Is there some configuration setting I missed?

I think I had this problem when I moved to MySQL 4.x.

The solution has two steps:

1. When you run the installer, run the 1_install.sql script
   with '-u root'.  I think the Unix installer (install.sh)
   already specifies '-u root'.  If you are on Windows, you
   will have to edit install.bat and add the '-u root' yourself
   so that it looks like this:

C:\MYSQL\BIN\MYSQL -u root < 1_install.sql
C:\MYSQL\BIN\MYSQL < 2_servers.sql
C:\MYSQL\BIN\MYSQL < 3_newsgroups.sql
    
2. Now that you've run the installer, you now have to explicity
   grant the privilege to create temporary tables.  This is a
   new requirement of MySQL 4.0.2 (and later).  So, fire up
   the MySQL client with -u root, and enter the following 
   command:
     GRANT CREATE TEMPORARY TABLES ON ubhcache.* TO root@localhost;



That should fix it for you.

That's the only issue I had with MySQL 4.x.  I've been running fine
for over 6 months now.  But I had to do the above procedure to 
get ubhcatalog to run.


-Gerard




 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
     http://groups.yahoo.com/group/ubh/

<*> To unsubscribe from this group, send an email to:
     [email protected]

<*> Your use of Yahoo! Groups is subject to:
     http://docs.yahoo.com/info/terms/