Bad index.html page??? Was (RE: [rt-users] Keep getting mysql is sues when running 'make initialize-database')

[Drew Barnes]

Paul Crossman wrote:

>I've got an updated process on this that sort of makes the issue go away.
>This will not be usable as I move forward in implementation, but perhaps
>someone might have some comments to make on this.
>
>- shutdown httpd
>- shutdown mysqld
>- remove the /var/lib/mysql directory (rm -rf /var/lib/mysql)
>- cp /opt/rt3/etc/RT_SiteConfig.pm /opt
>- remove the rt3 install directory (rm -rf /opt/rt3)
>- startup mysqld (initial database gets created here)
>- cd /usr/src/rt-3.0.12
>- make install
>- make initialize-database
>- cp /opt/RT_SiteConfig.pm /opt/rt3/etc/
>- Validate permissions and ownership of /opt/rt3/etc/RT_SiteConfig.pm
>
>I have success with this...
>
>>From here I can do the following
>
># mysql
>mysql> connect rt3
>mysql> source /root/rt3.sql
>###  Database backup imports just fine here.
>
>- Startup httpd
>
>##  Now I have to change everyone's password in the database since the
>password hashing between windows and Linux does not seem to translate
>properly.
>
># mysql
>mysql> connect rt3
>mysql> update Users set Password='X03MO1qnZdYdgyfeuILPmQ';
>
>Connection to the RT application is possible at this point for me, but
>others get a web page that starts off looking like this...
>
>%# BEGIN LICENSE BLOCK %# %# Copyright (c) 1996-2003 Jesse Vincent
><jesse at bestpractical.com> %# %# (Except where explictly superceded by other
>copyright notices) %# %# This work is made available to you under the terms
>of Version 2 of %# the GNU General Public License. A copy of that license
>should have %# been provided with this software, but in any event can be
>snarfed %# from www.gnu.org. %# %# This work is distributed in the hope that
>it will be useful, but %# WITHOUT ANY WARRANTY; without even the implied
>warranty of %# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
>GNU %# General Public License for more details. %# %# Unless otherwise
>specified, all modifications, corrections or %# extensions to this work
>which alter its source code become the %# property of Best Practical
>Solutions, LLC when submitted for %# inclusion in the work. %# %# %# END
>LICENSE BLOCK
>  
>

This sounds like an httpd.conf problem.  What does the section you set 
up for RT look like?

DB

>The URL in the browser is http://rtserver/index.html.  When I login
>successfully, the URL displayed for me is http://rtserver/rt/index.html.  At
>this point, I'm thinking browser issue or Windows settings issue as I can
>have various others use either IE or Firefox and produce the above result.
>I've searched the Wiki and Google and so far got nothing about this.
>
>The only logged message I can find is:
>
>[Wed Mar 30 12:26:06 2005] [error] [client 172.28.8.14] File does not exist:
>/opt/rt3/share/html/favicon.ico
>
>...but my successful logins yield this as well.
>
>More thoughts????  Anyone.... anyone.... Bueller???
>
>Paul C.
>
>
>________________________________________
>From: rt-users-bounces at lists.bestpractical.com
>[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Paul Crossman
>Sent: Wednesday, March 30, 2005 11:14 AM
>To: rt-users at lists.bestpractical.com
>Subject: [rt-users] Keep getting mysql issues when running 'make
>initialize-database'
>
>I'm working though my exercise of importing data from the Windows RT server
>to the Linux RT server.
>
>I have done this successfully once.
>
>Here's my process thus far.
>
>- shutdown httpd
>- shutdown mysqld
>- remove the /var/lib/mysql directory
>- startup mysqld (database gets created here)
>- cd /usr/src/rt-3.0.12
>- make initialize-database
>
>At this point, I get the following output.
>
># make initialize-database
>/usr/bin/perl //opt/rt3/sbin/rt-setup-database --action init --dba root
>--prompt-for-dba-password
>In order to create a new database and grant RT access to that database,
>Use of uninitialized value in concatenation (.) or string at
>//opt/rt3/sbin/rt-setup-database line
> 237.
>this script needs to connect to your mysql instance on  as root.
>Please specify that user's database password below. If the user has no
>database
>password, just press return.
>
>Password:
>
>Now creating a database for RT.
>Creating mysql database rt3.
>Now populating database schema.
>Creating database schema.
>schema sucessfully inserted
>Now inserting database ACLs
>Now inserting RT core system objects
>[Wed Mar 30 15:37:21 2005] [crit]: Connect Failed Access denied for user
>'rt_user'@'localhost' (us
>ing password: YES)
> at //opt/rt3/sbin/rt-setup-database line 334
> (/opt/rt3/lib/RT.pm:255)
>make: *** [initialize-database] Error 255
>
>I get the same result if I do the following:
>
>- cd /usr/src/rt-3.0.12
>- make dropdb
>- make initialize-database
>
>What gives?  This worked yesterday, now today it's broken?  I have other
>issues that I saw yesterday, but I can't get to them until can get the
>import working again.
>
>Does anyone have a thought on this??  I checked Wiki and got nothing.
>
>Paul C.
>
>_______________________________________________
>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
>RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training at bestpractical.com for details.
>
>Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>  
>