What is a Blacklist?

A list of cards that are denied for authentication on the BioStar device. When a card is lost or stolen, misuse can be prevented by registering the card ID on the blacklist.



Why would you want to delete a blacklisted CSN card?

In BioStar 2, if you;

  • Block (blacklist) a CSN card and then delete the card
  • Block (blacklist) a CSN card and then delete the user

In such cases, you cannot reuse this card because the card remains in the Blacklist, and there is no way to delete it from the list. 


The best way to prevent such problems is to delete the user after unblocking the card, so please keep that in mind.


In a future version of BioStar 2, you will be able to delete such Blacklisted cards within the UI, but for now, you can use the temporary solution below to delete the Blacklisted card. 

Note: This solution only applies to CSN cards.


How to delete all blacklisted Cards (BioStar 2.8+ but will work on older)


1. From version 2.8 onwards, Values within the t_usr and t_crd tables are encrypted, so can be a problem when trying to search values such as below.


2. A way around this will be to delete all blacklisted cards within the table. To accomplish this, connect to the database

* refer to the following article if you do not know how to access your Maria Database 


3. Once connected to the database, run the below query:  


use biostar2_ac;
set SQL_SAFE_UPDATES = False;
DELETE FROM T_BLKL;
UPDATE T_LSTSYNSTA SET BLKL = 0;

set SQL_SAFE_UPDATES = True; 


4. Once complete, an output should prompt for how many lines were affected


5. If you now login to BioStar 2, all blacklisted cards should be removed!


BioStar 2.3~2.5


Note: The information below is for Maria DB type, the default database of BioStar 2. 


If you would like to run the query on a database management program manually, you can manually run the query below. 


start transaction;
USE biostar2_ac;
DELETE 
FROM T_BLKL 
WHERE CRDUID = (SELECT CRDUID
FROM T_CRD
WHERE CRDCSN='134149339' ) ;
UPDATE T_LSTSYNSTA SET BLKL = 0;
COMMIT;


Enter your card number in '134149339' and run the query.  


If you would like to run a script without installing a database management program, you can use the attached .bat file. 

Change the file extension to .bat and run it with administrator privileges on the PC with the database. 




BioStar 2.2.1 and Lower Versions

Caution: This process makes direct changes to your database, so please back up your database before proceeding [BioStar 2] Database Backup and Restore Instructions



Procedure

1. Find the card CSN in Setting > Card > Blacklist Card and write the number down. 

2. Stop BioStar 2 service in BioStar Setting.


3. Download SQLite Expert Personal 32bit. (http://www.sqliteexpert.com/download.html

4. Install the program. 

5. Run the program. 

6. Open the DB file by clicking File > Open Database > C:\Program Files (x86)\BioStar 2\db\biostar2

7. Paste the query below and change the '1927837329' below to your card’s CSN number.


BEGIN TRANSACTION;
DELETE 
FROM T_BLKL 
WHERE CRDUID = (SELECT CRDUID
FROM T_CRD
WHERE CRDCSN='326429182384' ) ;
UPDATE T_LSTSYNSTA SET BLKL = 0;
COMMIT;


8. Click Execute SQL


9. Start BioStar 2 service in BioStar Setting

10. Check if the Blacklisted card has been deleted from Setting > Card > Blacklist Card.