Showing results for 
Search instead for 
Did you mean: 


Posts: 6
Registered: 14-02-2008


I am thinking of useing phplist with our google apps gmail account
Wondering if there is a guide on how to install phplist on
(I have found the settings to make it work with gmail)
cp:red Case dropped on title, all CAPS is rude. link:rules mod:end
Posts: 286
Registered: 04-08-2007


Hello there,
This package appears to be complaint with the CCGI Service in terms of Requirements, infact the CCGI Service just about meets the requirements. Smiley
In terms of advice on what you'll need:
Get WinSCP
(Get Notepad 2)
Installing the software listed will help save some hair pulling.
Manual Install
Thanks to PlusNet for having a script which saves considerable amounts of typing...
which will be used later to set file permissions for the PHP Scripts to function.
I would lay it out the directories different to how the Package extracts but I'll show that on the way.
WinSCP/PuTTY will help by giving us Full Paths which will be needed to run one of the files.

1. Create a Temporary directory - call it something like: Upload - in your "My Documents" or where ever suites.

2. Extract the Archive (Tar/Zip) to anywhere (Not into the Upload directory)

3. public_html/* to your temporary Upload directory
The reason it is packed in this way is that in most cases...
Apache would have been installed and configured such that,
each user on the System can have a subdirectory of their own in /home/username/public_html/.
This would alter the look of URLs though. The Sub-dommaining wouldn't be in place, there would be virtual sub-directories.
Instead of it would look like

This next part is optional...
but it appears to supply a Script which will allow a minimal Text-Based Service, allowing you to administer PHPList from the Command Line, if the Website is not displaying on the front end. I don't think it is needed.
To get this to work will require changing some text in the script with a Text Editor.
4. Alter the phplist file in the extracted directory bin/phplist, with a text editor of your choise
(Editors like Notepad 2 will help as they have Syntax Highlighting).
You'll need to get WinSCP Connected to your CCGI Space for this next part to work.
4.i. Create a New Session on the Main Window.
Host [ /] | Port [22]
Username [Portal Username] | Password [Portal Password]
Leave the Protocol as S-FTP.
4.ii.Click, Save, and name it what you like.
4.iii. Click on the Session created and click Login at the bottom. You'll be asked to allow the SSH Key.
Now, you can do this either of two ways.
We are trying to find the path for the root of our (your) Webspace.
It's technically already there at the top of the Right Hand Pane showing the Remote Host ( Server ).
Format: /share/storage/XX/UU/Username
You can save the hastle of typing it out by: Right Clicking -> "Copy Path to Clipboard".
You can also do this with PuTTY, which will give you a slightly different path which is shorter.
4.iv. Once connected, click the menu name Commands -> Open in PuTTY
You'll see a new Window appear and it will prompt you to allow the SSH Key again.
4.v. Then you'll be greeted with some Text and a Command Line (username@cshellXX:~$)
Type in: pwd
username@cshellXX:~$ pwd
To print the current working directory, this is the ROOT of your Webspace on the Server.
(Format: /files/homeX/Username/) we have to replace our paths:
Where /home/website/public_html/ or /home/website/ should be /files/homeX/Username/ (/share/storeage/XX/UU/Username)

# ...
# in commandline mode, access is restricted to users who are listed in the config file
# check README.commandline for more info
# identify the config file for your installation
export CONFIG /files/homeX/Username/lists/config/config.php
# run the PHPlist index file with all parameters passed to this script
/usr/local/bin/php /files/homeX/Username/lists/admin/index.php $*

4.vii.Saving it to the bin folder in your temporary Upload folder.
( Note the last line IS significantly different as PHP is installed to /usr/local/bin instead of /usr/bin )

5. Copy the phplist.sql file to the temporary Upload folder.

6. Now your Upload directory should look like this:
6.i.So, Open up WinSCP (possibly have to re-connect)
You have two Panes, the left hand is local the right hand is remote.
6.ii. Navigate on the Left Pane to your Temporay Upload folder.
Once you are there, select all the files and drag them to the Right hand Pane.
This will be slower than FTP, I've foun S-FTP more reliable.
You can use WinSCP in FTP insted of S-FTP (just create another Session Smiley)
This may take 5/10 minutes, so go make a mug of Brew Smiley
6.iii. Once this is done, open up PuTTY (again) and login. Once you're there
Type in: -r
username@cshellXX:~$ -r
6.iiii. Now we need to just apply the MySQL Database Tables to the Database.
Type in: mysql -h humbug/rumpus username_pn -u username -ppassword < phplist.sql
You can alternatively do this step via the PHMyAdmin Pages @
username@cshellXX:~$ mysql username_pn -u username -ppassword < phplist.sql

That should do the trick I think.
Short of building an Automated Version in Shell Script, it doesn't get any easier.
And you'd still need to know and understand all the steps in the Script for Debugging and possible Errors.
Posts: 6
Registered: 14-02-2008


Thanks for you help. I will try that when i have enough time.
To be honest i am more comfortable with hostgator , I havent yet got used to plusnets ccgi settup.
Also for some reason i have had troubles with permissions in the past.
I didnt know about i'll take a closer look at this script.