Re: BSM Dashboards 7.7
Listers, Ok, so I've figured out the root MySQL password and the cs050101 password... however, I'm still having an issue as to where it stores the Dashboards usernames/passwords since they don't store anywhere in the database... Has anyone built an integration using Remedy API to create a Dashboards account through Remedy? Basically what I was thinking was: When a user profile is saved/modified within Remedy (with some kind of dashboards flag albeit checkbox or group membership), to fire a command to dashboards to create an account with the same login id. Was hoping to write a SQL script to do it, however that seems to be out of the question now... Thoughts? Comments? Bueller? On Thu, Jan 2, 2014 at 4:40 PM, Rob Dudley wrote: > Greetings listers, > > I've searched and searched and searched, yet I cannot seem to find the > default root user password for the MySQL db which is installed with the > dashboards product. > > The problem is that I've changed the root password so that I can > see/access the Db (I did this hoping that I could find out which table > holds the actual dashboards users so that I could write an api to auto > create the accounts). Apparently changing it was bad because some genius > thought it would be good to have the jdbc connection, connect to the Db > using the root user instead of granting a specific user to the databases it > needs...smh > > I would be ever so grateful if someone could please either post or email > me directly the default root password so that I can change it back without > having to do a reinstall. > > Thank you in advance, > Rob > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: BSM Dashboards 7.7
Rob, I don't know the answer to your question but from experience and the direction I've seen BMC going, they will most likely retire the Dashboards product. They will be looking to take advantage of BOXI 4 and it's SDK for both Analytics and dashboards capabilities. So armed with that knowledge, you can weigh the pros and cons of pursuing the integration and development time you're going to be putting in to the current product. Sent from my iPhone > On Jan 3, 2014, at 1:08 AM, Rob Dudley wrote: > > ** > Listers, > > Ok, so I've figured out the root MySQL password and the cs050101 password... > however, I'm still having an issue as to where it stores the Dashboards > usernames/passwords since they don't store anywhere in the database... > > Has anyone built an integration using Remedy API to create a Dashboards > account through Remedy? Basically what I was thinking was: When a user > profile is saved/modified within Remedy (with some kind of dashboards flag > albeit checkbox or group membership), to fire a command to dashboards to > create an account with the same login id. Was hoping to write a SQL script > to do it, however that seems to be out of the question now... > > Thoughts? Comments? > > Bueller? > > >> On Thu, Jan 2, 2014 at 4:40 PM, Rob Dudley wrote: >> Greetings listers, >> >> I've searched and searched and searched, yet I cannot seem to find the >> default root user password for the MySQL db which is installed with the >> dashboards product. >> >> The problem is that I've changed the root password so that I can see/access >> the Db (I did this hoping that I could find out which table holds the actual >> dashboards users so that I could write an api to auto create the accounts). >> Apparently changing it was bad because some genius thought it would be good >> to have the jdbc connection, connect to the Db using the root user instead >> of granting a specific user to the databases it needs...smh >> >> I would be ever so grateful if someone could please either post or email me >> directly the default root password so that I can change it back without >> having to do a reinstall. >> >> Thank you in advance, >> Rob > > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: BSM Dashboards 7.7
Tauf, Thanks for the reply. The more and more I keep digging into Dashboards 7.7.01, the more and more I shake my head I've found that it not only utilizes an instance of mySQL, but utilizes an instance of Apache Derby DB as well. The Dashboard users are stored in the schema BSMDASHBOARDSAPP under the table BSD_USERS within Derby. Utilizing command line JDBC calls, the following call is stating that userid or password is invalid 'jdbc:derby://localhost:1528/bsmdashboards'; Once I can get in through this jdbc connection it will be easy to script out my integration - it's just finding the userid and password that I will need to connect :-) Rob On Sat, Jan 4, 2014 at 6:28 AM, Tauf Chowdhury wrote: > ** > Rob, > I don't know the answer to your question but from experience and the > direction I've seen BMC going, they will most likely retire the Dashboards > product. They will be looking to take advantage of BOXI 4 and it's SDK for > both Analytics and dashboards capabilities. > So armed with that knowledge, you can weigh the pros and cons of pursuing > the integration and development time you're going to be putting in to the > current product. > > Sent from my iPhone > > On Jan 3, 2014, at 1:08 AM, Rob Dudley wrote: > > ** > Listers, > > Ok, so I've figured out the root MySQL password and the cs050101 > password... however, I'm still having an issue as to where it stores the > Dashboards usernames/passwords since they don't store anywhere in the > database... > > Has anyone built an integration using Remedy API to create a Dashboards > account through Remedy? Basically what I was thinking was: When a user > profile is saved/modified within Remedy (with some kind of dashboards flag > albeit checkbox or group membership), to fire a command to dashboards to > create an account with the same login id. Was hoping to write a SQL script > to do it, however that seems to be out of the question now... > > Thoughts? Comments? > > Bueller? > > > On Thu, Jan 2, 2014 at 4:40 PM, Rob Dudley wrote: > >> Greetings listers, >> >> I've searched and searched and searched, yet I cannot seem to find the >> default root user password for the MySQL db which is installed with the >> dashboards product. >> >> The problem is that I've changed the root password so that I can >> see/access the Db (I did this hoping that I could find out which table >> holds the actual dashboards users so that I could write an api to auto >> create the accounts). Apparently changing it was bad because some genius >> thought it would be good to have the jdbc connection, connect to the Db >> using the root user instead of granting a specific user to the databases it >> needs...smh >> >> I would be ever so grateful if someone could please either post or email >> me directly the default root password so that I can change it back without >> having to do a reinstall. >> >> Thank you in advance, >> Rob >> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"