Why PHP RT is PERL !!!! 2008/4/3, Nelson Pereira <[EMAIL PROTECTED]>: > > 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. > [EMAIL PROTECTED] > 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> > > [image: www.MyFax.com] <http://www.myfax.com> > > > ------------------------------ > > *From:* Torsten Brumm [mailto:[EMAIL PROTECTED] > *Sent:* Thursday, April 03, 2008 2:14 PM > *To:* Nelson Pereira > *Cc:* Drew Barnes; [email protected] > *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 <[EMAIL PROTECTED]>: > > 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...: > > [EMAIL PROTECTED] 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 > [EMAIL PROTECTED] 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. > [EMAIL PROTECTED] > > 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:[EMAIL PROTECTED] > > Sent: Thursday, April 03, 2008 11:55 AM > To: Nelson Pereira > Cc: [email protected] > 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:[EMAIL PROTECTED] > > Sent: Thursday, April 03, 2008 11:13 AM > > To: Nelson Pereira > > Cc: [email protected] > > 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? > >> > >> > >> > >> > >> > >> [EMAIL PROTECTED] rt-3.6.6]# > >> > >> [EMAIL PROTECTED] rt-3.6.6]# > >> > >> [EMAIL PROTECTED] 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 > >> > >> [EMAIL PROTECTED] 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' > >> > >> [EMAIL PROTECTED] 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 > >> > >> [EMAIL PROTECTED] rt-3.6.6]# > >> > >> > >> > >> > >> > >> *Nelson Pereira* > >> Senior Network Administrator > >> > >> Protus IP Solutions Inc. > >> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > >> 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: [EMAIL PROTECTED] > >> > >> > >> 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: [EMAIL PROTECTED] > > > 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 >
-- MFG Torsten Brumm http://www.torsten-brumm.de
<<image001.gif>>
_______________________________________________ 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
