• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Install problems

J

jampudding

Guest
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
 
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.
 
Originally posted by Dmitry Frantsev
Try to change default password for 'root' user connection to MySQL database in /usr/local/sitebuilder/utils/SB/Defaults.pm file:
Click to expand...
Or even better, read sb_config --help and use db_admin_passwd and db_admin_user options
 
Hi,

Thanks for the replies.

Already tried both your suggestions but neither work.

SwSoft 2nd line are taking a look

Thanks

JP
 
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?
 
Originally posted by Dmitry Frantsev
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.
Click to expand...


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
 
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.
 
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
 
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.
 
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
 
Anybody with the same problem?
Can't log in with admin/admin.. Tried to reinstall, tried to update admin password with phpmyadmin - nothing..
 
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.
 
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
 
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.
 
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();
 
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
 
You must log in or register to reply here.

Similar threads

Y
Resolved SQLSTATE[HY000] [1045] Access denied for user 'es_fprkmvi'@'localhost' (using password: YES)
Replies
16
Views
7K
ynb.dev002
Y
V
Resolved Error after update MariaDb 10.5 to 10.6 : impossible to remove the skip-grant-tables
Replies
2
Views
2K
valko
V
K
Unable to establish a connection to the database
Replies
6
Views
3K
scsa20
scsa20
G
Issue Could not connect to database
Replies
8
Views
1K
MartinT
M
P
Forwarded to devs Plesk Migrator does not copy databases from DirectAdmin
Replies
4
Views
1K
Peter Debik
P
Back
Top