https://community.splunk.com/t5/Getting-Data-In/Is-it-possible-to-use-Splunk-forwarder-to-send-data-from-mysql/m-p/78176#M15995 <P>If you can write a script to get data from mysql, you can get it into Splunk.</P> <P>The usual way might be to use a shell script calling the mysql interpreter with your desired SELECT statement, returning the rows to STDOUT. Splunk would then index the data being output by the script. Inspecting the database directly from a Splunk script might be just a bit trickier, as I don't know whether a database connector for mysql is included in the Splunk Python library.</P> Wed, 03 Oct 2012 12:46:05 GMT sowings 2012-10-03T12:46:05Z https://community.splunk.com/t5/Getting-Data-In/Is-it-possible-to-use-Splunk-forwarder-to-send-data-from-mysql/m-p/78175#M15994 <P>Is it possible to use Splunk forwarder to send data from MYSQL ?</P> Wed, 03 Oct 2012 12:23:03 GMT https://community.splunk.com/t5/Getting-Data-In/Is-it-possible-to-use-Splunk-forwarder-to-send-data-from-mysql/m-p/78175#M15994 dragosluca 2012-10-03T12:23:03Z https://community.splunk.com/t5/Getting-Data-In/Is-it-possible-to-use-Splunk-forwarder-to-send-data-from-mysql/m-p/78176#M15995 <P>If you can write a script to get data from mysql, you can get it into Splunk.</P> <P>The usual way might be to use a shell script calling the mysql interpreter with your desired SELECT statement, returning the rows to STDOUT. Splunk would then index the data being output by the script. Inspecting the database directly from a Splunk script might be just a bit trickier, as I don't know whether a database connector for mysql is included in the Splunk Python library.</P> Wed, 03 Oct 2012 12:46:05 GMT https://community.splunk.com/t5/Getting-Data-In/Is-it-possible-to-use-Splunk-forwarder-to-send-data-from-mysql/m-p/78176#M15995 sowings 2012-10-03T12:46:05Z https://community.splunk.com/t5/Getting-Data-In/Is-it-possible-to-use-Splunk-forwarder-to-send-data-from-mysql/m-p/78177#M15996 <P>It is possible to use a Splunk Forwarder to send data from mysql, but it involves a scripted input. Input configurations are found here: <CODE><A href="http://docs.splunk.com/Documentation/Splunk/latest/Admin/Inputsconf" target="test_blank">http://docs.splunk.com/Documentation/Splunk/latest/Admin/Inputsconf</A></CODE>. I would call a perl or python script and use that to pull in the data.<BR /> Example: <CODE><A href="http://www.tutorialspoint.com/python/python_database_access.htm" target="test_blank">http://www.tutorialspoint.com/python/python_database_access.htm</A></CODE> </P> Wed, 03 Oct 2012 12:49:30 GMT https://community.splunk.com/t5/Getting-Data-In/Is-it-possible-to-use-Splunk-forwarder-to-send-data-from-mysql/m-p/78177#M15996 alacercogitatus 2012-10-03T12:49:30Z https://community.splunk.com/t5/Getting-Data-In/Is-it-possible-to-use-Splunk-forwarder-to-send-data-from-mysql/m-p/78178#M15997 <P>This is my favorite app: <A href="http://splunk-base.splunk.com/apps/50803/dbx-sql-database-extension">http://splunk-base.splunk.com/apps/50803/dbx-sql-database-extension</A>. No forwarder required and simple to use. You can do lookups, browse databases, update Splunk indexes from a database, and update the database from Splunk. You should definitely check it out!</P> Wed, 03 Oct 2012 12:55:01 GMT https://community.splunk.com/t5/Getting-Data-In/Is-it-possible-to-use-Splunk-forwarder-to-send-data-from-mysql/m-p/78178#M15997 dmaislin_splunk 2012-10-03T12:55:01Z https://community.splunk.com/t5/Getting-Data-In/Is-it-possible-to-use-Splunk-forwarder-to-send-data-from-mysql/m-p/78179#M15998 <P><A href="http://splunk-base.splunk.com/apps/50803/dbx-sql-database-extension">http://splunk-base.splunk.com/apps/50803/dbx-sql-database-extension</A><BR /> <A href="http://splunk-base.splunk.com/apps/27105/jdbc-scripted-input">http://splunk-base.splunk.com/apps/27105/jdbc-scripted-input</A></P> <P>are apps that will do this for you.</P> Wed, 03 Oct 2012 15:14:41 GMT https://community.splunk.com/t5/Getting-Data-In/Is-it-possible-to-use-Splunk-forwarder-to-send-data-from-mysql/m-p/78179#M15998 gkanapathy 2012-10-03T15:14:41Z https://community.splunk.com/t5/Getting-Data-In/Is-it-possible-to-use-Splunk-forwarder-to-send-data-from-mysql/m-p/78180#M15999 <P>As of right now (Oct 3 2012) this app is not downloadable. however, a less rich app (that requires a bit more work) is <A href="http://splunk-base.splunk.com/apps/27105/jdbc-scripted-input">http://splunk-base.splunk.com/apps/27105/jdbc-scripted-input</A></P> Wed, 03 Oct 2012 15:15:27 GMT https://community.splunk.com/t5/Getting-Data-In/Is-it-possible-to-use-Splunk-forwarder-to-send-data-from-mysql/m-p/78180#M15999 gkanapathy 2012-10-03T15:15:27Z