Jauder Ho's dashboard

That did not quite answer my question as I was looking for the path to the file. But looks like I found it.

themes/default/templates/footer.t is the place to stick the analytics code. Just tried it out and it works fine.

I just noticed due to the difference length of #aux-navigation between logged and not logged in states, it renders quite differently (also across different platforms, win, mac).

I have somewhat of a solution for now but would be interested in seeing how others deal with it.

http://help.vurbu.com/

Scott,

Prehaps you should include a blank directory by default and rewrite the directions to change perms/ownership. This did trip me up somewhat the first time.

Okay, I've finished dressing things up so it should be part of the same look and feel now.

I had to do some digging around to get nginx and php to work, especially since there is no php-fastcgi init file. If you are using Debian, ensure that php5-cli and php5-cgi packages are installed.

I found the following links useful for doing setup.
http://drupal.org/node/110224
http://blog.codefront.net/2007/06/11/...
http://www.mail-archive.com/debian-bu...
http://bugs.debian.org/cgi-bin/bugrep...

The following is the nginx config that I am using. As mentioned, it comes with the added bonus of max expires for CSS, Javascript and image files. For even more of a boost, you can turn gzip compression on (see http://tumblelog.jauderho.com/post/27...)

Enjoy!

# the server directive is nginx's virtual host directive.
server {
# port to listen on. Can also be set to an IP:PORT
listen 80;

# Set the charset
charset utf-8;

# Set the max size for file uploads to 10Mb
client_max_body_size 10M;

# sets the domain[s] that this vhost server requests for
server_name help.foo.com;

# doc root
root /var/www/help.foo.com;

# vhost specific access log
access_log /var/log/nginx_access.log main;

# Set image format types to expire in a very long time
location ~* ^.+\.(jpg|jpeg|gif|png|ico)$ {
root /var/www/help.foo.com;
expires max;
break;
}

# Set img, css and js to expire in a very long time
location ~* ^.+\.(css|js)$ {
root /var/www/help.foo.com;
expires max;
break;
}

location ~ \.php$ {
fastcgi_pass 127.0.0.1:9000;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME /var/www/help.vurbu.com$fastcgi_script_name;
include /usr/local/nginx/conf/fastcgi_params;
}

# Catchall for everything else
location / {
root /var/www/help.foo.com;
index index.php index.html;

if (-f $request_filename) {
break;
}

# if (!-e $request_filename) {
# rewrite ^(.*)$ /index.php?q=$1 last;
# break;
# }
}

error_page 500 502 503 504 /500.html;
location = /500.html {
expires 5d;
root /var/www-rails/foo.com/public;
}

error_page 404 /404.html;
location = /404.html {
expires 5d;
root /var/www-rails/foo.com/public;
}
} # end help.foo.com block

One more thing, it would be nice to be able to add Google Analytics code to track who is visiting the help forum. – Jauder Ho, on May 24, 2008 19:02

Scott, you are right. I just removed the ubuntu smarty package and it works fine. I'll follow up with the rest later. – Jauder Ho, on May 24, 2008 19:01

Lane, it's at http://help.vurbu.com/. It's the default install since I have not had time to customize it yet.

I would say that the INSTALL file should point out which css file to modify so that it's more evident.

One side benefit though is that the config I have now properly sets expires and gzip so that things are nice and fast. – Jauder Ho, on May 24, 2008 19:01

Now that things are working, here's a couple suggestions.

There is a typo on http://getsatisfaction.com/company/ad...
It should be "sprinkles-schema.sql" instead of "sprinkles-schema.php".

That page is also somewhat misleading. It took me reading the INSTALL file to realize that I had to install smarty for instance. So I would either rework the text to have people read the INSTALL file or copy the contents over.

Database by default is latin1. utf8 is my preference but this is not a big one.

I did notice that there are no indices for any of the tables. I have not looked at the data structure closely yet but I would imagine this should be defined out of the box.

That's it for now and I'll play more with it later.

Hah! That was it. I had localhost privs while connecting through mysql. On retesting using -h and trying to use sprinkles, it bombed out.

Works now! Awesome. – Jauder Ho, on May 23, 2008 20:06

Scott,

Thanks for the quick followup. I agree it's probably a subtle config issue.

This is what I have in boot.php (small changes to protect the innocent).
$mysql_username = 'toor;
$mysql_password = 'n@@rf!!';
$mysql_db = 'sprinkles';
$mysql_connect_params = '192.168.1.29:3306';

I stuck the code fragment above in admin-findsite.php just before findsite->data.

It currently fails with "Database error looking up current session: No database selected" so it looks like the connect succeeded but it's not getting expected data back from the query.

I am able to do the select from the command line just fine so it's a little strange. I did note that only the background_color column has data (#86fff6) with everything else being null.

On a lark, I dropped and recreated the database but that did not seem to have any effect.

As far as the config goes, I'm running on Ubuntu 8.04 with standard packages for php, smarty, mysql etc. MySQL is set to run in UTF8 (due to my app) but should not affect things (in theory).

nginx is compiled and is at version 0.6.30. fastcgi is started via an init script and bound to port 9000.

PS. I would be happy to do a writeup once I get this working. nginx is my new favorite toy and it just didn't seem right to have to fire up apache or something else just to run this. =)

True. I guess if this were possible as a default opt out with an option to opt in would be good. I'm personally willing to tolerate a little bit of spam for a chance to have conversations with people I wouldn't otherwise know.

Another option is to restrict to friend of friend.

That would be fantastic. Thanks!

My thoughts exactly =) Would be another great way to increase twitter subscriptions.

@quepol - Thanks! I had some momentary panic wondering if I thought this through. =)

Amy, I agree that it is possible and doable right now to directly msg someone by name.

I was just thinking in the context of straight SMS which as quepol points out I can just text message someone via a number. I pretty much access Twitter through a desktop app now and it would be immensely useful to be able to do SMS through the same interface.