Topic: Metadot 6.4.5.4 install hiccup

[fixit]

the default password ''123456'' is to log into metadot when the installation is complete

the password for the database is whatever you choose ''yourpassword'' or if you like, leave it as is.

What if I create an install script for you to use, this will do the installation of metadot for you

I use WinSCP to modify or copy and transfer files, I find it really easy to use as with putty http://winscp.net/ or click this link to download it http://winscp.net/download/winscp404setup.exe


Russell

[imcintyre]

Re the database password, is there a restriction on nonalphanumeric characters?  I always try to include at least 1 of these in my passwords. I noticed that when I was trying to fix things up following the instructions above, something did not go right one of the commands.

What is the difference between the 87 digit randomly generated password for mysql and this database password?

Ian

[fixit]

By looking at your bash history, I noticed that this command had not been run

config setprop modPerl status enabled

and

signal-event post-upgrade

go to /etc/httpd/conf and open httpd.conf, look at line 113, do you have something like LoadModule perl_module   modules/mod_perl.so with out the #

# Extra Modules
#LoadModule php_module         modules/mod_php.so
#LoadModule php3_module        modules/libphp3.so
LoadModule external_auth_module modules/mod_auth_external.so

LoadModule php4_module modules/libphp4.so
LoadModule perl_module   modules/mod_perl.so
LoadModule ssl_module        modules/mod_ssl.so
AddExternalAuth pwauth /usr/lib/httpd/modules/pwauth
SetExternalAuthMethod pwauth pipe


Russell

[imcintyre]

Starting with Line 107 I have the following:

# Extra Modules
#LoadModule php_module         modules/mod_php.so
#LoadModule php3_module        modules/libphp3.so
LoadModule external_auth_module modules/mod_auth_external.so

LoadModule php4_module modules/libphp4.so
# modPerl disabled
LoadModule ssl_module        modules/mod_ssl.so
AddExternalAuth pwauth /usr/lib/httpd/modules/pwauth
SetExternalAuthMethod pwauth pipe

[imcintyre]

I got it working thx. One of the mistakes I made that others may make involved this step in the how to

#Metadot

   ServerName yourdomain.com
   
   DocumentRoot         /opt/metadot/metadot
   Alias /metadot /opt/metadot/metadot
   Alias /images/ /opt/metadot/images/
   Alias /js/ /opt/metadot/js/
   Alias /index.pl /opt/metadot/metadot/index.pl
   Alias /public/   /opt/metadot/sitedata/public/
   Alias /skins/    /opt/metadot/sitedata/skins/
   Alias /htmlarea3/ /opt/metadot/js/htmlarea3/
   Alias /private/  /opt/metadot/sitedata/private/
   Alias /userchannel.pl /opt/metadot/metadot/userchannel.pl

<Directory /opt/metadot>
   Options +Indexes +Includes +FollowSymLinks -MultiViews +ExecCGI
   AllowOverride All
   allow from all
   AddHandler  cgi-script .pl
   PerlHandler speedy::Registry
   PerlSendHeader      On
   DirectoryIndex      index.pl
</Directory>

I assumed that changing the "ServerName  yourdomain.com" to my actual servername and domain name was required.This proved not required.

[pearl]

also, did you have any trouble with Dag repository

and was all the perl modules installed

yum --enablerepo=base --enablerepo=updates --enablerepo=addons --enablerepo=dag install perl-GD perl-GD-Graph perl-GD-Graph3d perl-GD-Text-Util perl-Date-Pcalc perl-Email-Valid perl-Apache-DBI perl-AppConfig perl-Archive-Tar perl-Archive-Zip perl-Bit-Vector perl-CGI-SpeedyCGI perl-Compress-Zlib perl-Data-Compare perl-Date-Calc perl-ExtUtils-PkgConfig perl-File-Find-Rule perl-File-HomeDir perl-HTML-Format perl-HTML-Template perl-HTML-Tree perl-Image-Base perl-Image-Size perl-Lingua-EN-NameParse perl-LWP-UserAgent-Determined perl-Mail-POP3Client perl-MailTools perl-HTTP-BrowserDetect perl-HTTP-Server-Simple perl-HTTP-Request-Form perl-HTTP-DAV perl-MIME-tools perl-Number-Compare perl-Number-Format perl-OLE-Storage_Lite perl-Parse-RecDescent perl-Pod-POM perl-Spreadsheet-WriteExcel perl-Template-Toolkit perl-Test-Builder-Tester perl-Test-Manifest perl-Test-Simple perl-Test-SimpleUnit perl-Text-Autoformat perl-Text-CSV_XS perl-Unicode-String perl-XML-Dumper perl-XML-RSS perl-XML-Simple

Russell

I had problems installing these, is there a way to fix it?

[fixit]

What was the problem you had, was it with the dag repositories or something else

did you get this error message below

http://apt.sw.be/redhat/el4/en/i386/dag/repodata/primary.xml.gz: [Errno -1] Meta data file does not match checksum
Trying other mirror.
Error: failure: repodata/primary.xml.gz from dag: [Errno 256] No more mirrors to try.

if so, try running these commands below

wget --cache=off http://apt.sw.be/redhat/el4/en/i386/dag/repodata/filelists.xml.gz

wget --cache=off http://apt.sw.be/redhat/el4/en/i386/dag/repodata/primary.xml.gz

wget --cache=off http://apt.sw.be/redhat/el4/en/i386/dag/repodata/repomd.xml

Russell

[pearl]

Hi Russel,

I just got finished installing it correct now. What i did was installing the perl modules in bits and pieces. Finally it worked and i was able to login. Don't know why it wouldn't install the first time, maybe there was a timeout orso. Not sure about that.

Thanks for your quick response. 

[bloodshoteye]

Hi Russell

I'm installing Metadot 6 for a customer on a fresh SME 7.2 install with all current updates.
I get this perl transaction check error:

Transaction Check Error:   file /usr/lib/perl5/vendor_perl/5.8.5/Test/Builder/Tester.pm conflicts between attempted installs of perl-Test-Builder-Tester-1.01-1.2.el4.rf and perl-Test-Simple-0.72-1.el4.rf
  file /usr/share/man/man3/Test::Builder::Tester.3pm.gz conflicts between attempted installs of perl-Test-Builder-Tester-1.01-1.2.el4.rf and perl-Test-Simple-0.72-1.el4.rf
  file /usr/share/man/man3/Test::Builder::Tester::Color.3pm.gz conflicts between attempted installs of perl-Test-Builder-Tester-1.01-1.2.el4.rf and perl-Test-Simple-0.72-1.el4.rf

Any ideas, please?
Thanks for your patience.

[fixit]

try without installing perl-Test-Simple-0.72-1.el4.rf and see what happens

[bloodshoteye]

I re-installed and tried again. The perl update only completes if I remove perl-Test-Simple-0.72-1.el4.rf from the list.
Both times I have the exact same result:

# perl index.pl
DBI connect('metadotdb','metadot',...) failed: Access denied for user 'metadot'@'localhost' (using password: YES) at DBAccess/MySQL.pm line 87
<h2>Unable to connect to SQL Server</h2>
db_name: dbi:mysql:metadotdb<br />db_user: metadot<br />db_password: (not displayed)
Can't call method "tables" on an undefined value at DBAccess/DBIObj.pm line 94.
Compilation failed in require at Portal.pm line 36.
BEGIN failed--compilation aborted at Portal.pm line 36.
Compilation failed in require at index.pl line 39.
BEGIN failed--compilation aborted at index.pl line 39.
speedy_backend[5492]: perl_parse error
speedy[5490]: Cannot spawn backend process

Huh? - both times I made absolutely sure I followed your howto, especially using copy and paste.
Both times I made sure of the mysql requirements too 

I have re-installed again and will give them Joomla in /opt. Real easy to upgrade it to V 1.0.13

I'm still intrigued why Metadot 6 is failing - I've had successful installations in the past on SME 7.2 

Mean time I thank the SME community for all their hard work and am grateful for what they provide us. I've also been grateful in a monetary way and will do so again - really looking forward to SME 8

[fixit]

speedy[5490]: Cannot spawn backend process

This could be due to that mod_perl was not install or activated

check to see if mod perl was installed

rpm -qa | grep mod_perl

if you get mod_perl-1.99_16-4.5, then try this to activate mod_perl

config setprop modPerl status enabled

signal-event post-upgrade

also check that other perl modules are installed

rpm -qa | grep perl-CGI-SpeedyCGI

perl-CGI-SpeedyCGI-2.22-1.2.el4.rf

rpm -qa | grep perl-Apache-DBI

perl-Apache-DBI-0.9901-2.2.el4.rf

If you did not get perl-CGI-SpeedyCGI-2.22-1.2.el4.rf and perl-Apache-DBI-0.9901-2.2.el4.rf after you ran the rpm -qa | grep, then it could be a problem with dag repository


Try setting up this repo


/sbin/e-smith/db yum_repositories set bfc-perl repository \
Name 'BFC - PERL' \
BaseURL 'http://www.fixitcomputers.com.au/yum/rpms/perl' \
EnableGroups no \
status disabled

expand-template /etc/yum.conf

yum --enablerepo=base --enablerepo=updates --enablerepo=addons --enablerepo=bfc-perl install perl-GD perl-GD-Graph perl-GD-Graph3d perl-GD-Text-Util perl-Date-Pcalc perl-Email-Valid perl-Apache-DBI perl-AppConfig perl-Archive-Tar perl-Archive-Zip perl-Bit-Vector perl-CGI-SpeedyCGI perl-Compress-Zlib perl-Data-Compare perl-Date-Calc perl-ExtUtils-PkgConfig perl-File-Find-Rule perl-File-HomeDir perl-HTML-Format perl-HTML-Template perl-HTML-Tree perl-Image-Base perl-Image-Size perl-Lingua-EN-NameParse perl-LWP-UserAgent-Determined perl-Mail-POP3Client perl-MailTools perl-HTTP-BrowserDetect perl-HTTP-Server-Simple perl-HTTP-Request-Form perl-HTTP-DAV perl-MIME-tools perl-Number-Compare perl-Number-Format perl-OLE-Storage_Lite perl-Parse-RecDescent perl-Pod-POM perl-Spreadsheet-WriteExcel perl-Template-Toolkit perl-Test-Builder-Tester perl-Test-Manifest perl-Test-Simple perl-Test-SimpleUnit perl-Text-Autoformat perl-Text-CSV_XS perl-Unicode-String perl-XML-Dumper perl-XML-RSS perl-XML-Simple


Russell