Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><strong>Edit</strong> Oh, my apologies for misinterpreting </p> <p>Still the problems with differences between daemonized/non-daemonized are roughly with the following class of options:</p> <ul> <li>environment variables <ul> <li>LIBPATH</li> <li>PATH</li> <li>HOME, UID, EUID (HOME surprisingly enough gets (ab)used way too often)</li> <li>mysql specific variables</li> </ul></li> <li>permissions <ul> <li>what user is the daemon running as? elevated or privilege separation?</li> </ul></li> <li>current working directory (traditionally / for daemons, where / might be a chroot jail instead of 'real' /)</li> <li><p><a href="http://kernel.org/doc/man-pages/online/pages/man2/mount.2.html" rel="nofollow">Starting with kernel 2.4.19, Linux provides per-process mount namespaces. A mount namespace is the set of file system mounts that are visible to a process. Mount-point namespaces can be (and usually are) shared between multiple processes, and changes to the namespace (i.e., mounts and unmounts) by one process are visible to all other processes sharing the same namespace. (The pre-2.4.19 Linux situation can be considered as one in which a single namespace was shared by every process on the system.)</a></p></li> <li><p>detached stdin/stdout causing trouble (IMO that would mean badly designed library, but who am I)</p></li> <li><p><strong>watch it that specific resources (file locks, socket connections, threads (!)) are <em>NOT</em> inherited across fork/execve</strong>. I recommend reading the linked on daemonization (below), especially for example the section on 'Mutual Exclusion and Running a Single Copy [open,lockf,getpid]'</p></li> </ul> <p>I'm sure I'm forgetting stuff</p> <p>Ermm... what are you starting a mysql server process for? Mysql has plenty of sound init scripts that <em>do work</em>.</p> <p>On the subject of proper daemonization: <a href="http://www.enderunix.org/docs/eng/daemon.php" rel="nofollow">http://www.enderunix.org/docs/eng/daemon.php</a></p> <p>Pay attention to the effects of sharing resources with fork children (e.g. file descriptors).</p> <p>Besides that, you could just be missing basic environment settings. Peruse the official init scripts for mysql to find out which you need.</p>
    singulars
    1. This table or related slice is empty.
    1. POC++ daemon forking causes mysql errors
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USsehe
    1. USsehe
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POC++ daemon forking causes mysql errors
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat do you mean starting a mysql server process? I am making my own daemon that just uses mysql connector library to access a database. I do not keep any file descriptors before the fork. Everything I need gets created after forking.
      singulars
      1. PO
      1. USuser623879
    2. COsorry misinterpreted. updated answer with more background info
      singulars
      1. PO
      1. USsehe
    3. COI was disabling stdin/stdout/stderr..apparently mysql connector relies on this ffs...thanks for mentioning that!!!!
      singulars
      1. PO
      1. USuser623879
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload