Welcome to the Casa de Pacopablo
This is the hideout of the crazy gringo, pacopablo.
Blog
Trac Hosting on the Cheap
As happens from time to time, the question of Trac hosting was raised on #trac
| [07:46:38] | <hendrixski> | anybody recommend any trac hosting? |
| [07:48:20] | <hendrixski> | we're currently hosting our own, and while it's not hard ... it's time consuming |
| [07:48:33] | <jhammel> | hendrixski: what is the time consuming part? |
| [07:49:01] | <hendrixski> | we installed some plugin, which caused something to work not as we wanted, and undoing it is taking more than an hour or so |
| [07:49:16] | <hendrixski> | and... honestly, an hour of developer time a month... and it's worth having someone else host it |
| [07:49:26] | <jhammel> | hendrixski: i'm not sure if any hosting company provides that level of support |
| [07:51:19] | <fission6> | how do i execute wiki-macros as another user besides apache, can i specify |
| [07:51:32] | <jhammel> | hendrixski: actually, its a business i'd like to get into, but am not prepared to quite yet |
| [07:53:00] | <hendrixski> | jhammel: I'd pay for it |
| [07:53:20] | <hendrixski> | I love trac, I just don't like having to configure the email, plugins, etc. etc. |
| [07:53:48] | <jhammel> | hendrixski: i wish i could take you up on that offer; too disorganized right now :( |
| [07:54:04] | <jhammel> | hendrixski: maybe in a month, if you still need it...still getting my own hosting story straightened out |
| [07:56:31] | <achilles> | I am looking for someone who would like to HOST and CONFIGURE TRAC |
There are many options for Trac Hosting. The issue is really figuring out which ones are good. I tried out Repository Hosting today and I was impressed. Some of the features that impressed me are:
- Very nice theme work
- Nice and snappy response
- ...
SQLAlchemy: Calling MS SQL Stored Procedure with Output Parameters
SQLAlchemy is generally a wonderful ORM and database toolkit for Python. Personally, I think it's the best one in the Python landscape. However, there are some things that tend to be a little troublesome.
Some of these are simply due to the difference between a relational database and an object oriented language. Others, however, are due to RDBMS specific quirks.
The problem I encountered recently was how to call a stored procedure in MS SQL from SQLAlchemy. In general, the ...
T-SQL Tidy.com: Awesome!!
Digging through Dynamics: GP stored procedures is painful, to say the least.
When you pull the SQL out of the database via SQL Server Management Studio it is one LONG line. No formatting, nothing. Reading the TSQL as one line isn't really an option. Reformatting it by hand takes FOREVER.
Fortunately, there is a wonderful online formatter over at TSQLTidy. It can transform the GP stored procedures into something that can actually be parsed by a human brain. [ http://www.t ...
Dynamics: GP 10 Manufacturing -- How Not To
Having recently upgraded from GP8 to GP10 and having switched from Horizons Manufacturing to GP: Manufacturing, I wanted to lay out a few do's and don'ts for anyone else considering a switch. Hopefully the below will save you some of the headache.
- Take The Defaults: As with pretty much all Microsoft products, accepting the defaults is prudent and nigh a necessity. If you simply take the defaults and use the software exactly as designed, you'll have an acceptable experience.
- ...
Dell Express Service Code Program
When you buy a Dell with Windows on it, you get a little program pre-installed that will tell you the service code of your machine. This is a handy little tool for tech support, especially if your machine is in a hard to reach location. Simply fire up the program and BAM! There is your service tag
Today I was cleaning up a PC today getting it ready to cycle it out of the company. In my hacking and slashing of data, I deleted the dell directory in which the Service Tag program resides. Not a huge d ...
Authenticate Trac Against phpBB
So, Chuck, over at Cobra wanted to get his trac site up and running and was wondering about using the exisiting accounts that people had in the phpBB3 forums. Trac being Python, and phpBB being, obviously, PHP, there was no stock way of accomplishing this.
First, Trac's authentication meme is basically: get someone else to do it. Generally speaking, this is the web server. That's all fine and dandy, but some people want a bit more. Thankfully, [htt ...
15 Character Limit
Let's establish some facts.
- MS SQL Server 2005 allows the sa password to be longer than 15 characters.
- MS Windows XP allows a password longer than 15 characters.
Given these two facts, one would assume that Microsoft has a policy of allowing arbitrary length password (or at least really long ones). However, if one were to assume this, one would be wrong.
Microsoft's Business Solutions - Great Plains 8 does NOT allow passwords longer than 15 characters. I'll admit that GP8 is a bit ...
!PyCon 2008 - Here I Come!
PyCon is March 14th through 16th with the 17th through 20th being open for sprints. PyCon was a blast last year, thanks to Financial Aid from the PSF. Thankfully, my employer is sending me this year. I'll be taking t ...
Populating ''Assign To'' Drop Down in Trac
When configuring a Trac environment, you can set the following option:
[ticket] restrict_owner = true
This will change the Assign To ticket filed into a select box that only contains existing users. However as it says on the TracTickets page, the user must have logged, in at least once, and set their email address.
If you run multiple Trac sites, and have a set of common users across all Trac ...
htpasswd with Python
As many Apache users know, the htpasswd1 is used to create a file with username/password pairs. The format for the file is simply a username, colon, encrypted password. For example:
foo:oNAU4bgeqQHt2
The username is foo and the password is bar encrypted with a salt of oN2
Now, there are good reason why an admin m ...
Thanks to coderanger, we will always know what day Easter is. :)
2010-04-04
As is evidenced by the lack of modification of the logo at the top of the page, this site is run on trac. It is a great piece of software that provides a wonderful plugin system. The "official" site for plugins and other modifications to trac is trac-hacks.org. Go check it out.
