1
jezzamaster
RE: installing xoops on win2k with IIS and mysql

Poblem with XOOPS installation:

Hi guys, this forum is great and so is xoops. Well heres my problem i'm a newbie web designer from australia, i want to install XOOPS on my WinXP machine (or my Win2k) but i get as far in the installation when i says finally that the database could not be connected to. (What the!) MySql runs as a service and i can connect and write to a table in php but XOOPS won't connect. Any help would be great. Email me suggestions @ jeremychild@gmail.com
"When life hands you a lemon, throw it at someone!"- John Rzeznik, Goo Goo Dolls

2
davidthomas1
RE: installing xoops on win2k with IIS and mysql

Are you sure you're using the correct database variables? (host, db name, username, password)
You'll need to create MySQL user with admin priviledges and use that user when installing XOOPS.
みんなちがってみんないい。

XOOPS 2.0.13.2

3
jezzamaster
RE: installing xoops on win2k with IIS and mysql

i am:
localhost - server name

xoopsuser - db user name
xoops - db pwd
xoops - db

I'm confused why it doesn't connect!
"When life hands you a lemon, throw it at someone!"- John Rzeznik, Goo Goo Dolls

4
Gaufres
RE: installing xoops on win2k with IIS and mysql
  • 2005/7/28 5:10

  • Gaufres

  • Just popping in

  • Posts: 2

  • Since: 2005/7/28


みんなちがってみんないい。

davidthomas1, do you know what it means...??

5
jctsup1
RE: installing xoops on win2k with IIS and mysql
  • 2005/7/28 6:17

  • jctsup1

  • Not too shy to talk

  • Posts: 146

  • Since: 2002/5/23


My guess is that you are using MySql 4.1.x or greater. The newer versions of MySql store passwords with a more complex hashing algorithim.

Quote:
An issue that has come to light is the issue of enhanced security in MySQL 4.1.11 where plain text passwords have been scrapped in favour of their 48-bit MD5 hash value that is used for authentication to the MySQL server from the web browser. You can read about this more fully in this link titled 'Client does not support authentication protocol' :

http://dev.mysql.com/doc/mysql/en/old-client.html
Jeffrey C. Tindillier, CIW
Microsoft MVP - IIS
--------------------------------------------
IIS Tips, Tricks & Resources
http://www.iis-resources.com

6
davidthomas1
RE: installing xoops on win2k with IIS and mysql

Gaufres:

Hi there. I'm actually a kiwi myself! living in Japan...

my sig:

みんなちがってみんないい。

or :

minna chigatte minna ii.

Is from a piece by the Japanese poet - Kaneko Misuzu.

It roughly translates to :

Everyone is different, everyone is good.
みんなちがってみんないい。

XOOPS 2.0.13.2

7
Gaufres
RE: installing xoops on win2k with IIS and mysql
  • 2005/7/31 22:12

  • Gaufres

  • Just popping in

  • Posts: 2

  • Since: 2005/7/28


davidthomas1

true, i'm actually japanese living in the Kiwi Land.
how nice selection it is!

8
Peekay
RE: installing xoops on win2k with IIS and mysql
  • 2005/7/31 22:36

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


One thing you might want to check is that the session path exists. My PHP 4.3.7 ini file specifies:
session.save_path C:PHPsessiondata

But the PHP install files didn't include a sessiondata folder, so I had to create it.

Plenty of room for CODE now I see.
A thread is for life. Not just for Christmas.

9
jezzamaster
RE: installing xoops on win2k with IIS and mysql

Thanks guys, i'm really enjoying xoops. So what i did is setup iis as port 88. and apache i installed and thats my defualt webserver. apache works better and can communicate with the damn database.
"When life hands you a lemon, throw it at someone!"- John Rzeznik, Goo Goo Dolls

10
brash
Re: RE: installing xoops on win2k with IIS and mysql
  • 2005/8/4 4:24

  • brash

  • Friend of XOOPS

  • Posts: 2206

  • Since: 2003/4/10


It's NOT IIS, there are lot of people who are, and have been using XOOPS on IIS for many years. Two things to check;

1) See jctsup1's post above to solve the MySQL authentication issue.


2) If you are using PHP 5, then you must load the MySQL extension in php.ini. Previous versions of IIS loaded the MySQL extension for you, but PHP 5 is different. Open php.ini and look for;
Quote:

;extension=php_mysql.dll

then change it to
Quote:

extension=php_mysql.dll

Save php.ini and then restart IIS and I would be pretty confident that XOOPS will then connect to your database.
IT Headquarters
Innovative IT Solutions

Login

Who's Online

245 user(s) are online (152 user(s) are browsing Support Forums)


Members: 0


Guests: 245


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits