How to Install SSL Certificate on Apache? SSL stands for Secure Sockets Layer, the protocol which provides the encryption. It provides secure, encrypted communications between a website and an internet browser. and are typically installed on pages that require end-users to submit sensitive information over the internet like credit card details or passwords, used to secure our website and web app. 1. Install OpenSSL OpenSSL is a software library to be used in applications that need to secure communication over the internet. To install on Ubuntu/Debian run the following command. sudo apt-get update sudo apt-get install openssl 2. Generate Key and CSR CSR stands for Certificate Signing request, To generate server key and CSR file run the following command, replace example.com to your domain name on which you want to install SSL certificate. openssl genrsa -out example.com.key 2048 openssl req -new -sha256 -key example.com.key -out example.com.csr When you will run the above command it will ask your information like Country: IN State or Province: XYZ City or Locality: XYZ Organization Unit: XYZ Organization: XYZ Common Name: www.example.com Fill out your details and hit enter, In Country provide two digits of your country code(example India: IN, USA: US etc ) Download these two files (example.com.key and example.com.csr) and submit it to the certificate provider, then they will issue the certificate. The certificate should contains two file .crt and .ca-bundle or bundle.crt Put your certificate file, bundle file and key file in the directory /etc/ssl/certs/ SSLCertificateFile — Certificate file SSLCertificateKeyFile — Server key file SSLCertificateChainFile — bundle file 3. Configure Apache Web Server Create the virtual host in apache, edit the file and make the virtual host for your domain and include the domain name, port 443, certificate file path etc. sudo nano /etc/apache2/site-enabled/000-default.conf If you want to redirect all your traffic to https than make sure you are also adding redirect rule. The virtual host may look like. <VirtualHost *:443> ServerAdmin admin@example.com DocumentRoot /var/www/html ServerName example.com ServerAlias www.example.com SSLEngine on SSLCertificateFile /etc/ssl/certs/example.com.crt SSLCertificateKeyFile /etc/ssl/certs/example.com.key SSLCertificateChainFile /etc/ssl/certs/example_bundle.crt <Directory /var/www/html> Options FollowSymLinks AllowOverride All </Directory> </VirtualHost> #Redirect all http traffic to https <VirtualHost *:80> ServerName example.com ServerAlias www.example.com Redirect permanent / https://www.example.com </VirtualHost> 4. Enable SSL Mode and restart apache services sudo a2enmod ssl sudo service apache2 restart Open your website URL in web browser eg. example.com or www.example.com and you will see a green(Secure) lock before the URL.

how do i solve this error Cast to ObjectId failed for value "Robert Martin" (type string) at path "author" for model "Book""

Kelly

im trying to return the book count of each author and i cant seem to pass in any arguments in when when using find in mongoose because i get the error above. my code below.


const typeDefs = gql`
    type Author {
        name: String!
        born: Int
        bookCount: Int
        id: String!
    }
    type Book {
        title: String!
        published: Int!
        author: Author!
        genres: [String!]!
        id: ID!
    }
    type Query {
        bookCount: Int!
        authorCount: Int!
        allBooks(author: String, genre: String): [Book!]!
        allAuthors: [Author!]!
    }
    type Mutation {
        addBook(
            title: String!
            author: String!
            published: Int!
            genres: [String!]!
        ): Book
        editAuthor(name: String!, setBornTo: Int!): Author
    }
`;

const resolvers = {
    Query: {
        bookCount: async () => Book.collection.countDocuments(),
        authorCount: async () => Author.collection.countDocuments(),
        allBooks: async (root, args) => {
            // if (args.genre && args.author) {
            //  return await Book.find({ author: [args.author] });
            // }

            // if (args.author) {
            //  return await Book.find({
            //      author: args.author,
            //  });
            // }

            // if (args.genre) {
            //  return await Book.find({
            //      genres: { $in: [args.genre] },
            //  });
            // }

            return await Book.find({});
        },
        allAuthors: async () => await Author.find({}),
    },
    Author: {
        bookCount: async (root) => {
            const books = await Book.find({ author: root.name });
            return books.length;
        },
    },
    Mutation: {
        addBook: async (root, args) => {
            const author = await Author.findOne({ author: args.name }).exec();
            // const author = authors.find((author) => author.name === args.author);
            console.log(author);
            if (!author) {
                author = { name: args.author, id: uuid() };
                authors = authors.concat(author);
            }
            const newBook = { ...args, id: uuid() };
            books = books.concat(newBook);
            return newBook;
        },
        editAuthor: (root, args) => {
            const authorToUpdate = authors.find(
                (author) => author.name === args.name
            );
            if (!authorToUpdate) {
                return null;
            }
            const updatedAuthor = { ...authorToUpdate, born: args.setBornTo };
            authors = authors.map((author) =>
                author.name === args.name ? updatedAuthor : author
            );
            return updatedAuthor;
        },
    },
};

const server = new ApolloServer({
    typeDefs,
    resolvers,
});

server.listen().then(({ url }) => {
    console.log(`Server ready at ${url}`);
});

this part is suppose to return the book count but the error comes and anywhere else where i try to pass in any arguments in find

Author: {
        bookCount: async (root) => {
            const books = await Book.find({ author: root.name });
            return books.length;
        },
    },