Which users are currently logged into NorthStar
grep -e "Succesfull logon" -e "logged out" /var/log/tomcat5.5/useradministration/useradministration.log
Find user name/email
mysql -h 127.0.0.1 -u northstar -p --execute 'select useraccount.username,user.firstname, user.lastname, user.email FROM useraccount INNER JOIN user ON user.id= useraccount.userid WHERE useraccount.username="astroandrey";' useradministration
Users cannot react to proposal invitation
This is normally caused by a difference of the email address specified by the inviting person and the email address actually used by the invited person.
Workarround: table invitations contains the unaccepted invitations. Find the ones for the proposal in questions and make note of the memberIDs.
These memberIDs will appear in the table nonregisteredmembers. Find the record corresponding to the person having trouble with the invitation. Delete this record from nonregisteredmembers.
Now goto database useradminstration table user and find the userID of the person having trouble. Make note of the userID.
Table registeredmembers contains the members that have already accepted the invitation. Insert a new record using the userID and memberID obtained in the steps above.
Finally go to table invitations and delete the record corresponding to the memberID in question.
The user should now see the proposal when they log into NorthStar
Add/change receiver information
edit:
/var/lib/tomcat5.5/webapps/localhost/proposal/conf/modules/effelsberg/effelsberg-options.xml
Note:
The file contains two contexts (regular, Target of Opportunity). All changes need to be done in both context sections.
Order of proposal categories when starting a new proposal
The proposal categories are read from the database and are stored internally as a TreeSet. Therefore the order is determined by Java's compareTo operator. Practially that means that categories appear in alphabetical order with capital letters being first. If the default behaviour is to be changed the SetUpSelectTelescpopeAction in the northstar-web-lib needs to be overridden:
northstar-web-lib/src/eu/radionet/northstar/control/telescope/SetUpSelectTelescopeAction.java
