[rt-users] New install (second chance)
Nelson Pereira
npereira at protus.com
Thu Apr 3 14:43:20 EDT 2008
I'm not sure... I'm having a big cryssis here with my Cisco 6500's so I
have to drop this until Monday probably,
So Monday, I will re-install RHEL4 on it with mysql and PHP from RHEL4
and I'll start from scratch again...
Talk to you later
Nelson Pereira
Senior Network Administrator
Protus IP Solutions Inc.
npereira at protus.com
phone: 613.733.0000 ext.528
MyFax: 613.822.5083
www.myfax.com
Refer your friends and colleagues to MyFax!
Click here for more information.
<http://www.myfax.com/referral_program.asp>
<http://www.myfax.com>
________________________________
From: Torsten Brumm [mailto:torsten.brumm at googlemail.com]
Sent: Thursday, April 03, 2008 2:14 PM
To: Nelson Pereira
Cc: Drew Barnes; rt-users at lists.bestpractical.com
Subject: Re: [rt-users] New install (second chance)
Hi Nelson,
just googled for your error message. are you sure you enabled mysql with
innodb support???
Btw, can you explain more in detail how you have done your setup?
is the mysql from the lamp or from the distro? how does your my.cnf
looks like?
Torsten
2008/4/3, Nelson Pereira <npereira at protus.com>:
Ok, the install seems to have gone well with :
./configure --with-web-user=apache --with-web-group=apache --with-mysql
But now the make initialize-database reports errors...:
[root at netnet-ems rt-3.6.6]# make initialize-database
/usr/bin/perl //opt/rt3/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 localhost 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.
Transactions not supported by database at
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBI.pm line
1668, <SCHEMA> line 463.
make: *** [initialize-database] Error 2
[root at netnet-ems rt-3.6.6]#
I am running MySQL, here is what phpinfo states:
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.42
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
Nelson Pereira
Senior Network Administrator
Protus IP Solutions Inc.
npereira at protus.com
phone: 613.733.0000 ext.528
MyFax: 613.822.5083
www.myfax.com
Refer your friends and colleagues to MyFax!
Click here for more information. www.MyFax.com
-----Original Message-----
From: Drew Barnes [mailto:barnesaw at ucrwcu.rwc.uc.edu]
Sent: Thursday, April 03, 2008 11:55 AM
To: Nelson Pereira
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] New install (second chance)
my configure was:
./configure --prefix=/usr/local/rt3 --with-web-user=apache
--with-web-group=apache --with-db-rt-pass=xxxxxxxxx --with-mysql
That installs in /usr/local/rt3, that apache is the user and group that
runs my webserver, specifies the password that rt_user connects to the
database with, using mysql.
A full list of options is available with ./configure --help
Nelson Pereira wrote:
> I don't even know what flags to use...?!?
>
>
>
> Nelson Pereira
>
> Refer your friends and colleagues to MyFax!
> Click here for more information. www.MyFax.com
>
> -----Original Message-----
> From: Drew Barnes [mailto:barnesaw at ucrwcu.rwc.uc.edu]
> Sent: Thursday, April 03, 2008 11:13 AM
> To: Nelson Pereira
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] New install (second chance)
>
> # cat README | grep configure
> 2 Run the "configure" script.
> ./configure --help to see the list of options
> ./configure (with the flags you want)
>
>
> Nelson Pereira wrote:
>
>> Hi,
>>
>>
>>
>> Trying this install again but this time with a RHEL4 box.
>>
>> Downloaded the tar.gz, unpacked, installed all perl modules, testdeps
>> all is fine... Then:
>>
>> Here is the output of ./configure and ./make install
>>
>> Can someone tell me what my problem is and how to fix it?
>>
>>
>>
>>
>>
>> [root at netnet-ems rt-3.6.6]#
>>
>> [root at netnet-ems rt-3.6.6]#
>>
>> [root at netnet-ems rt-3.6.6]# ./configure
>>
>> checking for a BSD-compatible install... /usr/bin/install -c
>>
>> checking for gawk... gawk
>>
>> checking for perl... /usr/bin/perl
>>
>> checking for chosen layout... RT3
>>
>> checking if user www exists... not found
>>
>> checking if user www-data exists... not found
>>
>> checking if user apache exists... found
>>
>> checking if group www exists... not found
>>
>> checking if group www-data exists... not found
>>
>> checking if group apache exists... found
>>
>> checking if group rt3 exists... not found
>>
>> checking if group rt exists... not found
>>
>> checking if group apache exists... found
>>
>> checking if database name is valid... yes
>>
>> configure: creating ./config.status
>>
>> config.status: creating sbin/rt-dump-database
>>
>> config.status: creating sbin/rt-setup-database
>>
>> config.status: creating sbin/rt-test-dependencies
>>
>> config.status: creating bin/mason_handler.fcgi
>>
>> config.status: creating bin/mason_handler.scgi
>>
>> config.status: creating bin/standalone_httpd
>>
>> config.status: creating bin/rt-crontool
>>
>> config.status: creating bin/rt-mailgate
>>
>> config.status: creating bin/rt
>>
>> config.status: creating Makefile
>>
>> config.status: creating etc/RT_Config.pm
>>
>> config.status: creating lib/RT.pm
>>
>> config.status: creating bin/mason_handler.svc
>>
>> config.status: creating bin/webmux.pl
>>
>> [root at netnet-ems rt-3.6.6]# make install
>>
>> mkdir -p //opt/rt3/etc
>>
>> cp etc/RT_Config.pm //opt/rt3/etc/RT_Config.pm
>>
>> [ -f //opt/rt3/etc/RT_SiteConfig.pm ] || cp etc/RT_SiteConfig.pm
>> //opt/rt3/etc/RT_SiteConfig.pm
>>
>> chgrp apache //opt/rt3/etc/RT_Config.pm
>>
>> chown root //opt/rt3/etc/RT_Config.pm
>>
>> chgrp apache //opt/rt3/etc/RT_SiteConfig.pm
>>
>> chown root //opt/rt3/etc/RT_SiteConfig.pm
>>
>> Installed configuration. about to install rt in /opt/rt3
>>
>> mkdir -p //opt/rt3/var/log
>>
>> mkdir -p //opt/rt3/var/mason_data
>>
>> mkdir -p //opt/rt3/var/mason_data/cache
>>
>> mkdir -p //opt/rt3/var/mason_data/etc
>>
>> mkdir -p //opt/rt3/var/mason_data/obj
>>
>> mkdir -p //opt/rt3/var/session_data
>>
>> mkdir -p //opt/rt3/share/html
>>
>> mkdir -p //opt/rt3/local/html
>>
>> mkdir -p //opt/rt3/local/etc
>>
>> mkdir -p //opt/rt3/local/lib
>>
>> mkdir -p //opt/rt3/local/po
>>
>> [ -d //opt/rt3/lib ] || mkdir -p //opt/rt3/lib
>>
>> cp -rp lib/* //opt/rt3/lib
>>
>> mkdir -p //opt/rt3/etc
>>
>> cp -rp \
>>
>> etc/acl.* \
>>
>> etc/initialdata \
>>
>> etc/schema.* \
>>
>> //opt/rt3/etc
>>
>> mkdir -p //opt/rt3/bin
>>
>> chmod +x bin/rt-mailgate \
>>
>> bin/rt-crontool
>>
>> cp -rp \
>>
>> bin/rt-mailgate \
>>
>> bin/mason_handler.fcgi \
>>
>> bin/mason_handler.scgi \
>>
>> bin/standalone_httpd \
>>
>> bin/mason_handler.svc \
>>
>> bin/rt \
>>
>> bin/webmux.pl \
>>
>> bin/rt-crontool \
>>
>> //opt/rt3/bin
>>
>> mkdir -p //opt/rt3/sbin
>>
>> chmod +x \
>>
>> sbin/rt-dump-database \
>>
>> sbin/rt-setup-database \
>>
>> sbin/rt-test-dependencies
>>
>> cp -rp \
>>
>> sbin/rt-dump-database \
>>
>> sbin/rt-setup-database \
>>
>> sbin/rt-test-dependencies \
>>
>> //opt/rt3/sbin
>>
>> [ -d //opt/rt3/share/html ] || mkdir -p //opt/rt3/share/html
>>
>> cp -rp ./html/* //opt/rt3/share/html
>>
>> cp -rp ./local/html/* //opt/rt3/local/html
>>
>> cp: cannot stat `./local/html/*': No such file or directory
>>
>> make: [local-install] Error 1 (ignored)
>>
>> cp -rp ./local/po/* //opt/rt3/local/po
>>
>> cp: cannot stat `./local/po/*': No such file or directory
>>
>> make: [local-install] Error 1 (ignored)
>>
>> cp -rp ./local/etc/* //opt/rt3/local/etc
>>
>> cp: cannot stat `./local/etc/*': No such file or directory
>>
>> make: [local-install] Error 1 (ignored)
>>
>> # RT 3.0.0 - RT 3.0.2 would accidentally create a file instead of a
>>
> dir
>
>> [ -f //opt/rt3/share/doc ] && rm //opt/rt3/share/doc
>>
>> make: [doc-install] Error 1 (ignored)
>>
>> [ -d //opt/rt3/share/doc ] || mkdir -p //opt/rt3/share/doc
>>
>> cp -rp ./README //opt/rt3/share/doc
>>
>> # Make the libraries readable
>>
>> chmod 0755 //opt/rt3
>>
>> chown -R root //opt/rt3/lib
>>
>> chgrp -R bin //opt/rt3/lib
>>
>> chmod -R u+rwX,go-w,go+rX //opt/rt3/lib
>>
>> chmod 0755 //opt/rt3/bin
>>
>> chmod 0755 //opt/rt3/bin
>>
>> chmod 0755 //opt/rt3/etc
>>
>> chmod 0500 //opt/rt3/etc/*
>>
>> #TODO: the config file should probably be able to have its
>>
>> # owner set separately from the binaries.
>>
>> chown -R root //opt/rt3/etc
>>
>> chgrp -R apache //opt/rt3/etc
>>
>> chmod 0550 //opt/rt3/etc/RT_Config.pm
>>
>> chmod 0550 //opt/rt3/etc/RT_SiteConfig.pm
>>
>> # Make the interfaces executable
>>
>> chown root //opt/rt3/bin/webmux.pl //opt/rt3/bin/rt-mailgate
>> //opt/rt3/bin/rt //opt/rt3/bin/rt-crontool
>> //opt/rt3/bin/standalone_httpd //opt/rt3/bin/mason_handler.scgi
>> //opt/rt3/bin/mason_handler.fcgi //opt/rt3/bin/mason_handler.svc
>>
>> chgrp apache //opt/rt3/bin/webmux.pl //opt/rt3/bin/rt-mailgate
>> //opt/rt3/bin/rt //opt/rt3/bin/rt-crontool
>> //opt/rt3/bin/standalone_httpd //opt/rt3/bin/mason_handler.scgi
>> //opt/rt3/bin/mason_handler.fcgi //opt/rt3/bin/mason_handler.svc
>>
>> chmod 0755 //opt/rt3/bin/webmux.pl //opt/rt3/bin/rt-mailgate
>> //opt/rt3/bin/rt //opt/rt3/bin/rt-crontool
>> //opt/rt3/bin/standalone_httpd //opt/rt3/bin/mason_handler.scgi
>> //opt/rt3/bin/mason_handler.fcgi //opt/rt3/bin/mason_handler.svc
>>
>> # Make the web ui readable by all.
>>
>> chmod -R u+rwX,go-w,go+rX //opt/rt3/share/html \
>>
>> //opt/rt3/local/html \
>>
>> //opt/rt3/local/po
>>
>> chown -R root //opt/rt3/share/html \
>>
>> //opt/rt3/local/html
>>
>> chgrp -R bin //opt/rt3/share/html \
>>
>> //opt/rt3/local/html
>>
>> # Make the web ui's data dir writable
>>
>> chmod 0770 //opt/rt3/var/mason_data \
>>
>> //opt/rt3/var/session_data
>>
>> chown -R apache //opt/rt3/var/mason_data \
>>
>> //opt/rt3/var/session_data
>>
>> chgrp -R apache //opt/rt3/var/mason_data \
>>
>> //opt/rt3/var/session_data
>>
>> Congratulations. RT has been installed.
>>
>>
>>
>>
>>
>> You must now configure RT by editing /opt/rt3/etc/RT_SiteConfig.pm.
>>
>>
>>
>> (You will definitely need to set RT's database password in
>>
>> /opt/rt3/etc/RT_SiteConfig.pm before continuing. Not doing so could
be
>>
>> very dangerous. Note that you do not have to manually add a
>>
>> database user or set up a database for RT. These actions will be
>>
>> taken care of in the next step.)
>>
>>
>>
>> After that, you need to initialize RT's database by running
>>
>> 'make initialize-database'
>>
>> [root at netnet-ems rt-3.6.6]# make initialize-database
>>
>> /usr/bin/perl //opt/rt3/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 localhost 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.
>>
>> Transactions not supported by database at
>> /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBI.pm line
>> 1668, <SCHEMA> line 463.
>>
>> make: *** [initialize-database] Error 2
>>
>> [root at netnet-ems rt-3.6.6]#
>>
>>
>>
>>
>>
>> *Nelson Pereira*
>> Senior Network Administrator
>>
>> Protus IP Solutions Inc.
>> npereira at protus.com <mailto:npereira at protus.com>
>> phone: 613.733.0000 ext.528
>> MyFax: 613.822.5083
>> www.myfax.com <http://www.myfax.com>
>>
>> Refer your friends and colleagues to MyFax!
>> Click here for more information.
>> <http://www.myfax.com/referral_program.asp>
>>
>>
>>
>> www.MyFax.com <http://www.myfax.com>
>>
>>
>>
>>
>>
>
------------------------------------------------------------------------
>
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> Buy a copy at http://rtbook.bestpractical.com
>>
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sales at bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
--
MFG
Torsten Brumm
http://www.torsten-brumm.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080403/f22a4388/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 4180 bytes
Desc: image001.gif
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080403/f22a4388/attachment.gif>
More information about the rt-users
mailing list