1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Install problems

Discussion in 'Sitebuilder 4.0 for Linux' started by jampudding, Sep 27, 2007.

  1. jampudding

    jampudding Guest

    0
     
    Hi,

    I am having problems installing sitebuilder 4 on a centos5 running whm/cpanel

    I have ran the auto installer and the error I get is:-

    [2007 Sep 27 10:47:33] [FATAL] Error connecting to MySQL on localhost:3306
    Reason: Access denied for user 'root'@'localhost' (using password: NO)
    Fatal error encountered at /usr/local/sitebuilder/utils//SB/Logging.pm line 121
    SB::Logging::Log('SB::Logging=HASH(0x91eb180)', 5, 'Error connecting to MySQL on localhost:3306\x{a}Reason: Access de...') called at /usr/local/site$
    SB::Utils::checkParameters() called at configure line 200
    main::main() called at configure line 287

    And many repetitions of

    if I run sb_config I get:-

    [FATAL] Error connecting to MySQL on localhost:3306
    Reason: Access denied for user 'root'@'localhost' (using password: YES)
    There were some configuration errors, check logs

    I realise this must need login details for the mysql somewhere but how where why etc!

    Any help is much appreciated

    Thanks

    JP
     
  2. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    Try to change default password for 'root' user connection to MySQL database in /usr/local/sitebuilder/utils/SB/Defaults.pm file:

    'db_admin_name' => "root",
    'db_admin_passwd' => "admin",

    If password is empty, just set empty password instead of 'admin'. If it is not empty, set correct one.

    After that re-run 'sb_config' utility and let me know about the results.
     
  3. caustic

    caustic Guest

    0
     
    Or even better, read sb_config --help and use db_admin_passwd and db_admin_user options
     
  4. jampudding

    jampudding Guest

    0
     
    Hi,

    Thanks for the replies.

    Already tried both your suggestions but neither work.

    SwSoft 2nd line are taking a look

    Thanks

    JP
     
  5. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    Were you able to resolve this situation? Did support team help in this case? Let me know if you need any further assistance. If situation is resolved could you post solution here?
     
  6. dnerty

    dnerty Guest

    0
     

    I have the sam problem on Centos 5 / CPanel / MySQL5 /php5.

    I changed dv_admin_name and db_admin_passwd and now I can run sb_config without error, but with no result!
    # sb_config
    Logs saved to /usr/local/sitebuilder/tmp/sb_config-0711291233.log
    And - the log is empty..

    Pls help..

    p.s. sitebuider has been installed, but without mysql db

    Downloading the file SiteBuilder/SiteBuilder_4.0.0/dist-rpm-CentOS-5-i386/locales/sitebuilder_zh_TW-4.0.0-all.07070609.noarch.rpm: skipped because of md5 checksum match.
    Starting installation of packages
    Installing the package sitebuilder-4.0.0-all.build07062700.noarch

    SiteBuilder has been installed successfully!
    Use sb_config command to configure SiteBuilder.
    'sb_config --help' displays help information.
    Usage: /etc/init.d/mysql {start|stop|restart|reload} [ MySQL server options ]
    Starting MySQL[ OK ]
    [FATAL] Error connecting to MySQL on localhost:3306
    Reason: Access denied for user 'root'@'localhost' (using password: NO)
    There were some configuration errors, check logs
    Logs saved to /usr/local/sitebuilder/tmp/sb_config-0711291230.log
    Installing the package sitebuilder_module-areamap-4.0.0-all.build07062700.noarch
    [FATAL] Error connecting to MySQL on localhost:3306
    Reason: Access denied for user 'root'@'localhost' (using password: YES)
    There were some configuration errors, check logs
    Installing the package sitebuilder_module-download
     
  7. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    Try to specify MySQL password for root user using sb_config utility:

    # sb_config --db_admin_name root --db_admin_passwd ROOT_PASSWORD

    It seems MySQL root user requires some password to log into MySQL. Update it for Sitebuilder configuration and after that try to re-run installation. You already have Sitebuilder packages uploaded into your server. Find them and re-install with
    "rpm -Uhv <PACKAGES> --force"
    command. Hope it helps.
     
  8. dnerty

    dnerty Guest

    0
     
    Yes, that helps..
    But now I have another problem:

    404 Not Found Not Found The requested URL /Login was not found on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

    Checked zz011_sitebuilder.conf but can't see anything wrong.

    index.php is encoded and can't see anything..

    pls help

    thanks
     
  9. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    Make sure that Sitebuilder configuration file zz011_sitebuilder.conf is included into apache configuration. You can also check apache log files and find out where does it search documents when you browse http://sitebuilder.hostname/Login.
     
  10. dnerty

    dnerty Guest

    0
     
    Of course it is included.. /Login is unreachable..
     
  11. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    So make sure that main Sitebuilder package installed correctly:
    # rpm -V sitebuilder-4.0.0-all.build07062700|grep missing

    This is structure of htdocs/ folder on my test installation:

    # ls -la /usr/local/sitebuilder/htdocs/
    200
    drwxr-xr-x 12 root root 4096 Nov 22 11:57 .
    drwxr-xr-x 9 root root 4096 Nov 5 03:26 ..
    drwxr-xr-x 2 root root 4096 Nov 7 12:40 applet
    -rw-r--r-- 1 root root 28 Nov 27 00:09 blank.html
    -rw-r--r-- 1 root root 12253 Nov 27 00:09 check.php
    -rw-r--r-- 1 root root 1522 Nov 27 00:09 external_login.php
    -rw-r--r-- 1 root root 2550 Nov 27 00:09 favicon.ico
    drwxr-xr-x 6 root root 4096 Nov 7 12:40 images
    -rw-r--r-- 1 root root 3317 Nov 27 00:09 index.php
    -rw-r--r-- 1 root root 2328 Nov 27 00:09 init.php
    drwxr-xr-x 5 root root 4096 Nov 22 11:57 js
    -rw-r--r-- 1 root root 1866 Nov 27 00:09 localizedimage.php
    drwxrwxr-x 18 root root 4096 Nov 7 12:44 modules
    -rw-r--r-- 1 root root 23 Nov 31 17:49 phpinfo.php
    -rw-r--r-- 1 root root 25 Nov 27 00:09 robots.txt
    drwxr-xr-x 3 root root 4096 Nov 7 12:40 ServiceFacade
    drwxr-xr-x 64 apache apache 4096 Nov 30 13:31 sites
    drwxr-xr-x 17 root root 4096 Nov 7 12:40 skins
    drwxr-xr-x 496 root root 20480 Nov 15 17:10 templates
    -rw-r--r-- 1 root root 401 Nov 7 12:34 test.php
    drwxr-xr-x 3 apache apache 4096 Nov 25 11:49 tmp
    drwxr-xr-x 4 root root 4096 Nov 7 12:40 wysiwyg

    Also, did you check apache error log files? There you should find out where apache looks files when you try to access http://sitebuilder.hostname/Login.
     
  12. dnerty

    dnerty Guest

    0
     
    I found mistake - mod_rewrite was not loaded for some reason..
    Mod_rewrite module was installed, but the line
    LoadModule rewrite_module libexec/mod_rewrite.so
    was missing in httpd.conf.

    Now everything is working fine.

    Thanks for help
     
  13. dnerty

    dnerty Guest

    0
     
    hmmm..
    I can't log in as admin/admin..
    What to do?
    Thanks
     
  14. dnerty

    dnerty Guest

    0
     
    Anybody with the same problem?
    Can't log in with admin/admin.. Tried to reinstall, tried to update admin password with phpmyadmin - nothing..
     
  15. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    Try to use following article to update admin password for Sitebuilder:
    http://kb.swsoft.com/en/1423
    As for Sitebuilder Wizard access use following article as resolution:
    http://kb.swsoft.com/en/2217
    Also which apache version do you use on your server? As I understand you have also Cpanel installed on it, do you?
    As I remember there were couple similar issues in the past when customers could not log into Sitebuiler. This issue was caused by apache 1.3 compiled on the server. After apache upgrade everything started to work fine.
     
  16. dnerty

    dnerty Guest

    0
     
    I used Apache 1.3.7, upgraded to 2.2 and after some time get the sitebuilder works.
    I created demo plan, but on demo get this error:

    Internal SiteBuilder error.
    File: /usr/local/sitebuilder/include/SB/Site/Page/Simple.php; Line: 107
    Message: PHP Warning : file_put_contents(/usr/local/sitebuilder/htdocs/sites/ca/caea7dcfa81f650f0f82f98f670a3ae8/zhwle62xy7x.content.html) [function.file-put-contents]: failed to open stream: No such file or directory; Code: 2

    Lots of troubles with sitebuilder..
    What do you suggest now?
    Thanks
     
  17. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    It seems this is some permissions issue on the server. By default ownership for Sitebuilder folders is set to apache:apache but on servers with Cpanel apache uses following group and user - nobody:nobody. So in this case try to perform following steps:

    1. # sb_config --httpd_owner nobody:nobody

    2. Make sure that utility /usr/local/sitebuilder/utils/fix_permissions contains following code:

    # cat /usr/local/sitebuilder/utils/fix_permissions
    #!/usr/bin/env perl

    use strict;
    use warnings;
    use FindBin qw($Bin);
    use lib "$Bin/";
    use SB::Defaults qw($CONFIG $SB_CONFIG $SB_PREFIX);
    use SB::Logging;
    use File::Spec;
    require SB::Utils;

    sub main() {
    my $config = SB::Utils::parseIni($SB_CONFIG, $CONFIG);
    $Logger->init(File::Spec->devnull());
    $Logger->setShowLogName(0);
    my $retval = SB::Utils::changeOwner($config->{'internal'}->{'httpd_owner'});
    exit $retval;
    }

    main();

    3. Run fix_permissions utility:

    # perl /usr/local/sitebuilder/utils/fix_permissions

    Hope it helps.
     
  18. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    Code should be the following:

    # cat /usr/local/sitebuilder/utils/fix_permissions
    #!/usr/bin/env perl

    use strict;
    use warnings;
    use FindBin qw($Bin);
    use lib "$Bin/";
    use SB::Defaults qw($CONFIG $SB_CONFIG $SB_PREFIX);
    use SB::Logging;
    use File::Spec;
    require SB::Utils;

    sub main() {
    my $config = SB::Utils::parseIni($SB_CONFIG, $CONFIG);
    $Logger->init(File::Spec->devnull());
    $Logger->setShowLogName(0);
    my $retval = SB::Utils::changeOwner($config->{'internal'}->{'httpd_owner'});
    exit $retval;
    }

    main();
     
  19. dnerty

    dnerty Guest

    0
     
    It's working now!
    Thanks for help. I suggest you to complete your Readme, FAQ, etc.. Sitebuilder is great, but installation is really painful.

    Finally - my configuration - CentOS 5, Cpanel 11, apache 2.2, mysql5, php5 with
    Curl, GD, Iconv, Mbregex, Openssl, POSIX, PathInfoCheck, Pear, TTF, XSL, XmlRPC, Zip, Zlib, Zendopt ON

    Regards

    p.s. pls delete link and name of my site in your post http://forum.swsoft.com/showpost.php?p=192808&postcount=11,
    thanks
     
  20. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
Loading...