FogBugz Posts

MySQL corruption

Sunday, October 05, 2008 by Michael H. Pryor
We have a fair number of customers who contact us with MySQL corruption horror stories.  Hopefully this blog article will help them recover their database.
Categories: FogCreek | FogBugz
Actions: E-mail | Permalink

FogBugz on Windows 2008

Thursday, October 02, 2008 by Michael H. Pryor

FogBugz 6.x will work fine on Windows 2008.  The only things you need to do are

  1. Install IIS 7 (it doesn't come preinstalled) and check off the boxes for .NET/ASP/CGI/etc


  2. Disable DEP by typing "bcdedit.exe /set {current} nx AlwaysOff" on a command prompt.


Categories: FogCreek | FogBugz
Actions: E-mail | Permalink

Using Excel Refreshable Web Queries with FogBugz

Wednesday, October 01, 2008 by Rich Armstrong
Customers often write in asking how to get FogBugz data into Microsoft Excel.  Though we do want to provide the ability to export data from FogBugz to Excel, it's still some way off, but that doesn't prevent you from using the two products together.  Excel has a "refreshable web query" functionality that will allow you to pull data from FogBugz into Excel rather than pushing.  Here's how you do it:
  1. Bring up IE and log into FogBugz, selecting "Remember Me"
  2. Figure out your data. Bring up a list of cases that reflects what you want to report.
  3. Copy all. Ctrl+A, Ctrl+C.
  4. Open a new Excel sheet and paste.
  5. Before you do anything else, look in the lower-right corner of the screen. There should be a little clipboard icon there. Click it and select "Refreshable Web Query".
  6. A box should pop up with a mini browser window. Click the yellow arrow next to the list of cases, changing it to a green check box, and click Import.
  7. The report should come up in Excel. This will be a live report that can be refreshed to reflect the current state of the data. To freeze this report in time, select Data > Properties and uncheck all the refresh options, or Data > Connections and remove any connections you find.
Categories: FogBugz
Tags: , ,
Actions: E-mail | Permalink

Typo3 Plugin for FogBugz case submission

Thursday, September 25, 2008 by Michael H. Pryor

Morten Nisker, from the CS dept at Aarhus University, has created a FogBugz plugin for the CMS Typo3.

All of the Feedback Links on the website send a new case message via the API to their FogBugz installation.

Categories: FogBugz
Tags:
Actions: E-mail | Permalink

How do I back up my FogBugz database?

Tuesday, September 23, 2008 by Michael H. Pryor

On Demand

If you are using FogBugz On Demand, there is no need for you to back up your database.  We are constantly taking snapshots of your database and shipping them to our other data centers in case of a catastrophe.  We are also taking nightly backups.  You can read more about our FogBugz On Demand Infrastructure on our website.  If you still need to grab a backup for testing purposes, or reporting purposes, you can do so by going to Settings->Your FogBugz On Demand Account.  You'll find a link there which allows you to download your database.

 



Microsoft SQL Server

Microsoft has a knowledge base article on how to back up your SQL Server database.  You can find the physical server your database is on by looking under Settings->Site->Database tab in FogBugz.

MySQL

MySQL has a knowledge base article on how to back up your MySQL database.  You can find the physical server your database is on by looking under Settings->Site->Database tab in FogBugz.

Access

To make a backup of your Access database, you just need to copy the .mdb file you are using.  You can find the physical location of your database by looking under Settings->Site->Database tab in FogBugz.

Categories: FogBugz
Tags:
Actions: E-mail | Permalink

Entourage 12.1.2 and FogBugz On Demand Lost Passwords

Friday, September 05, 2008 by Rich Armstrong

A patch has recently been released for Microsoft Office 2008 for Mac that has us breathing a bit easier, or would, if we could have everyone who used MSOffice 2008 for Mac install it.

If you use Entourage to handle your mail and have tried to get our FogBugz On Demand servers to send you a link to reset your password, you might've gotten something like this:

http://entoutrage.fogbugz.com/?pg=pgDemandPass=1=asdf123

This is a non-working URL due to the way Entourage handles ampersands in mail.  The real URL should look more like this:  

http://entoutrage.fogbugz.com/?pg=pgDemandPass&ixPerson=1&x=asdf123

If you're getting invalid password reset links and use Entourage, you should update to 12.1.2 take advantage of the latest fixes. 

If that's not an option, you can copy the link to a text editor and just insert the missing portions.  Add "&ixPerson" before the second equal sign, and "&x" before the third, then paste that into your browser.

We've gotten one report that the MH-E interface to the MH mail system has the same issue.  Again, this is an issue with the handling of ampersands in email.  We're not sure if a fix will be coming out for that system.

Categories: General | FogBugz
Tags:
Actions: E-mail | Permalink

FogBugz in Chrome

Thursday, September 04, 2008 by Ben Kamens

Update: FogBugz 6.1.36 has been released in order to fully support Google Chrome! 

To all those FogBugz users who've already switched to Google's Chrome browser and are enjoying its blazing speed: rest assured that we are working on improving the few pieces of FogBugz which are not yet fully Chrome-compatible. 

We know of the following issues when using Chrome to browse FogBugz:

1) FogBugz autocomplete dropdown lists are not supported.
2) Clicking inside the search bar doesn't bring up Recent Searches.
3) FogBugz keyboard shortcuts are slightly buggy.
4) FogBugz is too fast.

We are already working to resolve these issues (except the last one), but feel free to let us know if you discover any other problems.

Categories: General | FogBugz
Actions: E-mail | Permalink

FogBugz Leopard and Mampstack

Wednesday, August 06, 2008 by Michael H. Pryor

Stefan from WuffWuffWare.com sent us instructions on getting FogBugz installed with Mampstack and I wanted to make sure they were available in case someone else was attempting the same:

Install BugFogz on Leopard 10.5.4 inside Bitnamis Mampstack

  • The MacOS X machine is a vanilla machine with all the current software updates and a single user called admin
  • WebSharing is off, so we dont interfere with the MAMPStack
  • IP-Adress for that example is 192.168.178.199

INSTALL THE MAMPSTACK FROM BITNAMI

  • Download the current MAMPStack from www.bitnami.com
  • For this documentation we use MAMPStack 1.0-beta-1
  • Install Bitname MAMPStack to /Applications/mampstack-1.0-1
  • Give MAMPStack database a root user password


The for the sake of simplicity:
sudo ln -s /Applications/mampstack-1.0-Beta-1 /Applications/mampstack

Until FogBugz has some settings for the path of PHP:
sudo mv /usr/bin/php /usr/bin/php-orig
sudo ln -s /Applications/mampstack/php/bin/php /usr/bin/php
sudo ln -s /Applications/mampstack/php/bin/pear /usr/bin/pear
sudo ln -s /Applications/mampstack/php/etc/php.ini /etc/php.ini


In /etc/php.ini change:
- Replace all mampstack-1.0-beta-1 with mampstack

In /Applications/mampstack/apache2/conf/httpd.conf change:
- Replace all mampstack-1.0-beta-1 with mampstack
- Listen 80
- ServerName localhost:80

In /Applications/mampstack/ctlscript.sh change:
- Replace all mampstack-1.0-beta-1 with mampstack

In /Applications/mampstack/apache2/scripts/ctl.sh search for 8080 and 
change the message to “httpd started”

Change into /Application/mampstack
cd /Applications/mampstack
sudo ctlscript.sh stop
sudo ctlscript.sh start apache

The apache-Daemon is started as super user, so it can bind port 80 !

In a web browser: go to http://192.168.178.199 and the BitNami Welcome 
message should be shown to you

Now we start mysql with:
cd /Applications/mampstack
./ctlscript.sh start mysql

Be aware, that the server is now only started manually: to make this 
happen at system startup and without being logged in: see below.

INSTALL FOGBUGZ

Now we continue with the installation instructions of fogbugz at:
  1. PHP requirements
    http://www.fogcreek.com/FogBugz/docs/60/topics/setup/MacSystemRequirements.html

    create that test.php file in /Applications/mampstack/apache2/htdocs

    The page http://192.168.178.199 should display the required content.

    You might have to add a php after <? to make it work)
    also the echo -r - stuff should return the required value in the shell
  2. CURL requirements: Curl is installed (on my machine with curl 7.16.3
  3. The MONO framework: Download it from the given web page and install it

FIX THE FOGBUGZ INSTALLATION

Now download FogBugz from your order. I used version 6.1.30 for Macintosh.

Try to install it.

The install will fail. Now we have to fix that following the instructions in
http://www.fogcreek.com/FogBugz/docs/60/topics/setup/MacWhatSetupDoes.html

  • Go to /Library/WebServer/fogbugz.install
    • cd /Library/WebServer/fogbugz.install
    • sudo ./install.sh and answer the questions of PEAR for installation with y
    • the automatic restart of apache and the changes to /etc/apache2/httpd.conf will fail: We have to fix that manually
    • you have to stop the web sharing with sudo apachectl stop
  • Edit /Applications/mampstack/apache2/conf/httpd.conf and add the following line:
    • Include "/opt/fogbugz/Accessories/fogbugz.conf"
  • Make fogutil.so available:
    • mkdir /Applications/mampstack/php/lib/php/extensions
    • cp /opt/fogbugz/Accessories/fogutil.php5.2-mac-dynamic.so /Applications/mampstack/php/lib/php/extensions/fogutil.so
  • Fix the permissions a little. In my case:
    • sudo chmod -R admin /opt/fogbugz
    • sudo chmod u+x /opt/fogbugz
    • sudo chmod -R o-wx /opt/fogbugz/Website
    • sudo chmod -R u-w /opt/fogbugz/Website
    • sudo chmod -R o-wx /opt/fogbugz/Accessories
    • sudo chmod 554 /opt/fogbugz/Accessories/fogbugzmaintd
    • sudo chmod 444 /opt/fogbugz/Accessories/fogbugzmaintd.php
    • sudo chmod 664 /opt/fogbugz/Accessories/application.data
  • And then, because I am not a unix guru, and I just want this to work:
    • sudo chmod -R a+rwx /opt/fogbugz/Website
    • sudo chmod -R a+w /opt/fogbugz/Accessories
    • sudo chmod o+x /opt/fogbugz/Accessories
  • Restart apache via: sudo /Applications/mampstack/ctlscript.sh restart apache
  • Go to a browser and open http://192.168.178.199/fogbugz/install1.php
    • If this returns an error: the systems web server is runnung you have to stop that via sudo apachectl stop
    • If this returns an error: “Forbidden”, then the permissions are not set correctly
  • Follow the instructions, which should succeed
  • Fogbugz showed me an arror with my PHP settings about:
    • max_allowed_packet
    • Add the following line in /Applications/mampstack/mysql/my.cnf after
      [mysqld]

      max_allowed_packet=50M

MAKE IT STARTING AT SYSTEM STARTUP TIME

a.) Create a file as super user at /Library/LaunchDaemons/com.bitnami-apache.service.plist

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
        <key>Label</key>
        <string>com.bitnami-apache.services</string>
        <key>LaunchOnlyOnce</key>
        <true/>
        <key>OnDemand</key>
        <false/>
        <key>ProgramArguments</key>
        <array>
                <string>/Applications/mampstack/apache2/scripts/ctl.sh</string>
                <string>start</string>
        </array>
        <key>RunAtLoad</key>
        <true/>
        <key>UserName</key>
        <string>root</string>
</dict>
</plist>


b.) Create a file as super user at /Library/LaunchDaemons/com.bitnami-mysql.service.plist

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
        <key>KeepAlive</key>
        <true/>
        <key>Label</key>
        <string>com.bitnami-mysql.services</string>
        <key>Program</key>
        <string>/Applications/mampstack/mysql/bin/mysqld</string>
        <key>ProgramArguments</key>
        <array>
                <string>--user=admin</string>
        </array>
        <key>RunAtLoad</key>
        <true/>
        <key>Umask</key>
        <integer>7</integer>
        <key>UserName</key>
        <string>admin</string>
        <key>WorkingDirectory</key>
        <string>/Applications/mampstack/mysql</string>
</dict>
</plist>


c.) Create a file as super user at /Library/LaunchDaemons/com.bitnami-fogbugz.service.plist

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
        <key>Label</key>
        <string>com.bitnami-apache.services</string>
        <key>LaunchOnlyOnce</key>
        <true/>
        <key>OnDemand</key>
        <false/>
        <key>ProgramArguments</key>
        <array>
                <string>/Applications/mampstack/apache2/scripts/ctl.sh</string>
                <string>start</string>
        </array>
        <key>RunAtLoad</key>
        <true/>
        <key>UserName</key>
        <string>root</string>
</dict>
</plist>


d.) Load the files into launchd via:
sudo launchd load -w /Library/LaunchDaemons/com.bitnami-apache.service.plist
sudo launchd load -w /Library/LaunchDaemons/com.bitnami-mysql.service.plist
sudo launchd load -w /Library/LaunchDaemons/com.bitnami-fogbugzd.service.plist


Categories: FogBugz
Tags: , ,
Actions: E-mail | Permalink

Full Screen Wiki Editing

Monday, July 28, 2008 by Joel Spolsky

Frustrated by wasted screen real estate when you're editing Wiki articles in FogBugz?

Try Chas's Greasemonkey script.

Full Screen Wiki Editing in FogBugz

Categories: FogBugz
Actions: E-mail | Permalink

Review of FogBugz

Wednesday, June 11, 2008 by Joel Spolsky

Carson McComas reviews FogBugz: "Its genius is in its maturity. It is mature, seasoned, and polished software that makes tracking multiple issues with difficult sticky elements not just easy, but enjoyable. You know software is great if you still love it, and use it heavily after several months. Now I can't live without it."

Carson's site is at WorkHappy.net.

Categories: FogBugz
Actions: E-mail | Permalink

C# wrapper for the FogBugz API

Wednesday, June 11, 2008 by Eric Nehrlich

One of our customers wanted to use the FogBugz API from C#, but the API was only available via a REST interface.  So they wrote a C# wrapper around the FogBugz API to let them do what they wanted, and was gracious enough to share it with us.  You can download it from this link, which also includes a description of how it works.

Categories: FogBugz
Tags:
Actions: E-mail | Permalink

Fluid

Wednesday, June 11, 2008 by Joel Spolsky

If you're a Macintosh user, check out Fluid, which lets you create custom icons in the dock for websites you visit a lot.

Indiekid created a high-res fluid icon for FogBugz:

Categories: FogBugz
Actions: E-mail | Permalink

Git Integration

Thursday, May 08, 2008 by Michael H. Pryor

John Reilly has created integration between Git and FogBugz, which is available for download.

 

 

Categories: FogBugz
Tags:
Actions: E-mail | Permalink

Rails plugin for FogBugz

Thursday, April 24, 2008 by Eric Nehrlich
One of our customers, Caio Chassot, wrote a plugin for Rails that will let a Rails app submit bugs directly to a FogBugz installation by using BugzScoutCheck it out!
Categories: FogBugz
Tags:
Actions: E-mail | Permalink

WorkingOn is still working on FogBugz

Monday, April 21, 2008 by Michael H. Pryor

Daniel Schaffer has a new version of his FogBugz add on out. Check out WorkingOn v 1.3...

 


Categories: FogBugz
Actions: E-mail | Permalink