[rt-users] Problem initializing database
[EMAIL PROTECTED] ~]# /usr/sbin/rt-setup-database --action init --dba root --prompt-for-dba-password In order to create or update your RT database,this script needs to connect to your mysql instance on 10.12.14.149 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. readline() on closed filehandle SCHEMA_LOCAL at /usr/sbin/rt-setup-database line 192. Done setting up database schema. Now inserting database ACLs DBD::mysql::st execute failed: Access denied for user 'root'@'10.12.14.164' to database 'rt3' at /usr/sbin/rt-setup-database line 345. Problem with statement: GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON rt3.* TO rt_user@'10.12.14.164' IDENTIFIED BY '***'; Access denied for user 'root'@'10.12.14.164' to database 'rt3' at /usr/sbin/rt-setup-database line 346. On the MySQL server, I did: grant all on *.* to 'root'@'10.12.14.164' identified by '' but am still getting that error. I'm aware that this is almost certainly a MySQL error, but I don't think I'll get much help from any MySQL forums since I can't tell them exactly what /usr/sbin/rt-setup-database is doing. -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Problem initializing database
On Tue, Aug 07, 2007 at 01:11:24PM -0500, Scott Hebert wrote: On 8/7/07, John Oliver [EMAIL PROTECTED] wrote: grant all on *.* to 'root'@'10.12.14.164' identified by '' This is *almost* proper syntax. Try this instead... GRANT ALL ON *.* TO 'root'@'10.12.14.164' IDENTIFIED BY 'password' WITH GRANT OPTION THAT DID IT Thank you! :-) -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Default password
On Thu, Aug 02, 2007 at 02:39:18AM +0400, Ruslan Zakirov wrote: Here is the DatabaseRTHost option in the config that comes into play. Set it to '10.12.14.164' before running `make initdb`. As well you can use --with-db-rt-host option of the configure script to set it, note that you MUST run `make install` again before `make initdb` in this case. Ahh! Now I'm getting closer. [EMAIL PROTECTED] ~]# /usr/sbin/rt-setup-database --action init --dba root --prompt-for-dba-password In order to create or update your RT database,this script needs to connect to your mysql instance on 10.12.14.149 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. readline() on closed filehandle SCHEMA_LOCAL at /usr/sbin/rt-setup-database line 192. Done setting up database schema. Now inserting database ACLs DBD::mysql::st execute failed: Access denied for user 'root'@'10.12.14.164' to database 'rt3' at /usr/sbin/rt-setup-database line 345. Problem with statement: GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON rt3.* TO rt_user@'10.12.14.164' IDENTIFIED BY '***'; Access denied for user 'root'@'10.12.14.164' to database 'rt3' at /usr/sbin/rt-setup-database line 346. On the MySQL server, I did: grant all on *.* to 'root'@'10.12.14.164' identified by '' but am still getting that error. Thanks! -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Default password
On Thu, Aug 02, 2007 at 01:44:41PM -0500, James Moseley wrote: Well, sounds like you have a mysql problem now. While logged into your RT host, and assuming you have a mysql client installed, can you successfully connect the mysqld instance on 10.12.14.164? What happens when you do: mysql -u root -p -h 10.12.14.164 What about: mysql -u root -p -h 10.12.14.164 rt3 In the examples above, you will be prompted for the password. There is no MySQL running on .164 MySQL is on .149 I'm absolutely sure that this is a MySQL issue... it appears that root on .164 doesn't have the correct privileges on .149 I tried to at least temporarily give [EMAIL PROTECTED] full access on .149 but it didn't work as expected. My first guess is that rt-setup-database is trying to be too selective in the permissions it's granting... we can see that it's trying to give GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE to rt_user, so maybe when it creates the rt3 database it is using something other than ALL for 'root'? Access denied for user 'root'@'10.12.14.164' to database 'rt3' at /usr/sbin/rt-setup-database line 346. Since 'root'@'10.12.14.164' created rt3, that's the only reason I can think of that it's failing... the creator doesn't have enough privileges, or is assuming that the database is on localhost, if that makes a difference. On Thu, Aug 02, 2007 at 02:39:18AM +0400, Ruslan Zakirov wrote: Here is the DatabaseRTHost option in the config that comes into play. Set it to '10.12.14.164' before running `make initdb`. As well you can use --with-db-rt-host option of the configure script to set it, note that you MUST run `make install` again before `make initdb` in this case. Ahh! Now I'm getting closer. [EMAIL PROTECTED] ~]# /usr/sbin/rt-setup-database --action init --dba root --prompt-for-dba-password In order to create or update your RT database,this script needs to connect to your mysql instance on 10.12.14.149 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. readline() on closed filehandle SCHEMA_LOCAL at /usr/sbin/rt-setup-database line 192. Done setting up database schema. Now inserting database ACLs DBD::mysql::st execute failed: Access denied for user 'root'@'10.12.14.164' to database 'rt3' at /usr/sbin/rt-setup-database line 345. Problem with statement: GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON rt3.* TO rt_user@'10.12.14.164' IDENTIFIED BY '***'; Access denied for user 'root'@'10.12.14.164' to database 'rt3' at /usr/sbin/rt-setup-database line 346. On the MySQL server, I did: grant all on *.* to 'root'@'10.12.14.164' identified by '' but am still getting that error. Thanks! -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Default password
On Tue, Jul 31, 2007 at 02:53:50PM -0700, Chaim Rieger wrote: John Oliver wrote: I shouldn't have to manually add a 'root' user. Right? after use rt3 do show tables then select * from Users is root in there ? No. But the tables are there... [EMAIL PROTECTED] ~]# mysql -h ntdbs01 -u rt_user -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 Server version: 5.0.22 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use rt3; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql show tables; +-+ | Tables_in_rt3 | +-+ | ACL | | Attachments | | Attributes | | CachedGroupMembers | | CustomFieldValues | | CustomFields| | GroupMembers| | Groups | | Links | | ObjectCustomFieldValues | | ObjectCustomFields | | Principals | | Queues | | ScripActions| | ScripConditions | | Scrips | | Templates | | Tickets | | Transactions| | Users | | sessions| +-+ 21 rows in set (0.00 sec) Absolutely bizarre. OK, how do I add a root user correctly? -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT not connecting to database?
On Tue, Jul 31, 2007 at 03:25:45PM -0500, James Moseley wrote: Good. I wouldn't waste my time trying to tweak selinux. It sounds like it's behind a firewall on an internal netwrok, so why turn it on at all. There are many other things that will break with selinux turned on... Except, if nobody ever figures out the correct fixes for SELinux, then everyone will keep defaulting to disabling it. And SELinux really is a really, really good idea. If I get it, I'll add it to the wiki. If not... I know I'll live! -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Default password
The default password 'password' isn't working for me (do I have a black thumb of death or what? :-) ). I haven't been able to find anything about resetting it. -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Default password
On Tue, Jul 31, 2007 at 01:33:32PM -0700, John Oliver wrote: The default password 'password' isn't working for me (do I have a black thumb of death or what? :-) ). I haven't been able to find anything about resetting it. I found http://wiki.bestpractical.com/view/RecoverRootPassword However... it doesn't help :-( mysql update Users set Password='X03MO1qnZdYdgyfeuILPmQ' where Name='root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 mysql UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE Name='root'; Query OK, 0 rows affected (0.01 sec) Rows matched: 0 Changed: 0 Warnings: 0 0 rows affected sounds like there is no username root? -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Default password
On Tue, Jul 31, 2007 at 01:49:29PM -0700, Chaim Rieger wrote: John Oliver wrote: I found http://wiki.bestpractical.com/view/RecoverRootPassword However... it doesn't help :-( mysql update Users set Password='X03MO1qnZdYdgyfeuILPmQ' where Name='root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 mysql UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE Name='root'; Query OK, 0 rows affected (0.01 sec) Rows matched: 0 Changed: 0 Warnings: 0 0 rows affected sounds like there is no username root mysql -u (whatever) -p (if needed) then you need to change to the rt db use name_of_rt_db then you can reset the passwd. Yes, I know... :-) [EMAIL PROTECTED] ~]# mysql -h ntdbs01 -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 15 Server version: 5.0.22 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use rt3; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql update Users set Password='X03MO1qnZdYdgyfeuILPmQ' where Name='root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 mysql UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE Name='root'; Query OK, 0 rows affected (0.01 sec) Rows matched: 0 Changed: 0 Warnings: 0 I shouldn't have to manually add a 'root' user. Right? -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT not connecting to database?
On Mon, Jul 23, 2007 at 01:25:23PM -0700, John Oliver wrote:
When I hit my RT install in a browser, I get an Internet Server Error.
The error_log says:
DBI connect('dbname=rt3;host=10.12.14.149','rt_user',...) failed: Can't
connect to MySQL server on '10.12.14.149' (13) at
/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106
Connect Failed Can't connect to MySQL server on '10.12.14.149' (13)
at /usr/lib/perl5/vendor_perl/5.8.8/RT.pm line 205
[Mon Jul 23 13:20:52 2007] [warn] (104)Connection reset by peer:
mod_fcgid: read data from fastcgi server error.
[Mon Jul 23 13:20:52 2007] [error] [client 192.168.2.231] Premature end
of script headers: mason_handler.fcgi
But:
[EMAIL PROTECTED] ~]# mysqladmin -h 10.12.14.149 -u rt_user -p ping
Enter password:
mysqld is alive
The MySQL server is up, running, and available.
I'm still having this problem.
I have done zero customization. I'm working with this out of the box.
I cannot possibly be the only one who cannot get RT working. If I could
get a solution, I'll happliy document it in the wiki.
--
***
* John Oliver http://www.john-oliver.net/ *
* *
***
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: Re: [rt-users] RT not connecting to database?
On Tue, Jul 24, 2007 at 10:20:27AM -0700, John Oliver wrote:
On Tue, Jul 24, 2007 at 08:13:24AM +0200, Ham MI-ID, Torsten Brumm wrote:
Is the server at the same box or on a separated box? How does your setup
looks like?
The database is on a separate host. It can be accessed with mysqladmin
from the host running RT, so there isn't a firewall or anything.
-Original Message-
On Mon, Jul 23, 2007 at 11:13:41PM +0200, Ham MI-ID, Torsten Brumm wrote:
Does this error happen all the time or after a longer time without any
usage?
All the time.
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
To: rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Sent: Mon Jul 23 22:25:23 2007
Subject: [rt-users] RT not connecting to database?
When I hit my RT install in a browser, I get an Internet Server Error.
The error_log says:
DBI connect('dbname=rt3;host=10.12.14.149','rt_user',...) failed: Can't
connect to MySQL server on '10.12.14.149' (13) at
/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106
Connect Failed Can't connect to MySQL server on '10.12.14.149' (13)
at /usr/lib/perl5/vendor_perl/5.8.8/RT.pm line 205
[Mon Jul 23 13:20:52 2007] [warn] (104)Connection reset by peer:
mod_fcgid: read data from fastcgi server error.
[Mon Jul 23 13:20:52 2007] [error] [client 192.168.2.231] Premature end
of script headers: mason_handler.fcgi
I can run mason_handler.fcgi from the command line and get results,
so... some issue with the Apache configuration?
I'm still having this problem.
I configured Apache to use mod_perl instead of fcgid and I get the same
results.
The databaase is accessible, but RT won't access it. I'm stumped.
Could this be an issue with perl-DBI? Or something else?
How can I troubleshoot further? I'm stuck.
--
***
* John Oliver http://www.john-oliver.net/ *
* *
***
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: Re: [rt-users] RT not connecting to database?
On Wed, Jul 25, 2007 at 04:10:08PM -0500, James Moseley wrote: Please list the Set($Database* entries you have in RT_SiteConfig.pm Set($DatabaseHost , '10.12.14.149'); Set($DatabaseRTHost , '10.12.14.149'); #The name of the database user (inside the database) Set($DatabaseUser , 'rt_user'); # Password the DatabaseUser should use to access the database Set($DatabasePassword , '***'); # The name of the RT's database on your database server Set($DatabaseName , 'rt3'); Also, have you run 'make testdeps' to see if you are missing any perl modules? No. RT was installed as an RPM via yum from the FC7 extras repository. FWIW, I installed a CentOS 5 host to try to install from source again... and am once again trapped in a hopeless maze of unresolvable dependencies. Tons of the items that make fixdeps wants to install fail, but there are so many of them rushing by, I couldn't begin to guess what's failing or why. This is why I wanted to get the RPM install working. -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: Re: [rt-users] RT not connecting to database?
On Tue, Jul 24, 2007 at 08:13:24AM +0200, Ham MI-ID, Torsten Brumm wrote:
Is the server at the same box or on a separated box? How does your setup
looks like?
The database is on a separate host. It can be accessed with mysqladmin
from the host running RT, so there isn't a firewall or anything.
-Original Message-
On Mon, Jul 23, 2007 at 11:13:41PM +0200, Ham MI-ID, Torsten Brumm wrote:
Does this error happen all the time or after a longer time without any
usage?
All the time.
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
To: rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Sent: Mon Jul 23 22:25:23 2007
Subject: [rt-users] RT not connecting to database?
When I hit my RT install in a browser, I get an Internet Server Error.
The error_log says:
DBI connect('dbname=rt3;host=10.12.14.149','rt_user',...) failed: Can't
connect to MySQL server on '10.12.14.149' (13) at
/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106
Connect Failed Can't connect to MySQL server on '10.12.14.149' (13)
at /usr/lib/perl5/vendor_perl/5.8.8/RT.pm line 205
[Mon Jul 23 13:20:52 2007] [warn] (104)Connection reset by peer:
mod_fcgid: read data from fastcgi server error.
[Mon Jul 23 13:20:52 2007] [error] [client 192.168.2.231] Premature end
of script headers: mason_handler.fcgi
I can run mason_handler.fcgi from the command line and get results,
so... some issue with the Apache configuration?
--
***
* John Oliver http://www.john-oliver.net/ *
* *
***
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: Re: Re: [rt-users] RT not connecting to database?
On Tue, Jul 24, 2007 at 10:05:29PM +0200, Ham MI-ID, Torsten Brumm wrote: No, firewall was not my idea behind, have you tried from rtwww to rtdb with mysql -uusername -p -h rtdb and this works? Are the rights granded correctly during the installation? [EMAIL PROTECTED] ~]# mysql -u rt_user -p -h 10.12.14.149 Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 53 Server version: 5.0.22 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; ++ | Database | ++ | information_schema | | rt3| | test | ++ 3 rows in set (0.00 sec) mysql quit Bye -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RT not connecting to database?
When I hit my RT install in a browser, I get an Internet Server Error.
The error_log says:
DBI connect('dbname=rt3;host=10.12.14.149','rt_user',...) failed: Can't
connect to MySQL server on '10.12.14.149' (13) at
/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106
Connect Failed Can't connect to MySQL server on '10.12.14.149' (13)
at /usr/lib/perl5/vendor_perl/5.8.8/RT.pm line 205
[Mon Jul 23 13:20:52 2007] [warn] (104)Connection reset by peer:
mod_fcgid: read data from fastcgi server error.
[Mon Jul 23 13:20:52 2007] [error] [client 192.168.2.231] Premature end
of script headers: mason_handler.fcgi
But:
[EMAIL PROTECTED] ~]# mysqladmin -h 10.12.14.149 -u rt_user -p ping
Enter password:
mysqld is alive
The MySQL server is up, running, and available.
--
***
* John Oliver http://www.john-oliver.net/ *
* *
***
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
[rt-users] Wiki horked up?
I tried to log in to the wiki page. No can do. It doesn't remember my password, and it won'tt ake any of my usual passwords, and there's no link for I forgot my password, and I can't recreate an account with a known password, and I can't create an entirely new account. No Contact link, and Googling for help on Kwiki doesn't turn up anything. -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Configuring Apache for RT
On Mon, Jul 16, 2007 at 07:51:20PM -0500, [EMAIL PROTECTED] wrote: First, you probably didn't install mod_perl or any flavor of FastCGI. To install FastCGI in Fedora: yum install mod_fcgid True. I was trying to follow the wiki. Since the FC6 wiki is neaarly completely unusable for FC7, I've started an FC7 InstallGuide and am endeavoring to make it far more useful to folks in my position, who don't know these secrets :-) Next, you can't just include that virtual host config verbatim - it isn't going to work - you have to modify it for your system. That code assumes you are using Apache's FastCGI module, for one... That's exactly what I'm talking about :-) As far as I can see, there should be one right way to make this work under FC7, the way that presupposes all of the ways FC7 will have RT and its' dependencies installed. Instead, create an rt.conf file in /etc/httpd/conf.d. Put the following in it: LoadModule fcgid_module modules/mod_fcgid.so # Use FastCGI to process .fcg .fcgi .fpl scripts # Don't do this if mod_fastcgi is present, as it will try to do the same thing IfModule !mod_fastcgi.c AddHandler fcgid-script fcg fcgi fpl /IfModule # Sane place to put sockets and shared memory file SocketPath run/mod_fcgid SharememPath run/fcgid_shm # Main instance Alias /rt/NoAuth/images/ /opt/rt3/share/html/NoAuth/images/ ScriptAlias /rt /opt/rt3/bin/mason_handler.fcgi/ This assumes the Fedora RT RPM was installed in /opt/rt3 Which it isn't... /usr/share/rt3/html/ is where rt3 lives under FC7 Anyway... the RPM installs /etc/httpd/conf.d/rt3.conf: Alias /rt3 /usr/share/rt3/html PerlRequire /usr/sbin/webmux.pl Directory /usr/share/rt3/html AllowOverride All Options ExecCGI FollowSymLinks RewriteEngine On RedirectMatch permanent (.*)/$ $1/index.html AddDefaultCharset UTF-8 SetHandler perl-script PerlHandler RT::Mason /Directory Out of the box, that doesn't work. httpd will start, but I get the message about the web server not being configured. I pasted in the example you gave above and modified it to the FC7 defaults: LoadModule mod_fcgid.so # Use FastCGI to process .fcg .fcgi .fpl scripts # Don't do this if mod_fastcgi is present, as it will try to do the same thing IfModule !mod_fastcgi.c AddHandler fcgid-script fcg fcgi fpl /IfModule # Sane place to put sockets and shared memory file SocketPath run/mod_fcgid SharememPath run/fcgid_shm # Main instance Alias /rt/NoAuth/images/ /usr/share/rt3/html/NoAuth/images/ #ScriptAlias /rt /opt/rt3/bin/mason_handler.fcgi/ ScriptAlias /rt /usr/sbin/mason_handler.fcgi However, the LoadModule mod_fcgid.so makes httpd fail to start without any error logged to error_log, so I'm dead in the water again :-( -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Has anyone gotten RT working under FC as installed from yum?
A while ago, I wasted a huge amount of time trying to get RT working from source. I got an endless string of unresolved, and unresolvable, dependencies, and I have no wish to revisit that hell. Since RT is available from the Fedora Core Extras, I have to assume that means that it can be made to work with items installed from RPMs via yum. The InstallGuides on the wiki just aren't close to being complete, and I'm trying to get a working install *and* document the process so that the next poor bastard who just wants a working RT install doesn't need to get an advanced degree in atomic rocket surgery to do it :-) If anyone has gotten RT working with fedora Core via the RPMs, I could really, really use some help. -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RPM installation of RT
I installed Fedora Core 6 on a machine, and was very pleasantly surprised when yum install rt3 worked like a charm, after the hours I'd spent trying to get RT installed under RHEL4! :-) I went to http://my-server/rt3/ and the error_log says: [Thu Apr 12 11:37:28 2007] [error] [client 192.168.2.192] install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib/rt3/lib /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.7/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.7 /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 . /etc/httpd) at (eval 210) line 3.\nPerhaps the DBD::mysql perl module hasn't been fully installed,\nor perhaps the capitalisation of 'mysql' isn't right.\nAvailable drivers: DBM, ExampleP, File, Pg, Proxy, Sponge.\n at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106\n I do have mysql.pm [EMAIL PROTECTED] ~]# find / -name mysql.pm /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm /usr/lib/perl5/vendor_perl/5.8.8/DBIx/DBSchema/DBD/mysql.pm How do I add one of those to @INC, and why wasn't this already done? -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RPM installation of RT
On Thu, Apr 12, 2007 at 03:56:28PM -0400, Jesse Vincent wrote: On Thu, Apr 12, 2007 at 12:53:52PM -0700, John Oliver wrote: I installed Fedora Core 6 on a machine, and was very pleasantly surprised when yum install rt3 worked like a charm, after the hours I'd spent trying to get RT installed under RHEL4! :-) I went to http://my-server/rt3/ and the error_log says: [Thu Apr 12 11:37:28 2007] [error] [client 192.168.2.192] install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC Looks like the RPM ddidn't handle the dependencies correctly. I do have mysql.pm [EMAIL PROTECTED] ~]# find / -name mysql.pm /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm /usr/lib/perl5/vendor_perl/5.8.8/DBIx/DBSchema/DBD/mysql.pm Perl paths are fully qalified. You have DBIx::SearchBuilder::Handle::mysql and DBIx::DBSchema::DBD::mysql, but not DBD::mysql. You'll need to install DBD::mysql. Thank you Jesse! I installed that via yum, but still have the same issue. I do have the DBD::mysql, but I guess not where @INC expects it to be: [EMAIL PROTECTED] ~]# find / -name mysql.pm /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/Bundle/DBD/mysql.pm /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm /usr/lib/perl5/vendor_perl/5.8.8/DBIx/DBSchema/DBD/mysql.pm Should I just symlink it, or is there a right way to correct this? -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RPM installation of RT
On Thu, Apr 12, 2007 at 01:18:35PM -0700, John Oliver wrote: On Thu, Apr 12, 2007 at 03:56:28PM -0400, Jesse Vincent wrote: On Thu, Apr 12, 2007 at 12:53:52PM -0700, John Oliver wrote: I installed Fedora Core 6 on a machine, and was very pleasantly surprised when yum install rt3 worked like a charm, after the hours I'd spent trying to get RT installed under RHEL4! :-) I went to http://my-server/rt3/ and the error_log says: [Thu Apr 12 11:37:28 2007] [error] [client 192.168.2.192] install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC Looks like the RPM ddidn't handle the dependencies correctly. I do have mysql.pm [EMAIL PROTECTED] ~]# find / -name mysql.pm /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm /usr/lib/perl5/vendor_perl/5.8.8/DBIx/DBSchema/DBD/mysql.pm Perl paths are fully qalified. You have DBIx::SearchBuilder::Handle::mysql and DBIx::DBSchema::DBD::mysql, but not DBD::mysql. You'll need to install DBD::mysql. Thank you Jesse! I installed that via yum, but still have the same issue. I do have the DBD::mysql, but I guess not where @INC expects it to be: [EMAIL PROTECTED] ~]# find / -name mysql.pm /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/Bundle/DBD/mysql.pm /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm /usr/lib/perl5/vendor_perl/5.8.8/DBIx/DBSchema/DBD/mysql.pm Should I just symlink it, or is there a right way to correct this? I symlinked /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/Bundle/DBD/mysql.pm to /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBD/mysql.pm I now get: [EMAIL PROTECTED] ~]# /usr/sbin/rt-setup-database --action init --dba root --prompt-for-dba-password In order to create or update your RT database,this script needs to connect to your mysql instance on sdtvm05 as root. Please specify that user's database password below. If the user has no database password, just press return. Password: DBD::mysql initialisation failed: Can't locate object method driver via package DBD::mysql at /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBI.pm line 770, STDIN line 1. Perhaps the capitalisation of DBD 'mysql' isn't right. at /usr/sbin/rt-setup-database line 103 -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] RPM installation madness
I am trying to install rt3-3.6.3-1 build from Fedora Core 6 Extras .src.rpm on a RHEL4 Update 4 box. The install fails with a long list of perl dependencies. I found most of them in Fedora Extras... but they all have more dependencies, and the dependencies have dependencies, and the dependencies of the dependencies have yet further dependencies. The further I drill down, the more dependencies I find that I cannot fulfill with RPMs because there are no RPMs, but the rpm installation will not accept perl dependencies satisfied via CPAN. This is like reading 1,001 Arabian Tales How the heck do you get this to install? And, yes, I tried with the tarball as well. More endless problems. I think I have the tarball close to being ready to go, but my head is ready to explode from perl. It took two days to get to whatever point I did before I found the rpm, and I really want to go with the rpm install... if I have to go through this again if/when we need to upgrade, I think suicide will be a far more attractive option. -- *** * John Oliver http://www.john-oliver.net/ * * * *** ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
