[rt-users] New install (second chance)
Torsten Brumm
torsten.brumm at googlemail.com
Thu Apr 3 14:13:35 EDT 2008
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/b8d0e51a/attachment.htm>
More information about the rt-users
mailing list