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

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 © 1996-2003 Jesse Vincent
jesse@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

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.

[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Paul CrossmanSent: Wednesday, March 30, 2005 11:14 AM
To: rt-users@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.

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 © 1996-2003 Jesse Vincent
jesse@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