Ryfujk

How could a hydrazine and N2O4 cloud (or it's reactants) show up in weather radar?

How do I say "this must not happen"?

How do Java 8 default methods hеlp with lambdas?

Centre cell vertically in tabularx

Why not use the yoke to control yaw, as well as pitch and roll?

Problem with display of presentation

In musical terms, what properties are varied by the human voice to produce different words / syllables?

How do you write "wild blueberries flavored"?

As a dual citizen, my US passport will expire one day after traveling to the US. Will this work?

One-one communication

How to ask rejected full-time candidates to apply to teach individual courses?

Where and when has Thucydides been studied?

3D Masyu - A Die

Fit odd number of triplets in a measure?

systemd and copy (/bin/cp): no such file or directory

A question about the degree of an extension field

Sally's older brother

newbie Q : How to read an output file in one command line

Why can't fire hurt Daenerys but it did to Jon Snow in season 1?

Why are current probes so expensive?

What criticisms of Wittgenstein's philosophy of language have been offered?

Is there a verb for listening stealthily?

Pointing to problems without suggesting solutions

Are there any irrational/transcendental numbers for which the distribution of decimal digits is not uniform?

mysql won't start on FreeBSD

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

1

We recently picked up a client that has a site hosted on a FreeBSD box. The stack is FAMP. Things were chugging along just fine until recently mysql seems to have stopped running.

There is no mysql log under /var/log/mysql.log.

service mysql-server status says mysql is not running.

service mysql-server start says Starting mysql. but it doesn't actually start.

Where do I start to find out what happened and how to get mysql up and running again?

mysql freebsd

share|improve this question

edited Dec 9 '15 at 21:25

Jared Eitnier

asked Dec 9 '15 at 21:10

Jared EitnierJared Eitnier

11916

bumped to the homepage by Community♦ 17 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How familiar are you with FreeBSD?
  
  – EEAA
  Dec 9 '15 at 21:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This is literally the first instance of FreeBSD I've ever touched.
  
  – Jared Eitnier
  Dec 9 '15 at 21:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  you need to locate log (and my.cnf) to see actual error why it's wouldn't start...
  
  – alexus
  Dec 9 '15 at 21:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The problem can be replicated by installing FreeBSD 11.2 and mariadb103-server OOTB. find / -name "my.cnf" returns nothing.
  
  – Code4R7
  Jul 30 '18 at 21:13
  
  
  

  
  
  
  

add a comment | 

1

We recently picked up a client that has a site hosted on a FreeBSD box. The stack is FAMP. Things were chugging along just fine until recently mysql seems to have stopped running.

There is no mysql log under /var/log/mysql.log.

service mysql-server status says mysql is not running.

service mysql-server start says Starting mysql. but it doesn't actually start.

Where do I start to find out what happened and how to get mysql up and running again?

mysql freebsd

share|improve this question

edited Dec 9 '15 at 21:25

Jared Eitnier

asked Dec 9 '15 at 21:10

Jared EitnierJared Eitnier

11916

bumped to the homepage by Community♦ 17 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How familiar are you with FreeBSD?
  
  – EEAA
  Dec 9 '15 at 21:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This is literally the first instance of FreeBSD I've ever touched.
  
  – Jared Eitnier
  Dec 9 '15 at 21:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  you need to locate log (and my.cnf) to see actual error why it's wouldn't start...
  
  – alexus
  Dec 9 '15 at 21:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The problem can be replicated by installing FreeBSD 11.2 and mariadb103-server OOTB. find / -name "my.cnf" returns nothing.
  
  – Code4R7
  Jul 30 '18 at 21:13
  
  
  

  
  
  
  

add a comment | 

We recently picked up a client that has a site hosted on a FreeBSD box. The stack is FAMP. Things were chugging along just fine until recently mysql seems to have stopped running.

There is no mysql log under /var/log/mysql.log.

service mysql-server status says mysql is not running.

service mysql-server start says Starting mysql. but it doesn't actually start.

Where do I start to find out what happened and how to get mysql up and running again?

mysql freebsd

share|improve this question

edited Dec 9 '15 at 21:25

Jared Eitnier

asked Dec 9 '15 at 21:10

Jared EitnierJared Eitnier

11916

share|improve this question

edited Dec 9 '15 at 21:25

Jared Eitnier

asked Dec 9 '15 at 21:10

Jared EitnierJared Eitnier

11916

share|improve this question

edited Dec 9 '15 at 21:25

Jared Eitnier

asked Dec 9 '15 at 21:10

Jared EitnierJared Eitnier

11916

asked Dec 9 '15 at 21:10

Jared EitnierJared Eitnier

11916

asked Dec 9 '15 at 21:10

Jared EitnierJared Eitnier

11916

1 Answer
1

active

oldest

votes

0

The default location for the log file (which usually has a .err extension) is the same place as the database, which defaults to /var/db/mysql/.

But of course all of these can be changed in the master configuration file my.cnf which mysqld will look for in a number of locations including /etc/.

You may need to locate it with:

find / -name "my.cnf"

Also, check /etc/rc.conf as it may contain some command line parameters used when starting the service.

share|improve this answer

edited Dec 9 '15 at 21:56

answered Dec 9 '15 at 21:51

Richard SmithRichard Smith

6,8082717

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'm currently downloading a 3.5 gb .err file now to examine what is going on...
  
  – Jared Eitnier
  Dec 9 '15 at 21:57
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You probably only need the last few dozen lines.
  
  – Richard Smith
  Dec 9 '15 at 22:02
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "2"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f741984%2fmysql-wont-start-on-freebsd%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

The default location for the log file (which usually has a .err extension) is the same place as the database, which defaults to /var/db/mysql/.

But of course all of these can be changed in the master configuration file my.cnf which mysqld will look for in a number of locations including /etc/.

You may need to locate it with:

find / -name "my.cnf"

Also, check /etc/rc.conf as it may contain some command line parameters used when starting the service.

share|improve this answer

edited Dec 9 '15 at 21:56

answered Dec 9 '15 at 21:51

Richard SmithRichard Smith

6,8082717

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'm currently downloading a 3.5 gb .err file now to examine what is going on...
  
  – Jared Eitnier
  Dec 9 '15 at 21:57
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You probably only need the last few dozen lines.
  
  – Richard Smith
  Dec 9 '15 at 22:02
  

  
  
  
  

add a comment | 

0

The default location for the log file (which usually has a .err extension) is the same place as the database, which defaults to /var/db/mysql/.

But of course all of these can be changed in the master configuration file my.cnf which mysqld will look for in a number of locations including /etc/.

You may need to locate it with:

find / -name "my.cnf"

Also, check /etc/rc.conf as it may contain some command line parameters used when starting the service.

share|improve this answer

edited Dec 9 '15 at 21:56

answered Dec 9 '15 at 21:51

Richard SmithRichard Smith

6,8082717

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'm currently downloading a 3.5 gb .err file now to examine what is going on...
  
  – Jared Eitnier
  Dec 9 '15 at 21:57
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You probably only need the last few dozen lines.
  
  – Richard Smith
  Dec 9 '15 at 22:02
  

  
  
  
  

add a comment | 

The default location for the log file (which usually has a .err extension) is the same place as the database, which defaults to /var/db/mysql/.

But of course all of these can be changed in the master configuration file my.cnf which mysqld will look for in a number of locations including /etc/.

You may need to locate it with:

find / -name "my.cnf"

Also, check /etc/rc.conf as it may contain some command line parameters used when starting the service.

share|improve this answer

edited Dec 9 '15 at 21:56

answered Dec 9 '15 at 21:51

Richard SmithRichard Smith

6,8082717

find / -name "my.cnf"

share|improve this answer

edited Dec 9 '15 at 21:56

answered Dec 9 '15 at 21:51

Richard SmithRichard Smith

6,8082717

answered Dec 9 '15 at 21:51

Richard SmithRichard Smith

6,8082717

answered Dec 9 '15 at 21:51

Richard SmithRichard Smith

6,8082717