Subject: MySQL 5.0 connection error with latest geeklog

Posted on: 19/12/05 01:28am
By: Anonymous

I'm setting up a new geeklog using the latest. Now, I haven't run the install admin php script yet, but I am getting this error. Anybody seen it before, I'll try the install script next..

Warning: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\indigoperl\apache\geeklog-1.3.11sr3\system\databases\mysql.class.php on line 112

Warning: MySQL Connection Failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\indigoperl\apache\geeklog-1.3.11sr3\system\databases\mysql.class.php on line 112
Cannnot connect to DB server

MySQL 5.0 connection error with latest geeklog

Posted on: 19/12/05 01:51am
By: Anonymous

Same for admin/install/check.php

Warning: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\indigoperl\apache\geeklog-1.3.11sr3\system\databases\mysql.class.php on line 112

Warning: MySQL Connection Failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\indigoperl\apache\geeklog-1.3.11sr3\system\databases\mysql.class.php on line 112
Cannnot connect to DB server

MySQL 5.0 connection error with latest geeklog

Posted on: 19/12/05 02:17pm
By: Dirk

As the error message says: The client (i.e. PHP) is not compatible with the MySQL version. Try recompiling PHP or get versions of both that work together.

This is a setup problem on your end - nothing to do with Geeklog.

bye, Dirk

MySQL 5.0 connection error with latest geeklog

Posted on: 19/12/05 06:31pm
By: Anonymous

Thanks man. Makes sense. I'll upgrade my IndigoPerl.

MySQL 5.0 connection error with latest geeklog

Posted on: 19/12/05 06:32pm
By: Anonymous

Link to [IndigoPerl].

MySQL 5.0 connection error with latest geeklog

Posted on: 19/12/05 08:42pm
By: ronack

I just installed PHP5 and MySQL 5 on Apache 2 on a Win2003 Server and for the most part all seems well. I know I must have something not set quite right though because I'm getting

An SQL error has occured. Please see error.log for details.

when I try to post something but all in all I think its working.

MySQL 5.0 connection error with latest geeklog

Posted on: 21/12/05 07:24am
By: Dirk

[QUOTE BY= ronack] I know I must have something not set quite right though because I'm getting

An SQL error has occured. Please see error.log for details.

when I try to post something but all in all I think its working.[/QUOTE]
So .. Was this supposed to be a bug report? Care to share that SQL error message?

bye, Dirk

MySQL 5.0 connection error with latest geeklog

Posted on: 21/12/05 05:20pm
By: ronack

I wasn't sure and I'm still not sure, It's not a bug, I think what happened was that I just copied everything over to the new server rather than do an install. So I'm going to try that first. I'm still getting the error when I try to post something.

MySQL 5.0 connection error with latest geeklog

Posted on: 21/12/05 10:11pm
By: ronack

Yes I did have to run the install with the new settings. I tried to do a upgrade but that didn't work so hot. So instead I created a new database folder and did a freash new install. I don't know if I can just copy the backup db files now but I think i'll try. I think the install must set some values that you don't get otherwise.

MySQL 5.0 connection error with latest geeklog

Posted on: 21/12/05 10:26pm
By: ronack

I thought that fixed it but it didn't, I still have the sql error. I'm starting to lean to permissions. But truthly I haven't a clue where to begin.

MySQL 5.0 connection error with latest geeklog

Posted on: 22/12/05 03:24am
By: Dirk

[QUOTE BY= ronack] But truthly I haven't a clue where to begin.[/QUOTE]
And I truely have no idea what you're trying to do there. But since you refuse to provide any details, you're obviously not interested in getting help ...

bye, Dirk

MySQL 5.0 connection error with latest geeklog

Posted on: 22/12/05 05:21pm
By: ronack

Don't get snippy Dirk, I was trying to fix it on my own than say how I fixed it. What's so strange is that the site is working but when I go to post anything story, link static page, etc I get the SQL message. First I thought that I didn't have write permissions on the DB (this is a fresh install on a new server) I made sure it did. Then I though that maybe I needed to install fresh. That didn't help either.

This is my first set up of Apache on a Windows 2003 Server machine. I am moving off of an Xitami web server on Windows XP.

Latest version of PHP and MySQL. By the way PHP 5 doesn't have native MySQL support anymore you have to add it. Now that might have something to do with it but maybe not. I'm going to work with MySQL tonight and this weekend to see if maybe that's the culprit. I'm sure that there is some obscure setting that I am missing.

MySQL 5.0 connection error with latest geeklog

Posted on: 22/12/05 09:42pm
By: ronack

Ok this error did come from Geeklog and here is the error out of the Geeklog error log.

12/22/2005 9:39:37 PM - 1366: Incorrect integer value: '' for column 'statuscode' at row 1. SQL in question: REPLACE INTO gl_stories (sid,uid,tid,title,introtext,bodytext,hits,date,comments,related,featured,commentcode,statuscode,expire,postmode,frontpage,draft_flag,numemails,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,show_topic_icon) VALUES ('20051222213240802',2,'General','test','test','',0,FROM_UNIXTIME(1135305160),'0','',0,'-1','','1999-11-30 12:00:40','plaintext','0',0,0,2,3,3,2,2,2,1) 


MySQL 5.0 connection error with latest geeklog

Posted on: 22/12/05 09:55pm
By: ronack

More info, it is only on submitting stories and staticpages, everything else seems to be working fine.

MySQL 5.0 connection error with latest geeklog

Posted on: 22/12/05 09:57pm
By: ronack

Here is the error for staticpage submission

12/22/2005 9:54:52 PM - 1366: Incorrect integer value: '' for column 'sp_nf' at row 1. SQL in question: REPLACE INTO gl_staticpage (sp_id,sp_uid,sp_title,sp_content,sp_date,sp_hits,sp_format,sp_onmenu,sp_label,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,sp_php,sp_nf,sp_centerblock,sp_tid,sp_where,sp_inblock) VALUES ('20051222215440680',2,'test','test','2005-12-22 21:54:40',0,'allblocks',0,'',2,14,3,2,2,2,'0','',0,'none',1,'1') 


Geeklog - Forum
https://www.geeklog.net/forum/viewtopic.php?showtopic=61478