mysql> select * from Properties;
+---------+---------------------------------------------+---
----------------
-------------------------+
| blog_id | property_name |
property_value
|
+---------+---------------------------------------------+---
----------------
-------------------------+
| default | blog-url |
http://loc
alhost:8080/blojsom/blog/default |
| default | blog-admin-url |
http://loc
alhost:8080/blojsom/blog/default |
| default | blog-base-url |
http://localhost:8080/b
lojsom |
You'll want to change blog-admin-url as well.
On 6/20/06 4:43 PM, "Kai Middleton"
<kaimiddleton fastmail.fm> wrote:
> I originally wrote:
>
> I just got my 3.0 M2 instance installed.
> But I have my tomcat running on port 80.
> I can hit:
> http://localho
st/blojsom/blog/default/
> It gives me the "NAME YOUR BLOG" page but
with no stylesheet applied.
> Also, if I try to log in to:
> h
ttp://localhost/blojsom/blog/default/?flavor=admin
> I can load the page, but the submit (user:default
pass:default) fails.
> I notice the link to "Back to NAME YOUR
BLOG" hard codes 8080.
>
> David Czarnecki replied:
> Nope, just change the
> blog-url and
> blog-base-url
> properties in the database.
>
> But I can't find these properties. The closest I find
are:
> comment.authorurl
> pingback.url
> trackback.url
> pingback.sourceuri
> pingback.targeturi
>
> Here's what I did in MySQL:
>
> mysql> use blojsom
> Database changed
> mysql> show tables;
> +-------------------+
> | Tables_in_blojsom |
> +-------------------+
> | blog |
> | category |
> | categorymetadata |
> | comment |
> | commentmetadata |
> | dbuser |
> | dbusermetadata |
> | entry |
> | entrymetadata |
> | pingback |
> | pingbackmetadata |
> | plugin |
> | properties |
> | template |
> | trackback |
> | trackbackmetadata |
> +-------------------+
> 16 rows in set (0.00 sec)
>
> mysql> describe blog;
>
+---------+-------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra
|
>
+---------+-------------+------+-----+---------+-------+
> | blog_id | varchar(50) | NO | PRI | NULL |
|
>
+---------+-------------+------+-----+---------+-------+
> 1 row in set (0.00 sec)
>
> mysql> describe blog;
>
+---------+-------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra
|
>
+---------+-------------+------+-----+---------+-------+
> | blog_id | varchar(50) | NO | PRI | NULL |
|
>
+---------+-------------+------+-----+---------+-------+
> 1 row in set (0.00 sec)
>
> mysql> describe category;
>
+--------------------+-------------+------+-----+---------+-
---------------+
> | Field | Type | Null | Key |
Default | Extra
> |
>
+--------------------+-------------+------+-----+---------+-
---------------+
> | category_id | int(11) | NO | PRI | NULL
|
> auto_increment |
> | blog_id | varchar(50) | NO | MUL | NULL
|
> |
> | parent_category_id | int(11) | YES | | NULL
|
> |
> | name | text | NO | | NULL
|
> |
> | description | text | YES | | NULL
|
> |
>
+--------------------+-------------+------+-----+---------+-
---------------+
> 5 rows in set (0.03 sec)
>
> mysql> describe categorymetadata;
>
+----------------+---------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default |
Extra |
>
+----------------+---------+------+-----+---------+-------+
> | category_id | int(11) | NO | MUL | NULL |
|
> | metadata_key | text | NO | | NULL |
|
> | metadata_value | text | YES | | NULL |
|
>
+----------------+---------+------+-----+---------+-------+
> 3 rows in set (0.05 sec)
>
> mysql> describe comment;
>
+----------------+--------------+------+-----+---------+----
------------+
> | Field | Type | Null | Key | Default
| Extra
> |
>
+----------------+--------------+------+-----+---------+----
------------+
> | comment_id | int(11) | NO | PRI | NULL
| auto_increment
> |
> | entry_id | int(11) | NO | | NULL
|
> |
> | author | text | YES | | NULL
|
> |
> | author_url | text | YES | | NULL
|
> |
> | author_email | text | YES | | NULL
|
> |
> | comment | text | YES | | NULL
|
> |
> | date | datetime | NO | | NULL
|
> |
> | ip | varchar(100) | YES | | NULL
|
> |
> | status | varchar(255) | YES | | NULL
|
> |
> | comment_parent | int(11) | YES | | NULL
|
> |
> | blog_id | varchar(50) | NO | MUL | NULL
|
> |
>
+----------------+--------------+------+-----+---------+----
------------+
> 11 rows in set (0.03 sec)
>
> mysql> describe commentmetadata;
>
+----------------+---------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default |
Extra |
>
+----------------+---------+------+-----+---------+-------+
> | comment_id | int(11) | NO | MUL | NULL |
|
> | metadata_key | text | NO | | NULL |
|
> | metadata_value | text | YES | | NULL |
|
>
+----------------+---------+------+-----+---------+-------+
> 3 rows in set (0.06 sec)
>
> mysql> describe dbuser;
>
+-----------------+--------------+------+-----+---------+---
-------------+
> | Field | Type | Null | Key | Default
| Extra
> |
>
+-----------------+--------------+------+-----+---------+---
-------------+
> | user_id | int(11) | NO | PRI | NULL
| auto_increment
> |
> | user_login | varchar(50) | NO | | NULL
|
> |
> | user_password | varchar(64) | NO | | NULL
|
> |
> | user_name | varchar(250) | NO | | NULL
|
> |
> | user_email | varchar(100) | NO | | NULL
|
> |
> | user_registered | datetime | NO | | NULL
|
> |
> | user_status | varchar(64) | NO | | NULL
|
> |
> | blog_id | varchar(50) | NO | MUL | NULL
|
> |
>
+-----------------+--------------+------+-----+---------+---
-------------+
> 8 rows in set (0.00 sec)
>
> mysql> describe dbusermetadata;
>
+------------------+--------------+------+-----+---------+--
--------------+
> | Field | Type | Null | Key |
Default | Extra
> |
>
+------------------+--------------+------+-----+---------+--
--------------+
> | user_metadata_id | int(11) | NO | PRI | NULL
|
> auto_increment |
> | user_id | int(11) | NO | MUL | NULL
|
> |
> | metadata_key | varchar(255) | NO | | NULL
|
> |
> | metadata_value | text | YES | | NULL
|
> |
>
+------------------+--------------+------+-----+---------+--
--------------+
> 4 rows in set (0.05 sec)
>
> mysql> describe entry;
>
+------------------+-------------+------+-----+---------+---
-------------+
> | Field | Type | Null | Key | Default
| Extra
> |
>
+------------------+-------------+------+-----+---------+---
-------------+
> | entry_id | int(11) | NO | PRI | NULL
| auto_increment
> |
> | blog_id | varchar(50) | NO | MUL | NULL
|
> |
> | title | text | YES | | NULL
|
> |
> | description | text | YES | | NULL
|
> |
> | entry_date | datetime | NO | | NULL
|
> |
> | blog_category_id | int(11) | NO | MUL | NULL
|
> |
> | status | text | YES | | NULL
|
> |
> | author | text | YES | | NULL
|
> |
> | allow_comments | int(11) | YES | | 1
|
> |
> | allow_trackbacks | int(11) | YES | | 1
|
> |
> | allow_pingbacks | int(11) | YES | | 1
|
> |
> | post_slug | text | NO | | NULL
|
> |
> | modified_date | datetime | NO | | NULL
|
> |
>
+------------------+-------------+------+-----+---------+---
-------------+
> 13 rows in set (0.03 sec)
>
> mysql> describe entrymetadata;
>
+----------------+---------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default |
Extra |
>
+----------------+---------+------+-----+---------+-------+
> | entry_id | int(11) | NO | MUL | NULL |
|
> | metadata_key | text | NO | | NULL |
|
> | metadata_value | text | YES | | NULL |
|
>
+----------------+---------+------+-----+---------+-------+
> 3 rows in set (0.05 sec)
>
> mysql> describe pingback;
>
+----------------+--------------+------+-----+---------+----
------------+
> | Field | Type | Null | Key | Default
| Extra
> |
>
+----------------+--------------+------+-----+---------+----
------------+
> | pingback_id | int(11) | NO | PRI | NULL
| auto_increment
> |
> | entry_id | int(11) | NO | | NULL
|
> |
> | title | text | YES | | NULL
|
> |
> | excerpt | text | YES | | NULL
|
> |
> | url | text | YES | | NULL
|
> |
> | blog_name | text | YES | | NULL
|
> |
> | trackback_date | datetime | NO | | NULL
|
> |
> | blog_id | varchar(50) | NO | MUL | NULL
|
> |
> | ip | varchar(100) | YES | | NULL
|
> |
> | status | varchar(255) | YES | | NULL
|
> |
> | source_uri | text | NO | | NULL
|
> |
> | target_uri | text | NO | | NULL
|
> |
>
+----------------+--------------+------+-----+---------+----
------------+
> 12 rows in set (0.09 sec)
>
> mysql> describe pingbackmetadata;
>
+----------------+---------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default |
Extra |
>
+----------------+---------+------+-----+---------+-------+
> | pingback_id | int(11) | NO | MUL | NULL |
|
> | metadata_key | text | NO | | NULL |
|
> | metadata_value | text | YES | | NULL |
|
>
+----------------+---------+------+-----+---------+-------+
> 3 rows in set (0.05 sec)
>
> mysql> describe plugin;
>
+---------------+---------------+------+-----+---------+----
---+
> | Field | Type | Null | Key | Default
| Extra |
>
+---------------+---------------+------+-----+---------+----
---+
> | blog_id | varchar(50) | NO | MUL | NULL
| |
> | plugin_flavor | varchar(50) | NO | | NULL
| |
> | plugin_value | varchar(4096) | YES | | NULL
| |
>
+---------------+---------------+------+-----+---------+----
---+
> 3 rows in set (0.05 sec)
>
> mysql> describe properties;
>
+----------------+--------------+------+-----+---------+----
---+
> | Field | Type | Null | Key | Default
| Extra |
>
+----------------+--------------+------+-----+---------+----
---+
> | blog_id | varchar(50) | NO | MUL | NULL
| |
> | property_name | varchar(255) | NO | | NULL
| |
> | property_value | longtext | YES | | NULL
| |
>
+----------------+--------------+------+-----+---------+----
---+
> 3 rows in set (0.00 sec)
>
> mysql> describe template;
>
+-----------------+--------------+------+-----+---------+---
----+
> | Field | Type | Null | Key | Default
| Extra |
>
+-----------------+--------------+------+-----+---------+---
----+
> | blog_id | varchar(50) | NO | MUL | NULL
| |
> | template_flavor | varchar(50) | NO | | NULL
| |
> | template_value | varchar(255) | YES | | NULL
| |
>
+-----------------+--------------+------+-----+---------+---
----+
> 3 rows in set (0.05 sec)
>
> mysql> describe trackback;
>
+----------------+--------------+------+-----+---------+----
------------+
> | Field | Type | Null | Key | Default
| Extra
> |
>
+----------------+--------------+------+-----+---------+----
------------+
> | trackback_id | int(11) | NO | PRI | NULL
| auto_increment
> |
> | entry_id | int(11) | NO | | NULL
|
> |
> | title | text | YES | | NULL
|
> |
> | excerpt | text | YES | | NULL
|
> |
> | url | text | YES | | NULL
|
> |
> | blog_name | text | YES | | NULL
|
> |
> | trackback_date | datetime | NO | | NULL
|
> |
> | blog_id | varchar(50) | NO | MUL | NULL
|
> |
> | ip | varchar(100) | YES | | NULL
|
> |
> | status | varchar(255) | YES | | NULL
|
> |
>
+----------------+--------------+------+-----+---------+----
------------+
>
>
> _______________________________________________
> Blojsom-users mailing list
> Blojsom-userslists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers
--
David Czarnecki
http://www.blojsom.com/b
log/ | http://blojsom.sf.net
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers
|