# Possible to add request IP column in session table?

**URL:** <https://www.ruby-forum.com/t/possible-to-add-request-ip-column-in-session-table/134564>\
**Category:** Rails\
**Created:** [April 12, 2008, 1:25am UTC](https://www.ruby-forum.com/t/possible-to-add-request-ip-column-in-session-table/134564 "2008-04-12T01:25:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![S-gw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@S-gw](https://www.ruby-forum.com/u/S-gw)\
**Post date:** [April 12, 2008, 1:25am UTC](https://www.ruby-forum.com/t/possible-to-add-request-ip-column-in-session-table/134564/1 "2008-04-12T01:25:20Z")

</div>

Is there a way to add a column in the session table (using MySQL) to  
record the requester’s IP address?

Or possibly extend the session code to write to another table or log  
file that I could use to correlate session and requester IP address.

I need this short term for a debugging task.

– gw

---

<div class="post-metadata">

**Author:** ![S-gw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@S-gw](https://www.ruby-forum.com/u/S-gw)\
**Post date:** [April 12, 2008, 10:35am UTC](https://www.ruby-forum.com/t/possible-to-add-request-ip-column-in-session-table/134564/2 "2008-04-12T10:35:17Z")

</div>

The easiest way may be to add a “before\_filter”,

class ApplicationController \< ActionController::Base

before\_filter :save\_request\_ip

def save\_request\_ip  
session[:request\_ip] = request.remote\_ip  
end  
protected :save\_request\_ip

# :

# :

# rest of your ApplicationController code

# :

# :

end

Then read back the value from session[:request\_ip] as needed.

The requester’s IP may change from request to request, if they have  
IP’s assigned dynamically, for example. Not quite clear how this would  
be a “short term debugging requirement”. Also may require browser has  
“cookies enabled”, depending on what you’re up to.

Stephan

On Apr 11, 4:25 pm, Greg W. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)