11-07-2011, 10:51 AM
(This post was last modified: 11-07-2011, 10:52 AM by alcoholahmed.)
This is a method allows SIS Admins to create/modify their SIS user`s profiles
:Quote:-----------------------------------------------------------
if you just want to import the working file, skip to 14.
-----------------------------------------------------------
this works
This is what I used and got it to work. Let me know if it works for you, if it does I'll post these instructions for all. I used my original my.ini file.
This was done a fresh install on a pc that had never had sis before, I haven't yet tried it on one with existing sis.
Once I got "mysql" running I kept getting error messages with the way it was typed to use "N050" for everything, so I changed it to "ADMIN" and it worked.
dustymech
1.-Run SIS once, do not try to login, shut it down. You need to shutdown the SIS tray icon also
2.-copy initroot.txt to directory "C:\Program Files\Caterpillar Inc\SIS\database\".
3.-Open a command prompt shell and enter the following command:
"C:\Program Files\Caterpillar Inc\SIS\database\bin\mysqld-max-nt.exe" --defaults-file="C:\Program Files\Caterpillar Inc\SIS\database\my.ini" --init-file="C:\Program Files\Caterpillar Inc\SIS\database\initroot.txt" --console
4.-Open another command prompt shell and enter the following command:
"C:\Program Files\Caterpillar Inc\SIS\database\bin\mysql.exe" -u root --password="N050"
5.-The "mysql>" prompt will appear. One by one, enter the following commands
insert sisdata.lnkpassworddetails set adminuserid='ADMIN', password=md5('N050'), applicationindicator='d';
insert sisdata.lnkdealerpreferences set dealercode='ADMIN', portnumber='6000';
insert sisdata.lnkdealerprofile set dealercode='ADMIN', profileid='PI012';
insert sisdata.masdealer set dealercode='ADMIN', msid='ENGINE', dealername='ADMIN', noofusers=100, languageindicator='E';
insert sisdata.masprofiledealer set profileid='UI001', dealercode='ADMIN', profiledescription='ADMIN';
exit;
6.-Close the command prompt shells and shutdown the process "mysqld-max-nt.exe" using the Windows Task Manager.
7.-Run SIS,
8. -goto User Administration
9. -(case sensitive) use "ADMIN" as the dealercode and "N050" as the password to setup your users.
10.- User Administration
A. ENTER A SHORT SIMPLE USER ID - cat
B. ANY PASSWORD - 123123
C. real name - person
D. job description - fixer
E. user type - R Regular users
F. interface - Advanced
G. profile - UI001 ADMIN
H. use WTS Logic: - Yes
I. SIS Router Login ID - cat - usually same as USER ID
J. SIS Router Dealer Code - abcde
k. SAVE
11.- optional
A. EXPORT USER
B. SELECT - cat
C. EXPORT
12. A. right click on sis icon in task bar, click ( service information system )
B. use login ID ( cat ) password ( 123123 )
c. read license agreement
D. 1. a. select ( caterpillar authorized OEM )
E. bottom of page select ( YES )
13. not really needed ( BUT YOU CAN ADD ANOTHER PROFILE IF YOU WANT TO )
13.A. - (case sensitive) dealer code to login "ADMIN"
13.B. - (case sensitive) password is "N050" to setup another user.
13-C. - add users profile
13-D.- automatically add all , give description, new profile id is UI001
13-E.- click all, ok, all, all <- in that order, when all are highlighted
13-F.- save
user's profile
--------------------------------------------------------------------------------------------------------------
14.
A. START SIS
B. RighT click on sis icon in task tray ( yellow and black )
C. service information system
D. web page opens, click ( import SIS users )
E. browse
F. find the file ( SISUsers_cat.xml
G. load ( put check in box), click ( import )
H. login ( you may have to shut down sis and/or reboot pc before you can login )
I. login will be
Login ID: cat
password: 123123
--------------------------------------------------------------------------------------------------------------
sis user administration login (case sensitive)
Dealer Code: ADMIN
Password: N050
---------------------------------------------
SIS User Administration
Add User
User Details
User ID: - cat
Password: - 123123
Confirm Password: 123123
Real Name: - person
Job Description: fixer
User Type: - R Regular Users
Interface: - Advanced
Profile: - UI001 ADMIN
Windows Terminal Server Settings
Use WTS Logic: yes
SIS Router Login ID*: cat
SIS Router Dealer Code: abcde
* (Typically DBS/DBSi Login ID)
--------------------------------------------------------------------------------------------------------
attached are both an admin & user XML files.