In dev mode, everything is working fine but in production mode, it is throwing an error I showed in the image. How and where to install mysql2. Can any senior guide me?

Is MySql2 in your dependencies? If so, you might need to add it to bundle.nodeModules

@Ross Coundon It is already in dependencies and it is working in dev mode. What else to do further?

Can you try adding to bundle.nodeModules?

@Ross Coundon I don't know where is bundle.nodeModules. Please mention it

You can set the bundle property on the function that uses it by setting it in the functionProps. Or you can set it for all using defaultFunctionProps at the app level like

app.setDefaultFunctionProps({
  bundle: {
    nodeModules: ['mysql2']
  }
});

Docs are here.

This time I got this error app.setDefaultFunctionProps({ runtime: "nodejs14.x", timeout: 20, bundle: { nodeModules: ['mysql2'] } });

Ok, no idea what that is. I’d be inclined to delete the .sst directory and re-run at this point

I dropped .sst and build it again. It is throwing as follows Preparing your SST app Synthesizing CDK Building function src/lambda.handler There was a problem installing nodeModules. Error: Command failed: npm install npm WARN dev-condofamily-api-Api-Lambda_GET_- No description npm WARN dev-condofamily-api-Api-Lambda_GET_- No repository field. npm WARN dev-condofamily-api-Api-Lambda_GET_- No license field.

Ok, it seems there’s something odd about how the mysql2 is being handled. Specifying it in the nodeModules array prevents SST bundling it and instead just installs it into node_modules. The fact that it breaks when you do that is really weird. Probably one for @thdxr when he wakes up

@Ross Coundon I appreciate your quick response and support. Thanks from the core of my heart.

Which version of sst are you using?

Hm I use mysql2 in this way

@Ross Coundon "version": "0.1.0",

SST?

yeah this is some weird npm issue I'm not sure. You've tried deleting .sst folder and node_modules?

Won’t hurt

ok

I think you have some kind of user access privileges issue on the file system

@Ross Coundon I have admin privileges. I deleted package-lock.json now node modules installed. Let me check bundle.nodeModule works now or not

Gotta love those 😬