HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


Mysql Issue

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#105762 (In Topic #20633)
Avatar

Fan in training

Hello,
I am having a strange issue when attempting to install this. On step 3 it's asking the forum system, so I picked IPB 1.x (Currently running on a old site). I told it not to have the forum and portal different and no for join a network of multiple ocPortal sites. For the Database I have the mysql 4.0+ (Traditional driver). 

On step 4 of the installer it filled in most of my info, I filled in the rest, however once I push Install ocPortal I get the following:

Could not connect to database-server (Access denied for user install@localhost (using password NO), mysql_connect()[<a href-function.mysql0connect> function.mysql-connect </a>]: Access denied for user installer@localhost (Using passwordL NO))

This should be using a password as I have it setup to use a password but no go. Perhaps it's something server side so here is my server info:

CENTOS 6.6 X86_64 Standrd
Mysql Version: 5.5.40
Apache Version: 2.4
PHP Version: 5.3 with suphp and Apache SuEXEc
ConfigServer Security % Firewall - csf V7.56 (Although other scripts are fine so I don't think this is the issue)
Back to the top
 
Posted
Rating:
#105767
Avatar

Fan in training

This is also a Cpanel Server. I have confirmed other software (Such as PHPBB) will install and connect to the database just fine. I also verified the username for the mysql database was permitted to connect from any host (%) and localhost but still nothing.

Am I missing something or could it be something with Cpanel preventing it or is the code used to connect outdated? I noticed in PHP 5.3 some older software wouldn't run so I am wondering if this is the issue.

Any advice on what to check?
Back to the top
 
Posted
Rating:
#105770
Avatar

Hi,

That's very weird. I just ran some tests and it was okay, and nobody's reported a problem like this, plus the code hasn't changed in years.

I wonder if perhaps something is interfering with your web request, such as something like modsecurity on the server, or some local application firewall system.

ocPortal saves the password into info.php before it does anything. You should see a line get saved in it like this:

Code

$SITE_INFO['db_forums_password']='xxx';

If 'xxx' is actually blank (''), it indicates somehow it has come through from the installer field as blank. Either was left blank there, or something third party blanked it.

I assume 'install' is the correct IPB1 user, and there was meant to be some password to go with that.


I tried Googling around to see if there are situations where MySQL ignores the password given, but I couldn't see any.

Oddly it looks like the error message you gave above is hand-typed, because I see typos in it. For example, "Using passwordL NO" should be "Using password: NO". If you didn't hand-type that (and I'm not sure why you wouldn't have copy&pasted), it suggests something very odd, such as heavy Internet connection corruption on your line.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#105771
Avatar

I just looked up what CSF is, and it includes ModSecurity.

"A Stateful Packet Inspection (SPI) firewall, Login/Intrusion Detection and Security application for Linux servers."

It would not be surprising to me if it is interfering. We have no end of problems with ModSecurity and its outside our control to turn it off.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: