Re: trying to go live but have wrong URLS and database is empty

Obviously the database tables exist somewhere. I can't see
how the site is
running without them. Maybe use another tool to access the
database? MySQL
Query Browser, YourSQL, etc...

On 6/14/07 1:39 AM, "Garrett Smith"
<dhtmlkitchengmail.com> wrote:

> In blojsom-helper-beans-include.xml, I set the  bean
id="dataSource"'s
> url property to:
> 
>         <property name="url"
>
value="jdbc:mysql://localhost:3306/dhtmlkit_blojsom?aut
oReconnect=true&amp;use
>
Unicode=true&amp;characterEncoding=utf-8"/>
> 
> Database: dhtmlkit_blojsom
> 
> No tables found in database.
> 
> I followed the directions and it works locally.
> http://wiki.blojsom.com/wiki/display/blojsom
3/Tomcat+Setup+for+MySQL
> 
> I checked the log files and there is no JDBC error.
> 
> I do see the test entries that I created on the site
live. These
> entries were created on my local machine. I was
surprised to see them
> live. I cannot log in to the admin screen. Why does the
action to the
> admin login points to my IP address?
> <form name="blojsom-login"
> action="
http://24.6.215.208/news/default/?flavor=admin"
method="post">
> 
> All the blojsom URLs point to my machine.
> 
> Garrett
> 
> 
> On 6/13/07, David Czarnecki <davidblojsom.com> wrote:
>> 
>>  The URL properties are in the Properties table in
the database. Just make
>> sure you're pointing phpMyAdmin at the correct
database I guess.
>> 
>> 
>>  On 6/13/07 9:08 PM, "Garrett Smith"
<dhtmlkitchengmail.com> wrote:
>> 
>> 
>> 
>> I just tried to go live and found that I have some
of the content that I
>> created locally on my live site. I guess this is
how hibernate works. So I
>> checked the database to see if I can delete those
>> 
>>  1) the urls are all pointing to my machine's IP
address instead of the
>> correct domain. I can't view the admin pages, only
on my local machine.
>> 
>>  2) Using phpMyAdmin:  Database: dhtmlkit_blojsom
>>  No tables found in database
>> 
>>  What do I need to do to initialize the database on
the server? How can I fix
>> those URLs so they don't point to my local
machine?
>> 
>>  Thank you,
>> 
>>  Garrett
>> 
>> 
>>  --
>>  David Czarnecki
>> 
>>  http://www.blojsom.com/b
log/ | http://blojsom.sf.net
>> 
>>
------------------------------------------------------------
-------------
>> This SF.net email is sponsored by DB2 Express
>> Download DB2 Express C - the FREE version of DB2
express and take
>> control of your XML. No limits. Just data. Click to
get it now.
>> http://sourcefor
ge.net/powerbar/db2/
>> _______________________________________________
>> 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



------------------------------------------------------------
-------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and
take
control of your XML. No limits. Just data. Click to get it
now.
http://sourcefor
ge.net/powerbar/db2/
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers