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