[rt-users] Pros Only - Install Problem

[Lex Uijthof]

Hi,

I'm pretty new with RT2 and the install of it, but i had the same error
in the beginning. My mistake was that the password i used during the
installation for the rt_user was not the same as the password which
was written in the Makefile in the rt directory.

/tmp/rt/Makefile

.
.
# Set this to the password used by the rt database user
# *** Change This Before Installation***

DB_RT_PASS              =       [your passwd]

.
.
.

When i modified my Makefile and then treid it again , my problem was
solved.

Hopefully will i solve your problem to.



On Thu, 10 Jan 2002, Joel Webb wrote:

>The first line of acl.mysql is a blank line.
>
>I deleted that and the next line---> same error
>then I deleted the next line which I think you were referring to ---->same error
>
>For real, I think the setup would be a lot simpler if a mysql script was inacted.
>Do any of you guys know where it is actually being setup in the installation
>script?? Maybe I can install it that way??
>
>Here is the output of the error:
>
>Now populating database schema.
>Enter the mysql password for rt_user:
>Creating database schema.
>DBI->connect(dbname=rt2;host=localhost) failed: Access denied for user: 'rt_user
>@localhost' (Using password: YES) at tools/initdb line 144
>Access denied for user: 'rt_user at localhost' (Using password: YES) at tools/initd
>b line 144, <STDIN> line 1.
>make: *** [initdb.rtuser] Error 255
>
>
>
>James Adam Sigler (hollow1 at cc.gatech.edu) wrote*:
>>
>>Joel,
>>
>>Before compiling remove the first two lines of the acl.mysql
>>script in rt_directory(unzipped from distribution and Makefile
>>edited)/etc. Try that and let me know if it works.
>>
>>
>>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
>>
>>
>>On Wed, 9 Jan 2002, Joel Webb wrote:
>>
>>> 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
>>>
>>>
>>>
>>> _______________________________________________
>>> rt-users mailing list
>>> rt-users at lists.fsck.com
>>> http://lists.fsck.com/mailman/listinfo/rt-users
>>>
>>
>--
>Respectfully,
>
>Joel Webb
>WebbGroup Network Systems LLC
>www.webbgroup.net
>336.841.7241
>
>
>
>_______________________________________________
>rt-users mailing list
>rt-users at lists.fsck.com
>http://lists.fsck.com/mailman/listinfo/rt-users
>
Greetz,

Lex Uijthof

EuroNet Internet B.V. http://www.euronet.nl
Lex Uijthof, OSS department
Muiderstraat 1, Postbus 11095, 1001 GB Amsterdam