Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

osCommerce of FreeBSD 5.3


Guest

Recommended Posts

Posted

I want to install and explore oscommerce.

but whe I try to do the graphical installer it hangs with a partial image at the DB setup step (step2). There are no errors, and the progress bar finishes and throbber stops indicating loading. Also yes I did enable global_registers, reload mysql and apache after configuring each.

 

Here's what I did.

 

cd /usr/ports/www/oscommerce && make install

 

browser to:

http://myserver.tld/catalog/install

 

I get the install page, so I go to mysql and

 

danu# mysql -u root -p pwsoscdb
Enter password:
Welcome to the MySQL monitor.  Commands end with; or \g.
Your MySQL connection id is 13 to server version: 4.1.9

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW TABLES;
Empty set (0.00 sec)

mysql> CREATE TABLE user (name VARCHAR(20), firstname VARCHAR(20), surname VARC HAR(20), sex CHAR(1), birth DATE);
Query OK, 0 rows affected (0.01 sec)

mysql> SHOW TABLES; 
+--------------------+
| Tables_in_pwsoscdb |
+--------------------+
| user               |
+--------------------+
1 row in set (0.00 sec)

mysql> INSERT INTO user VALUES ('reed','Reed','OBrien','m','2005-01-19');
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM user     ->;
+------+-----------+---------+------+------------+
| name | firstname | surname | sex  | birth      |
+------+-----------+---------+------+------------+
| reed | Reed      | OBrien  | m    | 2005-01-19 |
+------+-----------+---------+------+------------+
1 row in set (0.00 sec)

 

 

I can access it with python too...

 

danu# python
Python 2.4 (#2, Jan  3 2005, 04:18:43)
[GCC 3.4.2 [FreeBSD] 20040728] on freebsd5
Type "help", "copyright", "credits" or "license" for more information.

>>>

>>> import MySQLdb
>>> db=MySQLdb.connect(passwd="secret",db="pwsoscdb")
>>> c=db.cursor()
>>> c.execute("""SELECT * FROM user""")
1L
>>> c.fetchone()
('reed', 'Reed', 'OBrien', 'm', datetime.date(2005, 1, 19))
>>>

 

 

Any ideas?

 

__________________

5amYan

4.6692016090

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...