Mailing List Archive

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
Re: how to supply db credentials to rt-email-dashboards? [ In reply to ]
On Nov 25, 2016, at 2:08 PM, Alex Hall <ahall@autodist.com<mailto: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 <url to rt instance>
user root
passwd <password>

Example:
# cat ~root/.rtrc
server http://localhost/rt
user root
passwd ohsupaihai7moR1

--
Landon Stewart
Lead Analyst - Abuse and Security Management
INTERNAP ®
📧 lstewart@internap.com<mailto:lstewart@internap.com>
🌍 www.internap.com<http://www.internap.com>
Re: how to supply db credentials to rt-email-dashboards? [ In reply to ]
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 ®
📧 lstewart@internap.com<mailto:lstewart@internap.com>
🌍 www.internap.com<http://www.internap.com>

On Nov 28, 2016, at 6:47 AM, Alex Hall <ahall@autodist.com<mailto: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.com<mailto:lstewart@internap.com>> wrote:
On Nov 25, 2016, at 2:08 PM, Alex Hall <ahall@autodist.com<mailto: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 <url to rt instance>
user root
passwd <password>

Example:
# cat ~root/.rtrc
server http://localhost/rt
user root
passwd ohsupaihai7moR1

--
Landon Stewart
Lead Analyst - Abuse and Security Management
INTERNAP ®
📧 lstewart@internap.com<mailto:lstewart@internap.com>
🌍 www.internap.com<http://www.internap.com/>




--
Alex Hall
Automatic Distributors, IT department
ahall@autodist.com<mailto:ahall@autodist.com>