I just downloaded and installed newest PHP and MySQL. They are PHP 5 and MySQL 5 too. It appears that the PHP and MySQL run well, but has problem to talk each others.
The PHP can only access MySQL through newer mysqli_ set functions ( i serial), not old mysql_ serial function. Fox ex. If I put "mysqli_connect("localhost", "root", "root_password")" on PHP page, it works. But it doesn't work for mysql_connect (no i).
Since "install.php" file is based on old mysql_ (no i) functions, I can not open the SMF installation page. I got error massege said "The installer was unable to detect MySQL support in PHP".
It looks to me that the new MySQL database doesn't support the old mysql_ functions, or the database client software (.dll) doesn't support. Or maybe I didn't configure the PHP correctly. So here are couple questions:
(1) Do I have to run new "i" serial functions (mysqli_) at PHP for MySQL 5 to install SMF?
The host is Windows 2003 server with IIS 6.0. I add "php5isapi.dll" as .php file handler at ISAPI Filter. The PHP looks work. I can run "phpinfo()" to get php configuration.
(2) Are there a new php installation pages, or patches which run "i" serial mysqli_ functions? That will save me lot of time.
I am new to php and MySQL though I have years of experiences on ASP.NET and MS SQL. I already hang at SMF installation for few days (not easy). Thanks ahead for any help.
Here is the MySQL settings from running "phpinfo()":
mssql
MSSQL Support enabled
Active Persistent Links 0
Active Links 0
Library version 7.0
Directive Local Value Master Value
mssql.allow_persistent On On
mssql.batchsize 0 0
mssql.compatability_mode Off Off
mssql.connect_timeout 5 5
mssql.datetimeconvert On On
mssql.max_links Unlimited Unlimited
mssql.max_persistent Unlimited Unlimited
mssql.max_procs Unlimited Unlimited
mssql.min_error_severity 10 10
mssql.min_message_severity 10 10
mssql.secure_connection Off Off
mssql.textlimit Server default Server default
mssql.textsize Server default Server default
mssql.timeout 60 60
---------------------------------------------
mysqli
MysqlI Support enabled
Client API library version 5.0.45
Client API header version 5.0.45
MYSQLI_SOCKET /tmp/mysql.sock
Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off
SMF doesn't support the mysqli library currently.
Please read the PHP documentation, there is information on how to enable the mysql library on Windows.
Same problem here. I'm glad I found this post. We are running almost identical set-ups and I've been damn near beating my head against the wall trying to get this to work so I can get my site off of WAMP server and on to a real set-up.
Anyone have any updates on this issue?
Added info/links?
Anything?
I guess I was too subtle with my last post.
Read the info here (http://www.php.net/manual/en/ref.mysql.php)
Look for the header "Installation on Windows Systems" then "PHP 5+" right under it. It tells you in very plain language how to enable the mysql extension on Windows.
If you are using PHP4 (not recommended as it is EOL), you don't need to worry as the extension is built-in.
LainaaI guess I was too subtle with my last post
No, not really. I'm thankful to have found it.
I was just looking for any updates on the issue, or added info that wasn't known when the topic was first opened.
What I did find on my own after reading this is that we can use PHP5 with MySQL 4.1 with SMF 1.1.4 and it all installs fairly easy.
On IIS6, the IUSER internet user account permissions seem to always be the thing that halts the install. One needs to give read and
write permissions to the IUSER account for the SMF folders in wwwroot.
Same issue if you're gonna take it a step further and add in TinyPortal. Permissions halts the install.
I thank you for the small tip in your first reply. I was really just being lazy and looking for someone to tell me what to use instead of having to do more reading. At the point that I had posted here, I had been reading stuff for over 6 hours and had about enough reading for one day. I just needed someone to say hey dumb@$$, just use MySQL 4.1 :P
Oh, MySQL GUI Tools for 5.0 seems to work well with MySQL 4.1. I've used it to create a back-up of my live forum, then used the restore feature to upload that data to the test servers MySQL database.
=================================================
...and here's a cheat sheet for anyone who's looking for the easy info and links like I was.
All links lead you directly to where to download the product needed. Some sites require that you sign in first.
- Windows Small Business Server 2003 (http://technet.microsoft.com/en-us/bb738394.aspx) (use a minimum install w/ IIS6 enabled only)
- PHP 5.2.5 (http://us2.php.net/get/php-5.2.5-Win32.zip/from/a/mirror) (manual install, the installer package does not work)
- MySQL 4.1 (http://dev.mysql.com/downloads/mysql/4.1.html) (version 5 does not work yet with SMF 1.1.4)
- MySQL Administrator for 5.0 (http://dev.mysql.com/downloads/gui-tools/5.0.html) (part of MySQL GUI Tools)
- SMF 1.1.4 (http://www.simplemachines.org/download/)
- TinyPortal 0.9.8 (http://www.tinyportal.net/index.php?action=tpmod;dl=item745) (you must be a signed in member to download)
The PHP install tutorial link I posted below is vital to getting php to work in less than 5 minutes. There is only one error in the tutorial, that is where it says to type PHP as the extention. The proper instruction it to type .php (the dot is needed).
Here's the link: http://www.tjitjing.com/blog/2006/05/php5-with-iis6-on-windows-server-2003.html (http://www.tjitjing.com/blog/2006/05/php5-with-iis6-on-windows-server-2003.html)
Follow the extra steps for MySQL preparation and MySQL 4.1 will install and connect flawlessly if you do it correctly.
===============================================
...and that's what I got. It took me days to figure it all out, but I have it up and running and it works... so far :P
You can use Windows Server 2003 instead, I just chose to use Windows Small Business Server 2003 because of price, and because it comes with Exchange Server for email support, Frontpage 2003, and Office Outlook 2003.
I've yet to configure Exchange, so my input on that is non-existant.
It you chose to not use Exchange Server for email, there is another program that I know works and it's open source. It's called hMailServer. I don't have a link ready to give out, just google it and it'll be on the first page of the results.
It works well and has a good GUI to it.
PHP5 works quite fine with MySQL 5 and SMF 1.1.4 as long as you follow the instructions on the documentation I linked to.
Personally, I really dislike Exchange (mostly over how it breaks standards and its crippled abilities when you use anything but Microsoft's designated client), but it is a nice solution for groupware if you don't want to play with something like Zimbra. I highly suggest having an incoming/outgoing gateway running something like Postfix so Exchange doesn't touch the outside world. It helps a ton when configured that way (no weird queue backlogs from 45x errors).
Lainaus käyttäjältä: Motoko-chan - tammikuu 27, 2008, 01:07:02 IPPHP5 works quite fine with MySQL 5 and SMF 1.1.4 as long as you follow the instructions on the documentation I linked to.
I've had MySQL5 connected to PHP5, but for some reason SMF didn't think so and wouldn't let me install.
So after a day of screwing with it, I found this topic here and went "Oh, that's what's wrong".
I uninstalled MySQL5, replaced it with MySQL4.1, all without modifying PHP or any of it's files, SMF let me install straight away.
Then I had the issue of file permissions, but that was solved within minutes.
LainaaPersonally, I really dislike Exchange (mostly over how it breaks standards and its crippled abilities when you use anything but Microsoft's designated client), but it is a nice solution for groupware if you don't want to play with something like Zimbra. I highly suggest having an incoming/outgoing gateway running something like Postfix so Exchange doesn't touch the outside world. It helps a ton when configured that way (no weird queue backlogs from 45 x errors).
I'm still new to email servers, so some of that is still an unknown to me, but thanks for the warning and the tip. I'll be using those tips here in a few weeks when I dig into the email part of the site on test server.
I'll go check out Zimbra in a few.