![]() ![]() "SHOW tables from " || dtConfig:DatabaseName || " ", "DSN=Mythtv UID=" || dtConfig:UserName || " PWD=" || dtConfig:Password, DSN=Mythtv comes from the windows ODBC Data Source Administrator applet Thanks to an example from for pointing the way with the next bit of JSL. The ODBC Connector dialog supplies some information that can be overridden laterĭiscover the table names in the MythTV databases The JSL below is going to override those. ![]() You can fill in the user and password and test the connection and see the database names that are available. My VirtualBox and network and server are not happy with closet.local for the server name so the dotted IP gets used. Press configure and add a few fields I think these can all be overridden via a connection string later. The Windows ODBC Data Source Administrator sets up a DSN I’m pretty sure I’m actually running MariaDB on my backend server and using the MySQL connector on the frontend. You probably need the 64 bit drivers, and you might need to download them. JMP data table loaded from XML file with one row and columns for UserName, Password, and DatabaseNameĬloset.local is the name of the backend host, mythtv is the SQL user name that has access to the mythconverg database, and the 3306 is the default port, so it won’t be needed.Ĭreate a DSN using the windows ODBC Data Source Administrator. grab user name and password from the XML config fileĭtConfig = Open( "F:\mythconfig.xml", invisible, XML Wizard( 0, guess( "huge" ) ) ) Ĭopy the file somewhere your copy of JMP can read it, and, with JMP 15, open it like this: On a Linux system running the MythTV frontend, there will be a file ~/.mythtv/config.xml. The database import seems useful it puts columns (or fields) next to each other that have related values and combines information from several tables in the database. ![]() JMP data table imported from database showing old, large files It says there is a MythTV bug around the deletepending database field that prevents the file from being deleted if MythTV crashes between the time the field is set and the file is deleted.įor example, using the Linux ls command to list some files, here’s a 3GB example (it is December 2019 only about two weeks of files fit on the 3T disk these files should be long gone.) describes a reason why there are lots of really old, really big files on the MythTV backend disk that are not visible in the MythTV frontend. An SQL database keeps track of what to record and what has been recorded. The implementation uses two computers, a backend (or several) that does the recording and a frontend (or several) that does the watching. It is a great way to learn about Linux and MySQL/MariaDB and avoid watching TV. MythTV is an open source program (TANSTAAFL) that can record over-the-air TV broadcasts using a tuner card in a PC (and a bunch of other stuff too). This post is about using JMP’s SQL capabilities, mostly, but also touches XML, Linux, MythTV. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |