Teru's blog

cmscart

found cmscart (http://www.cmscart.org).

following install.txt, at the terminal, installed mysql

> sudo apt-get install mysql-server

specifying a password for root on the way.

unzip the downloaded file. moved the file at /var/www.

> sudo chown -R www-data:www-data /var/www/cmscart104

>mysql -u root -p
mysql>create database cmscart;
mysql> use cmscart;

mysql> source /var/www/cmscart104/cmscart/sql/mysql/cmscart.sql; Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)admin/admintemplates.php?SiteName=mars

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

mysql>\q

edit config.php

$dbuser = "root"; 
$dbpass = "********";  > 
> 
> 
> (read on...)

edit /etc/apache2/sites-available/default add

AddType application/x-httpd-php .php
		DirectoryIndex index.php

save it as cmscart

> sudo a2ensite cmscart
> sudo /etc/init.d/apache2 restart

access on browser http://localhost/admin/adminsites.php ugrrrrr... doesn't work

edited admin/includes/Zip.php

//Excluded due to minimal code need
  // require_once 'PEAR.php';

  //Creates OS Constants

     if (substr(PHP_OS, 0, 3) == 'WIN') {
       //define('OS_WINDOWS', true);
       //define('OS_UNIX',    false);
       //define('PEAR_OS',    'Windows');
       OS_WINDOWS=true;
       OS_UNIX=false;
       PEAR_OS='Windows';
   } else {
       //define('OS_WINDOWS', false);
       //define('OS_UNIX',    true);
       //define('PEAR_OS',    'Unix'); // blatant assumption
	OS_WINDOWS=falst;
       OS_UNIX=true;
       PEAR_OS='Unix';

needed

> sudo apt-get install php5-mysql

too many places to admust. giving up.

ezPublish 3

trying to make webdav to work on ezPublish by following the instructions here.

before that, need to make webdav available on apache. see here, for example.

did

> sudo a2enmod dav
> sudo a2enmod dav-fs
> sudo a2enmod dasv-lock
> sudo /etc/init.d/apache2 restart

The effort to realize webdav is suspended here for a while.

ezPublish 2

There's an instruction to virtualize the URL by setting up Apache configuration to run ezPublish here.

Tried to follow what's written there with an example, and this page.

The section for overriding siteaccess method is skipped since it's done in the setting up wizard.

Below is the Apache configuration modified to meet my needs.

NameVirtualHost *:80
<VirtualHost *:80>
	ServerAdmin webmaster@localhost

	DocumentRoot /var/www
	AcceptPathInfo On

	<Directory />
		Options FollowSymLinks
		AllowOverride None
	</Directory>
	<Directory /var/www/ >
		AddType application/x-httpd-php .php
		DirectoryIndex index.php
		Options FollowSymLinks
		AllowOverride None
		Order allow,deny
		allow from all
	</Directory>

    <IfModule mod_php5.c>
        php_admin_flag safe_mode Off
        php_admin_value register_globals    0
        php_value magic_quotes_gpc  0
        php_value magic_quotes_runtime  0
        php_value allow_call_time_pass_reference 0
    </IfModule>
 
    <IfModule mod_rewrite.c>
        RewriteEngine On
        RewriteRule content/treemenu/? /index_treemenu.php [L]
        Rewriterule ^/var/storage/.* - [L]
        Rewriterule ^/var/[^/]+/storage/.* - [L]
        RewriteRule ^/var/cache/texttoimage/.* - [L]
        # RewriteRule ^/var/[^/]+/cache/public/.* - [L]
		RewriteRule ^/var/[^/]+/cache/(texttoimage|public)/.* - [L]
        Rewriterule ^/design/[^/]+/(stylesheets|images|javascript)/.* - [L]
        Rewriterule ^/share/icons/.* - [L]
        # Rewriterule ^/extension/[^/]+/design/[^/]+/(stylesheets|images|javascripts?)/.* - [L]
		Rewriterule ^/extension/[^/]+/design/[^/]+/(stylesheets|images|javascript|flash|lib?)/.* - [L]
        Rewriterule ^/packages/styles/.+/(stylesheets|images|javascript)/[^/]+/.* - [L]
        RewriteRule ^/packages/styles/.+/thumbnail/.* - [L]
        RewriteRule ^/favicon\.ico - [L]
        RewriteRule ^/robots\.txt - [L]
        # Uncomment the following lines when using popup style debug.
        # RewriteRule ^/var/cache/debug\.html.* - [L]
        # RewriteRule ^/var/[^/]+/cache/debug\.html.* - [L]
	RewriteRule .* /index.php
    </IfModule>

	ErrorLog /var/log/apache2/error.log

	# Possible values include: debug, info, notice, warn, error, crit,
	# alert, emerg.
	LogLevel warn

	CustomLog /var/log/apache2/access.log combined
</VirtualHost>

Actually, the above assumes ezPublish was configured to run under /var/www, which is different from the config shown in the previous post here.

ezPublish

installing ezPublish (http://ez.no/jp/ezpublish). download the source athttp://ez.no/jp/download. choose eZ Publish full installation (version 4.2.0). 27.2MB. (registered at http://ez.no as a user.)

untar the downloaded file

> sudo tar zxvf ezpublish-4.2.0-full-with_ezc-gpl.tar.gz -C /var/www
> sudo chown -R www-data:www-data /var/www/ezpublish-4.2.0
> sudo mv /var/www/ezpublish-4.2.0 /var/www/ezpublish

take care of its prerequisites:

> sudo apt-get install php5 php5-gd php-cli php-pear curl
> sudo apt-get install postgresql

by synaptic package manager on ubuntu9.04. apache is already installed.

follow the instructions at here.

the first thing to do is to execute psql as a postgres user. turns out i need a password... which i haven't set up this page gives an instruction, and i did

> sudo apt-get install pgadmin3
> sudo -u postgres psql postgres

within psql,

postgres=# \password postgres

then set the password as

Enter new password: 
Enter it again:
postgres=#\q

to login as postgres,

> sudo su
> su postgres
> psql -U postgres -W

assuming to use port 5432. create a new database and a new user

postgres=# CREATE DATABASE myezdb ENCODING='utf8';
CREATE DATABASE
postgres=# CREATE USER ezuser PASSWORD '********';
CREATE ROLE

grant permission

postgres=# GRANT ALL PRIVILEGES ON DATABASE myezdb TO ezuser;
GRANT

Next the instruction says to import the "pgcrypto" module. need to install pgcrypto as

> sudo apt-get install pgsql-contrib-8.3

Now, i can import the "pgcrypto" module into the new database:

postgres=# \c myezdb
Password for user postgres: 
You are now connected to database "myezdb".
myezdb=# \i '/usr/share/postgresql/8.3/contrib/pgcrypto.sql'
SET
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
myezdb=# \q

i donno what FUNCTIONs they are... but, it's ok. better restart PostgreSQL by

> sudo /etc/init.d/postgresql-8.3 restart

Apache is already installed and running. changed the config file at /etc/apache2/sites-available/defult by adding after <Directory /var/www/>

AddType application/x-httpd-php .php
                DirectoryIndex index.html index.php

saved the file as /etc/apache2/sites-available/ezpublish. then,

> sudo a2ensite ezpublish

After killing all the apache-related jobs (check ps aux | grep apache), start apache2

> sudo /etc/init.d/apache2 start

then access the site

> firefox http://localhost/ezpublish/index.php &

got error messages

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 491520 bytes) in /var/www/ezpublish/lib/eztemplate/classes/eztemplatearrayoperator.php on line 762

Fatal error: Class declarations may not be nested in /var/www/ezpublish/lib/ezdb/classes/ezdb.php on line 106

Ugrrr... After some gooling, changed memory_limit in php.ini

> sudo vi /etc/php5/apache2/php.ini

and changed to

memory_limit = 128M

also changed

max_execution_time = 720

Restarted apache2

> sudo /etc/init.d/apache2 restart

Launched the browser

> firefox http://localhost/ezpublish/index.php &

Voila!

hit "Finetune" button. a 'system check' page appears giving some cautions. here, instead of editing php.ini, edit config.php-RECOMMENDED under the root directory of ezPublish as

date.timezone = "Asia/Tokyo"

and save it as config.php.

> sudo chown www-data:www-data config.php

to change the ownership of the file. hit 'next' button anyhow. ... encountered "Missing database handlers" did

> sudo apt-get install php5-pgsql

that solved the problem. got
put a smtp server name s***.xrea.com i have on a rental server. hit 'next'
Servername is localhost, Port 5432, Username postgres, and Password ********. hit 'next'
set default to japanese and additional to english(american). hit 'next'
not all the screen is shown. chose 'Website Interface' as a begining. hit 'next'. took a minute or two to get
chose 'Map to Japanese'.
chose 'URL'.
didn't change any assuming they can be changed in admin later.
changed lastname to YUI, firstname to Comio. mail-address is admin at comio.net. hit 'next'.
got a messge to change to virtual host. i am actually running in virtual host mode, but maybe the apache config file need to be modified. ignore this this time, and see if it's ok. hit 'next'.
this time i won't send info to ez.no. hit 'next'
finished ! i wonder what is 'Usermame' ... hit the link 'User site'. got
ok. see the demo page hit 'Admin site' at the Finished page. got
typed admin as username, and a password. good to see japanese there.
ok, got the admin page

looks like the available extension options doesn't include ez-flow for example in the admin page. need to find out if it can be added thru the admin site.

EC-CUBE

EC-CUBE at http://www.ec-cube.net/ is an open source software for e-commerce written in PHP. Here's a memo in trying to install on Ubuntu8.04.

Download EC-CUBE Version 2.1.2a(tar.gz) at http://www.ec-cube.net/download/index.php. Untaring creates a directory eccube-2.1.2a. Installed requred packages: php5 and postgres, pgadmin3 using synaptic. As written in http://solyaris.wordpress.com/2008/08/09/setup-postgres-in-ubuntu/, did

$ sudo /etc/init.d/postgresql-8.3 start
$ sudo su postgres -c psql template1
postgres> ALTER USER postgres with PASSWORD 'password';
postgres> \q

where password is the password for postgres as a db user. Setup the password of postgres as a UNIX user as follows:

$ sudo passwd -d postgres
$ sudo su postgres -c passwd

Modified /etc/postgres/8.3/main/pg_hba.conf: from: localhost all all ident sameuser to: localhost all all md5 Restart Postgres

$ /etc/init.d/postgresql-8.3 restart

Create a db user

$  sudo -u postgres createdb -O eccube eccube_db

Create a database sudo -u postgres createdb -O eccube eccube_db Installed apache2 by synaptic. Moved the EC-Cube directory eccube-2.1.2a to /var/local Edited the file /etc/apache2/sites-available/default and saved as eccube_site.

NameVirtualHost *
<VirtualHost *>
        ServerAdmin webmaster@localhost

        DocumentRoot /var/local/eccube-2.1.2a/html
        DirectoryIndex index.html index.php

        <Directory />
                Options FollowSymLinks
                AllowOverride None
        </Directory>
        <Directory /var/local/eccube-2.1.2a/html/>
                Options Indexes FollowSymLinks MultiViews
                AllowOverride None
                Order allow,deny
                allow from all
        </Directory>

Load the new setup file for Apache:

a2dissite default
$ sudo a2ensite eccube_site

Restart Apache

$ sudo /etc/init.d/apache2 restart

Lauch a web browser at http://192.168.1.3/ shows the window below:
次へ進む(next)　gives
looks OK. Hit 次へ進む(next).
looks successful. 次へ進む(next) shows the window [[!!! BAD LINK: eccube3.png !!!]]
Now, setting DB [[!!! BAD LINK: eccube5.png !!!]]
gets "DB Error: extension not found". Installed php5-pgsql by synaptic. Restarted the PostgreSQL

/etc/init.d/postgresql-8.3 restart

Then, get different errors as shown below:
To see PHP settings, created phpinfo.php at /var/local/eccube-2.1.2a/html/ as

<?
  phpinfo()
?>

and browsed http://192.168.1.3/phpinfo.php.
seems OK. So, what's wrong? Changed in vi /etc/postgresql/8.3/main/postgresql.conf,

#listen_addresses = 'localhost'

to

listen_addresses = '*'

Restarted Postgres and Apache. OK with the host 127.0.0.1 it worked, and move to the window below:
Next window shows:
It looks OK. Then,
And, finally,
finishes! Logging in
It says /install/index.php needs to be deleted after completing installation.
is the first page for administration.