Email setting to relay emails for phpBB 3 on godaddy web hosting [solved]

1, Try gmail, it shows on Maintenance > Error log:

Email error
» EMAIL/SMTP
/adm/index.php

Could not connect to smtp host : 111 : Connection refused

Errno 2: stream_socket_client(): unable to connect to tls://smtp.gmail.com:587 (Connection refused) at [ROOT]/includes/functions_messenger.php line 1188

2, Use localhost as SMTP server address and protocol as then Phpbb 3 manual said. It shows:

General Error

SQL ERROR [ mysqli ]

MySQL server has gone away [2006]

3, Then I googled again and again. It’s said that gmail’s SMTP is blocked by godaddy. I registered one email on godaddy and in the configuration file of the email, I find the name of STMP.

Finally, the configuration as below works:

General setting:

Contact email address: your godaddy email address

From email address: your godaddy email address

SMTP settings:

Use SMTP server for email: Yes

SMTP server address and protocol: tls://yours.prod.phx3.secureserver.net

SMTP server port: 465

Authentication method for SMTP: login

SMTP username: your go daddy email address

SMTP password: your email password

Verify SSL certificate: Yes

Verify SMTP peer name: Yes

Allow self-signed SSL certificates: No

Note of Node.js

1, Error: Cannot find module ‘mysql’.

Option #1: The development environment is Netbeans on Macbook. On the terminal, enter the folder of the project and run the command: npm install mysql. Then it shows another error as 2#.

Option #2: Install in the default ‘usr/local/bin/node_modules’ path and then use ‘ln -s’ to build a symbolic link.

2, Error: connect ECONNREFUSED 127.0.0.1:3306

On the terminal, use the command ‘find / -type s’, find :

/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock

Add it to the configuration:

var con = mysql.createConnection({
host: “localhost”,
user: “***”,
database : ‘***’,
password: ‘***’,
socketPath: ‘/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock’
});

Then, it is connected successfully to the MySQL database.

Upgrade phpBB 3.0 to phpBB 3.2.5

The link below is the official introduction from phpBB.com

https://www.phpbb.com/support/docs/en/3.2/ug/upgradeguide/upgrade3/

Here I listed what problem I met and how I solved:

1, when use stk to clear the database, need to set maximum_time_out to large if it is 30. I set to 60, it works file.

2, After copied the files of phpBB 3.2.5 to the root folder and press ‘http://xxx/install’, it shows no mySQL_connection.

Since PHP 7.0, mySQL_connection function was removed. If it is on PHP7.0, change database driver from ‘mysql’ to ‘mysqli’ on the config.php file.

If the web server is on your computer, you need to change a few folders permission to 777. Those folders are files, cache, store. In phpBB 3.0, no store folder, build one.

3, After upgraded, couldn’t find permission page.

Clear the cache. Open ACP, on the default page, click ‘run now’ next ‘Purge cache’ to clear cache.

For me, it showed another error:

[phpBB Debug] PHP Warning: in file [ROOT]/vendor/zendframework/zend-stdlib/src/ArrayObject.php on line 426“continue” targeting switch is equivalent to “break”. Did you mean to use “continue 2”? …..

It’s said that phpBB 3.2.5 is not compatible with php 7.3. I changed to php 7.2, it is ok then.

4, On my macbook, when I change the Edit Forum page in ACP, it shows:

This site can’t be reached. ERR_CONNECTION_RESET.

I used my smart phone, it worked well.

5, the website is flooded by spams.

At ACP, the ‘General > User registration settings’ page, change the general setting to stop it. E.g.: New member post limit.

Intall phpBB 3.2 on Mac

Open terminal

cd / — enter the root directory

pwd — show the current

cd /Applications/XAMPP/xamppfiles/htdocs/phpBB3

open the browser, and type ‘localhost/phpBB3’ on the place bar, press ‘enter’.

It goes to “localhost/phpBB3/install/app”, and open a webpage with a ‘install’ tab.

If not change the permission, it will show:

Fatal error: Uncaught exception ‘ProxyManager\Exception\InvalidProxyDirectoryException’ with m essage ‘Provided directory

Note of users and groups on Mac

Owners and groups in the Finder and command line

On the terminal:
man dscaceutil (press ‘k’ to quit)
dscacheutil -q group -a name admin
dscacheutil -q group -a name staff
dscacheutil -q user -a name username

dscacheutil -q group -a name admin
output:
name: admin
password: *
gid: 80
users: root xx

View All users & Accounts on Mac
dscl . list /Users

Accounts start with ‘_’?

View All User Accounts, User Directories, & User GECOS Info on a Mac
dscacheutil -q user

Work note about my website on WordPress

@20190221

1, Login link: http://***.com/wp-login.php

2,  I moved my website on a online hosting server to my local server on my computer. It always went to its online website. Later I changed ‘***.com’(online url) to ‘localhost’ in the values of a few records in the option_value column of the wp_options table and and meta_value column of wp_postmeta table. It shows it’s not need to change all of them. It works fine now. 

3, If it’s alway redirected to dashboard, check config.php.

Add the two lines or change related lines:

define(‘WP_HOME’, ‘http://localhost/yourwebsite’);
define(‘WP_SITEURL’, ‘http://localhost/yourwebsite’);

Then visit http://localhost/yourwebsite/wp-admin.

@20190221

Try to update wordpress:
1, need ftp username and password to local XAMPP server.
It’s said on the terminal run this command as below, it will show it.
/Applications/XAMPP/xamppfiles/xampp security
But it shows: You need to be root to perform this action.
2, Go to Mac Apple menu, follow an instruction on apple website, to active su (super user) and set a password.
3, go back to the terminal, get ftp user and password.
4, the hostname is ‘localhost’; put the line as below in the wp-config.php as a posting on the website said:
define(‘FS_METHOD’,’direct’);
5, the download is ok, but it’s said: Could not create directory.
This command works:
chown -R ftp-user-name:ftp-user-name /Applications/XAMPP/xamppfiles/htdocs/iblog

In addition, I tried “chmod 777” first and it didn’t work.

chmod -R 777 ...  --- recursively

The ‘ls -l’ command is useful to see the details of folder’s right assignment.