Facebook
Twitter
L
Leighm0
Guest
I have just recently found a bug with plesk 8.1 for windows which involves the creation of mysql db's.
I have never had domains with numbers at the beginning but now a client has joined with one and normally when we add them into Plesk we create the domain/client, the username is normally the domain name without the .com etc.. and then we normally create a db with the same name and all ftp username and db username etc etc.. so its all pretty much uniform so its easy for us and easy for client to remember etc.
The mySQL db errors like so when using a numeral at the start of the db name: Error connecting to mySQL server... at which point i was curious because it was running fine.. so I went to the Event Log on server under Plesk and found the following:
Failed to connect to database: Can't connect to MySQL server on 'localhost' (10061)
at (MySQLDatabaseProvider::connect line 213)
at execute console command --check(vconsoleapp: tart line 128)
at execute "C:\Program Files\SWsoft\Plesk\admin\bin\mysqlmng.exe" --check "--server=localhost" "--port=4companyname" "--login=admin"
It was using the database name i had chosen for the Port.. kind of odd since shouldnt it be 3306.. and why in the heck was plesk telling the command line that the port was the db name.. interesting..
Anyway so i made it without the number 4 infront, and then also found out it wouldnt let me create a username on mysql access with a number either..
I guess its no real big issue, all i did was change all the other usernames to not inlcude the 4 so its all uniform like we have for all clients... but it was kind of silly that it screwed up the way it did..
I have never had domains with numbers at the beginning but now a client has joined with one and normally when we add them into Plesk we create the domain/client, the username is normally the domain name without the .com etc.. and then we normally create a db with the same name and all ftp username and db username etc etc.. so its all pretty much uniform so its easy for us and easy for client to remember etc.
The mySQL db errors like so when using a numeral at the start of the db name: Error connecting to mySQL server... at which point i was curious because it was running fine.. so I went to the Event Log on server under Plesk and found the following:
Failed to connect to database: Can't connect to MySQL server on 'localhost' (10061)
at (MySQLDatabaseProvider::connect line 213)
at execute console command --check(vconsoleapp: tart line 128)
at execute "C:\Program Files\SWsoft\Plesk\admin\bin\mysqlmng.exe" --check "--server=localhost" "--port=4companyname" "--login=admin"
It was using the database name i had chosen for the Port.. kind of odd since shouldnt it be 3306.. and why in the heck was plesk telling the command line that the port was the db name.. interesting..
Anyway so i made it without the number 4 infront, and then also found out it wouldnt let me create a username on mysql access with a number either..
I guess its no real big issue, all i did was change all the other usernames to not inlcude the 4 so its all uniform like we have for all clients... but it was kind of silly that it screwed up the way it did..