teknosains / rest-crud Goto Github PK

Hi, I'm quite new in using express.

I try to run this CRUD without internet. And it always show "Cannot Connect" when accessing database.
Is there any method I can do/need to install to make it able to run in my laptop without Internet?
Thanks!

After successful installation and starting of the server, it says "Welcome" but when I go to any URL (e.g. "localhost:3000/user") it shows an error page: "Cannot GET /user". The database was created and seeded using the t_user.sql file.

mysql> select * from t_user;
+---------+------------+--------------------+--------------------+
| user_id | name       | email              | password           |
+---------+------------+--------------------+--------------------+
|       1 | Mas Banyar | [email protected]   | 23235645yghgf      |
|       2 | Mas Mapmup | [email protected]   | dncskdcndscsdcdsc  |
|       4 | Boronong   | [email protected] | 032bcsjdncsdjc3223 |
|       5 | Nadya Ek   | [email protected]    | bonbon032932       |
+---------+------------+--------------------+--------------------+
4 rows in set (0.00 sec)

Are there any additional instructions that are required to make it work despite not being mentioned in the project readme?

The port seems to cause an error ECONNREFUSED from mysqld when the system uses a random port.

Adding the below fixes issue:
port : '/var/run/mysql/mysql.sock' // or whereever your systems socket is stored

Hi

when i run node server.js file
localhost:3000 - redirected to welcome page
when i use
localhost:3000/user - it getting error in localhost/user

i have connected db and table is correct and contains data.
can u please tell what is the exception here occuring.

Hey,

I think line 24 in user.js should be <td><%=data[i].user_id%></td>, because otherwise if you delete a user from the middle of the table, it won't be in sync with the database IDs anymore.

Cheers.