Installing PHP and MySQL

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;

 

 

PostgreSQL

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.

 

Internet Providers in Japan

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.

Provider

Initial Fee

Monthly Fee

Usage Fee

Air Net

ï½¥5000

ï½¥3000

ï½¥10/min from 11pm to 5am

Asahi Net

ï½¥2000

ï½¥900 (up to 3 hours)

ï½¥7/min after 3 hrs

AT&T Jens

ï½¥3000

ï½¥2000

none

Bekkoame

none

ï½¥2800

none

Biglobe

ï½¥2000

ï½¥3000

ï½¥10/min

DTI

ï½¥2000

ï½¥1500 (up to 5hours)

ï½¥10/min after 5 hrs

DreamNet

ï½¥5000

ï½¥2900

none

Global Online

ï½¥5000

ï½¥3000

none

IIJ

ï½¥20000

ï½¥2000

ï½¥10/min

IFNET

ï½¥9000

ï½¥18000/year

none

IF NET

ï½¥5000

ï½¥2000 (up to 40 hours)

ï½¥10/min after 40 hrs

InfoWeb

ï½¥1000

ï½¥2000 (up to 15 hours)

ï½¥10/min after 15 hrs

JETON Network

ï½¥3000

ï½¥1800 (up to 7 hours)

ï½¥10/3 mins (after 7 hrs)

Rimnet

none

ï½¥1800 (up to 7.5 hours)

ï½¥10/3 mins (after 7.5 hrs)

Shonan

ï½¥5000

ï½¥5000

none

So-net

ï½¥2000

ï½¥2000 (up to 15 hours)

ï½¥10/3 mins (after 15 hrs)

TokyoNet

ï½¥3000

ï½¥500 (up to 2 hours)

ï½¥3/min

Twics

ï½¥5000

ï½¥2000

none

Virtual Hosting

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.

Provider Monthly
Rate
Disk
Space
Monthly
Transfer
POP3
Accounts
Advanced Web Creations $24.95      
OneStop $24.95      
Reiter Associates $19.95 50Mb 2.5Gb 10
Elosoft Canada $16.95      
AZC.COM $13.45 10Mb 1Gb  
Virtual Reality Domains $5.00
$10.00
5Mb
10Mb
   
Interstyle Communications $19.95 10Mb    
Cyber Strategies $50 45Mb 1.2Gb  
Intellisys $9.95
$14.95
5Mb
10Mb
   
Lexiconn $19.95 25Mb 500Mb  
Party

Parti on Twics

Party

Join the Parti Community on Twics

Fun

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

Internet Providers in Japan

Last updated: 3rd September 1995


 

Provider Initial Fee Monthly Fee Usage Fee
IIJ ï½¥30000 (ï½¥10000 online signup) ï½¥2000 ï½¥30/min
IFNET ï½¥9000 ï½¥18000/year none
IBM Internet Service ï½¥2000 ï½¥2000 (up to 4 hours) ï½¥6 per 36 secs
Asahi Net ï½¥3000 ï½¥1000 (up to 2 hours) ï½¥10/min after 2 hours
ASCII ï½¥1000 none ï½¥10/min
Internet WIN ï½¥5000 (students ï½¥3800) ï½¥1700 (students ï½¥1400) none
InfoWeb ï½¥5000 ï½¥2000 ï½¥20/min
HA Telecom ï½¥2500 ï½¥1500 none
NIS ï½¥3500 ï½¥900 ï½¥20/min (ï½¥10/min 9600 access)
Global Online ï½¥5000 ï½¥35000/year none
NEC C&C Internet Service ï½¥10000 ï½¥5000 ï½¥20/min
JETON Network ï½¥3000 none ï½¥10/min
Spin ï½¥50000 ï½¥150000 none
Tokyo Internet ï½¥30000 ï½¥19000 none
Twics none ï½¥5000 (up to 20 hours) none
Bekkoame ï½¥10000 ï½¥20000 none
Rimnet ï½¥8000 ï½¥1800/month ï½¥10 per 3 mins
BNN ï½¥13000 ï½¥1000 none