Re: [Mixxx-devel] wiki down

The wiki is okay, but the db for the forum got moved during a MariaDB unattended security upgrade last night, I'm working on it now... On Thu, Dec 8, 2016 at 6:03 AM, Daniel Schürmann wrote: > I get this error: > > General Error > SQL ERROR [ mysqli ] > > Access denied for

[Mixxx-devel] wiki down

I get this error: General Error SQL ERROR [ mysqli ] Access denied for user 'phpbb'@'localhost' [1698] An sql error occurred while fetching this page. Please contact an administrator if this problem persists. --

Re: [Mixxx-devel] wiki down

Was able to get an old copy of the db working on mysql-5.7... mariadb totally f**ked itself up last night. :( On Thu, Dec 8, 2016 at 11:34 AM, Be wrote: > It's back, but it looks like some recent posts got lost in the process. > > On 12/08/2016 09:01 AM, Garth Dahlstrom wrote: >

Re: [Mixxx-devel] wiki down

Ok, back up from 12/3. Unfortunately we lost forums data from 12/3 to 12/7. On Thu, Dec 8, 2016 at 9:36 AM, RJ Ryan wrote: > Restoring from a 12/3 backup now. > > On Thu, Dec 8, 2016 at 8:45 AM, Garth Dahlstrom wrote: > >> Was able to get an old copy of the db

Re: [Mixxx-devel] wiki down

Restoring from a 12/3 backup now. On Thu, Dec 8, 2016 at 8:45 AM, Garth Dahlstrom wrote: > Was able to get an old copy of the db working on mysql-5.7... mariadb > totally f**ked itself up last night. :( > > > On Thu, Dec 8, 2016 at 11:34 AM, Be wrote: > >> It's

Re: [Mixxx-devel] wiki down

The binlogs are located in /var/log/mysql if you haven't changed the path or disabled binlogging. I never had to restore from them, but it's possible as far as I know. http://dba.stackexchange.com/questions/29414/how-to-restore-data-from-binary-log#29423 Should be a good start. :) Thorsten

Re: [Mixxx-devel] wiki down

It appears mariadb writes these to /var/lib/mysql, so unfortunately those are gone too. On Thu, Dec 8, 2016 at 10:07 AM, Thorsten Munsch wrote: > The binlogs are located in /var/log/mysql if you haven't changed the > path or disabled binlogging. > > I never had to

Re: [Mixxx-devel] wiki down

Is there something in /var/lib/mysql-upgrade ? sb Le 08/12/2016 à 20:10, RJ Ryan a écrit : It appears mariadb writes these to /var/lib/mysql, so unfortunately those are gone too. On Thu, Dec 8, 2016 at 10:07 AM, Thorsten Munsch

Re: [Mixxx-devel] wiki down

Alright, we didn't lose data after all! Forums are back online with posts up through 12/7. Thanks for pointing me to /var/lib/mysql-upgrade Sebastian. The "DATADIR" symlink in there is clearly cruft left over from a mysql-5.7 package. It confused mariadb-server's postinst script:

Re: [Mixxx-devel] wiki down

/var/lib/mysql-5.7 is the old database from when we were using mysql (before the MariaDB upgrade) on Nov 10th. That's what Garth reverted us to before I restored Dec 3rd from backup. On Thu, Dec 8, 2016 at 1:10 PM RJ Ryan wrote: A symlink to mysql-5.7: $ ls -al

Re: [Mixxx-devel] wiki down

A symlink to mysql-5.7: $ ls -al /var/lib/mysql-upgrade drwxr-xr-x 2 root root 4096 Nov 10 23:21 . drwxr-xr-x 50 root root 4096 Dec 8 11:34 .. lrwxrwxrwx 1 root root 10 Nov 10 23:21 DATADIR.link -> mysql-5.7/ On Thu, Dec 8, 2016 at 12:56 PM Sébastien Blaisot wrote: > >

Re: [Mixxx-devel] wiki down

Is this fail caused by the Ubuntu packages of MariaDB? I installed a few MariaDB instances on a fresh Debian server and it was set to /var/log/mysql everytime. :/ Ubuntu on a desktop = awesome Ubuntu on a server = pain in the ass IMHO Why don't we have backups since 12/3? Was the backupjob

Re: [Mixxx-devel] wiki down

Nice. Now, install and configure duplicity ;) sb Le 08/12/2016 à 22:43, RJ Ryan a écrit : Alright, we didn't lose data after all! Forums are back online with posts up through 12/7. Thanks for pointing me to /var/lib/mysql-upgrade Sebastian. The "DATADIR" symlink in there is clearly cruft

Re: [Mixxx-devel] wiki down

Nice spot RJ (the data was dropped off in /tmp next to that README) On Dec 8, 2016 4:36 PM, "Thorsten Munsch" wrote: > Why don't we have backups since 12/3? Was the backupjob not running? Sad.. > Frankly, I don't feel the forum data really warrants the space

Re: [Mixxx-devel] wiki down

How big is the gzipped file of one full sql dump? Is diskspace really a problem here? Am 08.12.2016 um 23:01 schrieb Garth Dahlstrom: > Nice spot RJ (the data was dropped off in /tmp next to that README) > > On Dec 8, 2016 4:36 PM, "Thorsten Munsch"

Re: [Mixxx-devel] Devel and live play on master

its been ages since i've done any work on mixxx, i am recompiling, I am considering just making a new branch off my new master here, and redoing the code from scratch, since it has been so long... someone said that i should rebase, though. comments? and how do i get and rebase my branch, after

Re: [Mixxx-devel] Devel and live play on master

Hi I have used it last weekend with no issues but than means nothing. You should take some time to verify this for your use case at home. Kind regards, Daniel Am 08.12.2016 um 23:11 schrieb Waylon Robertson: > Any gotchas/showstoppers currently existing on the bleeding edge? > >

[Mixxx-devel] Devel and live play on master

Any gotchas/showstoppers currently existing on the bleeding edge? -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel

Re: [Mixxx-devel] wiki down

Are you sure it's really the "old" one ? not just THE ONE ? sb Le 08/12/2016 à 22:12, RJ Ryan a écrit : /var/lib/mysql-5.7 is the old database from when we were using mysql (before the MariaDB upgrade) on Nov 10th. That's what Garth reverted us to before I restored Dec 3rd from backup. On

Re: [Mixxx-devel] Devel and live play on master

Rebasing will work like this: git fetch upstream git checkout id3ratings_to_stars git rebase upstream/master resolve conflict if any Am 08.12.2016 um 23:43 schrieb Waylon Robertson: > its been ages since i've done any work on mixxx, i am recompiling, I > am considering just making a new

Re: [Mixxx-devel] Devel and live play on master

hmm.. thought it was git add remote, git pull my remote branch, think it ended up in master, fix conflicts, then recompile. at least, thats what i just did. What did i just do? On Fri, Dec 9, 2016 at 12:07 PM, Daniel Schürmann wrote: > Rebasing will work like this: > > git

Re: [Mixxx-devel] Devel and live play on master

It sound like you have merged you feature branch into your private master branch. Is the new master working now including your "id3ratings_to_stars " changes? If yes, you can correct your repository like this: # comit your merge git

[Mixxx-devel] Write metadata to mp3 file

With the current master, I would like to write out metadata to a unloaded mp3's id3 tags, how do I accomplish this? -- Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based

Re: [Mixxx-devel] wiki down

On Thu, Dec 8, 2016 at 2:15 PM Thorsten Munsch wrote: > How big is the gzipped file of one full sql dump? > > Is diskspace really a problem here? > A backup is 1GB (forum SQL database, forum files, wiki files). We use Google Cloud "coldline" storage which is

Re: [Mixxx-devel] wiki down

>90 # this should never even happen, but just in case... LMAO :D Glad you could fix this. Please don't forget to edit the backup cronjob to daily. Am 08.12.2016 um 22:43 schrieb RJ Ryan: > Alright, we didn't lose data after all! Forums are back online with > posts up through