Differences

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

--- evergreen-admin:sip [2010/08/11 14:49] – sylvar
+++ evergreen-admin:sip [2013/02/20 11:42] – The recommended minimum min_spare_servers should be 1. lazar
@@ Line 2: / Line 2: @@
 Author: Bill Erickson\\
 This is a rough intro to installing the SIP server for Evergreen.
+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=====
-Current SIP code lives at github:
+Current SIP code lives at http://git.evergreen-ils.org:
 <code>
 cd /opt
-git clone git://github.com/atz/SIPServer.git SIPServer
+git clone git://git.evergreen-ils.org/SIPServer.git SIPServer
-</code>
-Or use the old style:
-<code>
-$ cd /opt
-$ sudo cvs -d:pserver:anonymous@openncip.cvs.sourceforge.net:/cvsroot/openncip login
-# when prompted for the CVS password, just hit Enter (sudo password may be req'd)
-$ sudo cvs -z3 -d:pserver:anonymous@openncip.cvs.sourceforge.net:/cvsroot/openncip co -P SIPServer
 </code>
@@ Line 23: / Line 19: @@
     <server-params
         min_servers='1'
-        min_spare_servers='0'
+        min_spare_servers='1'
         max_servers='25'
     /></code>
@@ Line 43: / Line 39: @@
 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 84: / Line 98: @@
   - 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=====