Posts in category: Web Development

Run httpd with

/etc/rc.d/init.d/httpd start

Create a test file /var/www/html/test.php containing the following line

Use a web browser to browse to http://localhost/test.php

If PHP is working, this should display your settings.

Sincxe RedHat7.2 on uses PostgreSQL instead of MySQL you will have to change a number of settings.

Note in particular that the default PHP is not installed with MySQL support.

PHP-Nuke Web Portal System

Need a working Linux box with Apache (www.apache.org)

PHP 4.0.4 or better with mod_php Apache module (www.php.net)

mySQL database server (www.mysql.com)

Run /usr/bin/mysql_install_db to install initial MySql tables. This is safe to do at any time.

Set a password for the MySQL root user with

mysqladmin -u root -p password 'new-password'

mysqladmin -u root -h localhost.localdomain -p password 'new-password'

Test installation with 

cd sql-bench ; run-all-tests

However this is not installed with the RedHat7.2 standard rpms. MySQL commands are in /usr/bin

mysqladmin version

mysqladmin variables

To see the MySQL databases

mysqlshow

mysqlshow databasename

Good instructions at http://www.camalott.com/~jtpolk/psqlrh5.html

@

@

Run mySql with

/etc/rc.d/init.d/mysqld start

Create table for PHP-NUke with

mysqladmin create nuke

Then fill the databases with

mysql nuke

NukePHP manual at http://web-dj.net/manual/

To connect to a MySQL database PHP needs MySQL extensions. These can be found in php-mysql-4.0.6-7.i386.rpm

To make it easier to administer MySQL databases, install phpMyAdmin

Access it at http://localhost/phpMyAdmin-2.3.0/

@

su - postgres  createdb nuke psql nuke 

I got a load of errors :(

So I found a version of NukePHP that supports PostgreSQL at www.bluewolverine.com

Download nuke_pg.sql

@

su - postgres  createdb nuke cat /root/nuke_pg.sql | psql nuke

 Lots of messages as it runs but no errors! Cool!

Next problem, Looking at http://localhost/test/admin.php shows lots of errors;

Warning: Supplied argument is not a valid PostgreSQL link resource in /var/www/html/test/includes/sql_layer.php on line 197

Lo ts of messages about this on the BlueWolverine forums so try their version of phpnuke. It looks like replacing my version of includes/sql_layer.php with theirs might do the job. Bit better, just a lot of errors at line 303 in sql_layer.php

Put the @ back in line 303 like the comment suggests.

$res=@pq_exec($id,$query);

Great! Now only 1 error.

Warning: Unable to connect to PostgreSQL server: connectDBStart() -- connect() failed: Connection refused Is the postmaster running (with -i) at 'localhost' and accepting connections on TCP/IP port 5432? in /var/www/html/test/includes/sql_layer.php on line 92

I added "-o -i" options to /etc/rc.d/init.d/postgresql as follows:

su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -o -i -D $PGDATA -p /usr/bin/postmaster start > /dev/null 2>&1"

Now restart Postgres and httpd

/etc/rc.d/init.d/postgresql restart
/etc/rc.d/init.d/httpd restart

Getting close, a new error:

Warning: Unable to connect to PostgreSQL server: FATAL 1: user "root" does not exist in /var/www/html/test/includes/sql_layer.php on line 92

Looks like the user is wrong in config.php. Fix it:

$dbuname="postgres";

$dbpass="";

Hmm another error:

Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/html/test/themes/NukeNews/theme.php on line 57

It looks like my Linux box (a P166 with only 80Mb ram) is too slow and PHP is timing out. Modify the max_execution_time in /etc/php.ini to a bigger value

max_execution_time=480;

 

 

RedHat has switched from MySQL to PostgreSQL which is a more advanced DB server supporting stored procedures and functions. The PostgreSQL site is at http://www.postgresql.org/

I have the following rpms on my system:

• postgresql-7.1.3-2
• postgresql-devel-7.1.3-2
• postgresql-libs-7.1.3-2
• postgresql-server-7.1.3-2
• php-pgsql-4.0.6-7

If you want to install from source try the following, but the install paths will be different.

./configure gmake su gmake install adduser postgres   mkdir /usr/local/pgsql/data   chown postgres /usr/local/pgsql/data   su - postgres   /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data   /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &   /usr/local/pgsql/bin/createdb test   /usr/local/pgsql/bin/psql test

PostgreSQL commands are installed in /usr/bin

The data directory is in /var/lib/pqsql/data

To start the server run

/etc/rc.d/init.d/postgresql start

You have to create a user before you can make a database. Checking the /etc/passwd file I found that a user called postgres already existed.

 

My domain, mortell.com, was taken over by some Asian firm. I missed the email from Network Solutions reminding me to pay the yearly fee. I must have deleted it among all the spam I get daily. I registered dmortell.com and moved my website here.

Some friends were looking for Internet Providers so I updated a survey I did back in 1997. It’s not all inclusive (there’s a LOT of ISP’s in Japan now) and it just gives costs of basic services like dial-up access, but it should give a rough comparison of some of the main providers I know of.

Last updated: 17th February 1999

This is a sample of Internet providers available in Japan.

The rates below are for standard dial-up services. Most providers offer selection of different services which may increase or reduce the costs shown below. Check each providers service pages carefully to see what’s included in each package. Some charge extra for homepage space, some charge extra for ISDN 128k access.

Consumption tax is not included.

If you don’t care what address your web pages are at, there are a number of free web page providers such as Geocities, Yahoo, Netscape, MSN and 50Megs, to name but a few. Search for more at Yahoo

If you want your web pages to be located at www.yourdomain.com, you’ll need a virtual hosting account. These tend to be more expensive, and the cost depends on the size of your site and the amount of traffic it produces. The following table lists sample rates of basic virtual hosting costs from a number of providers. They all have a selection of services with various options and limits.

Some options that might be worth paying extra for are FTP access, Telnet access, cgi scripts, Frontpage Server extensions, and if you’re thinking of starting an e-commerce site, you’ll more than likely need SSL Secure Server and SQL Database Server.

Join the Parti Community on Twics

Many of your fellow Twicsters meet in a virtual hangout called “Parti”. Parti is mouse-free and lightning-fast, so more yen stays in your pocket instead of “GUI-ing” into NTT’s. You can download all your Parti notes in one batch and read them off-line. There are many “topics” in Parti. Here we help each other find answers to questions about computing, living in Japan, good places to eat, and other pressing matters. (Sometimes we even get together for real parties.)

But first, you may be wondering “how do I get there?”

If you are connected to Twics for Web surfing, then use your Telnet client to connect to beehive.twics.com (otherwise known as 192.135.222.9). If you have ordinary dialup comms software like Crosstalk or Zterm or Microphone, then just set it to dial 03 5361 7270.

Either way, you log on with your Twics username and password (all lowercase), then choose PARTI from the menu.

Splash. You’re in! Welcome. Read the notes in your Inbox. Some instructions and a list of topics will be waiting there for you. Just keep pressing your Return or Enter key to continue. Then please join and read some notes in other topics. To join the “help” topic for example, you just type

  join "help"

To read the last 10 notes, you type

  read "help" -10

And so on.But the great thing about Parti is that once you’ve joined a few topics, everything else is automatic. The next time you visit, any new notes will be waiting in your inbox. (We’ll also reveal the yen-saving secrets of batch downloading/uploading notes instead of staying online as you read/write each one.)

But don’t worry about the details now. Just drop in and see what’s happening. You’ll soon discover why Parti is a big reason many of us choose Twics as our internet provider.

Oh yes, to quit, just type quit or q.

See you in Parti,

The Parti Community

More Information

•  Pages 1-4 through 2-8 of “The Twics User’s Guide” give more details about connecting to Twics.
•  For more help about using Parti, see the Parti Help Page
•  The Parti FAQ answers many frequently asked questions.
•  There’s lot’s of useful information and guides to Parti in the Parti Members Pages
•  See what’s happening in Parti these days with Parti News

Last updated: 3rd September 1995