Help - Installed My...
 
Notifications
Clear all

Help - Installed Mysql now i get SOLIDCP error

7 Posts
2 Users
0 Reactions
1,601 Views
Posts: 11
Topic starter
(@pythonit)
Active Member
Joined: 9 years ago

installed mysql on the standalone server, Mysql5.5 (installed the SQL connector)

on SOLIDCP > servers > Mysql > entered the password for mysql.

Error SOLIDCP error

Opening locally i get

As per the error, im guessing SQL the server is now trying to run Mysql as the default database?

Any thoughts on how to either disable mysql while i investigate or resolve the issue through configs?

Cheers

Dean

6 Replies
2 Replies
(@pythonit)
Joined: 9 years ago

Active Member
Posts: 11

UPDATE
Ive commented line 284, as suggested in the error.

Ive now got the site restored 🙂

But does anyone know how to fix the mysql install?

Cheers
Dean

Reply
Admin
(@m-tiggelaar)
Joined: 9 years ago

Noble Member
Posts: 1995

hmm how do you mean how to fix th SQL install?
to fix the SQL asp.net installer it self you mean?, that part i have no idea.
i did make the web.config fix by default in the 1.0.2 beta and will be included in the 1.0.2 stable in 10 days.

Reply
Posts: 11
Topic starter
(@pythonit)
Active Member
Joined: 9 years ago

Happy to wait in that case, im pretty sure its just a SQL application lookup (WebURL)

Ill send an update if i solve things in this version.

 

Cheers

Dean

Reply
Posts: 1995
Admin
(@m-tiggelaar)
Noble Member
Joined: 9 years ago

Ah i think i also misread your solution.

Actually the solution for an asp.net site is to remove the SQL driver in it's web.config:

https://solidcp.com/kb/update/manual-update/

scroll down to the "Updating the SolidCP Portal" and at the bottom you will see 1 minor provider change in the portal web.config

This will make sure the Portal is not affected by the mysql asp.net driver.

Reply
Posts: 11
Topic starter
(@pythonit)
Active Member
Joined: 9 years ago

This one im guessing, ill give it a go this evening.

<providers>
<remove name="MySqlSiteMapProvider" /> <add name="SolidCPSiteMapProvider" type="SolidCP.WebPortal.SolidCPSiteMapProvider, SolidCP.WebPortal" securityTrimmingEnabled="true" />
</providers>

Thanks Marco

Reply
1 Reply
Admin
(@m-tiggelaar)
Joined: 9 years ago

Noble Member
Posts: 1995

yup thats the one.
you just need it in the portal following my tests.
do note this applies to most asp.net sites though from what i saw others also started to include this by default recently.

The true solution lays with the mysql provider development but as it's been like this for more then a year i doubt they will fix that up.

Reply
Share: