Minilogin to public server? (i'll settle for the minilogin source code)

[Aerewen]

setting it to null will cause it to auto increment as well. as memory serves me older versions of MySQL will spit out an error if your insert query doesnt specify at least a null value for a key

[John Adams]

Just because I am in an argumentive mood today (grin), no value passed would also be NULL.

Ok, I am done.

[Aerewen]

Just to sustain your mood :p

You are correct, however if someone were to type in an emty set of quotes or a 0 there thinking it was a mistake in my post, then the query wouldnt work

which is why i added the column and the NULL value to the query

[John Adams]

Oddly, my mood changed once I left work.

You win. Uncle!!

[Cyro]

Okay, using this PHP fix...when i type in my username and password, internet explorer eventually comes up with the error of "cannot load page"
However, i know it connects because I can see the attempts to connect in the minilogin.exe...

Any ideas? My thoughts were that I needed to change something about the MySql access...

Below are my files, copied and pasted verbatim (aside from making the user/pass blank)

~~~~~~~~~~~~~~~~~~
Index.php
~~~~~~~~~~~~~~~~~~
Put this page on your site after setting the variables below to
the information of the MySQL database with the PEQ info in it.
*/
$DB_ADDY = "eqemu.no-ip.biz:5999"; //address:port for the MySQL server
$DB_USER = ""; //username to login to MySQL with
$DB_PASS = ""; //password to login to MySQL with
$DB_DB = "ax"; //database name to use "peq" for default installation

$server_name = "Shadows of Hatred"; //set the name of your server here
$admin_level = 250; //default level of admin to give to people who sign up
//This WILL NOT modify admin of people logging in to the server.

~~~~~~~~~~~~~~~~~~~
Loginserver.ini
~~~~~~~~~~~~~~~~~~~
[LoginServer]
loginserver=eqemu.no-ip.biz
loginport=5999
worldname=Shadows of Hatred
worldaddress=eqemu.no-ip.biz
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=
[ChatChannelServer]

worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=MiniLogin
ServerPort=5999

~~~~~~~~~~~~~~~~~~~
eqemu_config.xml
~~~~~~~~~~~~~~~~~~~
<?xml version="1.0">
<server>
<world>
<shortname>Minilogin</shortname>
<longname>Shadows of Hatred</longname>

<!-- Only specify these two if you really think you need to. -->
<address>eqemu.no-ip.biz</address>
<localaddress>127.0.0.1</localaddress>

<!-- Loginserver information. -->
<loginserver>
<host>eqemu.no-ip.biz</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>
<unlocked/>
<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>some long random string</key>

<!-- Enable and set the port for the HTTP service. -->
<tcp ip="eqemu.no-ip.biz" port="9000" telnet="enable"/>
<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<!-- Database configuration, replaces db.ini. -->
<database>
<host>eqemu.no-ip.biz</host>
<port>3306</port>
<username></username>
<password></password>
<db>ax</db>
</database>
</server>


Can anyone shed some light...please? It would be GREATLY appreciated!!!
Thanks in advance,
-Cyro

[LordHogFred]

Ok I'm getting some really horrible errors:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Inetpub\wwwroot\eqlogin\index.php on line 119

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 120

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 122

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 123

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 158

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 159

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\eqlogin\index.php on line 163

Any ideas?

[John Adams]

Yeah, google this:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Tons of posts about this on the net.