[rt-users] Pros Only - Install Problem

[Joel Webb]

Adam,

What file has the mysql.acl in it?? I am looking at the insertdata file but I don't
see what lines you are talking about.


>I rewrote the mysql.acl script such
>that the first two lines of the template script were commneted out or
>deleted from the script. This will allow the third line which grants
>permissions to the rt_user in the database to run. In mysql acl scripts if
>any previous line fails the script exits and does not run subsequent
>lines. You must edit the template script thought becvause if you edit only
>the actual script run,

If you are talking about the initacls.mysql SHELL script. That particular script
looks like it is used many times by the perl instal script to make changes to the
MYSQL database. The "first two lines" in that script are variables so I don't know
which scripts to edit. Can you tell me the script name and the line numbers??
That would be great if you could do that.


>Adam
>
>On Tue, 8 Jan 2002, Joel Webb wrote:
>
>> I am using mysql for my database backend.
>>
>> Installs aren't normally this complicated for people who have been using mysql.
>> Normally the installs are like this
>>
>> >mysql -u root rt2 -p < rt2databasesetup
>>
>> Then in the rt2databasesetup is all the commands that would be
>> used to setup the database initially. I like the perl script, that helps, but
>> maintainance wise is a bear.
>>
>> Let me know what you guys think. I have already installed the script half-way and
>> then started checking the permissions inside mysql outside of the script.Sort of
>> pausing where I am and checking to see if the script works on the backend. But I
>> couldn't see the new user or anything. Any help is appreciated.
>>
>> >> cp etc/acl.mysql '//opt/rt2/etc/acl.mysql'
>> >-Jam
>> >> /usr/bin/perl -p -i -e " s'!!DB_TYPE!!'"mysql"'g;\
>> >>                         s'!!DB_HOST!!'"localhost"'g;\
>> >>                         s'!!DB_RT_PASS!!'"myrt4m3       "'g;\
>> >>                         s'!!DB_RT_HOST!!'"localhost"'g;\
>> >>                         s'!!DB_RT_USER!!'"rt_user"'g;\
>> >>                         s'!!DB_DATABASE!!'"rt2"'g;" //opt/rt2/etc/acl.mysql
>> >> Substitution replacement not terminated at -e line 1.
>> >> make: *** [acls] Error 255
>> --
>> Respectfully,
>>
>> Joel Webb
>> WebbGroup Network Systems LLC
>> www.webbgroup.net
>> 336.841.7241
>>
>>
>
>--
>
>Sincerely,
>-James Adam Sigler-
>
>
>
>James Adam Sigler
>Research Scientist
>College of Computing
>Georgia Tech
>Phone: 404-385-0391
>Office: CoC 211
>Email: hollow1 at cc.gatech.edu
>
>
--
Respectfully,

Joel Webb
WebbGroup Network Systems LLC
www.webbgroup.net
336.841.7241