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.
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
<?php
phpinfo();
?>
Running this file will at least give you the information if PHP and MySQL are running properly.
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.*
As far as I can see your MySQL isn't running
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?
Windows - Start - Configuration - System management - component services I think
Lainaus käyttäjältä: Aucun - toukokuu 18, 2011, 01:04:15 AP
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.
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
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 ?
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.
Hi Aucun, Any updates to this? :)
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?
File is install_2-0.mysql.sql
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.
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.
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.
If I link would help you, I will provide one. http:// aogaming.dyndns.info/index.php
All your paths point to 127.0.0.1 instead of aogaming.dyndns.info get the repair settings tool to fix
Where do I get this repair tool? And what is it?
What is repair_settings.php? (http://docs.simplemachines.org/index.php?topic=663.0)
Thank you very much, that fixed the problem completely. If I have anymore questions can I just post them here instead of making a new topic?
a new topic would be best.