3

I have two databases one normal Tridion and one for broker Database. I am using Tridion 5.3.

How does Tridion know which broker database to use? How do I put it in my configuration?

6

in cd_broker_conf.xml

you have section like following.

<Storage>
      <Database Type="sql">
      <Pool Type="jdbc" Size="5" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" />
          <DataSource Class="com.microsoft.sqlserver.jdbc.SQLServerDataSource">
          <Property Name="serverName" Value="db"/>
          <Property Name="portNumber" Value="1433"/>
          <Property Name="databaseName" Value="Tridion_broker"/>
          <Property Name="user" Value="uid"/>
          <Property Name="password" Value="pwd"/>
        </DataSource>
      </Database>
    </Storage>
| improve this answer | |
3

As Raj says, this is stored in the cd_broker_conf.xml file.

You will find this file in to following folder: C:\Program Files\Tridion\config (assuming that Tridion was installed in the default location)

NOTE: If you make any changes to this file, you will need to restart the Tridion Content Broker and Tridion Content Deployer Windows Services (or the Java processes), to get the changes to take effect.

You may also need to restart the Tridion Cache Channel Service and Tridion Dynamic Linking Services for good measure too.

| improve this answer | |
  • 2
    You will also need to restart the Deployer service (if installed) as that is also using the Broker for storing published content. – Bart Koopman Sep 5 '13 at 12:54
  • Indeed the linking service also used the Broker configuration ;) – Bart Koopman Sep 5 '13 at 13:01
  • Thanks for all of your answers Raj,Miguel,Jonathan and Bart :) – neil Sep 6 '13 at 3:15
  • Actually, Bart , I am planning on refreshing my dev/test tridion databases from live. I have two databases one tridion and one broker. So, I was wondering if I clean the broker database completely and recreate all tables and users for brokers, how would the broker tables then populate with values, I mean what would trigger that. – neil Sep 6 '13 at 3:18
  • @neil if you want to clean the db, what is purpose of restoring it from production? Is publishing already working in your environment or you need to setup it? – Raj Kumar Sep 6 '13 at 3:42
3

Just want to add that in case of a J2EE application the configuration in the cd_broker_conf.xml could be pointing to a JNDI instead having those values written in the configuration file. In that case you will have to go to the definition of the JNDI in the Application Server to find those values.

| improve this answer | |
  • Yup thats right . It does point to jndi, I know the databases and passwords, I just need to know the above. – neil Sep 6 '13 at 12:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.