"Brian M. Long" wrote:
>
> ok so since i can't get james to work i'd like to just hack the thing to get
> more initial users and not worry about adding more.
>
> can i just add more users to /src/sql/external/default_roles_permissions.sql
> and rebuild the WAR file?
>
> -bml
>
hmm... if you follow the posts on the mail archive about this issue, you should
be able to resolve your mail issue.
If you want to use SQL to update your user DB and you're using the default
hypersonicSQL database bundled with jetspeed 1.3a1 you can:
* stop Tomcat
* do the following
cd <webapps>/jetspeed/WEB-INF
java -classpath lib/hsql.jar DatabaseManager
choose Hypersonic standalone mode
path (must be absolute): <webapps>/jetspeed/WEB-INF/db/jetspeed
user: sa
password: <none>
and use the GUI
* start Tomcat
or if you want command line operation
* stop Tomcat
* cd <webapps>/jetspeed/WEB-INF/db
* append your SQL statements at the end of jetspeed.script
(for example, using a shell
cat >> jetspeed.script
INSERT INTO TURBINE_USER
VALUES(0,'myuser','mypass','','',NULL,'CONFIRMED',NULL,NULL,NULL,NULL)
^D
)
* restart Tomcat
--
Raphaël Luta - [EMAIL PROTECTED]
Vivendi Universal Networks - Services Manager / Paris
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/[email protected]/>
List Help?: [EMAIL PROTECTED]
