Datasource as Client Store

[900spg]

I'm trying to switch my client variable storage from the cookies to a mysql
database. I used the CFMX7 Administrator to create the tables in a new schema
and the tables exist but after half a day I have yet to find any records in the
two tables. Am I missing so part of making this change? It appears that CF is
still using the registry even though I do not have any application.cfm files
that override the admin settings?

[ke4pym]

After you create it, you've still got to go back and actually select that store
as your client store and then apply it. I don't remember if you need a server
reboot or not.

Also, if your code is forcing variables into session scope then nothing will
be written to your db.

[900spg]

Hi je4pym,
Thanks for the response to my question. After creating I did select the
database client store and applied the settings. I have a third party web store
and forum that both seem to require client variables because if I set the
setting for client variables to none both pages give an error that they need
client variables and the administrator is set to none.

A little more background on the situation. My site had been using the registry
for client variables for the last 9 months. The registry grew considerably and
seemd to be causing performance issues on the server. I changed the client
variable setting to cookies a week or so ago and used the clientvarpurge
template available from adobe. Yesterday I created the tables in my database
using the ColdFusion Administrator and set the client variables to use this as
the client variable store.

It now appears that I have client variable in my registry and I can not get
any to be written in the database. Looking through the log files I do not see
anything that would seem to point out the issue.

[ke4pym]

Have you tried restarting the server?

[900spg]

I have tried restarting the server and recreating the db client store tables.
When I set my client variables to cookie my forum software is able to remember
my username and password when I check the box requesting the values to be
remembered. As soon as I switch the client variables to be set in the db the
forum software is no longer able to remember my username and password and I
never get any records written to the client variable tables.