Thread: [Quickfix-developers] newbie mysql questions
Brought to you by:
orenmnero
Menu
▾
▴
quickfix-developers
|
From: Clark S. <cla...@ya...> - 2004-08-18 18:56:03
|
I conigured and compiled quickfix to use mysql. Do I need to do anything else or are the fix messages automatically stored to a database on the hard drive? What is the name of the database file? I have never used mysql before. How do I open the database file of fix messages? I guess I should by a book on mysql. Does anyone have a recomendation? __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail |
|
From: Clark S. <cla...@ya...> - 2004-08-18 19:51:26
|
I conigured and compiled quickfix to use mysql. Do I need to do anything else or are the fix messages automatically stored to a database on the hard drive? What is the name of the database file? I have never used mysql before. How do I open the database file of fix messages? I guess I should by a book on mysql. Does anyone have a recomendation? __________________________________ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo |
|
From: Oren M. <or...@qu...> - 2004-08-19 05:09:21
|
Clark, You need to generate the database with the create_mysql script in the src/sql directory. This will generate a database called quickfix. If you are running a newer version of quickfix you may need to add a '-u root' right after the mysql call if it isn't already there. This is assuming that your root account has not password which is the default installation. If you have a password or are using another account, you will need to supply them. After running the script, you can run the mysql client and type 'use quickfix', then type 'show tables' . You can use standard SQL commands to do whatever queries you like. --oren On Aug 18, 2004, at 1:58 PM, Clark Sims wrote: > QuickFIX Documentation: > http://www.quickfixengine.org/quickfix/doc/html/index.html > QuickFIX FAQ: > http://www.quickfixengine.org/wikifix/index.php?QuickFixFAQ > QuickFIX Support: http://www.quickfixengine.org/services.html > > I conigured and compiled quickfix to use mysql. Do I > need to do anything else or are the fix messages > automatically stored to a database on the hard drive? > What is the name of the database file? > > I have never used mysql before. How do I open the > database file of fix messages? I guess I should by a > book on mysql. Does anyone have a recomendation? > > > > __________________________________ > Do you Yahoo!? > Take Yahoo! Mail with you! Get it on your mobile phone. > http://mobile.yahoo.com/maildemo > > > ------------------------------------------------------- > SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 > Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 > _______________________________________________ > Quickfix-developers mailing list > Qui...@li... > https://lists.sourceforge.net/lists/listinfo/quickfix-developers > |
|
From: Clark S. <cla...@ya...> - 2004-08-20 16:08:32
|
In order to access the databases I had to log in as root. I typed "mysql -u root". As a normal user I got: 1044 error "access denied @localhost" I probably ran into these problems, because I don't understand how to grant users's access, and how to set passwords. --- Oren Miller <or...@qu...> wrote: > Clark, > > You need to generate the database with the > create_mysql script in the > src/sql directory. This will generate a database > called quickfix. If > you are running a newer version of quickfix you may > need to add a '-u > root' right after the mysql call if it isn't already > there. This is > assuming that your root account has not password > which is the default > installation. If you have a password or are using > another account, you > will need to supply them. After running the script, > you can run the > mysql client and type 'use quickfix', then type > 'show tables' . You > can use standard SQL commands to do whatever queries > you like. > > --oren > > On Aug 18, 2004, at 1:58 PM, Clark Sims wrote: > > > QuickFIX Documentation: > > > http://www.quickfixengine.org/quickfix/doc/html/index.html > > QuickFIX FAQ: > > > http://www.quickfixengine.org/wikifix/index.php?QuickFixFAQ > > QuickFIX Support: > http://www.quickfixengine.org/services.html > > > > I conigured and compiled quickfix to use mysql. Do > I > > need to do anything else or are the fix messages > > automatically stored to a database on the hard > drive? > > What is the name of the database file? > > > > I have never used mysql before. How do I open the > > database file of fix messages? I guess I should by > a > > book on mysql. Does anyone have a recomendation? > > > > > > > > __________________________________ > > Do you Yahoo!? > > Take Yahoo! Mail with you! Get it on your mobile > phone. > > http://mobile.yahoo.com/maildemo > > > > > > > ------------------------------------------------------- > > SF.Net email is sponsored by Shop4tech.com-Lowest > price on Blank Media > > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic > DVD+R for only $33 > > Save 50% off Retail on Ink & Toner - Free Shipping > and Free Gift. > > > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 > > _______________________________________________ > > Quickfix-developers mailing list > > Qui...@li... > > > https://lists.sourceforge.net/lists/listinfo/quickfix-developers > > > > __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail |
|
From: Gururaj K. <gkr...@ba...> - 2004-08-20 20:35:09
|
The MySQL website has great documentation - http://dev.mysql.com/doc/mysql/en/Privilege_system.html. The access denied causes are listed here - http://dev.mysql.com/doc/mysql/en/Access_denied.html User authorization model is "user@host having privileges for a db" You can go in as "mysql -u root mysql", create a new user for the quickfix database. ========================== $ mysql -u root -p Enter password: ... You're in...... mysql> GRANT ALL PRIVILEGES ON PStorage.* to tuser1@localhost -> IDENTIFIED BY 'tpass1'; Query OK, 0 rows affected (0.13 sec) ======================== $mysql -u tuser1 -ptpass1 mysql ERROR 1044: Access denied for user: 'tuser1@localhost' to database 'mysql' $mysql -u tuser1 -ptpass1 Pstorage .... Now goes in ===================================== -----Original Message----- From: qui...@li... [mailto:qui...@li...] On Behalf Of Clark Sims Sent: Friday, August 20, 2004 12:08 PM To: QuickFIX Subject: Re: [Quickfix-developers] newbie mysql questions QuickFIX Documentation: http://www.quickfixengine.org/quickfix/doc/html/index.html QuickFIX FAQ: http://www.quickfixengine.org/wikifix/index.php?QuickFixFAQ QuickFIX Support: http://www.quickfixengine.org/services.html In order to access the databases I had to log in as root. I typed "mysql -u root". As a normal user I got: 1044 error "access denied @localhost" I probably ran into these problems, because I don't understand how to grant users's access, and how to set passwords. --- Oren Miller <or...@qu...> wrote: > Clark, > > You need to generate the database with the > create_mysql script in the > src/sql directory. This will generate a database > called quickfix. If > you are running a newer version of quickfix you may > need to add a '-u > root' right after the mysql call if it isn't already > there. This is > assuming that your root account has not password > which is the default > installation. If you have a password or are using > another account, you > will need to supply them. After running the script, > you can run the > mysql client and type 'use quickfix', then type > 'show tables' . You > can use standard SQL commands to do whatever queries > you like. > > --oren > > On Aug 18, 2004, at 1:58 PM, Clark Sims wrote: > > > QuickFIX Documentation: > > > http://www.quickfixengine.org/quickfix/doc/html/index.html > > QuickFIX FAQ: > > > http://www.quickfixengine.org/wikifix/index.php?QuickFixFAQ > > QuickFIX Support: > http://www.quickfixengine.org/services.html > > > > I conigured and compiled quickfix to use mysql. Do > I > > need to do anything else or are the fix messages automatically > > stored to a database on the hard > drive? > > What is the name of the database file? > > > > I have never used mysql before. How do I open the > > database file of fix messages? I guess I should by > a > > book on mysql. Does anyone have a recomendation? > > > > > > > > __________________________________ > > Do you Yahoo!? > > Take Yahoo! Mail with you! Get it on your mobile > phone. > > http://mobile.yahoo.com/maildemo > > > > > > > ------------------------------------------------------- > > SF.Net email is sponsored by Shop4tech.com-Lowest > price on Blank Media > > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic > DVD+R for only $33 > > Save 50% off Retail on Ink & Toner - Free Shipping > and Free Gift. > > > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 > > _______________________________________________ > > Quickfix-developers mailing list > > Qui...@li... > > > https://lists.sourceforge.net/lists/listinfo/quickfix-developers > > > > __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ Quickfix-developers mailing list Qui...@li... https://lists.sourceforge.net/lists/listinfo/quickfix-developers |
|
From: Clark S. <cla...@ya...> - 2004-09-08 17:42:14
|
I got into the mysql database quickfix. All of the messages are from an old session on June 22. I am running a session right now. I have run sessions every trading day for the last month. How do I access these messages? Oren Miller <or...@qu...> wrote:Clark, You need to generate the database with the create_mysql script in the src/sql directory. This will generate a database called quickfix. If you are running a newer version of quickfix you may need to add a '-u root' right after the mysql call if it isn't already there. This is assuming that your root account has not password which is the default installation. If you have a password or are using another account, you will need to supply them. After running the script, you can run the mysql client and type 'use quickfix', then type 'show tables' . You can use standard SQL commands to do whatever queries you like. --oren On Aug 18, 2004, at 1:58 PM, Clark Sims wrote: > QuickFIX Documentation: > http://www.quickfixengine.org/quickfix/doc/html/index.html > QuickFIX FAQ: > http://www.quickfixengine.org/wikifix/index.php?QuickFixFAQ > QuickFIX Support: http://www.quickfixengine.org/services.html > > I conigured and compiled quickfix to use mysql. Do I > need to do anything else or are the fix messages > automatically stored to a database on the hard drive? > What is the name of the database file? > > I have never used mysql before. How do I open the > database file of fix messages? I guess I should by a > book on mysql. Does anyone have a recomendation? > > > > __________________________________ > Do you Yahoo!? > Take Yahoo! Mail with you! Get it on your mobile phone. > http://mobile.yahoo.com/maildemo > > > ------------------------------------------------------- > SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 > Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 > _______________________________________________ > Quickfix-developers mailing list > Qui...@li... > https://lists.sourceforge.net/lists/listinfo/quickfix-developers > --------------------------------- Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. |
|
From: Oren M. <or...@qu...> - 2004-09-08 18:01:50
|
I'm not exactly sure what you are asking here, but assuming you are using the MysqlStoreFactory, messages are placed into the outgoing_log and incoming_log tables. You can query by date, beginstring, sendercompid, and targetcompid. --oren On Sep 8, 2004, at 11:29 AM, Clark Sims wrote: > I got into the mysql database quickfix. All of the messages are from > an old session on June 22. I am running a session right now. I have > run sessions every trading day for the last month. How do I access > these messages? > > Oren Miller <or...@qu...> wrote: > Clark, > > You need to generate the database with the create_mysql script in the > src/sql directory. This will generate a database called quickfix. If > you are running a newer version of quickfix you may need to add a '-u > root' right after the mysql call if it isn't already there. This is > assuming that your root account has not password which is the default > installation. If you have a password or are using another account, you > will need to supply them. After running the script, you can run the > mysql client and type 'use quickfix', then type 'show tables' . You > can use standard SQL commands to do whatever queries you like. > > --oren > > On Aug 18, 2004, at 1:58 PM, Clark Sims wrote: > > > QuickFIX Documentation: > > http://www.quickfixengine.org/quickfix/doc/html/index.html > > QuickFIX FAQ: > > http://www.quickfixengine.org/wikifix/index.php?QuickFixFAQ > > QuickFIX Support: http://www.quickfixengine.org/services.html > > > > I conigured and compiled quickfix to use mysql. Do I > > need to do anything else or are the fix messages > > automatically stored to a database on the hard drive? > > What is the name of the database file? > > > > I have never used mysql before. How do I open the > > database file of fix messages? I guess I should by a > > book on mysql. Does anyone have a recomendation? > > > > > > > > __________________________________ > > Do you Yahoo!? > > Take Yahoo! Mail with you! Get it on your mobile phone. > > http://mobile.yahoo.com/maildemo > > > > > > ------------------------------------------------------- > > SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank > Media > > 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 > > Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. > > http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 > > _______________________________________________ > > Quickfix-developers mailing list > > Qui...@li... > > https://lists.sourceforge.net/lists/listinfo/quickfix-developers > > > > > Do you Yahoo!? > Win 1 of 4,000 free domain names from Yahoo! Enter now. |
|
From: Clark S. <cla...@ya...> - 2004-09-08 20:07:11
|
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. |
|
From: Oren M. <or...@qu...> - 2004-09-08 20:24:38
|
There are two factories you can use. There is the MysqlStoreFactory, =20= and the MysqlLogFactory. You need to instantiate these in your code =20 and pass them to your initiator or acceptor. This is what you would =20 use in place of the FileStoreFactory or FileLogFactory. You will then =20= need to give them the appropriate configuration settings: =20 http://www.quickfixengine.org/quickfix/doc/html/=20 configuration.html#Storage The default settings should work with a standard default MySQL =20 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 =20= > into the database, and type "show tables". Once in the database when I = =20 > querry sessions,=A0 "select * from sessions;"=A0 I get : > > mysql> select * from sessions; > +-------------+--------------+--------------+---------------------=20 > +-----------------+-----------------+ > | beginstring | sendercompid | targetcompid | creationtime=A0=A0=A0=A0=A0= =A0=A0 | =20 > incoming_seqnum | outgoing_seqnum | > +-------------+--------------+--------------+---------------------=20 > +-----------------+-----------------+ > | FIX.4.2=A0=A0=A0=A0 | SETGET=A0=A0=A0=A0=A0=A0 | TEST=A0=A0=A0=A0=A0=A0= =A0=A0 | 2004-06-22 07:36:48 | > =A0 1 |=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 1 | > +-------------+--------------+--------------+---------------------=20 > +-----------------+-----------------+ > 1 row in set (0.00 sec) > > This is a very old session. I guess I am not using mysqlstorefactory. =20= > How do I turn this option on?=A0 Do I need something like: > > MySQLStoreDatabase=A0=A0=A0 quickfix > > in the config file?=A0 Do I need to write something in the C++ code = to =20 > turn on mysqlstorefactory? > > Thanks in Advance, > > Clark Sims > > =A0 > > =A0 > > Do you Yahoo!? > Win 1 of 4,000 free domain names from Yahoo! Enter now.= |
|
From: Clark S. <cla...@ya...> - 2004-09-09 01:22:13
|
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 |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X