This is just a page to practice and learn WikiFormatting.

Go ahead, edit it freely.

How to set up Trac

Installation

Currently we are using Trac 11.1 installed on a Debian OS.
First you need to install ​setuptools. After you download the .egg install it with:

sudo sh setuptools-0.6c9-py2.5.egg

Then you can install Trac executing:

sudo easy_install Trac

• Usefull links

​http://pypi.python.org/pypi/setuptools#installation-instructions
​http://trac.edgewall.org/wiki/TracInstall
​http://trac.edgewall.org/wiki/TracOnDebian

Setting up Postgresql

The trac database is under postgres with user "scs" and schema "trac".

• Usefull links

​http://www.postgresql.org/docs/7.4/interactive/user-manag.html
​http://trac.edgewall.org/wiki/TracEnvironment

Setting up Plug-ins

• Current Plug-ins

AdvancedTicketWorkflowPlugin ​http://trac-hacks.org/wiki/AdvancedTicketWorkflowPlugin
BackLinksMenu ​http://trac-hacks.org/wiki/BackLinksMenuMacro
HudsonTrac ​http://trac-hacks.org/wiki/HudsonTracPlugin
PrivateWikis ​http://trac-hacks.org/wiki/PrivateWikiPlugin
TicketSubmitPolicy ​http://trac-hacks.org/wiki/TicketModifiedFilesPlugin
TracAccountManager ​http://trac-hacks.org/wiki/AccountManagerPlugin
TracCustomRoadmap ​http://trac-hacks.org/wiki/CustomRoadmapPlugin
TracDiscussion ​http://trac-hacks.org/wiki/DiscussionPlugin
TracFullBlogPlugin ​http://trac-hacks.org/wiki/FullBlogPlugin
TracGoogleAnalytics ​http://trac-hacks.org/wiki/TracGoogleAnalyticsPlugin
TracIncludeMacro ​http://trac-hacks.org/wiki/IncludeMacro
TracRecaptchaRegister ​http://trac-hacks.org/wiki/RecaptchaRegisterPlugin
TracSpamFilter ​http://trac-hacks.org/wiki/SpamFilterPlugin
TracTicketDelete ​http://trac-hacks.org/wiki/TicketDeletePlugin
TracTocMacro ​http://trac-hacks.org/wiki/TocMacro
TypedTicketWorkflow ​http://trac-hacks.org/wiki/TypedTicketWorkflowPlugin

Current Trac configuration file attachment:trac.ini​

Permissions and Authentication

anonymous - BLOG_VIEW BROWSER_VIEW CHANGESET_VIEW DISCUSSION_VIEW FILE_VIEW LOG_VIEW MILESTONE_VIEW REPORT_SQL_VIEW REPORT_VIEW ROADMAP_VIEW SEARCH_VIEW TICKET_VIEW TIMELINE_VIEW WIKI_VIEW
authenticated - BLOG_COMMENT BLOG_MODIFY_OWN DISCUSSION_APPEND TICKET_CREATE
team - BLOG_ADMIN DISCUSSION_ADMIN DISCUSSION_APPEND DISCUSSION_MODERATE TICKET_ADMIN WIKI_ADMIN

The authentication uses HtDigestStore with the acct_mgr.web_ui.loginmodule from the TracAccountManager plugin.

---

• Кафе машината - София, Сервиз "БЪЛГАРИЯ СЕРВИЗ" :
  • ул. "Вежен" 25, тел.: 963-22-49;
  • жк "Люлин-10" бл. 149-партер, тел.: 925-08-70, 925-13-22

---

• Sophie2 Server set-up
  • Trac
  • SVN
  • Postgres + migrating the WBS
  • Nexus
  • Buld Server
  • Hudson
  • Testlink

• SCS_REPO_MAINTENANCE, SCS_ISSUE_TRACKER_MAINTENANCE, SCS_BACKUP

• New Server installation and set-up
  • software RAID
  • users + quotas
  • vnc4server instances for all users
  • Eclipse, Java 6, Maven

• Dzver port forwarding.

• Sophie2 web site with Dian.

   [WebMethod]
    public List<City> SearchStates(string userName, string password, string name)
    {
        IWorkspace workspace = Connect(userName, password);

        List<City> resCities = new List<City>();
        IFeatureClass statesClass = (workspace as IFeatureWorkspace).OpenFeatureClass("States");
        IFeatureClass capitalsClass = (workspace as IFeatureWorkspace).OpenFeatureClass("Capitals");
        int nameIndex = capitalsClass.FindField("CITY_NAME");

        IQueryFilter sfs = new QueryFilterClass();
        sfs.WhereClause = "STATE_ABBR = '" + name + "'";
        IFeatureCursor resCursor = statesClass.Search(sfs, true);

        IFeature state = resCursor.NextFeature();
        while (state != null)
        {
            
            ISpatialFilter sfc = new SpatialFilterClass();
            IGeometry buffer = state.Shape;
            sfc.Geometry = buffer;
            sfc.SpatialRel = esriSpatialRelEnum.esriSpatialRelEnvelopeIntersects;

            IFeatureCursor resCursorCy = capitalsClass.Search(sfc, true);
            IFeature capital = resCursorCy.NextFeature();

            while (capital != null)
            {
                resCities.Add(new City(capital.get_Value(nameIndex) as string, 0, 0));
                capital = resCursorCy.NextFeature();
            }

            Marshal.ReleaseComObject(resCursorCy);
            state = resCursor.NextFeature();
        }

        Marshal.ReleaseComObject(resCursor);
        return resCities;
    }