Different Database for IRStats - IRStats Discuss

Message from discussion Different Database for IRStats

Guy

More options 10 Nov 2008, 05:18

From: Guy <guy.knig...@gmail.com>

Date: Sun, 9 Nov 2008 21:18:25 -0800 (PST)

Local: Mon 10 Nov 2008 05:18

Subject: Re: Different Database for IRStats

  Reply to author
  |
  Forward | Print | View thread
  | Show original
  | Report this message | Find messages by this author
  

I'm trying to do this as well, I currently have the config file set so
that the 'extract' database is our EPrints 3 DB (called 'quteprints'),
while the database configuration is for a separate IRStats DB I've set
up (called 'irstats'). However, when I try to run an update_table, I
get the following error:

DBD::mysql::st execute failed: Table 'irstats.access' doesn't exist
at /usr/local/irstats/var/www/irstats/lib/IRStats/DatabaseInterface.pm
line 625.

Anyone know how to resolve this?

Thanks,
Guy

Guy Knights
Computer Systems Officer
Library Systems, QUT
Phone: (07) 3138 3910
Email: g.knig...@qut.edu.au

On Nov 4, 11:25 pm, "Dennis - UT" <dv.epri...@gmail.com> wrote:

> These settings can be found in irstats.conf (or the conf file specific to
> your repository in case of multiple config files):

> *#database configuration
> database_driver = mysql
> database_server = localhost
> database_name = so
> *
> The instructions I posted on the eprints list before assume that you use the
> same database as eprints, this should be fine in most cases I guess and
> doesn't require setting up additional databases.

> Dennis

> On Tue, Oct 14, 2008 at 7:58 AM, Francis <fjayaka...@gmail.com> wrote:

> > Hi, I have been trying to implement IRStats for our GNU EPrints.org
> > based IR. I would say that I have been partially successful because of
> > useful tips provided by Dennis.

> > During the course of installing the IRStats, there are instruction to
> > create a different database for IRStats. However, after the
> > implementation of IRStats, i see that it has created a table in the
> > database being used for EPrints.org software. I'm unable to figure
> > out how to instruct IRStats to use a different database? Can somebody
> > please let me know if this is possible at all?

> > Many thanks,

> > - Francis

Reply to author Forward