How to supply db credentials to rt-email-dashboards?

Hi list,
I’m trying to run /opt/rt4/sbin/rt-email-dashboards, but am getting an
error that the database credentials are not correct. They aren’t, but why?
If they get picked up from the configuration, they should be correct, since
RT itself is running just fine. If they aren’t gotten from the
configuration files, where do they come from and how can I supply them? The
tool’s help text didn’t list any DB settings as possible flags. Thanks.

Alex Hall
Automatic Distributors, IT department
ahall@autodist.com

Hi list,
I’m trying to run /opt/rt4/sbin/rt-email-dashboards, but am getting an error that the database credentials are not correct. They aren’t, but why? If they get picked up from the configuration, they should be correct, since RT itself is running just fine. If they aren’t gotten from the configuration files, where do they come from and how can I supply them? The tool’s help text didn’t list any DB settings as possible flags. Thanks.

In the homedir of the user that runs the rt-email-dashboards create a file called ‘.rtrc’.

That file should contain:
server
user root
passwd

Example:

cat ~root/.rtrc

server http://localhost/rt
user root
passwd ohsupaihai7moR1

Landon Stewart
Lead Analyst - Abuse and Security Management
INTERNAP ®
:e-mail: lstewart@internap.commailto:lstewart@internap.com
:earth_africa: www.internap.comhttp://www.internap.com

As far as I know the ~user/.rtrc file is good for both rt-crontool and the rt utility itself. I’ve cc’d the list in case anyone has any more info or corrections.

Landon Stewart
Lead Analyst - Abuse and Security Management
INTERNAP ®
:e-mail: lstewart@internap.commailto:lstewart@internap.com
:earth_africa: www.internap.comhttp://www.internap.comOn Nov 28, 2016, at 6:47 AM, Alex Hall <ahall@autodist.commailto:ahall@autodist.com> wrote:

Thank you, this works perfectly. What else is this ‘rtrc’ file good for, if anything? Or is it only for the scripts in [rtDir]/sbin to use for database connections?

On Fri, Nov 25, 2016 at 7:31 PM, Landon Stewart <lstewart@internap.commailto:lstewart@internap.com> wrote:
On Nov 25, 2016, at 2:08 PM, Alex Hall <ahall@autodist.commailto:ahall@autodist.com> wrote:

Hi list,
I’m trying to run /opt/rt4/sbin/rt-email-dashboards, but am getting an error that the database credentials are not correct. They aren’t, but why? If they get picked up from the configuration, they should be correct, since RT itself is running just fine. If they aren’t gotten from the configuration files, where do they come from and how can I supply them? The tool’s help text didn’t list any DB settings as possible flags. Thanks.

In the homedir of the user that runs the rt-email-dashboards create a file called ‘.rtrc’.

That file should contain:
server
user root
passwd

Example:

cat ~root/.rtrc

server http://localhost/rt
user root
passwd ohsupaihai7moR1

Landon Stewart
Lead Analyst - Abuse and Security Management
INTERNAP ®
:e-mail: lstewart@internap.commailto:lstewart@internap.com
:earth_africa: www.internap.comhttp://www.internap.com/

Alex Hall
Automatic Distributors, IT department
ahall@autodist.commailto:ahall@autodist.com