VoIP Community of Thailand - เว็บบอร์ด VoIP Issabel, Elastix Asterisk FreePBX IPPhone VoIP Gateway Call Center IPPBX ของไทย โดยคนไทย เพื่อคนไทย

พอดีผมลง VSC และ VSR มาหมดแล้วครับติดปีญหาตัว voipswitch portal อย่างเดียวครับ error ตามนี้เลยครับ


Server Error in '/Portal' Application.
--------------------------------------------------------------------------------

ERROR [HY000] [MySQL][ODBC 3.51 Driver]Access denied for user 'raweeharee'@'rawee-6cbfb4198' (using password: NO)
ERROR [HY000] [MySQL][ODBC 3.51 Driver]Access denied for user 'raweeharee'@'rawee-6cbfb4198' (using password: NO)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 3.51 Driver]Access denied for user 'raweeharee'@'rawee-6cbfb4198' (using password: NO)
ERROR [HY000] [MySQL][ODBC 3.51 Driver]Access denied for user 'raweeharee'@'rawee-6cbfb4198' (using password: NO)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[OdbcException: ERROR [HY000] [MySQL][ODBC 3.51 Driver]Access denied for user 'raweeharee'@'rawee-6cbfb4198' (using password: NO)
ERROR [HY000] [MySQL][ODBC 3.51 Driver]Access denied for user 'raweeharee'@'rawee-6cbfb4198' (using password: NO)]
Microsoft.Data.Odbc.OdbcConnection.Open() +539
API.DataServices.MySQLGetScalar(String query) in C:\Documents and Settings\void\Moje dokumenty\Visual Studio 2005\Projects\Portal\API\DataServices.cs:115
Main.UpdateView() +215
Main.Page_Load(Object sender, EventArgs e) +5
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053

ผมว่า error น่าจะเกิดจาก file web.config เลยเอา source code มาให้ช่วยแก้ไขครับ
<?xml version="1.0"?>
<!--
Note: As an alternative to hand editing this file you can use the
web admin tool to configure settings for your application. Use
the Website->Asp.Net Configuration option in Visual Studio.
A full list of settings and comments can be found in
machine.config.comments usually located in
\Windows\Microsoft.Net\Framework\v2.x\Config
-->
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<configSections>
<sectionGroup name="ajaxNet">
<section name="ajaxSettings" type="Ajax.AjaxSettingsSectionHandler, Ajax"/>
<section name="ajaxConverters" type="Ajax.AjaxConverterSectionHandler, Ajax"/>
</sectionGroup>
</configSections>

<!-- Portal Config -->
<appSettings>
<add key="PortalUrl" value="http://localhost/Portal/"/>
<add key="PortalTitle" value="Voipswitch Portal"/>
<add key="Style" value="Orange"/>
<add key="Currency" value="THB"/>
<!-- Database configuration -->
<add key="DataBase" value="MYSQL"/>
<add key="Server" value="192.168.1.XXX"/>
<add key="Catalog" value="Voipswitch"/>
<add key="Username" value="raweeharee"/>
<add key="Password" value="XXXXXXX"/>
<!-- Language configuration -->
<add key="DefaultLanguage" value="EN"/>
<add key="LanguageDir" value="C:\\inetpub\\wwwroot\\Portal\\Languages"/>
<!-- Online shop configuration -->
<!-- Catalog -->
<add key="Referrer" value="http://localhost/OnlineShop/"/>

<add key="serveraddress" value="192.168.1.147" />
</appSettings>

<connectionStrings/>

<ajaxNet>
<ajaxSettings>
<commonAjax enabled="false" path="portal.js" language="javascript"/>
<temporaryFiles path="~/styles" deleteAfter="1"/>
<urlNamespaceMappings>
<add namespace="Portal.AjaxMethods,Portal" path="MyDemoMethods"/>
</urlNamespaceMappings>
</ajaxSettings>
</ajaxNet>
<system.web>
<httpHandlers>
<add verb="POST,GET" path="virtfolderforhttphandler/*.ashx" type="Ajax.PageHandlerFactory, Ajax"/>
</httpHandlers>

<!--
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
-->
<compilation defaultLanguage="c#" debug="true">
<compilers>
<compiler language="c#" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" extension=".cs" compilerOptions="/d:DEBUG;TRACE"/>
</compilers>
<assemblies>
<add assembly="Microsoft.Data.Odbc, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
</assemblies>
</compilation>

<pages enableSessionState="true" autoEventWireup="true"/>
<sessionState mode="InProc" cookieless="false" timeout="20"/>
<httpModules>

</httpModules>


<!--
The <authentication> section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user.
-->
<authentication mode="Windows"/>
<!--
The <customErrors> section enables configuration
of what to do if/when an unhandled error occurs
during the execution of a request. Specifically,
it enables developers to configure html error pages
to be displayed in place of a error stack trace.
<customErrors mode="RemoteOnly"/>
-->
<customErrors mode="RemoteOnly" defaultRedirect="error500.html">
<error statusCode="403" redirect="error403.html" />
<error statusCode="404" redirect="error404.html" />
<error statusCode="500" redirect="error500.html" />
</customErrors>

</system.web>
</configuration>


รบกวนด้วยนะครับขอบคุณมากครับเพิ่มเติมอีกนิดครับ error ข้างบนผมเข้า url นี้ครับ
http://localhost/portal/main.aspx

แล้วถ้าผใช้ url นี้ http://localhost/portal/ ก็จะเกิด error ตามข้างล่างนี่ครับผมจะต้องใช้อันไหนเข้าครับ
The website declined to show this webpage
HTTP 403
Most likely causes:
•This website requires you to log in.

What you can try:
Go back to the previous page.

More information
แล้วถ้า click more information ก้จะเจอ


This error (HTTP 403 Forbidden) means that Internet Explorer was able to connect to the website, but it does not have permission to view the webpage.

For more information about HTTP errors, see Help.

มีปัญหาตอนคอนเน็คเข้าดาต้าเบสหน่ะครับ MySQL มัน Deny ตอนจะคอนเน็คเข้าไป เช็ค Username/Password

ทำยังไงดีอะครับรองเปลี่ยน version ของ MYSQL ดูดีไหมครับผมใช้ version 5.5.8 อยู่ครับ