<div style="font-family: arial; font-size: 14px;"><div fr-original-style="" style="box-sizing: border-box;">Try putting quotes around the database password.</div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div fr-original-style="" style="box-sizing: border-box;" contenteditable="false"><span fr-original-style="" style="box-sizing: border-box;"> </span></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><hr id="previousmessagehr" fr-original-style="" style="box-sizing: border-box; clear: both; user-select: none;"><div fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">From</strong>: "Boubacar Bah" <bahbouba.909@gmail.com><br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">Sent</strong>: 9/17/21 1:22 PM<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">To</strong>: mapserver-users@lists.osgeo.org<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="box-sizing: border-box; font-weight: 700;">Subject</strong>: [mapserver-users] asking help about python except databsaseError syntaxe</span></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div dir="ltr" fr-original-style="" style="box-sizing: border-box;">Hi everyone<br fr-original-style="" style="box-sizing: border-box;">currently I am on a python script in the I am using the psycopg2 to connect to a database<br fr-original-style="" style="box-sizing: border-box;">now at con = none<br fr-original-style="" style="box-sizing: border-box;">I try to connect to my database and make an insertion in my postgis database after this request I try to manage the except in case of error; This is where the script is problematic then the day of apache error says that the except synstax has an error but after having this several times I can't find the problem. below I send you the script and error log if someone can help me solve the problem.<div fr-original-style="" style="box-sizing: border-box;">this is my script cgi:</div><div fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="color:rgb(212,212,212);background-color:rgb(30,30,30);font-family:Consolas,"Courier New",monospace;font-size:14px;line-height:19px;white-space:pre;" style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, "Courier New", monospace; font-size: 14px; line-height: 19px; white-space: pre; box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;">con = <span fr-original-style="color:rgb(86,156,214);" style="color: rgb(86, 156, 214); box-sizing: border-box;">None</span></div><div fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="color:rgb(197,134,192);" style="color: rgb(197, 134, 192); box-sizing: border-box;">try</span>:</div><div fr-original-style="" style="box-sizing: border-box;">   con = psycopg2.connect(<span fr-original-style="color:rgb(156,220,254);" style="color: rgb(156, 220, 254); box-sizing: border-box;">host</span>=<span fr-original-style="color:rgb(206,145,120);" style="color: rgb(206, 145, 120); box-sizing: border-box;">"localhost"</span>, <span fr-original-style="color:rgb(156,220,254);" style="color: rgb(156, 220, 254); box-sizing: border-box;">database</span>=<span fr-original-style="color:rgb(206,145,120);" style="color: rgb(206, 145, 120); box-sizing: border-box;">"webmapping"</span>, <span fr-original-style="color:rgb(156,220,254);" style="color: rgb(156, 220, 254); box-sizing: border-box;">user</span>=<span fr-original-style="color:rgb(206,145,120);" style="color: rgb(206, 145, 120); box-sizing: border-box;">"postgres"</span>, <span fr-original-style="color:rgb(156,220,254);" style="color: rgb(156, 220, 254); box-sizing: border-box;">password</span>=<span fr-original-style="color:rgb(181,206,168);" style="color: rgb(181, 206, 168); box-sizing: border-box;">97071884</span>)</div><div fr-original-style="" style="box-sizing: border-box;">   cur = con.cursor()</div><div fr-original-style="" style="box-sizing: border-box;">   cur.execute(<span fr-original-style="color:rgb(206,145,120);" style="color: rgb(206, 145, 120); box-sizing: border-box;">"insert into points(geom) values((SELECT ST_GeometryFromText('POINT(</span><span fr-original-style="color:rgb(86,156,214);" style="color: rgb(86, 156, 214); box-sizing: border-box;">%s</span><span fr-original-style="color:rgb(206,145,120);" style="color: rgb(206, 145, 120); box-sizing: border-box;"> </span><span fr-original-style="color:rgb(86,156,214);" style="color: rgb(86, 156, 214); box-sizing: border-box;">%s</span><span fr-original-style="color:rgb(206,145,120);" style="color: rgb(206, 145, 120); box-sizing: border-box;">)',4326)))"</span>,(coordx,coordy,))</div><div fr-original-style="" style="box-sizing: border-box;">   con.commit()</div><div fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="color:rgb(197,134,192);" style="color: rgb(197, 134, 192); box-sizing: border-box;">except</span> psycopg2.DatabaseError, e:</div><div fr-original-style="" style="box-sizing: border-box;">   <span fr-original-style="color:rgb(220,220,170);" style="color: rgb(220, 220, 170); box-sizing: border-box;">print</span>(<span fr-original-style="color:rgb(206,145,120);" style="color: rgb(206, 145, 120); box-sizing: border-box;">"Error </span><span fr-original-style="color:rgb(86,156,214);" style="color: rgb(86, 156, 214); box-sizing: border-box;">%s</span><span fr-original-style="color:rgb(206,145,120);" style="color: rgb(206, 145, 120); box-sizing: border-box;">"</span>) % e </div><div fr-original-style="" style="box-sizing: border-box;">   sys.exit(<span fr-original-style="color:rgb(181,206,168);" style="color: rgb(181, 206, 168); box-sizing: border-box;">1</span>)   </div><div fr-original-style="" style="box-sizing: border-box;"><span fr-original-style="color:rgb(197,134,192);" style="color: rgb(197, 134, 192); box-sizing: border-box;">finally</span>:</div><div fr-original-style="" style="box-sizing: border-box;">  <span fr-original-style="color:rgb(197,134,192);" style="color: rgb(197, 134, 192); box-sizing: border-box;">if</span> con:</div><div fr-original-style="" style="box-sizing: border-box;">     con.close()</div><div fr-original-style="" style="box-sizing: border-box;">this is my log error bellow:</div><div fr-original-style="" style="box-sizing: border-box;">[Thu Sep 16 20:52:16.176534 2021] [cgi:error] [pid 2852:tid 1232] [client ::1:59242] AH01215:   File "C:\\ms4w\\Apache\\cgi-bin\\suivi_gps.cgi", line 32\r: C:/ms4w/Apache/cgi-bin/suivi_gps.cgi<br fr-original-style="" style="box-sizing: border-box;">[Thu Sep 16 20:52:16.176534 2021] [cgi:error] [pid 2852:tid 1232] [client ::1:59242] AH01215:     except psycopg2.DatabaseError, e:\r: C:/ms4w/Apache/cgi-bin/suivi_gps.cgi<br fr-original-style="" style="box-sizing: border-box;">[Thu Sep 16 20:52:16.176534 2021] [cgi:error] [pid 2852:tid 1232] [client ::1:59242] AH01215:                                  ^\r: C:/ms4w/Apache/cgi-bin/suivi_gps.cgi<br fr-original-style="" style="box-sizing: border-box;">[Thu Sep 16 20:52:16.176534 2021] [cgi:error] [pid 2852:tid 1232] [client ::1:59242] AH01215: SyntaxError: invalid syntax\r: C:/ms4w/Apache/cgi-bin/suivi_gps.cgi</div><div fr-original-style="" style="box-sizing: border-box;">if someone can suppose me idea to solve this problem</div><div fr-original-style="" style="box-sizing: border-box;">thanks</div></div></div></div></div>