Guest Posted January 19, 2005 Posted January 19, 2005 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.