MivaSQL to MySQL converter for MM5

[nixusr]

Re: MivaSQL to MySQL converter for MM5

The connection string may not be the issue anymore. After I made the change and tried to access the merchant storefront instead of the admin, I got a more descriptive message that states...
Description:
/lib/i686/libc.so.6: version `GLIBC_2.3' not found (required by /usr/local/mivavm/lib/databases/mysql.so)

So I will need to inspect the box for this required library file.

[brucejbrown]

Re: MivaSQL to MySQL converter for MM5

When the conversion completes, does it issue a message? When I ran it, it went through 29 steps, the last of which was converting basketoptions.dbf. All of them said OK.

I tried changing merchdb.dat. The instructions look pretty simple, but none of the variations I tried worked.

The instructions say to change the string to:
mysql|mysql_username@mysql_database|mysql_username |mysql_password|

(I'm not sure if the space between username and | is significant.)

So, let's say my database was called DB, username STORE and password STORE , I tried:
mysql|STORE@DB|STORE |STORE

When I tried to connect to the store, I got:

Error Code: MER-DBA-MYS-00001
Description: Unable to connect to database: Unknown MySQL server host 'DB' (1)
Other Information:

Obviously, the database is there otherwise the conversion program wouldn't have worked.

What am I missing?

Thanks,

Bruce

[ILoveHostasaurus]

Re: MivaSQL to MySQL converter for MM5

The instructions say to change the string to:
mysql|mysql_username@mysql_database|mysql_username |mysql_password|

(I'm not sure if the space between username and | is significant.)

So, let's say my database was called DB, username STORE and password STORE , I tried:
mysql|STORE@DB|STORE |STORE

When I tried to connect to the store, I got:

Error Code: MER-DBA-MYS-00001
Description: Unable to connect to database: Unknown MySQL server host 'DB' (1)
Other Information:

Obviously, the database is there otherwise the conversion program wouldn't have worked.

What am I missing?

Thanks,

Bruce

Get rid of the space, that should not be there, unless your username actually contains a space, which I don't think mysql allows. The other issue is that "DB", your format is wrong, should be:

mysql|mysql_database@mysql_server|mysql_username|m ysql_password|

So you need to udpate the database@server portion and drop the space form after the username.

[brucejbrown]

Re: MivaSQL to MySQL converter for MM5

I tried using the same values for database, username, and password as I had in the conversion code.

So, this time my string looked like:

mysql|[email protected]|STORE|STORE|

To keep the example simple, I'm using DB as the mysql database, and STORE is the username and password.

I got to the admin.mvc page without a problem. When I tried to log in, I got:
Runtime error in lib/db.mvc @ [0000014e:0000002a]: lib/dbprim/users.mv: Line 148: MvOPENVIEW: mysql_stmt_prepare: Table 'DB.Users' doesn't exist

Sorry. But I don't understand how to resolve this.

As I said in my prior post, the conversion ended at step 29, but didn't give any message saying it was done (nor did it give any error messages). So, did the conversion fail and is that the reason I'm having troubles logging in or am I missing something else?

Thanks,

Bruce

[ILoveHostasaurus]

Re: MivaSQL to MySQL converter for MM5

I tried using the same values for database, username, and password as I had in the conversion code.

So, this time my string looked like:

mysql|[email protected]|STORE|STORE|

To keep the example simple, I'm using DB as the mysql database, and STORE is the username and password.

I got to the admin.mvc page without a problem. When I tried to log in, I got:
Runtime error in lib/db.mvc @ [0000014e:0000002a]: lib/dbprim/users.mv: Line 148: MvOPENVIEW: mysql_stmt_prepare: Table 'DB.Users' doesn't exist

Sorry. But I don't understand how to resolve this.

As I said in my prior post, the conversion ended at step 29, but didn't give any message saying it was done (nor did it give any error messages). So, did the conversion fail and is that the reason I'm having troubles logging in or am I missing something else?

Thanks,

Bruce

Sounds like the conversion failed; the Users table is where all the logins to the admin side of the store are held, so if that table is missing, the conversion didn't create it like it should have. I'd probably wipe out the tables in DB and start it over again, see if it completes next time.

[brucejbrown]

Re: MivaSQL to MySQL converter for MM5

Yes, that was the problem. I deleted baskets, packed the store and re-ran the conversion utility. This time it went through 143 tables (instead of 29) and said "DONE!" when it completed.

Thanks for your help!

Bruce

[Gazungle]

Re: MivaSQL to MySQL converter for MM5

Would you have to re-install any plugins after doing this ?

[ILoveHostasaurus]

Re: MivaSQL to MySQL converter for MM5

Would you have to re-install any plugins after doing this ?

You don't.

[brucejbrown]

Re: MivaSQL to MySQL converter for MM5

I ran the MivaSQL to mySQL converter. It completed without any errors and said "done" at the end. I also changed the merchdb.dat file.

I wasn't able to log into admin using https, but was able to get in using http. The Main admin page showed that it was running mysql. It had this error:
Runtime error in lib/db.mvc @ [00000145:0000002a]: lib/dbprm/store.mv: Line 233: MvOPENVIEW: mysql_stmt_bind_results: Using unsupported buffer type: 246 (parameter 27).

I'm running Redhat 5. I tested the conversion on a slightly older version of the store on a server runnning Redhat Linux ES 4 and it worked there.

Any ideas on what's causing this error or how to troubleshoot it?

Thanks,

Bruce

[ILoveHostasaurus]

Re: MivaSQL to MySQL converter for MM5

I'm running Redhat 5. I tested the conversion on a slightly older version of the store on a server runnning Redhat Linux ES 4 and it worked there.

Any ideas on what's causing this error or how to troubleshoot it?

Thanks,

Bruce

RHEL 5 uses MySQL 5 which Merchant only theoretically runs on using the beta release version 2.0 MySQL connector but I think it actually doesn't run reliably with that connector so MySQL 4.1 is the only viable version at this point.

[d_host]

Re: MivaSQL to MySQL converter for MM5

EDIT: David beat me to it. Yes, RHEL 5 will not work for you if you use mySQL 5. With or without the new beta connector. It appears to be still a little too buggy for production use. Switch to RHEL4 with mySQL 4.1.2x or see if you can install that older version of mySQL on your RHEL5 system (I haven't tried that route so I don't have first hand experience whether this will work).

[James Harrell]

Re: MivaSQL to MySQL converter for MM5

Have you tried with the MySQL Beta connector v2.102 I released late last week? This should be stable on MySQL v5. Of course, still not advised for production use as it is BETA.

Regards,
James

[Gazungle]

Re: MivaSQL to MySQL converter for MM5

Where can we can download the latest version ?

[brucejbrown]

Re: MivaSQL to MySQL converter for MM5

We got changed back to mysql 4.1 but stayed on RHEL5. Everything seems to be working now. Just in the nick of time too. We converted on Saturday and we had our busiest day on Sunday. Thanks for your help.

[brucejbrown]

Re: MivaSQL to MySQL converter for MM5

Nope. We'll wait for something that's ready for production.