On 08/18/2012 01:40 AM, Kendrick C. Wilson wrote:
> james1) log into the mysql server
> 2) create a database with the name james3) grant the user james to
all tables in the databases4) start the james server tables will get
created
Ok, I did that and have:
root@dur:/home/thufir/apache-james-3.0-beta4/bin#
root@dur:/home/thufir/apache-james-3.0-beta4/bin# ./james-cli.sh -h
localhost -p 9999 listdomains
dur.bounceme.net
mydomain.tld
127.0.1.1
127.0.1.1
listdomains command executed sucessfully in 1841 ms.
root@dur:/home/thufir/apache-james-3.0-beta4/bin#
root@dur:/home/thufir/apache-james-3.0-beta4/bin# ./james-cli.sh -h
localhost -p 9999 listusers
[email protected]
[email protected]
[email protected]
listusers command executed sucessfully in 273 ms.
root@dur:/home/thufir/apache-james-3.0-beta4/bin#
root@dur:/home/thufir/apache-james-3.0-beta4/bin# cat
../conf/james-database.properties
# MySQL JDBC database properties
database.driverClassName=com.mysql.jdbc.Driver
database.url=jdbc:mysql://localhost/james
database.username=james
database.password=password
vendorAdapter.database=MYSQL
openjpa.streaming=false
root@dur:/home/thufir/apache-james-3.0-beta4/bin#
however, how do I know where james is storing those users and domains?
They're not in the database, it's empty:
thufir@dur:~$
thufir@dur:~$ mysql -u james -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 135
Server version: 5.5.22-0ubuntu1 (Ubuntu)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql>
mysql> use james;
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql> quit
Bye
thufir@dur:~$
Should I create the tables manually? Can't see why James isn't writing
the user and domain data to the database.
thanks,
Thufir
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
