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.


SQL Error installing

Login / Search

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

Fan in training

I tried all three methods of installing and when I run install.php, I get the following error:

ocPortal error

Could not connect to database-server (Client does not support authentication protocol requested by server; consider upgrading MySQL client)

Details here are intended for the website/system-administrator, not for regular website users. If you are a regular website user, please let the website staff deal with this problem.

Depending on the error, you may need to edit the base configuration (the info.php file).

ocProducts maintains full documentation for all procedures and tools. These may be found on the ocPortal website. If you are unable to easily solve this problem, we may be contacted from our website and can help resolve it for you.

I recently upgraded MySQL, however, I'm using Plesk conrol panel. I'm not sure if this is a probllem. Any help appreciated.

Ellen

Back to the top
 
Posted
Rating:
#32933
Joe
Avatar

Honoured member

As you said this error occurs when you first run the install.php file? It sounds like your MySQL is not compatible with ocPortal, as in, your version of MySQL is older than what ocPortal supports. I'll leave Chris to determine the problem though. :)

Back to the top
 
Posted
Rating:
#32939

Non-joined user

Running MySQL 4.1.21

Thanks for your reply.

I checked the requirements and it said MySQL version 4 or later. I'm running MySQL version 4.1.21. The error said "Consider Upgrading," it didn't say I must upgrade. Not sure why this error appears since I'm within the stated requirements. I'm thinking that it may have something to do with my server running under the Plesk control panel environment-but not sure.

Back to the top
 
Posted
Rating:
#32940
Avatar

Hi,

I've never experienced this one myself, but I'll try and make sense of what I've read…

Basically the PHP on your server is too old to work with this mySQL version.
There are a number of workarounds, but the most obvious is probably to just upgrade PHP. See:
MySQL :: MySQL 5.0 Reference Manual :: B.1.2.4 Client does not support authentication protocol


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:
#33016
Avatar

Fan in training

My server meets the requirements listed

My php version is 4.3, The requirements state that PHP 4.2 and above. MySQL also meets listed requirements. Have the requiremens changed?
Back to the top
 
Posted
Rating:
#33026

Non-joined user

 :$ this is my test
Back to the top
 
Posted
Rating:
#33028
Avatar

Community saint

ellenchenlan said

My php version is 4.3, The requirements state that PHP 4.2 and above. MySQL also meets listed requirements. Have the requiremens changed?

Are you talking about the requirement for ocPortal?

I run http://otakuplayground.com and am hopping to make themes and other things for ocportal even though I no longer use it for otakuplayground.com I still love it and feel it could go far with the right help. It needs themes and needs people to advertise for it.
Back to the top
 
Posted
Rating:
#33034
Avatar

ellenchenlan said

My php version is 4.3, The requirements state that PHP 4.2 and above. MySQL also meets listed requirements. Have the requiremens changed?

This is a fundamental problem between PHP and mySQL on your server, and not related to ocPortal itself.


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:
#33066
Avatar

Fan in training

Yes, I'm talking about the requirements for OCPortal I found posted on this web site.

The error message says OCPortal Error and says, "consider upgrading "mySQL." Chris says PHP is too old, and to upgrade PHP.

What would be helpful is someone could tell me the minimum requirements for PHP and mySQL for OCPortal. I can probably proceed from there.

As far as I can tell based on the information posted on this web site, I meet the requirements to run OCPortal. If not, tell me what they are.
Back to the top
 
Posted
Rating:
#33068
Joe
Avatar

Honoured member

Wow - I was way off. :P Apologies.

Back to the top
 
Posted
Rating:
#33080
Avatar

This isn't a problem between PHP, mySQL, and ocPortal. It's a problem just between PHP and mySQL, and would happen for any PHP application needing access to the database. Where it says "ocPortal error", it is a bit misleading; it is an error that is stopping ocPortal working, but the main error message didn't originate in ocPortal, and ocPortal didn't cause it.

As I mentioned, I've never encountered this myself, but I have now looked into it fully, and it seems only PHP version 5 can work with mySQL 4.1 and newer and newer, unless special measures are taken:
  • the password authentication method for any mySQL user account that PHP will access is manually changed to the old style
  • or, the whole server is set to continue to use old style password authentication method when first upgrading/installing mySQL 5

I guess most shared webhosts do one of the options behind-the-scenes, but as you're managing your own server, it falls to you to make sure mySQL and PHP are compatible with each other.

I'd advise upgrading to PHP 5.


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:
#33091
Avatar

Community saint

yes I agree with Chris and besides php 5 is faster at least for me and on the server I am on I can switch back and forth between php 5 and php 4 and ocPortal loads faster.
You need a page load timer to notice but its still faster.

BTW when I switch between php 4 and php 5 the sql version also changes from version 4 to 5.
So what ever version of php I am using I am using the same version of sql. Its kind of neat how that works.

I run http://otakuplayground.com and am hopping to make themes and other things for ocportal even though I no longer use it for otakuplayground.com I still love it and feel it could go far with the right help. It needs themes and needs people to advertise for it.
Back to the top
 
Posted
Rating:
#33174
Avatar

Fan in training

Thanks for the replies. From what I read, OCPortal cannot run on my server. Regaredless that my installation of PHP and MySQL meet the stated requirements.  Why, who knows?

I have set up many sites, installed many scripts over the years and this is the first time I've seen this type of error. But it is a typically cryptic programmer's error message that does not tell the user what to do or what the real problem is.

I expected help here - if only someone just stating the exact requirements for OCPortal without the technobabble double talk.

Thanks for you time, I think I will go else where.  O_o

Back to the top
 
Posted
Rating:
#33179
Avatar

In lay-persons' terms, your current version of PHP and your current version of MySQL are not compatible together, but separately they do meet the requirements of ocPortal.

To solve the problem: upgrade your version of PHP to the latest version.


Like ocPortal on Facebook:
Back to the top
 
Posted
Rating:
#33352
Avatar

Fan in training

Upgraded PHP

It would have been nice if someone would just say which versions work together instead of letting me guess.

Regardless, I upgraded to the lastest PHP. Still will not install. After I start filling out the form and click I'm Sure I want to Continue, I get a different message. In fact I get a whole page at: Step 4 out of 10. The top says: PHP [8] Undefined index: forum_type. Although, I did select OCPortals forum.

This is message followed by "Here is the stack trace." Followed by a lot of paths and code.

So now what?








Back to the top
 
Posted
Rating:
#33356
Avatar

Hi,

It looks like there's the previous problem has left a partially created info.php file behind. Please try deleting this file and then trying again.

This is a bug, so I'll be taking a closer look at it later on - our apologies for the inconvenience here.


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:
#33358
Avatar

Fan in training

It Works

Thanks - That did the trick. I'm really impressed. A great job with the admin pages. I've tried so many and each time I've been disappointed. This looks like it will more than suffice.


Last edit: by ellenchenlan
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: