This is the database login and not the user login.
Eg. in postgresql, you have to create 2 roles (user1 & user2) and to create 2 databases (db-defailt0 owner to user1, db-default1 owner to user2). This sujst an example, name your database and user as u want.
That’s it.
Thus, when use select the DB in the login page everything you 'll do will be applied to the selected database.
No, you are making a confusion. On Axelor you have to kind of accounts (users): login/password you are using to connect to the database (configured in the application.properties) and users that connect to the Axelor Web plateform.
On the application.properties you define your database(s) properties. Axelor requires as least 1 database but your can use severals (for test, pre-prod, etc.). To connect to a database you need a login and a password (define in the database system - eg. roles in postgresql), its the goal of the attribute db.default.user (the database user login) and db.default.password the database user password. When I say "user’ is the a people.
On example.com/login.jsp, if you have configured several properties you will have to select the database (default or secondary) and then to enter your user credential (eg. admin/admin) which are not stored in the application.properties but in a database’s table. Now, using the Administation menu you could create a new user.
Summary:
login/passord defined in the application.properties are used for the database connection
when connected on Axelor, use the Administration/Users menu to create new users (people accounts)
You can first test the db connection your defined in the application.properties using a client (eg. pgsql). If both connections work you should see the combo in the login page and then use the default axelor account admin (password admin. You need to restart tomcat after any modification of the application.properties.
Case 2: in this cas you will have several connection port due to tomcat bind (example.com:80 and example.com:81)
So nothing is perfec, it just depends of what is the goal of having several instances:
if its for dev and prod, use 2 different server
if its for several company you can solve point 1 & 2 by using a reverse proxy (eg. Apache) and make a specific reverse, using the requested domain, as a transparent action
Could you tell if there is something wrong in my configuration?
Ideally If I am tenant “hh24” I would connect using port 8081(ea. “http://cloud.censon.us:8081/login.jsp”) so that I will be using the database named “hh24”.
If I am tenant “wpf” I would connect using port 8082(ea. “http://cloud.censon.us:8082/login.jsp”) so that I will be using the database named “wpf” and so on and so forth.
what is happening to my server is that it looks like it is “unable to resolve tenant id for some reason” and only the default/fallback database is used and when using ports other than the default ones my credentials “admin/admin” does not work.
The “hosts” property in the tenant config is: host name based filter, the tenant is accessible from those hosts only (error in the doc, the numer 5 and 6 has been reversed). Thus don’t increment it like u done.
Now, with multi tenants, just connect to http://yourhost:8080/login.jsp (default access) and u you should see a combobox with the list of your tenants.
I don’t think it’s a good idea to use the multi tenancy. Prefer to setup several WebApps instead.
Just to check, did you create other database with the [default] schema ?
I created schma for other databases by running/booting each one of them once with axelor so that the tables there will be created. I can use those other databases to for main. Is there a best way to create schema for other tenants other thatn running them once as main/default db?
in this example, each property need to start with db.db[number] and not db.hh24 nor db.wpf.
Just try to replace db.hh24.* by db.db1., db.wpf.* by db.db2. and db.bm.* by db.db3. and it should work
So, your config should be (with correct login/password for each of course):
Hi, i see the multi tanancy mode we must create multi database instance but i want make tenancy by data --> company / organization in this way How i can do it?
because it will take small size of database and make very easy to maintenance.
pls Help.
Thanks