Page 1 of 1

How to divide the DB and application and web

Posted: Thu Nov 06, 2014 7:58 am
by Aruis.yu
Hi All:

I want to do a test, let the TM1 divided in to 3 layers. One server install the web server , the other is the application server, the third one is the Database server. How to do that?

Now I currently divided 2 layers, Web server and application is on one server, DB is on another server.

And I had modify the tm1s.cfg file and the database file I modify to \\192.168.6.32\C$\XXXX, I had open the port to another server(Web and application)

But when I get to start the service on application, it always says that "Can't connect to admin server at host 192.168.6.32 and port 5498.

But actually i had open the 5498 port for application server.

Re: How to divide the DB and application and web

Posted: Thu Nov 06, 2014 12:55 pm
by jim wood
You have to have an install of TM1 for web to work. So you have to install the listener on one, the DB and a full install on web. Then you have to change the default admin host to where the listener is.

Re: How to divide the DB and application and web

Posted: Thu Nov 06, 2014 1:13 pm
by Aruis.yu
jim wood wrote:You have to have an install of TM1 for web to work. So you have to install the listener on one, the DB and a full install on web. Then you have to change the default admin host to where the listener is.
You are right. But I did like you said. I copy the DB to another server, and using the listen on the path of the DB, like \\192.168.6.32\C$\DB, after I modify the .cfg and start to run the .cfg. It actually begin to run, but after a while, shows the error. Actually, I open all ports . But it still don't work

Re: How to divide the DB and application and web

Posted: Thu Nov 06, 2014 1:32 pm
by tomok
Aruis.yu wrote:[and using the listen on the path of the DB, like \\192.168.6.32\C$\DB, after I modify the .cfg and start to run the .cfg. It actually begin to run, but after a while, shows the error. Actually, I open all ports . But it still don't work
So what do you have as the parameter for the AdminHost item in your tm1s.cfg? If it is "\\192.168.6.32\C$\DB" then that's not going to work. That is pointing to a specific file path on that server. All the AdminHost parameter needs is the name of the server it is running on like "192.168.6.32". In any case, why would you have the Admin Host service run on a different machine than the TM1 Server service???? If they run on the same box then you can leave the AdminHost parameter blank.

Re: How to divide the DB and application and web

Posted: Fri Nov 07, 2014 1:52 am
by Aruis.yu
tomok wrote:
Aruis.yu wrote:[and using the listen on the path of the DB, like \\192.168.6.32\C$\DB, after I modify the .cfg and start to run the .cfg. It actually begin to run, but after a while, shows the error. Actually, I open all ports . But it still don't work
So what do you have as the parameter for the AdminHost item in your tm1s.cfg? If it is "\\192.168.6.32\C$\DB" then that's not going to work. That is pointing to a specific file path on that server. All the AdminHost parameter needs is the name of the server it is running on like "192.168.6.32". In any case, why would you have the Admin Host service run on a different machine than the TM1 Server service???? If they run on the same box then you can leave the AdminHost parameter blank.
Because some company need the security process, let the database and the application separate on different server. And the AdminHost in my .cfg is 192.168.6.32. but the DataBaseDirectory=\\192.168.6.32\C$\DB.

Re: How to divide the DB and application and web

Posted: Fri Nov 07, 2014 2:38 pm
by lotsaram
Aruis.yu wrote:Hi All:

I want to do a test, let the TM1 divided in to 3 layers. One server install the web server , the other is the application server, the third one is the Database server. How to do that?

Now I currently divided 2 layers, Web server and application is on one server, DB is on another server.

And I had modify the tm1s.cfg file and the database file I modify to \\192.168.6.32\C$\XXXX, I had open the port to another server(Web and application)

But when I get to start the service on application, it always says that "Can't connect to admin server at host 192.168.6.32 and port 5498.

But actually i had open the 5498 port for application server.
I do not think that in the context of TM1 that you understand what is the application server, database server and web server.
For TM1 there is no distinction between the application server and database server (although there might be to a file server where the offline database definition is stored), and the admin host is none of these 3 entities.

Re: How to divide the DB and application and web

Posted: Fri Nov 07, 2014 11:29 pm
by mvaspal
For TM1 there is no distinction between the application server and database server
as long as you do not start using the Application Web; so it depends what we understand under application server