[rt-users] Pros Only - Install Problem
Joel Webb
joel at webbgroup.net
Thu Jan 10 12:22:22 EST 2002
I am positive I am not fat fingering the password. The password also has been
numerous times. I have used the default password. I have used new passwords. I have
double checked to see if the passwords don't have blank spaces behind them.
Has anybody made a MySQL setup script instead of using the PERL??
Lex Uijthof (lex at bigboned.euronet.nl) wrote*:
>
>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
>
>
--
Respectfully,
Joel Webb
WebbGroup Network Systems LLC
www.webbgroup.net
336.841.7241
More information about the rt-users
mailing list