WORKING - Fingerprint enabled Time and Attendance application for ERPNext

Frappe Framework App Development
52

@noetico Hi, i am very glad to see your struggle for building this feature.
i’ve also tried implementing this but it didn’t work.
i’ve downloaded this and set it up as per user manual.
I’ve putted ip, dbname , dbuser, dbpasword in setup.txt file
but when i am connecting it to server it show below error,
Connection failed with error: Unable to connect to any of the specified MySQL hosts.

please have look into it. your reply will be highly appreciated.

53

Have you set up the right privileges in mysql? also edit my.cnf; comment out skip-networking and bind-address, add # in front of both lines. Set privileges from the mysql command line.

54

Sorry buddy i’ve not got your point. please guide step by step or provide documentation if possible.

55

we have been done it for weighing machines on android!

56

extremely sorry for the late reply. try the following steps

  1. log into mysql, you can use bench mysql
  2. set privileges as follows: grant all privileges on databaseName TO ‘user’ @‘%’ identified by ‘password’ with grant option; hit enter
  3. enter flush privileges; hit enter
  4. edit my.cnf to allow external connections as follows, navigate to etc/mysql and open the my.cnf file, look for bind-address 127.0
    0.1 add a # in front of it, before it like so, #bind-address…
  5. add another line, #skip-networking
  6. save file, restart server
    please dont make a mistake in the conf file.

all the best

2 Likes
57
  1. edit my.cnf to allow external connections as follows, navigate to etc/mysql and open the my.cnf file, look for bind-address 127.0
    0.1 add a # in front of it, before it like so, #bind-address…

Can you please explain this step? i am unable to find my.cnf file.

58

Try this

frappe@erpnext:~/frappe-bench$ find /etc -name '*.cnf' | xargs grep bind-address
find: `/etc/ssl/private': Permission denied
find: `/etc/polkit-1/localauthority': Permission denied
grep: /etc/mysql/debian.cnf: Permission denied
/etc/mysql/my.cnf:#bind-address		= 127.0.0.1
/etc/mysql/my.cnf:bind-address		= 0.0.0.0
1 Like
59

I’ve tried this and below is the result :

/etc/ssl/openssl.cnf
find: ‘/etc/lvm/backup’: Permission denied
find: ‘/etc/lvm/archive’: Permission denied
/etc/mysql/mariadb.conf.d/erpnext.cnf
/etc/mysql/my.cnf
/etc/mysql/debian.cnf
/etc/mysql/conf.d/settings.cnf
/etc/mysql/conf.d/mysqld_safe_syslog.cnf
/etc/mysql/conf.d/mariadb.cnf

But still i am unable to find the file.

60

You say this is not the file you require /etc/mysql/my.cnf

In my case that file worked for me.

edit: Here are docs to be found Configuring MariaDB with Option Files - MariaDB Knowledge Base

61

@clarkej thanks for your reply actually i am new here, i don’t have enough knowledge of ERPNext as how much you have, i am just following @noetico 's these steps, i am stuck in step no 4. i am unable to understand it properly.

extremely sorry for the late reply. try the following steps

1 - log into mysql, you can use bench mysql
2 - set privileges as follows: grant all privileges on databaseName TO ‘user’ @’%’ identified by ‘password’ with grant option; hit enter
3 - enter flush privileges; hit enter
4 - edit my.cnf to allow external connections as follows, navigate to etc/mysql and open the my.cnf file, look for bind-address 127.0
0.1 add a # in front of it, before it like so, #bind-address…
5 - add another line, #skip-networking
6 - save file, restart server
please dont make a mistake in the conf file.
all the best

62

Right there /etc/mysql/my.cnf

63

Many thanks @clarkej & @noetico i’ve found the file my.cnf
but it is not allowing me to edit the file. my user name is frappe, and the file owner is root, but i don’t have the root password, where can i get root password?

64

For user ‘frappe’ to edit that file that user account must have sudo privileges.

Run this to identify if that’s the case for you:
frappe@erpnext:~/frappe-bench$ groups
frappe adm cdrom sudo dip plugdev lpadmin sambashare libvirtd

If not then you will need to obtain or reset the root password…

65

how are you running erpnext? well check this out:

if you are the server owner you can actually change the password fairly easily and use sudo.

66

@noetico I’ve finished all above 6 points, but still getting this error while Click on Connect Server
Connection failed with error: Unable to connect to any of the specified MySQL hosts.
Now please tell me what to do next?

67

ok, maybe you should query the mysql users and see, remember when you use the grant privileges the part with identified by ‘password’ should have the password for that user.

also do this and see what you have.

at the mysql prompt type

use mysql;
select host, user, password from user;

then whats the output for each of these…

show grants for 'user'@'localhost';
show grants for 'user' @'%' ;

replace user with user name like root or frappe

68

hi
i try to install application in window 8 but show message this package not install window 8 or later

69

hey hii
i am got this error at connect server time how to solve dear i am confused how to solved… i am confused.

Connection failed with error: Authentication to host ‘192.168.0.15’ for user ‘root’ using method ‘mysql_native_password’ failed with message: Access denied for user ‘root’@‘192.168.0.102’ (using password: YES)

70

You are either using a wrong database password or your mysql is not allowing the connection.

71

currently i got this

Connection failed with error: SELECT command denied to user ‘localhost’@‘192.168.0.102’ for table ‘tabEmployee’