SMF and MySQL on Windows 2008 server.

[Aucun]

I've been trying to install SMF on a Windows 2008 server running Apache (Newest Version), PHP (Newest Version), and MySQL (Newest Version). I have made a database in MySQL along with a user who has all permissions to the database. I loaded the website using the 127.0.0.1 address and tried to complete the /install.php page but I keep getting: No connection could be made because the target machine actively refused it.

I'm not sure how this is possible as just a day ago I was getting an error saying it was a connection probably or invalid username/password. I have set MySQL to ignore the firewall by adding it to the program list.

[CapadY]

Make a little file called phpinfo.php with the next content, put it in the forum root folder and run it in your webbrowser using localhost/phpinfo.php

Koodi [Valitse] Laajenna


<?php
phpinfo();
?>


Running this file will at least give you the information if PHP and MySQL are running properly.

[Aucun]

System  Windows NT WIN-VJDHKIM8LFO 6.1 build 7600 (Unknow Windows version Standard Edition) i586 
Build Date  Mar 17 2011 10:34:15 
Compiler  MSVC9 (Visual C++ 2008) 
Architecture  x86 
Configure Command  cscript /nologo configure.js "--enable-snapshot-build" "--disable-isapi" "--enable-debug-pack" "--disable-isapi" "--without-mssql" "--without-pdo-mssql" "--without-pi3web" "--with-pdo-oci=D:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8=D:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8-11g=D:\php-sdk\oracle\instantclient11\sdk,shared" "--enable-object-out-dir=../obj/" "--enable-com-dotnet" "--with-mcrypt=static" 
Server API  Apache 2.0 Handler 
Virtual Directory Support  enabled 
Configuration File (php.ini) Path  C:\Windows 
Loaded Configuration File  C:\Program Files (x86)\PHP\php.ini 
Scan this dir for additional .ini files  (none) 
Additional .ini files parsed  (none) 
PHP API  20090626 
PHP Extension  20090626 
Zend Extension  220090626 
Zend Extension Build  API220090626,TS,VC9 
PHP Extension Build  API20090626,TS,VC9 
Debug Build  no 
Thread Safety  enabled 
Zend Memory Manager  enabled 
Zend Multibyte Support  disabled 
IPv6 Support  enabled 
Registered PHP Streams  php, file, glob, data, http, ftp, zip, compress.zlib, compress.bzip2, https, ftps, phar 
Registered Stream Socket Transports  tcp, udp, ssl, sslv3, sslv2, tls 
Registered Stream Filters  convert.iconv.*, mcrypt.*, mdecrypt.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, zlib.*, bzip2.* 

[CapadY]

As far as I can see your MySQL isn't running

[Aucun]

I'm not sure how it was turned off, I had it running and the server did not restart. Anyways, how would I go about turning back on MySQL?

[CapadY]

Windows - Start - Configuration - System management - component services I think

[ziycon]

I'm not sure how it was turned off, I had it running and the server did not restart. Anyways, how would I go about turning back on MySQL?

- Start > Run
- 'services.msc'
- Click on the mySQL service name and now click the start option thats available, you will need administrative privileges.

[Aucun]

Ok, I got the MySQL running again but now when I try the install.php page I get this:

Line #563: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) /*!40102 NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP */,' at line 3

[CapadY]

I think there is a problem with the newest version of MySQL, is it possible to go back a version ?

By the way, are you sure your database is empty after your first attemps to install ?

[Aucun]

I can go back a few versions yes, do you know what one last worked properly? Also, I remade the database a few times thinking the same thing but it still gave me the error.

[Aleksi "Lex" Kilpinen]

Hi Aucun, Any updates to this?

[Cop999]

Hi, every body. I have same problem as Aucum. But on  Windows Server 2003.
Same result:
#563: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) /*!40102 NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP */,' at line 3
Who Know in which file I can see this error?

[vbgamer45]

File is install_2-0.mysql.sql

[Cop999]

Today I tried again instalation with webinstaller. And I saw that now avalable only version 2.0. This version installed without any problem. Big Thanks for all people and for support SMF.

[Aucun]

I got the right version of MySQL running and the database worked when using install.php, but now I'm having another problem. When I load the site from the computer it's running from, the default homepage is index.php and it loads fine. When I load the page from another computer, being my own not the vps, it doesn't load the page right, almost like the php isn't loading properly and making it look really basic.

[Illori]

sounds like your paths to the themes are incorrect. without having a link to view your forum we can only guess what the issue is.

[Aucun]

If I link would help you, I will provide one. http://  hxxp:aogaming.dyndns.info/index.php [nonactive]

[vbgamer45]

All your paths point to 127.0.0.1 instead of aogaming.dyndns.info get the repair settings tool to fix

[Aucun]

Where do I get this repair tool? And what is it?

[vbgamer45]

What is repair_settings.php?