[rt-users] Pros Only - Install Problem
Jesse Vincent
jesse at bestpractical.com
Thu Jan 10 12:52:20 EST 2002
From your installation log:
s'!!DB_RT_PASS!!'"myrt4m3 "'g;\
It _really_ looks to me like you have an embedded tab or set of spaces in there.
Start over with a clean copy of the sources. Really.
On Thu, Jan 10, 2002 at 05:22:22PM +0000, Joel Webb wrote:
> 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
>
>
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>
--
http://www.bestpractical.com/products/rt -- Trouble Ticketing. Free.
More information about the rt-users
mailing list