Welcome to Geeklog, Anonymous Friday, November 08 2024 @ 09:15 pm EST
Geeklog Forums
MySQL 5.0 connection error with latest geeklog
TagStar
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
Text Formatted Code
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
28
15
Quote
TarStar
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
Text Formatted Code
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
20
13
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
This is a setup problem on your end - nothing to do with Geeklog.
bye, Dirk
16
19
Quote
TagStar
Anonymous
Thanks man. Makes sense. I'll upgrade my IndigoPerl.
16
13
Quote
TagStar
Anonymous
Link to [IndigoPerl].
15
24
Quote
Status: offline
ronack
Forum User
Full Member
Registered: 05/27/03
Posts: 612
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.
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.
12
13
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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.
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.
So .. Was this supposed to be a bug report? Care to share that SQL error message?
bye, Dirk
14
19
Quote
Status: offline
ronack
Forum User
Full Member
Registered: 05/27/03
Posts: 612
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.
12
14
Quote
Status: offline
ronack
Forum User
Full Member
Registered: 05/27/03
Posts: 612
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.
20
14
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by ronack: But truthly I haven't a clue where to begin.
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
13
14
Quote
Status: offline
ronack
Forum User
Full Member
Registered: 05/27/03
Posts: 612
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.
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.
17
10
Quote
Status: offline
ronack
Forum User
Full Member
Registered: 05/27/03
Posts: 612
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)
Text Formatted Code
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)
16
16
Quote
Status: offline
ronack
Forum User
Full Member
Registered: 05/27/03
Posts: 612
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')
Text Formatted Code
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')
14
18
Quote
All times are EST. The time is now 09:15 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content