Re: Choosing a "non-standard" database name?

Yeah, I thought so too. Corrected a dns issue, and it's fast now. So fedora
32 is looking like one of the best platforms I've seen for maia.

Now, I just have to find the time to modify the installer to do the right
thing about the database name.

Jake

On Wed, May 6, 2020 at 12:44 PM Derek Atkins <[email protected]> wrote:

> That looks like a failed DNS lookup and/or failed IPv6 attempt?
>
> Can you run the mysqladmin under strace on F32 to see what it's doing for
> those 5 seconds?
>
> -derek
>
> On Wed, May 6, 2020 3:38 pm, jjs - mainphrame wrote:
> > As a preliminary check, the fedora instance here is able to use a
> database
> > called "maia1" (and by induction, any arbitrary name), with changes to
> the
> > 3 config files - maia.conf, maiad.conf and config.php.
> >
> > One thing that I can't figure out, and maybe a fedora guru can shed
> > some light, is that fedora is taking an extra 5 seconds to interact with
> > the remote database server, and I'm not sure what system setting could be
> > causing that.
> >
> > From Centos 8:
> > $ time mysqladmin status -h dbserv -u test -ptest
> > Uptime: 2257483  Threads: 7  Questions: 252508  Slow queries: 0  Opens:
> 99
> >  Flush tables: 1  Open tables: 93  Queries per second avg: 1.11
> >
> > real 0m0.009s
> > user 0m0.001s
> > sys  0m0.006s
> >
> > From Fedora 32:
> > $ time mysqladmin status -h dbserv -u test -ptest
> > Uptime: 2257557  Threads: 7  Questions: 252511  Slow queries: 0  Opens:
> 99
> >  Flush tables: 1  Open tables: 93  Queries per second avg: 1.11
> >
> > real 0m5.009s
> > user 0m0.002s
> > sys  0m0.003s
> >
> > Jake
> >
> > On Mon, May 4, 2020 at 6:45 PM jjs - mainphrame <[email protected]>
> > wrote:
> >
> >> If you do dive in, be sure and start with the latest version of the
> >> repo.
> >> It's getting updates pretty much every day.
> >>
> >> Jake
> >>
> >> On Mon, May 4, 2020 at 8:38 AM Derek Atkins <[email protected]> wrote:
> >>
> >>> Indeed.  I'll see if I have time to look at it myself.
> >>> I think there are a few more than 3 places, but hopefully less than 6.
> >>> Certainly the get-info.sh needs to be updated, but so do the SQL
> >>> scripts
> >>> and scripts that generate the config files.
> >>> Hopefully I can find the time.  WAY too much going on.
> >>>
> >>> -derek
> >>>
> >>> On Mon, May 4, 2020 11:32 am, jjs - mainphrame wrote:
> >>> > Lots going on this week, so we'll see
> >>> >
> >>> > I'm hoping it's mostly in 3 config files, but a search will tell.
> >>> >
> >>> > Jake
> >>> >
> >>> >
> >>> >
> >>> > On Mon, May 4, 2020 at 7:53 AM Derek Atkins <[email protected]> wrote:
> >>> >
> >>> >> Of course, there are 2772 instances of the 4-tuple "maia" that I
> >>> will
> >>> >> need
> >>> >> to check through to ensure I get all places!
> >>> >>
> >>> >> Fun.  (unless you volunteer to do this for me ;)
> >>> >>
> >>> >> -derek
> >>> >>
> >>> >> On Mon, May 4, 2020 10:45 am, jjs - mainphrame wrote:
> >>> >> > That doesn't seem unreasonable.
> >>> >> >
> >>> >> > Jake
> >>> >> >
> >>> >> > On Mon, May 4, 2020 at 7:27 AM Derek Atkins <[email protected]>
> >>> wrote:
> >>> >> >
> >>> >> >> Hi,
> >>> >> >>
> >>> >> >> jjs - mainphrame <[email protected]> writes:
> >>> >> >>
> >>> >> >> > You can send them by email here, or add it to the issue on the
> >>> >> repo.
> >>> >> >> >
> >>> >> >> > Jake
> >>> >> >>
> >>> >> >> One thing I noticed is that there is a hard-coded dependency on
> >>> the
> >>> >> >> database *name* of "maia".  I was planning to install this
> >>> along-side
> >>> >> my
> >>> >> >> older (1.0.2a) maia installation (same DB server, although
> >>> different
> >>> >> >> mail hosts).  I would rather be able to name the *new* database
> >>> >> >> something other that "maia", rather than trying to rename the
> >>> >> existing,
> >>> >> >> live database.
> >>> >> >>
> >>> >> >> I suppose I could do the manual install, following the fedora
> >>> model,
> >>> >> but
> >>> >> >> would you accept a PR that lets one choose the database name?  In
> >>> my
> >>> >> >> case, I want to set it to "maia1".
> >>> >> >>
> >>> >> >> -derek
> >>> >> >>
> >>> >> >> --
> >>> >> >>        Derek Atkins                 617-623-3745
> >>> >> >>        [email protected]             www.ihtfp.com
> >>> >> >>        Computer and Internet Security Consultant
> >>> >> >>
> >>> >> >
> >>> >>
> >>> >>
> >>> >> --
> >>> >>        Derek Atkins                 617-623-3745
> >>> >>        [email protected]             www.ihtfp.com
> >>> >>        Computer and Internet Security Consultant
> >>> >>
> >>> >>
> >>> >
> >>>
> >>>
> >>> --
> >>>        Derek Atkins                 617-623-3745
> >>>        [email protected]             www.ihtfp.com
> >>>        Computer and Internet Security Consultant
> >>>
> >>>
> >
>
>
> --
>        Derek Atkins                 617-623-3745
>        [email protected]             www.ihtfp.com
>        Computer and Internet Security Consultant
>
>

_______________________________________________
Maia-users mailing list
[email protected]
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users