[rt-users] Almost there... Some progress... maybe...

[Andrew Nicols]

On 8/29/06, Ben Weston <ben at computerhelpme.com> wrote:
>
> I went into Webmin and looked at the SQL DBase (my MySQL skills are very
> limited....), and that database apparently has no tables in it at all.
>
> Did my DBase not initialize properly during install?  I wouldn't be
> surprised, since I've had to adjust settings today to make everything
> sane as far as users/passwords go, and I just didn't notice it at that
> time.
>
> Is there anyway to fix this after the fact, short of a fresh re-install?


If you know where your binaries are and your config directory. You'll
probably find the rt-setup-database in:

/opt/rt3/sbin/rt-setup-database

Off the top of my noggin:
sudo /opt/rt3/sbin/rt-setup-database --action init --datadir /opt/rt3/etc
--dba sql_admin_username --dba-password sql_admin_password

It needs to be run as a user with access to read your config files (i.e.
root/sudo)

Andrew
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060829/cdacba46/attachment.htm>