Differences

This shows you the differences between two versions of the page.

--- evergreen-admin:sip [2010/09/08 08:01] – add note re: documentation and github. rsoulliere
+++ evergreen-admin:sip [2011/04/01 08:51] – Permission numbers vary between versions. This code uses the permission code instead. sylvar
@@ Line 3: / Line 3: @@
 This is a rough intro to installing the SIP server for Evergreen.
-NOTE: This documentation is also available in the Evergreen documentation at [[http://libdog.mohawkcollege.ca/evergreen_documentation/draft/html/]]. In github: [[http://github.com/rsoulliere/Evergreen-DocBook/blob/master/1.6/admin/sip.xml]].
+NOTE: This documentation is also available in the Evergreen documentation at [[http://docs.evergreen-ils.org/1.6/draft/html/]]. In github: [[http://github.com/rsoulliere/Evergreen-DocBook/blob/master/1.6/admin/sip.xml]].
 =====Getting the code=====
@@ Line 46: / Line 46: @@
 OR use SQL like:
-<code>
+<code sql>
 INSERT INTO permission.grp_tree (id,name,parent,description,application_perm)
 VALUES (8, 'SIP', 1, 'SIP2 Client Systems', 'group_application.user.sip_client');
-INSERT INTO permission.grp_perm_map (grp,perm,depth)
+INSERT INTO
-VALUES (8,15,0),(8,16,0),(8,17,0),(8,31,0),(8,32,0),(8,48,0),(8,54,0),(8,75,0),(8,82,0);
+  permission.grp_perm_map (grp, perm, depth, grantable)
+SELECT
+  g.id, p.id, 0, FALSE
+FROM
+  permission.grp_tree g,
+  permission.perm_list p
+WHERE
+  g.name = 'SIP' AND
+  p.code in (
+    'COPY_CHECKIN',
+    'COPY_CHECKOUT',
+    'RENEW_CIRC',
+    'VIEW_CIRCULATIONS',
+    'VIEW_COPY_CHECKOUT_HISTORY',
+    'VIEW_PERMIT_CHECKOUT',
+    'VIEW_USER',
+    'VIEW_USER_FINES_SUMMARY',
+    'VIEW_USER_TRANSACTIONS'
+);
 -- VERIFY:
@@ Line 87: / Line 105: @@
   - Syslog-ng expects the logfile to exist so create the file.<code>$ sudo touch /var/log/SIP_evergreen.log</code>
   - Restart syslog-ng <code>$ sudo /etc/init.d/syslog-ng restart</code>
+== syslog-ng(remote logging server) ==
+Use this configuration in the destination server's syslog-ng.conf to filter incoming remote SIP logs into a daily unified SIP.log.  Be sure to modify paths according to your environment.
+<code>
+# --------------------------------------------------------------------------------
+# Destination
+# --------------------------------------------------------------------------------
+destination d_external_sip {                             # f_sip
+file("/var/log/remote/prod/$YEAR/$MONTH/$DAY/SIP.log",
+        template("$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC $HOST $MSG\n") owner(nagios) group(nagios) perm(0644) template-escape(no)); };
+# --------------------------------------------------------------------------------
+# Filter
+# --------------------------------------------------------------------------------
+filter f_sip { match("acs-server"); };
+# --------------------------------------------------------------------------------
+# Log Statement
+# --------------------------------------------------------------------------------
+log { source(s_external); filter(f_sip); destination(d_external_sip); };</code>
+Add the lines below to the syslog-ng.conf on the remote server you wish to forward logs from.
+<code>
+#SIP
+source s_file_sip { file("/var/log/SIP.log" follow_freq(1)); };
+log { source(s_file_sip); destination(d_ext); };</code>
 =====Testing Your Connection=====