Discussion :

[sybess]

Bonjour,

Je débute en Laravel. J'ai la version 5.5.
J'ai un problème pour accéder à une page web.
Si je met juste www.mondomaine.net, j'ai un message écrit assez joliment " Sorry, the page you are looking for could not be found. ".
Cependant, si je met www.mondomaine.net/api/test, j'ai une erreur 404 de mon navigateur.

J'aimerais pouvoir accéder à ma page en tapant : www.mondomaine.net/api/test
Auriez vous une idée de ce qu'il faut que je fasse, de ce qui ne va pas dans mon code ?
Voici le code ci-après :
RouteServiceProvider.php :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
<?php namespace App\Providers;
 
use Illuminate\Routing\Router;
use Illuminate\Foundation\Support\Providers\RouteServiceProvider as ServiceProvider;
 
class RouteServiceProvider extends ServiceProvider {
 
	/**
	 * This namespace is applied to the controller routes in your routes file.
	 *
	 * In addition, it is set as the URL generator's root namespace.
	 *
	 * @var string
	 */
	protected $namespace = 'App\Http\Controllers';
 
	/**
	 * Define your route model bindings, pattern filters, etc.
	 *
	 * @param  \Illuminate\Routing\Router  $router
	 * @return void
	 */
	public function boot(Router $router)
	{
		parent::boot($router);
 
		//
	}
 
	/**
	 * Define the routes for the application.
	 *
	 * @param  \Illuminate\Routing\Router  $router
	 * @return void
	 */
	public function map(Router $router)
	{
		$router->group(['namespace' => $this->namespace], function($router)
		{
			require app_path('Http/routes.php');
		});
	}
 
}

routes.php (il se trouve dans le dosser app/Http/)

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
<?php
 
/*
|--------------------------------------------------------------------------
| Application Routes
|--------------------------------------------------------------------------
|
| Here is where you can register all of the routes for an application.
| It's a breeze. Simply tell Laravel the URIs it should respond to
| and give it the controller to call when that URI is requested.
|
*/
 
Route::group(array('prefix' => 'api/test'), function()
{
	Route::resource('customers', 'CustomerController',
                ['only' => ['store', 'show', 'update']]);
	Route::get('/customers', 'CustomerController@showAll');
	Route::delete('/customers/{id}', 'CustomerController@delete');
});

Je vous remercie par avance pour votre réponse.

Cordialement

Sybess

[MaitrePylos]

Bonjour

Api/test ne pointe sur rien en regardant vos routes.
Pour savoir qu'elle sont les routes accessibles au départ de votre application demandez à Artisan de vous les lister

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
 
 
php artisan route:list

Vous pourrez alors visualisez l’ensemble de vos routes.

[sybess]

Bonjour,

Merci beaucoup pour votre réponse.
Cela veut dire le fichier RouteServiceProvider.php est correct et que le problème vient seulement de routes.php ?
Si je comprend bien, il faut que je tape www.mondomaine.net/api/test/customers pour que cela pointe vers quelque chose ?

Voici la réponse de php artisan route:liste :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
+--------+-----------+---------------------------------------+--------------------+---------------------------------------------------+------------+
| Domain | Method    | URI                                   | Name               | Action                                            | Middleware |
+--------+-----------+---------------------------------------+--------------------+---------------------------------------------------+------------+
|        | POST      | api/api/test/customers                | customers.store    | App\Http\Controllers\CustomerController@store     | api        |
|        | GET|HEAD  | api/api/test/customers                |                    | App\Http\Controllers\CustomerController@showAll   | api        |
|        | PUT|PATCH | api/api/test/customers/{customer}     | customers.update   | App\Http\Controllers\CustomerController@update    | api        |
|        | GET|HEAD  | api/api/test/customers/{customer}     | customers.show     | App\Http\Controllers\CustomerController@show      | api        |
|        | DELETE    | api/api/test/customers/{id}           |                    | App\Http\Controllers\CustomerController@delete    | api        |
|        | GET|HEAD  | api/test/customers                    |                    | App\Http\Controllers\CustomerController@showAll   | web        |
|        | POST      | api/test/customers                    | customers.store    | App\Http\Controllers\CustomerController@store     | web        |
|        | PUT|PATCH | api/test/customers/{customer}         | customers.update   | App\Http\Controllers\CustomerController@update    | web        |
|        | GET|HEAD  | api/test/customers/{customer}         | customers.show     | App\Http\Controllers\CustomerController@show      | web        |
|        | DELETE    | api/test/customers/{id}               |                    | App\Http\Controllers\CustomerController@delete    | web        |
+--------+-----------+---------------------------------------+--------------------+---------------------------------------------------+------------+

Si je comprend bien ce que me dit la commande php artisan, il faut que je tape www.mondomaine.net/api/api/test/customers. Mais là aussi j'ai une erreur 404 de mon navigateur.

Cordialement

Sybess

[MaitrePylos]

Oui et dans votre cas, vous vez des routes pour faire des api et des routes pour afficher dans un projet web.

[sybess]

Bonjour,

Ok, j'aimerais faire une api qui envoie des données de ma base de donnée en format json.
Est ce que le fichier routes.php est correct pour faire cela ?
De plus, quand je tape www.mondomaine.net/api/test/customers ou www.mondomaine.net/api/api/test/customers, j'ai une erreur 404 du navigateur. Je ne comprend toujours pas pourquoi.
Savez vous d'où cela peut-il venir ? Du fichier routes.php ?

Cordialement
Sybess

[MaitrePylos]

Qu'avez-vous dans App\Http\Controllers\CustomerController ?

[sybess]

Voici le contenu du fichier App\Http\Controllers\CustomerController.php

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<?php namespace App\Http\Controllers;
 
use App\Http\Requests;
use Illuminate\Http\Response;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use App\Customer;
use App\Inspection;
use Input;
use Validator;
use DateTime;
use Config;
use Illuminate\Database\Eloquent\ModelNotFoundException;
 
class CustomerController extends Controller {
 
	private static $DATE_NULL = '0000-00-00 00:00:00';
 
	public function store() {
 
		$input = Input::all();
        $validation = Validator::make($input, Customer::$rules);
 
        if ($validation->passes()) {
        	//Set the timezone
			$timezone = Config::get('app.timezone');
			date_default_timezone_set($timezone);
 
		    $input['cust_created_at'] = date('Y-m-d H:i:s');
 
    		$customer = Customer::create($input);
        	return response()->json($customer);
        }
 
        return response()->json(array(
                    'code'      =>  400,
                    'message'   =>  'Data is not valid'
                   ), 400);
	}
 
 
	public function show($id) {
		try {
			$customer = Customer::findOrFail($id);
 
	        return response()->json($customer->toArray());
       	}
	    catch(ModelNotFoundException $e) {
			return response()->json(array(
                    'code'      =>  404,
                    'message'   =>  'Customer not found'
                   ), 404);
		}
	}
 
	public function update($id) {
		try {
			$customer = Customer::findOrFail($id);
 
		    $validator = Validator::make($data = Input::all(), Customer::$rules);
 
		    if ($validator->fails()) {
		        return response()->json(array(
	                    'code'      =>  400,
	                    'message'   =>  'Data is not valid'
	                   ), 400);     
		    }
 
		    //Set the timezone
			$timezone = Config::get('app.timezone');
			date_default_timezone_set($timezone);
 
		    $data['cust_updated_at'] = date('Y-m-d H:i:s');
		    $bool = $customer->update($data);
		    return response()->json(array('success' => $bool));
		}
	    catch(ModelNotFoundException $e) {
			return response()->json(array(
                    'code'      =>  404,
                    'message'   =>  'Customer not found'
                   ), 404);
		}
	}
 
	public function showAll() {
		$lastUpdateDate = Input::get('last_update_date');
 
		//Requete without the last update date
		if(empty($lastUpdateDate)) {
			$customers = Customer::where('cust_deleted_at', '=', CustomerController::$DATE_NULL)
								->orderBy('cust_name', 'asc')
				   				->get();
		}
		else {
			$customers = Customer::where('cust_created_at', '>', $lastUpdateDate)
								->orWhere('cust_updated_at', '>', $lastUpdateDate)
								->orWhere('cust_deleted_at', '>', $lastUpdateDate)
								->orderBy('cust_name', 'asc')
				   				->get();
		}
 
        return response()->json($customers->toArray());
	}
 
 
	public function delete($id) {
		try {
                   $customer = Customer::findOrFail($id);
 
		    //Set the timezone
			$timezone = Config::get('app.timezone');
			date_default_timezone_set($timezone);
 
			$now = date('Y-m-d H:i:s');
	        $customer->cust_deleted_at = $now;
 
	        Inspection::where('insp_cust_id', $id)->update(array('insp_deleted_at' => $now));
		    $bool = $customer->save();
		    return response()->json(array('success' => $bool));
       	}
	    catch(ModelNotFoundException $e) {
			return response()->json(array(
                    'code'      =>  404,
                    'message'   =>  'Customer not found'
                   ), 404);
		}
	}
}

[MaitrePylos]

ligne 101, mettez un dd($customers) pour voir si on arrive jusque là ?

[sybess]

J'ai rajouté dd($customers) à la ligne 101 du fichier app/Http/Controllers/CustomerController.php.
J'ai tapé www.mondomaine.net/api/api/test/customers et www.mondomaine.net/api/api/test/customers dans la barre d'adresse.
Cependant, j'ai toujours une erreur 404 de la part du navigateur, pour les 2.

[MaitrePylos]

ok, avez vous bien un fichier .htaccess, le alloweride de apache est bien à all,avez vous bien activé le rewrite ?

[sybess]

Où devrait se trouver le fichier .htaccess ?
Car en tout cas je n'en ai pas dans le dossier principal, ni dans le dossier public.

Le alloweride de apache : Je ne sais pas ce que c'est, ni où chercher pour le trouver.

pour le rewrite : j'ai tapé la commande a2ensite rewrite, la réponse : ERROR: Site rewrite does not exist!

Auriez vous une solution ?

[MaitrePylos]

le fichier .htaccess doit se trouver dans public

c'est sudo a2enrewrite (faut relancer apache après)

le alloweride se trouve dans les fichier de conf apache sous debian/ubuntu c'est /etc/apache2/

[sybess]

Ok,
Alors voici ce qui se trouve dans le fichier public/.htaccess :

Code apache :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<IfModule mod_rewrite.c>
    <IfModule mod_negotiation.c>
        Options -MultiViews -Indexes
    </IfModule>
 
    RewriteEngine On
 
    # Handle Authorization Header
    RewriteCond %{HTTP:Authorization} .
    RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
 
    # Redirect Trailing Slashes If Not A Folder...
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteCond %{REQUEST_URI} (.+)/$
    RewriteRule ^ %1 [L,R=301]
 
    # Handle Front Controller...
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteRule ^ index.php [L]
</IfModule>

J'ai tapé sudo a2enrewrite, cependant, j'ai la réponse : sudo: a2enrewrite: command not found


Voici ce que contient le fichier /etc/apache2/apache2.conf :

Code apache :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
# This is the main Apache server configuration file.  It contains the
# configuration directives that give the server its instructions.
# See http://httpd.apache.org/docs/2.4/ for detailed information about
# the directives and /usr/share/doc/apache2/README.Debian about Debian specific
# hints.
#
#
# Summary of how the Apache 2 configuration works in Debian:
# The Apache 2 web server configuration in Debian is quite different to
# upstream's suggested way to configure the web server. This is because Debian's
# default Apache2 installation attempts to make adding and removing modules,
# virtual hosts, and extra configuration directives as flexible as possible, in
# order to make automating the changes and administering the server as easy as
# possible.
 
# It is split into several files forming the configuration hierarchy outlined
# below, all located in the /etc/apache2/ directory:
#
#       /etc/apache2/
#       |-- apache2.conf
#       |       `--  ports.conf
#       |-- mods-enabled
#       |       |-- *.load
#       |       `-- *.conf
#       |-- conf-enabled
#       |       `-- *.conf
#       `-- sites-enabled
#               `-- *.conf
#
#
# * apache2.conf is the main configuration file (this file). It puts the pieces
#   together by including all remaining configuration files when starting up the
#   web server.
#
# * ports.conf is always included from the main configuration file. It is
#   supposed to determine listening ports for incoming connections which can be
#   customized anytime.
#
# * Configuration files in the mods-enabled/, conf-enabled/ and sites-enabled/
#   directories contain particular configuration snippets which manage modules,
#   global configuration fragments, or virtual host configurations,
#   respectively.
#
#   They are activated by symlinking available configuration files from their
#   respective *-available/ counterparts. These should be managed by using our
#   helpers a2enmod/a2dismod, a2ensite/a2dissite and a2enconf/a2disconf. See
#   their respective man pages for detailed information.
#
# * The binary is called apache2. Due to the use of environment variables, in
#   the default configuration, apache2 needs to be started/stopped with
#   /etc/init.d/apache2 or apache2ctl. Calling /usr/bin/apache2 directly will not
#   work with the default configuration.
 
 
# Global configuration
#
 
#
# ServerRoot: The top of the directory tree under which the server's
# configuration, error, and log files are kept.
#
# NOTE!  If you intend to place this on an NFS (or otherwise network)
# mounted filesystem then please read the Mutex documentation (available
# at <URL:http://httpd.apache.org/docs/2.4/mod/core.html#mutex>);
# you will save yourself a lot of trouble.
#
# Do NOT add a slash at the end of the directory path.
#
#ServerRoot "/etc/apache2"
 
#
# The accept serialization lock file MUST BE STORED ON A LOCAL DISK.
#
#Mutex file:${APACHE_LOCK_DIR} default
 
#
# The directory where shm and other runtime files will be stored.
#
 
DefaultRuntimeDir ${APACHE_RUN_DIR}
 
#
# PidFile: The file in which the server should record its process
# identification number when it starts.
# This needs to be set in /etc/apache2/envvars
#
PidFile ${APACHE_PID_FILE}
 
#
# Timeout: The number of seconds before receives and sends time out.
#
Timeout 300
 
#
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive On
 
#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 100
 
#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 5
 
 
# These need to be set in /etc/apache2/envvars
User ${APACHE_RUN_USER}
Group ${APACHE_RUN_GROUP}
 
#
# HostnameLookups: Log the names of clients or just their IP addresses
# e.g., www.apache.org (on) or 204.62.129.132 (off).
# The default is off because it'd be overall better for the net if people
# had to knowingly turn this feature on, since enabling it means that
# each client request will result in AT LEAST one lookup request to the
# nameserver.
#
HostnameLookups Off
 
# ErrorLog: The location of the error log file.
# If you do not specify an ErrorLog directive within a <VirtualHost>
# container, error messages relating to that virtual host will be
# logged here.  If you *do* define an error logfile for a <VirtualHost>
# container, that host's errors will be logged there and not here.
#
ErrorLog ${APACHE_LOG_DIR}/error.log
 
#
# LogLevel: Control the severity of messages logged to the error_log.
# Available values: trace8, ..., trace1, debug, info, notice, warn,
# error, crit, alert, emerg.
# It is also possible to configure the log level for particular modules, e.g.
# "LogLevel info ssl:warn"
#
LogLevel warn
 
# Include module configuration:
IncludeOptional mods-enabled/*.load
IncludeOptional mods-enabled/*.conf
 
# Include list of ports to listen on
Include ports.conf
 
 
# Sets the default security model of the Apache2 HTTPD server. It does
# not allow access to the root filesystem outside of /usr/share and /var/www.
# The former is used by web applications packaged in Debian,
# the latter may be used for local directories served by the web server. If
# your system is serving content from a sub-directory in /srv you must allow
# access here, or in any related virtual host.
<Directory />
        Options FollowSymLinks
        AllowOverride None
        Require all denied
</Directory>
 
<Directory /usr/share>
        AllowOverride None
        Require all granted
</Directory>
 
<Directory /var/www/>
        Options Indexes FollowSymLinks
        AllowOverride None
        Require all granted
</Directory>
 
#<Directory /srv/>
#       Options Indexes FollowSymLinks
#       AllowOverride None
#       Require all granted
#</Directory>
 
 
 
 
# AccessFileName: The name of the file to look for in each directory
# for additional configuration directives.  See also the AllowOverride
# directive.
#
AccessFileName .htaccess
 
#
# The following lines prevent .htaccess and .htpasswd files from being
# viewed by Web clients.
#
<FilesMatch "^\.ht">
        Require all denied
</FilesMatch>
 
 
#
# The following directives define some format nicknames for use with
# a CustomLog directive.
#
# These deviate from the Common Log Format definitions in that they use %O
# (the actual bytes sent including headers) instead of %b (the size of the
# requested file), because the latter makes it impossible to detect partial
# requests.
#
# Note that the use of %{X-Forwarded-For}i instead of %h is not recommended.
# Use mod_remoteip instead.
#
LogFormat "%v:%p %h %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" vhost_combined
LogFormat "%h %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %O" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agent
 
# Include of directories ignores editors' and dpkg's backup files,
# see README.Debian for details.
 
# Include generic snippets of statements
IncludeOptional conf-enabled/*.conf
 
# Include the virtual host configurations:
IncludeOptional sites-enabled/*.conf
 
# vim: syntax=apache ts=4 sw=4 sts=4 sr noet

[sybess]

J'ai trouvé la solution au problème.
il fallait taper sudo a2enmod rewrite.
Le problème est corrigé.

[sybess]

Bonsoir,

J'ai maintenant un autre problème.
J'ai bien créé ma base de donnée et fais les migrations pour avoir les tables dans la base de donnée.
Cependant, quand je tape www.mondomaine.net/api/test/customers dans la barre d'adresse, j'arrive sur une page d'erreur de laravel qui me dit : "SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from `customers` where `customers`.`id` = 1 limit 1)"

Je présume que cela vient d'un problème de droit pour l'accès à la base de donnée.
Cependant, je n'ai aucune idée de comment résoudre ce problème, bien que j'ai passé plusieurs heures à chercher sur Internet.
Auriez-vous idée pour résoudre mon problème ?

Cordialement

Sybess