Re: [Gnumed-devel] oscar fiddling

[James Busser]

On Jun 30, 2006, at 1:45 AM, Syan Tan wrote:
> I couldn't find the password.

The default, as displayed by the hash in the partial table dump  
below, is the same (mac2002) for each of oscarrep (reception),  
oscardoc (doctor with administration privileges) and oscaradmin.  
However attempts to login oscarrep or oscaradmin will generate an  
error because the cvs tables ship without their having had a defined  
role --- once this is known, it can be easily reset within the oscar  
app by logging in as oscardoc and using the Admin menu which appears  
at far right.

mysql> select * from security;
+------------ 
+------------------------------------------------------------------ 
+------
| user_name  | password                                           |  
provider_no | pin  |
+------------ 
+------------------------------------------------------------------ 
+-------
| oscarrep   | -51-282443-97-5-9410489-60-1021-45-127-12435464-32 |  
999999      | 1117 |
| oscardoc   | -51-282443-97-5-9410489-60-1021-45-127-12435464-32 |  
999998      | 1117 |
| oscaradmin | -51-282443-97-5-9410489-60-1021-45-127-12435464-32 |  
999997      | 1117 |
+------------+---------------------------------------------------- 
+-------------+-------