Send Motion-user mailing list submissions to
motion-user@lists.sourceforge.net
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/motion-user
or, via email, send a message with subject or body 'help' to
motion-user-requ...@lists.sourceforge.net
You can reach the person managing the list at
motion-user-ow...@lists.sourceforge.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Motion-user digest..."
Today's Topics:
1. Re: MySQL - access denied (tosiara)
----------------------------------------------------------------------
Message: 1
Date: Thu, 18 Mar 2021 14:38:26 +0200
From: tosiara <tosi...@gmail.com>
To: Motion discussion list <motion-user@lists.sourceforge.net>
Subject: Re: [Motion-user] MySQL - access denied
Message-ID:
<cachtdwrvego5wk8od9ntsdk_oqxoyxxwo7nhvfzy+zkeni0...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Try adding also database name, like this:
./mysql -u root -p clips
Does it work that way?
On Thu, Mar 18, 2021 at 2:20 PM Bill Visick via Motion-user
<motion-user@lists.sourceforge.net> wrote:
>
> Thaanks to Tosaria for his comment, sorry I can't see how to respond directly
> to it!
>
>
> Anyway, I understand motion can't fix mysql problems but was hoping there was
> maybe a config option that I'd set wrong somewhere.
>
>
> On the command prompt I enter:
>
> ./mysql -u root -pxxxxxxxxxx
>
>
> and get:
>
> Welcome to the MariaDB monitor. Commands end with ; or \g.
> Your MariaDB connection id is 41
> Server version: 10.3.21-MariaDB Source distribution
>
> etc.
>
>
> For info, the user table has:
>
> +-----------+------+
> | host | user |
> +-----------+------+
> | 127.0.0.1 | root |
> | ::1 | root |
> | localhost | root |
> +-----------+------+
>
>
> Could there be a path problem? At the command prompt I have to cd to the
> relevant directory first (/usr/local/mariadb10/bin) but the fact that motion
> says Access denied rather than being unable to find mysql suggests that's not
> the problem.
>
>
> Regards
> Bill Visick
>
>
>
>
> ------ Original Message ------
> From: "Bill Visick via Motion-user" <motion-user@lists.sourceforge.net>
> To: motion-user@lists.sourceforge.net
> Cc: "Bill Visick" <bvis...@btinternet.com>
> Sent: Wednesday, 17 Mar, 21 At 17:31
> Subject: [Motion-user] MySQL - access denied
>
> I'm trying to insert records in a database but motion can't connect to it. I
> have the following in motion.conf:
>
>
> database_type mysql
> database_dbname clips
> daabase_host localhost
> database_port 3306
> database_user root
> database_password xxxxxxxxxxxxxxxx
> sql_log_picture on
> sql_log_snapshot on
> sql_log_movie on
> sql_query insert into motion(camera, filename, event, frame, file_type,
> time_stamp, text_event) values('%$_%t', '%f', '%v', '%q', '%n', '%Y-%m-%d
> %T', '%C')
>
>
> In motion.log I get:
>
>
> motion_init: Database backend mysql
> motion_init: Cannot connect to MySQL database clips on host localhost with
> user root
> motion_init: MySQL error was Access denied for user 'root'@'localhost' (using
> password: YES)
> motion_loop: Thread exiting
>
>
> I can log in to MySQL successfully using the same credentials from a command
> prompt.
>
>
> I'm sure I'm missing something simple, thanks very much for any suggestions.
>
>
> Bill Visick
>
> ________________________________
> _______________________________________________
> Motion-user mailing list
> Motion-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/motion-user
> https://motion-project.github.io/
>
> Unsubscribe: https://lists.sourceforge.net/lists/options/motion-user
>
> _______________________________________________
> Motion-user mailing list
> Motion-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/motion-user
> https://motion-project.github.io/
>
> Unsubscribe: https://lists.sourceforge.net/lists/options/motion-user
------------------------------
------------------------------
Subject: Digest Footer
_______________________________________________
Motion-user mailing list
Motion-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/motion-user
------------------------------
End of Motion-user Digest, Vol 177, Issue 8
*******************************************
