Comments (4)
I believe older bookworms changed the global my.conf (/etc/mysql/my.cnf) but now the preference is to specify user settings in a local my.conf (~/.my.cnf). To continue in the latter fashion, I sent #23, which adds the values @bmschmidt discusses in the thread you referenced...
from lab-workshops.
Some background because I was just working on this: Ideally these changes can all be handled by typing bookworm config mysql
, or (non-interactively) the newly-added bookworm config --force mysql
(added to get a clean set-up running on Travis with 14.04 without asking for any locations).
In reality, I keep overshooting or undershooting the mark on some configuration because there are many places that these things can be stored and differences in users trying to access them. (Apache runs as httpd, root sometimes installs some files, etc). So I'd love any bug reports on the bookwormDB
repo where that command is failing.
In response to @duhaime's question here: Bookworm wants to overwrite both these locations on occasion. On (my?) Ubuntu mysqld
is a owned by the user mysql
, so the customizations can't be in /home/$whoami/.my.cnf
; they have to be in /etc/my.cnf
or /etc/mysql/my.cnf
or something of the sort, or else the server won't read them. As @pleonard212 says, they're only necessary for large builds.
There also needs to be a username and password defined for both an administrator (the person who creates the bookworm) and client (used by the web service for safety, so that even if someone succeeds in SQL injection they can't do anything but run SELECT queries.)
The locations searched for those two files are defined here. I'm trying to catch everywhere that I've seen on Ubuntu, CentOS, and OS X.
from lab-workshops.
Thanks so much @bmschmidt, this helps! Thanks as well for this awesome application. Peter and I led a pretty well-attended gathering last week during which we helped some folks at Yale get started with the OneClick installer at Rice and building the application from source, and everyone was really enthusiastic about the web app and the interface. I was watching people who got ahead of the tutorial running queries and showing their neighbors throughout the event--it's a good thing to see.
In order to provide some documentation on this Wiki on how one can build a custom Bookworm, I created a simple utility that writes some settings to both ~/.my.cnf
and /etc/mysql/conf.d/my.cnf
, and this seems to work on Ubuntu 14.04 (provided one follows the other steps outlined in the Wiki).
Thanks again for this great work!
from lab-workshops.
Closing this issue as this problem should be all set
from lab-workshops.
Related Issues (15)
- Suggested Workshop: Web Scraping Workshop HOT 2
- Using Github HOT 3
- Suggested workshop: find overrepresented terms
- Gathering a Building: Prototype
- Pull request tutorial HOT 2
- Palladio, per favore
- Building a Bookworm HOT 1
- Bookworm :: CGI Connection Error? HOT 9
- Bookworm on Ubuntu - consider @locahost for MySQL permissions HOT 1
- D3 workshop HOT 1
- Would like command line github workshop HOT 1
- Interactive Plots Workshop HOT 2
- word-vectors workshop: To be done HOT 3
- Word of thanks HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from lab-workshops.