Re: [Quickfix-developers] newbie mysql questions

[Clark S. <cla...@ya...>]

There is a small discrepency between the documentation
and the implementation. The default user doesn't
appear to be root. In order to get it to work I must
explicitly include

MySQLStoreUser=root

in the config file. Maybe this has to do with the
mysql version?  I also have to add -u root, to get any
of the mysql batch files, or log ons to work.

--- Oren Miller <or...@qu...> wrote:

> There are two factories you can use.  There is the
> MysqlStoreFactory,  
> and the MysqlLogFactory.  You need to instantiate
> these in your code  
> and pass them to your initiator or acceptor.  This
> is what you would  
> use in place of the FileStoreFactory or
> FileLogFactory.  You will then  
> need to give them the appropriate configuration
> settings:  
> http://www.quickfixengine.org/quickfix/doc/html/ 
> configuration.html#Storage
> 
> The default settings should work with a standard
> default MySQL  
> installation running on the local machine.
> 
> --oren
> 
> On Sep 8, 2004, at 2:04 PM, Clark Sims wrote:
> 
> > well I ran the psql script to create the quickfix
> database. I can get  
> > into the database, and type "show tables". Once in
> the database when I  
> > querry sessions,  "select * from sessions;"  I get
> :
> >
> > mysql> select * from sessions;
> >
>
+-------------+--------------+--------------+---------------------
> 
> > +-----------------+-----------------+
> > | beginstring | sendercompid | targetcompid |
> creationtime        |  
> > incoming_seqnum | outgoing_seqnum |
> >
>
+-------------+--------------+--------------+---------------------
> 
> > +-----------------+-----------------+
> > | FIX.4.2     | SETGET       | TEST         |
> 2004-06-22 07:36:48 |
> >   1 |               1 |
> >
>
+-------------+--------------+--------------+---------------------
> 
> > +-----------------+-----------------+
> > 1 row in set (0.00 sec)
> >
> > This is a very old session. I guess I am not using
> mysqlstorefactory.  
> > How do I turn this option on?  Do I need something
> like:
> >
> > MySQLStoreDatabase    quickfix
> >
> >  in the config file?  Do I need to write something
> in the C++ code to  
> > turn on mysqlstorefactory?
> >
> > Thanks in Advance,
> >
> > Clark Sims
> >
> >  
> >
> >  
> >
> > Do you Yahoo!?
> >  Win 1 of 4,000 free domain names from Yahoo!
> Enter now.



		
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail