[DiscordArchive] Hmm does Eluna module access database directly? Last time I was compiling it seemed like some lua-re
[DiscordArchive] Hmm does Eluna module access database directly? Last time I was compiling it seemed like some lua-re
Original source
Hmm does Eluna module access database directly? Last time I was compiling it seemed like some lua-related stuff was getting access errors when executing some DB stuff, I assume it was cos I got separate credentials for each DB in config. Couldn't get more info about that then though as was in rush, wonder if this is possible?
rektbyfaith
04-27-2022, 08:46 AM #1Archived author: Grandold • Posted: 2022-04-27T08:46:09.025000+00:00
Original source
Hmm does Eluna module access database directly? Last time I was compiling it seemed like some lua-related stuff was getting access errors when executing some DB stuff, I assume it was cos I got separate credentials for each DB in config. Couldn't get more info about that then though as was in rush, wonder if this is possible?
Original source
Actually found that from logs I think:
```
[1044] Access denied for user 'acore-characters'@'localhost' to database 'ac_eluna'
Unhandled MySQL errno 1044. Unexpected behaviour possible.
[1142] CREATE command denied to user 'acore-characters'@'localhost' for table 'carboncopy'
Unhandled MySQL errno 1142. Unexpected behaviour possible.
```
rektbyfaith
04-27-2022, 08:49 AM #2Archived author: Grandold • Posted: 2022-04-27T08:49:55.492000+00:00
Original source
Actually found that from logs I think:
```
[1044] Access denied for user 'acore-characters'@'localhost' to database 'ac_eluna'
Unhandled MySQL errno 1044. Unexpected behaviour possible.
[1142] CREATE command denied to user 'acore-characters'@'localhost' for table 'carboncopy'
Unhandled MySQL errno 1142. Unexpected behaviour possible.
```
Original source
So was just wondering if it's possible it's trying to connect to characters db with the world db credentials
rektbyfaith
04-27-2022, 08:51 AM #3Archived author: Grandold • Posted: 2022-04-27T08:51:01.923000+00:00
Original source
So was just wondering if it's possible it's trying to connect to characters db with the world db credentials
Original source
Hmm actually I think it's the carboncopy lua script that is trying to create a whole new _database_, is this correct? Shouldn't it just create new table? Would somehow need to define new login credentials for new database if it really is supposed to create a db too.
rektbyfaith
04-27-2022, 09:06 AM #4Archived author: Grandold • Posted: 2022-04-27T09:06:44.487000+00:00
Original source
Hmm actually I think it's the carboncopy lua script that is trying to create a whole new _database_, is this correct? Shouldn't it just create new table? Would somehow need to define new login credentials for new database if it really is supposed to create a db too.
Original source
> trying to create a whole new database, is this correct?
Yes, it uses a different database
rektbyfaith
04-27-2022, 09:21 AM #5Archived author: Roboto • Posted: 2022-04-27T09:21:11.536000+00:00
Original source
> trying to create a whole new database, is this correct?
Yes, it uses a different database
Original source
by default it uses `ac_eluna`, but you can change this to use your characters database instead.
![[Image: unknown.png?ex=690c68dd&is=690b175d&hm=3...9982043ab&]](https://cdn.discordapp.com/attachments/448835144564867094/968804355379691590/unknown.png?ex=690c68dd&is=690b175d&hm=3f8a90604fda67ab4e96379ddfda946e4be60c33d274621c43bacb49982043ab&)
rektbyfaith
04-27-2022, 09:22 AM #6Archived author: Roboto • Posted: 2022-04-27T09:22:38.012000+00:00
Original source
by default it uses `ac_eluna`, but you can change this to use your characters database instead.
Original source
or you can manually create a database called `ac_eluna` and add the same permissions to it as the characters db
rektbyfaith
04-27-2022, 09:23 AM #7Archived author: Roboto • Posted: 2022-04-27T09:23:07.004000+00:00
Original source
or you can manually create a database called `ac_eluna` and add the same permissions to it as the characters db
Original source
We usually use a different db for eluna scripts to keep things tidy
rektbyfaith
04-27-2022, 09:23 AM #8Archived author: Roboto • Posted: 2022-04-27T09:23:53.453000+00:00
Original source
We usually use a different db for eluna scripts to keep things tidy
Original source
Okay thanks, was just weirded out why it is trying to create new database while I haven't even set login credentials or permissions for such But ye seems to work even without the db/table, though ofc carboncopy tickets can't then be managed i guess (which is perfect for me, just using it to let ppl copy characters with no limit).
rektbyfaith
04-27-2022, 09:25 AM #9Archived author: Grandold • Posted: 2022-04-27T09:25:19.384000+00:00
Original source
Okay thanks, was just weirded out why it is trying to create new database while I haven't even set login credentials or permissions for such But ye seems to work even without the db/table, though ofc carboncopy tickets can't then be managed i guess (which is perfect for me, just using it to let ppl copy characters with no limit).
Original source
Glad to hear someone makes use of my code
rektbyfaith
04-27-2022, 09:34 AM #10Archived author: Honey • Posted: 2022-04-27T09:34:51.428000+00:00
Original source
Glad to hear someone makes use of my code
1 Guest(s)
1 Guest(s)