change all environment to use mysql2 database and pending wierd partner index spec example