Category Archives: IT

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

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

Email error

Could not connect to smtp host : 111 : Connection refused

Errno 2: stream_socket_client(): unable to connect to tls:// (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://

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

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


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

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.

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
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


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.


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:
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.

How to configure Apache to run Python on Mac (iOS)

Step 1: configure httpd.conf


<Directory "/Applications/XAMPP/xamppfiles/cgi-bin">
    AllowOverride None
    Options None
    Require all granted


<Directory "/Applications/XAMPP/xamppfiles/cgi-bin"> 
    AddHandler cgi-script .cgi .py
    AllowOverride All
    Options +Indexes +FollowSymLinks +ExecCGI
    Order allow,deny 
    Allow from all 
    Require all granted 

If no “Require all granted”, it will show “Access Forbidden” when you visit your file on browser.

Step 2: put your python file e.g. in the folder cgi-bin

Example is as below:


print "Content-type: text/html\n"

print "Hello, world!"

use sudo chmod 755 to make it executable.

Step 3: then go to browser, type “http://localhost/cgi-bin/”, you will see “Hello World”.

Please don’t forget “Content-type: text/html\n”, otherwise it will show:

Server error!

The server encountered an internal error and was unable to complete your request.

Error message:
malformed header from script ‘’: Bad header: Hello, world!

In addition, you may need to change the permission of cgi-bin and

The commands are: sudo chmod 775 cgi-bin

and: sudo chmod 755 cgi-bin/