| Author |
Message
|
| Sriharsha |
 Posted: Tue May 16, 2006 8:47 am Post subject: Getting database connect error while starting a broker |
 |
|
Novice
Joined: 20 Feb 2006
Posts: 13
|
I am trying to start a WMB 6 broker on AIX and its showing successful command initiation.But when i checked the processes only bipservice is running and bipbroker process hasn't comeup.And in the logs i see the following.
May 16 11:38:59 amdwi503 user:err|error WebSphere Broker v6000[1261660]: (INVTXT01)[1]BIP2048E: An Exception was caught while
issuing database SQL command connect. : INVTXT01.agent: /build/S000_P/src/AdminAgent/ImbAdminStore.cpp: 304: ImbAdminStore::
Connect: :
May 16 11:38:59 amdwi503 user:err|error WebSphere Broker v6000[1261660]: (INVTXT01)[1]BIP2321E: Database error: ODBC return c
ode '-1'. : INVTXT01.agent: /build/S000_P/src/DataFlowEngine/ImbOdbc.cpp: 232: ImbOdbcHandle::checkRcInner: :
May 16 11:38:59 amdwi503 user:err|error WebSphere Broker v6000[1261660]: (INVTXT01)[1]BIP2322E: Database error: SQL State '78
'; Native Error Code '0'; Error Text '523 76'. : INVTXT01.agent: /build/S000_P/src/DataFlowEngine/ImbOdbc.cpp: 360: ImbOdbcHa
ndle::checkRcInner: :
May 16 11:38:59 amdwi503 user:err|error WebSphere Broker v6000[1261660]: (INVTXT01)[1]BIP2053E: The broker made an unsuccessf
ul attempt to access its database MINVTXBT with userid mqsi. : INVTXT01.agent: /build/S000_P/src/AdminAgent/ImbAdminAgent.cpp
: 480: ImbAdminAgent::instanceOfAdminAgent: :
I used mqsichangebroker to make sure that it's using the correct password to connect to the broker database and got the same error.
I checked the odbc ini file and checked the path of the driver used for odbc connection and it looks fine.
Any suggestions on why this could be happening.
Thanks
Sriharsha |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue May 16, 2006 9:22 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Did you try manually connecting to the database as the mqsi user?
Did you try making sure that you had properly authorized the mqsi user on the database itself?
Did you try ensuring that the mqsi user had sufficient priviledges to both start and run the broker?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Sriharsha |
| Posted: Tue May 16, 2006 10:18 am Post subject: |
|
|
Novice
Joined: 20 Feb 2006
Posts: 13
|
Yeah I am able to connect to broker database manually using mqsi
db2 connect to MINVTXBT user mqsi
Enter current password for mqsi:
Database Connection Information
Database server = DB2/6000 8.2.1
SQL authorization ID = MQSI
Local database alias = MINVTXBT
These are the permissions given for the mqsi user to the database MINVTXBT
db2 get authorizations
Administrative Authorizations for Current User
Direct SYSADM authority = NO
Direct SYSCTRL authority = NO
Direct SYSMAINT authority = NO
Direct DBADM authority = NO
Direct CREATETAB authority = YES
Direct BINDADD authority = YES
Direct CONNECT authority = YES
Direct CREATE_NOT_FENC authority = NO
Direct IMPLICIT_SCHEMA authority = YES
Direct LOAD authority = NO
Direct QUIESCE_CONNECT authority = NO
Direct CREATE_EXTERNAL_ROUTINE authority = NO
Direct SYSMON authority = NO
Indirect SYSADM authority = NO
Indirect SYSCTRL authority = NO
Indirect SYSMAINT authority = NO
Indirect DBADM authority = NO
Indirect CREATETAB authority = NO
Indirect BINDADD authority = NO
Indirect CONNECT authority = NO
Indirect CREATE_NOT_FENC authority = NO
Indirect IMPLICIT_SCHEMA authority = NO
Indirect LOAD authority = NO
Indirect QUIESCE_CONNECT authority = NO
Indirect CREATE_EXTERNAL_ROUTINE authority = NO
Indirect SYSMON authority = NO
Am i missing something in the above permissions
Also we are using a different user id to run the broker which is same as the broker name in this case it's "invtxt01" and i started the broker with invtxt01 id.
Does using a different id to run the broker than the one being used for database access causes any problems. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Tue May 16, 2006 7:05 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi Sriharsha,
So ur broker and database has different userid passwords ?
During broker creation what is the command u used ? did u specify the correct userid and password at the respecitve places ? Please post your command here...
Do a test connection from the ODBC too...
Regards. |
|
| Back to top |
|
|
| kevin_22 |
| Posted: Tue May 16, 2006 8:17 pm Post subject: |
|
|
Centurion
Joined: 08 Mar 2005
Posts: 100
|
Hi Sriharsha,
You might not create a Data sournce name for your Database. For creation of broker you need DSN. Try connecting thru DSN.
Thanks,
Kevin |
|
| Back to top |
|
|
| JT |
| Posted: Wed May 17, 2006 12:36 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
|
| Back to top |
|
|
|
|
