| Author |
 Topic  |
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
 Posted - 17 November 2009 : 08:35:51
|
Hi,
I run a forum which is recently converted from MS Access mySQL. The site is built using MS FrontPage, including forms and other special FrontPage extensions.
I’m now spending my time preparing the hole site for a migration to a complete CMS and Portal solution, and thus I need to make the site independent of FrontPage Extensions.
In my work cleaning the code I shift between MS FrontPAge and Visual Studio 2008.
While doing this the discussion forum suddenly stopped (again), and I can’t understand why.
---------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver]Access denied for user 'tuser1213'@'tjatte.kontrollpanelen.se' (using password: YES)
/diskussion/inc_header.asp, line 111
---------------------------
I looked at the connection string, and it looks OK to me.
---------------------------
strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=mysql5.XXXXXXXXXXX;port=XXXX;user=XXXXXXXX;password=XXXXXXXXX;DATABASE=XXXXXXX_snitz;" '## MySQL w/ MyODBC v3.51
---------------------------
What have I done wrong?
Thanks / Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 17 November 2009 : 09:24:46
|
| Which version of Snitz are you using? |
 |
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 17 November 2009 : 09:45:33
|
| 3.4.07 |
!-Keep distance in traffic-!
www.whiplashinfo.se |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 17 November 2009 : 13:06:43
|
I helped torborg do the conversion and the connection string is correct. We spoke to the host about the problem before, they don't know what was wrong either, but they changed the password for him and then it was ok once again. Now the same problem occurs. The connection string hasn't been changed.
I don't know of MS Frontpage messing with the mysql server.
This seems more like a mysql server problem, is it not? |
Support Snitz Forums
|
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 17 November 2009 : 16:09:10
|
Don't know if it is essential, but when I open the site in Visual Studio 2008, I recieve a pop up windows saying
---------------
Unable to open the Web site "http://www.whiplashinfo.se/diskussion". Server error : There is no web named "/diskussion". If this web site exists on the server, check to make sure FrontPage Server Extensions are installed, and that you have the permission to access the server.
---------------
Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 17 November 2009 : 17:35:24
|
Are you sure the username and domain are correct for mysql server? Is the mysql server on a different computer than the web server? Because if they db is on the same computer as the web server you'd typically be using 'localhost' as the server, not 'tjatte.kontrollpanelen.se'
There is a pretty long chapter on mysql authentication in the mysql documentation.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 17 November 2009 : 18:34:06
|
We got the info for mysql server from the host. Whether the hosts knows what they are doing is another question.
When tomas first had this problem, I was able to log in to the server using SQLYog from my computer, while he was getting access denied on the forum.
Doing an ip address lookup, both www.whiplashinfo.se and tjatte.kontrollpanelen.se has the same ip address: 193.17.218.90 |
Support Snitz Forums
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 18 November 2009 : 02:44:38
|
Where is the forum code running? If it's on the same machine as the webserver try using 'localhost' in the connection string for the host. If you've tested the credentials from your computer using another mysql tool, and the forum code fails with the same credentials, there may be some incorrect entry in the mysql server host table.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 18 November 2009 : 03:53:58
|
quote:
Originally posted by Doug G
Where is the forum code running? If it's on the same machine as the webserver try using 'localhost' in the connection string for the host. If you've tested the credentials from your computer using another mysql tool, and the forum code fails with the same credentials, there may be some incorrect entry in the mysql server host table.
Using Localhost instead didn't help.
Still the same error code.
Tomas
|
!-Keep distance in traffic-!
www.whiplashinfo.se |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 18 November 2009 : 08:39:09
|
OK - I got an answer from my host. He says that the only thing they did was to reset the password to the mySQL database.
Now the forum shows, but I must have done something wrong again, as all images was gone. I loged in to the Admin menu and changed the paths to the fomrum, all other URL:s and the path to image folder.
After doing this, I suddenly end up in a loop trying to reach the Admin menu (after login of cource).
Thanks/ Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 18 November 2009 : 13:52:09
|
It seems working now tomas. I just checked your site.
If they have to keep resetting the password (as this is the 2nd time) there must be a problem somewhere. Dunno why a password reset is required unless the password in the mysql user table is being changed? |
Support Snitz Forums
|
|
|
| |
Topic |
|
Topic Locked
