ltwCalendar
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers ForumsProjectsltwCalendar

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
  #1  
Old March 23rd, 2006, 01:31 AM
MitchShiver MitchShiver is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 2 MitchShiver User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
More problems with install

I have seen many instances of this problem in this forum, which is why I really tried to do my homework before coming in with the same problem. My connection to MySQL fails when trying to install ltwCalendar. Below is the IE output when the failure happens, along with some code I added to the script to show that I have updated the ltw_config.php file properly. Below that is the mySQL window output of me logging in successfully using those same parameters. I am using Windows XP, PHP v4.4.2, and ltwCalendar v4.0. Other than the required changes to ltw_config.php, I have made no other changes to the ltwCalendar scripts. Any help is greatly appreciated...

IE OUTPUT showing the failure from webpage:
ltwCalendar Installer (v4.0)
$this->db_server: localhost
$this->db_name: test
$this->db_user: ltwuser
$this->db_pass: ltwpass
Error: Connection to MySQL server localhost failed.
$this->db_server: localhost
$this->db_name: test
$this->db_user: ltwuser
$this->db_pass: ltwpass
Error: Connection to MySQL server localhost failed.
$this->db_server: localhost
$this->db_name: test
$this->db_user: ltwuser
$this->db_pass: ltwpass
Error: Connection to MySQL server localhost failed.
Getting a list of tables from the database.

Warning: mysql_query(): supplied argument is not a valid
MySQL-Link resource in
c:inetpubwwwrootprivateltw_classes.php on line 629
Error: A problem was encountered while executing this query.
$query
--------------------------------------------------------------
------------------
show tables
Error: Fatal db Error.

MySQL Window Output showing success from MySQL prompt:
Crogram FilesMySQLMySQL Server 5.0bin>mysql -h
localhost -u ltwuser -pltwpass
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 370 to server version: 5.0.19-nt

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> use test
Database changed
mysql> show tables;
Empty set (0.00 sec)

Reply With Quote
  #2  
Old March 23rd, 2006, 03:10 AM
mootinator mootinator is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 76 mootinator User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
RE: More problems with install

I'm going to venture a guess based on based on what you've described that the issue you are having is what is referred to in the article here:


Client does not support authentication protocol


You likely won't see that actual error message unless you go into ltw_classes.php, and on lines 601 and 603 remove the '@' sign.

(The lines I'm referring to begin "this->dbh=@mysql...")

Reply With Quote
  #3  
Old March 23rd, 2006, 04:24 PM
Anonymous Anonymous is offline
Registered User
Codewalkers God 35th Plane (22000 - 22499 posts)
 
Join Date: Apr 2007
Posts: 22,309 Anonymous User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 24
RE: More problems with install

BINGO! Thanks, worked great....

Reply With Quote
  #4  
Old March 23rd, 2006, 05:40 PM
MitchShiver MitchShiver is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 2 MitchShiver User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
RE: More problems with install


Reply With Quote
Reply

Viewing: Codewalkers ForumsProjectsltwCalendar > More problems with install


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway
Stay green...Green IT