Jump to content

support

Administrators
 View Profile  See their activity

  • Posts

    5,090

  • Joined

  • Last visited

  • Days Won

    318

 Content Type 

Posts posted by support

    Get password heartbeat status through API?

    in Community Support

    Posted

    Hi Jomalin,

     

    If you have a look at the screen Administration -> Reporting, all these reports are available via the API.

    I would suggest you're interested in failed heartbeats, and we have a report for that. Full documentation can be found on the menu Help -> Web API Documentation

     

    We hope this helps.

    Regards

    Click Studios

    Build 9493 Database Management

    in Known Issues

    Posted

    Problem:

    When you upgrade from a build prior to Version 9493, your Passwordstate database will support Unicode characters, which can make your database grow by a large amount.  To ensure you have a seamless upgrade experience we'd recommend the following database management options:

     

    Steps to Consider Before you Upgrade:

     

    **Note** If you are using SQL Express, this has a 10 GB data limit. Your database should really no no bigger than 2GB if using SQL Express, otherwise you may have to consider Moving your database to a SQL Standard instance. 

     

    Option #1: Set your Recovery model for your database to "Simple".  This will still allow full backups to be taken, but will significantly reduce the size of your database.  **Note** you should not set your database to Simple mode if you have any form of SQL Replication running.

    Action: Connect to your database server using SQL Management Studio Tools, right click your Passwordstate database, and select Properties.  Now change the recovery model to Simple:

     

    2022-07-06_8-21-13.png

     

    Option #2: Check you have plenty of disk space on your database server prior to upgrading, as your database may grow to be 300% – 400% in size.

    Action: Connect to your database server using SQL Management Studio Tools, right click your Passwordstate database, and select Properties.  Select the Files Menu and determine which disk drive the database is stored on, and also determine the current size of your database. Check that there is ample space on this drive and free up space if required. 

     

    2022-07-06_8-36-09.png

     

     

    Option #3: Shrink the database and log files to reduce the overall size of the database. 

    Action: Connect to your database server using SQL Management Studio Tools, create a New Query and paste in the following code.  Now click the Execute button:

     

    DBCC SHRINKDATABASE (Passwordstate)

     

    2022-07-06_8-43-43.png

     

     

    Option #4: Confirm your Autogrowth setting is not limited.  If your database has a limit on how much it can grow, this may impact your upgrade.

    Action: Connect to your database server using SQL Management Studio Tools, right click your Passwordstate database, and select Properties.  Select the Files Menu, and check the database is set to Autogrowth.  If it is not, click the Edit button and select Autogrowth and Unlimited as per below screenshot:

     

    2022-07-06_8-49-52.png

     

     

    Option #5: A lot of customers see a build up of Passwordstate auditing data over the years, and this can consume quite a lot of space in the database.  

    Action:  If you generate a lot of auditing records with your usage of Passwordstate, then most likely the majority of the records will be in the AuditingArchive table. To check the number of rows you can run the following queries in SQL Server Management Studio:

     

    USE Passwordstate

    SELECT COUNT(*) FROM AuditingArchive

     

    With our testing, 1 or 2 million records do not pose an issue with the upgrade.  If you have significantly more records than this, please consider backing up and then deleting the records in the AuditingArchive table. Backing up the data first is only required for your own compliance reasons - The decision is yours to backup the data before deleting it.

     

    To backup your AuditingArchive table, right click the Passwordstate database and select Export Data...

    2022-07-06_9-00-18.png

     

    To delete all rows in the AuditingArchive table, run the following command in SQL Management Studio Tools:

     

    USE Passwordstate

    TRUNCATE TABLE AuditingArchive

     

     

     

    Steps to Consider After you Upgrade:

     

    The only step required after upgrading would be to Shrink the database again.  Follow Option #3 above to perform this step.

     

    Regards,

    Click Studios Support

    Mobile App Error: Connection failed, please re-scan the pairing code to try again.

    in Known Issues

    Posted

    If you are attempting to scan the QR code into the Passwordstate App, but you receive the error where it connect connect, try to following troubleshooting items:

     

    Step 1:

    On your phone, open a browser, and try browsing to your AppServer URL.  You will need to see a "200 | Status OK" message.  If you don't your AppServer URL is not available from phone connection.  This could be firewall, or DNS blocking this access.

     

    Step 2:

    Check that you have the AppServer computer name set correctly under Administration -> Authorized Web Servers.  This must be in netbios format, and not FQDN.  If you do not see your server on this page, add it in and try scanning the QR code again.  Ensure you set the Role to be an "AppServer" and the functional riles has Mobiel

     

    2022-04-19_7-47-19.png

     

    2022-04-19_7-47-53.png

     

    Step 3:

    Check the C:\inetpub\PasswordstateAppServer\web.config file "AppSettings" section.  You should not see a line that says the following:

     

    <add key="SetupStage" value="Setup Complete" />

     

    Instead, it should look similar to the screenshot below.  If you see that SetupStage line of code, please remove it and save your web.config file, and try again.

     

    2022-04-19_8-20-13.png

     

    Step 4:

    Update the AppServer module by following Section 6 in this guide, and try scanning the QR code again: https://www.clickstudios.com.au/downloads/version9/Upgrade_Instructions.pdf

     

    Step 5:

    You should also update the Mobile App on your mobile device to the latest version, from either the Play store, or the Apple store.

     

    Step 6:

    Re-query the AppServer SSL public Key by following this forum post, and try pairing again: https://forums.clickstudios.com.au/topic/15380-query-app-server-ssl-public-key-mobile-apps-ios-and-android-connection-issue/

     

     

    Regards,

    Support

    How to run a SQL query when Click Studios support requests some data

    in General Hints and Tips

    Posted

    To help Click Studios with supporting an issue you may have, sometimes we ask you to run "SQL Queries" to retrieve some data from your database.  Below is an example how you can do this.

     

    Step 1:

    Identify where your Passwordstate database is hosted.  You can do this by clicking on Administration Home:

     

    2022-04-07_7-41-06.png

     

    Step 2:

    Open Microsoft SQL Server Management Studio on any machine where you have this installed. If you don't have it installed, you can down load for free from Microsoft: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

     

    2022-04-07_7-49-52.png

     

    Step 3:

    Enter your database name, and select an account that has permissions to connect to your SQL database server.  If you do not have an account that you know of, you can use the SQL account that Passwordstate uses.  You can find the username and password for this account by following this forum post: https://forums.clickstudios.com.au/topic/1655-how-to-find-my-database-server/#:~:text=If you need to get,is c%3A\inetpub\passwordstate.

     

     

    **Note**, in my screenshot below I am using the SQL account that is being used by Passwordstate, so therefore I selected "SQL Server Authentication".  If you were connecting with a domain account instead, choose the Windows Authentication option.

     

    2022-04-07_8-01-00.png

     

    Step 4:

    Now you can create a new query, and paste in the SQL code Click Studios Supplied to you, and execute that query.  You'll see results as per the screenshot below, where you can then copy the data and paste it into an Excel spreadsheet.  This makes it easy for click studios support to read:

     

    2022-04-07_8-08-29.png

     

    Now if you send this data to Click Studios, this will help us determine what the issue is.

     

    Regards,

    Support

    Permalink filter

    in Community Support

    Posted

    Hi Jacob,

     

    The way we've designed permalinks is to take you directly to the record you need, when you click on the hyperlink i.e. Folder, Password List or Password record.

     

    Would it help if you were using a password record permalink, instead of a Password List permalink?

    If you are clicking on Password List permalinks, you can still search/filter within that list, once you are taken to the Password List. We have no way of automatically filtering when doing this though.

    Regards

    Click Studios

    Host matching/selection of Linked Credentials

    in Feature Requests

    Posted

    Hello TJ,

     

    This is how we've designed the Remote Session Credentials, so you can log into systems using the same domain account. If needed, you can click on the Manual Launch button, and search for your other accounts here.

     

    Or if you would prefer them in the dropdown, we could move this request into our Feature Requests section of the forums for you.

    Regards

    Click Studios

×
×
  • Create New...