Installation issue - latest files

[Supergran]

Not sure if this is related to #139 but I've been setting up a clean install to test a module and thought I'd use the latest files as some of my previous issues have been mentioned in the work you're doing. I'm using PHP 7.06 MySql 5.5.49 on Mamp Pro and have never had an installation problem before.
Installation goes well until I try to add the admin user and password. When submitting that it times out with a fatal error:
Maximum execution time of 60 seconds exceeded in E:\vhosts\xxxxxxxxx\htdocs\class\database\mysqldatabase.php on line 66
Call Stack

# Time Memory Function Location

1 0.2009 376128 {main}( ) ...\page_tablesfill.php:0
2 7.3579 1622408 make_data( ) ...\page_tablesfill.php:70
3 59.6227 1787488 Db_manager->insert( ) ...\makedata.php:111
4 59.6227 1787488 XoopsMySQLDatabase->connect( ) ...\dbmanager.php:246

The database connection has been made as the tables have been created in the database.
Hope that's helpful
Jan

[mambax7]

I just installed the latest files on my WAMP with PHP 7.08, MySQL 5.7.13, and had no problems.

Can you check your error logs for PHP and MySQL and see if you find anything there?

[Supergran]

HI - No errors in MySQL log. The following in PHP log:
[17-Jul-2016 18:09:05 Etc/GMT-12] PHP Fatal error: Maximum execution time of 60 seconds exceeded in E:\vhosts\pedigreefinala\htdocs\class\database\mysqldatabase.php on line 66
[17-Jul-2016 18:09:05 Etc/GMT-12] PHP Stack trace:
[17-Jul-2016 18:09:05 Etc/GMT-12] PHP 1. {main}() E:\vhosts\pedigreefinala\htdocs\install\page_tablesfill.php:0
[17-Jul-2016 18:09:05 Etc/GMT-12] PHP 2. make_data() E:\vhosts\pedigreefinala\htdocs\install\page_tablesfill.php:70
[17-Jul-2016 18:09:05 Etc/GMT-12] PHP 3. Db_manager->insert() E:\vhosts\pedigreefinala\htdocs\install\include\makedata.php:111
[17-Jul-2016 18:09:05 Etc/GMT-12] PHP 4. XoopsMySQLDatabase->connect() E:\vhosts\pedigreefinala\htdocs\install\class\dbmanager.php:246

Which is pretty much as before - fail is at step 9/14 on ...install/page_siteinit.php
Error is reported on a blank page at ..page_tablesfill.php as you probably got from the error report.

[geekwright]

This sounds familiar. Try changing the MySQL host to 127.0.0.1 instead of localhost. This is an issue in recent Windows versions with IPv6 support and MySQL.

[mambax7]

She is on Mac, so this is actually a good link for her:
http://stackoverflow.com/questions/3699454/should-a-mamp-return-1-as-ip-on-localhost
But I had also issues on my WAMP on Windows in the past, and this link above helped to solve it.
What I had to do was to change in Apache Config file to:
Listen 127.0.0.1:80

[geekwright]

E:\chosts\… doesn't sound Mac like.

The base.issue is MySQL only binds to 1 address, but localhost can resolve to ::1 and 127.0.0.1. If you bind to the wrong one, you get a lengthy timeout each time you talk to the database.

[mambax7]

You're right - I thought that they have Mamp Pro only on Macs, but I see that they also have a Window version.

[Supergran]

Thank you both... yes it's windows...sounds as if this is my problem rather than with xoops. Interestingly Richard I used to use Wamp and had trouble with it on windows 10 so opted for Mamp Pro and that has worked fine until now and yes I'm getting the lengthy timeout. The GUI won't let me change the localhost...
i don't want to eat up your time as this clearly isn't an Xoops problem but if you have any ideas I'd be grateful. I've been googling for a couple of hours but I've not been able to find anything for the windows version. Strange I've not had a problem before. I've several hosts running various xoops set ups.
Again thanks. You've already helped.

[mambax7]

I've been using WAMP for the last 10 years or so, and had no problems that couldn't be solved.
For your issue, just follow the directions from the link I gave you above:

Find where your apache is 'listen'-ing to the ips/ports, etc... Typically this will be a line looking like this

Listen 80

Make it look like this:

Listen 127.0.0.1:80

Resave it. Restart Apache. Voila!

On my WAMP Apache, it is in:

/conf/httpd.conf

Just look for this section, and then change the "Listen" as follows:

#
# Listen: Allows you to bind Apache to specific IP addresses and/or
# ports, instead of the default. See also the <VirtualHost>
# directive.
#
# Change this to Listen on specific IP addresses as shown below to
# prevent Apache from glomming onto all bound IP addresses.
#
Listen 127.0.0.1:80

[geekwright]

Sorry I wasn't clear. The change is in the XOOPS settings. Just enter 127.0.0.1 as the MySQL host during the install.

[Supergran]

Doh!" Sorry Richard, so wrapped up in Mamp I'd missed that completely. Thank you both That's worked...there's some tables that data hasn't been written to for some reason but I'm up and running. Thanks for your time. I'm very grateful.