[ic] IC 5.2.0 mysql problem

[Mark Weaver]

Bryan D Gmyrek wrote:

>>>Killing Interchange server 17624 with TERM.
>>>Vend::Payment::AuthorizeNet payment module initialized, using Net::SSLeay
>>>High traffic settings.
>>>Calling UI......UI is loaded...
>>>Interchange V5.2.0
>>>Configuring catalog store...Using MySQL, DSN=dbi:mysql:store...table
>>>'tree'
>>>failed: connect failed (create) -- Access denied for user:
>>>'interch at localhost' (Using password: NO)
>>>done.
>>>Interchange server started in UNIX mode(s) (process id 17707)
>>>
>>>I've checked and double checked the mysql password and the variable.txt
>>>file.  I am able to log into mysql using
>>>mysql -uinterch -pmypassword
>>>
>>>DBI version is 1.40
>>>
>>>Tried looking in the ic code to find where mysql is accessed and if the
>>>password is being passed properly but wasn't able to figure that out.  Any
>>>other ideas? I'm tapped out...
>>>
>>>Thanks,
>>>Bryan
>>
>>Are you accessing mysql through "localhost" or from another machine? If
>>another machine then the IP address could be the problem.
> 
> 
>>From localhost...
> 
> 
>>grant all privileges on store.* to interch at xxx.xxx.xxx.xxx identified by
>>"password" with grant option;
>>
> 
> To check I did this ... though like I said it was working before so...
>  GRANT ALL PRIVILEGES ON store.* TO 'interch'@'localhost' IDENTIFIED BY
> 'pass' WITH GRANT OPTION;
> 
> Still get same error on ic restart.
> 
> It does work if I set the users password like so:
>  GRANT ALL PRIVILEGES ON store.* TO 'interch'@'localhost' IDENTIFIED BY
> '' WITH GRANT OPTION;
> 
> And remove the password from the variable.txt so that it looks like
> SQLDSN	dbi:mysql:store	Database
> SQLPASS		Database
> SQLUSER	interch	Database
> 
> However, somehow this doesn't seem so secure to me ;-}
> 
> Bryan

Do you have MySQL Administrator? If you do you should be able to check 
and see what the security settings are on the database that MySQL has 
for the user interch. It sounds to me like the db user interch doesn't 
have a password set or its set to null. Course, I may have this all back 
to front and the problem is on the Interchange side. Let me check my 
variable.txt file and see what I've got and I'll post it back here for 
comparison.

-- 
Mark Weaver
American Micro - Webmaster
1-800-558-2058